Checklist

Bank Statement Conversion Checklist

Use this checklist before, during, and after converting statement PDFs so the final spreadsheet or import file is reviewable.

Updated 2026-06-28

Before conversion

Start with the original monthly PDF statement when possible. Screenshots, copied text, and low-resolution photos create avoidable review work.

Confirm whether the file contains one account or several account sections. Multi-account PDFs should be reviewed section by section so balances remain meaningful.

  • Use the full statement period, not only visible transaction pages.
  • Keep cover pages and summary pages available for validation.
  • Use OCR mode only when the PDF is scanned or image-based.

During conversion

Select only the pages that contain relevant transaction data when page count matters. Preserve the source PDF so every converted row can be traced back to the statement.

  • Check that dates use the correct regional format.
  • Confirm whether the output uses one signed amount column or separate debit and credit columns.
  • Keep wrapped descriptions attached to the original transaction.

After conversion

Do not import the output into accounting software until the transaction count, opening balance, closing balance, and obvious totals have been checked.

  • Opening balance plus credits minus debits should equal closing balance for bank accounts.
  • Credit card statements need liability-aware sign handling.
  • Summary totals should validate the output, not become duplicate transaction rows.

Checklist

  • Original PDF source saved
  • Statement period identified
  • Account sections separated
  • OCR mode chosen only when needed
  • Date format confirmed
  • Debit/credit sign convention confirmed
  • Repeated headers removed
  • Wrapped descriptions reviewed
  • Opening and closing balances checked
  • Output reviewed before import

FAQ

Should I convert summary pages?

Keep summary pages for validation, but do not treat summary totals as transaction rows unless they are actual postings.

What is the most common conversion error?

The most common error is splitting wrapped descriptions into separate rows or duplicating repeated page headers as transactions.