Import #1: ledgerpro_payments.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: 2054
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	Payment No	Type	Date	Name ID	Name	Method	Check/Ref No	Currency	Amount	Exchange Rate	Amount (USD)	Applied To	Applied Amount	Unapplied
1371	1372	PMT-31432	Receipt	02/09/2026	C-0186	Hawthorne Fresh Market	ACH	475684128274990	USD	20,626.27	1.0000	20,626.27

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
Payment No	1971	10	—	0
Type	2	12	—	0
Date	132	10	date mm dd yyyy 2054	838
Name ID	260