Export format
Bank statement to QuickBooks converter
3-column Date / Description / Amount CSV that QuickBooks Online accepts in Banking → Upload transactions. Any bank, digital or scanned PDF, with the running balance reconciled before you import anything.
What's in the QuickBooks file
- 3-column format: Date (MM/DD/YYYY), Description, Amount — negative for money out.
- Import it in QuickBooks Online: Transactions → Banking → Upload from file.
- One CSV per account; QuickBooks matches rows to your existing rules.
The extracted data
| A · Date | B · Description | C · Debit | D · Credit | E · Balance | |
|---|---|---|---|---|---|
| 1 | 2026-08-02 | CARD PURCHASE 08/01 STARBUCKS #2231 NEW YORK NY | 6.85 | 4,805.55 | |
| 2 | 2026-08-03 | ACH DEBIT CON EDISON UTILITY PAYMENT | 142.19 | 4,663.36 | |
| 3 | 2026-08-04 | ZELLE PAYMENT FROM J. MARTINEZ | 350.00 | 5,013.36 | |
| 4 | 2026-08-08 | DIRECT DEPOSIT ACME CORP PAYROLL | 3,240.00 | 7,664.94 | |
| 5 | 2026-08-12 | CHECK #1042Verify — read from image | 130.00 | 7,534.94 |