Reconciling CRM exports with bank deposits before board season

Every November, development directors across Gyeonggi call us with the same problem: the CRM says total giving was KRW 842 million, but finance reports KRW 819 million in deposits. The gap is rarely fraud. It is usually timing, definition, or duplicate records.

Start with a shared donor definition

Before comparing any numbers, sit with your finance lead and agree on what counts as a "gift" for reporting purposes. Pledges? Cash received only? In-kind donations? Employer matching that arrives months later? Write the definition in one paragraph and both teams sign off. This single step prevents most board-meeting arguments.

Match on transaction ID, not donor name

Korean donor names appear in multiple romanization formats in CRM systems. Match CRM transaction IDs to bank deposit reference numbers wherever possible. When IDs are missing — common with legacy paper pledge forms — match on amount, date (within a three-day window), and the last four digits of the donor's registered phone number if your CRM stores it.

Flag the three usual gap sources

Timing differences: Year-end gifts processed in CRM on December 31 but deposited on January 3. Track these in a "pending deposit" appendix rather than adjusting either system's totals.

Refunds and chargebacks: CRM may not automatically reverse a gift when a credit card chargeback occurs. Pull chargeback reports from your payment processor and cross-reference monthly.

Soft credits and tribute gifts: Honor/memorial gifts often create two CRM records (donor + honoree) but one bank deposit. Finance counts one transaction; CRM counts two. Document the mapping rule in your appendix.

Build a reconciliation worksheet before charting

We require clients to complete a simple three-column worksheet — CRM total, bank total, explained variance — before we begin chart production. Unexplained variance above 2% triggers a data preparation phase quoted separately. This protects both your board and our report accuracy.

When to ask for outside help

If unexplained variance persists after two reconciliation passes, or if your organization migrated CRM systems mid-year, external reconciliation typically takes three to five days and saves weeks of board-meeting explanation later.