Skip to content
BookkeepKit

Convert Excel Transactions to QBO

Have transactions in a spreadsheet: a bank's .xlsx export, a client's workbook or a list typed by hand? Convert it into a QBO file QuickBooks Online and Desktop import directly.

Drop an Excel file here

.xlsx, .xls, .xlsm or .ods. CSV, PDF and OFX work too.

Processed in your browser. Your files never leave your computer.

Pro and Business: drop several statements at once to convert them in one go.

How it works

  1. 1

    Drop the workbook

    Excel .xlsx, .xls or .xlsm, or a sheet downloaded from Google Sheets. Pick the right tab if there are several.

  2. 2

    Match the columns

    Date, description and amount, or separate debit and credit columns. Real Excel dates and numbers are read exactly.

  3. 3

    Review and download

    Fix anything that looks wrong, check the balance, and download the QBO file.

Why spreadsheets are a common starting point

Many banks offer an Excel export alongside CSV. Bookkeepers also receive transactions in spreadsheets from clients who track cash spending by hand, from payment platforms, or from previous accountants. QuickBooks Desktop can't import those directly, and QuickBooks Online's CSV upload is picky about layout. Converting to QBO turns any reasonably clean sheet into a file that imports in one step.

Preparing the sheet

The converter is tolerant, but a few habits make it effortless:

  • One transaction per row, with a single header row above the data. Title rows above the header are fine; they're skipped.
  • Dates as real dates. Excel date cells are read exactly. Text dates in US format (01/05/2026) also work.
  • Amounts as numbers, either one signed column (negative for money out) or two columns for debits and credits.
  • No merged cells in the transaction area. They can shift values into the wrong column.

How the workbook is read

The file is opened in your browser. The first sheet with data is selected, the header row is found, and each column is matched to its role from its name or its contents. Cells keep their real type: a date cell stays a date, so there's no risk of 03/04 becoming April 3rd, and a number cell keeps every cent. If the detection is unsure, the column matching panel opens with a preview of the first rows.

From workbook to QuickBooks

  1. Drop the workbook and confirm the sheet and columns.
  2. Enter the opening and closing balances if you have them, so the converter can check the total.
  3. Download the QBO file.
  4. In QuickBooks Online, go to Transactions > Bank transactions > Link account > Upload from file. In QuickBooks Desktop, use File > Utilities > Import > Web Connect Files.

Large workbooks

A year of transactions for a busy account can produce a QBO file over QuickBooks Online's 350 KB limit. The converter splits it into consecutive date ranges automatically and explains the order to import them in. QuickBooks Desktop has no such limit, but the split files work there too.

Frequently asked questions

Which spreadsheet formats work?

Excel workbooks (.xlsx, .xlsm, .xls) and OpenDocument (.ods). From Google Sheets, use File > Download > Microsoft Excel or CSV.

My workbook has several sheets. Which one is used?

The first sheet that contains data is selected automatically. If it's the wrong one, open the column matching panel and choose another sheet.

Dates show as numbers like 46027. Is that a problem?

No. That's how Excel stores dates internally. Both real date cells and date serial numbers are converted to the right calendar date, whatever your time zone.

Can I use a spreadsheet I typed myself?

Yes. A header row with Date, Description and Amount is enough. Use negative numbers for money out, or separate Debit and Credit columns.

What about formulas and totals rows?

The calculated values are used, not the formulas. Rows without a valid date, such as totals or notes, are skipped and listed.

Can I convert to something other than QBO?

Yes. The same file can be downloaded as QFX, OFX, QuickBooks CSV, Xero CSV, Wave CSV or IIF for QuickBooks Desktop.

Guides

    Statements from a specific bank: Chase statement converter · Bank of America statement converter

    Related tools