Bank statements
Convert a bank statement PDF to QuickBooks CSV
A practical guide to turning bank statement PDFs, scans, and photos into reviewable QuickBooks CSV rows.
Start with the cleanest upstream file
The most reliable source is the original statement PDF downloaded from the bank portal. A scan or phone photo can work when the page is upright, bright, and the full transaction table is visible.
Extract transactions, not every table
The goal is to keep real bank activity and ignore page content that looks structured but is not a transaction: account summaries, interest summaries, check image captions, fee schedules, and disclaimers.
Normalize the output columns
For a simple QuickBooks CSV, normalize withdrawals and payments to negative Amount values, deposits to positive Amount values, and keep the original description readable enough for review.
- Date should be consistent.
- Description should keep the merchant or counterparty.
- Amount should be signed, not split into debit and credit columns.
Use the CSV for cleanup or import
Once reviewed, the CSV can be used for QuickBooks import, spreadsheet cleanup, accountant handoff, or reconciliation prep. Users often need this when the bank feed is missing historical transactions.
Checks before downloading
- Row count
- Does it match the visible transaction count?
- Signs
- Are withdrawals negative and deposits positive?
- Dates
- Are all dates in a consistent format?
- Non-transactions
- Were balances, summaries, and headings excluded?
FAQ
What if the bank statement uses Debit and Credit columns?
The export can still use one signed Amount column. Debits become negative values and credits become positive values.
What if a description wraps across two lines?
The wrapped text should be merged into one Description cell when it belongs to the same transaction.
Do balance columns need to be exported?
Not for the basic QuickBooks CSV. Balance can be useful during review, but the import file usually focuses on transaction rows.
Turn a statement file into reviewable rows
Upload a PDF, scan, screenshot, or clear photo and review the rows before downloading CSV.