Convert Excel to QBO for QuickBooks Import
QuickBooks Desktop can't import Excel. Convert to QBO and import via Web Connect — transactions land in your bank feed for matching and categorization.
XLSX and XLS supported. Auto-detects columns. Free online — no signup.
How It Works
Upload Your Excel File
XLSX or XLS with transaction data. Date, amount, and description columns auto-detected.
Mapped to QBO
Columns mapped to QBO fields. INTU.BID header and unique FITIDs added for QuickBooks compatibility.
Download QBO
Import via Web Connect in QuickBooks Desktop, or upload in QuickBooks Online's bank feed.
Why QuickBooks Can't Import Excel Directly
QuickBooks expects structured banking data with metadata Excel doesn't have.
What Excel Has
- Rows and columns of transaction data
- No standardized column names
- No transaction IDs for deduplication
- No bank identifier or account metadata
What QBO Adds
- STMTTRN blocks with typed fields
- FITID for duplicate detection
- INTU.BID bank identifier header
- DTPOSTED dates in YYYYMMDD format
We Detect Your Columns Automatically
No matter what your headers are called, we find the right data.
"Date", "Trans Date", "Posted", "Txn Date"
"Amount", "Debit/Credit", "Total", "Sum"
"Description", "Payee", "Memo", "Name"
How to Import QBO into QuickBooks
QuickBooks Desktop
- File > Utilities > Import > Web Connect
- Select your .qbo file
- Map to an existing bank account (or create new)
- Review transactions in bank feed
QuickBooks Online
- Transactions > Bank Transactions
- Link account > Upload from file
- Select your .qbo file
- Match and categorize in bank feed
What is Excel?
Microsoft Excel Spreadsheet (XLSX/XLS)
Rows and columns with transaction data — dates, amounts, descriptions. QuickBooks Desktop can't import it for bank transactions. Needs conversion to QBO first.
What is QBO?
QuickBooks Web Connect
OFX-based format with INTU.BID header. Imports via Web Connect into QuickBooks Desktop and Online. Transactions land in the bank feed for matching.
Why This Tool
Auto Column Detection
Date, amount, and description columns detected automatically — no manual mapping needed.
Debit/Credit Support
Single amount column or separate debit/credit columns both handled correctly.
FITID Generation
Unique transaction IDs for every row. QuickBooks uses these to detect duplicates on re-import.
INTU.BID Header
QBO file includes the Intuit Bank ID header QuickBooks requires. No "unable to read" errors.
Desktop & Online
One QBO file works with QuickBooks Desktop (Pro, Premier, Enterprise) and QuickBooks Online.
XLS + XLSX
Both modern (.xlsx) and legacy (.xls) Excel formats supported.
When to Use This
Manual Transaction Import
Tracking transactions in Excel? Convert to QBO and import into QuickBooks instead of entering them one by one.
Bank Doesn't Connect
Bank feed down or bank not supported? Download your statement as Excel, convert to QBO, and import.
Historical Data Load
Bring years of Excel transaction history into QuickBooks. Convert each period to QBO and import chronologically.
Excel-to-QBO Issues & Fixes
"This file is not a valid Web Connect file"
Renaming .xlsx to .qbo won't work — they're different formats. Use this converter to add the INTU.BID header and STMTTRN structure QuickBooks requires.
Dates swapped — month and day reversed
Ambiguous dates like 03/04/2026 may parse as MM/DD or DD/MM. Verify your spreadsheet's date format matches the converter output.
Amounts are missing or zero
Remove currency symbols ($) and commas from your Amount column. QuickBooks needs plain numbers like 1250.00, not $1,250.00.
Duplicate transactions on re-import
QuickBooks uses FITIDs to flag duplicates. Review the warnings during bank feed matching and skip already-imported rows.
Frequently Asked Questions
Why can't QuickBooks import Excel directly?
QuickBooks Desktop only accepts QBO via Web Connect for bank transactions. QuickBooks Online accepts CSV but QBO is more reliable — it includes FITIDs for duplicate detection and structured metadata.
Do I need specific column names?
No. Date, amount, and description columns are auto-detected. Variations like "Trans Date", "Debit/Credit", or "Payee" all work.
Does it handle separate Debit and Credit columns?
Yes. Separate debit/credit columns are detected and combined into correctly signed amounts for QBO.
Will QuickBooks detect duplicates?
Yes. Each transaction gets a unique FITID. Re-importing the same file triggers duplicate warnings in the bank feed.
Desktop and Online both supported?
Yes. Web Connect in Desktop (Pro, Premier, Enterprise) and bank feed upload in QuickBooks Online.
What about .xls files?
Both .xlsx and .xls formats supported. Same QBO output either way.
MoneyThumb csv2qbo costs $59.95+. Is this free?
Yes. No transaction limits, no trial restrictions, no desktop install. Fully free in your browser.
Is my data secure?
Encrypted via TLS, processed in memory, never stored. Your file is deleted immediately after conversion.
Related Tools
CSV to QBO
Convert CSV financial files to QBO for QuickBooks Desktop and Online. Auto-detects columns and maps your data. Free, instant, no signup required.
Convert now →Excel to OFX
Convert Excel (XLSX/XLS) files to OFX for Quicken, GnuCash, Moneydance, and other accounting software. Auto-detects columns. Free, instant, no signup required.
Convert now →PDF to QBO
Import bank statement PDFs into QuickBooks as QBO files. AI auto-maps dates, debits, and credits. Works with QuickBooks Desktop and Online. Free, no signup.
Convert now →Excel to CSV
Convert Excel spreadsheets (XLSX/XLS) to clean CSV format. Compatible with any tool that accepts CSV input. Free, instant, no signup required.
Convert now →