How to Reconcile Prepayments in Xero: Step-by-Step
A practical walkthrough for reconciling prepaid expenses in Xero, including where the built-in tools fall short and how to fill the gaps.
How to structure your Xero chart of accounts so that prepayments and accrued liabilities are easy to track, reconcile, and audit.
A well-structured chart of accounts is the foundation of clean financial reporting. In Xero, the default chart of accounts is a reasonable starting point, but it rarely has enough detail for proper prepayment and accrual tracking. Finance teams that bolt on extra accounts as an afterthought end up with inconsistent naming, duplicate accounts, and reconciliation headaches.
Every prepayment needs two accounts: a balance sheet account (the prepaid asset) and an expense account (where the amortized expense lands). The same logic applies to accrued liabilities — you need a liability account and a corresponding expense account. If you commingle these, reconciliation becomes unreliable.
For most small-to-mid-sized businesses, having separate prepaid accounts for insurance, software, rent, and a catch-all "Other Prepayments" account is sufficient. On the liability side, separate accounts for payroll accruals, professional fees, and general accrued expenses cover the common cases.
Rule of thumb: If a prepayment or accrual type appears on your balance sheet every month, it deserves its own account. If it appears once or twice a year, it can go in the "Other" account.
In Xero, go to Accounting > Chart of Accounts > Add Account. Choose "Current Asset" for prepaid accounts and "Current Liability" for accrued liability accounts. Assign a unique account code and a clear name. Lock any accounts you do not want staff to post to directly using Xero's account lock feature.
Review your chart of accounts at least once a year. Archive any accounts that are no longer in use. Check that account names still match the types of transactions posted to them. A clean chart of accounts makes every other part of month-end close faster.
CloseKit replaces your spreadsheets with instant balance sheet reconciliations. Start a free trial — no credit card required.
A practical walkthrough for reconciling prepaid expenses in Xero, including where the built-in tools fall short and how to fill the gaps.
How to structure your chart of accounts for prepayments and accruals — including account types, numbering conventions, and common mistakes.
The chart of accounts is the backbone of your financial reporting. Here is how to design one that makes month-end close and reconciliation easier.
Xero is great for day-to-day bookkeeping, but it lacks the tools finance teams need for proper prepayment management. Here is what is missing.