The "Customer Balance Summary" feature in Wafeq provides a quick and efficient way to track each customer's financial balance in your accounts. The report allows you to select the time period you want to display the data for, and shows the financial movements that occurred during that period, making the tracking and collection process easier.
This report allows you to easily answer questions such as:
What is the total amount each customer owes at the end of the period?
How has the balance changed since the beginning of the period?
Has the customer made any payments, or has their debt increased?
In this guide, we will explore the steps for viewing the report and its details.
How to View the Customer Balance Summary Report?
Click on "Reports" in the main menu, then click on "Customer Balance Summary" under the "Sales" reports.
Controlling the Display Order of Report Columns
Wafeq allows you to customize how columns are displayed in the Customer Balance Summary report. You can show or hide specific columns, as well as rearrange them based on your needs.
This helps you focus on the most important data, such as the opening balance, debit, credit, or closing balance.
At the top of the report table, click the “Edit Columns” ⚙️ button.
A panel will appear containing:
All available columns in the report
Toggle switches to show or hide columns
The ability to reorder columns using drag and drop
Showing or Hiding Columns
You can easily control column visibility:
To show a column → Turn on the toggle next to it
To hide a column → Turn off the toggle next to it
Example:
You can hide the Opening Balance column if you don’t need it, or display the Debit and Credit columns when reviewing transaction details.
Reordering Columns
To change the order of the columns:
Click and hold the drag icon (⋮⋮) next to the column name
Drag the column up or down to your desired position
Release it in the new location
The column order will update instantly in the report.
Example:
You can move the Closing Balance column next to the Customer Name column to quickly review customer balances.
Frozen Columns
At the top of the settings panel, you will find a section called:
Pinned Columns
What does freeze a column mean?
When you pin a column, it remains fixed at the beginning of the table even when you scroll horizontally. It does not move with the other columns.
This is especially useful when working with reports that contain many columns.
How to freeze a column:
Drag the desired column into the “Pinned Columns” section at the top.
Resetting to Default
If you want to return to the default column order:
Click “Reset”
The report will return to its original column arrangement.
You can also share your feedback about the column visibility feature by clicking “Share your feedback here.”
You can perform the following actions on the report:
Customize the report based on the time period (e.g., Last 3 months, Last 12 months, or a custom period).
Filter the report data by branches / cost centers / projects.
Download the report by exporting it as an Excel or PDF file.
Comments
0 comments
Please sign in to leave a comment.