Import #1: ledgerpro_trial_balance_by_period.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: 924
Quarantined: 0
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	Description	Period Ending	Debit	Credit
918	919	6999	Suspense – Clearing	06/30/2026	2,315.77
919	920	7100	Foreign Exchange Gain/Loss	06/30/2026		1,204.17
920	921	7200	Interest Expense

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	Blank	Distinct	Max length	Patterns	Ambiguous dates
Account	0	132	4	integer 924	0
Description	0	132	38	—	0
Period Ending	0	7	10	date mm dd yyyy 924	0
Debit	120	255