Header
Includes company name, department, reconciliation ID, report date, period covered, preparer name, and approver name. Use consistent naming conventions to link to general ledger and bank statement references for auditability.
Use this template to standardize month-end procedures, accelerate close cycles, and create a clear audit trail for internal and external reviewers. It reduces reconciliation time and supports accurate financial reporting and compliance with tax and regulatory obligations.
Common users include accounting staff, controllers, internal auditors, and finance managers responsible for month-end close and audit preparation.
External accountants and auditors rely on completed reconciliations during reviews, tax filings, and financial statement audits.
Includes company name, department, reconciliation ID, report date, period covered, preparer name, and approver name. Use consistent naming conventions to link to general ledger and bank statement references for auditability.
Record account number, ledger code, cost center, and reporting currency. Include links or references to source systems and the bank statement file name to simplify verification during reviews.
Enter beginning balance, total debits, total credits, and ending balance per ledger. Reconcile these to bank or subledger totals and flag any timing differences or outstanding items for follow-up.
Document outstanding checks, deposits in transit, bank fees, interest, and corrective journal entries. For each adjustment, cite source document, date, amount, and preparer who authorized the correction.
Explain unexplained variances larger than the materiality threshold. Include root-cause notes, expected date of resolution, accounting impact, and any required audit or tax disclosures follow-up.
Provide preparer signature, preparer printed name, date, and approver signature with date. Consider an electronic signature and audit trail to capture IP, timestamp, and reviewer comments for compliance.
| Template Field Name | Configuration Value | Format | Auto-sum numeric columns |
|---|---|
| Reconciliation Date Field MM/DD/YYYY Required | MM/DD/YYYY | Date validator enabled for close schedule |
| Account Number Field include leading zeros | Account code | Exact match to GL |
| Amount Fields two decimals required | Currency | Two-decimal numeric format enforced |
| Variance Notes mandatory text explanation | Notes | Plain text with audit comments |
Ensure your platform supports secure storage, role-based access, audit trails, and the file formats used by accounting systems.
Typically within 7 business days after month end.
Include reconciliations for intercompany and consolidated accounts.
Provide reconciliations within 10 business days upon request.
Finalize all reconciliations before external audit fieldwork.
Retain reconciliations to support tax filings as needed.
The finance team standardized templates across entities to reduce manual matching.
BIS integrated reconciliations with their ERP for automated balances.