Viewing the Clients Balance Report

The Clients Balance report shows the financial position of each client during a specific period. It includes the balance before the start of the period, total sales, refunds, payments, and settlements, leading to the current closing balance. This report is used to review the balances owed by clients, track their account movements, and know the net debt or balance of each client in any period.

Steps to view the report

1. Click Reports.
2. Click Clients Reports.
3. From the page, select Clients Balance.
4. You can apply a number of filters before viewing the report:
   • From Date / To Date: Select the period you want to view the client balance movements for.
   • Client: Select one or more clients to view only their balance. You can search by name, email, or phone number.
     • If you don’t select a specific client, the system shows the report for all clients.
   • Client Category: Filter the results to show only the clients of a specific category. You can search by name.
     • If you don’t select a specific category, the system shows all categories.
   • Hide Zero Balance: Enable this option to hide clients with a zero balance and show only clients with balances.
   • Show details: Enable this option to show the client’s address, phone, and category details.
   • Assigned Staff: Select one or more employees to view the clients linked to them. You can search by name, code, email, department, branch, or country.
     • If you don’t select a specific employee, the system shows the report for all employees.
   • Follow Up Status: Filter the clients by the follow-up status assigned to them manually.
     • If you don’t select a specific status, the system shows all clients regardless of their status.
   • Keywords: Type a word or phrase to search the clients’ data and filter the results based on it.
   • Journals Branch: Select one or more branches to view only the accounting entries linked to that branch.
     • If you don’t select a specific branch, the system shows the report for all branches.
   • Hide Columns: You can hide any report column you don’t need to show. The columns that can be hidden are: Code, Account No, Name, Client’s Branch, Manual Status, Employee, Balance Before, Total Sales, Total Refund, Net Sales, Total Payments, Settlements, and Balance.
5. After you edit the filters, click Show Report to update the results, or click Reset to go back to the default settings.
6. You can switch between Summary to show only the totals of each client, or Details to show the data of each transaction separately within the client’s account.
7. You can print the report from Print or export it from Export to:
   • CSV
   • Excel
   • PDF

Report columns

The table shows a row for each client with a summary of their account movement during the selected period. The columns are as follows:

Column	Description
Code	The client’s ID in the system, with a direct link to view the full client profile.
Account No	The client’s account number in the general ledger.
Name	The client or company name as registered in the system, with a direct link to the client profile.
Client’s Branch	The branch the client belongs to.
Manual Status	The client follow-up status that was assigned manually.
Employee	The name of the employee responsible for or linked to the client.
Balance Before	The client’s accumulated balance before the start of the period selected in the filter. A negative value means the client has a credit balance.
Total Sales	The total value of the sales invoices issued to the client during the selected period.
Total Refund	The total value of the refund invoices issued to the client during the selected period.
Net Sales	The difference between total sales and total refund. A negative value means the refunds exceeded the sales.
Total Payments	The total amounts paid by the client during the selected period.
Settlements	The value of any settlements or adjustment entries made on the client’s account during the period.
Balance	The client’s current closing balance after calculating all movements. A positive value means an amount owed by the client, and a negative value means a credit balance in their favor.

At the bottom of the table, the Totals row adds up the values of all the financial columns for all clients over the whole period.

FAQs

Can I view the Clients Balance report for each currency separately?

No, the Clients Balance report shows the balances in the account currency only, and it doesn’t have a currency filter. Its filters are: From Date / To Date, Client, Client Category, Hide Zero Balance, Show details, Assigned Staff, Follow Up Status, Keywords, and Journals Branch.

How do I hide clients with a zero balance?

Enable the Hide Zero Balance option before viewing the report, so only the existing balances appear.

What does a negative value in the Balance column mean?

A negative value in the Balance column means a credit balance in the client’s favor, while a positive value means an amount owed by the client.