Manage Reports

You can manage the reports in Zoho Books by configuring PDF layouts during export, scheduling reports to auto-send them at specific frequencies, configuring role-based access to reports, and sharing reports with other users.

Configure Layouts For Reports

Zoho Books provides you the option to easily configure report layouts to best suit your business requirements when you print or export them as a PDF.

Prerequisite: Only the admins and the users who have full access to all the reports can configure layouts for reports.

You can choose and the fields that have to be displayed and customise different attributes of the reports such as the table density, design, orientation, margins, paper size, and the fonts. To do this:

Reports Reports
Field Description
Table Density These options affect the size of the rows in the report that is printed or exported. You can select from three options: Classic, Compact and Super Compact.
Table Design This option allows you to choose the way you want the information on your report to be tabularized. You can select from three options: Bordered, Alternative Rows and Alternative Columns.
Paper Size Based on the medium where this would be printed, you can select either A4 or Letter sizes.
Orientation Select either Portrait or Landscape based on where you’re displaying the report.
Font Family This is the font that will be used to display content on this report. A note will appear under the selected font explaining which language it’s best suited for.
Margins The margins of the reports determine how much distance there is between the report’s content and the edges of the medium on which it’s printed.

Note: Opting to choose a Table Design that is not the default option i.e., bordered, alternative rows, or alternative columns will not be applicable to the Business Overview and Tax Reports.

Choose Details to Display

This section lets you select the information to be displayed in the report that is going to be printed or exported as a PDF.

Table Description
Organisation Name Enable this option to display your organisation’s name on the report.
Report Basis Select the method of accounting to be displayed on your report: cash-based and accrual-based.
Page Number Enable this option to auto-generate the page number in the footer section for your reports.
Generated By Selecting this option will display the name of the admin who is generating the report. If you have chosen to schedule the report to be generated, selecting this option will mention that the report is generated by the ‘system’ (Zoho Books).
Generated Date Enable this option to display the date on which the report was generated.
Generated Time Enable this option to display the time when the report was generated.

Note: The Generated Time will be not be enabled if you have not chosen to display the Generated Date.

Insight: Configuring the layouts will be applicable to all the reports when you print them, or when you export the PDF. However, the configuration can be changed if you wish to make an exception when you want to print or export an individual report just for that instance. These configurations for the individual report will only be applicable for that instance and will not be reflected when you try to print or export the PDFs of the other reports.


Customize Reports

You can customise a report by applying filters and selecting columns to display, and view the customisations in the report instantly.

Note: This feature is available only for certain plans of Zoho Books. Visit the pricing page to check if it’s available in your current plan. Furthermore, the Custom Reports feature is available only in Profit and Loss, Balance Sheet, Cash Flow Statement, and Invoice Details reports.

To customise a report:

Customize Report button

You will be redirected to the General section.

1. General

In the General section, you can customise your report based on the following filters:

Filters Description
Date Range Generate the report for a specific week, month, quarter, or year or set a custom duration of your own.
Report Basis Select the method of accounting to be displayed in your report:

Accrual: Amount generated when the transactions are created.
Cash: Amount generated when the organisation actually receives the cash.
Filter Accounts Filter accounts that you’d like to include. This can be:
1. All accounts
2. Accounts with transactions
3. Accounts without zero balance
Compare With Compare the report with previous periods, months, quarters, or years.

To compare your report with the previous years or previous periods, select your preferred date range.

To compare your report with the previous months, select month-wise ranges like Jan 1 to Jan 31 as your custom date range.

To compare your report with the previous quarters, select quarter-wise ranges based on your organisation’s fiscal year. For example, if your fiscal year is January to December, select date ranges like Jan 1 - Mar 31, Apr 1 - Jun 30, etc., as your custom date range.
Advanced Filters Filter your report based on projects, reporting tags, and branches.

Note: If you have specified a custom date range in your custom report and you schedule it, the scheduled report will be generated using the data available between the custom date range. For example, let’s say you schedule a custom report to be generated on a weekly basis and the custom date range is between 7 July 2021 to 7 August 2021. After 7 August 2021, every weekly report generated will use the date from 7 July 2021 to 7 August 2021.

2. Show/Hide Columns

In this section, you can customise the columns of your report. Here’s how:

Show / Hide Columns

Learn how to save your customisations as a new custom report in this help document.


Schedule Reports

You can schedule your reports to be sent to your email address or other users in the organisation. These reports will be sent in different time intervals at a specific time chosen by you.

Zoho Books allows you to schedule a report to be generated on a weekly, monthly, quarterly or yearly basis as per your preference. The generated report will then be sent to the email addresses of your choice.

Note: The Schedule Report option is available only in certain reports. If you want the Schedule Report option in a report that does not have it, kindly reach out to us at support@zohobooks.com.

Prerequisite: Only the admins and the users who have permission to schedule reports can schedule reports.

To schedule a report:

Reports

The report will be automatically sent to your email at the specified time and interval.

View Scheduled Reports

Zoho Books lists all the reports you’ve scheduled, for your reference. You can keep track and view the details of them in our dedicated Scheduled Reports page.

It details the frequency of your scheduled report, the user who scheduled the report, the email recipients, the status of your report, the date when your next report is due and the file format chosen.

Prerequisite: Only the admins and the users who have full access to all the reports can view scheduled reports.

To view your scheduled reports:

Reports

Deactivate Scheduled Reports

You can disable a scheduled report by performing the steps mentioned below:

Reports Reports

Insight: If you wish to re-enable a scheduled report, kindly click the Active option against Status.

Receive Weekly Summary Reports

Zoho Books can send a Weekly Summary Report to the admin if the option is enabled. The report contains a summary of income and expenditure, cash flow, transaction overview, active projects, alerts, and new feature updates.

To enable this:

Reports

The reports will be sent to the admins of the organisation every Sunday.


Configure Role Based Access to Reports

The predefined roles in Zoho Books cannot be edited. However, you can create custom roles and configure the permissions the users with that role will have for reports.

Prerequisite: Only admins can configure roles in Zoho Books.

To configure the report permissions of a role:

Note: If you want users with this role to view the list of scheduled reports and configure layouts for report PDFs, you will have to enable full access for all reports.

Edit Role's Report Permissions

Once you configure the role, all the users with this role will have access only to the reports you’ve permitted for their role.


Share Report With Another User

In Zoho Books, admins have access to all the reports. Based on the permissions granted for a role, a user’s access to reports might be limited. In such cases, when the user needs access to a report, you can share the report with them.

Scenario: John is the Sales lead in his organisation, however he doesn’t have access to the reports module. So, he approaches the admin of his Zoho Books organisation to give him access to the Sales by Customer report. Now, using the Share Report option, the admin shares the report with John so that he can view, export, and schedule the report.

Prerequisite: Only Admins and the users with the Share permission in their role can share the report with other users.

To share a report with another user:

Edit Role's Report Permissions

Modify User’s Level of Access to a Report

After you have given access to a report, if you want to change the level of access a user has to a report, you can modify it.

To modify the level of access to a report:

Edit Role's Report Permissions

Remove User’s Access to a Report

You can remove a user’s access to the report if they no longer need to have access to the report. To remove access:

Edit Role's Report Permissions
Was this document helpful?
Yes
No
Thank you for your feedback!
Want a feature?
Suggest
Switch to smart accounting software. Switch to Zoho Books.   Start my free 14-day trial Explore Demo Account

Books

MTD ready accounting
software for small
businesses.