What CSV Format Does QuickBooks Online Accept?
QuickBooks Online is flexible about column names — you map your headers to QBO fields during the import wizard. But certain columns are required, and specific formats are more reliably accepted.
| Column | Required? | Accepted Values |
|---|---|---|
| Date | Yes | MM/DD/YYYY, MM-DD-YYYY, YYYY-MM-DD, DD/MM/YYYY |
| Description | Yes | Any text — payee name, memo, transaction ID |
| Amount | Yes (or use Debit + Credit) | Signed decimal: negative for debits, positive for credits |
| Debit | Alternative to Amount | Positive number representing money leaving the account |
| Credit | Alternative to Amount | Positive number representing money entering the account |
| Balance | No | Running balance — QBO ignores this column |
| Reference / Check # | No | Maps to QBO Reference field; useful for reconciliation |
Step-by-Step: Import CSV into QuickBooks Online
Open the Banking Tab
In QuickBooks Online, click Banking in the left sidebar, then ensure you're on the Banking tab (not Rules or Receipts).
Select Your Bank Account Tile
Click the bank account tile you want to import into. If not listed, click Add account to create it first.
Click the Upload Icon
Look for the small cloud/upload icon in the account tile area, or open the account and select Upload transactions from the action menu.
Upload Your CSV File
Click Browse and select your CSV file. QuickBooks reads the first few rows and displays your column headers for mapping.
Map Columns to QBO Fields
For each CSV column, select the QBO field from the dropdown: Date, Description, Amount (or Debit/Credit). Confirm the date format, then click Next.
Review and Finish
QBO shows a preview. Check for date or amount errors. Click Finish import. Transactions appear in the For Review tab.
Bank PDF Won't Import? Convert to CSV First
Zera Books converts any bank statement PDF to a QuickBooks-ready CSV — correct columns, MM/DD/YYYY dates, signed amounts, ready for Banking tab import.
Try Zera Books Free ›Getting a CSV From Your Bank PDF
Most banks deliver statements as PDFs, not CSV files. Converting a PDF to a properly formatted CSV takes two approaches:
Manual: Open the PDF, copy-paste transaction data into Excel, reformat dates to MM/DD/YYYY, ensure amounts use the correct sign convention, remove currency symbols, and save as CSV. For a 200-transaction statement, this takes 1–2 hours and introduces transcription errors.
Automated: Zera Books extracts bank statement data from PDFs automatically — including digital PDFs, scanned statements, and multi-page documents. The exported CSV uses QuickBooks-compatible column format with MM/DD/YYYY dates and signed amounts. The whole process takes under 2 minutes.
Zera Books also handles multi-account statements. If your PDF contains checking and savings transactions together, it automatically separates them into individual CSV files for separate import into each QBO bank account.
Common CSV Import Errors in QuickBooks Online
| Error | Cause | Fix |
|---|---|---|
| File format not supported | File is .xlsx, not .csv | In Excel: File › Save As › CSV (Comma delimited) |
| Unable to read file | Extra header rows, BOM characters, or encoding issues | Open in text editor, remove extra rows, save as UTF-8 CSV |
| All amounts show as 0 | Amount column has currency symbols ($) or commas | Remove $ and , from amounts: use 1250.00 not $1,250.00 |
| Dates show as text or wrong date | QBO date format selection doesn't match CSV | On the column mapping step, select the date format that matches your CSV |
| Duplicate transactions | Date range overlaps existing bank feed data | Filter CSV to dates not yet imported; QBO won't deduplicate on its own |
| Transactions in wrong account | Wrong account selected at start of upload | Delete imported transactions and redo from the correct account tile |
After Import: Reviewing and Categorizing Transactions
All CSV-imported transactions land in the For Review tab. QuickBooks suggests categories based on description matching and past patterns — but many transactions need manual review, especially on first-time imports.
Zera Books pre-categorizes transactions before export using AI trained on QuickBooks chart of accounts. You receive a CSV with category suggestions already applied — you just confirm or adjust in QBO's For Review tab instead of categorizing from scratch.
- AI categorization includes confidence scores — high-confidence transactions are auto-applied; lower-confidence ones are flagged for review
- Supports QuickBooks default chart of accounts and custom account structures
- Learns from corrections over time, improving accuracy for repeat clients