How to convert an Excel bank statement to QBO
Turn an .xlsx or .xls bank statement into a QuickBooks Web Connect file.
- 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
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
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
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.
- Files over 4 MB are refused. A statement that is only a PDF is converted from the PDF pages, not by saving it as Excel first.
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.