Zoho Reports

Zoho Reports

About


Zoho Reports is a powerful online reporting and business intelligence service, with an intuitive drag-and-drop interface that enables in-depth analysis and easy reporting.

Note: The instructions below are meant for someone with more than average technical knowledge. If you are having difficulty, you may wish to consult with an IT contact at your company for assistance.


How To Integrate AccountingSuite with Zoho Reports



Note: You will need to create separate data sources for Daily Snapshots and Financial Performance. In the example below, we will demonstrate how to connect the Daily Snap service.
  1. Select the Files & Feeds icon to set the source of data. (see figure 1, below)
  2. Configure the Import Your Data Form. (See figure 2, below)
    1. Enter a name in the Database Name field. Give it a friendly name that describes the data from AccountingSuite.
    2. Enter a Description. This should give details about what this connection does and what kind of data is retrieved. This field is for you and your co-workers to understand what the connection is for.
    3. Choose  JSON in the File Type drop down.
    4. Choose the Web radio button in the Data Location field.
    5. Select the URL with Authentication tab.
      1. Enter the following URL. Replace {account_number} with your 7 digit AccountingSuite Account Number found in the upper left corner of the screen in AccountingSuite. For example:  https://apps7.accountingsuite.com/a/1100755/hs/data_mart/daily_snap
      2. Enter the Username for the AccountingSuite account.
      3. Enter your password for the AccountingSuite account.
    6. Add Parameters (optional).
      1. Choose Get in the Method drop-down.
      2. We provide 2 optional parameters for entering the period.
        The date format is yyyyMMdd – four digit year, two digit month (from 01 to 12) and two digit day (from 01 to 31).
        Parameter Name: BeginOfPeriod, Value: 20160101, Send request as : Parameter.
        Parameter Name: EndOfPeriod, Value: 20161231, Send request as : Parameter.
    7. Click Next. 
  3. Complete Import Your Data details. (see figure 3, below)
    1. Table Name: Give a friendly name for this new Table.
    2. First row contains column names: Yes.
    3. Format of date columns: yyyy-MM-dd
    4. On Import Errors: Set empty values for the column.
    5. Click Create.
  4. Review the Imported Data Summary from Zoho Reports. (see figure 4, below)
    At this point, you can decide to schedule the import by clicking on “Schedule this Import”.
  5. Now you will see the new Table in “Tables & Reports” in the left menu. Follow the Zoho Reports tutorials to create your own Dashboard. (see figures 5 a,b,c, below)




Figure 1, Choosing a Data Source
Figure 1, Choosing a Data Source


Figure 2, Import Data
Figure 2, Import Data


Figure 3, Import Data
Figure 3, Import Data


Figure 4, Data import summary.
Figure 4, Data import summary


Figure 5a, Sample
Figure 5a, Sample



Figure 5b, Sample Report



Figure 5c, Sample Report

Related Articles

    • Related Articles

    • Zoho Reports

      Zoho Reports  About Zoho Reports is a powerful online reporting and business intelligence service, with an intuitive drag-and-drop interface that enables in-depth analysis and easy reporting. Note: The instructions below are meant for someone with ...
    • AccountingSuite™ Reports

      Reporting AccountingSuite™ has a complete set of financial, operational and project based reports. Our advanced reporting customization features allow you to create the report you want. To run a report, Navigate to Reports → Report Category (Ex. ...
    • Running Reports

      Overview Reports in AccountingSuite™ are located in the Reports menu . They are broken down by module and are available in the menu for modules included in your edition of AccountingSuite™. Common Features Across Reports Report Command Bar Run report ...
    • Multi-currency Financial reports (extension)

      Multi-currency reporting offerings include the Income Statement, Balance Sheet, A/P Aging, A?R Aging, and General Ledger reports Introduction Now available with multiple currencies, AccountingSuite™’s  Financial Reports are available in ...
    • Expense Reports (extension)

      Overview The Expense Reports extension allows users of your organization to submit expense reports and managers to approve the expense reports. Installation Please view this article for installation instructions. Setup A few setup tasks are needed In ...