Matching QQube Fields to QuickBooks Desktop

Modified on Sun, 26 Jul at 3:32 AM

Overview

Most QQube fields are easy to recognize, such as Customer Name or Invoice Number. Other fields combine information from multiple QuickBooks transactions. For example, Sales Amount aggregates activity from the four sales transaction types in QuickBooks.

QQube also includes calculated measures that do not appear on a standard QuickBooks report, such as total discounts taken or applied. The Excel Select Assistant helps identify these fields. Hover over a field to view its source, purpose, and expected values.

Why Match QQube to QuickBooks

Comparing a QuickBooks transaction to its QQube fields helps you understand the QQube data structure. It is also the primary method for troubleshooting data-accuracy questions.

In this exercise, you will compare information from a QuickBooks sales invoice with the corresponding fields in the QQube Sales data model.

Match an Invoice to QQube Fields

1. Load the Sales Data Model

Open the QQube Configuration Tool and load the Sales data model.

2. Confirm a Successful Synchronization

Verify that the Sales data model completed without synchronization errors.

3. Open the Sales PivotTable Example

Open Excel. Use the QQube Excel Add-In to open the default PivotTable example for the Sales data model.

QQube Excel Add-In Sales PivotTable example

4. Identify the QuickBooks Invoice Fields

Open the sales invoice shown below. Identify the values that you want to locate in QQube.

QuickBooks sales invoice fields used for comparison

5. Locate the Corresponding QQube Fields

Use the Excel Select Assistant to find the QQube fields that represent the invoice values.

QQube Sales data model fields corresponding to the QuickBooks invoice

Expected Result

You can identify the QQube fields that correspond to the QuickBooks invoice and use the Select Assistant descriptions to understand their source and intended use.