When one statement covers several accounts, every transaction keeps its account in the CSV and Excel files, in an Account Number column. Some import formats put all the accounts in one list, so split them before you import.
How each format shows the accounts
| Format | How accounts appear |
|---|---|
| CSV and Excel | An Account Number column on every row. |
| OFX, QFX (Quicken) and QuickBooks (.QBO) | Each account in its own statement block, in the same file. |
| QuickBooks (CSV), Xero, FreshBooks and QIF (Quicken) | No account column. All the accounts' transactions are in one list. |
| API (JSON) | One entry per account, with the last four digits of the account number. |
OFX, QFX and QBO files label each account as a checking account, so your accounting software may ask which account to import into. Pick the matching account.
Steps: split accounts before importing a one-list format
- Sign in and open History. Download the statement as CSV.
- Sort or filter the CSV by Account Number to see which transactions belong to which account.
- Download the format you need from History. Downloading again doesn't use another credit.
- Using the CSV as your guide, split the import file into one file per account.
- Import each file into the matching account in your accounting software.
If something goes wrong
- Transactions from two accounts landed in one account. Remove that import in your accounting software, split the file by account, and import again.
- You can't find an Account Number column. You're looking at a format without one. Download the CSV or Excel file instead.
- Your software asks which account to use. Choose the account that matches the statement block you're importing.