A template records the work. A control system checks it and refuses to call it finished while something is wrong.
An Excel finance system for controllers is a workbook that tests the numbers, not just a layout to fill in. It checks that balances agree to the trial balance, flags exceptions, records who prepared and reviewed each item and blocks sign-off while anything is open. Start with trial balance integrity, reconciliation-to-ledger checks, an exception list, preparer and reviewer evidence and a sign-off gate.
A template gives you rows and columns. It trusts whoever types into it. A control system adds checks that run every time the numbers change, so a mistake shows up as a red flag rather than in the auditor's management letter. The detail is in Excel template vs control system; this guide covers which controls a controller needs first and how to build them.
Paste the trial balance into a fixed tab and test it on every refresh:
=IF(ROUND(SUM(TB[Balance]),2)=0,"TB balances","TB out by "&TEXT(SUM(TB[Balance]),"#,##0.00"))
Add a second check that the account count matches the last period, so a missing account can't slip through:
=IF(COUNTA(TB[Account])=PriorAccountCount,"Same accounts","Account list changed")
On the reconciliation log, pull the ledger balance for each account from the trial balance rather than typing it in:
Ledger balance: =XLOOKUP([@Account],TB[Account],TB[Balance],0)
Difference: =ROUND([@[Ledger balance]]-[@[Reconciled balance]],2)
Status: =IF([@Difference]=0,"Agreed","Difference")
A reconciliation that doesn't agree to the ledger is not a reconciliation. See balance sheet reconciliation for the evidence each one needs.
Bring every open item into one place: differences, unreconciled accounts, aged reconciling items without an owner, journals awaiting approval. Each row needs an owner, a next action and a target date. A controller reviewing ten tabs misses things; a controller reviewing one list doesn't.
Aged item flag: =IF(AND([@Age]>60,[@Owner]=""),"Needs owner","")
Record who prepared and who reviewed each item, with dates. Then test the rules you care about:
Same person: =IF([@Preparer]=[@Reviewer],"Preparer reviewed own work","")
Review missing: =IF(AND([@Preparer]<>"",[@Reviewer]=""),"Not reviewed","")
This is the evidence an auditor asks for, and it supports manual journal controls as well.
The final control is the one that makes the others matter. The sign-off cell only shows "Ready" when nothing is open:
=IF(COUNTIF(Exceptions[Status],"Open")=0,"Ready to sign off","Blocked: "&COUNTIF(Exceptions[Status],"Open")&" open item(s)")
Combine it with the trial balance and reconciliation checks so a period can't be closed with a known error.
More in spreadsheet controls for finance teams.
If you are new in the role, start with the trial balance check and the reconciliation log, because they catch the largest errors. Add the exception list and reviewer evidence next, then the sign-off gate once the team is used to recording status. Use the month-end close checklist to decide which tasks feed the exception list.
A controlled workbook works well for one or a few entities and a small team. When many people need to work in the same file at once, or volumes make pasting data impractical, look at whether dedicated software is worth the cost. Once-off software vs a subscription sets out the cost maths.
UK teams often say "financial controller" and "nominal ledger"; US teams say "controller" and "general ledger". The controls are the same. Listed US companies document these controls under the SOX framework; UK groups may follow their own internal control framework or auditor guidance. Check the current requirements that apply to you.
12 questions on how strong your close controls are. Free to use online.
The Month-End Close & Controls System tests the trial balance against the sum of reconciled balances, keeps every open item on one exception dashboard and blocks sign-off while exceptions remain open. Excel, no macros, one-time price.
A template is a layout you fill in. A control system also tests the numbers, flags exceptions and blocks sign-off while anything is wrong.
A trial balance check and a reconciliation log that pulls ledger balances from the trial balance. They catch the largest errors quickly.
They can, if the workbook is protected, versions are kept per period and there is clear evidence of preparation and review. Ask your auditor what evidence they expect.
Last updated 15 November 2026. General guidance for finance teams; check it against your own policies, systems and local rules.