Supplier Balances Report

Report Overview

The supplier balances report is a financial report that shows the account position of each supplier over a specific period. It includes the opening balance, total purchases, returns, payments, and adjustments, leading to the closing balance.

Steps to View the Report

1. From the main menu click on “Reports“.
2. Click on “Purchases Reports“.
3. From the purchases reports page, select “Suppliers Balance“.
4. Before displaying the report, you can apply several filters:
   • Supplier: Select one or more suppliers to display their balances only. You can search by name.
     • If no supplier is selected, the report will include all suppliers.
   • Date From: Select the start date of the period for which you want to display balances.
   • Date To: Select the end date of the period for which you want to display balances.
   • Hide Zero Balance: Enable this option to exclude suppliers with zero balances from the report results.
     • If not enabled, the report will include all suppliers, including those with zero balances.
   • Branch: Select one or more branches to display balances for suppliers associated with those branches only.
     • If no branch is selected, the report will include all branches
   • Group By: Choose how the report results should be grouped:
     • Supplier: Display balances grouped by supplier name.
     • Branch: Display balances grouped by branch.
5. After adjusting the filters, click “View Report” to update the results, or click “Clear Filters” to return to the default settings.
6. You can switch between “Summary” view to display only the total balance for each supplier, or “Details” view to display detailed transaction and balances for each supplier.
7. You can print the report using “Print” or export it from “Export” to:
   • CSV
   • Excel
   • PDF

Report Columns

The table displays a financial summary for each supplier during the selected period. The columns are organized as follows:

• Code: The unique identifier of the supplier in the system, with a direct link to view their full profile.
• Account Number: The accounting account number associated with the supplier in the general ledger.
• Name: The supplier’s trade name as registered in the system, with a direct link to the supplier’s page.
• Branch: The branch associated with the supplier.
• Opening Balance: The supplier’s carried-forward balance before the start of the selected period. A negative value indicates a credit balance in favor of the supplier.
• Total Purchases: The total value of purchase invoices recorded for the supplier during the period.
• Total Returns: The total value of returns recorded against the supplier’s invoices during the period.
• Net Purchases: Total purchases after deducting total returns.
• Total Payments: The total amount paid to the supplier during the period.
• Adjustments: The value of any adjustments or journal entries applied to the supplier’s account during the period.
• Balance: The closing balance of the supplier at the end of the period, calculated as: Opening Balance + Net Purchases – Payments – Adjustments. A negative value indicates a credit balance in favor of the supplier.

At the bottom of the table, a totals row is displayed, summarizing all financial columns for all suppliers across the entire selected period.