Xero GL Reconciliation: How to Match Your Xero Balance to Your Schedules

The core purpose of a balance sheet reconciliation is simple: prove that every balance in your general ledger is supported by a schedule or document you can stand behind. For prepaid expenses and accrued liabilities in Xero, this means reconciling the GL account balance to a schedule of individual items.

What You Are Reconciling

You have two things: (1) the Xero GL balance — what Xero shows in the prepaid asset or accrued liability account as of the last day of the period; and (2) your supporting schedule — a list of individual prepayments or accruals with their current balances as of the same date. The reconciliation is the process of proving these two figures agree.

Step 1: Pull the Xero GL Balance

In Xero, run the Balance Sheet report as at the last day of the period. Drill into the relevant account (e.g., "Prepaid Insurance" or "Accrued Expenses") to see the closing balance. Note this figure — it is the number you need to reconcile to.

Step 2: Run Your Supporting Schedule

Your supporting schedule should be a list of every active prepayment or accrual, with the balance remaining as of the same date. If you are using a spreadsheet, apply your amortisation formulas as of the period-end date. If you use a tool, generate the "as of date" report.

Step 3: Compare and Identify the Variance

Total the schedule balances. Compare to the Xero GL balance. If they match: reconciled. If they do not: you have a variance to investigate.

Step 4: Investigate the Variance

When there is a difference between your schedule total and the Xero GL balance, work through these common causes:

• A new prepayment was added to the schedule but the journal entry was never posted in Xero
• A journal entry was posted in Xero to the wrong GL account
• An amortisation entry was posted for the wrong amount (e.g., £1,000 instead of £1,100)
• A prepayment reached zero on the schedule but a residual balance remains in Xero from a prior error
• A refund or adjustment was posted in Xero but not reflected in the schedule
• A duplicate journal entry was accidentally posted in Xero

Step 5: Post Corrections and Recheck

Once you identify the root cause, post a correcting journal entry in Xero (or update your schedule, if the error was in the schedule). Rerun the comparison. Repeat until the variance is zero.

Step 6: Document the Reconciliation

Before moving on, save your reconciliation workpaper: the Xero GL balance, the schedule total, confirmation they match, and any notes about corrections made. This is your audit evidence.