Bank statement → QuickBooks
Convert a PDF statement into the formats QuickBooks imports: OFX, or the three-column CSV — Date, Description, Amount — it takes natively, with money out already signed negative so you are not fixing signs by hand.
Northbank
Current account · GB29 NWBK 6016 1331 9268 19
STATEMENT
| Date | Description | Out | In | Balance |
|---|---|---|---|---|
| 01/03 | SALARY — ACME LTD | 3,200.00 | 4,061.20 | |
| 03/03 | TESCO STORES 2841 | 84.30 | 3,976.90 | |
| 05/03 | SHELL FUEL BRISTOL | 61.75 | 3,915.15 | |
| 07/03 | RENT — HARBOUR LETTINGS | 1,150.00 | 2,765.15 |
The Excel you get back
| Date | Description | Out | In | Balance | Category |
|---|---|---|---|---|---|
| 01/03/2026 | Salary — Acme Ltd | 3,200.00 | 4,061.20 | Income | |
| 03/03/2026 | Tesco Stores 2841 | 84.30 | 3,976.90 | Groceries | |
| 05/03/2026 | Shell Fuel Bristol | 61.75 | 3,915.15 | Fuel | |
| 07/03/2026 | Rent — Harbour Lettings | 1,150.00 | 2,765.15 | Rent |
Drop your bank statement PDF
PDF · photo · iPhone HEIC · scan · zip · Word — mix them freely, no sign-up to try
Your first document converts free and the Excel downloads — no sign-up. $7 for a whole batch.
How it works
- 1
Drop the statements
A month, or a year. Any bank. Scans and photos work too.
- 2
It reads them
Every transaction transcribed as printed, with the direction of the money kept straight.
- 3
Upload to QuickBooks
Take the OFX or the CSV and import it through QuickBooks' own upload — no bank connection required.
Columns QuickBooks already understands
Date, Description, Amount, in that order, with expenses negative. Nothing to map, no import wizard to fight, no column that lands in the wrong field.
Accounts QuickBooks cannot connect to
A closed account, a foreign bank, a client who arrives with a shoebox of PDFs. The bank feed cannot help you there; a PDF is all this needs.
Categories filled in
Every row also comes with an expense category in the Excel version, so the classification work is done before you even open the books.
Questions people ask
- Can it read a scanned or photographed document?
- Yes. Scans and phone photos are read the way a person reads them — a crumpled receipt or a skewed scan still works, and there is no template to configure for each bank.
- What if one PDF holds many receipts?
- It splits them apart. Fifty receipts scanned into a single PDF become fifty rows; a twelve-page statement stays one document.
- Are the amounts real numbers in Excel?
- Yes. Amounts and balances arrive as numeric cells, so a column sums the moment you open the file.
- How are foreign currencies handled?
- Each amount is converted at the published rate for the date of that transaction — not today's rate. The rate and its date sit beside the figure so you can check it.
- Do I need an account?
- No. The first document converts free and you can download the Excel without an account. Pay $7 once for a whole batch; an account is only for a monthly page allowance.
- Does it work with QuickBooks and Xero?
- Yes. Alongside Excel, you can download a statement as OFX — the standard bank-data format both read — or as a ready-made CSV laid out the way each one expects: Date, Amount, Payee, Description, Reference for Xero, and the three-column Date, Description, Amount for QuickBooks, with money out already signed negative. Invoices and receipts can also come out as UBL XML for an ERP or an e-invoicing system.