QQube for QuickBooks Pre-Install Requirements | CLEARIFY

Pre-Install Requirements

This guide is for QQube Version 7.x.

Requirements for QQube Version 6.x are found here

Requirements for QQube Version 5.x are found here

QQube Technical Requirements

• Server Operating Systems -  64 Bit Only for 2011, 2012&R2, 2016, 2019
• Desktop Operating System -  64 Bit Only for Windows 7, Windows 8.1, Windows 10
• CPU - Minimum Recommended - 4th Generation Intel Core ix Processors
• Memory - 2 Gig Minimum for Single-User, 4 Gig Minimum (8 Gig Recommended) for Multi-User
• Hard Drive Space - 350MB available hard drive space. Additional space needed for the QQube database - up to 3 Gig+ per company
• Excel Add-In - Excel 2013 and above (including 365, 2019), both 32 and 64 bit. 64 Bit Encouraged.
• .NET Framework - Version 4.7.2 or above required

Because developers do not have direct access to the database, the more horsepower the better.

QuickBooks Requirements

VERSIONS

• QuickBooks Pro and Pro Plus
• QuickBooks Premier and Premier Plus
• Quickbooks Enterprise Solutions (includes Silver, Gold and Platinum levels)
• QuickBooks Accountant Editions

US Versions 2016 thru current.

Canadian, UK, and Multi-currency versions thru current year.

New Zealand version thru current year.

For file size considerations, please review this guide.

RELEASES

• 2020 - Current Release is ok.
• 2019 - Current Release is ok.
• 2018 - Current Release is ok.
• 2017 - Release 1 thru current is ok except R5 which requires a QuickBooks patch.
• Prior to 2016 - Intuit sunsets the fourth year release every May 31.  e.g. 2016 was sunsetted on May 31, 2019.   QQube will work but is not supported.

QuickBooks Multi-Company Requirements

• Requires the QQube Multi-Company Add-On
  
  • Up to 3 Companies
  • 4 to 10 companies
  • 11 to 100 companies
  • (Trial Version has no limitations)
• You can combine, mix, aggregate any QQube supported QuickBooks file
• Automation of extraction can only be done seamlessly with the same type of QB file e.g. all Premier, or all Enterprise files

Requirements to Run Examples

• Microsoft Access - 2013 and above. 
• Microsoft Excel - 2013 and above
• Excel PowerPivot. Excel 2013 (Professional Plus Edition only), Excel 2016/2019 (Professional Plus, Excel Standalone) and Excel 365 (Office 365 ProPlus Edition, E3, E4)
• Microsoft Power BI - Current Version (Updates are monthly from Microsoft)
• SAP Crystal Reports - 2011 and above.
• Tableau - Versions 9.x and above.

Implementation Requirements

SINGLE USER (Workstation Only)

• QuickBooks client must be installed and registered
• Administrative Permissions for installation (NOT "run as administrator")
• Does not connect to a network where another QQube engine/implementation exists.
• Cannot be installed on a server

MULTI-USER

• If local network - install on administrative console.  Administrative console can only be locked - not logged out of. This is where the installation is performed, and where the synch takes place.
• If network is remote desktop, terminal server or hosted platform where users remotely login to use QuickBooks, create a dedicated server user called "QQubeSynch", with temporary administrative rights, and the time out property set to "never". This is where the installation is performed, and where the synch takes place.
• Client version of QuickBooks must be installed and registered on the server under the admin console, (or dedicated server user, depending upon your network environment, above).

The Intuit SDK (Software Development Kit) only allows QQube to communicate with QuickBooks via a client interface, and doesn't allow the use of a service to perform that communication.