A Reconciliation Checklist for Converted Bank Statements

A machine-readable statement makes sorting faster, but it does not prove the converted data is correct. Keep the original file, work from a copy, and reconcile the output before importing it into a ledger. This checklist separates extraction errors from genuine transactions.

If your source is a PDF or image, bank file tool can be used to turn the statement into a table for review. I am connected with the tool. The checks below still matter no matter which converter you use: column labels, amount signs, duplicates, missing rows, and opening-to-closing balance.

Do not upload statements you are not authorized to process. Redact sensitive details before sharing a sample for troubleshooting, and retain the original statement as the reference of record.

liveswapface
Table View
Suggest Item
Use this list
Name
What to verify
Link

Preserve the original file and statement period

Inspect the imported column map

Normalize debits, credits, dates, and currency

Compare transaction count and date range

Flag duplicates, reversals, and missing lines

Reconcile opening and closing balances

Spot-check exported rows against the source