Supplier invoice PDFs to a Xero bill import file
“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.”
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.
- FileSupplier invoice linesCSV export · 40 rows
- FileSupplier settingsCSV export · 8 rows
- FileCoding rulesCSV export · 17 rows
- StepMake supplier keyStep 1
- StepMake settings supplier keyStep 2
- StepGroup coding rules by supplierStep 3
- JoinBring in supplier settings30 of 40 paired
- JoinBring in coding rules40 of 40 paired
- StepBuild Xero bill import rowsStep 6
- ResultXero Bill Import Rows40 rows
- ScheduleRuns when you sayProposed
On the sample files, every step runs and the result has 40 rows.
- Download Supplier invoice lines sample (40 rows)Mammoth: drop the supplier invoice PDFs on New workflow; it reads one row per printed line
- Download Supplier settings sample (8 rows)Xero: Contacts > Suppliers > Export, with each supplier's payment terms
- Download Coding rules sample (17 rows)A sheet you keep: supplier, a word in the line description, and the account code
What you get back
The result of that run, the rows to look at first.
| ContactName | InvoiceNumber | InvoiceDate | DueDate | Description | Quantity | UnitAmount | AccountCode | TaxType | Check |
|---|---|---|---|---|---|---|---|---|---|
| CleanServe Catering Supplies Ltd | CS-4406 | 2026-10-31 | 2026-10-31 | Disposable gloves | 40 | 2.25 | 433 | 20% (VAT on Expenses) | New supplier |
| CleanServe Catering Supplies Ltd | CS-4406 | 2026-10-31 | 2026-10-31 | Cling film rolls | 6 | 4.80 | 429 | 20% (VAT on Expenses) | New supplier |
| CleanServe Catering Supplies Ltd | CS-4406 | 2026-10-31 | 2026-10-31 | Sanitiser spray | 12 | 3.10 | 433 | 20% (VAT on Expenses) | New supplier |
| CleanServe Catering Supplies Ltd | CS-4406 | 2026-10-31 | 2026-10-31 | Paper takeaway boxes | 200 | 0.32 | 429 | 20% (VAT on Expenses) | New supplier |
| CleanServe Catering Supplies Ltd | CS-4406 | 2026-10-31 | 2026-10-31 | Foil trays | 100 | 0.21 | · | 20% (VAT on Expenses) | New supplier |
| CleanServe Catering Supplies Ltd | CS-4406 | 2026-10-31 | 2026-10-31 | Dish tabs | 4 | 7.50 | · | 20% (VAT on Expenses) | New supplier |
| CleanServe Catering Supplies Ltd | CS-4406 | 2026-10-31 | 2026-10-31 | Broom heads | 2 | 8.40 | · | 20% (VAT on Expenses) | New supplier |
| CleanServe Catering Supplies Ltd | CS-4406 | 2026-10-31 | 2026-10-31 | Black bin liners | 10 | 1.95 | · | 20% (VAT on Expenses) | New supplier |
| CleanServe Catering Supplies Ltd | CS-4406 | 2026-10-31 | 2026-10-31 | Surface wipes | 8 | 2.60 | · | 20% (VAT on Expenses) | New supplier |
| CleanServe Catering Supplies Ltd | CS-4406 | 2026-10-31 | 2026-10-31 | Aprons | 5 | 4.20 | · | 20% (VAT on Expenses) | New supplier |
| GreenVale Produce | GV-1107 | 2026-11-07 | 2026-11-21 | English carrots | 20 | 1.20 | 310 | Zero Rated Expenses | Agrees |
| GreenVale Produce | GV-1107 | 2026-11-07 | 2026-11-21 | Maris Piper potatoes | 25 | 0.80 | 310 | Zero Rated Expenses | Agrees |
How it works
How to use the Xero Bill Import Rows workflow
- 1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and working on sample files.
- 2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
- 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?
What do you need besides the invoices?
What happens to rows that do not match a rule?
How do you change the rules?
Get early access to this workflow
It opens already built and working on sample files. Swap in your own exports to see your result.
Workflows like this
Schedules, commissions, costing and margins, worked out the same way from every new export.
- Pivot table from raw dataTurn a raw sales export into a pivot table of revenue by region and month.See the workflow Built by the agent
- Real estate commission splitWork out real estate commission on each closed sale and split it between the listing agent, buying agent and brokerage.See the workflow Built by the agent
- Loan amortization from statementsBuild a monthly loan amortization schedule from an Excel export, with interest, principal, and remaining balance for each loan.See the workflow Built by the agent
- Accrued expenses scheduleBuild an accrued expenses schedule from QuickBooks exports. Match purchase orders to vendor bills, calculate unbilled amounts, and flag items that need accrual.See the workflow Built by the agent
- RFM segmentsEvery customer scored 1-5 on recency, frequency and spend, with a segmentSee the workflow Template
- Sales velocityEach rep's open deals, win rate, deal size, sales cycle and velocity, and the team'sSee the workflow Template