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
1451	1452	PMT-31511	Receipt	02/26/2026	C-0200	Ember Lane Grocers	CHECK	5345	USD	11,590.08	1.0000	11,590.08

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