StatementToExcel

QuickBooks Online · 3 columns · outflows negative

Bank statement to QuickBooks Online CSV

QuickBooks Online does not want a general-purpose CSV. It wants three columns, one header row and correctly signed amounts — and a date it can parse. Pick the QuickBooks preset and choose the date format your company file uses.

Drop your bank statement here

PDF from online banking, or an OFX / QFX export. Click to choose, or paste with Ctrl/⌘+V.

Text-based PDF up to 60 MB / 200 pages, or .ofx / .qfx

Never uploaded — conversion happens in your browser No sign-up, no email Rows checked against the statement's running balance

The format QuickBooks expects

Date,Description,Amount
01/04/2025,ACME PAYROLL DEPOSIT,317.92
01/06/2025,INSURANCE PREMIUM AUTO,-806.84
01/09/2025,CHECK #1042,-88.50

Three columns, nothing else. Deposits positive, payments negative. If your statement prints withdrawals as positive numbers in a separate column, the converter still writes them negative here — that is the point of the preset.

Before you import

  • Check the date format. Match your QuickBooks company file. This is the most common reason an import is rejected.
  • Check the period. Export one statement at a time so the rows land in the right period and you can compare totals afterwards.
  • Know your balance. The statement's closing balance is on the Summary sheet — it is how you confirm the import completed.
  • Do not double-import. If the account already has a live bank feed, uploading the same period creates duplicates in the review queue.

Importing the file into QuickBooks Online

QuickBooks moves this around between releases, so the wording below may differ slightly in your version. The sequence does not change.

  1. Open Banking (or Transactions, depending on your version).
  2. Choose the bank account you are importing into. If it has no live feed, use the option to upload transactions from a file rather than connecting a bank.
  3. Select Upload from file and choose the CSV you downloaded. Set the delimiter if asked — the file is comma-separated.
  4. Map the columns. QuickBooks usually detects Date, Description and Amount from the header row; if it does not, select them manually. The date format question refers to the format usedin the file.
  5. Review the transactions in the For review queue, then accept them.

Confirming it worked

Compare three numbers: the number of rows in your CSV, the number of transactions in the review queue, and the closing balance on the statement. If the row counts match and the final running balance matches the statement's closing balance, the import is complete. That check is exactly what the tool's balance verification is for.

If the import fails

  • "We couldn't read your file" — usually the date format. Re-download with the format your company file uses.
  • Everything lands in one column — the delimiter selection. Confirm comma is chosen, not semicolon or tab.
  • Amounts come in as text — indicates thousands separators were quoted oddly. The converter writes plain numbers like -1234.56 with no currency symbols or separators, so this should not occur; if it does, check the file was not edited in a spreadsheet that re-formatted the column.

Questions people actually ask

What CSV format does QuickBooks Online accept?

For the "Upload from file" route in Banking, QuickBooks Online expects three columns: Date, Description and Amount. There must be one header row, one row per transaction, and outflows must be negative — a payment of 806.84 is -806.84, while a deposit of 317.92 is 317.92. The QuickBooks preset produces exactly those three columns in that order.

How should the dates be formatted?

QuickBooks expects the date format matching your company file and locale — commonly MM/DD/YYYY in the United States and DD/MM/YYYY elsewhere. The QuickBooks preset defaults to MM/DD/YYYY; change it in the Date format dropdown before downloading if your QuickBooks uses a different one. A date QuickBooks cannot read is the single most common cause of a failed import.

Why negative amounts?

Because QuickBooks has to know which direction money moved. A statement that shows withdrawals in their own column as positive numbers loses that information when it becomes a single Amount column. The converter writes money out as negative, derived from the column the value was printed in and cross-checked against the running balance.

Will the import duplicate transactions I already have?

It can, if your bank account is already connected and downloading the same transactions. Uploading a CSV adds rows to the review queue; QuickBooks will not match them against existing entries for you. If the account is already connected, this is usually not the tool you want — it is for accounts with no live feed.

What about Category, Payee and Memo columns?

QuickBooks does not need them, and a file that includes them will simply have more columns to map. Keep the import to Date, Description and Amount, then categorise in QuickBooks where the rules engine can help you. The tool's own Excel workbook keeps debit, credit and balance columns if you want the fuller picture alongside.

Is my banking data sent to QuickBooks by this tool?

No. The converter never talks to Intuit or to anyone else. It writes a file on your machine; you upload that file to QuickBooks yourself, through your own logged-in session.