Short answer: A month-end balance sheet reconciliation proves that each balance in the ledger is supported by independent evidence, such as a bank statement, a subledger or a schedule. Reconcile high-risk accounts (cash, receivables, deferred revenue, accruals) every month, lower-risk accounts quarterly, and have someone other than the preparer review and sign off each one.
For a SaaS business on Xero, QuickBooks Online or Zoho Books, the reconciliations that cause the most trouble are the schedule-driven ones: deferred revenue, prepayments and accruals. Their balances come from journals, so an error in the schedule flows straight into the balance sheet unless someone ties the two together.
Which balance sheet accounts to reconcile at month end
Start with every balance sheet account that has a non-zero balance or had activity in the month. For a typical SaaS company that list is short enough to manage:
- Cash and cash equivalents. Each bank account, card account and payment processor clearing account.
- Accounts receivable. The aged receivables report against the control account.
- Prepayments. Software subscriptions, insurance and other costs paid in advance.
- Fixed assets and capitalized costs. The asset register against the ledger.
- Accounts payable and accruals. The aged payables report and the accruals listing.
- Deferred revenue. Billed but not yet earned revenue, usually the largest liability for a subscription business.
- Payroll and sales tax liabilities. Against payroll reports and tax filings.
- Intercompany and suspense accounts. These should reconcile to zero or to an agreed balance.
Equity accounts change rarely and can be checked when they move, for example after a funding round or a stock option exercise.
Setting reconciliation frequency by risk
Not every account needs the same effort each month. Rank accounts by the size of the balance, the volume of transactions and how much judgment goes into the number. The table below is an illustrative starting point; your own ranking is an internal choice agreed with your auditor.
| Account | Risk | Frequency | Ties to |
|---|
| Cash and clearing accounts | High | Monthly | Bank and processor statements |
| Accounts receivable | High | Monthly | Aged receivables report |
| Deferred revenue | High | Monthly | Revenue schedule by contract |
| Accruals | Medium to high | Monthly | Accruals listing and support |
| Prepayments | Medium | Monthly | Prepayment schedule |
| Fixed assets | Low | Quarterly | Asset register |
| Equity | Low | When it moves | Cap table and board minutes |
Raise an account's frequency when something changes: a new revenue stream, a price change, a system migration or an error found in the previous period.
What a good reconciliation file contains
A reconciliation file should let a reviewer, or an auditor a year later, follow the logic without asking the preparer. The same six elements work for any account:
- Header: account name and number, period end date, preparer and date prepared.
- Ledger balance: the balance from the trial balance at period end.
- Supporting balance: the independent figure, such as the bank statement, subledger total or schedule balance.
- Reconciling items: each difference listed separately with a date, amount, description and expected resolution.
- Evidence: the statement, report or schedule itself, attached or linked.
- Review block: reviewer name, review date and any questions raised and answered.
An unexplained difference of any size is a finding. "Rounding" is acceptable only when it is a rounding difference you can show.
Tying out deferred revenue to the revenue schedule
Deferred revenue is the balance of invoiced amounts not yet recognized as revenue. The tie-out has two levels.
- Schedule to ledger. The closing deferred revenue on the revenue schedule should equal the deferred revenue balance in the ledger. A difference usually means a journal was missed, posted twice or posted to the wrong period.
- Contracts and invoices to schedule. Each invoice in the period should appear in the schedule with the right service dates, and canceled or amended contracts should be reflected.
Illustrative example: on March 1, 2026 a customer is invoiced $120,000 for a 12-month subscription. At March 31, 2026, $10,000 has been recognized and $110,000 should sit in deferred revenue for that contract. The reconciliation adds up these contract-level balances and compares the total with the ledger.
Our article on why deferred revenue reconciliations break and how to fix them covers the common causes in detail, and how to record deferred revenue covers the underlying entries.
Tying out prepayments and accruals
Prepayments and accruals are reconciled the same way: the ledger balance against a schedule or listing, and the schedule against invoices and supplier evidence.
Prepayments
The prepayment schedule lists each prepaid cost, its service period and the amount released each month. Check that the closing schedule balance equals the ledger, that new prepaid invoices in the month have been added, and that fully released items have dropped off. Annual software contracts are the usual source of errors.
Accruals
The accruals listing shows each cost incurred but not yet invoiced. Check that each accrual has support, such as a purchase order, a contract or a budget holder's confirmation, and that last month's accruals were reversed or matched to the invoice that arrived. An accrual that rolls forward unchanged for several months is often a cost that will not be billed.
Handling reconciling items and aged differences
Reconciling items are differences between the ledger and the supporting balance that have a known cause. Timing items, such as a deposit in transit, clear on their own. Other items need a correcting journal.
- Label each item as timing or error, so the reviewer knows which ones need action.
- Age each item by the month it first appeared.
- Set an internal limit for how long an item can carry forward before it is escalated to the finance lead. Many teams choose one or two months.
- Correct at source. If the difference comes from the schedule or the CRM, fix it there as well as in the ledger, or it will return next month.
Review and sign-off of balance sheet reconciliations
The reviewer is not the preparer. In a small team, the controller reviews the accountant's reconciliations and the finance lead reviews the controller's, including deferred revenue. Review means more than checking that the two balances match: it means reading the reconciling items, opening a sample of the evidence and asking about anything that looks unusual.
The finance lead then signs off the full set before the management accounts are released. That sign-off is the point at which the balance sheet can be relied on. The SaaS month-end close checklist shows where reconciliations sit in the close calendar.
How ScaleXP helps with schedule-driven balances
ScaleXP builds the schedules behind deferred revenue, prepayments and accruals from your Xero or QuickBooks data and CRM data from HubSpot, Salesforce or Pipedrive, and prepares the journals from those schedules. The journals are posted once finance approves them. Because the schedule and the journal come from the same source, the schedule gives the reconciler a supporting balance to compare with the ledger.
The ScaleXP month-end close page describes a balance sheet reconciliation view that compares the ScaleXP balance with the balance in Xero or QuickBooks. For the individual workflows, see deferred revenue schedules in ScaleXP and prepayment schedules in ScaleXP.
Conclusion
A month-end balance sheet reconciliation is complete when each material balance is tied to independent evidence, each difference is explained and dated, and someone other than the preparer has reviewed and signed it off. Reconcile by risk, give deferred revenue, prepayments and accruals a two-level tie-out, and clear aged items at source rather than carrying them forward.
Frequently asked questions
Which balance sheet accounts should be reconciled every month?
Cash, accounts receivable, deferred revenue, accruals and prepayments should be reconciled every month in a SaaS business, because they are large, active or based on judgment. Payroll and sales tax liabilities usually follow monthly too. Lower-risk accounts such as fixed assets can move to a quarterly cycle, and equity can be checked whenever it changes.
What should a balance sheet reconciliation include?
A balance sheet reconciliation should include the account and period, the ledger balance, an independent supporting balance, a list of reconciling items with dates and explanations, the evidence itself, and a review block with the reviewer's name and date. A reviewer should be able to follow it without asking the preparer any questions.
How do you reconcile deferred revenue at month end?
Compare the closing balance on the revenue schedule with the deferred revenue balance in the ledger, then check that each invoice issued in the month appears in the schedule with the correct service dates. Differences usually come from missed or duplicated journals, or from contract changes that reached the CRM but not the schedule.
How long can a reconciling item stay open?
Timing items such as deposits in transit should clear in the following month. For other items, set an internal limit, often one or two months, after which the item is escalated to the finance lead and corrected. An item that rolls forward for several months is usually an error rather than a timing difference.
Does ScaleXP replace balance sheet reconciliations?
No. ScaleXP builds the schedules for deferred revenue, prepayments and accruals and prepares the journals, which are posted once finance approves them. The schedules give your team a supporting balance for those accounts, but the reconciliation, review and sign-off remain finance tasks, and accounts such as cash and receivables are reconciled in the usual way.
