Balance Sheet Reconciliation: A Practical Guide for Finance Teams

Balance sheet reconciliation is the process of confirming that the balance shown in the general ledger for each account is supported by independent evidence. For cash, that means a bank statement. For debtors, an aged receivables report. For prepayments and accrued liabilities, it means agreeing the GL balance to a schedule of the individual items that make up that balance.

It sounds straightforward. In practice, it is the step most likely to be skipped under time pressure — and the one most likely to surface errors that have been quietly accumulating for months.

Why Reconcile the Balance Sheet?

The P&L gets reviewed closely every month — revenue, costs, margins. The balance sheet tends to get less attention unless something looks obviously wrong. But balance sheet errors compound. A prepaid expense that was never amortised inflates your asset base. An accrual that was never reversed inflates your liabilities. Neither shows up as a variance on the P&L, so both can sit undetected until an audit or a business sale.

Reconciling Prepaid Expenses

Your prepaid expenses GL balance should equal the sum of all open prepayment schedules as of the balance sheet date. To reconcile it:

• Pull the closing balance of your prepaid expenses account from the GL
• List every active prepayment with its remaining balance as of the period end
• Sum the individual balances and compare to the GL
• Investigate any difference — common causes include amortization journals that failed to post, prepayments that were expensed directly rather than set up as schedules, or manual adjustments that were not recorded

Reconciling Accrued Liabilities

The same logic applies to accrued liabilities. Your accruals GL balance should equal the sum of all open accruals as of the period end. Any accrual that has been reversed should not appear in the list.

• Pull the closing balance of your accrued liabilities account from the GL
• List every open accrual with its balance — only include items that have not yet been reversed
• Sum the individual balances and compare to the GL
• Investigate any difference — common causes include reversed accruals that were not removed from the list, or new invoices posted directly to the accruals account

The "As of Date" Problem

One of the trickier aspects of balance sheet reconciliation is that the answer changes depending on the date. If you are preparing management accounts for March, you need to know the prepaid balance as of 31 March — not today's date, and not the balance at any arbitrary point during the month.

When amortization runs automatically and balances are calculated on a date-specific basis, this is trivial. When you are working from a spreadsheet, it often means manually re-running calculations or maintaining separate point-in-time snapshots. That is where most of the reconciliation time goes.

Making Reconciliation Faster

CloseKit's reconciliation dashboard lets you select any date and instantly see the breakdown of your prepaid expenses and accrued liabilities. Every item shows its current balance, the amortization or reversal history behind it, and the GL accounts it maps to. The total reconciles automatically to what your GL should show — turning a multi-hour task into a two-minute check.

• Select any date to see point-in-time balances for all accounts
• Drill into individual prepayments and accruals for full history
• Export a reconciliation schedule as CSV for audit workpapers
• See immediately if a balance has changed due to an adjustment or correction