Balance Sheet Reconciliation Template

Start from the trial balance at the period end. Give every balance sheet account its own row, with your account numbers and names exactly as they appear, including accounts at zero that moved during the period. Check that total debits equal total credits before going further.

Reconcile cash, receivables, payables, accruals and anything built on an estimate every month. Quieter accounts need it at least once a quarter. Give each account an owner and a due day on your month-end close checklist, so the work is finished before anyone reports from the numbers.

The Public Company Accounting Oversight Board (PCAOB) writes the standards that auditors of US public companies follow. Its standard on audit evidence, AS 1105, says that in general, evidence from a knowledgeable source independent of the company is more reliable¹ than evidence from internal sources alone. It also ranks original documents above photocopies, faxes and scans.

That is why one of the most common tie-outs proves so little. A receivables aging comes out of the same ledger as the receivables account. When the two agree, that proves the system adds up, not that customers owe you the money. If auditors rely on reports like these, AS 1105 has them test the reports' accuracy and completeness, or the controls over them.

The cheapest strong evidence usually arrives after the period ends. Cash received next month against specific invoices shows those receivables existed. Payments made next month can reveal bills that belonged in the period you're closing. For cash, a bank reconciliation does the line-by-line work, and a fixed asset register built from invoices supports equipment balances.

Then put a number on it. Split each balance into the dollars backed by outside evidence and the dollars that aren't, so the two add back to the balance. A tick in a Reconciled column hides that split, and the second figure is the one worth a reviewer's time.

Write down every difference as an item: what it is, when it arose, the amount and who owns it. "Timing" explains nothing unless you can say when the item will clear. Never add a balancing line to make an account agree. An unexplained amount is a finding, so record it as one.

Estimates need fresh support every period. Recalculate each recurring accrual from its source, such as the lease, the contract or recent actual bills, and note when it was last compared with a real invoice.

The allowance for credit losses is no different. In the US, the Financial Accounting Standards Board's credit loss standard bases it on historical experience, current conditions, and reasonable and supportable forecasts². A memo written for last year's audit can't support this year's figure on its own.

Every item you can't clear goes on an aged list with the date it first appeared. Give each one two figures: its effect on this period, and the total it has reached on the balance sheet across every period it has survived.

The SEC staff shows why in Staff Accounting Bulletin 108, guidance written for public companies. Its example is an improper expense accrual of $100 that built up at $20 a year³ for five years. Judged on this year's income statement, the error is $20; on the balance sheet, it is $100. The staff says to measure both, and warns that the yearly view alone can let small errors pile up.

Say a utilities accrual is booked at $9,400 a month while the bills paid against it average $7,475. That leaves $1,925 too much in the liability every month, an amount nobody stops to chase. After 24 months, accrued liabilities hold $46,200 that the business doesn't owe.

Small doesn't mean safe. In SAB 99, the SEC staff says exclusive reliance on a percentage threshold such as 5% has no basis in the accounting literature or the law⁴. Its list of reasons a small misstatement can still be material includes whether it affects compliance with loan covenants. Use a threshold to decide what to investigate first, never what to ignore.

The reviewer should be someone other than the preparer, and both should sign and date each reconciliation. If nobody else can review, leave the reviewer line blank rather than signing twice, and ask an outside accountant to check the riskiest accounts.

Read the numbers before the conclusions. Start with the dollars that nothing outside the ledger supports, then the zero differences on internal reports, then the aged list read as one total. A reviewer who reads only the status column learns that the preparer agrees with themselves.

If an audit is coming, an audit preparation checklist tracks what the auditors will ask for. To skip the setup, open this template in River. It builds the account list from your trial balance, sorts your documents by who produced them and totals what has no outside evidence.