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.
Not a PDF? Free file converters: CSV to QBO converter · OFX to QBO converter · QFX to QBO converter · QIF to QBO converter
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 |
QuickBooks questions
How do I import a bank statement CSV into QuickBooks Online?
In QuickBooks Online go to Transactions → Bank transactions → Link account → Upload from file, choose the Rowvert QuickBooks CSV, map it to the right account and confirm. The 3-column layout (Date, Description, Amount) is recognised automatically.
CSV or .qbo — which is better for QuickBooks?
QuickBooks Desktop only imports .qbo (Web Connect). QuickBooks Online accepts both; .qbo also carries the closing balance and transaction IDs that prevent duplicates, so prefer it when you can.
Why does QuickBooks reject my CSV?
Usually a date format or a column mismatch. The Rowvert QuickBooks CSV uses MM/DD/YYYY dates and one signed Amount column, which is what QuickBooks Online expects for US companies.
Can I import older months when the bank feed only goes back 90 days?
Yes — that is the most common use. Download the older PDF statements from your bank, convert them, and upload each month's file.