How to apply a Xero customer prepayment to a sales invoice
Key facts
How do you apply a customer prepayment in Xero? Record and reconcile the advance as a prepayment for the customer. Apply the available credit to their approved sales invoice. A £500 prepayment on a £1,600 invoice leaves £1,100 due.
This guide is not legal advice and laws/rules may change; consult a qualified professional for personalized assistance. Use at your own risk.
Confirm what the customer paid for
Check the bank receipt and the customer’s remittance or order reference. An intentional advance for future work, received before you raise the sales invoice, fits Xero’s prepayment workflow. If a customer accidentally pays £500 more than they owe on an existing invoice, match the amount due to that invoice and record the excess as an overpayment. If you cannot identify the payer or the intended work, follow up before assigning the funds to a contact.
Record the receipt and allocate it later
- Record the advance once. During reconciliation of a bank account in your organisation’s base currency, record the incoming £500 as a prepayment for the confirmed customer. If the prepayment already exists in Xero, match the bank line to that record. Keep the receipt date, bank reference and order reference together.
- Check the approved invoice. When the sales invoice is raised, compare the Xero contact, order reference and currency on both records. Verify that the invoice has an open balance and that the advance is still available.
- Apply the credit. Allocate the £500 prepayment to the agreed invoice. Open both records to check the allocation. The bank still has one £500 receipt, dated when the advance arrived.
Worked example from bank receipt to £1,100 due
In this fictional example, on 3 September Calder Lab Services pays a £500 advance against order PO-762. You match the bank line to the remittance and record a £500 prepayment. In this example GBP is the organisation’s base currency.
On 10 September, you approve INV-208 for £1,600 with a 10 October due date. On 12 September, you allocate the £500 credit. The prepayment has £0 left to allocate, INV-208 shows £1,100 outstanding, and the reconciled bank receipt remains £500. On a 30 September review, the £1,100 is open and becomes overdue only after 10 October if it remains unpaid.
To check for other advances awaiting allocation, run Xero’s Receivable Invoice Detail report for the relevant date range with prepayments included. Review the approved prepayments and their remaining balances. An unallocated advance is customer credit, so trace it to the underlying order separately from any overdue invoice.
Verify the amount before following up
Quote INV-208 and £1,100 in your next follow-up. If the customer asks how the advance was used, the Xero prepayment PDF can show the allocation. Review Xero’s steps for recording a prepayment and its guide to viewing and reporting prepayments. See the Xero aged receivables guide for the follow-up on open invoice balances.


.webp)