beginner·Finance & FP&A·45 minutes

Bank Reconciliation Exception Triage

Proposed matches with explicit logic, a categorised remainder (book / carry / investigate), and draft journals for fees — cutting manual matching time sharply.

⬡

Recommended modelGPT-5.5 Instant

Strong at spreadsheets and structured financial data

What you need to fill in

[account/period][paste][paste]

Tools used

ClaudeExcel

The prompt

"Help me clear my bank reconciliation exceptions faster. I will paste (A) unmatched bank statement lines and (B) unmatched cash ledger entries for [account/period]. Please: 1. Propose matches across the two lists (amount, date proximity, reference fragments, sums of multiple items to one) 2. For each proposed match, state the matching logic so I can verify 3. Group the remainder: bank fees to book, timing items to carry, and true investigations 4. Draft the journal entries for the fees and charges Bank lines: [paste] Ledger lines: [paste]"

Open in ChatGPT

Sample output

**Proposed matches (verify before accepting)** 1. Bank -12,450.00 (06-28, ref 'INV88*') ↔ ledger 12,450.00 INV-8812 — exact amount, ref fragment 2. Bank -3,300.00 ↔ ledger 1,100 + 2,200 (same payee, same day) — 2:1 split **Book now:** bank charges 214.50 → Dr 6810 Bank fees / Cr 1010 Cash **Carry:** 2 deposits in transit (06-30) **Investigate:** unknown incoming 5,000.00 'AUTOGIRO K.' — ask AR who invoiced this payer.

Try with these tools

claude chatgpt copilot

financebank-reconciliationtreasurymonth-end-close

More in Finance & FP&A

Headcount & Workforce Cost Planning Model

A driver-based headcount plan: FTE roster logic, fully-loaded cost, hiring ramp, and scenario toggles.

advanced

CAPEX Investment Appraisal Builder (NPV / IRR / Payback)

A complete capex appraisal: cash-flow layout, NPV/IRR/payback with formulas, and a decision memo.

intermediate

Gross Margin Bridge & Price-Volume-Mix Analysis

A period-over-period margin bridge decomposed into price, volume, mix, cost, and FX effects.

advanced