Import #1: ledgerpro_gl_detail_2026H1.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: 9669
Quarantined: 1
Encoding: cp1252
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	Account	Account Description	Date	Period	Type	Num	Line	Doc No	Name ID	Name	Memo	Debit	Credit	Currency	Foreign Amount	Reversal Of
7539	7540	2000	Accounts Payable	06/22/2026	06/2026	Bill	JE-AP-21486	2	B-21486	V-1205	Methow Valley Apples

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.

Lines 9505–9506field count mismatchfield counts 11, 6

6410,Freight Rebates,04/30/2026,04/2026,General Journal,JE-2026-0412,3,,,,Rebate per
March agreement,,450.00,USD,,

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
Account	60	4	integer 9669	0
Account Description	60	38	—	0
Date	136	10	date mm dd yyyy 9669	3768
Period	6