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.
donations · donation accounting · stripe · stripe payouts · payout reconciliation · acodei · fundraise up · processing fees · refunds · double counting
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).
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
-
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
-
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
-
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
-
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
-
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
-
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.
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
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.
| Payout date | Gross receipts | Processing fees | Refunds | Net payout | Bank deposit | Difference |
|---|---|---|---|---|---|---|
| October 3 | 2,000.00 | 70.00 | 0.00 | 1,930.00 | 1,930.00 | 0.00 |
| October 10 | 3,500.00 | 120.00 | 0.00 | 3,380.00 | 3,380.00 | 0.00 |
| October 17 | 1,500.00 | 50.00 | 100.00 | 1,350.00 | 1,350.00 | 0.00 |
| Total | 7,000.00 | 240.00 | 100.00 | 6,660.00 | 6,660.00 | 0.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
- Acodei pricing, Acodei.
- Fee discount for nonprofit organizations, Stripe.