Reconciliation

GrantKeeper's current reconciliation is deterministic and matching-based. It is not just asking AI to guess. It compares amount, date, vendor similarity, and references where available.

Table Reconciliation

Use table reconciliation when a bank statement should match one Table.

1. Open the Table.
2. Open Bank Statement Reconciliation.
3. Select a CSV bank statement file.
4. Submit.
5. Review matched entries.
6. Review discrepancies.
7. Download the reconciliation CSV if needed.

The reconciliation output separates:

• matched/aligned entries,
• discrepancies missing in the Table,
• discrepancies missing in the bank statement.

Master Reconciliation

Use Master reconciliation when a bank statement should match entries across multiple Tables.

1. Open Master Table.
2. Select Reconciliation.
3. Choose the date range or month.
4. Upload a CSV bank statement file.
5. Submit.
6. Review matches and discrepancies.
7. Use history to view previous reconciliations.
8. Download reconciliation output if needed.

How to Read Discrepancies

Common discrepancy types:

• Bank transaction has no matching Table entry.
• Table entry has no matching bank statement row.
• Refund or money-in behavior needs review.
• Vendor names differ enough to reduce confidence.
• Date or amount differs.

Use discrepancies as a checklist. They point to things to review; they do not automatically prove an error.