Skip to the converter
StatementZap

Guides

How to convert an Excel bank statement to QBO

Turn an .xlsx or .xls bank statement into a QuickBooks Web Connect file.

  1. 1

    Start from the workbook

    Use the .xlsx or .xls file from the bank, or the sheet you already cleaned up. The first row of the sheet should be the column names. A totals row at the bottom is skipped.

  2. 2

    Choose the sheet

    Upload the workbook on the Excel to QBO page. If it has more than one sheet, pick the sheet that holds the transactions. The other sheets are not read.

  3. 3

    Map the columns

    Set Date, Description, and Amount, or a Debit and Credit pair. If a date such as 03/04/2026 could be March 4 or April 3, choose MM/DD/YYYY or DD/MM/YYYY. A bank preset fills this in when the headers match.

  4. 4

    Download QBO and import it

    Download the QBO file. In QuickBooks Desktop choose File, Utilities, Import, Web Connect Files, and pick the register. QuickBooks Online needs the CSV download instead of QBO.

Questions

Can I convert a CSV the same way?

Yes. A CSV is one sheet. Use the CSV to QBO page, or drop the CSV on the Excel page. Both write the same QBO file.