# QuickBooks Data Export

*Published:* 2026-02-11
*Author:* LiyakatAli Lal

> Step-by-step export process for QuickBooks Desktop and Online. Extract customers, items, invoices, and GL data, with common pitfalls explained.

# 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.

### Categories and Taxonomies

#### Service
[Quickbooks to ERPNext](https://rtcamp.com/blog/service/quickbooks-to-erpnext.md)

#### Solutions
[ERP Migration](https://rtcamp.com/blog/solution/erp-migration.md)

#### Topics
[ERP Migration](https://rtcamp.com/topics/erp-migration.md), [Frappe/ERPNext](https://rtcamp.com/topics/frappe-erpnext.md), [Quickbooks to ERPNext](https://rtcamp.com/topics/quickbooks-to-erpnext.md)

### Related Posts

- [The Audit](https://rtcamp.com/handbook/quickbooks-to-erpnext-migration/pre-migration-audit.md)
- [The QuickBooks to ERPNext Migration Guide](https://rtcamp.com/handbook/quickbooks-to-erpnext-migration.md)
- [Structural Limits of Accounting-First Software](https://rtcamp.com/handbook/why-migrate-quickbooks-to-erpnext/structural-limits.md)
- [QE in a nutshell](https://rtcamp.com/handbook/quality-engineering/introduction.md)
- [Migration Path](https://rtcamp.com/handbook/quickbooks-to-erpnext-migration/migration-path-options.md)
