→

Xero Month-End Close Process: A Step-by-Step Guide

Nigel Sapp

Published:

June 19, 2025

Updated:

September 23, 2026

See Numeric in action

Xero does bank reconciliation well, which is why so many lean accounting teams are happy to rely on it. With bank feeds and bank rules doing the matching, most transactions are ready to clear before the Xero month-end close starts.

At the same time, Xero leaves out some of the structure larger accounting teams rely on, like a reviewer role and schedules for prepaids and accruals. Rather than a strict period close, Xero’s process uses lock dates on transactions and reconcile periods as two separate steps.

There is also the issue of manual processes. Xero lacks a true native subledger for tracking prepaids and accruals, creating additional manual processes and outside tracking responsibilities for the user. That adds work and leaves room for errors.

This guide will walk you through the steps of Xero’s month-end close process, providing additional guidance where its capabilities may fall short.

Key Takeaways

Xero lacks a one-step period close process, and adviser permissions are required to lock a transaction period.
Bank reconciliation is Xero’s strength, but lacks a native integrated process for prepaids or accruals.
A standardized checklist is the single biggest lever on a faster, cleaner Xero close.
Reconciling non-bank accounts usually means connecting Xero to outside documents in Google Drive, OneDrive, or Excel.
Numeric extends Xero’s capabilities with a shared close checklist, reconciliations that tie workpapers to Xero balances, and reviewer sign-off.

Learn to automate your accounting for 5.5 free CPE credits. Take the Finance Engineer Course.

The Month-End Close Process with Xero

In most cases, the Xero month-end close requires the following steps:

Collect all financial documents including bank statements, loan statements, credit card statements, income statements, expense statements, etc.
Record monthly expenses and income including payroll, utilities, payments to suppliers, travel expenses, insurance premiums, loan interest, etc.
Update accounts payable and accounts receivable.
Reconcile bank accounts and credit card accounts, comparing them to actual bank statements within Xero.

Reconcile prepaid accounts and accruals. This is where Xero tends to require some manual processing, since there isn’t prepaid or accrual scheduling built within the platform. Keeping an outside schedule or spreadsheet for accruals and prepaids can support this work.

Post the monthly prepaid amortisation as a manual journal. Under Accounting > Manual journals, debit the expense and credit the prepaid account. Any recurring or variable transactions can be managed via the Repeating tab. You have the option to save as draft or post when the amount is identical every period. Variable prepaid schedules will require manual adjustment from within the repeating journal or saved draft.
Use the auto-reversing date for accruals. Accruals run the same logic in reverse: what's been incurred but not invoiced, worked out from open POs, unbilled vendor work, and contractual obligations. Manual journals carry an optional auto-reversing date, so you set the reversal when you post the accrual rather than relying on remembering it next month. Date the journal to the last day of the month and note the reason for adjustment.
Tie the schedule back to the Xero balance. Compare your schedule total against the account balance and document any difference.

Numeric can formalize and simplify the reconciliation process for prepaids and accruals. Maintain your schedule in your spreadsheet, and allow Numeric to link your records to your Xero account balance. This can help automate the tie-out process, track changes, and allow for reviewer sign-off in a single place.

Reconcile fixed assets and inventory. Both items reconcile against records that exist outside the general ledger, but they each have their own process: Fixed assets reconcile against a register that Xero maintains, while inventory reconciles against a physical count.

To reconcile fixed assets, register the drafts, then run depreciation. When you code a transaction to an asset account, Xero creates a draft asset. However, the draft asset won’t appear on reconciliation reports until it has been registered. Once you do this, you can run the depreciation through the period of time you’re reconciling.
Run the Fixed Asset Reconciliation report. Under Reporting > All Reports, set the date range to the month you're closing. The closing book values for the balance sheet and the asset register should match, with the difference showing as zero. When the numbers don’t align, check for unregistered drafts, assets that were added manually without a cost transaction, and manual journals or credit notes that were prematurely posted to fixed asset or depreciation accounts.
To reconcile inventory, compare the inventory item list to your stocktake. There's no equivalent reconciliation report here. The report gives quantity on hand and value at period end for each tracked item. If there’s a discrepancy, all you can do is check your inventory count.
Adjust, then check where the entries landed. Xero Inventory Plus handles adjustments one item at a time or in bulk by CSV. Run the journal report and filter it for inventory adjustments to confirm your numbers. If the balance is still off, there may be some other reason for the mismatch, such as human error or setup issues.

What Xero doesn't give you for either one of these processes is a place to record the reconciliation outside of the report itself. Teams that want a formal record of the reconciliation, review, and sign-off usually add a tool like Numeric.

Check the Account Transactions report for the month and make any necessary edits.
Review and publish the Reconciliation Report for each account.
Review the Balance Sheet.
Review the Income Statement (P&L).
Publish the GL/Account Transactions, Balance Sheet, and Income Statement reports. Publishing creates a snapshot of a report for a particular period, which makes it useful for reference purposes or even leadership reports.

To build a Xero reporting pack for month-end, use Xero’s management report feature. The report includes an executive summary, cash summary, income statement, balance sheet, and an aging summary for both accounts receivable and accounts payable. You can also create custom packs to include any other reporting documents that you need. The management report doesn't usually include general ledger detail, so add that separately.

Download the published reports and financial statements to your computer.
Set up the month-end lock date, following the steps below.

Reconcile without the manual work with Xero App Numeric

Locking a Month in Xero

Locking down a month is a typical sticking point for teams accustomed to working in NetSuite or other accounting software. In NetSuite, you can close out a period. However, with Xero, you can set a lock date to stop users from adding, changing, or deleting transactions dated on or before it.

Xero has two lock dates, and together they work like a soft close and a hard close.

All users except advisers. Standard users are locked out while advisers can still post. This is the lock date most teams set during the close, freezing the books for the wider business while accounting finishes adjusting entries.
All users. Nobody posts once this lock date is set, advisers included. Set this once the period is final.

You need the adviser user role to set or change either one. To set a lock date:

In the Accounting menu, select Accounting settings.
Click Financial settings.
Under Lock Dates, enter the date for locking transactions, selecting whether advisers can or cannot make changes on and before this date.

Click Save.

Removing or moving a lock date follows the same path: Return to Financial settings and clear or change the date.

The history and notes section at the bottom of the financial settings page records every lock date change and who made it. If you unlock a period, add a note explaining why. This can help answer any questions that may arise during an audit.

Where the Xero Close Starts to Break Down

For a team of two closing a single entity, pairing Xero with a well-organized Google Drive can work well. However, the system can start to break down for smaller organizations once second entities, additional accountants, or audits come into play.

There is no reviewer role in the close. Xero does not have preparer and reviewer roles for smaller organizations, only access levels, such as viewer, standard, and administrator. Users of a beta feature called Workpapers have these preparer and reviewer roles, but it’s currently only available to select users of Xero Partner Hub.
You can’t compare views: When a senior reviews a staff accountant’s prepaid schedule, there is no built-in diff view showing what has changed since last month. Rather, you may have to use a History & Notes report to track changes over time or build reports that snapshot periods of time to compare and contrast.
Prepaids, accruals, or deferred revenue don’t have a separate subledger. The work happens in external spreadsheets without a way to connect the spreadsheet to the balance it is supposed to support.
The template lacks a leadership dashboard. You won’t find a single dashboard template highlighting close progress, open items, or reviewer status for leadership to review. This can create confusion when trying to track down statuses in different areas of the tool.
Audit prep requires reconstruction vs. retrieval. With your supporting close documents living in different tools, there is nothing connecting your prepaids, accruals, or deferred revenue. They must be manually uploaded. You can set recurring transactions over time, but if amounts differ from month to month, they need regular manual adjustments.
Multi-entity organizations remain separate. Each legal entity acts as a separate Xero organization with its own chart of accounts and its own subscription. Xero has no native consolidation offering, so a third-party tool would be necessary for group reporting and consolidated financial statements.

This is the wall SINE ran into. The specialist media consultancy, with offices in London and New York, had built its finance function deliberately around process rather than headcount. As the team grew, the spreadsheet approach stopped scaling. As co-founder and CFO Felix Matthews said, “When you have so many spreadsheet tabs that you actually have to scroll across to see them all, that's always a good sign that you are maybe not using the best technique for managing the close.”

Felix Matthews, SINE co-founder and CFO, said Numeric’s ability to integrate with Xero was the deciding factor in layering the tools together. “Then the live Xero integration sealed the deal – here's our live general ledger, here are the balances and here's how we can integrate our existing Google sheet schedules – that was next-level.”

Managing Your Month-End Close Checklist with Xero

Controllers running the close on Xero often find inconsistencies after the books should have been closed. That happens because the checklist and the work live in different places with reconciliations, schedules, and journals living outside of Xero. Having a shared, integrated checklist with owners, due dates, and real-time status changes mitigates consistency issues, because progress is visible in real time.

Numeric serves as the checklist layer on top of Xero. Tasks connect to the accounts and schedules they represent, and open items, reviewer status, and unreconciled accounts all sit in one place.

“It's enabled me to delegate with guardrails. I can monitor progress, spot issues and see how we're tracking against our due date targets,” said Felix Matthews, SINE co-founder and CFO, after rolling out Numeric.

A strong month-end close checklist is critical for maintaining accurate financial data, audit-ready teams, and clear communication.

Starting from scratch? Reference our templates for common use cases including ecommerce, SaaS, retail, healthcare, and hospitality.

How Reconciling in Xero Works

Account reconciliation is an important step in the Xero month-end process, so let’s have a look at how it is done. To help ease the process, let’s break it up into two separate jobs: the ongoing work of matching transactions against the bank feed, and then the harder work of reconciling misaligned balances.

Standard Bank Reconciliation Flow

Bank reconciliation refers to the process of checking and confirming that all transactions in your bank account are recorded and matched in your accounting records in your general ledger. To reconcile bank accounts on Xero, you need to match bank statement lines from your bank account (on the left of the screen) with transactions in Xero (on the right of the screen), by following these steps from Xero:

From the Dashboard, go to Accounting, select Bank accounts, then click on Reconcile X items. This shows how many items are pending reconciliation at the moment.

Xero business bank account with Reconcile items button

For each bank statement line, you can choose whether to match with a transaction in Xero with the Find and match tab, create a transaction, transfer, or discuss.
To create a matching transaction, enter the name of the contact in the Who field, the account in the What field, and a description in the Why field (optional).

Creating a matching transaction in Xero with the Who, What, and Why fields

Once you have the correct matching transaction, click OK.

Confirming a matched bank statement line in Xero

You can create bank rules by setting up your own custom conditions, setting the contact, allocating line items, setting the reference, and adding rule details. In this way, Xero will automatically pick up all transactions that follow the set conditions for easier and faster matching.
Once you’ve reconciled all transactions in the bank account, check out the Reconciliation Report by clicking on it, to make sure that everything is in balance.
If the Balance in Xero and the Statement Balance match, you are good to go. Your bank account has been correctly reconciled.

Handling Missing or Mismatched Transactions

When the balances don't match, a common cause is a missing bank statement line in Xero. The below instructions from Xero can help with handling missing or mismatched transactions.

Xero Reconciliation Report comparing Balance in Xero and Statement Balance

Open the Bank Reconciliation report pack and select Bank Statement under Contents.
Compare it against your actual bank account to identify missing transactions.
Go to Accounting > Bank accounts. Open the menu for the relevant account and choose Import a Statement, then download Xero's CSV template.
Enter the missing transactions. Date and Amount are required fields.
Upload the file, then map the fields and select the date format if prompted. Once you do this, review the transactions, then Complete import.
Reconcile the imported statement lines.
Run the Bank Reconciliation Detail report and confirm the Statement balance (calculated) matches your real bank balance.
If there's still a difference, check the Statement Exceptions report.

Reconciling Non-Bank Accounts in Xero (Prepaids, Accruals, Deferred Revenue, or Fixed Assets)

Xero doesn’t have a schedule or subledger for prepaid expenses, accruals, or deferred revenue, so those schedules generally sit outside of Xero. Fixed assets are the exception. Xero has a register that posts depreciation automatically for registered fixed assets (this excludes draft, disposed, or sold assets), in addition to the ability to run a Fixed Asset Reconciliation Report.

The general workaround for reconciling non-bank accounts in Xero has been known to result in version control issues, lack of audit trails and reviewer sign-off, and formula errors. That’s because they rely on manual work prone to file and data entry errors, such as:

Schedules living in Excel or Google Sheets with one tab or file per account.
Workpapers living in cloud storage platforms that have been organized with poorly managed folder conventions
Manual typing of asset numbers into Xero.

“[Numeric] also becomes your knowledge base. You can keep files contextually in the right place rather than just in a Google Drive with an often confusing folder structure,” said Felix Matthews, SINE co-founder and CFO.

Numeric handles this without asking you to migrate your work. Your workpaper can stay where it lives, whether that’s in Google Sheets or Excel on SharePoint, while Numeric links it to the Xero account it supports. Because Numeric’s integration with Xero is live, the schedule total is always measured against the current general ledger balance rather than an outdated one. Thanks to this process, the balance ties to Xero automatically.

Numeric also attributes and timestamps each comment, submission, review, and approval, so reviewers and auditors can see who signed off and when.

Beyond reconciliation, the Numeric MCP lets you run parts of your close from your AI tool. Ask Claude to submit the reconciliations that tie out and flag the ones that don't, and it carries out that work in Numeric under your existing permissions.

Run your Xero reconciliations from your AI assistant. Learn about the Numeric MCP.

Learn more

Common Xero Month-End Close Mistakes

These 5 mistakes account for common trouble-spots teams run into during the closing process with Xero.

Forgetting to set the lock date. You may find your published balance sheet stops matching the general ledger if staff are able to backdate transactions into a period that should be closed. Make the lock date the last item on the checklist.
Assuming everyone can set a lock date. Only an account adviser can assign a lock date, so be sure to assign the appropriate person to this responsibility before month-end.
Bank feed duplicates. Manually importing CSV files that overlap with the automatic feed can cause duplicate line items. Check the import's date range against the feed first.
Leaving unreconciled items parked in a suspense account. When balances sit unidentified for months, it becomes harder to trace their origin. Don’t leave your files waiting in suspense. Clear the account regularly.
Inconsistent close timelines. Changing timelines can interfere with accounts receivable, payments, and your data consistency. If your close takes a different number of days every month, it can impact team performance and leadership’s trust in your process. Set target dates by task and track against them.

Native Xero vs. Xero + Numeric

The below chart applies to Xero’s standard offerings and not actions that may be available in Xero’s Partner Hub.

Capability	Native Xero	Xero + Numeric
Close checklist and task management	No closing checklists, task assignments, due dates, or dependencies	Shared checklist with owners, due dates, dependencies, and real-time status
Bank reconciliation	Bank feeds, suggested matches, and bank rules handle ongoing transaction matching	Xero continues to handle transaction matching. Numeric reconciles the month-end account balance against your supporting schedule.
Non-bank reconciliation (prepaids, accruals, deferred revenue)	No schedule or subledger. Managed in spreadsheets, posted back as manual journals	Your workpaper stays where it lives and links to the Xero account, so the balance ties automatically
Fixed assets	Fixed asset register with automated depreciation	Register stays in Xero. The reconciliation of the register to the GL balance is tracked, reviewed, and signed off.
Reviewer workflow and sign-off	User permissions only. No preparer and reviewer roles in the close	Preparer and reviewer roles, review notes, and comment threads anchored to the account
Audit trail	History and Notes on individual records. Nothing tying a schedule to the entry it supports	Every comment, submission, review, and approval logged with timestamp and user
Auto-submitted reconciliations	Not available	Accounts that tie out within your materiality threshold submit automatically, and changes after sign-off are flagged
Multi-entity close visibility	Each entity is treated as a separate organization. No consolidation, no cross-entity view available.	Tasks tagged by entity, so every entity's close sits in one checklist
Real-time close visibility for leadership	No native real-time close dashboard or close-status tracking for leadership	Live dashboard of close progress, open items, and reviewer status

Getting Your Xero Close Under Control

A clean Xero month-end close comes down to the same handful of moves every period:

Collect the source documents.
Record the month’s activity.
Reconcile the bank accounts against the feed.
Work the balance sheet accounts against their supporting schedules.
Review the statements.
Publish a reporting pack with commentary.
Set the lock date.

Xero does this well with reliable transaction matching, fixed asset depreciation, and publish-ready snapshots to support the work.

However, there are areas outside the ledger that lack critical processes for a reliable month-end close. These gaps include:

A closing checklist
Preparer and reviewer workflows
Schedules for prepaids, accruals, and deferrals
Shared views for leadership of where the close stands
Data consolidation for multi-entity companies

While spreadsheets and other third-party tools often help to fill in the holes, they are prone to errors and inconsistencies. Connecting those tools to Xero, so balances tie out automatically and reviews happen in one place, cuts down on manual errors during the month-end close.

Numeric can help support your team in this area with guides and templates geared toward strengthening your month-end close process. For the broader process outside of Xero specifically, Numeric’s month-end close primer is the place to start.

If your team has hit the point where Xero’s native tools are not keeping up, see how Numeric extends Xero for the close.

If your accounting has grown more complex than Xero was built to handle, explore Numeric's ERP replacement, the Financial Data Platform (FDP). Its data-centric accounting model keeps the full context of every transaction in one place, giving your team more flexibility and functionality than Xero.

Either way, schedule a demo to see how Numeric fits your Xero setup.

Frequently Asked Questions

From a literal standpoint, Xero doesn’t have a consolidated close option. Rather, it has a lock date, which stops users from adding or changing transactions on or before that date. To lock a period, go to the Accounting menu, select Accounting settings, click Financial settings, enter your date under Lock Dates, choose which users the lock applies to, and save. In practice, teams treat the lock date as the close: finish the reconciliations, publish the reports, then lock. You can also reconcile and close a bank period for a chosen date range, but that is separate from adding a lock date.

They do different jobs. Your financial year-end date tells Xero what 12-month period your reports and fiscal year covers. It sets the date range for the profit and loss and drives how the year rolls over. A lock date is a control. It stops people from changing transactions in a period you have already reported on. You will typically set lock dates monthly throughout the year, and change the financial year end date almost never.

Not in the way you would reconcile a bank account. Xero has no prepaid or accrual schedule, so the supporting detail generally lives in a spreadsheet and a user posts it as a manual journal. Repeating manual journals make reconciliation easier, but the schedule itself and the tie-out between the schedule and the Xero balance both happen outside the platform. That is the gap most Xero teams end up filling with an integrated reconciliation layer.

Anyone who sets or changes a lock date needs adviser permissions. Xero restricts lock dates to users with the adviser role, which means a standard user cannot lock a period even if they own the close. It is worth auditing your user roles before month-end rather than discovering the restriction while trying to close.

That number depends on your organization. For a single-entity business with clean bank feeds and a decent set of bank rules, three to five business days is a realistic target. Teams that reconcile weekly will likely close faster than teams that save everything for month-end. The number of manual balance sheet schedules, unreconciled items parked in suspense accounts, and handoffs between people can add to your close time.

Track your own close over three or four months and identify the tasks that consistently sit unfinished the longest. Unblocking those processes can help speed up your close process.

No. Each legal entity lives in its own Xero organization with its own chart of accounts and its own subscription, and Xero has no native consolidation or intercompany elimination features. Group reporting requires exporting each entity’s balance sheet and income statement separately, in addition to assembling the consolidation manually. Teams running more than one entity usually add a third-party consolidation tool or a close platform that can span entities.