Duemendby Atesen Software
Sign in

Guides / Xero dates

Bulk change due dates in Xero

Set a due date across sales invoices or bills with an old-to-new preview.

Checked 25 October 2026. Duemend writes only after you type the confirmation, and only to the organisation you chose. Xero can reject a date change (for example in a locked period); its ValidationException message appears on the affected row.

Before you begin

Choose Sales invoices or Bills. The list includes DRAFT, SUBMITTED and AUTHORISED invoices. Xero may reject changes on part-paid or locked-period documents.

  1. Sign in with Xero and open Invoices.
  2. Choose Sales invoices or Bills. Use status, Contact contains, invoice date range, due date range or Overdue only, then Load invoices. Refresh loads a fresh snapshot.
  3. Tick the invoices and choose Due date in Field. Select Fixed date, Shift by days, Days after invoice date, Organisation default payment terms or Weekend → next Monday.
  4. Choose Preview changes. Compare every old date and new date; unchanged rows are skipped.
  5. Type UPDATE n with the displayed count, then Update dates.
  6. Review the per-row results and Result CSV. History → View results → Undo restores successful changes within 30 days.

Import a prepared list

Open Import, choose the type and upload CSV or XLSX with InvoiceNumber, field and new date. Preview import shows unknown invoice numbers, wrong fields/statuses and bad dates per row.

Keep control of the result

Undo restores stored old dates on successful rows for 30 days. A date changed again since the update is skipped, so a later edit is preserved. Xero cannot clear a date again, so a date that was empty before the update stays in place; the preview says how many invoices this affects.

Load and Preview are free. Your first 10 successful rows per organisation are free, with no trial expiry. Maximum 1,000 rows per job; write calls contain at most 50 invoices. Reads above 10,000 invoices fail clearly without showing a partial list.

Official references: Xero invoices API and Xero payment terms.

What Duemend does

New dates on every invoice or bill you picked, with a result per row, a result CSV and Undo for 30 days.

Who it is for: Bookkeepers and credit controllers on Xero who need to move due dates, expected or planned payment dates on many invoices or bills at once.

Start free with XeroCompare plans

Free to connect and preview. First 10 date changes free, then $19 for 7 days or $12 a month, excl. VAT/sales tax.

Three steps

  1. Sign in with Xero

    You sign in on Xero’s own page and choose the organisation. Duemend never sees your Xero password.

  2. Pick invoices and new dates

    Filter, tick the invoices or bills, choose the field and a rule such as +14 days, or upload a CSV or Excel file. The preview shows every old and new date.

  3. Type UPDATE to confirm

    Type UPDATE and the number of changes, for example UPDATE 12. You get a result per row, a result CSV and Undo for 30 days.