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.

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 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.