Runs entirely in your browser — your file is never uploaded to a server.
Drop your file below — runs entirely in your browser, nothing is uploaded.
A CSV file means your bank gave you structured data — which most banks only do for the last few months. Beyond that you get a PDF, and a PDF won't open in Excel. BalanceExtract reads those directly: it works out the column layout from the document itself, handles scanned statements with OCR, checks that every running balance reconciles, and flags any row it isn't confident about before you export.
Same OFX output, same on-device processing, nothing uploaded.
Drag the file onto the box above or click to browse. It is read in your browser — nothing is uploaded to a server, which you can confirm in the Network tab.
Every transaction is read out with its date, payee, description, amount and transaction ID, along with any warnings about rows that need a look.
The OFX file saves straight to your device, ready to open in a spreadsheet or import into your accounting software.
OFX (Open Financial Exchange) is a bank-neutral, standardized transaction-import format that most accounting software treats as a live feed rather than a static file. This guide covers what's inside an OFX file and when it's genuinely the better choice over a plain CSV.
Getting a CSV to actually reconcile itself against a bank feed in QuickBooks or Xero, instead of landing as an inert list you have to categorize by hand, is what OFX is for. OFX is built for automated reconciliation, not eyeballing — accounting software matches and categorizes OFX imports the way it would a live bank connection. This converter reads any CSV with a date, description, and amount column, and builds a standard STMTTRN transaction list.
| Field | What It Contains |
|---|---|
| DTPOSTED | Transaction date |
| TRNAMT | Signed amount |
| NAME | Payee or description |
| FITID | A unique transaction ID, used by accounting software to avoid duplicate imports |
| TRNTYPE | CREDIT or DEBIT |
Honest side-by-side write-ups, including where each of them is the better choice.