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 QBO 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 QBO file saves straight to your device, ready to open in a spreadsheet or import into your accounting software.
Getting a CSV to actually reconcile itself against a bank feed in QuickBooks, instead of landing as rows you have to categorize by hand, means turning it into QBO first. This guide covers what's inside the file this tool produces.
QBO is QuickBooks' own Web Connect format, built on the same underlying structure as OFX. This converter reads any CSV with a date, description, and amount column, and builds a standard QBO transaction file QuickBooks Online and Desktop both accept as a real bank feed.
| Field | What It Contains |
|---|---|
| DTPOSTED | Transaction date |
| TRNAMT | Signed amount |
| NAME | Payee or description |
| FITID | A unique transaction ID, used by QuickBooks to avoid duplicate imports |
Honest side-by-side write-ups, including where each of them is the better choice.