The Xero month-end close checklist
The month-end close, step by step - written by an ACA who has run a few hundred of them. Works whether or not you use Postlock.
- Set your cut-off and tidy the basics
- Reconcile bank and cash first
- Work through the balance sheet, top to bottom
- Prove receivables and revenue
- Accruals, prepayments and payables
- Fixed assets and depreciation
- VAT and tax control accounts
- Review the P&L for sense
- Lock the period and sign off
- Watch for changes after sign-off
Closing the books each month isn't about ticking boxes - it's about being able to stand behind every number on the balance sheet and the P&L. The steps below are the routine I'd run for any business on Xero. The first nine are the close itself; the tenth is the one almost every checklist forgets, and it's the one that bites.
1. Set your cut-off and tidy the basics
Month-end starts before month-end. Agree a cut-off date and stick to it - every invoice, bill and bank line for the period needs to be in before you reconcile, or you'll spend the day chasing moving numbers. In Xero: clear the bank feeds, publish the draft invoices and bills that belong to the period, deal with anything sitting in Awaiting Approval, and check nothing is parked in a suspense or clearing account. A clean starting point saves more time than any single reconciliation.
2. Reconcile bank and cash first
Everything ties back to cash, so start there. Reconcile every bank, credit-card and loan account to the actual statement balance: not just that the transactions are reconciled, but that the balance agrees. A bank account that doesn't agree to the statement is the fastest route to a wrong balance sheet. Don't forget PayPal, Stripe, Wise and similar - they're where reconciliation quietly breaks, because the feed and the platform balance drift apart.
3. Work through the balance sheet, top to bottom
This is the heart of the close, and the discipline is simple: every balance-sheet line needs to be explained, not just glanced at. For each line you should be able to answer "what is this balance, and why is it this number?" The textbook lines have a schedule (below). The ones that catch people out are the odd balances: a one-off deposit, a bespoke accrual, a director's loan movement, something in "other debtors" booked eight months ago that nobody remembers by the time the auditor asks. Write the explanation down the first time and carry it forward every month. That institutional memory is worth more than any reconciliation tick.
4. Prove receivables and revenue
Reconcile the debtors (accounts receivable) control account to the aged receivables report - they should agree to the penny; if they don't, something's been posted straight to the control account. Review the aged debt for anything very old: is it really collectable, or does it need providing for? If you recognise revenue over time - deferred income, subscriptions, retainers - check the deferred revenue schedule releases the right amount this month. Revenue is where the P&L and the balance sheet meet, so it matters twice.
5. Accruals, prepayments and payables
The classic month-end schedules. Prepayments: spread costs paid in advance (insurance, annual software, rent) across the months they cover, releasing one month. Accruals: book the cost of things you've had but not yet been invoiced for (utilities, professional fees). Reconcile the creditors (accounts payable) control to the aged payables. The trick with all three is roll-forward: last month's closing is this month's opening, you release what's due, add what's new, and the schedule total should tie to the GL. A schedule that won't tie is telling you something's been posted around it.
6. Fixed assets and depreciation
Reconcile the fixed asset register to the balance sheet - cost, accumulated depreciation and net book value. Post this month's depreciation (Xero's fixed-asset module can run it, or your schedule does), and pick up additions and disposals. A disposal booked to the wrong account is a common one. The register is itself a movement schedule: opening NBV, plus additions, less depreciation and disposals, equals closing NBV.
7. VAT and tax control accounts
Reconcile the VAT control account to your VAT return position - after a return is filed and paid it should clear back towards nil, give or take timing. A VAT account drifting up every quarter usually means transactions posted with the wrong tax treatment, or manual journals. Check PAYE/NIC and any other tax control accounts the same way. These are the accounts HMRC cares about, so prove them properly.
8. Review the P&L for sense
With a clean balance sheet the P&L should largely take care of itself - but review it anyway. Compare this month to last month and to budget, and ask why anything moved. A cost that's doubled, revenue that's dropped, a margin that's shifted - either it's real and worth understanding, or it's an error you haven't caught. This is where materiality earns its keep: decide what's material for your business (a percentage of profit, revenue or net assets) and focus there. Tying out pennies while missing the big movement is the wrong trade.
9. Lock the period and sign off
When you're happy, lock the period in Xero (set a lock date) so nothing lands in the closed month by accident. Produce your reconciliation pack - the working papers that show how each balance was proved - and the headline figures for whoever's relying on them: the board, the owner, the bank. Sign-off should mean something. It's the point you stand behind the numbers.
10. Watch for changes after sign-off
The step most checklists miss, and the one that quietly causes the most pain. Locking a period in Xero is a soft lock: it can be lifted, and entries can be backdated into a closed month: a late bill dated last month, a correcting journal, an integration syncing historic data. The moment that happens, the numbers you signed off, and put in a board pack or filed accounts, no longer match Xero, and nobody gets told. So the close isn't really finished at sign-off; it's finished when you can prove the signed-off numbers haven't moved. Snapshot your balances at lock and check back: did anything land in a period you'd already closed? This is exactly the gap Postlock was built to close - but however you do it, build "has anything changed since I signed off?" into your routine.
Frequently asked questions
- How long should a Xero month-end close take?
- It depends on size and complexity - a small business with clean books might be half a day, a larger entity a few days. The biggest time sinks are chasing cut-off and explaining odd balances, both of which get faster when you carry forward your notes month to month.
- What’s the difference between a movement schedule and a proof?
- A movement schedule rolls a balance forward (opening + additions − releases = closing) - prepayments, accruals, fixed assets. A proof reconciles the GL balance to an independent list - debtors to the aged report, bank to the statement. Most balance-sheet lines are one or the other.
- Can you lock a period in Xero so nothing changes?
- You can set a lock date, but it’s a soft lock - it can be lifted, and entries can still be backdated into a closed period. That’s why checking for post-close changes matters.
- What does materiality mean in a month-end close?
- It’s the threshold below which a difference isn’t worth chasing - often a percentage of profit, revenue or net assets. It keeps you focused on what actually affects the numbers rather than tying out pennies.
- Do I need to reconcile every balance-sheet account every month?
- Yes: every balance-sheet line should be explained every month. The P&L flows from a clean balance sheet, so if the balance sheet is right, the P&L usually follows.