CSV to QBO converter for QuickBooks
Turn a bank CSV export into a QuickBooks Web Connect (.qbo) file, or into OFX for Xero and Wave, or QIF for Quicken. The columns are matched up automatically and nothing leaves your browser.
How to use it
- Export a CSV from your bank, Monzo/Starling/Revolut/Wise app, or spreadsheet.
- Drop it above. Rowledger works out the date, description, amount (or debit and credit) and balance columns. Adjust any it gets wrong.
- Pick the account type (bank or credit card) and download the QBO. Import in QuickBooks via File → Utilities → Import → Web Connect Files (Desktop) or Transactions → Upload from file (Online).
Have a PDF statement rather than a CSV? Use the statement converter instead. It checks the rows against the printed balances first.
Questions
What is a QBO file?
A QBO (Web Connect) file is the format QuickBooks Desktop and QuickBooks Online import from. It is an OFX file with an Intuit bank identifier. Each transaction carries a unique ID so re-imports don't duplicate.
Which CSV layouts are recognised?
Any CSV with a date column and either a signed amount column or separate debit/credit columns. Headers are detected automatically and can be remapped. Bank exports from Monzo, Starling, Revolut, Wise, Chase, Capital One and most others work directly.
Why does QuickBooks reject my CSV but accept the QBO?
QuickBooks' CSV importer is strict about date formats, encodings and column counts. QBO files avoid all of that and carry transaction IDs.
Is my data uploaded?
No. The conversion runs in your browser. You can do it offline.
What is the free limit?
Free converts files up to 25 transactions. Pro removes the limit and adds OFX/QIF and batch.