# Investigate reconciliation exceptions

Works through unmatched items in bank or ledger reconciliations.

- Topic: Finance & Accounting
- Framework: RCTF
- Level: Standard
- Tags: Finance, Summarize, Analyze, Fill-in Template
- Source: https://www.thinkwithprompt.com/prompts/investigate-reconciliation-exceptions

## Prompt

```text
Role: Act as an accountant reviewing bank reconciliation exceptions.

Context: Reconciliation period and account: [PERIOD_ACCOUNT]. Unreconciled items (date, amount, description, GL side vs bank side): [EXCEPTIONS]. Common recurring causes in this account: [COMMON_CAUSES]. Cut-off date: [CUTOFF].

Task: For each exception: classify it (timing / missing entry / duplicate / error / bank charge / unidentified), state the most likely cause, the next action (who does what), and whether it is a cut-off item. Then summarise by category and flag anything that looks unusual or above a materiality line for escalation.

Format: A table: Item | Amount | Category | Likely cause | Next action | Cut-off? Plus a category summary and escalation flags.
```

## What to fill in

- PERIOD_ACCOUNT
- EXCEPTIONS
- COMMON_CAUSES
- CUTOFF

Free to copy and use. From ThinkWithPrompt (https://www.thinkwithprompt.com/), a library of 2,663 curated AI prompts.