CSV to QBO: Convert Bank Files for QuickBooks

1. Quick Answer

**To convert CSV to QBO:** upload your bank CSV, map the date, description, amount, debit, and credit fields, then download the QBO file.

**For QuickBooks Online:** you can upload CSV, QBO, QFX, or OFX files from **All apps > Accounting > Bank transactions > Upload from file**.[1](https://quickbooks.intuit.com/learn-support/en-us/help-article/import-transactions/manually-upload-transactions-quickbooks-online/L0rE9OXBz_US_en_US)

**For QuickBooks Desktop:** use a QBO Web Connect file through **File > Utilities > Import > Web Connect Files**. Check your account and back up the company file first.[4](https://www.propersoft.net/howto/convert-csv-to-qbo/)

**For a free online converter:** [BankXLS CSV to QBO Converter](/csv-to-qbo) accepts CSV, XLSX, and XLS transaction files and processes the conversion in the browser.[2](https://bankxls.co/csv-to-qbo)

2. What Is a QBO File?

QBO means QuickBooks Web Connect file. It is a bank-transaction format that QuickBooks can read as an imported feed, with fields for dates, amounts, descriptions, account details, and transaction IDs.

CSV files have no single bank-wide layout. One export may use Date, Description, Amount; another may split money into Date, Description, Debit, Credit. A converter maps those rows into the structure QuickBooks expects.

The practical difference is the import step. QuickBooks Online supports CSV uploads, while a QBO file is already arranged for the Web Connect workflow. A QBO file also carries a FITID, or Financial Institution Transaction ID, which can help QuickBooks identify a transaction that has already been imported.[1](https://quickbooks.intuit.com/learn-support/en-us/help-article/import-transactions/manually-upload-transactions-quickbooks-online/L0rE9OXBz_US_en_US) [2](https://bankxls.co/csv-to-qbo)

3. CSV vs. QBO: Which File Should You Use?

QuickBooks says transaction-list uploads can use CSV, QBO, QFX, or OFX. Its current help page also says a file can contain up to 1,000 lines per upload and should be 350 KB or less when uploaded as a transaction list.[1](https://quickbooks.intuit.com/learn-support/en-us/help-article/import-transactions/manually-upload-transactions-quickbooks-online/L0rE9OXBz_US_en_US)

4. How to Convert CSV to QBO

The basic import CSV to QBO process has 5 parts: download the source file, check the columns, upload it, map the fields, and download the QBO file.

4.1 Download the Right CSV from Your Bank

Sign in to your bank or card provider and export the transaction range you need. Pick CSV, comma-separated values, or Microsoft Excel if those are the available choices.

Choose the first date carefully. If the QuickBooks account already has transactions, start after the last transaction you imported. Overlapping date ranges can create duplicate rows during review.

4.2 Check the CSV Columns

QuickBooks documents 2 accepted CSV layouts:[3](https://quickbooks.intuit.com/learn-support/en-us/help-article/bank-transactions/format-csv-files-excel-bank-transactions-quickbooks/L4BjLWckq_US_en_US)

4.3 Upload the File to BankXLS

Open the [BankXLS CSV to QBO converter](/csv-to-qbo) and choose your CSV, XLSX, or XLS file. The page also includes sample layouts for a combined amount column, separate debit and credit columns, and credit card statements.

For a csv to qbo converter free online workflow, BankXLS keeps the conversion in the browser. The page is also a csv to qbo converter online option for people who don’t want to install desktop software.[2](https://bankxls.co/csv-to-qbo)

BankXLS states that conversion happens in browser memory and that the source financial data is not sent to an external server.[2](https://bankxls.co/csv-to-qbo) That matters when a file contains account numbers, payee names, or business spending details.

4.4 Map the Columns

Match each source column to the right transaction field:

**Date:** the posted or transaction date.

**Description:** the payee, memo, or bank description.

**Amount:** one signed column when expenses and deposits use opposite signs.

**Debit:** money leaving the account in a split-column file.

**Credit:** money entering the account in a split-column file.

4.5 Download the QBO File

Download the converted file and keep the original CSV beside it. Use a clear filename such as checking-2026-01-to-2026-03.qbo so you can identify the account and date range later.

A QBO file can contain sensitive financial data. Store it in a private folder and delete temporary copies after you finish the import and review.

5. How to Import QBO into QuickBooks Online

QuickBooks Online currently lists this path for transaction uploads:[1](https://quickbooks.intuit.com/learn-support/en-us/help-article/import-transactions/manually-upload-transactions-quickbooks-online/L0rE9OXBz_US_en_US)

1. Open **All apps**.

2. Select **Accounting**, then **Bank transactions**.

3. Select the bank or credit card account.

4. Open **Link account** and choose **Upload from file**. If the account is not connected, choose **Upload from file** or **Or upload transactions manually**.

5. Select the QBO file and choose **Continue**.

6. Choose the QuickBooks account that should receive the transactions.

7. Review the file and select the transactions to import.

8. Select **Continue**, then **Yes**, then **Done**.

QuickBooks may add details from recognized descriptions or bank rules. Review the imported rows, match them to existing transactions, categorize them, and reconcile the account before treating the file as finished.[1](https://quickbooks.intuit.com/learn-support/en-us/help-article/import-transactions/manually-upload-transactions-quickbooks-online/L0rE9OXBz_US_en_US)

6. How to Import QBO into QuickBooks Desktop

QuickBooks Desktop uses the Web Connect import path for QBO files. Before you import, back up the company file and confirm that the account in QuickBooks matches the account represented by the QBO file.

The usual path is **File > Utilities > Import > Web Connect Files**. Select the QBO file, choose the destination account, and review the downloaded transactions under Bank Feeds. ProperSoft also notes that a directly connected account may need to be disconnected before a Web Connect file can be imported.[4](https://www.propersoft.net/howto/convert-csv-to-qbo/)

Menu labels vary across QuickBooks Desktop editions. If your version shows a different path, search its Help menu for “Web Connect.”

7. Common CSV to QBO Problems

7.1 QuickBooks Says the File Is Too Large

QuickBooks Online lists a 350 KB limit for transaction-list uploads and up to 1,000 lines per upload.[1](https://quickbooks.intuit.com/learn-support/en-us/help-article/import-transactions/manually-upload-transactions-quickbooks-online/L0rE9OXBz_US_en_US) Shorten the date range and import the transactions in smaller batches. A QBO workflow can also be useful when a long CSV keeps hitting the direct-upload limit, but you should still review the resulting file before importing it.

7.2 The Date Column Is Rejected

Use one date format for every row. Remove weekday text and check whether the bank exported dates as month/day/year or day/month/year. Open the CSV in a spreadsheet editor and inspect several rows, including the first and last transaction.

7.3 Debit and Credit Values Are Reversed

Bank and credit card exports don’t use one universal sign convention. Compare a known payment and a known deposit with the original statement, then reverse or remap the values before creating the QBO file.

7.4 QuickBooks Shows Duplicate Transactions

The most common cause is an overlapping date range. Compare the first new transaction with the last transaction already in QuickBooks. QBO files can include FITID transaction identifiers, but you still need to review the import queue and remove any duplicate rows before accepting them.[1](https://quickbooks.intuit.com/learn-support/en-us/help-article/import-transactions/manually-upload-transactions-quickbooks-online/L0rE9OXBz_US_en_US) [2](https://bankxls.co/csv-to-qbo)

7.5 The CSV Has Separate Debit and Credit Columns

Keep the columns separate during mapping. QuickBooks accepts a 4-column CSV with Date, Description, Credit, and Debit; BankXLS also provides a separate debit and credit sample layout.[2](https://bankxls.co/csv-to-qbo) [3](https://quickbooks.intuit.com/learn-support/en-us/help-article/bank-transactions/format-csv-files-excel-bank-transactions-quickbooks/L4BjLWckq_US_en_US)

7.6 The Bank Only Gives You a PDF

A PDF is a different starting point. First turn the statement into a structured spreadsheet, check the extracted rows against the statement, then convert the CSV to QBO. BankXLS also publishes a [bank statement to Excel guide](/blog/bank-statement-to-excel-software) for this type of workflow.

8. Is CSV to QBO Safe for Bank Data?

Treat every transaction file as private. It can contain account details, merchant names, addresses, and spending patterns.

Browser-only processing reduces the number of places where the file can travel. BankXLS says its converter processes files locally in the browser and does not upload the source data to a server.[2](https://bankxls.co/csv-to-qbo) You should still use a private device, keep the file name generic when sharing it, and delete copies you no longer need.

9. Watch the QuickBooks Import Walkthrough

QuickBooks publishes a short video showing how to download transactions, upload a file, map columns, check amount signs, and finish the import:

10. Frequently Asked Questions

Can I convert CSV to QBO for free? Yes. You can use the [BankXLS CSV to QBO converter](/csv-to-qbo) to convert a transaction spreadsheet in your browser. This is a csv to qbo converter free option for a basic online conversion. Keep the original CSV and review the downloaded QBO file before importing it.

Can I import CSV directly into QuickBooks Online? Yes. QuickBooks Online supports CSV uploads from the Bank transactions area. The file needs an accepted 3-column or 4-column layout, consistent dates, correct debit and credit values, and compliance with the current upload limits.[1](https://quickbooks.intuit.com/learn-support/en-us/help-article/import-transactions/manually-upload-transactions-quickbooks-online/L0rE9OXBz_US_en_US) [3](https://quickbooks.intuit.com/learn-support/en-us/help-article/bank-transactions/format-csv-files-excel-bank-transactions-quickbooks/L4BjLWckq_US_en_US)

How do I upload CSV to QBO? Upload the CSV to a converter, map the date, description, amount, debit, and credit fields, download the QBO file, and then upload that file to the correct QuickBooks account. The [BankXLS CSV to QBO converter](/csv-to-qbo) follows this workflow in the browser.

What columns does a CSV need for QuickBooks? QuickBooks accepts either Date, Description, and Amount, or Date, Description, Credit, and Debit. Keep dates in one format and leave zero-only amount cells blank.[3](https://quickbooks.intuit.com/learn-support/en-us/help-article/bank-transactions/format-csv-files-excel-bank-transactions-quickbooks/L4BjLWckq_US_en_US)

Why won’t QuickBooks accept my CSV file? Common causes include an unsupported column layout, mixed date formats, numbers in the description field, zero values in debit or credit cells, weekday text attached to dates, or a file above the current size or line limit. Correct the CSV, convert it to QBO, and review the transaction range before trying again.[1](https://quickbooks.intuit.com/learn-support/en-us/help-article/import-transactions/manually-upload-transactions-quickbooks-online/L0rE9OXBz_US_en_US) [3](https://quickbooks.intuit.com/learn-support/en-us/help-article/bank-transactions/format-csv-files-excel-bank-transactions-quickbooks/L4BjLWckq_US_en_US)

11. Final Checklist

Before you import, check these 7 items:

The file belongs to the right bank or credit card account.

The date range starts after the last imported transaction.

Expenses and deposits use the correct signs.

Dates follow one format.

The CSV uses a 3-column or 4-column layout if you are importing CSV directly.

The QBO file has a clear filename and is stored privately.

You reviewed the imported transactions before matching, categorizing, and reconciling them.

12. References

Pricing, file limits, and menu labels can change. Sources checked October 20, 2026.

[1] [Intuit QuickBooks Help: Manually upload transactions into QuickBooks Online](https://quickbooks.intuit.com/learn-support/en-us/help-article/import-transactions/manually-upload-transactions-quickbooks-online/L0rE9OXBz_US_en_US)

[2] [BankXLS CSV to QBO Converter](https://bankxls.co/csv-to-qbo)

[3] [Intuit QuickBooks Help: Format CSV files in Excel to get bank transactions into QuickBooks](https://quickbooks.intuit.com/learn-support/en-us/help-article/bank-transactions/format-csv-files-excel-bank-transactions-quickbooks/L4BjLWckq_US_en_US)

[4] [ProperSoft: Convert CSV to QBO and import into QuickBooks](https://www.propersoft.net/howto/convert-csv-to-qbo/)