Clean a messy aged-debtors CSV before you chase.
Upload an export from Xero, Sage, QuickBooks, or a spreadsheet. SHVL maps common column names and exports the clean columns needed for the health check and chase-pack flow.
Free browser-side normaliser.
The page reads the CSV locally. Check the exported rows before using them for chasing or client work.
Choose a CSV or load the sample to normalise rows.
Column mapping
What the normaliser recognises.
Exports rarely use identical headings. The tool checks common alternatives for customer name, email, invoice number, due date, amount and notes, then writes them into a predictable order.
It is intended for aged-debtors exports and simple spreadsheet lists. If one row contains several invoices, split those invoices into separate rows before relying on totals or due dates.
Review before use
Check the clean file, not just the column names.
- Confirm amounts use the expected currency and decimal format.
- Check that dates have not been interpreted in US month-first order.
- Keep disputed, paid or sensitive accounts out of a chase batch.
- Verify customer email addresses against the accounting record.
Normalising a file does not validate whether a debt is due or whether a customer should be contacted.
Ready to chase the cleaned batch?
Use the health check first, then generate editable Word letters, email drafts, an Excel interest log, and README when the rows are ready.
Run health checkGenerate chase pack