01
Supplier Statement
Tracks supplier movements across a selected period with opening position, debit and credit activity, closing balance, transaction details, activity trends and payment-method distribution.
POWER BI CASE STUDY
Supplier Analytics Suite
An integrated supplier accounts analytics solution for monitoring balances and transactions, analyzing opening and closing positions, tracking payment aging, and comparing supplier exposure across companies to support payment planning and cash management.Power BIDAXPower QueryFinancial AnalysisHTML Visuals
01 — Analysis journey
02
Supplier Trial Balance
Reconciles opening, period and closing debit or credit balances. The supplier profile tooltip reveals the latest payment, latest purchase and days since the last payment without leaving the visual.
INTERACTION
Interactive supplier profile
Hovering over a supplier bar reveals the most recent payment and purchase, their dates, and the number of days since payment.
03
Supplier Credit Aging
Ages outstanding balances from each supplier’s latest payment. Suppliers below SAR 1 are excluded from the decision chart to reduce noise, while a dedicated card keeps the excluded count transparent.
04
Company Comparison
Focuses only on external outstanding balances. A funnel ranks company exposure, while the detailed matrix reconciles every aging bucket to the header total of SAR 53,077,632.41 across 730 external suppliers.
02 — Interactive report