CSV to QBO converter
Turn a bank or credit card CSV into a QBO file. Review the transactions before you download.
How to convert CSV to QBO
- Choose a transaction file. Export a CSV from your bank or credit card provider, or try the fictional sample above.
- Match your columns. Select the date, description and amount columns. If the file uses separate income and expense columns, select both. Confirm the date order and how the file represents expenses.
- Review and download. Compare the transaction count, date range and totals with your source. Enter the destination account details, then download the QBO file.
What your CSV should look like
Download sample CSVUse a UTF-8 CSV or TSV with a header and one transaction per record, up to 2 MB and 15,000 records. Commas, semicolons and tabs are supported. Use a four-digit year and USD amounts.
| Date | Description | Amount |
|---|---|---|
| 2026-10-01 | Fictional payroll | 1500.00 |
| 2026-10-02 | Example Books, Inc. | -42.50 |
| 2026-10-07 | Fictional refund | 29.95 |
Common CSV mapping errors
- Ambiguous dates: 10/04/2026 can mean October 4 or April 10. Match the date order used by your bank and check a known transaction in the preview.
- Reversed amounts: If your CSV has separate debit and credit columns, map them separately. Compare one deposit and one expense with your statement before downloading.
- Extra rows: Keep one header and the transaction rows. Remove report titles and summary totals before selecting the file again.
Using QuickBooks Online? Check whether you can upload your bank CSV directly before converting it.
Frequently asked questions
What is a QBO file?
A .qbo file is a QuickBooks Web Connect transaction file. Unlike a CSV, it includes account and financial institution fields alongside the transaction data.
Can I import this file into QuickBooks?
This preview generates a QBO file. Import compatibility has not yet been verified in QuickBooks. See the QuickBooks import guide to check your edition. QuickBooks Online can also accept CSV bank transactions directly when the file meets its requirements.
What if my dates or amounts are rejected?
Check the selected date order, the amount columns and the income and expense convention. For a CSV with extra title or balance rows, remove those rows and keep one header followed by transactions. The converter reports invalid records and blocks export until they are fixed.
Can I convert an Excel file or a PDF statement?
For an Excel sheet, save or export the transaction tab as UTF-8 CSV first. PDF statements are outside the scope of this converter.
Are my transactions uploaded or saved?
The file and conversion settings stay in the browser. There is no conversion history. Your downloaded QBO stays on your device. See file privacy.