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
| status | count | amount |
| flag | 2 | 1595 |
| ok | 4 | 1100 |
| review | 2 | 7670 |
| watch | 1 | 125 |
By finding
| code | count | amount |
| batch_total_mismatch | 1 | -10 |
| deposit_not_in_crm | 1 | 250 |
| gl_differs | 1 | -905 |
| in_transit | 1 | 125 |
| not_deposited | 1 | 1020 |
All rows (9)
| item | date | crm amount | deposit | deposit amount | gl amount | status | reasons |
| Batch B-102 | 2026-10-09 | 575 | D-2 | 565 | | flag | Batch B-102: gifts total 575, deposit D-2 on 2026-10-12 is 565 (difference -10). |
| Batch B-103 | 2026-10-14 | 1020 | | | | flag | Batch 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-4 | 2026-10-25 | | D-4 | 250 | | review | Deposit D-4 on 2026-10-25 for 250 (Mobile deposit) matches no gift or batch in the CRM. |
| Month 2026-10 | 2026-10 | 7420 | | | 6515 | review | 2026-10: the CRM has 7420 of gifts, the ledger has 6515 of contribution revenue (difference -905). |
| Gift G-1011 | 2026-10-29 | 125 | | | | watch | Gift 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-100 | 2026-09-24 | 200 | D-0 | 200 | | ok | |
| Batch B-101 | 2026-10-06 | 400 | D-1 | 400 | | ok | |
| Gift G-1010 | 2026-10-20 | 300 | D-3 | 300 | | ok | |
| Month 2026-09 | 2026-09 | 200 | | | 200 | ok | |
Limits
- Reads only the files you give it. It does not log in to a donor CRM, giving platform, payment processor, bank, payroll or accounting system, and changes nothing in them.
- Thresholds, rates, dates and policies are settings in your own file, with working defaults; check them against your own policies, funder agreements and current rules before you rely on them.
- Not legal, tax, audit or accounting advice. A person decides what to record, send, file or pay.
- Names, e-mails, phone numbers, street addresses and taxpayer ids of donors, members, volunteers, staff and vendors are masked in results returned to the AI model. The report and draft files written here keep the real values: keep them in a private folder.
Written by a Fairgive agent from your files. Nothing was sent or paid.