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.
A step-by-step guide to recording accrued expenses in Xero using manual journals, plus the limitations finance teams hit at month-end and how a dedicated tool helps.
Xero is excellent for day-to-day bookkeeping, but accruals — expenses incurred but not yet invoiced — require manual effort every month. Unlike bank transactions or bills, accruals have no source document, so Xero will never pick them up automatically. You have to post a manual journal to recognise the expense, then reverse it when the invoice arrives.
An accrual is a liability you owe at the balance sheet date for services or goods already received but not yet billed. Common examples: legal fees where the work is done but the invoice has not arrived, electricity charges not yet billed, contractor time completed in the period, and payroll for days worked but not yet paid.
At month-end, go through your open purchase orders, recurring contracts, and any services you know were delivered but for which you have not received an invoice. Your goal is to capture every significant expense that falls in the current period. Materiality thresholds vary — many teams only accrue items above £500 or £1,000 to keep the process manageable.
In Xero, go to Accounting > Manual Journals > New Journal. Date the journal to the last day of the period. Debit the relevant expense account and credit your "Accrued Expenses" liability account (typically in the Current Liabilities section of the chart of accounts). Add a description that identifies the supplier and the period — for example, "Accrue legal fees — June 2026".
Best practice: Use a dedicated "Accrued Expenses" account rather than a generic liability account. This makes the balance sheet reconciliation much cleaner and lets you see your total accrued liability at a glance.
When the invoice arrives in the following month, you need to reverse the accrual so the expense is not double-counted. In Xero, open the original manual journal and click "Reverse" — this creates an equal and opposite journal dated the first day of the next period. Then code the actual invoice to the expense account as normal.
CloseKit is building a direct Xero integration that will let you manage accruals in CloseKit and push the journal entries to Xero automatically. You will be able to track which accruals are open, which have been reversed, and see the full history — without leaving CloseKit. The integration is coming soon.
Coming soon: CloseKit's Xero integration will let you sync accrual journal entries directly from CloseKit into Xero, with automatic reversal reminders and a full audit trail.
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.
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.
Accrued liabilities are easy to forget and hard to reconcile in Excel. Here is a better way to record, track, and reverse them every month.
How to structure your Xero chart of accounts so that prepayments and accrued liabilities are easy to track, reconcile, and audit.