Customer Deposit

Report Module Guide: Customer Deposit Report

Module Location

Finance > Reports > Customer Deposit

Module Objective

The Customer Deposit Report module is used to generate a detailed report regarding all deposit or down payment transactions received from customers. This report is crucial for tracking the initial deposit amount, how that deposit was used to pay invoices (settlement), and how much of the balance is still available.

1. Report Parameters (Filter)

The main page of this module is a form containing various parameters to customize the report that will be generated.

Here is an explanation for each parameter:

• Customer Code/Name:

  • Filter the report to display deposits from one specific customer, or leave it blank to display all customers.

• From / To:

  • Specify the date range of the deposit transactions you wish to display (e.g., September 7, 2025, to October 7, 2025).

• Unsettled:

  • Important filter: Check this box to only display deposits that still have a remaining balance (that have not been fully used).

2. Steps to Generate the Report

Step 1: Set Report Parameters

Define the parameters you need, such as the date range or a specific customer. Use the Unsettled filter if you only want to see remaining deposits.

Step 2: Generate the Report

After all parameters are set, click one of the two buttons at the bottom:

• [Display Report]: To preview the customer deposit report directly on your screen.

• [Export to MS Excel]: To download the report data in an Excel file format.

3. Reading the Report (Report Content)

The generated report will be a list of deposit details, grouped by customer.

This report displays important details such as:

• Document Number: The cash receipt number from when the deposit was received.

• Invoice No.: The sales invoice number that was paid using the deposit.

• Deposit: The initial down payment amount received.

• Used/Deposit: The amount of the deposit that has been used/applied.

• Remaining: The remaining balance of the deposit that is still available.

Tips & Important Notes

• Use the Unsettled filter to quickly see the total down payment liability that the company still has towards its customers.

• This report is a recapitulation of the data created in the Bank/Cash Receipt module and processed in the Settlement module.

• This is an important operational report for the AR (Account Receivable) and Accounting teams.