Skip to content
Workflow · Calculate · Opening soon

Supplier invoice PDFs to a Xero bill import file

Read each supplier invoice PDF into one row per printed line, then map each line to Xero's bill import columns. Your supplier settings give the Xero contact and payment terms, your coding rules give the account code, and each line's VAT rate gives Xero's tax type.

Early access opens shortly. Check back soon.

Someone typed

“turn the supplier invoice lines and supplier settings into xero bill import rows for xero, using the coding rules; match suppliers with a lower-cased key, keep quantities and unit prices, set due dates, tax type, and show check as agrees, new supplier, total differs, or no account code.”

The agent read it as

turn the Supplier invoice lines and Supplier settings into xero bill import rows for xero, using the Coding rules; match suppliers with a lower-cased key, keep quantities and unit prices, set due dates, tax type, and show check as agrees, new supplier, total differs, or no account code, using UK Xero VAT tax types.

What the agent built

6 steps, each one an ordinary Mammoth step you can open and change.

  1. File
    Supplier invoice lines
    CSV export · 40 rows
  2. File
    Supplier settings
    CSV export · 8 rows
  3. File
    Coding rules
    CSV export · 17 rows
  4. Step
    Make supplier key
    Step 1
  5. Step
    Make settings supplier key
    Step 2
  6. Step
    Group coding rules by supplier
    Step 3
  7. Join
    Bring in supplier settings
    30 of 40 paired
  8. Join
    Bring in coding rules
    40 of 40 paired
  9. Step
    Build Xero bill import rows
    Step 6
  10. Result
    Xero Bill Import Rows
    40 rows
  11. Schedule
    Runs when you say
    Proposed

On the sample files, every step runs and the result has 40 rows.

What you get back

The result of that run, the rows to look at first.

Xero Bill Import RowsSample data40 rows
ContactNameInvoiceNumberInvoiceDateDueDateDescriptionQuantityUnitAmountAccountCodeTaxTypeCheck
CleanServe Catering Supplies LtdCS-44062026-10-312026-10-31Disposable gloves402.2543320% (VAT on Expenses)New supplier
CleanServe Catering Supplies LtdCS-44062026-10-312026-10-31Cling film rolls64.8042920% (VAT on Expenses)New supplier
CleanServe Catering Supplies LtdCS-44062026-10-312026-10-31Sanitiser spray123.1043320% (VAT on Expenses)New supplier
CleanServe Catering Supplies LtdCS-44062026-10-312026-10-31Paper takeaway boxes2000.3242920% (VAT on Expenses)New supplier
CleanServe Catering Supplies LtdCS-44062026-10-312026-10-31Foil trays1000.21·20% (VAT on Expenses)New supplier
CleanServe Catering Supplies LtdCS-44062026-10-312026-10-31Dish tabs47.50·20% (VAT on Expenses)New supplier
CleanServe Catering Supplies LtdCS-44062026-10-312026-10-31Broom heads28.40·20% (VAT on Expenses)New supplier
CleanServe Catering Supplies LtdCS-44062026-10-312026-10-31Black bin liners101.95·20% (VAT on Expenses)New supplier
CleanServe Catering Supplies LtdCS-44062026-10-312026-10-31Surface wipes82.60·20% (VAT on Expenses)New supplier
CleanServe Catering Supplies LtdCS-44062026-10-312026-10-31Aprons54.20·20% (VAT on Expenses)New supplier
GreenVale ProduceGV-11072026-11-072026-11-21English carrots201.20310Zero Rated ExpensesAgrees
GreenVale ProduceGV-11072026-11-072026-11-21Maris Piper potatoes250.80310Zero Rated ExpensesAgrees
40 rows in the result · 12 shown, problems first. Sample data: illustrative figures, not business results.

How it works

How to use the Xero Bill Import Rows workflow

  1. 1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and working on sample files.
  2. 2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
  3. 3Change it in words, then turn it onSay what to change and see the new result before anything saves. Then choose when it runs.

Xero Bill Import Rows: questions

How do you turn supplier invoice PDFs into a Xero bill import file?
Read each supplier invoice PDF into one row per printed line, then map each line to Xero's bill import columns. Your supplier settings give the Xero contact and payment terms, your coding rules give the account code, and each line's VAT rate gives Xero's tax type. The workflow makes one row per invoice line and flags new suppliers, invoices whose lines plus VAT don't match the printed total, and lines no coding rule covers.
What do you need besides the invoices?
Your supplier list with each supplier's Xero contact name and payment terms (Xero can export your contacts), and a short sheet of coding rules: the supplier, a word in the line description, and the account code to use.
What happens to rows that do not match a rule?
They are kept in the output and marked for review. For this workflow, a row can be flagged as a new supplier, a total mismatch, or no account code, so you can check it before importing.
How do you change the rules?
Edit the rules in words, then rerun the workflow. You can change which supplier name maps to which contact, which account code is used for each coding rule, and how tax text is assigned for each VAT rate.

Get early access to this workflow

It opens already built and working on sample files. Swap in your own exports to see your result.

Early access opens shortly. Check back soon.

Workflows like this

Schedules, commissions, costing and margins, worked out the same way from every new export.

All calculate workflows →