Payment terms and early-payment discounts in Xero

How Xero handles terms

In Xero, payment terms set due dates only: a number of days after the invoice date, days after the end of the invoice month, a day of the following month or a day of the current month. There is no early-payment discount field on terms. That means the due date is the only thing the terms calculate. If a supplier offers a discount for paying before the due date, that arrangement sits outside the terms record and needs its own control.

Set one agreed term per supplier and check the due date at entry. A term expressed as a day of the following month can push an invoice into a later payment run than a clerk expects, especially near month end. A term expressed as a number of days after the invoice date depends on the invoice date being entered correctly. When an invoice arrives, enter the invoice date and the agreed term in Xero, then confirm the due date before the invoice moves into a run. Keep any discount note in your AP checklist or supplier record, not in the terms field, because there is no early-payment discount field on terms.

A simple worked situation: a supplier sends INV-1043 with an agreed term. A clerk enters it in Xero. Later, a re-sent email arrives with the invoice number keyed as 1043, and a second entry is created. The two references differ by the prefix only. The due dates may also differ if the invoice date was keyed differently. Before the payment run, compare the supplier record, the invoice reference and the date window. That check catches the pair before both entries are paid.

Early-payment discounts

Because Xero payment terms set due dates only and there is no early-payment discount field on terms, treat a discount as a separate decision and a separate record. Before paying early, confirm the supplier's discount offer in writing, note the payment date that qualifies, and decide who approves the early payment. Compare the discount rate with your own cost of funds. If the discount is worth more than the cost of holding the cash, early payment can make sense; if not, keep the due date and preserve the cash.

A frequent failure is to pay early but leave the invoice at its full amount, so the payment is short and a balance remains. Another is to pay the full invoice and never claim the discount credit. Both create cleanup work. In Xero, the due date does not change because of a discount. The invoice total also does not change unless a credit is applied. Use a discount log outside the terms record, and match the payment, the expected discount and the supplier credit before you close the invoice.

Worked situation: a supplier offers a discount for payment before the due date. The clerk pays early but posts the full invoice amount, then asks the supplier for the discount as a credit. If the supplier agrees, apply the credit to the invoice. If the supplier does not agree, the discount was not captured and the early payment bought nothing. The control is simple: no early payment without an approved discount note and a named person responsible for obtaining the credit. Keep the note with the supplier record, and review open discount claims before the next statement reconciliation.

Mistakes to watch for

Re-keyed invoice numbers are a common source of duplicates. INV-1043 and 1043 look different as strings but can be the same supplier invoice. A clerk who matches only on the invoice number may miss the pair; a clerk who matches on vendor, amount and date windows is more likely to catch it. In Xero, the export places the supplier invoice number in Reference, so a comparison of Reference values is a practical first pass. Look for a value with and without a prefix, a leading zero or a hyphen.

The same supplier set up twice is another repeat mistake. Two supplier records can split payments, hide a credit and make statement reconciliation harder. Before adding a supplier, search on the legal name and on common trading names. If two records already exist, do not merge them casually while open invoices are in flight. Note which record holds the open items, route new invoices to one record, and check both records during the next payment run.

Statements paid as well as invoices create duplicates that look legitimate. A statement lists INV-1043 and other open items; a clerk enters the statement as a new invoice and pays it, while the original INV-1043 is also in the run. A statement is a summary, not a supplier invoice. Enter invoices, not statements, and use statement reconciliation to agree the open balance. If a statement payment has already gone out, ask the supplier for a credit back and apply it to the duplicate.

Re-sent payment runs are easy to miss when the same batch is released twice after a bank file issue or an approval loop. Check the payment run history and the bank debits before releasing a re-sent run. Also check discounts: a clerk may pay early to capture a discount, then fail to obtain the credit because the discount was never recorded outside the terms. Treat every early payment as an exception with an owner, a supplier confirmation and a follow-up date.

Checking past payments

Start with the Aged Payables Detail report (called Accounts Payable Aging Detail in the US edition) and Aged Payables Summary. Both display what is owed by supplier and age. Use them to find old balances, odd supplier records and items that should have cleared. Then export the detail you need and compare the Reference values. The supplier invoice number sits in Reference, so INV-1043 and 1043 can be lined up next to each other. Match on vendor, amount and date windows rather than on the invoice number alone.

A worked review: an export contains one row with INV-1043 and another with 1043. The supplier is the same and the date window overlaps. That is a candidate duplicate, not proof. Pull the supplier statement, confirm which entry the supplier has recorded, and check the bank for the payment. If both entries were paid, ask the supplier for a credit back. If only one was paid, void or correct the other entry in Xero before the next run. Record the outcome so the same pair is not reopened next month.

Use statement reconciliation as the closing check. Agree the supplier statement to open invoices, not to a new statement entry. If a duplicate payment is confirmed, request a credit back in writing and apply the credit to the correct invoice. Keep a simple log of duplicates found, credits requested and credits received. Review the log against the next Aged Payables Detail report so unresolved credits do not age out of view. The aim is a clean supplier balance, not a quick write-off.

Questions