Reconciling every account every month wastes time. Reconciling too few lets errors grow.
Rate each balance sheet account by risk: its size, how much activity it has, how much judgement is involved, and its history of errors. Reconcile high-risk accounts such as bank, receivables, payables, suspense and payroll liabilities every month. Reconcile low-risk, low-activity accounts quarterly or yearly. Write the frequencies into a policy and review the ratings each year.
Give each balance sheet account a score from 1 to 3 on four factors:
| Factor | 1 (low) | 3 (high) |
|---|---|---|
| Balance size | Small, immaterial | Large or material |
| Activity | Few postings | Many postings each month |
| Judgement | None; balance comes from a statement | Estimates, provisions, manual calculations |
| Error history | No recent issues | Recent errors or audit findings |
In Excel, total the four scores and set the frequency:
=IF(F2>=9,"Monthly",IF(F2>=6,"Quarterly","Annually"))
Adjust the cut-offs to suit your business, and record them in your policy.
Even a low-rated account should be reconciled in a month when:
A balance sheet flux analysis catches the first two automatically.
A short reconciliation policy should list every account, its risk rating, frequency, owner and reviewer. It turns a debate every month into a schedule. Review the ratings once a year and after any audit finding. The account reconciliation template and the balance sheet reconciliation process cover how to do each one.
Take a bank account with a material balance, hundreds of transactions a month, no judgement and no recent errors. It scores 3, 3, 1 and 1: a total of 8, which would suggest quarterly. But bank accounts are a classic fraud and error risk, so most policies override the score and reconcile them monthly. Build these overrides into the policy for specific account types, so the scoring works for the general case and the exceptions are explicit.
By contrast, a share capital account with no movement for years scores 1 on every factor: annual reconciliation is enough, as long as the flux analysis would show any change.
Neither UK nor US rules set a fixed reconciliation frequency for private companies; it is a matter of internal control and audit expectations. US public companies need documented, tested controls under SOX, which in practice means a written risk-based policy.
Reviews every balance sheet reconciliation with an on-device AI and 20 review tests, flags vague and wrong-account reconciling items, and builds a risk-ranked review queue. Runs in your browser on your own computer: nothing is uploaded.
12 questions on how strong your close controls are. Free to use online.
The Balance Sheet Reconciliation Library covers the balance sheet with nine working papers: a known error blocks sign-off, every supported balance needs an evidence reference and every aged item needs an owner and a next action. Excel, no macros, one-time price.
Matching software can reconcile high-volume accounts such as bank, but someone still needs to review exceptions, approve the result and own the account.
No. A risk-based policy reconciles high-risk accounts monthly and lower-risk ones quarterly or yearly, with overrides for unusual movements.
Bank, receivables, payables, suspense, payroll and tax liabilities, intercompany balances and accounts with material estimates.
At least once a year, and whenever there is an audit finding or a significant change in how an account is used.
Last updated 21 October 2026. General guidance for finance teams; check it against your own policies, systems and local rules.