Check invoice coding against the supplier’s last exports

Before you export a Xero purchase invoice, see whether it’s coded the way the supplier’s last 3 exported invoices were, and exactly what’s different.

1:40 · Watch on YouTube ·

Before you start

  • A folder connected to Xero.
  • A purchase invoice that hasn’t been exported yet, matched to a Xero contact whose earlier invoices you exported from Datamolino.

Follow the workflow

5 steps with the real screens, at your own pace.

Check invoice coding against the supplier’s last exports
Green and amber

How it works

Green and amber

Datamolino compares each invoice with the supplier’s last 3 exported invoices. Green means every account, tax rate and tracking option was used before. Amber means something’s new.

  1. Open the purchase invoice and look at the strip above the Supplier section. Green, Coded as usual, means every account, tax rate and tracking option was used on the supplier’s last 3 exports.

  2. If the strip is amber, Coded differently, read the pill. It names what’s new, for example ACCOUNT 429.

  3. Click the strip to open the comparison: the values used on the last 3 exports on the left, this invoice on the right, with new values marked New.

  4. Hover a value to see each past export’s date and invoice number, and what it used.

  5. Click an invoice number under Last 3 exports to open that invoice in a new tab. To change the coding, edit the invoice as usual and save.

Full guide: Coding history: check coding against past exports

Good to know

  • Coding history is for folders connected to Xero. Folders connected to QuickBooks or FreeAgent don’t show the strip.
  • The strip compares with invoices from the same supplier exported from Datamolino, and updates when you save the invoice.
  • Changing the export detail alone, for example from Invoice Total to Line Items, keeps the strip green. The comparison still marks the Export detail row New.
  • The strip only shows a comparison. It doesn’t contact Xero, suggest coding or change it.

Transcript

Before you export a supplier invoice to Xero, coding history shows whether it’s coded the way that supplier’s last invoices were.

Datamolino compares each invoice with the supplier’s last 3 exported invoices. Green means every account, tax rate and tracking option was used before. Amber means something’s new.

Open an invoice that’s ready to export. The strip sits above the coding. Green means it’s coded as usual and matches the last 3 exports.

Now the face masks line goes to account 429. Save, and the strip turns amber. The pill names what’s new, and the line below lists what’s as usual.

Click the strip to open it. You’ll see the usual account, tax rate, tracking and export detail beside this invoice. Anything new is marked New.

Each square is one past export, oldest on the left, newest on the right. A dark square means that export used the value.

Hover a value to see each export’s date and invoice number, and what it used. All 3 used 310, not 429. And 325 was used on the newest export only.

To check one, click its invoice number at the bottom. It opens in a new tab.

So before you export, you see at a glance whether an invoice is coded as usual, and exactly what’s different.

You’ll find more guides in the Datamolino Help Centre.