Exporting Data from QuickBooks

We need master data first, then transactions. Order matters.

Master Data (Customers, Vendors, Items)

QuickBooks Desktop

• Customers/Vendors: Reports → List → Customer Contact List → Excel → Create New Worksheet
• Items: Reports → List → Item Listing. Add columns for Cost, Sales Price, and On Hand Quantity.

QuickBooks Online

• Customers: Sales → Customers → Export to Excel
• Items: Settings → Products and Services → Export

Transaction Data

Here’s where QuickBooks fights you. Its reports are designed for printing, not database migration.

General Ledger / Journal Entries

Export the Trial Balance for your opening balance date. This carries account names and balances. The Account Listing does not carry balances.

Invoices

Export Sales by Customer Detail.

Warning

QuickBooks exports are formatted for human reading. Merged cells, headers, subtotals – none of this works for data import. The “Sales by Customer Detail” report aggregates and formats data, which can collapse invoice lines and lose item-level granularity. Not accurate for itemized invoice migration.

If native exports are too messy, you may need Transaction Pro Importer for cleaner CSV output, or API extraction.

Verify Immediately

Open every exported file right after export.

• Are columns aligned?
• Are there totals at the bottom? (Delete them as you need raw data only.)

Are negative numbers using brackets (100) or negatives -100? Use negative values instead of brackets when preparing Excel files, as this format is more reliable during CSV parsing and imports.