Reconcile Donation Ledger with Payment Processor

Updated 14 November 2026 · Standard formula, shown below

This guide walks you through matching every donation recorded in your ledger against the transactions reported by your payment processor (like Stripe, PayPal, or Square). By the end, you’ll have a clear list of discrepancies—missing donations, extra charges, or mismatched amounts—and a verified total that ties your books to your bank deposits.

What You’ll Need

Your donation ledger (spreadsheet, accounting software, or CRM) with date, donor name, amount, and payment method for each gift.
Access to your payment processor’s dashboard or exported transaction report (CSV or Excel).
A copy of your bank statement for the same period (to confirm deposits).
A spreadsheet tool (Excel, Google Sheets) or accounting software for sorting and comparing.
Your processor’s fee schedule (to understand processing fees and payout timing).

Step-by-Step

Define the reconciliation period. Choose a specific date range (e.g., the last month, quarter, or fiscal year). Be consistent—use the same start and end dates for your ledger, processor report, and bank statement.
Export your processor’s transaction report. Log into your payment processor’s dashboard, navigate to the transactions or payouts section, and export a report for your chosen period. Include columns: transaction ID, date, gross amount, fees, net amount, and status (e.g., completed, refunded, pending).
Pull your ledger entries. Export or view your donation ledger for the same period. Ensure each entry has at least: date, donor name (or anonymous), amount, and payment method. If you use a CRM like Salesforce or Bloomerang, export with those fields.
Normalize the data. In a spreadsheet, create two tabs: one for processor data, one for ledger data. Clean both: remove test transactions, format dates consistently (YYYY-MM-DD), and convert all amounts to a single currency (e.g., USD). For processor data, note that the “gross amount” is what the donor paid; the “net amount” is what you receive after fees.
Match by transaction ID or reference. If your ledger stores a payment processor transaction ID (e.g., from a webhook or API), use that as the primary key. Use VLOOKUP or INDEX/MATCH in Excel/Sheets to bring the processor’s gross amount and net amount into your ledger tab. Flag any ledger row without a matching ID.
Match by amount and date when no ID exists. For entries without a transaction ID, sort both lists by date and amount. Manually or with a formula (e.g., using COUNTIFS), identify ledger entries that have a corresponding processor transaction with the same date and gross amount. Mark them as matched.
Investigate unmatched ledger entries. For each ledger donation that has no match in the processor report, check: Did the donor use a different payment method (e.g., check) that isn’t in the processor file? Was the donation recorded twice? Was it refunded or charged back? Note the reason and adjust your ledger if needed.
Investigate unmatched processor transactions. For each processor transaction without a ledger entry, check: Is it a fee, refund, or payout adjustment? Is it a donation that was never recorded? Did a donor use a giving form that bypassed your CRM? Create a ledger entry for legitimate donations, or categorize fees separately.
Reconcile fees and net amounts. Sum the processor’s fees for the period. Compare this to any fee expense account in your ledger. Also, sum the net amounts from the processor—this should match the total deposits into your bank account (minus any pending payouts). If not, check payout timing: some processors batch deposits daily or weekly.
Create a reconciliation report. In your spreadsheet, list: total gross donations per processor, total gross donations per ledger, total fees, total net deposits, and a list of all discrepancies with explanations. Save this as a permanent record.
Adjust your ledger. Make necessary journal entries: add missing donations, correct amounts, record fees as expenses, and note refunds. After adjustments, re-run the totals to ensure they match the processor’s net and your bank deposits.
Document and repeat. Note the date of reconciliation and any recurring issues (e.g., recurring donations not syncing). Set a monthly reminder to repeat this process.

Common Mistakes

Mismatched date fields: Your ledger might record the donation date, while the processor records the settlement date. Always compare using the same date type.
Ignoring processor fees: Forgetting to account for processing fees will make your ledger totals higher than your bank deposits. Always separate gross and net.
Double-counting refunds: If a donor is refunded, the processor shows a negative transaction. Ensure your ledger also has a negative entry or a refund flag; otherwise, you’ll overstate donations.
Mixing currencies: If you accept international donations, processor reports may show the donor’s currency. Convert everything to your base currency using the processor’s exchange rate or a consistent daily rate.
Not checking pending payouts: Transactions that are “pending” in the processor haven’t hit your bank yet. Exclude them from the bank reconciliation but include them in the gross donation total.

Tips

Use a dedicated reconciliation spreadsheet template. Create columns for: date, donor, ledger amount, processor gross, processor net, transaction ID, status, and notes. Reuse it monthly.
Automate where possible. If your payment processor integrates with your accounting software (e.g., QuickBooks, Xero), enable automatic syncing to reduce manual entry.
Reconcile monthly, not yearly. Monthly reconciliation catches issues early and makes the task much smaller.
Keep a separate ledger account for processing fees. This makes it easy to see if fees are being recorded correctly.
Use the processor’s payout report as the final authority for bank deposits. It shows exactly what was deposited and when.

Troubleshooting

Totals don’t match after adjustments. Re-check for pending transactions, refunds, and fees. Also verify that you’re comparing the same date range—if your processor report uses UTC and your ledger uses local time, a donation near midnight could fall in different days.

Can’t find a transaction ID in the ledger. Some donation platforms (like Facebook Fundraisers) don’t pass transaction IDs. In that case, match by donor name and amount, and note the lack of ID in your report.

Processor report shows a chargeback. A chargeback reverses a donation. Record it as a negative donation and a fee (the chargeback fee) in your ledger. If the donor disputes, you may need to provide evidence.

Bank deposits don’t match processor net. Check if the processor holds reserves or has a rolling payout schedule (e.g., 2-day delays). Compare the bank statement date range to the payout date range, not the transaction date.

Duplicate ledger entries for the same donation. This often happens when a donor uses a giving form that creates a record in both your CRM and your payment gateway. Merge the entries and keep one.

Frequently Asked Questions

Q: How often should I reconcile donations?
A: Monthly is standard. If you have high volume, consider weekly to catch issues faster.

Q: What if a donor gives via check and credit card?
A: Only credit card transactions will appear in the processor report. Checks should be reconciled separately with your bank statement. Your ledger should show both methods.

Q: Should I include pending transactions in my reconciliation?
A: For the gross donation total, yes. For bank deposit matching, no—only include settled transactions. Note pending amounts separately.

Q: How do I handle processing fees in my ledger?
A: Record fees as an expense (e.g., “Payment Processing Fees”) and record the net amount as the actual donation revenue, or record gross revenue and fees separately. Consistency is key.

Q: What if a donor cancels a recurring donation?
A: The processor will show a cancellation, but no transaction. Your ledger should be updated to stop future entries. Review your recurring donation list against the processor’s active subscriptions.

Q: Can I use accounting software to automate this?
A: Yes, tools like QuickBooks or Xero can sync with major processors. But you still need to review discrepancies manually—automation doesn’t catch everything.

Method: the standard formula for this calculation, rounded as each result states. See how the calculators work or report an error.