(Expected Release Date: On or Before November 6, 2017)
This will be a full install, and will upgrade versions 4.1 and later in place. Those with QQube Version previous to 4.1 will need to un-install that previous version before installing 6.1.
Current users of QQube who are still within the yearly subscription period will be notified of download and upgrade procedures for this free upgrade. Users outside of the yearly subscription period will be able to renew their subscription here:
New users need to request the link for a trial download.
QQube 6.1 is not a newer version that is simply "more and better". It is essentially a re-write of the underpinnings using newer technology, and modern architectures not previously available to us.
We can't control how Intuit exposes their data using the Software Development Kit (SDK), but there are many other aspects we can control to enable a better customer experience and produce a more efficient application.
QQube now contains over 45 independent Analytic areas, ranging from Open Sales Orders to 52/53 Tax Year Financial Summaries with 6,000 + fields of information, and over 250 additional pre-calculated measures used in examples for Excel PowerPivot, and Microsoft Power BI.
Highlights
Changes to Requirements
Reworked Statement of Cash Flows
New and Improved Financial Analytics
New Enterprise only Financial Summary Analytics
Additions to General Ledger Detail
52/53 Calendar
Audit Trail
Bank Transfers
Billing Rate. Fix issue where Billing Rate by item contains more than 3 figures... e.g. with comma, and wouldn't convert to number
Build Assemblies. Fix issue where transaction item description was not showing.
Financial Summary Reports. Fix rare issue where, when using account numbers, and the Parent Account was similar - but with one character LESS than - the Child Account, Financial Summary and Financial Summary Reports by Class would not appear correctly, or disappear altogether.
Fixed Assets. Fix null values not properly formatted as 0.00
General Ledger Detail
Payroll
Profit and Loss by Job (Enterprise Only). Fix issue where if a budget was missing for a whole year (within the 3 year period setup in the QQube Configuration Tool), the actuals would not show.
Sales. Fix occurrence on sales transactions to show quantity as 0 where quantity was null, but amount and percentage where greater than 0. This now matches QuickBooks Reporting.
Sales Tax
Presentation Clean-Up in Excel PowerPivot. If the name of the main folder/table/tab was changed in PowerPivot, then the Presentation Clean-Up for Financial Summary Subjects was not available. This has been fixed - including Profit and Loss Detail.
Synchronizer Status
New Refresh Options
NOTE: Each refresh option is applicable ONLY to the currently open spreadsheet
We are proud to include a library of over 60 Power BI analytics with QQube - the first of its kind.
Click here to see the complete library
FACT Table
The main folder (FACT table) for each subject used to contain all transactional information, whether it was something you measured (e.g. amount or qty), or something you measured BY e.g. Document Ship Method, or Line Billable Status.
QQube 6.1 corrects this, by separating measures, from document attributes, line attributes, and geography.
IMPORTANT NOTE: These structural changes may require manual intervention after the upgrade for those customers who did not use the Excel Add-In for report creation and/or implementation. These structural changes were necessary for the future of the product, and will be explained in detail in an upcoming Knowledge Base Article before the public release.
Single Date Options
Like all traditional warehouses, QQube provides a true Calendar Dimension for the various dates that exist in QuickBooks transactions, e.g. Transaction Date, Ship Date, Expected Date, etc. Excel and Tableau provide their own date dimension extensions e.g. Year, Quarter, Month, Day; so we have provided single date fields to accommodate those applications, and simplify the field options.
Fields that remove clutter from the canvas:
Here are a few DIMENSION folders which may have only one or two fields, - fields that are rarely used - but clutter up the canvas. So to simplify, we have added those single fields into the Document Attributes Folder:
Auto reload of all data when an abnormal interruption or manual abort has occurred. It is a requirement for data accuracy, so it has been automated.
Data Truncation information. There are times where a field in QB has more characters stuffed into it, than is recognized by the Intuit SDK. We see this where customers use older IIF import tools, and strict field sizes are not followed, OR a user has put more than phone and extension in a phone field. Previously it would just error out, with no indication as to what record or field was at issue. We now log this information so that it can be easily read for correction.
Option to auto clear the data, before reloading from scratch. This is a huge help for clients with multi-company QB files, and there is a higher instance of merging accounts, customers, items, etc. - all of which require a complete reload.