How to apply a Xero customer prepayment to a sales invoice

When a business customer pays before you raise their sales invoice, link the advance to that customer in Xero. Once the invoice is approved, allocate the advance and check that the invoice shows only the remaining amount due.
Upload a case

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.

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

  1. 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.
  2. 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.
  3. 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.

RELATED ARTICLES

Illustration of a free e-book representing the 'Free International Debt Collection Guide.' This guide offers proven debt collection techniques. Get your free copy now.
FREE GUIDE

Download our free debt collection guide

Practical steps to get unpaid invoices paid, at home and abroad. Download our debt collection guide for free.

Thank you! The guide will land in your inbox shortly
Oops! Something went wrong while submitting the form.