Turn bank-statement PDFs into
rows for Excel
The most flexible destination for review and cleanup
Target outcome
Readable dates, descriptions, debit or credit values, and balances in columns.
Do not edit the only clean copy.
Download the reviewed ReconReady CSV, preserve it as the conversion output, and create a separate working copy for Excel & CSV. That keeps mapping changes traceable.
File lineage
Check the structure before the import.
Product requirements change. Use this as a control list, then compare it with Excel & CSV’s current help or sample file.
- 01Keep one clear header row
- 02Format dates consistently
- 03Use separate debit and credit columns or one signed amount consistently
- 04Retain descriptions without truncating useful references
- 05Compare totals and balances with the source PDF
A small test catches expensive mistakes.
Import one short period first. Compare the first date, last date, transaction count, movement total, and resulting bank balance with the PDF before continuing.
First and last date
01Transaction count
02Amount direction
03Description mapping
04Ending balance
05Duplicate check
06Guidance without false shortcuts.
Which bank supplied the PDF?
Prepare the source before Excel & CSV.
Convert the PDF, review the rows, and preserve a clean export before destination-specific mapping.
