How to Import Bank Statements into QuickBooks

The short version

QuickBooks Online imports transactions from three-column CSVs: Date, Description, Amount. It cannot parse PDF files, so a paper-or-PDF statement has to be converted first. The whole job is two steps: get a clean CSV, then feed it through Banking → File upload.

Step 1: convert the statement PDF to CSV

Upload your statement PDF to StatementSheet and press “CSV for QuickBooks”. That export is exactly the three columns above — Date, Description, Amount — with the running balance deliberately left out, because QuickBooks reads a fourth column as a debit and would import your balance as money. The plain CSV and the Excel file keep the balance for reading; this one is shaped for the importer. If your bank splits debits and credits into separate columns, they are merged into a single signed amount during conversion, which is what QuickBooks wants.

Before importing, glance at the flagged rows: those are lines where the recomputed balance did not reconcile, and importing them would carry an error straight into your books.

Step 2: upload in QuickBooks

• Open Banking (Transactions → Banking) and choose File upload / Link account → Upload.
• Drag in the converted CSV and select the target account.
• Map the columns — with our export, defaults line up automatically.
• Pick the date format used by the statement and confirm.
• Review, categorize and add the imported rows.

Mistakes that cost hours later

• Importing overlapping periods twice → duplicate transactions. Check the last imported date first.
• Amounts without signs → withdrawals become deposits. Use signed amounts from the start.
• Feeding in flagged rows from a sloppy conversion → reconciliation breaks weeks down the line.