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.

• On the Customize Report page, check the Generate balances as on the selected date without considering transactions created at a later date option.

• 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.

• 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.

• 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.

• You will be redirected to the Customer Balances report page. In the pane that appears, click Download next to the notification.

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