Fictional sample report from Fair Agents, written by the check on made-up files. Every person, business and number is invented. Names of real systems and marketplaces only show which export the made-up file imitates. Back to all samples

Gift and deposit reconciliation

10 cash gift(s) for 2,620.00 and 5 deposit(s) for 1,715.00: not deposited 1,020.00, deposits short or over 10.00, deposits with no gift 250.00, in transit 125.00, ledger gap 905.00.

By status

statuscountamount
flag21595
ok41100
review27670
watch1125

By finding

codecountamount
batch_total_mismatch1-10
deposit_not_in_crm1250
gl_differs1-905
in_transit1125
not_deposited11020

All rows (9)

itemdatecrm amountdepositdeposit amountgl amountstatusreasons
Batch B-1022026-10-09575D-2565flagBatch B-102: gifts total 575, deposit D-2 on 2026-10-12 is 565 (difference -10).
Batch B-1032026-10-141020flagBatch B-103 (1020, gifts G-1006, G-1007, latest 2026-10-14) matches no deposit by batch or by amount within 5 days.
Deposit D-42026-10-25D-4250reviewDeposit D-4 on 2026-10-25 for 250 (Mobile deposit) matches no gift or batch in the CRM.
Month 2026-102026-1074206515review2026-10: the CRM has 7420 of gifts, the ledger has 6515 of contribution revenue (difference -905).
Gift G-10112026-10-29125watchGift G-1011 (125, 2026-10-29) is newer than the deposit window before the last deposit in the file (2026-10-25); it may still be on its way.
Batch B-1002026-09-24200D-0200ok
Batch B-1012026-10-06400D-1400ok
Gift G-10102026-10-20300D-3300ok
Month 2026-092026-09200200ok

Limits

Written by a Fairgive agent from your files. Nothing was sent or paid.