Customer Balance Summary

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.

Reports Interface Details

The Reports interface has been redesigned with greater accuracy and organization to provide a more efficient and flexible reporting experience, making it easier to access, review, and analyze your business data based on your operational needs.

Available Features in the Reports Interface:

• Pin Reports Feature:
  You can pin your most important or frequently used reports by clicking on the “Pin” option, allowing them to appear at the top of the Reports page for quicker access without needing to search through all reports each time. You can also unpin reports at any time by clicking the same option again.

• Summary or Detailed View:
  When selecting a report, you can choose how you would like the data to be displayed:

  1 - Summary View to display key information such as accounts and amounts.

  2 - Detailed View to access more in-depth information such as customers, notes, or any additional details added to your transactions.
  This feature helps you analyze your data with the level of detail that best suits your needs.

• Reports Categorization:
  Reports are organized into clear categories to help you quickly find the right report based on the type of information you need, such as reports related to cost centers, projects, and other classifications.
  This organization saves time and effort while providing more accurate and structured reporting insights.

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.