Here is the Q1 2025 accounts payable breakdown using the latest AP snapshot on or before 2025-03-31 and including payables with transaction_date <= 2025-03-31.

Summary - Total open AP: AED 4,356,765.77 - Open payable documents: 252 - The largest concentrations are in Not Due / Open / Net 90 and Not Due / Open / Net 45, which together make up a large share of the Q1 2025 payable balance. - A meaningful portion also sits in 31-60 Days / Partially Paid / Net 90, indicating some overdue balances that are only partially settled.

Top observations - Not Due / Open / Net 90: AED 775,442.34 (17.80% of total) - Not Due / Open / Net 45: AED 587,562.83 (13.49%) - 31-60 Days / Partially Paid / Net 90: AED 553,968.19 (12.72%) - Not Due / Partially Paid / Net 45: AED 276,404.68 (6.34%) - 31-60 Days / Partially Paid / Net 45: AED 274,036.35 (6.29%)

Overall, the AP portfolio appears to be concentrated in a mix of not-yet-due obligations and partially paid overdue balances, especially under Net 45 and Net 90 terms.

I've also prepared a bar visualization of this data.

DPO for Q1 2025 is 56.67 days.

This was calculated as:

DPO = (Open AP at 2025-03-31 / Q1 2025 purchases) × 90 days

Using your company data: - Open AP as of 2025-03-31: AED 4,356,765.77 - Q1 2025 purchases: AED 6,919,014.41 - DPO: 56.67 days

Interpretation: on average, the business is taking about 57 days to pay suppliers based on the Q1 2025 payable balance and purchase run rate.

Here are the suppliers with the highest open accounts payable balances, based on the latest available AP snapshot. This shows who we currently owe the most money to.

Top 3 suppliers account for the largest current payable exposure: - Fujairah Rock & Aggregate: AED 272,900.06 - Atlas Copco Middle East: AED 202,888.27 - Gulf Business Machines (GBM): AED 192,893.29

If you want, I can also break this down by aging bucket, overdue only, or show the full supplier ranking.

I've also prepared a bar visualization of this data.

Based on the latest accounts payable snapshot, the company does not appear overly dependent on just one or two suppliers from an open-payables concentration perspective.

Key takeaways: - Total open AP: AED 5,056,602.38 - Largest single supplier exposure: Fujairah Rock & Aggregate at AED 272,900.06, which is only 5.40% of total open AP - Top 3 suppliers combined: 13.22% of total open AP - Top 5 suppliers combined: 20.82% of total open AP - Top 10 suppliers combined: 37.13% of total open AP

Interpretation: - If dependency were high, I would expect one supplier to represent a much larger share, or the top 3–5 suppliers to dominate the payable base. - Here, the exposure looks fairly distributed across multiple suppliers. - That said, the top 10 suppliers still account for over one-third of open AP, so there is some concentration worth monitoring, but not an obvious red flag based on this view alone.

Important caveat: - This analysis measures dependency using current unpaid supplier balances (open AP). - That is useful for exposure concentration, but it is not the same as operational dependency or spend dependency. - A fuller supplier dependency assessment would also look at: - procurement spend concentration from purchase_registers - single-source / critical suppliers - supplier risk categories - inventory items tied to each supplier

So the short answer is: No, not based on current AP exposure alone — supplier concentration looks moderate rather than excessive.

I've also prepared a bar visualization of this data.

Payables aging analysis for Q1 2025

Using the latest accounts payable snapshot on or before 2025-03-31, and including payables with transaction_date <= 2025-03-31, here is the aging profile based on days past due relative to the snapshot date.

Summary - Total open AP: AED 4,356,765.77 - Open payable documents: 252 - Current / not yet due: AED 2,189,588.43 (50.26%) - Overdue AP: AED 2,167,177.34 (49.74%) - The largest overdue bucket is 31–60 Days, at AED 1,153,014.33. - There were no balances in 91–180 Days or Over 180 Days in this snapshot.

Interpretation - About half of the AP balance was still not due, which suggests a fairly balanced short-term payable position. - Nearly the other half was overdue, concentrated mostly in the 0–60 day range. - The absence of balances older than 90 days indicates that while there is short-term payment pressure, there does not appear to be a significant long-aged payable backlog in this Q1 2025 snapshot.

I've also prepared a pie visualization of this data.