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