Convert CSV to QBO Free for QuickBooks
Your bank only gives you a CSV, but QuickBooks Desktop wants a Web Connect file. Import CSV to QBO here: map your columns once, check the preview, and download a QBO file with dates, amounts and transaction IDs already set.
- Encrypted with AES-256
- Temporary private storage; automatic deletion
- Preview before you download
How to convert CSV to QBO
- 01
Upload your CSV.
Drag in the file you downloaded from your bank or card account, or click browse. Want to see how it works first? Use the sample file.
- 02
Check the columns and options.
Confirm which column holds the date, the description and the amount. Set the date format, account type and the bank QuickBooks should show.
- 03
Preview and download.
Look over the first 10 converted transactions. If the dates and signs look right, download your QBO file and import it into QuickBooks.
CSV to QBO example: what changes in the file
This fictional bank CSV becomes a QBO document with signed amounts, posted dates and generated transaction IDs. The example uses month-first input dates. Institution details are fictional; use your own bank's supported details for a real import.
CSV input
Date,Description,Amount 03/02/2026,Office Depot,-142.18 03/04/2026,Client payment – Acme LLC,2500.00 03/09/2026,Monthly service fee,-12.00 03/16/2026,Fuel – Main St Station,-58.40
QBO output
OFXHEADER:100
DATA:OFXSGML
VERSION:102
SECURITY:NONE
ENCODING:USASCII
CHARSET:1252
COMPRESSION:NONE
OLDFILEUID:NONE
NEWFILEUID:NONE
<OFX>
<SIGNONMSGSRSV1>
<SONRS>
<STATUS>
<CODE>0</CODE>
<SEVERITY>INFO</SEVERITY>
</STATUS>
<DTSERVER>20261024231306[0:GMT]</DTSERVER>
<LANGUAGE>ENG</LANGUAGE>
<FI>
<ORG>Sample Bank</ORG>
<FID>00000</FID>
</FI>
<INTU.BID>00000</INTU.BID>
</SONRS>
</SIGNONMSGSRSV1>
<BANKMSGSRSV1>
<STMTTRNRS>
<TRNUID>0</TRNUID>
<STATUS>
<CODE>0</CODE>
<SEVERITY>INFO</SEVERITY>
</STATUS>
<STMTRS>
<CURDEF>USD</CURDEF>
<BANKACCTFROM>
<BANKID>000000000</BANKID>
<ACCTID>0000</ACCTID>
<ACCTTYPE>CHECKING</ACCTTYPE>
</BANKACCTFROM>
<BANKTRANLIST>
<DTSTART>20260302000000[0:GMT]</DTSTART>
<DTEND>20260317000000[0:GMT]</DTEND>
<STMTTRN>
<TRNTYPE>DEBIT</TRNTYPE>
<DTPOSTED>20260302120000[0:GMT]</DTPOSTED>
<TRNAMT>-142.18</TRNAMT>
<FITID>29cf4b75b3261770f8c3ee692bbce140f2456a3ae9d784f050062c24cf3b421c</FITID>
<NAME>Office Depot</NAME>
<MEMO>Office Depot</MEMO>
</STMTTRN>
<STMTTRN>
<TRNTYPE>CREDIT</TRNTYPE>
<DTPOSTED>20260304120000[0:GMT]</DTPOSTED>
<TRNAMT>2500.00</TRNAMT>
<FITID>baf84360efdf926b06436e8b6bce4a41f5cc081ffc892d2dfe9f3c8ae3dfd9b5</FITID>
<NAME>Client payment – Acme LLC</NAME>
<MEMO>Client payment – Acme LLC</MEMO>
</STMTTRN>
<STMTTRN>
<TRNTYPE>DEBIT</TRNTYPE>
<DTPOSTED>20260309120000[0:GMT]</DTPOSTED>
<TRNAMT>-12.00</TRNAMT>
<FITID>1381197694912b8a73c71ec5221970d8600fb74342d42dae45d511d14628352f</FITID>
<NAME>Monthly service fee</NAME>
<MEMO>Monthly service fee</MEMO>
</STMTTRN>
<STMTTRN>
<TRNTYPE>DEBIT</TRNTYPE>
<DTPOSTED>20260316120000[0:GMT]</DTPOSTED>
<TRNAMT>-58.40</TRNAMT>
<FITID>2d2c3fa0fceaef7f045d05b3d926db59ea2d8addac7229f5152eabe1c53719fc</FITID>
<NAME>Fuel – Main St Station</NAME>
<MEMO>Fuel – Main St Station</MEMO>
</STMTTRN>
</BANKTRANLIST>
<LEDGERBAL>
<BALAMT>0.00</BALAMT>
<DTASOF>20261231235959[0:GMT]</DTASOF>
</LEDGERBAL>
</STMTRS>
</STMTTRNRS>
</BANKMSGSRSV1>
</OFX>How CSV columns map to QBO fields
A bank CSV is just rows and columns. A QBO file labels every value so QuickBooks knows exactly what it is. This is where each part of your CSV ends up.
| CSV field | QBO field | Note |
|---|---|---|
| Date | DTPOSTED | Read with the date format you pick, then written as YYYYMMDD. |
| Description | NAME | Shows as the payee line when you review transactions in QuickBooks. |
| Amount, or Debit and Credit | TRNAMT | Money out is negative and money in is positive. |
| Sign of the amount | TRNTYPE | DEBIT for money out, CREDIT for money in. |
| (none in a CSV) | FITID | A transaction ID is generated when the source has none. IDs help supported software recognise previous imports; review overlapping files for duplicates. |
| Account type option | ACCTTYPE, or the credit card account block | Checking or Savings, or a credit card account. |
| Bank shown in QuickBooks option | INTU.BID | The bank ID QuickBooks Desktop checks before it accepts a Web Connect file. |
How to upload the QBO file to QuickBooks
QuickBooks Online and QuickBooks Desktop both read QBO files. In Online, a QBO file skips the column mapping step that a CSV upload needs. In Desktop, Web Connect is the only way in for bank transactions from a file like this.
QuickBooks Online
QuickBooks Online · Documentation checked
- Go to Transactions › Bank transactions. On the newer menu, it's All apps › Accounting › Bank transactions.
- Select Link account ▾, then Upload from file.
- Choose your QBO file and continue.
- Pick the QuickBooks account these transactions belong to, then confirm.
- Open the For review tab to categorize and add each transaction.
QuickBooks Desktop
QuickBooks Desktop Web Connect · Documentation checked
- Back up your company file first: File › Back Up Company › Create Local Backup.
- Go to File › Utilities › Import › Web Connect Files.
- Select your QBO file and open it.
- Choose an existing QuickBooks account, or create a new one, when prompted.
- Review and accept the transactions in Bank Feeds.
How to download a CSV from your online banking
Show me where to download it
Most banks put the CSV export next to your transaction list. Sign in, open the account, and go to Activity or Statements. Pick a date range, choose Download, then select CSV as the format. For a card account, the steps are the same from the card's activity page.
- Chase: Sign in on a computer, open the account, and look for Download or Export in the account activity view. Choose the CSV option.
- Bank of America: Open the account's activity, then look for Download or Export in the account activity view. Pick CSV or a spreadsheet format.
- Wells Fargo: Go to the account's activity, then look for Download or Export in the account activity view. Select a comma-delimited (CSV) file.
Some banks also offer a QuickBooks Web Connect download in that same menu. If yours does, you can import that file directly and skip this converter.
What are CSV and QBO files?
What is a CSV file?
A CSV (comma-separated values) file is plain text in rows and columns. Banks offer it because Excel and Google Sheets open it. Every bank orders and names its columns differently, so accounting software usually asks you to map them.
What is a QBO file?
A QBO file is QuickBooks Web Connect, a bank-transaction format used by QuickBooks Online and supported QuickBooks Desktop editions. It is based on OFX and includes Intuit institution details. Transaction IDs help the importer recognise previously imported entries; review matches and duplicates before accepting them.
QuickBooks Desktop's Web Connect won't take a CSV, but it will take a QBO file with IDs that stop duplicates.
CSV to QBO import errors and how to fix them
| Error | Cause | Fix |
|---|---|---|
| "QuickBooks is unable to verify the financial institution information for this download" | The institution is not accepted, the identifiers do not match, or Web Connect services are unavailable for this edition. | Confirm that the selected bank and institution IDs match your own account, and that your software supports that bank's Web Connect service. Correct the details and reconvert; do not substitute an unrelated bank. |
| QuickBooks Desktop won't import any Web Connect file | The QuickBooks Desktop edition no longer has supported Web Connect services. | Update to a supported version of QuickBooks Desktop. |
| Dates are in the wrong month, or some rows fail | The date format you picked doesn't match your CSV, so 03/04 is read as April 3 instead of March 4. | Set Date format to match your bank's export and convert again. Check the preview before you download. |
| Every transaction shows as money in | Your CSV has separate Debit and Credit columns, but both were read as one Amount column. | Map Debit and Credit to their own columns in the Columns option. |
| QuickBooks Online rejects your CSV upload | Online needs a 3- or 4-column layout, one date format, 350 KB or less and up to 1,000 lines. | Upload the QBO file instead. You won't need to map columns in QuickBooks. |
CSV to QBO questions
Upload your bank CSV above, check the column mapping and date format, and download the QBO file. Then upload it in QuickBooks Online through Link account › Upload from file. In QuickBooks Desktop, use File › Utilities › Import › Web Connect Files.
Yes. QuickBooks Online accepts CSV uploads, but the file must use 3 or 4 columns and one date format. It also has to be 350 KB or less, with up to 1,000 lines. You map the columns on every upload. A QBO file arrives with those details already set, plus a unique ID per transaction.
Not through Web Connect, which is how QuickBooks Desktop takes bank transactions from a file. Convert the CSV to QBO first, then import it with File › Utilities › Import › Web Connect Files.
Transaction IDs help your software recognise previously imported transactions. Review duplicate matches and overlapping date ranges; an ID is not a guarantee that every import will be de-duplicated.
Both are common. QBO is the Web Connect file type, and people also use QBO as short for QuickBooks Online. This converter makes the file type, and that file works in QuickBooks Online and QuickBooks Desktop.
Yes. Converting CSV to QBO here is free, and you don't need an account. Files are encrypted with AES-256 and deleted automatically.
You assign categories during review in QuickBooks, just as you would with a bank feed. If you're unsure which account or category to use, ask your accountant.
Limitations
Use the details for the bank that holds your account. A directory listing or an Intuit bank ID does not guarantee acceptance by QuickBooks or Quicken; your edition, subscription and the institution's Web Connect support also matter.
File privacy
File-converter uploads and results are temporarily stored in private storage. Uploads are deleted after a successful conversion; abandoned uploads and results are automatically deleted after about an hour. Download links are temporary.