Supplier Balance Summary

In businesses that rely on purchasing goods or materials on credit or maintaining ongoing relationships with recurring suppliers, it becomes essential to track the financial balance of each supplier.

The "Supplier Balance Summary" report in Wafeq provides a focused view of your financial obligations to suppliers during a time period you define, showing the opening balance, total debit and credit movements, and the closing balance.

This report allows you to easily answer questions such as:

• What is the total amount owed to suppliers at the end of the period?

• How has the balance changed since the beginning of the period?

• Have the supplier payments been made, or has your liability increased?

In this guide, we will explore the steps for viewing the report and its details.

How to View the supplier Balance Summary Report?

Click on "Reports" in the main menu, then click on "supplier Balance Summary" under the "Purchases" reports.

Controlling the Display Order of Report Columns

Wafeq allows you to customize how columns are displayed in the Supplier 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.

Click the “Edit Columns” ⚙️ button at the top of the report table.

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.

Frozen Columns

At the top of the settings panel, you will find a section called:

Frozen  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 freezw a column:

Drag the desired column into the “Frozen Columns” section at the top.

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.