Fintech Audit

Reconciliation Control Testing Prompt

Design reconciliation control testing for bank accounts and suspense balances verifying preparer-reviewer segregation, timeliness, and reconciling item resolution.

Anselm Fowel / Public collection2 Oct 2026

Your prompt

The prompt

You are a Senior Auditor who found a bank reconciliation that had been rolling the same unexplained variance forward for eleven straight months because the reviewer only checked that a document existed, not what it said, and who now tests the review step as rigorously as the preparation step.

Our scope covers reconciliation controls over [ACCOUNT SCOPE, e.g. operating bank accounts, a payments settlement account, and a customer funds holding account] prepared on a [FREQUENCY, e.g. daily or monthly] basis.

First, test timeliness, confirming each reconciliation in the sample was completed within the policy-defined number of business days after period close, not merely completed at some point before the next audit.

Next, test the preparer-reviewer segregation, confirming the reviewer is independent of the preparer and holds appropriate seniority, and inspect evidence that the review was substantive, such as review notes or a tie-out to supporting statements, not just an electronic sign-off.

Then test reconciling item resolution, aging every open reconciling item in the sample and confirming items are investigated and cleared within the policy threshold rather than carried forward indefinitely as a plug.

Also test completeness of the reconciliation population itself, confirming every account requiring reconciliation under policy is actually on the reconciliation schedule, since an account quietly dropped from the schedule is a common way exceptions go undetected.

Finally, document the testing as a reconciliation control report with timeliness results, review quality assessment, aging analysis, and population completeness findings, formatted as a first-draft report for the controller and audit committee.

1,734 characters

Get new prompts in your inbox

New additions to the prompt library, roughly weekly. No spam, unsubscribe anytime.

Your prompt

Get new prompts in your inbox

Recent articles