Excel to QBO: who needs it
Some banks only export to Excel. Accountants often receive transactions as a spreadsheet from a client. And sometimes you’ve cleaned up a download in Excel — fixed descriptions, removed personal items — and want to import the result. In each case QuickBooks can take a CSV with column mapping, but a QBO file is quicker and carries transaction IDs, which helps QuickBooks avoid duplicates. Converting XLSX to QBO bridges the gap.
Prepare the workbook
- One heading row above the transactions, with names like Date, Description and Amount — or Debit and Credit. Title rows above the headings are fine; the converter finds the heading row.
- Dates as dates. Real Excel dates are read directly. Dates typed as text work too; confirm the day/month order in step 2.
- Amounts as numbers, either one signed column or separate money-out and money-in columns.
- Save as .xlsx. Old .xls workbooks need re-saving as .xlsx first.
Convert Excel to QBO
- Drop the .xlsx file on the converter above. It reads the first sheet in the workbook and names it in the status message, so move the transactions to the first sheet if they’re elsewhere.
- Check the preview: dates, descriptions and amounts, and the totals of money in and out. Open Change which column is which if a column was guessed wrongly.
- In step 3, QuickBooks QBO (Web Connect) is already selected. Set the account type, currency and the last digits of the account number, then download.
Importing the QBO file
In QuickBooks Online, upload it from Transactions → Bank transactions → Upload transactions and choose the account. In QuickBooks Desktop, use File → Utilities → Import → Web Connect Files; Desktop checks the bank ID, and the Web Connect guide covers what to do if it refuses the file.
Spreadsheet problems that stop a conversion
- Totals or notes inside the data. A “Total” row at the bottom is skipped, but other notes between transactions are reported as rows that couldn’t be read.
- Merged cells and blank columns can confuse the column detection. Unmerge them, or pick the columns by hand in step 2.
- Formulas. Cells calculated by formula are read using the last value Excel saved, so recalculate and save the workbook before converting.
- Separate debit and credit columns are merged into one signed amount automatically; see combining debit and credit columns if you want to do it in Excel.
Frequently asked questions
Which Excel files can I convert to QBO?
.xlsx and .xlsm workbooks. Re-save an old .xls file as .xlsx first. CSV files work too.
Does my spreadsheet need specific column names?
No. Names like Date, Description, Amount, Debit and Credit are recognised automatically, and you can choose any column by hand in step 2.
Which sheet is used if the workbook has several?
The first sheet. The status message names the sheet it read; if your transactions are on another sheet, move that sheet to the front and save.
Is my workbook uploaded?
No. The workbook is read in your browser and the QBO file is saved to your device.
Can I import the QBO file into QuickBooks Desktop?
Yes, through File → Utilities → Import → Web Connect Files. Desktop may refuse some bank IDs; the Web Connect guide explains the fixes.