Clients Balance Report

Report Overview

The Clients Balance Report provides a financial overview for each client over a selected period. It includes the opening balance before the period, total sales, returns, payments, and adjustments, leading to the current closing balance.

This report is used to review outstanding client balances, track account activity, and determine the net receivable or payable balance for each client over any given period.

How to Access the Report

1. Go to the Reports menu.
2. Click on Clients Reports.
3. Select Clients Balance.
4. You can apply the following filters before displaying the report:

• Date Range (From – To): Select the period for which you want to view client balance activity.
• Client: Select one or more clients to view their balances only (search by name, email, or phone number).
  If not selected, all clients will be included.
• Client Category: Filter results to display clients of a specific category only.
  If not selected, all categories will be included.
• Hide Zero Balances: Enable this option to hide clients with zero balance and display only clients with balances.
• Show Details: Enable this option to display additional client details such as address, phone number, and category.
• Employee: Select one or more employees to view clients associated with them.
  If not selected, all employees will be included.
• Follow-up Status: Filter clients based on manually assigned follow-up status.
  If not selected, all clients will be included.
• Search Keywords: Enter a keyword or phrase to filter client data.
• Journal Branch: Select one or more branches to view accounting entries related to those branches only.
  If not selected, all branches will be included.
• Hide Columns: You can hide any columns you do not need. Available columns include: Code, Account Number, Name, Client Branch, Manual Status, Employee, Opening Balance, Total Sales, Total Returns, Net Sales, Total Payments, Adjustments, Balance.

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 client only.
• Detailed View: Displays each transaction within the client account.

You can print the report using Print, or export it via Export to:

• CSV
• Excel
• PDF

Report Columns

• Code: The customer’s unique identifier in the system, with a direct link to the full customer profile.
• Account Number: The customer’s account number in the general ledger.
• Name: The customer or company name as recorded in the system, with a direct link to the customer profile.
• Client’s Branch: The branch the customer belongs to.
• Manual Status: The manually assigned follow-up status of the customer.
• Employee: The employee responsible for or associated with the customer.
• Balance Before : The customer’s balance before the selected period. A negative value indicates a credit balance in favor of the customer.
• Total Sales: The total value of sales invoices issued to the customer during the period.
• Total Refund: The total value of return invoices issued to the customer during the period.
• Net Sales: The difference between total sales and total returns. A negative value indicates returns exceed sales.
• Total Payments: The total amount paid by the customer during the period.
• Settlements: The value of any adjustments or journal entries applied to the customer account during the period.
• Balance: The current closing balance after all transactions. A positive value indicates an amount due from the customer, while a negative value indicates a credit balance.

At the bottom of the table, a Grand Total Row summarizes all financial columns for all customers during the entire period.