Convert an OFX File That Holds Several Accounts
When you export everything at once, many banks put every account into a single OFX file, one statement block after another. Rather than splitting the file by hand, you can convert it in one go and separate the accounts later with a filter.
Your file is never uploaded. The OFX, QFX and QBO converter runs in your browser and makes no network requests while it works. Always review the rows before you use them.
Steps
- Download the combined export from online banking.
- Drop it on the OFX to CSV tool.
- Look at the Accounts summary: there is one line per account with its type, currency, date range, transaction count and ledger balance.
- Download as CSV or Excel. All accounts go into the same sheet.
- Turn on a filter on the Account column to view one account at a time, or copy each account to its own tab.
Good to know
How rows are labelled
Every transaction row starts with the account number and the account type, such as CHECKING, SAVINGS or CREDITLINE, so nothing gets mixed up even when dates overlap.
Transfers between your own accounts
A move from checking to savings shows up twice: negative in one account and positive in the other. If you total the whole sheet, those pairs cancel out, so total per account when you want each balance movement.
Balances per account
The ledger balance in the summary is the one the bank wrote into the file for that account. Compare it with your online banking to confirm the export is complete.
Questions
Is there a limit on accounts per file?
No fixed limit is set; each statement block in the file is read and listed.
Can I mix bank and card accounts?
Yes. Bank and credit card statement blocks in the same file are both read.
Do I need to split the file first?
No. Splitting by hand risks breaking the tags, so convert the whole file and filter afterwards.
Have bank statements as PDFs instead? RowSmith converts text-based PDF statements to CSV or Excel in your browser.
This guide was written with AI assistance and reviewed against the tool's behaviour. Always review your output before using it.
RowSmith is an independent tool and is not affiliated with any bank or software company.