Import #1: ledgerpro_invoices.csv

Original source

The file exactly as the legacy system exported it. Rows are stored once and never edited, so this is the evidence every canonical record and every finding traces back to.

parsed

Rows read: 1033
Quarantined: 0
Encoding: utf-8
Uploaded: 2026-09-22 05:11:23Z

Rows

Values are shown verbatim, including the whitespace and formatting the export contained.

Raw rows as read
Row	Lines	Invoice No	Customer ID	Customer Name	Invoice Date	Due Date	Terms	Currency	Subtotal	Tax	Total	Exchange Rate	Total (USD)	Balance Due	Status
912	913	INV-9878	C-0064	Juniper Hill Foods	12/05/2025	01/04/2026	Net 30	USD	22,982.46	0.00	22,982.46	1.0000

Quarantined rows

Lines the reader could not turn into a row. They are kept verbatim and excluded from every result, so anything here is missing from the migration.

Every row was read.

Profile

What the reader observed per column, used to suggest a column mapping and to flag ambiguous dates.

Column profile
Column	Distinct	Max length	Patterns	Ambiguous dates
Invoice No	1033	9	—	0
Customer ID	166	6	—	0
Customer Name	166	31	—	0
Invoice Date	146