Excel to QBO Converter
Turn an Excel bank statement (.xlsx or .xls) into a QBO file for QuickBooks, right in your browser.
Drop your bank file here or choose a file
Excel (.xlsx, .xls) or CSV · stays on your device
No signup. Your file never leaves your computer. Works in your browser.
How to convert Excel to QBO
- Get the Excel file Download your transactions from your bank as Excel, or use a spreadsheet you keep yourself. It needs at least a date, a description and an amount column.
- Drop it into the converter Choose the .xlsx or .xls file or drag it onto the box above. The converter picks the first sheet that has transactions; you can switch sheets.
- Check the columns Make sure the date, description and amount (or money out and money in) columns are right. Title rows above the table are skipped automatically.
- Review the transactions Fix or delete any row. Totals of money in and money out are shown above the table.
- Choose QBO, your bank and the account type Pick the bank shown in QuickBooks and whether this is a checking, savings or credit card account.
- Download the QBO file Click Download QBO file, then import it into QuickBooks.
How to import the QBO file into QuickBooks
These steps follow Intuit's current help pages. Back up your company file first; Intuit notes that an import can't be undone.
QuickBooks Desktop for Windows
- Sign in to your Intuit account Intuit requires you to be signed in inside QuickBooks Desktop to import .qbo files.
- Open the import Choose Banking › Bank Feeds › Import Web Connect Files, select the .qbo file and click Open.
- Choose the account Choose Use an existing account if the account is already in QuickBooks, or Create a new QuickBooks account. Click Continue, then OK.
- Add the transactions Review them in the Bank Feeds Center and add them.
If the import fails, Intuit's fixes include switching to Classic Mode: Banking › Bank Feeds › Change Bank Feeds Mode.
QuickBooks Desktop for Mac
- Open the import Choose Banking › Downloaded Transactions › Import File.
- Pick the file Select the .qbo file.
- Choose the account If QuickBooks asks, pick the matching account under Store in the QuickBooks Account, then click Continue and OK.
QuickBooks Online
- Open Bank transactions Choose All apps › Accounting › Bank transactions. Older menus start at Banking or Transactions.
- Choose Upload from file Select the account's tile if you see one, open Link account and choose Upload from file.
- Pick the file and the account Select the .qbo file and click Continue. Choose the account in the QuickBooks account list and click Continue.
- Import Select the transactions to import, click Continue, then Yes and Done.
Intuit's limits for one upload: 350 KB per file and up to 1,000 lines.
Why convert Excel to QBO
Some banks offer downloads only as Excel files, and many bookkeepers keep transactions in a spreadsheet. QuickBooks Web Connect, the way QuickBooks Desktop imports bank downloads, reads QBO files. An Excel to QBO converter bridges the gap: it reads the sheet, adds the account details and transaction IDs QuickBooks needs, and writes a QBO file.
What the converter reads in a workbook
- Real date cells and Excel date numbers, plus dates typed as text (01/05/2026, 2026-01-05, Jan 5, 2026).
- Number cells and amounts typed as text, including $1,234.56, (1,234.56) and 1234.56-.
- Title rows, bank names and blank rows above the table, which are skipped.
- More than one sheet: you choose which one to convert.
Supported banks and file layouts
Any bank's CSV or Excel file
The converter finds the header row (even below bank names and account summaries), matches columns by name and by content, and handles one signed amount column, separate debit and credit columns, or an amount with a DR/CR column. Dates like 01/05/2026, 2026-01-05 and Jan 5, 2026 and amounts like (1,234.56) or 1234.56- are all read.
Known layouts, picked automatically
- American Express card · Date, Description, Card Member, Account #, Amount, … 8 more
- Apple Card · Transaction Date, Clearing Date, Description, Merchant, Category, … 3 more
- Bank of America checking or savings · Date, Description, Amount, Running Bal.
- Bank of America credit card · Posted Date, Reference Number, Payee, Address, Amount
- Barclays credit card · Transaction Date, Description, Category, Amount
- Capital One 360 checking or savings · Account Number, Transaction Description, Transaction Date, Transaction Type, Transaction Amount, Balance
- Capital One credit card · Transaction Date, Posted Date, Card No., Description, Category, … 2 more
- Charles Schwab Bank checking · Date, Status, Type, CheckNumber, Description, … 3 more
- Charles Schwab Bank checking (older layout) · Date, Type, Check #, Description, Withdrawal (-), … 2 more
- Chase checking · Details, Posting Date, Description, Amount, Type, … 2 more
- Chase credit card · Transaction Date, Post Date, Description, Category, Type, … 2 more
- Citi credit card · Status, Date, Description, Debit, Credit
- Discover card · Trans. Date, Post Date, Description, Amount, Category
- Mercury transactions · Date (UTC), Description, Amount, Status, Source Account, … 9 more
- PayPal activity · Date, Time, TimeZone, Name, Type, … 11 more
- PNC checking or savings · Transaction Date, Transaction Description, Amount, Balance
- SoFi checking or savings · Date, Description, Type, Amount, Current balance, Status
- Square transactions · Date, Time, Time Zone, Gross Sales, Discounts, … 44 more
- Stripe balance report · balance_transaction_id, created_utc, available_on_utc, currency, gross, … 4 more
- USAA checking or savings · Date, Description, Original Description, Category, Amount, Status
- Venmo statement · ID, Datetime, Type, Status, Note, … 16 more
- Wells Fargo · 5 columns, no header row
Each layout was checked against the bank's own help pages or real sample files. If your bank changes its layout, the converter still reads the file by its column names.
Common problems and fixes
- The converter shows the wrong sheet
- Choose the right sheet in the Sheet box above the columns. The converter starts with the first sheet that has at least two rows of data.
- Dates show up as numbers like 46027
- That is how Excel stores dates. The converter reads date cells and Excel date numbers as real dates, so they come out right in the QBO file.
- The file is protected with a password
- The converter can't open password-protected workbooks. Open the file in Excel, remove the password (File › Info › Protect Workbook), save it, and try again. Or save the sheet as CSV.
- Totals or a balance column appear as transactions
- The converter skips rows such as "Total" and "Ending balance" and ignores a running balance column. If a summary row slips through, delete it in the table.
- Amounts have the wrong sign
- If purchases are positive numbers (common for credit cards), turn on Flip signs. If your sheet has separate debit and credit columns, choose Money out + money in under Amounts.
Excel vs QBO
| Excel (.xlsx) | QBO | |
|---|---|---|
| What it is | A spreadsheet you can edit | A Web Connect statement file (OFX format) for QuickBooks |
| Imported by QuickBooks Web Connect | No | Yes |
| Formulas and formatting | Yes | No: transactions only |
| Account details | Whatever you type in | Bank ID, account type and account number |
| Duplicate protection | None | A unique ID for every transaction |
Frequently asked questions
How do I convert an Excel file to QBO?
Drop the .xlsx or .xls file into the converter above, check the columns and transactions, choose your bank and the account type, and click Download QBO file.
Do I need Excel installed?
No. The converter reads the workbook in your browser. You only need the file.
Does it work with old .xls files?
Yes. Both .xlsx (Excel 2007 and later) and the older .xls format are read.
What columns does my sheet need?
A date, a description and an amount. The amount can be one column with minus signs for money out, two columns (money out and money in), or an amount with a debit/credit column. Memo and check number are optional.
Is my workbook uploaded?
No. It is read by your own browser and never leaves your computer.
Can I make a CSV or QFX file instead?
Yes. Before you download, choose CSV, QFX, QIF, OFX or the QuickBooks Online CSV layout.
Related tools
Last updated · EmproIT