How You Can Check Supplier Running Balances

Users can check the supplier financial summary or each supplier’s running balance, or in simple words, the “supplier statement of account,” through their account details. There is a download button located on the right side of the “supplier details page” through which you can download the supplier’s financial summary for records. 

This screen provides a quick overview of the supplier’s financial position, helping you monitor total purchases, payments made, outstanding balance, and recent cash flow activity. 

Purchases Section 

This section shows the total purchase amount for the current month, payments made to the supplier, and the remaining balance. 

The balance is automatically calculated as
Balance = Total Purchases – Payments 

This helps you understand how much is still payable to the supplier. 

Bill Summary 

This panel displays the number of bills created in the  

• current month 

• total bills in the financial year 

• total open bills (unpaid or partially paid).

It helps track pending supplier payments. 

Cash Flow Section 

This shows the total amount paid to the supplier in the last 30 days. It helps review recent payment activities and manage cash planning. 

Download Statement 

By clicking the “Download Statement” button, you can generate a detailed supplier account statement, including open bills, partial payments, unallocated payments, and the final outstanding balance for sharing or record purposes. 

Users can download the supplier running balance in any file format, such as PDF or CSV, as per their needs.

• If you download the PDF, it will give you data in the document.

• If you download the CSV file, it will give you data in Excel form. 

Let me say, if you download the data in PDF, it will look like the one given below.

This statement provides a complete financial overview of the supplier’s account as of the print date. It shows all outstanding bills, unallocated payments, and the final payable balance. The report is used for reconciliation, payment planning, and official record sharing. 

Above, you can see all your company details and supplier basic details or contact information on the top.

Users can directly access and review the status of the unallocated bills, open invoices, partially paid bills, and purchase orders from the document.

At the bottom right, the system calculates the final payable amount:

• Opening Balance—Previous outstanding amount carried forward (AED 0.00). 

• Total Open Bill Amount  

• Total Partial Paid Amount  

• Total Amount (Payable)  

This gives the final amount the company must pay to the supplier.