How to Generate Customer Control Summary Report

Overview:

The Customer Control Summary report provides a consolidated view of all customer control account balances. It helps users quickly assess outstanding receivables, identify inconsistencies, and support accurate reconciliation. This report is especially useful for accounting staff, collection teams, and anyone monitoring customer balances across multiple control accounts.

Scenario:

Before the month-end closing, an Accounts Receivable officer needs to verify that customer balances are correctly aligned with their designated control accounts. Instead of reviewing multiple detailed reports, the officer runs the Customer Control Summary report to view all customer balances at a glance—grouped and summarized by control account—ensuring a faster and more accurate reconciliation process.

Procedure:

1. Go to Reporting > Report Center > Customer > Other Reports > Customer Control Summary

2. In the Filter section, configure the following options as needed:

• Date Range – Select the reporting period.

• Customer – Filter by specific customer or leave blank to include all.

• Agent – Filter by assigned agent.

• Doc Agent – Filter by document agent, if applicable.

• Area – Filter by customer area or region.

• Category – Select the customer category.

• Control A/C – Choose the customer control account.

• Project - Filter by project (visible only if the add-on module is enabled).

• Include PD Cheque – Enable this option to include Post-Dated Cheques in the summary.

• In Local Currency – Enable this option to display balances in local currency.

• Sort By – Select Customer Code or Customer Name for sorting.

3. Click Preview to generate the report.

4. Review the results to confirm alignment between customer balances and control accounts.

Application:

• Reconciliation: Validate customer balances against control accounts.

• Financial Control: Maintain oversight of receivables at a summarized level.

• Audit Preparation: Provide auditors with a consolidated customer balance summary.

• Performance Monitoring: Assess receivables by agent, area, or category.

• Management Reporting: Present high-level customer balance information for decision-making.