Why convert for QuickBooks Online?
- The numbers tie out. A balance-reconciliation check compares opening + transactions against the closing balance and verifies any running balances, flagging anything that doesn't add up — so a misread amount doesn't reach your books.
- Built for the QBO upload flow. The 3-column Date / Description / Amount layout is exactly what QuickBooks Online's Upload from file importer expects, so mapping is trivial.
- Under the upload limit automatically. Long statements are split into parts that stay inside QuickBooks' import limits — no manual trimming.
How it works
- Open the converter. No registration is required.
- Upload the statement. Drag and drop your PDF, or browse from your device.
- Convert to QuickBooks CSV. Choose QuickBooks CSV as the target format and click Convert.
- Upload in QuickBooks Online. Preview the extracted rows, unlock the full CSV (one-time $15), review any flagged rows, then go to Transactions → Link account → Upload from file and map the columns.
What gets flagged
Before the CSV is handed back, a deterministic reconciliation check runs. It flags the statement for review when:
- A row's printed running balance doesn't equal the previous balance plus that row's amount.
- The opening balance plus the sum of every transaction doesn't equal the closing balance.
- The transaction dates run out of order — a later row dated before an earlier one.
- No transactions could be read from the statement at all.
Flagged rows are surfaced for you to review — never silently exported as reconciled. You upload into QuickBooks Online with the totals already tied to the statement, or with a clear list of which rows to check first.
Good for
- Getting a closed-account or feed-less bank into QuickBooks Online.
- Catch-up bookkeeping across many months at once.
- Statements too long for a single QuickBooks upload.
The exact CSV you get
QuickBooks Online accepts two bank-statement CSV shapes, and this converter writes whichever you pick:
- 3-column (default) —
Date, Description, Amount, where money in is positive and money out is negative. - 4-column —
Date, Description, Credit, Debit, splitting the sign into two columns; only one of the two is filled per row.
Dates are written MM/DD/YYYY, the format QuickBooks Online expects for US organisations. Descriptions are whitespace-normalised so a description wrapped across two lines in the PDF arrives as one clean field.
Long statements are split automatically. QuickBooks Online limits how much one CSV import can carry. Rather than push a file up against that ceiling, the converter splits output into parts of at most 1,000 transactions and roughly 350 KB each — deliberately conservative, so size is never the reason an import fails. Each part carries its own header row and imports on its own without you editing anything. A year of a busy current account usually lands as two or three files.
FAQ
How do I upload the file in QuickBooks Online? Go to Transactions, choose Link account, then Upload from file, and select the CSV. Map the Date, Description, and Amount columns, pick the bank account, and confirm — QuickBooks then shows the transactions for review before you add them.
Why did my statement come back as several files? QuickBooks Online caps how much it will take in one CSV import. Rather than send a file to the edge of that ceiling, the converter splits long statements into parts of at most 1,000 transactions and roughly 350 KB each, deliberately conservative so an import is not rejected for size. Each part carries its own header row, so you upload them one after another and nothing needs editing.
What happens to rows that don't reconcile? They're flagged, not dropped. The transaction still appears in the file, but the statement is marked as needing review with the specific checks that failed, so you can verify against the original PDF before importing. Nothing that fails the balance check is passed off as reconciled.
Is my financial data safe? Files are deleted after 1 hour, never used to train any AI model, and we never connect to your bank. All transfers are encrypted. This is a conversion utility, not financial, tax, or accounting advice.
Related
- Bank statement → QuickBooks → QuickBooks generally, incl. Desktop
- PDF → QBO (Web Connect) → import as a .qbo bank feed
- Bank statement → CSV → a plain spreadsheet
- All supported formats →