About Services Tools Blog Contact us

Accounts Change Extract

Lists every record changed in Xero since a date you choose, so a period can be rechecked after a return is prepared. It only reads and never changes your accounts.

  • Scheduled Workers & Sync
  • Professional services
  • Tool
  • Bespoke
  • Local/private
  • 2026

The problem

After a return is prepared, people keep editing records in Xero and the edits are easy to miss. A full backup holds everything, so it does not show the short list of what changed. A tool that wrote changes back could make the recheck worse.

What it does

A person runs it from a terminal, never from the website, and gives it a start date and a file location. It connects to Xero with the saved sign-in and collects records updated since that date, including a watched set of bank accounts. It saves a file of changes for a person to review and sends nothing back to Xero.

Outcomes

  • A period can be rechecked from a list of changes instead of a full download.
  • Bank lines appear in the file beside the invoices.
  • A person reads the file and decides what to do.
  • Nothing is posted back to Xero.

Simplified mockup

Interactive preview with sample data. Nothing is sent to a server.

Accounts change extract

Read only
Since date

A date on or after 12 Mar 2026 returns an empty list. Nothing is posted back.

php accounts_delta.php \ --since=2026-02-14 \ --out=/var/recheck/delta.json
Run
Ready. CLI only.

Later window

Last change in the file was 21 Feb 2026. This window should come back empty.

Invoices in window
0
Expected before you run
Bank lines in window
0
Watched accounts still queried
Write-back
Off
Same rule as the first extract
Second run
Same script, later date.

Read only

Web server refusal
This script can only be run from the command line. exit 1

Invoked from the web server, it stops before any token is used.

No write-back
  • Reads invoices updated since the date
  • Reads the watched bank accounts
  • Writes one JSON file for a person
  • Does not create, edit or void anything in the accounts file
Watched bank accounts, included on every extract
AccountWhy it is watchedIn the 14 Feb delta
Business currentCustomer receipts1 line
DepositSweep after payrollNone
Tax holdingQuarter set-asideNone
Client moneyMust not be mixed into salesNone

How it works

  1. Stop if it is started from the website.
  2. Take a start date and a place to save the file.
  3. Connect to Xero with the saved sign-in.
  4. Collect records updated since that date, including watched bank accounts.
  5. Save the list of changes and stop. Nothing is written back.

Pipeline

flowchart LR
  Since["Since date"] --> Query["Changed records"]
  Tokens["Stored tokens"] --> Query
  Query --> Json["JSON delta"]
  Json --> Human["Human recheck"]