Matching QQube Fields to QuickBooks Desktop

Overview

Most of the fields in QQube are easy to recognize such as Customer Name, or Invoice Number.  There may be some fields that span multiple transactions such as Sales Amount - which aggregates information from the four sales transactions in QuickBooks.

And other fields are measures that QuickBooks doesn't have in any report, such as total discounts taken, or applied. The Excel Select Assistant is a good guide because you can hover over a field, and it gives you information about its origins.

An Exercise Matching QQube to QuickBooks

In this example, we are going to view a series of field information from a sales invoice and compare it to the list of fields in QQube. Not only will this help you learn about the QQube data structure representing QuickBooks, but it is the primary method of troubleshooting data accuracy.

STEP 1.  Load the Sales Data Model from the QQube Configuration Tool

STEP 2.  Make sure there are no synch errors

STEP 3.  Open up Excel, and use the Excel Add-In, starting with default Pivot Table example for the Sales Data Model.

STEP 4.  Locate the fields for this picture.

STEP 5.  This is how the fields are represented in QQube: