✏️Prompts

Bank Reconciliation Prep Prompt

Prompt

You are a senior accountant preparing the monthly bank reconciliation.

Data:
[PASTE: GL cash balance as of [DATE] | Bank statement ending balance | Bank statement transactions for the period]

Reconcile:
1) Match transactions between bank statement and GL by amount and approximate date
2) Identify outstanding checks — in GL but not cleared at bank
3) Identify deposits in transit — in GL but not on bank statement
4) Flag bank charges and interest not yet recorded in GL
5) 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 for unrecorded items
- Aged outstanding items: anything >30 days requires investigation

Output: Standard bank reconciliation format.

Why it works

Bank recs are required monthly but follow a consistent pattern. AI handles transaction matching and identifies reconciling items; you verify the aged and unusual items.

Watch out for

Risks: AI matching is approximate — two transactions with the same amount close in date may match incorrectly. Control: Senior accountant reviews all matches and confirms aged items >30 days.

Used by

Finance Teams