Customer Payments Report

Report Overview

The Customer Payments Report displays all payments and collected amounts from customers over a selected period. It includes details such as payment method, receiving treasury, and the employee responsible for collection.

This report is used to monitor cash collection activities, review incoming payments, and track the performance of the sales team in collecting customer dues over any given period.

How to Access the Report

1. Go to the Reports menu.
2. Click on Client’s Reports.
3. Select Clients Payments.

You can apply the following filters before displaying the report:

• Client: Select one or more customers to view their payments only (search by name, email, or phone number).
  If not selected, all customers will be included.
• Client Category: Filter results to display customers of a specific category only.
  If not selected, all categories will be included.
• Payment Method: Filter payments based on the payment method used. Available methods include cash, cheque, bank transfer, credit card, manual payment, cash on delivery, customer credit balance, and other online payment gateways.
  If not selected, all payment methods will be included.
• Date Range (From – To): Select the period for which you want to view payments.
• Treasury: Select a specific treasury to view payments received into it only.
  If not selected, all treasuries will be included.
• Show Details: Enable this option to display additional customer details such as address, phone number, and category.
• Assigned Staff: Select one or more employees to view payments associated with them (search by name, code, email, department, branch, or country).
  If not selected, all employees will be included.
• Keywords: Enter a keyword or phrase to search within customer data such as phone number, address, or department.
• Branch: Select one or more branches to view their payments only.
  If not selected, all branches will be included.
• Hide Columns: You can hide any columns you do not need. Available columns include: ID, Date, Customer Code, Customer Name, Type, Document Number, Payment Method, Treasury, Amount, Employee, Collected By, Branch, Added By.
• Group By: Choose how to group the report data:
  
  • Customer
  • Treasury
  • Payment Method
  • Branch
• Order By: Select how to sort the results:
  • Date Descending
  • Date Ascending
  • Number Descending
  • Number Ascending

After adjusting the filters, click Show Report to update the results, or click Clear Filters to reset to default settings.

You can switch between:

• Summary View: Displays totals per customer only.
• Detailed View: Displays each payment under its respective customer.

A chart is displayed at the top of the page showing the distribution of payments across customers.

• You can print the report using Print, or export it via Export to:
  
  • CSV
  • Excel
  • PDF
  • PDF (Without Chart)

Report Columns

The table displays payments grouped under each customer. When using Detailed View, each payment appears individually within its customer group. Columns are organized as follows:

• ID: The unique identifier of the payment in the system, with a direct link to view details.
• Date: The date the payment was recorded.
• Client Code: The customer’s unique identifier in the system.
• Client Name: The name of the customer who made the payment.
• Type: The document type associated with the payment:
  Invoice
  Sales Return
  Return payments are displayed in red and as negative values
• Document Number: The invoice or return number linked to the payment, with a direct link to view it.
• Payment Method: The method used for payment (e.g., cash, bank transfer, credit card).
• Treasury: The treasury where the payment was received.
• Amount: The paid amount in the selected currency. Return payments appear as negative values.
• Assigned Staff: The employee responsible for the customer or linked to the transaction.
• Collected By: The employee who actually collected the payment.
• Branch: The branch where the payment was recorded.
• Added By: The user who entered the payment into the system.

At the end of each customer group, a Subtotal Row summarizes total payments for that customer during the selected period.
At the bottom of the table, a Grand Total Row summarizes all payments across all customers for the entire period.