Integration with QuickBooks Desktop | Zoho Analytics On-Premise

Integration with QuickBooks Desktop


Zoho Analytics seamlessly integrates with QuickBooks Desktop, and enables you to easily analyze your accounting data and keep track of key metrics. This helps managers create intuitive reports on accounts, bill details, invoices, customers, and much more. 

General

1. What is Zoho Analytics?

Zoho Analytics is an on-premises reporting and business intelligence application that helps you analyze your IT data and create insightful reports & dashboards for informed decision-making. It offers the following important capabilities:

  • Import data from local filesweb feedslocal and cloud databases, and cloud storage/drive.

  • Displays data in an easy-to-view excel format.

  • Build custom reports and dashboards easily, with the drag-and-drop report builder.

  • Supports powerful visualizations in the form of chartspivot tablessummary viewstabular views, and dashboards

  • Generate reports and KPIs in seconds with Zia, Zoho Analytics' intelligent analytics assistant powered by Machine Learning and Artificial Intelligence.

  • Create custom formulas using the built in formula engine that contains a wide range of mathematical, statistical and logical functions.

  • Share reports and dashboards with your colleagues easily, through a wide range of collaboration features. 

  • Export and publish reports and dashboards in various formats, and configure permissions and filters for the views.

  • Supports out-of-the-box integrations with a wide number of applications, to give you pre-built reports and dashboards on your application's data within minutes.

2. What are the highlights of this integration?

Zoho Analytics seamlessly integrates with QuickBooks Desktop, allowing you to create intuitive reports and live dashboards for a high level view of your accounting data. The data from the following modules will be synchronized into Zoho Analytics on setting up this integration.

  • Accounts
  • Billing and transactions
  • Checks
  • Credit memos
  • Customers
  • Estimates
  • Invoices
  • Payments
  • Sales orders, and receipts
  • Vendors

Setup

1. How do I integrate Zoho Analytics with QuickBooks Desktop?

2. What are the supported QuickBooks Desktop versions for this integration?

You can easily integrate Zoho Analytics with the following versions of the QuickBooks Desktop application.

  • US Enterprise 2016
  • US Premium 2016
  • US Pro 2016
  • US Enterprise 2017
  • US Premium 2017
  • US Pro 2017
  • US Enterprise 2018
  • US Premium 2018
  • US Pro 2018

3. How long should I wait for my QuickBooks Desktop data to initially appear in Zoho Analytics?

After setting up the integration, you might have to wait some time for the initial fetch to complete. Depending on the amount of data in your application, the reports and dashboards might take up to 5 minutes to display all the metrics. If you access the workspace before the initial fetch, it will not display any data.

4. What should I do when the data synchronization fails?

The import or synchronization process of your QuickBooks Desktop data can fail sometimes, due to a variety of reasons. If the issue persists, please e-mail onprem-support@zohoanalytics.com.

5. How do I schedule data synchronization?

You can schedule data synchronization at regular intervals using your QuickBooks Web Connector. To do this, select the Auto-Run checkbox, and specify the required interval using the Every-Min drop-down. 

6. How do I download the latest .QWC file?

You can download the latest .QWC file even after the setup is completed. To do this, click the Data Sources button from the left-side panel. In the page that appears, click Download .QWC File

7. Can I edit the synchronization settings?

To edit the connection and synchronization settings, open your QuickBooks Web Connector. Modify the synchronization interval in the Every-Min section, and click the Update Selected button. 

To edit the modules and fields imported from QuickBooks Desktop, open your Zoho Analytics application, and select Data Sources -> QuickBooks Desktop from the side panel. 

The synchronization summary is displayed with the following data:

  • Last data sync status: Status of the most recent synchronization from QuickBooks Desktop.

  • Last data sync time: Time at which the most recent synchronization was completed.

Click the Edit Setup link, modify the selected modules and fields as needed, and click Save.

8. How do I create custom reports over my QuickBooks Desktop data?

You can easily create custom reports in the form of chartspivot tablessummary and tabular views in Zoho Analytics. Click the corresponding links to learn more about creating reports. These reports can also be organized together to form intuitive dashboards. Refer this documentation to learn more about creating dashboards.

9. Can I set up the QuickBooks Desktop integration in existing workspaces in Zoho Analytics?

Yes. Follow the steps below to do this.

  • Open the required workspace, click the Create button from the side panel, and select the New Table / Import Data option.

  • Select the required QuickBooks Desktop tile in the Import Your Data screen that appears, and follow the setup procedure.

10. Is it possible to create multiple QuickBooks Desktop integration setups in Zoho Analytics?

Yes. Follow the steps below to do this. 

  • Open the required workspace, click the Create button from the side panel, and select the New Table / Import Data option.

  • Select the required QuickBooks Desktop tile in the Import Your Data screen that appears, and enter the details of the required QuickBooks Desktop account according to the usual setup procedure.

To do this, you need to remove the data source from Zoho Analytics, and remove the app from your QuickBooks Desktop application. 

To remove the data source in Zoho Analytics, 

  • Open the corresponding workspace, and click the Data Sources option from the side panel.

  • Click the Settings icon that appears on mouse over the data source's name, and select Remove Data.

To remove the app from your QuickBooks Desktop application,

  • Open the QuickBooks Web Connector, navigate to the Zoho Analytics section and click the corresponding Remove button.

  • In the QuickBooks Desktop application, click Edit -> Preferences. Navigate to the Integrated Applications section, select the Zoho Analytics application, and click Remove

Reporting Features

1. What are the report types supported by Zoho Analytics?

Zoho Analytics supports a wide variety of reports, in the form of charts, pivot tables, summary views and tabular views. To know more about the various types of reports, click here. To know more about dashboards and KPI widgets, click here.

2. Can I modify the pre-built reports created on integrating with QuickBooks Desktop?

Yes. If you are the administrator or a workspace administrator of the workspace in which the integration is set up, click the Edit Design button in a report's toolbar and make the required changes. If you are a user to whom a report is shared, save a copy of the report by clicking Save > Save As, and modify the copied version as needed.

3. How do I create reports using fields/columns across different QuickBooks Desktop modules?

Columns from different QuickBooks Desktop modules are joined by default. Therefore, reports can be created over this data by simply dragging and dropping the respective columns in the report builder. Click here to learn more about creating reports. 

4. What are formulas in reports?

Formulas are calculations that can be defined using the powerful formula engine in Zoho Analytics, to create required reports. Refer this documentation to know more. There are also several default formulas created based on the QuickBooks Desktop modules. To view the default formulas, open the required table, click Add and select the Edit Formulas option.

5. Is it possible to create custom formulas in Zoho Analytics?

Yes. Refer this documentation to learn more.

6. Can I modify the tables imported from QuickBooks Desktop?

The data from QuickBooks Desktop is synchronized with Zoho Analytics automatically, and stored in the form of various tables. Therefore, it is not possible to add data or modify the existing data present in these tables.

7. Can I add new columns to the tables imported from QuickBooks Desktop?

No. However, you can add Formula Columns and Aggregate Formulas to these tables, to help create custom reports. Refer this documentation to know more.

8. Can I import new tables into the QuickBooks Desktop workspace?

To do this, open the QuickBooks Desktop workspace, click Create from the side panel and select the New Table / Import Data option. You can integrate with other applications, or choose to import data stored in local filesweb URLslocal databasescloud databases and cloud drives. Click the corresponding links to know more.

9. Can I combine data from other sources with the data from QuickBooks Desktop, and create reports and dashboards?

Yes. To do this, import or add a new table to the QuickBooks Desktop workspace and define a lookup relationship between the added data and the existing data in the workspace. To define a lookup relationship between two tables, it is essential that the tables have at least one column in common between them. Follow the below steps to establish a lookup relationship.

  • Open the corresponding table, right click the column header and select the Change to Lookup Column option.

  • In the dialog that opens, select the column from the second table to look up.

  • Click OK.

Click here to learn more about lookup columns

10. What are Query Tables?

Using query tables, Zoho Analytics allows you to import the required data required by writing standard SQL queries. This feature also allows you to combine data from different tables, and create reports from the combined data. Refer this documentation to know more.

Sharing & Collaboration

1. How do I share reports, dashboards, and tables in Zoho Analytics?

You can share the out-of-the-box reports, dashboards and tables, and the ones you create, with other users easily. Refer this documentation to know more.

2. Why are my colleagues unable to access the reports I create?

The QuickBooks Desktop workspace can be accessed only by the administrator who set up the integration. To allow other users to access the out-of-the-box reports and dashboards, you can share the reports and dashboards as needed. Refer this documentation to know more. 

3. Can other users create reports using the tables in the QuickBooks Desktop workspace?

Yes. To do this, share the required table with the users with the required permissions and filters.

4. Is it possible to share the same report to multiple users such that they each see different data? 

Yes, you can do this by creating Variables. This allows you to share the report to several users, with associated filter criteria so that each user can access only the data specific to them. To learn more, refer this documentation.

5. Can I export a report or a dashboard?

Yes, you can export the report or dashboard in various formats such as CSV, EXCEL, PDF, HTML and image. To learn more, refer this documentation

6. How do I print the reports and dashboards created in Zoho Analytics?

To do this, export the report or dashboard in the required format and print the exported file. To learn more about exporting a view in Zoho Analytics, refer this documentation

Note: To export a shared report or dashboard, the Export permission has to be enabled. 

7. Can I email reports and dashboards at scheduled times?

Yes, you can easily set up email schedules. Refer this documentation to learn more.

8. Can I embed reports? 

Yes. You can easily embed reports and dashboards into websites, applications or blogs. Refer this documentation to know more.

Help & Support

1. How do I get technical support on Zoho Analytics?

Technical support is free for all users, even during the trial period. You can contact technical support through:

2. Can I have get a personalized demo of this integration?

Yes, please register for a demo using the form on this page.


    Access your files securely from anywhere

      Zoho CRM Training Programs

      Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.

      Zoho CRM Training
        Redefine the way you work
        with Zoho Workplace

          Zoho DataPrep Personalized Demo

          If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.

          Zoho CRM Training

            Create, share, and deliver

            beautiful slides from anywhere.

            Get Started Now


              Zoho Sign now offers specialized one-on-one training for both administrators and developers.

              BOOK A SESSION





                          Quick Links Workflow Automation Data Collection
                          Web Forms Enterprise Begin Data Collection
                          Interactive Forms Workplace Data Collection App
                          CRM Forms Customer Service Accessible Forms
                          Digital Forms Marketing Forms for Small Business
                          HTML Forms Education Forms for Enterprise
                          Contact Forms E-commerce Forms for any business
                          Lead Generation Forms Healthcare Forms for Startups
                          Wordpress Forms Customer onboarding Order Forms for Small Business
                          No Code Forms Construction RSVP tool for holidays
                          Free Forms Travel
                          Prefill Forms Non-Profit

                          Intake Forms Legal
                          Mobile App
                          Form Designer HR
                          Mobile Forms
                          Card Forms Food Offline Forms
                          Assign Forms Photography
                          Mobile Forms Features
                          Translate Forms Real Estate Kiosk in Mobile Forms
                          Electronic Forms

                          Notification Emails for Forms Alternatives Security & Compliance
                          Holiday Forms Google Forms alternative  GDPR
                          Form to PDF Jotform alternative HIPAA Forms
                          Email Forms
                          Encrypted Forms
                          Embeddable Forms
                          Secure Forms
                          Drag and Drop form builder
                          WCAG


                                            You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.




                                                Manage your brands on social media

                                                  Zoho Desk Resources

                                                  • Desk Community Learning Series


                                                  • Digest


                                                  • Functions


                                                  • Meetups


                                                  • Kbase


                                                  • Resources


                                                  • Glossary


                                                  • Desk Marketplace


                                                  • MVP Corner


                                                  • Word of the Day


                                                    Zoho Marketing Automation

                                                      Zoho Sheet Resources

                                                       

                                                          Zoho Forms Resources


                                                            Secure your business
                                                            communication with Zoho Mail


                                                            Mail on the move with
                                                            Zoho Mail mobile application

                                                              Stay on top of your schedule
                                                              at all times


                                                              Carry your calendar with you
                                                              Anytime, anywhere




                                                                    Zoho Sign Resources

                                                                      Sign, Paperless!

                                                                      Sign and send business documents on the go!

                                                                      Get Started Now




                                                                              Zoho TeamInbox Resources



                                                                                      Zoho DataPrep Resources



                                                                                        Zoho DataPrep Demo

                                                                                        Get a personalized demo or POC

                                                                                        REGISTER NOW


                                                                                          Design. Discuss. Deliver.

                                                                                          Create visually engaging stories with Zoho Show.

                                                                                          Get Started Now









                                                                                                              • Related Articles

                                                                                                              • QuickBooks Advanced Analytics

                                                                                                                Zoho Analytics Advanced Analytics for QuickBooks Online empowers you with financial analytical capabilities over your QuickBooks Online data. With this connector you can create insightful reports & dashboards over your QuickBooks data for in-depth ...
                                                                                                              • Integration with Google Ads

                                                                                                                Zoho Analytics seamlessly integrates with Google Ads, and enables you to easily analyze your Google Ads campaign data and keep track of key metrics. This helps product marketers create intuitive reports on your accounts, campaigns, Ad Groups, and ...
                                                                                                              • Integration with Zoho CRM

                                                                                                                Zoho Analytics seamlessly integrates with Zoho CRM, and enables you to analyze your Zoho CRM data easily and keep track of key metrics. This helps managers create intuitive reports on your campaigns, invoices, purchase orders, and much more.  General ...
                                                                                                              • Integration with Exact Online

                                                                                                                Zoho Analytics seamlessly integrates with Exact Online, and enables you to analyze your accounting data easily and keep track of key metrics. This helps managers create intuitive reports on your accounts, opportunities, payments, and much more.  ...
                                                                                                              • Integration with Jira Software

                                                                                                                Zoho Analytics seamlessly integrates with Jira Software Server and Jira Software Cloud. This enables you to easily analyze your project management data by generating detailed reports on projects, backlogs, sprints, issues, and much more.  Please note ...
                                                                                                                Wherever you are is as good as
                                                                                                                your workplace

                                                                                                                  Resources

                                                                                                                  Videos

                                                                                                                  Watch comprehensive videos on features and other important topics that will help you master Zoho CRM.



                                                                                                                  eBooks

                                                                                                                  Download free eBooks and access a range of topics to get deeper insight on successfully using Zoho CRM.



                                                                                                                  Webinars

                                                                                                                  Sign up for our webinars and learn the Zoho CRM basics, from customization to sales force automation and more.



                                                                                                                  CRM Tips

                                                                                                                  Make the most of Zoho CRM with these useful tips.



                                                                                                                    Zoho Show Resources