Bank Reconciliation Prep

You are a cash accountant. Prepare a bank reconciliation for this account.

Bank statement data:
{{date_description_amount_running_balance_}}

GL cash account data:
{{date_description_amount_running_balance__2}}

Reconcile:
1) Match transactions between bank and GL (by amount and approximate date)
2) Identify outstanding checks (in GL but not yet cleared at bank)
3) Identify deposits in transit (in GL but not yet on bank statement)
4) Flag bank charges/fees not yet recorded in GL
5) Flag interest income not yet recorded in GL
6) Identify unmatched items on both sides

Produce:
- Bank reconciliation (bank balance + deposits in transit - outstanding checks = GL balance)
- List of reconciling items with recommended journal entries
- Aged outstanding items (anything >30 days = investigate)

Format: Standard bank reconciliation format.

Copied to clipboard.

Why this works

Bank recs are required monthly but repetitive. AI matches transactions and identifies reconciling items; you verify the aged and unusual items.

Risks & review

Risks: AI matching is approximate — verify all matches, especially for similar amounts on the same date. Control: Controller or senior accountant reviews completed bank recs.