Root-cause analysis for prepayment and accrual reconciliation discrepancies in Xero — the most common causes, how to diagnose them, and how to prevent recurrence.
You run your monthly reconciliation. Your prepayment schedule says £28,400. Xero says £27,950. There is a £450 difference and you have no idea where it came from. This guide walks through the most common root causes and how to trace them.
Someone posted the monthly amortisation journal but debited the expense account against the wrong balance sheet account — perhaps "Prepaid Software" instead of "Prepaid Insurance". The schedule is right; Xero is split across two accounts incorrectly.
Diagnosis: Search Xero for all manual journals posted in the period. Look at every entry that touches a prepaid account. Check that the account code on each entry matches your schedule.
The schedule was updated with the new amortisation, reducing the balance — but no one posted the corresponding journal entry in Xero. The schedule has moved; Xero has not.
Diagnosis: Compare the number of amortisation entries you expect (one per active prepayment per month) against the manual journals posted in Xero for the period. Missing entries are immediately visible.
The journal was posted, but for an incorrect amount. This might be a typo (£1,000 instead of £1,100), a rounding difference, or an outdated template that used last month's amount.
Diagnosis: Match each Xero journal entry amount against the expected amortisation from your schedule, line by line. A mismatch is your culprit.
A prepayment was cancelled and a refund was received. The bank transaction was coded to the prepaid account in Xero, reducing the balance. But the schedule was not updated to reflect the early termination. Now Xero is lower than the schedule.
This is one of the most common causes of growing variances. Every adjustment to a prepayment — refunds, partial cancellations, amount corrections — must be reflected in both Xero and your schedule simultaneously.
The variance existed before this month — it was carried forward from a prior period that was never fully reconciled. The current month is clean, but the starting point was already wrong.
Diagnosis: Run the reconciliation for the prior month too. If the variance existed then, work backwards month by month until you find the period where it first appeared.
CloseKit's upcoming Xero integration will automatically compare your Xero GL balance against your CloseKit prepayment schedules each period. Variances are flagged immediately, with drill-down to the transaction level. Sign up at getclosekit.com to be notified at launch.
CloseKit replaces your spreadsheets with instant balance sheet reconciliations. Start a free trial — no credit card required.
The step-by-step process for reconciling a Xero GL account balance to a supporting schedule — prepayment amortisation tables, accrual registers — and how to investigate discrepancies.
Real-world scenarios of common month-end close errors: forgotten prepayments, miscalculated accruals, timing mismatches, and how structured processes prevent them.
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.