Exporting Data from QuickBooks

Export Wizard Overview

PrimeConnect's export wizard lets you extract data from QuickBooks Desktop and save it as a well-organized Excel (.xlsx) spreadsheet. Whether you need a full customer list, filtered invoice data for a specific date range, or a custom report with hand-picked columns, the export wizard handles it in four straightforward steps.

PrimeConnect supports exporting 40+ entity types, covering both list records (Customers, Vendors, Items, Accounts, and more) and transaction records (Invoices, Bills, Journal Entries, Sales Receipts, and more). Every export produces a clean, structured spreadsheet that opens in Excel, Google Sheets, or LibreOffice Calc.

To start an export, click "Export" on the PrimeConnect home screen or select it from the top navigation bar.

Step 1: Choose Entity Type

The first step is to select what type of data you want to export. The entity type picker is organized into two main groups:

• Lists (Master Records): Customers, Vendors, Employees, Items, Accounts, Classes, Sales Representatives, Payment Methods, Sales Tax Codes, and more. These are the standing data records in your QuickBooks company file.
• Transactions: Invoices, Bills, Journal Entries, Sales Receipts, Credit Memos, Estimates, Purchase Orders, Checks, Deposits, Transfers, Inventory Adjustments, and more. These are the day-to-day financial transactions.

Click on the entity type you want to export. A quick-access section at the top of the list shows entity types you have recently exported, so you can jump back to frequently used types without scrolling.

Step 2: Apply Filters

After selecting an entity type, you can narrow down which records are included in the export by applying one or more filters. Filters are optional — if you skip this step, all records of the selected type are exported.

Different entity types offer different filter options depending on their available fields. Transaction types typically offer the richest filtering options, including date ranges and amounts.

Available Filter Types

PrimeConnect provides several categories of filters, depending on the entity type selected:

• Date range filters: Filter transactions by their transaction date, due date, or other date fields. Includes convenient presets and a custom range picker.
• Amount range filters: Set a minimum and/or maximum amount to include. Useful for finding large invoices, small payments, or transactions within a specific dollar range.
• Field-specific filters: Filter by account type, customer type, item type, vendor type, or other categorical fields. These use dropdown menus that show all available values from your QuickBooks data.
• Multi-select filters: Select specific customers, vendors, items, or accounts to include. Check the ones you want and uncheck the rest.
• Text search filters: Search for records containing specific text in name, description, memo, or reference number fields.

You can combine multiple filters to create precise data selections. Filters work together using AND logic — a record must match all active filters to be included in the export.

Date Range Filters

Date range filters are the most commonly used filter for transaction exports. PrimeConnect provides a set of built-in presets for quick selection, as well as a custom date range option:

When you select a preset, the start and end dates are set automatically. With the Custom Date Range option, two date pickers appear so you can define any arbitrary date window.

Step 3: Select Fields

In this step, you choose which data columns appear in your exported spreadsheet. PrimeConnect shows a list of all available fields for the selected entity type, each with a checkbox.

• Check/uncheck fields: Toggle individual fields to include or exclude them from the export. By default, the most commonly used fields are pre-selected.
• Select all / deselect all: Quick buttons at the top let you toggle all fields at once, then uncheck the ones you do not need.
• Drag to reorder: Drag fields up or down in the list to control the column order in the output spreadsheet. The order you see in this list is the exact order columns will appear in the exported file.

Customizing field selection is especially useful when you only need specific columns — for example, exporting only customer names and balances rather than every available field.

Step 4: Export & Download

After configuring your filters and fields, click the "Export" button to generate your spreadsheet. PrimeConnect queries your QuickBooks company file in real time, retrieves the matching records, and writes them into an Excel file.

During export, you will see a progress indicator showing how many records have been processed. For most entity types, this takes only a few seconds. Very large exports (tens of thousands of records) may take a minute or more.

Once complete, the file is automatically saved to your default download location. The filename follows the pattern:

[EntityType]_[YYYY-MM-DD].xlsx

For example, an invoice export on February 25, 2026 would be named Invoices_2026-02-25.xlsx. If you export the same entity type multiple times on the same day, a numeric suffix is appended to avoid overwriting (e.g., Invoices_2026-02-25 (2).xlsx).

Every export operation is logged in your operation history so you can revisit what was exported, when, and how many records were included.

Understanding the Output File

The exported .xlsx file is a standard Excel workbook that can be opened in any spreadsheet application:

• Microsoft Excel (2007 or later)
• Google Sheets (upload or import)
• LibreOffice Calc
• Apple Numbers

If you need to convert exported data to another format for use in a different accounting platform, our free accounting tools can help. Convert QuickBooks exports to formats compatible with Xero, Sage, or other platforms.

The file structure is straightforward:

• Row 1 (header row): Contains the column headers matching the field names you selected in Step 3.
• Rows 2 and beyond: Each row represents one record from QuickBooks. For transactions with line items (like invoices), each line item may appear as a separate row depending on the entity type's structure.

Data types are preserved in the Excel output. Date fields are formatted as Excel dates (so you can sort and filter by date in Excel). Numeric fields are stored as numbers (so you can use SUM, AVERAGE, and other formulas). Text fields are stored as strings.

Tips for Large Exports

Exporting large datasets (thousands or tens of thousands of records) is fully supported, but a few strategies can help make the process smoother:

• Use date filters to break up large datasets. Instead of exporting all invoices for the last 10 years in one go, export year by year or quarter by quarter. Smaller files are faster to generate, easier to work with in Excel, and simpler to troubleshoot if anything looks off.
• Check the record count before exporting. The export preview shows the total number of records that match your filters. If the count is unexpectedly high (or low), adjust your filters before proceeding.
• Keep QuickBooks open during export. PrimeConnect communicates with QuickBooks in real time during the export process. Do not close QuickBooks or switch company files until the export completes.
• Export only the fields you need. Selecting fewer fields in Step 3 produces a leaner file that generates faster and is easier to work with. If you only need customer names and balances, do not export all 30+ customer fields.
• Check available disk space. Very large exports can produce files that are several megabytes in size. Make sure your download folder has adequate free space.