adminpack.pub About

Workflow · A working process

Donations to accounting

Get Stripe gifts into QuickBooks Online at gross, with fees, refunds and payouts reconciled and nothing recorded twice.

Jump to a section

Overview

Outcome
Every online gift appears in the ledger at its gross amount, processing fees and refunds are recorded as their own lines, and each Stripe payout matches a bank deposit to the cent with nothing recorded twice.
Who it is for
For any publisher that takes reader money through Stripe, including donations, memberships and subscriptions. The mapping and reconciliation work for for-profit publishers too; only the Stripe nonprofit pricing variation depends on nonprofit status. Tool and tax references are US-centered.
Before you start
  • A Stripe account that receives your online payments, whether directly or through a donation platform.
  • A ledger such as QuickBooks Online with the bank account connected.
  • A written decision on which system is the record for donors (the donor database or CRM) and which is the record for money (the ledger).

Skip to the workflow steps

Why the bank deposit is not your revenue

Stripe deposits a net amount: the gifts it collected, minus its fees, minus any refunds paid out of that batch. If you record the deposit as income, the ledger understates what readers gave and hides what processing costs. Recording gross income, fees and refunds separately gives you an honest donation total, a real processing-cost line and figures that match the donor database.

Who owns which record

Three kinds of system touch an online gift. Each should own one thing:

  • The donation form or platform (for example Fundraise Up, or a Stripe-hosted form) owns the donor-facing experience and usually the donor record.
  • Stripe owns the money movement: charges, fees, refunds, disputes and payouts.
  • The ledger (QuickBooks Online here) owns the financial record.

A sync tool such as Acodei is a bridge between Stripe and the ledger, not a fourth record. Acodei bills by synced event, and sales, refunds and payouts each count, so estimate cost from your real event mix, not just the number of gifts.

Why one clearing account

Sales, fees and refunds all post through a single Stripe clearing account, and each payout moves what is left to the bank. When every payout has landed, the account is zero. Anything left is either a payout in transit or a mistake worth finding. That one number is the quickest health check you have.

Where double counting comes from

Most donation reconciliation problems are the same deposit recorded twice. The usual causes:

  • Bank feed plus sync tool. The sync tool posts the payout as a transfer into the bank. The bank feed then shows the same deposit, and someone clicks “Add” instead of “Match”. Fix: Stripe deposits are always matched, never added.
  • Donation platform plus Stripe sync. If the platform’s own accounting integration and a Stripe sync are both on, every gift arrives twice. Fix: keep the Stripe sync, because Stripe sees fees, refunds and payouts, and turn the other off.
  • Hand entries from the donor database. Someone enters a month of online gifts from a CRM report “to be safe.” Fix: hand entries are only for gifts that did not go through Stripe.

A quick test: ledger donation income should be close to Stripe gross receipts plus offline gifts. If it is close to double, look for one of the three above. Refunds and disputes are where mappings break, so test them again after changing any sync setting.

Connecting to the finance workflow

This is the revenue side of the finance workflow’s monthly close. The Stripe clearing account is reconciled with the bank and card accounts, and the reviewer sees donation income, fees and refunds as separate lines in budget-versus-actual.

The workflow

  1. Map where money and records travel

    Responsible: Finance lead

    Draw the path for one gift: donation form, Stripe charge, Stripe fee, Stripe payout, bank deposit, ledger entries. Note every system that creates a record along the way, including any donation platform, CRM, bank feed and sync tool.

    Inputs
    List of payment forms and platforms; Bank feed settings
    Outputs
    One-page flow diagram; List of systems that write to the ledger
    Resources
    The small-publisher finance workflow
  2. Choose one system to write each event

    Responsible: Finance lead

    Decide which single path records each Stripe event in the ledger. If a sync tool posts payouts, the bank feed must match to those entries rather than add new ones. If the donation platform also exports to the ledger, turn that export off.

    Inputs
    List of systems that write to the ledger
    Outputs
    Written import rules
    Resources
    Acodei, QuickBooks Online
  3. Configure the sync

    Responsible: Bookkeeper

    Map Stripe sales to income accounts, Stripe fees to a processing-fee expense account, refunds to a refunds account that reduces revenue (contra-revenue), and payouts to a transfer from a Stripe clearing account to the bank account.

    Inputs
    Chart of accounts; Sync tool settings
    Outputs
    Account mapping; Stripe clearing account in the ledger
    Resources
    Acodei, QuickBooks Online
  4. Test a gift, a refund and a payout

    Responsible: Bookkeeper

    Before relying on the sync, follow one real payout through: a successful gift, its fee, a refund and the resulting payout. Confirm each landed once, in the right account, and that the payout matches the bank deposit.

    Inputs
    One recent payout
    Outputs
    Tested mapping; Notes on anything that needed adjustment
    Resources
    Acodei
  5. Reconcile each payout

    Responsible: Bookkeeper

    For every payout in the month, confirm gross receipts minus fees minus refunds equals the net payout, and that the net payout equals one bank deposit. The Stripe clearing account should return to zero, or to the balance of payouts still in transit.

    Inputs
    Stripe payout reports; Bank statement
    Outputs
    Payout reconciliation; Clearing account balance explained
    Resources
    QuickBooks Online
  6. Match donor records to the ledgerOptional

    Responsible: Development or audience lead, with the bookkeeper

    Compare the month's gift total in the donor database with gross donation income in the ledger. Differences usually come from refunds, timing at month-end or gifts entered by hand.

    Inputs
    Donor database gift report; Ledger income report
    Outputs
    Explained difference or adjustment list

Variations

Donations through a donation platform

When: You use a donation-form platform such as Fundraise Up that processes through your Stripe account.

Treat the platform as the donor-facing form and donor record, and Stripe as the record of money movement. Post to the ledger from Stripe only. Check whether the platform's own accounting export or integration is switched on, and turn it off if a Stripe sync tool is also posting.

See: Acodei

Stripe nonprofit pricing

When: You are a registered nonprofit and most of your Stripe volume is tax-deductible donations.

Stripe's nonprofit pricing is conditional. It depends on region and on the share of your Stripe volume that is tax-deductible donations; memberships, ticket sales and similar payments do not count. A publisher with large membership or subscription revenue may not qualify. Check the current rule before you plan around the rate.

See: Stripe nonprofit processing discount

Small volume, no sync tool

When: You have a handful of payouts a month and want to avoid another subscription.

Record each payout by hand as a journal entry: gross income, fee expense and refunds, netting to the deposit, using the Stripe payout report. Then match the bank-feed deposit to that entry. This is slower but uses the same accounts and the same reconciliation.

See: QuickBooks Online

Exceptions and decisions

  • A refund larger than the payout it falls in: Stripe may draw the difference from your bank account. Record the withdrawal against the Stripe clearing account, not as a new expense.
  • A disputed charge (chargeback): record the reversal and any dispute fee when Stripe deducts them, and keep the evidence with the reconciliation.
  • A payout initiated on the last day of the month that arrives in the bank the next month: leave it in the clearing account and list it as in transit.
  • A gift that bypassed Stripe (check or bank transfer): record it from the deposit and enter it in the donor database by hand; it will not appear in the sync.

Harbor Street Review payout reconciliation

Fictional example. Names and figures are invented for illustration.

An invented reader-funded publisher receives three Stripe payouts in October. A reader who gave in early October is refunded later in the month, so the refund comes out of the third payout. Fees are round, invented figures for illustration and are not Stripe's rates.

October payouts, fictional figures (US dollars)
Payout dateGross receiptsProcessing feesRefundsNet payoutBank depositDifference
October 32,000.0070.000.001,930.001,930.000.00
October 103,500.00120.000.003,380.003,380.000.00
October 171,500.0050.00100.001,350.001,350.000.00
Total7,000.00240.00100.006,660.006,660.000.00
  • Check: 7,000.00 − 240.00 − 100.00 = 6,660.00, and 1,930.00 + 3,380.00 + 1,350.00 = 6,660.00.
  • The 100.00 refund relates to a gift paid out on October 3 but is deducted from the October 17 payout. Record it in October 17's payout, not by editing the earlier one.
  • In this example the original fee on the refunded gift is not returned, so it stays in processing-fee expense.
  • The ledger shows 7,000.00 of gift income, 240.00 of fee expense and 100.00 of refunds, not 6,660.00 of income.

Completion checklist

  • Every payout in the month matches exactly one bank deposit.
  • For each payout, gross receipts minus fees minus refunds equals the net payout.
  • The Stripe clearing account balance equals payouts still in transit, and nothing else.
  • No deposit appears twice in the ledger: the bank feed matched to sync entries rather than adding new income.
  • Donor database totals and ledger donation income agree, or the difference is explained.

Sources

  1. Acodei pricing, Acodei. Checked October 14, 2026. Supports: Acodei bills each Stripe event it syncs to QuickBooks; every sale, refund, payout, invoice and invoice payment counts as one. Failed and incomplete payments are not billable.
  2. Fee discount for nonprofit organizations, Stripe. Checked October 14, 2026. Supports: Stripe's nonprofit fee discount requires registered nonprofit status, an eligible region, and at least 80% of Stripe payment volume from tax-deductible donations. Membership fees, tuition, ticket sales, registration fees and auction payments do not count toward the donation-volume threshold.

By Jonathan Keen. Content updated October 14, 2026.

Disclosure: No commercial relationship: AdminPack receives nothing from the companies named on this page. Links are ordinary links. See the editorial policy.

Something out of date? Suggest a correction. Know a tool or program I should cover? Suggest a tool or program.