Matching QQube Fields to QuickBooks Desktop

Modified on Wed, 19 Aug at 4:27 AM

Overview

Many QQube fields map directly to familiar QuickBooks information, such as Customer Name or Invoice Number. Other fields organize activity from multiple QuickBooks transaction types into a single reporting value. For example, Sales Amount represents sales activity from invoices, credit memos, sales receipts, and statement charges.

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

Why match QQube to QuickBooks

Comparing a QuickBooks transaction to its corresponding QQube fields helps you understand how QuickBooks information is organized in the QQube data model.

Troubleshooting principle

Matching the original QuickBooks transaction to its QQube fields is the primary method for investigating 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. Hover over a field when you need additional information about its source and intended use.

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.