Import Bank Statement into QuickBooks: CSV and OFX Guide

Updated 3 November 2026

To import a bank statement into QuickBooks, convert the PDF into a CSV or OFX file, then use QuickBooks Online’s manual upload to bring the transactions into your For review list. The parts that usually go wrong are the CSV layout, the date format and the sign of the amounts, so this guide walks through each one and finishes with fixes for the most common errors.

When you need a manual import

Bank feeds pull transactions into QuickBooks automatically, but a manual import is the answer when:

• your bank isn’t supported, or the connection keeps dropping;
• you need transactions from before the feed was connected;
• you’re catching up on an old or closed account;
• a client has given you PDF statements and nothing else.

In each case you’re starting from a PDF, and the upload tool is designed for data files, so the first job is converting it.

Step 1: Convert the PDF statement

Open the free bank statement converter and add your PDF. It runs in your browser, so the statement isn’t uploaded anywhere; if you handle client documents, our guide on whether it’s safe to convert bank statements online explains why that matters. Review the preview, check any rows the balance check flags, fix them, then export:

• CSV if you want to see or edit the data before it reaches QuickBooks.
• OFX if you want an upload with no column mapping.

The bank statement to QuickBooks page summarises the settings that suit QuickBooks.

Step 2: Put the CSV into a layout QuickBooks accepts

QuickBooks Online accepts bank CSVs in one of two layouts. The column order isn’t critical because you map columns during upload, but the file should contain only these columns.

3-column layout

Money out is negative and money in is positive. That’s the same convention as the converter’s signed Amount column, so keep Date, Description and Amount, and delete Debit, Credit and Balance.

4-column layout

Money in goes under Credit and money out under Debit, both as positive numbers. Keep Date, Description, Debit and Credit, delete Amount and Balance, and check that neither column contains minus signs.

Tidy-up checklist

• One header row, with nothing above it (no bank name, account number or statement title).
• No blank rows, and no opening or closing balance lines.
• Plain numbers only: 1200.00, not £1,200.00 or $1,200.00.
• Saved as .csv, not .xlsx.

Step 3: Upload the file in QuickBooks Online

The wording changes from time to time and can differ by version and region, but the flow is broadly:

1. Go to Banking, or Transactions > Bank transactions.
2. Find the option to upload transactions from a file. It’s often in a drop-down next to the button for linking an account.
3. Choose your CSV or OFX file and continue.
4. Pick the QuickBooks account the transactions belong to, such as your business current account or credit card. Double-check this; transactions posted to the wrong account are tedious to undo.
5. For CSV only: map the columns. Say whether the first row is a header, which column holds the date and in what format, which holds the description, and whether amounts are in one column or two.
6. Select the transactions to import and confirm.

The transactions then appear in the For review list. Nothing reaches your books until you categorise or match each one and add it, which gives you a chance to catch mistakes. For current screenshots, see the QuickBooks help centre.

Date format pitfalls

Dates cause more failed or messy imports than anything else.

• Pick the matching format during mapping. If 03/10/2026 in your file means 3 October, choose a day-first format such as dd/MM/yyyy. Choose month-first and QuickBooks reads it as 10 March.
• Watch out for Excel re-saving the CSV. Opening a CSV in Excel and saving it again can silently change dates to your computer’s regional format. If you edit in Excel, check the date column before saving.
• Look for dates in the future. Transactions dated months ahead are a sure sign that day and month have swapped.
• Use four-digit years. Two-digit years invite misreads.

The converter detects whether your statement uses DD/MM or MM/DD and lets you choose the output format, so you can export in exactly the format you’ll select in QuickBooks.

CSV or OFX for QuickBooks?

If you’ve already reviewed everything in the converter’s editable preview, OFX is usually the smoother route. If you want to rename descriptions or split the file by date first, use CSV. Our guide to CSV, Excel and OFX formats covers the differences in more depth.

Common errors and how to fix them

Credit card accounts deserve a special mention: if charges come through as payments, the sign convention is reversed for that account. Preview a few rows before confirming. The credit card statement converter page covers card statements specifically.

A note on QuickBooks Desktop

QuickBooks Desktop is stricter than QuickBooks Online. It generally expects Web Connect (.qbo) files, and its options for CSV bank transactions are more limited. This converter doesn’t produce .qbo files, so if you use Desktop, check the QuickBooks help centre for what your version supports.

Key takeaways

• Convert the PDF to CSV or OFX first; QuickBooks Online’s upload is built for data files.
• For CSV, use either the 3-column (Date, Description, Amount) or 4-column (Date, Description, Credit, Debit) layout, with nothing above the header.
• Match the date format in your file to the one you select during mapping.
• Choose OFX for a quick upload with no mapping, or CSV when you want to edit first.
• Review everything in For review before adding it to your books. Using Xero for another client? See our guide to importing a bank statement into Xero.

Frequently asked questions

Convert a bank statement →