Selecting Your Fields using the Excel Add-In | CLEARIFY

Select Assistant

One of the features of the Excel Add-In, allows you to pick QuickBooks report fields for use in your dynamic range (list) or pivot table, without needing to know anything about tables, relationships, or reverse engineering.  

Once you have chosen your fields, you can simply close the Field Selector, and are you completely in the realm of Excel. Outside of the Presentation Cleanup, the Add-In does not interact with your report, other than the field choices.

QQube allows you to drag and drop any field into Excel - the rest is just Excel

How the Data is Organized

There are two types of data models:  

• Financial Summary which may have hundreds of measures and only two or three dimensions. e.g. account, class, company
• Detail which may have up to 50 measures, and many dimensions.  These include: Sales, Inventory, Job Cost Details, Purchasing, General Ledger Detail, Profit and Loss Detail, A/R, A/P.

This shows the layout for a detail data model.  NOTE: Each data model has its own subset of fields, but the general design is the same.

1. MEASURES.  These are quantity, amount, or rate fields.  Information that you sum, average, max, min, count, etc.
2. Date Dimensions. Dates and date attributes.
3. List Dimensions.  Commonly known as List Information in QuickBooks, e.g. customer, account, item, class, etc.
4. Document Attributes. Examples are reference number, terms, customer custom field.  Items that are applicable to the whole document.
5. Document Dates. Single dates that are more useful for applications that derive their own "Date Dimension" when a single date is used.
6. Geography. Address Information in both short and long form.
7. Document Line Attributes.  Other 1 Field, item custom fields used on a transaction.

Linked Transactions are also available in the Field Selector.  If you pay a bill, the Bill Payment Check would be a linked transaction.  If the same bill was received against a Purchase Order, it too would be a linked transaction.  You can select linked posting, and linked non-posting information.

Refresh Options for Selecting Fields in Larger Spreadsheets

There are times when a large file can fill up your Excel Spreadsheet, and if your machine is slower than average,it can take more than a few seconds to add a field into Excel.  This is because QQube is re-creating the underneath structure, with every field you select.

Top change this behavior, un-click the Auto Refresh option at the bottom of the Select Assistant.

Pick the fields you want from the Field Selector, then check the box back.  QQube will now re-create the structure one time, with all of the fields you have selected.