How to import bank statements into QuickBooks
How to prepare PDF bank statements as reviewed CSV files before importing transactions into QuickBooks Online or Desktop.
Who this is for
QuickBooks users handling catch-up bookkeeping or old PDF statements.
QuickBooks wants transaction data, not the original PDF
QuickBooks imports structured transaction files. If the bank only gives you a PDF statement, you need to convert it into a reviewed table first.
The safest workflow is PDF to spreadsheet preview, clean obvious issues, then export a QuickBooks-ready CSV for import.
What to review before importing
QuickBooks imports are easy to duplicate if dates, descriptions, or amounts are wrong. Review the extracted rows before upload, especially when statements include payments, transfers, or balance-only summary lines.
- Remove non-transaction summary rows
- Confirm debits and credits are not reversed
- Avoid duplicate date ranges already imported from bank feeds
- Keep the original PDF attached to the cleanup workpaper
When this is better than reconnecting bank feeds
Bank feeds are ideal for current activity, but they do not always reach far enough back. A PDF-to-CSV workflow helps when the client only has old statements, closed accounts, or missing historical periods.
Step-by-step workflow
Convert the statement to rows
Use the Bank Statement document type and choose QuickBooks output if your end goal is import.
Check the date range
Make sure the statement period does not overlap transactions already downloaded through bank feeds.
Review the amount column
QuickBooks CSV normally needs a single amount column where expenses and deposits have opposite signs.
Import and reconcile
Import the CSV, categorize transactions, then reconcile against the statement ending balance.
Review checklist
- Statement period does not duplicate bank feed data
- CSV has Date, Description, and Amount fields
- Charges and deposits have the correct signs
- Transfers are reviewed before categorization
- Ending balance is reconciled after import
Frequently asked questions
Can QuickBooks import a PDF bank statement directly?
QuickBooks generally expects structured transaction data. A PDF statement usually needs to be converted to CSV before import.
Is a QuickBooks CSV the same as a normal bank statement CSV?
Not always. A QuickBooks import file is usually simplified into Date, Description, and Amount, while review files may keep debit, credit, and balance columns.