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

Zoho Books -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 Customise Report on the top left corner of the page.
Customize Report
  • On the Customise 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 Customise the details in the export file if you want to customise the contents of the export file. The pop up will expand. Make the necessary customisations.
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.


    • Related Articles

    • Zoho Books - Why does the closing balance in the Customer Balances Summary report not match with the accounts receivable in the Balance Sheet report?

      The accounts receivable section in the Balance Sheet report displays the outstanding receivables for the selected period. However, if you’ve recorded payment for transactions created for a future date, those payments will be tracked under unearned ...
    • Zoho Bigin Integrating with Zoho Books

      The Zoho Books/Invoice integration for Bigin lets you sync contacts, companies, and products between Zoho Books or Zoho Invoice and Bigin. Zoho Books and Zoho Invoice users can also create and view invoices, estimates, and sales orders related to ...
    • Zoho CRM Troubleshooting Data Import and Export

      1. When I try to import leads, I get an error message which says "Duplicate record exist in system: Email." I've checked my CRM data and there is no duplicate record with the same email address. How do I resolve this? Once you have ensured there is ...
    • Zoho CRM Troubleshooting Data Backup

      1. My scheduled data backup is not ready for download in CRM. What should I do? The screenshot below is the default data backup screen in Zoho CRM and will appear when there is no data backup schedules. The screenshot below shows what the page will ...
    • Zoho CRM Troubleshooting Data Storage

      1. My data storage was full, so I deleted many unnecessary records but the storage still shows as full and I cannot add new records or notes. The data and file storage in your organization is checked and updated once an hour. This means that it will ...