Why does the data available in the Customer Balances report differ from the data available in the Customer Balances Summary report?

The Customer Balances Summary report includes the customer balances for the selected period, whereas the Customer Balances report includes the customer balances that are applicable for the selected period and future dates.

To access the same information found in the Customer Balances Summary report, you can export the Customer Balances report while excluding transactions created on future dates. The information will not be within the report itself but will instead be available in the exported file. Here’s how you can do this:

  • Go to the Reports module in the left sidebar.
  • Select Customer Balances report under Receivables.
  • Click Customize Report on the top left corner of the page.
Customize Report
  • On the Customize Report page, check the Generate balances as on the selected date without considering transactions created at a later date option.
Generate reports as on selected date
  • Click Schedule Report to schedule the report.
  • In the pop up that appears, check the I want to protect this file with a password option if you want to secure the file. Enter a password of at least 6 characters in the Password field.
Enter password
  • Click Customize the details in the export file if you want to customize the contents of the export file. The pop up will expand. Make the necessary customizations.
Make the necessary customization
  • Click Export.
  • A pop up will notify you that the report will be available shortly. Click OK.
  • You will get an in-app notification once the export file is ready. Click the Notification button on the top right corner of the page and click the Customer Balances report has been generated notification.
Click the Notification button
  • You will be redirected to the Customer Balances report page. In the pane that appears, click Download next to the notification.
Click Download

Your Customer Balances report will be downloaded as a PDF, containing data exclusively related to customer balances for the chosen period.

Was this document helpful?
Thank you for your feedback!
Want a feature?

Switch to smart accounting software. Switch to Zoho Books.   Start my free 14-day trial Explore Demo Account


Online accounting software
for small businesses.