Skip to main content

Coding history for Xero: check an invoice's coding against the supplier's last exports

See at a glance whether a Xero purchase invoice is coded like the supplier's last 3 exported invoices, and what is different.

Written by Tina

Catch coding mistakes before they reach Xero, not after.

Coding history compares each purchase invoice with the supplier's last 3 exported invoices. You see at a glance whether the invoice is coded as usual, and if not, exactly what is different. A wrong account, tax rate or tracking option stands out before you export, so you fix it in Datamolino instead of correcting it in Xero later.
​

How to check an invoice's coding history

  1. Open a purchase invoice.

  2. Look at the strip above the Supplier section.

  3. Click the strip to open the comparison. The left column shows the values used on the last 3 exports. The right column shows this invoice, and new values are marked New.

  4. Hover a value to see each of the last 3 exports, oldest first: its date, its invoice number, and whether it used that value or what it used instead.

  5. To look at one of those invoices, click its invoice number under Last 3 exports. It opens in a new tab.

Green or Amber strip - what they mean

🟢 Green, "Coded as usual": every account, tax rate and tracking option on this invoice was used on at least one of the supplier's last 3 exports.

Coding history strip in green showing “Coded as usual” above the Supplier section of a Xero purchase invoice: the invoice is coded the same way as the supplier’s last 3 exports.

🟠 Amber, "Coded differently": at least one value is new. The pill names it, for example ACCOUNT 429.

Coding history strip in amber showing “Coded differently” with a pill naming the new value, above the Supplier section of a Xero purchase invoice: something on the invoice was not used on the supplier’s last 3 exports.

👉 How do I see exactly what’s different?

Click the strip to open it. You’ll see two columns:

  • Usual on last 3 exports (left): the account, tax rate, tracking and export detail the supplier’s last 3 exports used.

  • This invoice (right): what this invoice uses. A value that matches shows Same as usual, and a value that’s new is marked New, for example NEW 429 General Expenses.

Opened coding history strip comparing the values usual on the supplier’s last 3 exports with this invoice: account, tax rate, tracking and export detail, with new values marked New and links to the last 3 exported invoices.

👉 I updated coding but the strip didn't change

The strip updates when you save the invoice. While you are still editing, it shows the result for the invoice as last saved. You have to click save to save your new coding and the strip will update accordingly.

👉 Can I change the coding from the strip?

No. The strip only shows a comparison. It does not suggest or change any coding. To change the coding, edit the invoice as usual and save it.

What the strip compares

The strip compares this invoice with the last 3 exported invoices from the same supplier in the same folder. It compares four things:

  • Account: the ledger codes (Xero accounts) used on the invoice or its lines.

  • Tax rate: the tax codes used.

  • Tracking: the tracking category options used, one row per tracking category.

  • Export detail: whether the invoice is exported as Invoice Total, Tax Summary or Line Items.

👉 How are line items compared?

Line items and Tax Summary lines are compared as a whole. A ledger code, tax code or tracking option counts as usual if it appeared on any line of the last 3 exports. Lines are not matched one by one, and it does not matter how many lines use a value. The small ×4 next to a value only shows how many lines on this invoice use it.

👉 The export detail changed but the strip stayed green.

Switching between Invoice Total, Tax Summary and Line Items never turns the strip amber, because the ledger codes, tax codes and tracking options are still compared either way. The change still shows when you open the strip: the Export detail row is marked New.

What the squares mean

Each value in the left column has small squares, one per past export, oldest on the left and newest on the right. A dark square means that export used the value.

Coding history comparison with a value hovered: the popover lists the last 3 exports with their date and invoice number, and the small squares next to each value show which past exports used it.

👉 What does a value with only some dark squares tell me?

It shows how recently the supplier used the value. One dark square on the right means only the newest export used it. Dark squares only on the left mean the supplier used it before, but not on the latest invoice. Hover the value to see the dates and invoice numbers.

Frequently Asked Questions

👉 Which invoices show the strip?

Purchase invoices that are in a folder connected to Xero, andhave not been exported yet. The strip also shows on approved invoices. Folders connected to QuickBooks or FreeAgent do not show the strip.

👉 Who can see the strip?

Everyone who codes and exports invoices in the folder. Users with the role "Approver only" do not see the strip.

👉 What happens on invoices with changes to many lines?

The strip finds every change, however many lines the invoice has. When it is closed, it names the first 2 changes and then shows how many more there are, for example +8 more. Open it to see them all. In each row, new values are listed after the usual ones.

👉 What if the supplier has fewer than 3 exported invoices?

The strip compares with the exports there are, for example "matches the last export". If the supplier has no exported invoices yet, there is no strip.

👉 Which past invoices count?

Only invoices from the same supplier that were exported from Datamolino. Changes made in Xero after the export are not taken into account.

👉 Why is a supplier amber on every invoice?

If a supplier's tracking option changes on every invoice, for example a new event or job each time, that option is new on every invoice, so the strip is amber. Open it and check that only Tracking is new and the account and tax rate are as usual.

👉 Does the strip check the coding in Xero?

The strip does not contact Xero. It only compares with invoices already exported from Datamolino.

Did this answer your question?