Balance Sheet Account Reconciliation Template

Account Reconciliation: [Entity] [GL account] [Period end]

Balance sheet account reconciliation with preparer and reviewer evidence: account header and risk tier, balance per general ledger against an independent source, reconciling items with age and owner, unexplained difference against a threshold, roll-forward of activity, evidence index, ageing and write-off decisions, preparer certification, reviewer checklist and escalation. Control language follows the GAO Standards for Internal Control in the Federal Government (Green Book, GAO-25-107721, 2025 revision, US public domain). COSO, IFRS, ISA and PCAOB standards are cited by name only. Replace every [bracketed] value and every row marked Example. This is a document format, not accounting, audit, tax, legal or financial advice. Obtain the standard or law for the normative text.

Document control

Approvals

Revision history

Contents

1. Account header and risk tier
2. Balance per ledger and supporting source
3. Reconciling items
4. Unexplained difference and threshold
5. Roll-forward of activity
6. Supporting evidence index
7. Ageing, clearance and write-off decisions
8. Preparer certification
9. Reviewer checklist and sign-off
10. Exceptions escalated
11. Reconciliation policy reference
12. Glossary and references

1. Account header and risk tier

Describe the account in plain words: what transactions post to it, from which systems, and what the balance represents at period end. The risk tier sets the frequency, the reviewer level and the evidence standard. Assign the tier with the criteria in section 11 and review it at least once a year, or when the account's activity changes.

The Green Book asks management to design control activities that achieve objectives and respond to risks (Principle 10) and to use quality information from reliable sources (Principle 13). For a reconciliation, that translates into two tests of the source: it must come from outside the ledger, and the preparer must be able to show how it was obtained (a download log, a confirmation, a system report with parameters). A spreadsheet that someone else typed is not an independent source until it is agreed to something that is.

2. Balance per ledger and supporting source

Take the GL balance from the trial balance after the entity GL lock, not from a working report. Take the supporting balance from the independent source dated at the same period end and the same time zone. If the source is in a different currency, translate at the closing rate and show both amounts.

The difference is explained in section 3. If the difference is zero, still list items that net to zero (for example a timing item offset by an error), because the reviewer needs to see them.

3. Reconciling items

Each reconciling item has an ID, a type, the date it arose, its age at period end, an owner and an expected clearance date. Use four types: timing (will clear by itself in the normal course, such as a sale captured on the last day and settled the next), GL error (the ledger is wrong and needs a journal entry), source error (the external source is wrong and the counterparty must correct it), and under investigation (cause not yet known). A GL error that is material for the account is corrected in the period, not carried as a reconciling item; a GL error below the correction threshold may be corrected in the next period if the reviewer agrees.

The total of reconciling items is 38,450.00 + 4,120.00 + 2,380.00 + 1,950.00 = EUR 46,900.00. RI-02 is a GL error that is corrected in March because the fee belongs to March expense; after JE-2027-03-0418 the GL balance becomes EUR 1,280,480.00 and RI-02 drops out of the reconciliation. The reconciliation is presented here before the correction so that the reviewer sees the error and its fix; the final version shows the corrected balance with a reference to the entry. RI-03 and RI-04 are also GL errors, but each is below the EUR 2,500 correction threshold in section 11, so the reviewer agrees to correct them in April. RI-04 is a cut-off error (the refund belonged to March) that the April posting clears. RI-03 is not unexplained: the PSP has already taken the cash, so the balance is a claim on the cardholder's bank, not on the PSP. Moving it to a separate "chargebacks in dispute" account keeps the PSP clearing account clean and makes the dispute visible on its own ageing report; carrying a known item as "under investigation" would hide it.

4. Unexplained difference and threshold

The unexplained difference is the part of the difference that no reconciling item explains.

where $A$ is the GL balance, $B$ is the supporting balance and $RI_i$ are the reconciling items with the sign convention in the guidance block.

An unexplained difference below the threshold does not need an entry this period, but it is not ignored. Record it as an item under investigation in the next period's reconciliation with an owner. If the same account shows an unexplained difference three periods in a row, escalate it in section 10 even if each one is small, because a repeating difference usually means a missing posting rule. An unexplained difference above the threshold blocks the reviewer's sign-off until it is explained or escalated.

In the example, the EUR 800.00 is traced in April to a currency rounding difference on GBP card sales processed by the PSP for the CC-DE webshop; the fix is a mapping change in the order-to-cash interface, logged as ISS-2027-04-02 in the April close.

5. Roll-forward of activity

A roll-forward is a second, independent check. It confirms that last period's reviewed balance is still the starting point and that each type of movement agrees to its source report. It is required for high-risk accounts and useful for any account with large gross flows and a small net balance, such as clearing accounts.

Check: 1,190,300.00 + 9,842,750.00 - 9,731,200.00 - 12,980.00 - 4,270.00 = 1,284,600.00. The February fees booked in March show the same pattern as RI-02: fees have been booked one month late. The reviewer raises this as a process issue (section 10), because the March correction is only a fix for one period.

6. Supporting evidence index

List every document the reconciliation relies on. Store evidence in the controlled close folder with read-only access after review. A reviewer or auditor should be able to re-perform the reconciliation from the evidence index alone. Where evidence is a system report, record the report name, parameters and run time.

7. Ageing, clearance and write-off decisions

Age reconciling items from the date they arose, not from the date they were first listed. Items older than the policy limit need a decision: chase, correct or write off. Write-offs are journal entries and follow the normal approval limits; they are never posted by the preparer without approval. Track the ageing profile over time; a growing tail is a sign that the account's process is failing, even if every reconciliation is signed on time.

Check: 38,450.00 + 4,120.00 + 1,950.00 = 44,520.00; 44,520.00 + 2,380.00 = 46,900.00.

Provisioning for items that are likely to be lost follows the group's expected credit loss and provisions policies, documented in Accounting Policy Manual (finance/accounting-policy-manual); the reconciliation records the decision and links to the entry.

8. Preparer certification

The preparer signs the statements below. Each statement is about this reconciliation only. If a statement is not true, strike it, explain why in the comment, and tell the reviewer before they start.

9. Reviewer checklist and sign-off

The reviewer must not be the preparer and should not have posted entries to the account in the period. Record what was checked, not only that it was checked. Comments and questions raised during review stay in the file, with their answers, because they are the evidence that the review was precise enough to detect an error. Under the Green Book, monitoring and remediation (Principles 16 and 17) depend on deficiencies being found and acted on; a review that never finds anything should itself be questioned.

If the reviewer returns the reconciliation, the preparer updates it and the reviewer reviews again; both rounds are recorded in the revision history.

10. Exceptions escalated

Escalate when an unexplained difference exceeds the threshold, when an item passes the age limit without a decision, when the same issue recurs, or when the reconciliation was not prepared or reviewed on time. Escalated issues go to the close issues log in Month-End Close Checklist (finance/month-end-close-checklist). If the issue suggests that a key control did not operate or was not designed well enough, the internal control lead evaluates it in Control Deficiency Evaluation (compliance/control-deficiency-evaluation).

11. Reconciliation policy reference

The values below come from the group reconciliation policy. They are Example values for Corvid Commerce Group plc; set your own in your accounting manual, reflecting materiality for the financial statements and the risk of each account.

Assign risk tiers using these criteria: transaction volume, use of manual entries, degree of judgement, exposure to fraud or misappropriation, history of errors, and whether the account is close to a material line in the financial statements. Review the tier for every account once a year and when a new system, process or entity is added. Accounts with zero balance and no activity still need a quarterly check that nothing posted to them, because an unexpected posting is itself a signal.

11.1 Common errors to look for

Reviewers and preparers find the same problems across many organisations. A supporting balance taken from a report that reads the GL (for example, an ERP "bank balance" screen rather than the bank statement) gives no independent evidence. Reconciling items described only as "timing" with no transaction reference cannot be vouched. Items that are positive one month and negative the next with similar amounts often mean a recurring entry is posted in the wrong period. Foreign-currency accounts reconciled in the functional currency only can hide differences in the transaction currency; reconcile in the transaction currency first, then check the revaluation. Finally, a reconciliation that is always completed on the due date by the same person, with no comments from the reviewer, deserves a second look by the financial controller from time to time.

11.2 Choosing the independent source by account type

The right source depends on what the balance represents. For bank and cash accounts, use the bank statement or a bank confirmation at the period-end cut-off. For clearing accounts with payment processors, use the processor's merchant balance or settlement report. For receivables and payables control accounts, agree the GL to the sub-ledger ageing, and then rely on the sub-ledger's own controls (customer statements, supplier statement reconciliations for the largest suppliers). For intercompany balances, use the counterparty's ledger balance as confirmed in the intercompany matching tool. For prepayments, accruals and deferred revenue, use a schedule built from contracts or invoices, and check a sample of schedule lines to the underlying documents each period. For fixed assets, agree to the fixed asset register roll-forward. For provisions and other judgemental balances, the source is the approved calculation or memo; the reconciliation confirms that the GL equals the approved amount and that the memo is current. For tax balances, use the tax computation and the latest returns or authority statements.

11.3 Automated matching

Many organisations use matching software for high-volume accounts. Automation changes the evidence, not the need for review. Keep the matching rules under change control, review the rule set at least yearly, and treat unmatched items exactly like manual reconciling items: typed, aged and owned. Auto-certification of low-risk accounts with zero balance and no activity is acceptable when the policy allows it and the rule itself is tested. The reviewer still signs the overall reconciliation status for the entity each period.

12. Glossary and references

12.1 Glossary

12.2 References

Standard and licence note

Based on the GAO Standards for Internal Control in the Federal Government (Green Book, GAO-25-107721, 2025) and SEC Release 33-8810 (2007), both US government works in the public domain; they are cited and the text here is original. The reconciliation layout, risk tiers and thresholds are original practitioner writing; no standard prescribes them, and the threshold values are examples, not requirements. COSO, IAASB (ISA 240) and PCAOB (AS 2401) materials are cited by name and number only; no text from them is reproduced or paraphrased. Corvid Commerce GmbH and every figure are fictional. Check the current official versions of every cited source and your local law before use. Template licence: MIT.