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.

IN THIS PAGE…

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 customize different attributes of the reports such as the table density, design, orientation, margins, paper size, and the fonts. To do this:

Go to Reports and select the Configure Report Layout option from the top-right corner.

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
Organization Name	Enable this option to display your organization’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.

Click Save.

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.

Custom Reports

Custom Reports lets you save all the customizations you have made to a report as a separate report. This way, all the preferences you applied to a report will be saved and you can access it when you need it 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 create a custom report:

In the report creation page, click Customize Report.
After you’ve selected the customizations that you need, click Save as Custom Report.**

Click Next to go to the Re****port Layout section. Here, you can further customize the report by configuring a separate layout for the report. Configuring your report layout lets you control how your report looks like when you print or export it. Learn more about Report Layout.
After you’ve made the changes, click Next to go to the Report Preferences section.
Enter a name for the custom report in Report Nam****e.
Enter a name in the Name in Export field to set the name that should be used when exporting the report.
Configure who can view, export, or schedule the custom report in Configure Permissions. You can find the different share options that are available in the table below:

Field	Description
Only Me	Only you will be able to view, export, or schedule the custom report.
Only Selected Users & Roles	Only the selected users will be able to view, export, or schedule the custom report.
Everyone	Everyone in the organization will be able to view, export, or schedule the custom report.

You can schedule your custom reports that you have saved to be sent to your email address or other users in the organization. In the custom report details page, click Schedule Report. These reports will be sent in different time intervals at a specific time you configure.

Note: The date range specified in the custom report will be used when a scheduled report is generated. For example, let’s say you schedule a custom report to be generated on a weekly basis and the date range mentioned in the custom report is This Month (June). If the first report is generated on 7 June 2021, it will use the data from 1 June 2021 to 31 June 2021, and the second report which will be generated on 14 June 2021 will also use the data from 1 June 2021 to 31 June 2021.

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.

All the custom reports that you create will be listed under the Custom Reports section in the Reports module.

Schedule Reports

You can schedule your reports to be sent to your email address or other users in the organization. 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:

Go to Reports and select the report which you wish to be generated based on a schedule.
Click the Schedule Report option at the top next to the Print icon.
Select the criteria based on which you wish to schedule the report.
Click Save.

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:

Go to Reports
Click Scheduled Reports in the top right corner.

Deactivate Scheduled Reports

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

Go to Reports.
Click the scheduled report, which you wish to disable (For eg: Sales by Customer).
Click the Report has been scheduled button in the top right corner of the page.

In the pop-up window that follows (Report Scheduler), click Mark as Inactive to make the report inactive.
Click Save for the changes to take effect.

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:

Click Settings on the top right corner of the page.
Click General under Preferences.
Check the Send Weekly Summary report option.

The reports will be sent to the admins of the organization 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:

Click the Gear icon in the top right corner of the window.
Select Users and Roles and click the Roles tab.
Create a new custom role or edit a custom role that you had already created.
Scroll down to the bottom of the Edit Role page. You will find the Reports permissions at the end of the page.
If you want to give this role full access to all the reports in Zoho Books, check the Enable full access for all reports option.

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.

If you want to give this role limited access to some of the reports in Zoho Books, you can click a report group and mark the permissions the role can have for each report. Later, when new reports are introduced, you will have to edit the role and provide access to the new reports.
Scroll down and click Save after you’ve configured the 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.

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 organization, however he doesn’t have access to the reports module. So, he approaches the admin of his Zoho Books organization 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:

Go to Reports in the left sidebar.
Select the report you want to share with another user.
Click the Share icon at the top right corner.
Select the user with whom you want to share the report and the level of access they can have.
Click Share.

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:

Go to Reports in the left sidebar.
Select the report for which you want to modify the sharing permissions.
Click the Share icon at the top right corner. The users who have access to the report will be listed in the popup.
Click the dropdown in the Permissions column and change the level of access the user has to the report. The permissions will be updated immediately.

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:

Go to Reports in the left sidebar.
Select the report for which you want to remove a user’s access.
Click the Share icon at the top right corner. The users who have access to the report will be listed in the popup.
Click the Remove icon next to the user’s name and level of permissions. The user’s access to the report will be removed immediately.