← Back to all guides

How to Import a Bank Statement into QuickBooks

QuickBooks is the most widely used accounting software for small businesses. Importing your bank statement data directly saves hours of manual entry and ensures your books are accurate.

Step 1: Convert Your PDF Statement to CSV

QuickBooks can't read PDF statements directly. You first need to convert your bank statement PDF to CSV format using csvbank.com. The process takes seconds and requires no account.

Step 2: Import into QuickBooks Online

In QuickBooks Online, go to Banking → Upload from file. Select your CSV file and map the columns: Date, Description, Amount. QuickBooks will preview the transactions before importing.

Step 3: Import into QuickBooks Desktop

In QuickBooks Desktop, go to Banking → Bank Feeds → Import Web Connect File. Alternatively use File → Utilities → Import → IIF Files after converting your CSV to IIF format.

Mapping CSV Columns to QuickBooks

When QuickBooks asks you to map columns, use these settings:

• Date → Date column
• Description → Description column
• Amount → Use Debit and Credit columns separately, or combine them

Tips for Clean Imports

• Import one month at a time to avoid duplicates
• Review QuickBooks' auto-categorisation and correct any mistakes
• Reconcile after each import to catch any missing transactions
• Keep your CSV files archived in case you need to re-import