Convert CSV to QBO
Convert CSV bank transactions into QuickBooks format
CSV Input
Try a sample:
Drop a CSV file here or
Only the first file is used if multiple are dropped.
The request is made directly from your browser. No proxy is used.
Account Details
Column Mapping
Provide CSV input above to map columns.
QBO Output
QBO output will appear here...
More Options
CSV Format
Input
Financial Institution
How to Use This Tool
This tool converts bank statement CSVs into QBO (QuickBooks Web Connect) files directly in your browser. No data is uploaded or sent to any server.
- Provide your bank statement — Paste CSV text, upload a file, or try the sample dataset.
- Map your columns — Tell the tool which columns contain the date, amount, and description. Supports both single-amount and separate debit/credit columns.
- Enter account details — Provide your account type, routing number, and account number. Your account number is obscured for security.
- Download your QBO file — Copy or save the output for import into QuickBooks.
FAQ
5 questionsDoes this tool upload my bank statement data?
No. All conversion happens entirely in your browser using JavaScript. Your financial data never leaves your device.
What is QBO format?
QBO (QuickBooks Web Connect) is an OFX-based format that QuickBooks Desktop and QuickBooks Online use for importing bank transactions.
What account details do I need?
You need your account number and routing number (for bank accounts). Your account number is obscured in the form and only the last 4 digits appear in the output.
Do I need to enter an ending balance?
It's optional but recommended. QuickBooks Desktop and Quicken may require an ending balance. If you leave it empty, the tool uses 0.00.
What are FID and INTU.BID?
These are financial institution identifiers that QuickBooks uses to verify the source. The default value of 3000 works for most imports. You can find your bank's specific IDs in an existing QBO file from your bank.