Which file does my software need?
| Software | File to use | Tool |
|---|---|---|
| QuickBooks Desktop | QBO (Web Connect) | CSV to QBO |
| QuickBooks Online | QBO, OFX or a 3-column CSV | CSV to QBO or CSV to QuickBooks Online |
| Quicken for Windows or Mac | QFX (Web Connect) | CSV to QFX |
| Xero, Sage | OFX | CSV to OFX |
| YNAB, GnuCash, Moneydance, PocketSmith | QIF or OFX | CSV to QIF or CSV to OFX |
| Excel or Google Sheets | XLSX or CSV | QBO, QFX and OFX, QIF or IIF to CSV |
How these formats relate
CSV is a plain spreadsheet. Almost every bank can export it, but each bank lays it out differently, which is why accounting software is fussy about importing it.
OFX is the banking industry's standard statement format. It records each transaction with a date, amount, payee and a unique ID, in the same structure no matter which bank produced it.
QFX and QBO are OFX files with a few extra Intuit fields. Quicken looks for QFX and QuickBooks looks for QBO; the transactions inside are the same.
Before you import anything
- Back up your company or Quicken file.
- Use one file per account, and check the account type before you download.
- Compare the totals the tool shows with your statement for the same dates.
- Review the transactions on your software's import screen before you accept them.