Free tool
CSV to QBO converter for QuickBooks Online
Turn any bank or credit card CSV into a .qbo file that QuickBooks Online imports cleanly, with no column mapping in QuickBooks and no duplicate transactions. Free, no signup, and your file never leaves your browser.
- Free, no signup
- Runs in your browser: nothing is uploaded
- Tested in QuickBooks Online, October 2026
Your file. Your review. Ready to import.
How it worksStep 1
Choose your bank or card CSV
Your file is processed in this browser tab. It is never uploaded to our servers.
Works with QuickBooks Online. QuickBooks Desktop isn’t supported yet.
How to convert CSV to QBO
- Export a CSV from your bank. In online banking, open the account’s activity and look for Download or Export. Choose CSV (sometimes labelled “Spreadsheet”) and the date range you need.
- Choose the file above and check the columns. The converter finds the headings, date format and amount columns on its own. Change anything that looks wrong and review the transactions in the preview.
- Download the .qbo and import it. In QuickBooks Online, go to Transactions → Bank transactions, open the Link account menu and choose Upload from file. Pick the matching account, then review the transactions under For review.
Why convert CSV to QBO instead of uploading the CSV?
We uploaded the same transactions both ways into a QuickBooks Online test company. The .qbo file was accepted with fewer steps and without the duplicates.
| CSV upload | .qbo from this converter | |
|---|---|---|
| Messy bank exports | In our test, a typical export with account details above the headings and a totals row was rejected outright | The converter removes those lines before building the file |
| Uploading an overlapping date range | Every transaction is added again | QuickBooks skips the ones it already has |
| Column mapping | You confirm the columns and date format on every upload | No mapping screen: choose the account and continue |
| Credit card signs | Charges can arrive as money in if the export lists them as positive | Charges import as spending and payments as card payments |
Why your CSV won’t import into QuickBooks
When QuickBooks Online rejects a bank CSV, it usually shows one message and no detail: Your file does not contain the three required columns: transaction date, memo and amount.
These are the usual causes, and what the converter does about each.
| Cause | How the converter handles it |
|---|---|
| Lines above the column headings (account name, statement period) | Found and skipped automatically; the preview tells you how many. |
| A totals or balance row at the end | Rows without a valid date are skipped and listed so you can check them. |
| Extra columns such as balance, type or category | Ignored unless you map them. |
| Separate withdrawal and deposit columns, or 0.00 in the unused one | Combined into one signed amount; zero rows are dropped. |
| Day-first dates (31/01/2026) or dates that could be read either way | Detected from the whole file. If every date is ambiguous, you are asked to confirm. |
| Descriptions that are only a number, such as a check number | Rewritten as “CHECK 1042” (or “REF 1042” without a check number column). |
| Currency symbols and thousands separators ($2,450.00) | Read correctly, as are amounts in parentheses and trailing minus signs. |
Frequently asked questions
Does QuickBooks Online accept CSV files?
Yes. QuickBooks Online imports 3-column (date, description, amount) and 4-column (date, description, credit, debit) CSV files. But it rejects some real bank exports, makes you map columns on every upload, and doesn't check CSV uploads for duplicates. A .qbo file avoids all three.
Why won't my CSV file upload to QuickBooks?
The most common causes are extra lines above the column headings, a totals row, extra columns, and dates in a format QuickBooks doesn't expect. QuickBooks often just says “Your file does not contain the three required columns: transaction date, memo and amount.” Run the file through the converter above and it handles each of these.
Is this CSV to QBO converter really free?
Yes. There's no signup, no watermark and no limit on downloads. The converter runs in your browser, so it costs us nothing to run per file.
Is my financial data safe?
Your file is read and converted inside this browser tab. It is not uploaded to Bumblebee or anyone else, and our analytics never record file contents, only counts such as how many transactions were converted.
Will I get duplicate transactions?
Not from overlapping .qbo files. Each transaction gets an ID built from its date, amount and description, so the same transaction gets the same ID in every export, and QuickBooks skips IDs it has already imported. We confirmed this in QuickBooks Online: a file with 4 repeats and 2 new transactions added only the 2 new ones.
Does it work with credit card statements?
Yes. Choose “Credit card” as the account type. Most card exports list charges as positive numbers, so the converter suggests reversing the signs, and the .qbo is written as a credit card statement that QuickBooks recognises.
Can I convert an Excel file to QBO?
Save it as CSV first: in Excel, choose File → Save As → CSV. Direct Excel upload is coming soon.
Does it work with QuickBooks Desktop?
This version is built and tested for QuickBooks Online only. If you use Desktop, tell us with the button in the converter so we know to prioritise it.
Which banks does it work with?
Any bank that exports transactions as CSV. It recognises common column names, including Chase's checking and credit card layouts, and falls back to reading the values when the headings are unusual. You can always change the columns it picks.
Cleaning bank files for every client, every month?
A converter fixes one file. We build AI applications for accounting firms that take recurring work like bank file cleanup off your team’s plate, with your review before anything is posted.