What is extracted

Company & settings

DataNotesDate range?
Company information Name, address, EIN, fiscal year, contact details No — always
Preferences QB settings that affect how data is structured No — always

Chart of Accounts

All accounts are extracted in full. The date range setting does not apply to accounts.

Lists

All list data is extracted in full. The date range setting does not apply to any list.

ListNotes
CustomersIncluding jobs (sub-customers)
Vendors
Employees
Other Names
Sales Reps
Payment Methods
Shipping Methods
Sales Tax Codes
Standard Terms
Date-Driven Terms
Classes
CurrenciesMulti-currency if enabled in QB
Price Levels
Unit of Measure Sets
Customer Types
Customer Messages

Items

All item types are extracted in full. The date range setting does not apply to items.

Item type
Inventory Items
Non-Inventory Items
Service Items
Discount Items
Other Charge Items
Subtotal Items
Sales Tax Items
Sales Tax Group Items
Group Items
Inventory Assembly Items

Transactions

Transactions are filtered by the date range if one is configured. If no date range is set, all transactions are extracted regardless of date.

Transaction type
Invoices
Sales Receipts
Credit Memos
Estimates
Sales Orders
Receive Payments
Bills
Bill Payment Checks
Bill Payment Credit Cards
Vendor Credits
Purchase Orders
Checks
Deposits
Transfers
Journal Entries
Credit Card Charges
Credit Card Credits
Time Tracking
Inventory Adjustments
Build Assemblies

What is not extracted

Important

If any data type below is critical to your migration, contact your Pivoten account team before running an extraction to discuss options.

Transactions not extracted

Transaction typeNotes
Item Receipts Receiving inventory before getting a vendor bill. These are separate from Bills in QB.
Paychecks Requires QuickBooks payroll to be active
Payroll Liability Checks Payroll tax payment transactions
Finance / Statement Charges AR finance charges added to customer statements
Memorized Transactions Saved transaction templates; not actual financial records

Other data not extracted

DataNotes
Fixed Asset Items A separate item type in QB used to track fixed assets
Budgets Financial plans and forecasts created in QB
Vehicle Mileage Mileage log entries
To Do items QB task list entries
Attached documents Files attached to QB transactions are not included in the snapshot
Custom fields (data extensions) User-defined fields added to QB records
Audit trail QB's internal change history log

Date range behavior

The date range setting (configured during setup) filters transactions by transaction date. It has no effect on lists, the chart of accounts, or items — those are always extracted in full.

Data category Affected by date range?
Company & preferences No — always extracted
Chart of Accounts No — always extracted
Customers, Vendors, Employees, etc. No — always extracted
Items (all types) No — always extracted
Transactions Yes — filtered by date if set

Even if you configure a date range of 2023–2024, your full customer list, all accounts, and all items will still be included in the snapshot. Only transaction records are windowed by date.

Tip

If you want a complete history, leave both date range fields blank. If you are doing a partial migration or only need recent data, set a date range to reduce extraction time and snapshot size.