Excel & CSV preparation guide

Turn bank-statement PDFs into
rows for Excel

Export clean transaction rows, filter or classify them in a spreadsheet, and retain the original PDF for review and audit context.

The most flexible destination for review and cleanup

Destination guide

Target outcome

Readable dates, descriptions, debit or credit values, and balances in columns.

01First principle

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

01Bank statement PDF
02ReconReady export.csv
03CSV_working_copy.csv
04Excel & CSV
02Preparation checklist

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.

  1. 01Keep one clear header row
  2. 02Format dates consistently
  3. 03Use separate debit and credit columns or one signed amount consistently
  4. 04Retain descriptions without truncating useful references
  5. 05Compare totals and balances with the source PDF
03Five-field audit

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

01

Transaction count

02

Amount direction

03

Description mapping

04

Ending balance

05

Duplicate check

06
04Excel & CSV questions

Guidance without false shortcuts.

05Start at the source

Which bank supplied the PDF?

10 pages / free trial

Prepare the source before Excel & CSV.

Convert the PDF, review the rows, and preserve a clean export before destination-specific mapping.