← All ResourcesResource
How To Import Bank Statements Into QuickBooks
QuickBooks cannot import PDF bank statements directly. Convert your PDF to CSV, QBO, or OFX first, then follow a simple import workflow to load transactions into your bank register.
Last updated: 3 min read
Prepare Your Bank Statement File
QuickBooks cannot import PDF bank statements directly. Convert your PDF to CSV, QBO, or OFX first using a bank statement converter.
- Download PDF statement from your bank
- Upload to bank statement converter
- Select QBO or CSV output format
- Download the export file
Import via QBO File
In QuickBooks Online, navigate to Banking → Upload transactions → select your QBO file. QuickBooks maps fields automatically for QBO format imports.
Import via CSV File
For CSV imports, map columns during the first import: assign Date, Description, and Amount fields. Save the mapping for recurring monthly imports from the same bank.
Frequently Asked Questions
Can I import a PDF directly into QuickBooks?
QuickBooks requires structured formats like CSV, QBO, or OFX. Convert your PDF bank statement first, then import the export file.
What columns does QuickBooks need?
Typically Date, Description, and Amount (or separate Debit/Credit columns). Match your export columns during the import mapping step.
Related Resources
- How To Import Bank Statements Into XeroImport bank statement CSV files into Xero.
- Bank Statement Columns ExplainedStandard bank statement column definitions for finance teams.
- Bank Statement Data Extraction ExplainedHow PDF bank statement data extraction works.
- Common Bank Statement ErrorsFix common bank statement data errors.
- CSV vs Excel For Bank StatementsCompare CSV and Excel for bank statement workflows.
- How Accountants Use Bank Statement ConvertersAccounting firm workflows with statement converters.
Related Formats
Convert Bank Statements Automatically
Upload your PDF bank statement and convert it into Excel, CSV, QBO, or accounting-ready formats within seconds.
Convert Statement Now