Nonprofit Donation Reconciliation Template
Three documents and three sheets that bridge one month's giving across the processor, the CRM and the bank until both residuals read zero.
Free download · No account needed
Every reconciliation guide starts the same way. Export the processor report, export the CRM gifts, compare the totals, investigate the difference. It works until you try it, because the three systems are not reporting the same thing. The processor reports what donors authorised. The bank reports what settled after fees, on the day it landed. The CRM reports what somebody keyed. Three correct answers to three different questions, and subtracting two of them produces a number with no meaning.
So this pack does not chase a match. It builds two signed bridges and drives each residual to zero. The first walks the bank's deposits back to the processor's charges, carrying fees, refunds, disputes and the two in-transit ends almost nobody carries. The second walks those charges to the CRM's gift rows. Every term is a countable set of transactions you can click into rather than a line labelled timing with nothing behind it, and the whole thing is deposit-first because one bank line is a batch and not a gift.
In the worked example a December file reports $86,686.40 at the processor, $70,788.41 at the bank and $90,615.40 in the CRM, on a row count that matches the charge count exactly. Both bridges close to the cent. What falls out includes four donors who gave $197.05 and hold no gift record, so no acknowledgment and no place in next year's segmentation, plus $2,071.34 of fees that belong in fundraising expense rather than netted away against revenue.
What is in the pack
Three-way Reconciliation
One block per bank line, decomposed into the transactions that settled in it, with a residual column that has to read zero.
Both in-transit terms
Charges created in the period that settle after it, and prior-period charges that settled inside it. The two terms nobody carries.
Exception Register
Every difference between the CRM and the processor, typed into six categories, priced, and assigned to a named owner with a date.
Fee Analysis
Effective rate by gift size band, so a small recurring gift's real price is visible instead of averaged into one blended number.
Two Bridges Method Note
A full December close worked end to end, with three conflicting totals, both bridges closing, and the two reporting errors it avoids.
Discrepancy Resolution Note
Six categories a gift file actually produces, each with a signature to recognise it, a cause, a fix, and who has to act.
How it works
- 1
Send the three files
Itemised processor exports rather than summaries, the CRM gift export as recorded, and the bank statement at deposit-line level. Row counts checked against stated totals first.
- 2
Write down the semantics
Which date each system calls the gift date, whether its amounts are gross or net, and what it does with a donor-covered fee. Every later difference is an instance of one of these.
- 3
Decompose the deposits
Deposit-first, one block per bank line, charges and fees and reversals until the residual reads zero to the cent. A line that will not close becomes an exception, never a rounding difference.
- 4
Bridge, then work the leftovers
Both bridges to zero, then the exception list in order of what expires first. The unacknowledged donor outranks the larger accounting error every time, including on the board's own report. A gift keyed against the wrong one of two records reconciles and still lands nowhere useful. A major gift that closed after months of cultivation still has to clear this same bridge before the portfolio that tracked it can mark the ask closed.
Frequently asked questions
Why not just compare the CRM total to the bank total?
Because that comparison cannot find the gift nobody recorded. The money arrived and the deposit tied, so the bank is happy. In the worked example the CRM's total is $3,929.00 higher than the processor's, so a variance check points the wrong way while four donors sit unrecorded and unthanked.
What are the in-transit terms and why do they matter?
Charges created before the period end settle after it, and the prior period's charges settle inside it. Here that is $15,665.22 closing and $3,625.32 opening, the two largest terms after fees. Carrying neither understates December revenue by $12,039.90 on timing alone.
Which date is the gift date?
The charge date, not the deposit date. A contribution charged to a credit card is deductible in the year the charge is made, so the receipt keys to that. The general ledger and the bank reconciliation key to the payout date, which is why the sheet carries all three.
Why can I not match a gift to a bank deposit?
A deposit is a settlement batch. The largest December line here holds 35 charges created across three days plus a dispute reversing a charge deposited two weeks earlier. The processor's own payout reconciliation report groups the batch by category, which is the shape to reconcile against.
Should fees be netted against the gift?
No. Record contribution revenue at gross and the fee as fundraising expense. Netting leaves both figures $2,071.34 light with net assets unaffected, which is why it survives for years, and the fundraising efficiency ratio computed from it is wrong in the flattering direction.
Our donors can cover the processing fee. What do we record?
Either answer is defensible, and not knowing which one your systems implement is not. In the worked example 98 gifts read $15,680.00 in the CRM and $16,061.40 at the processor. That $381.40 is the receipt amount and the fundraising expense, and it recurs every month until somebody decides.
Does this post the journal entries?
No. It produces the figures an entry needs and names them: revenue at gross, fees as fundraising expense, gifts in transit at the period end, cash per the bank. Your finance staff or accountant posts and reviews, and the annual totals feed the Form 990.
Find the gifts your CRM never recorded
Send the processor exports, the CRM gift file and the bank statement. The first thing back is the list of charges with no gift record behind them.
Reconcile my month