How to check invoice coding against the supplier’s last exports
Open the purchase invoice before export and read the coding history strip. Green, Coded as usual, means every account, tax rate and tracking option was used on the supplier’s last 3 exported invoices. Amber, Coded differently, names the value that is new so you can check it before it reaches Xero.

Read the strip before you export
Most suppliers are coded the same way month after month. The risky invoice is the one that quietly differs: a new account, a different tax rate or a tracking option nobody meant to use. Coding history puts that check on the invoice itself. Before you export a purchase invoice to Xero, a strip above the Supplier section compares its coding with the supplier’s last 3 exported invoices in the same folder.
| Strip | What it means | What to do |
|---|---|---|
| Green, Coded as usual | Every account, tax rate and tracking option on this invoice was used on the last 3 exports | Export as normal |
| Amber, Coded differently | At least one value is new; the pill names it, for example ACCOUNT 429 | Open the strip and confirm the new value is intended |
| No strip | The supplier has no invoices exported from Datamolino yet, or the folder isn’t connected to Xero | Check the coding as you do today |
Check an invoice step by step
- Open a purchase invoice in a Xero folder that hasn’t been exported yet. The strip also shows on approved invoices.
- Read the colour and the pill. When the strip is closed it names the first 2 changes and then shows how many more there are, for example +8 more.
- 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, with new values marked New.
- 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.
- To look at one of those invoices, click its invoice number under Last 3 exports. It opens in a new tab.
- If the coding needs to change, edit the invoice as usual and save. The strip updates when you save; while you are still editing, it shows the result for the invoice as last saved.
What the strip compares
The comparison has four rows: Account (the Xero ledger codes on the invoice or its lines), Tax rate, Tracking (one line per tracking category) and Export detail (Invoice Total, Tax Summary or Line Items).
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 aren’t matched one by one, and it doesn’t matter how many lines use a value; the small “×4” next to a value only shows how many lines on this invoice use it.
Changing the export detail on its own doesn’t turn the strip amber, because the ledger codes, tax codes and tracking are still compared either way. The open comparison still marks the Export detail row New, so the change stays visible.
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. One dark square on the right means only the newest export used it; dark squares on the left only mean the supplier used it before but not on the latest invoice.
A worked example
A bookkeeper opens this month’s invoice from a regular supplier. The strip is amber and the pill reads ACCOUNT 429. The line below lists what is as usual.
They open the strip. On the left, account 310 Cost of Goods Sold has three dark squares; on the right, 429 General Expenses is marked New. Hovering 429 lists the three past exports with their dates and invoice numbers, and shows that all 3 used 310, not 429. Account 325 Direct Expenses has one dark square on the right, so only the newest export used it.
The bookkeeper clicks the most recent invoice number, checks it in the new tab and decides 429 was picked by mistake. They change the line back to 310 and save. The strip turns green, Coded as usual, and the invoice is ready to export.
When amber is expected
Some suppliers will be amber on every invoice, and that can be correct.
- A new tracking option each time. If you track by event, job or project, the option is new on every invoice. Open the strip and check that only Tracking is new and the ledger code and tax code are as usual.
- Fewer than 3 exports. The strip compares with the exports there are, for example “matches the last export”. With no exported invoices from the supplier, there is no strip.
- A genuine change. A supplier that now sells you something different needs a new account. Confirm it once, export, and from then on it is part of the history the next invoices are compared with.
What the strip does not do
The strip only shows a comparison. It doesn’t contact Xero, doesn’t suggest coding and doesn’t change any value. It compares with invoices from the same supplier exported from Datamolino, using the coding saved on them at the time.
Coding history is available for folders connected to Xero. Folders connected to QuickBooks or FreeAgent don’t show the strip. Everyone who codes and exports invoices in the folder sees it; users who only approve invoices don’t see it on the Approvals page.
It works alongside the coding you already automate. Supplier defaults and keyword rules apply rules saved from your own coding decisions; coding history shows, invoice by invoice, whether the result still matches what you exported before. See the Xero integration for how export works.


