Learn how to install and use QuickBooks Advanced Reporting.
If you're using QuickBooks Desktop Enterprise 2018 and higher, you can use QuickBooks Advanced Reporting (QBAR) for better insights into your business. Advanced Reporting is used to create interactive custom reports or you can download report templates to get started. Here’s what to do.
Note: If you use a hosted version of QuickBooks Enterprise through a third-party such as Right Networks, you’ll need to contact your hosting service to do these steps for you.
Step 1: Update QuickBooks Enterprise to the latest release
If you’re updating a non-hosted version of QuickBooks Enterprise, make sure to log in as a Windows admin first.
- Go to Downloads & Updates.
- From the Select Product dropdown, select QuickBooks Desktop Enterprise.
- From the Select Version dropdown, choose the Enterprise version or year you use.
- Select Search.
- Select Get the latest updates, then save the file to download the update.
- When the download is done, double-click to install the update. You may need to restart Windows after the installation finishes.
Step 2: Sync your license data online
- Go to the QuickBooks Help menu, then select Manage My License.
- Select Sync Data License Online.
Step 3: Start the install and extract the data for the reports
To start the install, go to the QuickBooks Reports menu and select Advanced Reporting.
Frequently Asked Questions
You need to sign in as the QuickBooks admin or ask your QuickBooks admin to edit your role to give you access to Advanced Reporting.
How to give a user role access to QuickBooks Advanced Reporting
- Sign in to QuickBooks as the admin.
- Go to the Company menu and select Users then Set Up Users and Roles.
- Select a current role then Edit or New (whichever is appropriate).
- Under Roll Access, Area and Activities, select File then QuickBooks Advanced Reporting, and select OK.
If you see the error “Sorry! Advanced Reporting couldn't update your report. Please try again.” while you try to update Advanced Reporting with your latest data, don’t worry. To fix it, you’ll need to update QuickBooks Desktop Enterprise to the latest version.
If the latest release doesn’t fix the issue, here’s what to do:
- Remove any parentheses, brackets or apostrophes in the company file path or file name by renaming folders or file.
- Re-open the company file and run Advanced Reporting.
- Change the date to follow the standard format: MM/DD/YYYY.
- Make sure that QVConnect32.exe isn't blocked by your antivirus program. If it is, you’ll need to add an exception for the QlikView connector in the AVP's real-time scan. QVConnect32.exe file location:
- Windows 10/8.1 and 8.0: C:\Users\username\AppData\Local\Microsoft\Windows\INetCache\QVConnect\11.20.12235.0
- Windows 7: C:\Users\username\AppData\Local\Microsoft\Windows\Temporary Internet Files\\QVConnect\11.20.12235.0
- * 11.20.12235.0 changes depending on your version number
These steps vary depending on the anti-virus program you use, so make sure to go to the anti-virus program support site for detailed instructions.
If you continue to get the error after following these steps, contact QuickBooks Support.