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.
Xero has a built-in "Prepayments" feature in Accounts Payable that is easily confused with prepaid expense accounting. Here's what each one is for and when to use which.
Xero has a feature called "Prepayments" in the Accounts Payable module. Many finance teams assume this handles prepaid expense accounting — but it does not. Understanding the difference between Xero's AP prepayment feature and proper prepaid expense accounting prevents a common and costly bookkeeping error.
In Xero, you can record a "prepayment" in Accounts Payable when you pay a supplier before receiving a bill. This creates a credit on the supplier's account that can be applied to a future bill. It is designed for situations like paying a deposit to a supplier or making an advance payment against a purchase order.
This is a cash management and AP workflow feature. It has nothing to do with amortizing a prepaid expense over time. When you apply the prepayment to a bill, the full cost hits the expense account in one go — there is no spreading of cost over multiple periods.
Prepaid expense accounting is something you have to build manually in Xero. You code the original payment to a balance sheet account (e.g., "Prepaid Insurance"), then post monthly manual journal entries to amortize the balance to the expense account over the coverage period. Xero has no built-in amortization schedule or automation for this.
Finance teams new to Xero often use the AP Prepayment feature for things like annual insurance or software licences, then wonder why the full expense appears on the P&L in one month. The answer is that they used the wrong tool. The AP Prepayment feature is for matching payments to bills — it is not an amortization mechanism.
Rule of thumb: If the benefit is received entirely in the current period, use Xero's AP prepayment or simply post the bill as normal. If the benefit spans multiple future periods, code the payment to a prepaid asset account and set up a manual amortization schedule.
Rather than managing amortization schedules manually in a spreadsheet alongside Xero, tools like CloseKit let you enter prepayments once, set the coverage period, and automatically calculate the monthly journal entries. The Xero integration (coming soon) will push those journals directly to Xero, eliminating the manual step entirely.
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.
Learn how to correctly record, track, and amortize prepaid expenses so your balance sheet is always accurate — without Excel.
How to structure your Xero chart of accounts so that prepayments and accrued liabilities are easy to track, reconcile, and audit.
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.