Bank statements to QuickBooks, verified to the cent
A 3-column or 4-column CSV formatted for QuickBooks Online bank feeds, importable via Transactions → Bank transactions → Upload from file.
Before any file leaves Parseledger, the extracted figures must reconcile against the statement's own balances — opening + credits − debits = closing, checked line by line. What you import into QuickBooks is provably consistent with the paper.
| Date | Description | Amount | Balance |
|---|---|---|---|
| Opening balance | |||
| 06-012026-06-01 | Acme Consulting Ltd — invoice 0142 | ||
| 06-032026-06-03 | HMRC VAT | ||
| 06-052026-06-05 | WeWork — office | ||
| 06-092026-06-09 | Tesco | ||
| 06-122026-06-12 | Stripe payout | ||
| 06-162026-06-16 | Salary — J. Doe | ||
| 06-202026-06-20 | Adobe Creative Cloud | ||
| 06-242026-06-24 | Client refund — invoice 0139 | ||
| 06-272026-06-27 | Bolt & Sons — invoice 0143 | ||
| 06-302026-06-30 | Bank charges | ||
| Closing balance | |||
This is the check every statement goes through. Try fixing the flagged row — the amount was misread as 68.44; the statement says 64.88.
Live demo — this is the real verification engine. Click the flagged amount and fix it.
Importing the file into QuickBooks
- 01
In QuickBooks Online, go to Transactions → Bank transactions.
- 02
Select the account, then choose Upload from file (under the Link account dropdown).
- 03
Upload the CSV Parseledger produced. It follows the QuickBooks 3-column or 4-column layout, so QBO maps date, description and amount without manual fiddling.
- 04
Confirm the mapping, import, and categorise as usual. The imported lines sum to the statement closing balance because the file was reconciled before it was exported.
Convert your bank's statements to QuickBooks
United Kingdom
- Monzo statements to QuickBooks
- Starling Bank statements to QuickBooks
- Revolut statements to QuickBooks
- Barclays statements to QuickBooks
- Lloyds Bank statements to QuickBooks
- HSBC statements to QuickBooks
- NatWest statements to QuickBooks
- Santander UK statements to QuickBooks
- Nationwide statements to QuickBooks
- TSB statements to QuickBooks
- Metro Bank statements to QuickBooks