Home › Guides › How to Import a CSV into QuickBooks (QBO)

How to import a CSV file into QuickBooks (QBO)

QuickBooks Online can import a bank or credit card CSV through Bank transactions → Link account → Upload from file. You do not need to convert that CSV into a .qbo (Web Connect) file first: Online accepts QBO, QFX and CSV transaction lists that are in English, 350 KB or less and up to 1,000 lines, with either three columns (Date, Description, Amount) or four (Date, Description, Credit, Debit). “QBO” can also mean the .qbo file extension used by QuickBooks Desktop Web Connect, which is a different path than importing a CSV into QuickBooks Online.

Updated November 8, 2026

Two meanings of “QBO”

Search results for “import csv to qbo” mix two different things:

If your goal is to import csv into QuickBooks Desktop bank feeds, Intuit does not document an Online-style CSV upload. See the Desktop section below and the QBO Web Connect guide for Desktop.

You usually do not need to convert CSV to QBO

Intuit’s Manually upload transactions into QuickBooks Online article (updated August 24, 2026; checked November 8, 2026) says QuickBooks allows you to upload an account statement (PDF or image) or a list of transactions (QBO, QFX or CSV). For a transaction list, it suggests a QuickBooks Online data (QBO) file and also accepts QFX or CSV.

So if your bank already gave you a CSV, format it and upload it. Converting that spreadsheet into a .qbo file is not a step Intuit requires for Online. CSVLedger also does not convert an existing CSV into a .qbo file — it converts statement PDFs.

QuickBooks Online can extract transactions from a PDF or image statement as well. This guide stays on the CSV transaction-list path, which lets you inspect dates, signs and totals before anything enters the books.

Format the CSV: 3 columns or 4 columns

Intuit documents two bank-transaction layouts in Format CSV files in Excel to get bank transactions into QuickBooks (updated August 24, 2026; checked November 8, 2026). This is not the template for invoices, customers or a journal.

3-column format: Date, Description, Amount

Intuit’s published example uses a signed Amount column: a payment is negative and a deposit is positive.

Date,Description,Amount
1/1/2018,Example of a payment,-100.00
1/1/2018,Example of a deposit,200.00

The rows above are Intuit’s own sample dates and wording. Use plain decimal amounts like those examples, with one transaction per row.

4-column format: Date, Description, Credit, Debit

Intuit documents the headings Date, Description, Credit, Debit. Its sample places a payment in Credit and a deposit in Debit, and leaves the unused amount cell empty:

DateDescriptionCreditDebit
1/1/2018Example of a payment100.00
1/1/2018Example of a deposit200.00

A bank export may label Credit and Debit from a different point of view, so do not assume the words on the file match Intuit’s import fields. If the mapping is confusing, use the signed three-column layout instead. Remove the word “amount” from headers such as “Credit amount” or “Debit amount” — they should read only “Credit” and “Debit”.

File rules Intuit documents

From the transaction-list guidelines on Intuit’s upload article, and the cleanup notes on its format article:

Keep opening-balance, closing-balance and total rows in your working copy for the check below. The file you upload should contain transaction rows only.

A fictional CSV and a balance check

Suppose a checking statement shows opening balance 2450.00 and closing balance 2785.40. This fictional three-column CSV uses Intuit’s recommended dd/mm/yyyy dates:

Date,Description,Amount
03/10/2026,ACME PAYROLL,1200.00
05/10/2026,CITY UTILITIES,-84.60
12/10/2026,OFFICE SUPPLIES,-45.00
18/10/2026,CLIENT TRANSFER,265.00

Check: 2450.00 + 1200.00 − 84.60 − 45.00 + 265.00 = 2785.40, which matches the printed closing balance. Matching totals does not prove every description character is perfect — still spot-check payees. If you edited the file in Excel, reopen the saved CSV and confirm that dates and minus signs survived saving.

Upload the CSV in QuickBooks Online

These steps follow Intuit’s “Upload a list” section (checked November 8, 2026). Menu names change; use the current article if your screen differs.

  1. Go to All apps, then Accounting, then Bank transactions.
  2. If you see a tile for the account you want to upload into, select it.
  3. Open the Link account dropdown and choose Upload from file. If the account is not connected to online banking yet, select Upload from file or Or upload transactions manually.
  4. Select the CSV you downloaded or formatted, then Continue.
  5. In the QuickBooks account dropdown, choose the bank or credit card account the rows belong to (or Add New if you do not have one yet).
  6. Select Continue.
  7. Match the columns in the file with the QuickBooks fields (Date, Description and either Amount or Credit/Debit) and confirm the date format that matches the actual text in the CSV. Then Continue.
  8. In the preview, find one known payment and one known deposit. Stop if either has the wrong direction or date.
  9. Select the transactions to import, then Continue.
  10. Select Yes, then Done.

Intuit’s next steps are to match and categorise the uploaded lines, then reconcile them. Uploading a file is not the same as completing reconciliation. Before you start, Intuit also recommends checking your chart of accounts so you do not create duplicates, and making sure the uploaded record starts at least one day before your oldest QuickBooks transaction in that account if you are filling a gap.

Credit card CSVs

Intuit notes that credit card CSVs may list transactions in reverse order, and that deposits can appear as negative amounts because a payment reduces the card balance. Choose the credit card account, not the checking account that pays the bill, when you upload.

If your source is a PDF statement

Prefer a bank CSV, QFX or QBO download when the bank offers one — see the US bank statement format guide. If you only have a PDF:

If you already have a bank CSV, skip conversion and import the spreadsheet directly into QuickBooks Online.

QuickBooks Desktop: no Online-style CSV bank upload

Intuit’s Import and export data in QuickBooks Desktop article (updated August 3, 2026; checked November 8, 2026) lists Excel or CSV for general transfer of lists and transactions, and separately says to import bank transactions using Web Connect (.qbo) files. Its Download bank feed transactions in QuickBooks Desktop article (updated August 5, 2026) states that Web Connect only works with .qbo files, and that QFX and QIF files will not work there.

There is no official Desktop article that documents a Bank transactions → Upload from file CSV workflow like the one above. For Desktop bank feeds, get or create a .qbo file and follow How to import a QBO file into QuickBooks Desktop.

One related Desktop path is documented, and it is not a bank-feed CSV upload: Enter transactions by batch in QuickBooks Desktop (updated August 4, 2026) says only QuickBooks Enterprise and QuickBooks Accountant Desktop support batch entering transactions from Excel or CSV into bank, credit card, accounts receivable and accounts payable registers. That workflow uses Accountant → Batch Enter Transactions, then copy and paste rows that match the window’s column order. Back up the company file first. Rows pasted this way go into the register; they do not go through the Online-style upload preview.

When a browser converter helps

Disclosure: I built CSVLedger. It converts text and clear English scanned bank statement PDFs to Excel, CSV, QuickBooks .qbo and Xero CSV in your browser (no upload), with an automatic balance check. It does not convert an existing CSV file into a .qbo file. If you already have a bank CSV, import it directly into QuickBooks Online. Use the converter when your source is a statement PDF and you want a QuickBooks 3-column CSV or a .qbo file to review before uploading.

Open PDF to CSV → · PDF to QBO · How we check accuracy · Plans and limits

Conversion runs in your browser; statement files are not uploaded to CSVLedger. A balance check helps spot extraction issues; it does not replace your review or accounting reconciliation. No fake testimonials — try a short statement you already understand.

Frequently asked questions

What does “import CSV to QBO” mean?

People use QBO in two ways: QuickBooks Online, the web product, and the .qbo Web Connect file extension. Importing a CSV into QuickBooks Online means uploading a formatted transaction list. It is not the same as turning a CSV into a .qbo file.

Do I need to convert a CSV to a .qbo file for QuickBooks Online?

No. Intuit’s QuickBooks Online upload article lists QuickBooks Online data (QBO), Quicken QFX and CSV as transaction-list files. If you already have a bank CSV that matches the 3-column or 4-column layout, upload the CSV directly.

What CSV format does QuickBooks Online accept?

Intuit documents two layouts: Date, Description and Amount, or Date, Description, Credit and Debit. Files must be in English, 350 KB or less and up to 1,000 transaction lines. Use one consistent date format (Intuit recommends dd/mm/yyyy), leave zero amount cells blank and do not put the word “amount” in Credit or Debit headers.

Can QuickBooks Desktop import a CSV of bank transactions?

Not the way QuickBooks Online does. Intuit documents Desktop bank data through Web Connect (.qbo) files and says Web Connect works with .qbo files, not QFX or QIF. Accountant and Enterprise editions can paste Excel or CSV rows into registers with Batch Enter Transactions; that is register entry, not an Online-style bank-feed CSV upload.

Can CSVLedger convert an existing CSV into a .qbo file?

No. CSVLedger converts PDF bank and credit card statements to Excel, CSV, QuickBooks .qbo and Xero CSV in the browser. It does not turn an existing CSV file into a .qbo file. If you already have a bank CSV, import it into QuickBooks Online as CSV. If you only have a statement PDF and need a .qbo file for Desktop Web Connect, convert the PDF instead.

Related guides

Sources and scope

Based on official Intuit help articles fetched and checked on November 8, 2026. Menus, regional builds and product requirements can change; if your screen differs, follow the current Intuit article for your product. Examples marked fictional are illustrative. This page is documentation-based guidance, not a claim that a live import was completed in every QuickBooks edition today.