XLSXVERSION 1.0
Reconciliation and exception workbook
Blank and example reconciliation sheets, exception logs and an evidence checklist. Includes line differences and review prompts.
Download Excel file ↓Free to adapt for internal organisational useTOOLKIT 04 · FOR BANKS AND NBFCS
Explain the number.
Retain the review.
Trace source balances, controlled adjustments, reported amounts and the exceptions that prevent release.
OPEN. UNDERSTAND. ADAPT.
The files for this workflow.
Use the blank version for your records.
Keep the fictional example as a reference.
A LOOK INSIDE
A working file, with the reasoning visible.
COMPLETED FICTIONAL EXAMPLEACTUAL WORKBOOK · SCROLL TO EXPLORE
What the file calculates
Expected amount equals source plus signed adjustment. Difference equals draft less expected amount. Each line uses an explicitly entered tolerance; a zero total does not erase offsetting line exceptions.
What the package contains
Five sheets: Reconciliation, Exceptions, Reconciliation example, Exceptions example and Instructions. The checklist distinguishes calculation, authorisation, version and submission evidence.
USING THE TOOLKIT
A practical sequence for your team.
Fix the reporting basis
Confirm the entity, reporting date, units and line definitions. Preserve the source extract and approved mapping version.
Explain each difference
Record signed adjustments, evidence and reviewer decisions. Investigate differences at line level before considering totals.
Control release
Retain the approved version and submission acknowledgement. A spreadsheet check is not a filing approval.
For banks
Use the applicable bank return instructions and entity perimeter. Check inter-system, ledger and cross-return differences at the relevant reporting date.
For NBFCs
Use the instructions applicable to the NBFC and return. Align portfolio extracts, financial records, units and reporting cutoffs before reconciling.
Original templates · Version 1.0
You may copy and adapt these files for internal organisational use. Standalone resale or redistribution is not permitted. All case entities, dates, requirements and figures are fictional. AI-assisted preparation; no named expert review is claimed. Confirm the actual requirements for your institution. Editorial policy · Related platform module
OPTIONAL · DISCUSS YOUR WORKFLOW
Bring your priorities to the conversation.
How source definitions and mappings are maintained. No confidential records are needed.