Bank statement · QuickBooks Online
Bank statement to QuickBooks Online, verified
Upload a PDF, scanned, or photographed bank statement and get back a file built for QuickBooks Online’s own bank-transaction importer: a 3-column CSV (Date, Description, Amount) or an OFX file, with every transaction reconciled against the statement’s stated opening and closing balance before you download.
CSV or OFX: which should you pick?
CSV
the simpler, one-off route: QuickBooks Online maps its own Date/Description/Amount columns for you during upload, and you can eyeball every row before confirming the import.
OFX
QuickBooks Online also accepts a bank statement as a Web Connect file (QuickBooks’ own help center lists OFX alongside QFX and QBO as accepted formats). Pick OFX if you’d rather skip the column-mapping step, or if you’re importing the same statement into more than one ledger and want one file that works for both QuickBooks and Xero.
Importing into QuickBooks Online, step by step
- 1In QuickBooks Online, go to All apps, then Accounting, then Bank transactions.
- 2Select the account tile you want to import into (or, if it isn’t connected yet, continue to the next step).
- 3Open the Link account dropdown and choose Upload from file (shown as "Or upload transactions manually" for an account with no bank connection).
- 4Drag in (or select) the CSV file Arkrel generated, then select Continue.
- 5In the QuickBooks account dropdown, pick the destination account (or Add New to create one), then Continue.
- 6Tell QuickBooks about the file: the first row is a header (Yes), amounts are in One column, and the date format is MM/dd/yyyy for a US-dollar statement (QuickBooks US preselects it, and Arkrel writes month-first dates for US-dollar statements) or dd/MM/yyyy for any other currency. The columns then map on their own: Date, Description, Amount. Continue.
- 7Select which rows to import, then Continue.
- 8Select Yes to confirm the transaction count, then Done.
- 9Review the imported activity on the Bank transactions page for the selected account. Check items awaiting review and any transactions automatically posted by bank rules before completing the account’s accounting review.
How the balance is verified first
Arkrel reconciles the extracted totals against the printed opening and closing balance before export. The dashboard and free tool show any mismatch in our reading. The results identify the affected transaction numbers when running-balance checks locate them. You can still export the file, with an X-Arkrel-Checks: failed marker for API and automation use when reconciliation fails. Tested in Intuit’s official developer sandbox, a fully functional QuickBooks Online US company, on September 27, 2026: a 2-page, 60-transaction statement imported from both the CSV (with the upload screen’s default settings, no changes) and the OFX file, with every date, amount and direction matching the statement, and the OFX import showing the statement’s verified closing balance.
Common import errors, and the fix
QuickBooks reads every date one day (or one month) off, or rejects the file outright.
The date format chosen in the upload step must match the file, and every row uses the same one. Arkrel writes MM/dd/yyyy for US-dollar statements (the format QuickBooks US preselects) and dd/MM/yyyy for other currencies, so pick that option; a mismatch silently swaps day and month for any date up to the 12th. If your bank’s original PDF prints a date with no year at all (common on statements that assume the year is obvious from context), Arkrel infers it from the statement’s own period dates automatically; on the rare statement where that’s genuinely ambiguous, the export fails with a specific error naming the row instead of guessing and importing a wrong year.
The upload is rejected as too large, or QuickBooks silently caps how many transactions came in.
QuickBooks Online’s CSV importer is documented at up to 1,000 lines per file and 350 KB per upload. A statement longer than that needs to be split (by date range is easiest) into more than one import.
https://quickbooks.intuit.com/learn-support/en-us/help-article/import-transactions/manually-upload-transactions-quickbooks-online/L0rE9OXBz_US_en_USA transaction shows up twice after re-importing the same statement.
OFX includes a stable transaction ID (FITID) that accounting software can use to recognize a repeat import. IDs repeat for the same file read the same way when its source fingerprint is available. A different file or a changed reading gets different IDs; without a source fingerprint, IDs are specific to that upload. For CSV imports, review the ledger’s own duplicate check. Compare imported transactions with the source, including any overlapping dates.
A deposit and a withdrawal both look positive (or both negative) after import.
QuickBooks’ own worked example for the 3-column format uses a negative number for money out and a positive number for money in; Arkrel’s CSV follows that same convention using the sign the verifier already reconciled against the statement’s balances, so it should never need flipping by hand.
Catching up years of statements at once?
A one-off statement import is what this page covers. For a bookkeeping catch-up spanning years of statements, older PDFs a client handed you, or statements your account's own download window no longer reaches, see the dedicated guide.
Try it now, free
Use the free bank statement pdf to csv/excel tool: no signup, up to 3 pages, results in seconds.
Do I need the paid plan to get the QuickBooks CSV or OFX file?
What if the statement’s balance doesn’t reconcile?
Does this work for a credit card statement, not just a checking account?
By bank
Each bank publishes its own window for downloading transactions natively. See the documented window and the PDF-conversion path for your bank.