QBO to CSV: Open QuickBooks Web Connect Files in Excel

When you need a QBO file as a spreadsheet

Banks offer .qbo downloads because they import cleanly into QuickBooks. But a bookkeeper often needs the same transactions somewhere else: a working paper for a tax preparer, a client who uses Xero, a pivot table to categorize a year of spending, or simply a readable list to check before importing. Converting the file gives you that list without re-typing anything.

It's also the fastest way to see what's actually inside a file before it touches the books: how many transactions, which dates, and whether the totals match the paper statement.

What the CSV contains

The "all fields" CSV has one row per transaction with these columns:

• Date: the posting date (DTPOSTED) as MM/DD/YYYY.
• Description: the payee name (NAME). If the bank shortened it to 32 characters and put the full text in the memo, the full text is restored.
• Memo: any extra detail the bank included.
• Amount: signed, with no currency symbol or thousands separator, so spreadsheets treat it as a number.
• Check Number: from CHECKNUM when present.
• Transaction ID: the bank's FITID, useful for spotting duplicates between files.

The Excel option writes real date and number cells with an accounting format, an autofilter on the header, and a Summary sheet with the account, period, money in, money out and ending balance.

Moving a QBO download into another accounting app

Xero

1. Choose Xero CSV and download.
2. In Xero, open the bank account, choose Manage account, then Import a statement.
3. Upload the file and confirm the column mapping: Date, Amount, Payee, Description, Reference.

Wave

1. Choose Wave CSV and download.
2. In Wave, go to Transactions, open More and pick Upload a bank statement.
3. Select the account and upload the CSV.

QuickBooks Online, as CSV

If the original .qbo file is refused, a CSV is a good fallback. Choose the 3-column or 4-column QuickBooks CSV, then go to Transactions > Bank transactions > Link account > Upload from file. You lose the bank's transaction IDs, so QuickBooks relies on its own duplicate detection.

Things to watch for

• Ending balance: the figure shown is the bank's ledger balance (LEDGERBAL) on the statement end date. Use it to check that nothing is missing.
• Pending transactions are usually not included in Web Connect downloads, so recent card swipes may be missing.
• Several accounts in one file: some banks put checking and savings in the same download. The tool shows the first account and tells you when there are more.