Why QBO Doesn't Accept .xlsx Directly
QuickBooks Online's Banking tab only accepts CSV files for transaction import. Excel's .xlsx format contains formatting, formulas, multiple sheets, and metadata that the QBO import engine can't parse.
The fix is straightforward: save your Excel file as a CSV before importing. But there are several common Excel pitfalls that cause the CSV import to fail even after conversion.
| Excel Issue | What Happens in QBO | Fix Before Saving CSV |
|---|---|---|
| Merged cells in header row | QBO reads merged cell as blank column | Unmerge all cells; give each column a clear header |
| Date stored as Excel serial number | QBO sees a 5-digit number, not a date | Format the date column as MM/DD/YYYY text before saving |
| Amount column contains formulas | CSV exports formula result correctly, but sometimes fails | Copy › Paste Special › Values Only to convert formulas to static values |
| Currency-formatted amounts ($1,250.00) | QBO reads as text, shows amount as 0 | Remove $ and , characters; use plain decimals (1250.00) |
| Multiple sheets in workbook | CSV only exports the active sheet | One sheet at a time — save each account's transactions as separate CSV files |
| Extra rows above column headers | QBO tries to map report title row as column header | Delete all rows above the column header row |
Preparing Your Excel File for QBO Import
Before saving as CSV, clean your Excel file to avoid the common errors above:
Delete Rows Above Column Headers
Bank statement Excel exports often include 3-5 header rows (account name, date range, etc.) above the actual column headers. Delete all of these so row 1 is your column header row (Date, Description, Amount, etc.).
Fix Date Formatting
Select the date column › Format Cells › Custom › type MM/DD/YYYY. Verify dates display as 01/15/2025, not as 5-digit serial numbers. If dates show as serial numbers after CSV save, convert them to text first.
Clean Amount Columns
Remove $ signs and comma separators from amounts. Select the Amount column › Find & Replace › replace "$" with "" and "," with "". Ensure negative numbers use a minus sign, not parentheses: -500.00 not (500.00).
Save as CSV
File › Save As › choose CSV (Comma delimited) (*.csv). Excel will warn that only the active sheet will be saved — click OK. You now have a CSV ready for QBO import.
Skip the Excel Cleanup
Zera Books accepts Excel and PDF bank statements and converts them directly to QuickBooks-ready CSV — no manual cell formatting, no formula cleanup, no date reformatting.
Try Zera Books Free ›Step-by-Step: Import CSV into QuickBooks Online
Once your Excel file has been saved as a clean CSV:
Open Banking Tab in QBO
Click Banking in the left sidebar. Ensure you're on the Banking tab (not Rules or Receipts).
Select Account and Click Upload
Click the bank account tile, then click the upload/cloud icon. Choose Upload from file and browse to your CSV file.
Map Column Headers
QBO displays your CSV column headers and asks you to map each one to: Date, Description, Amount (or Debit/Credit). Select the date format that matches your CSV. Click Next.
Review and Finish
Review the transaction preview. Transactions appear in For Review after you click Finish import.
When to Use Zera Books Instead of Manual Conversion
The manual Excel-to-CSV workflow works for occasional imports with clean Excel files. But it breaks down in several common scenarios:
- Scanned bank statements saved as .xlsx: OCR-based Excel files often have irregular layouts that require extensive cleanup
- Bank statements with merged headers: Some banks export Excel files with multi-row merged headers that require tedious unmerging
- Multi-account workbooks: If your bank exports all accounts in one Excel file (multiple sheets), you need to process each sheet separately
- High volume: Manually cleaning 12 months of statements across 20 clients is not practical
Zera Books handles all these cases — it accepts both Excel (.xlsx) and PDF bank statements, processes them through AI extraction, and outputs clean QuickBooks-compatible CSV files with pre-categorized transactions. $79/month unlimited processing for all clients.
Common Errors After Excel-to-CSV Conversion
| Error in QBO | Root Cause in Excel | Fix |
|---|---|---|
| Amounts show as 0 or text | Amounts formatted as currency with $ and commas | Strip $ and , before saving; use plain 1250.00 format |
| Dates don't parse | Dates saved as Excel serial numbers (e.g., 45307) | Format date column as MM/DD/YYYY, copy-paste as values, then save CSV |
| Wrong column mapped | Column headers include spaces or special characters | Rename headers to simple words (Date, Amount, Description) before saving |
| First row treated as data, not header | Extra blank row above header in Excel | Delete all blank rows above the column header row |
| Negative amounts not recognized | Excel uses parentheses for negatives: (500.00) | Replace (500.00) with -500.00 using Find & Replace |