How to Reconcile Prepayments in Xero: Step-by-Step

Xero handles invoicing and bank feeds well, but its prepayment tracking is minimal. If you pay an annual software licence or insurance premium, Xero records the payment — but it does not automatically amortize the prepaid asset over time. That means your balance sheet will overstate prepaid assets and understate expenses unless you create manual journal entries every month.

Where Xero Tracks Prepayments

In Xero, prepayments typically live in a balance sheet account such as "Prepayments" or "Prepaid Expenses" under Current Assets. When you code a bill to this account, the amount sits there until you manually move it to the expense account via a journal entry. Xero has no built-in amortization schedule.

Step 1: Identify All Prepaid Items

Start by running the Balance Sheet report in Xero as of the last day of the prior month. Look at every line in your prepaid asset accounts. Each balance should correspond to a known prepayment — insurance, software, rent, or similar. If you find a balance you cannot explain, investigate the transactions in that account.

Step 2: Calculate Monthly Amortization

For each prepayment, divide the original amount by the number of months in the coverage period. This gives you the monthly expense amount. For a £12,000 annual insurance policy, the monthly amortization is £1,000.

Step 3: Post Journal Entries

In Xero, go to Accounting > Manual Journals. Create a journal entry dated the last day of the month. Debit the expense account and credit the prepaid asset account for the monthly amount. Repeat for each prepayment.

Step 4: Reconcile the Balance

After posting all journal entries, re-run the Balance Sheet report. The prepaid asset balance should now equal the sum of all remaining unamortized amounts. If there is a discrepancy, check for missed entries, double-posted journals, or new payments coded to the account.

Where Xero Falls Short

• No amortization schedules — you must calculate and post every entry manually
• No schedule-to-GL reconciliation — you have to verify balances yourself
• No audit trail showing why a prepayment was adjusted or terminated early
• No as-of-date view — you can only see the balance as of today or by running historical reports
• Partial refunds and early terminations require manual adjustments with no built-in workflow

A Better Approach

A dedicated prepayment tracker sits alongside Xero and handles the amortization automatically. You enter the prepayment once, set the schedule, and the tool calculates the monthly expense. At month-end, you export the journal entries and post them to Xero — or sync them directly if the integration supports it.