Finance operations · Browser-local preflight
Xero Invoice & Bill CSV Import Validator
Preflight invoice and bill CSV/XLSX files locally before Xero import, with explicit mapping, row-level errors, unresolved organisation references, normalized CSV output, and deterministic batch splitting.
Your uploaded CSV/XLSX stays in this browser. UsefulBox does not send source rows to Xero or to our server.
Preflight only: no Xero login, OAuth, API write, account-code choice, tax choice, or accounting conclusion.
1. Add the invoice or bill file
Use an existing Xero-style CSV or map a generic CSV/XLSX locally. The first row is treated as column headings.
No file selected.
2. Map columns
Required mappings mirror the conservative invoice/bill import fields used by this preflight. Optional columns may be left unused.
3. Confirm parsing preferences
4. Optional local organisation references
Paste known values to verify exact organisation-specific references. Without a pack, non-empty ContactName, AccountCode and TaxType values remain UNRESOLVED instead of receiving a false PASS.
What this tool deliberately does not decide
- Whether an unknown ContactName should create a new Xero contact.
- Which AccountCode or TaxType is correct for your organisation.
- Whether a transaction is tax-compliant, correctly classified, or ready for accounting approval.
- Whether a live Xero organisation contains values not present in the optional local reference packs.
Related UsefulBox tools