- Home
- Skills
- Finance & Accounting
- days payable outstanding analyzer
Works with the AI Agents you already use
days payable outstanding analyzer
Inconsistent payables tracking leads to poor cash flow visibility and missed working capital opportunities.
$2.99
days payable outstanding analyzer
Example session with this skill installed
Calculate DPO for 2024-Q3 and 2024-Q4 using COGS. Q3: Closing Payables 450k, COGS 2.1M. Q4: Closing Payables 510k, COGS 2.4M. Show trends and working capital effect. Prepared by Finance Team A.
- Read your context and instructions
- Compiled the days payable outstanding
I have processed the payables data for 2024-Q3 and 2024-Q4. The calculation script has completed the DPO and working capital trend analysis.
Days Payable Outstanding Analysis — Global Corp, 2025-01-20
1. Scope, sources and assumptions
- Sources: E1 (User supplied Q3/Q4 financials)
- Periods: 2024-Q3, 2024-Q4
- Currency: USD (Unit Scale: 1)
- Basis: Closing Payables / COGS
- Authorized Entities: Global Corp HQ
2. DPO and working capital
| Period | Days | Payables basis | Denominator | DPO | Value of one DPO day | DIO | DSO | Cash conversion cycle |
|---|---|---|---|---|---|---|---|---|
| 2024-Q3 | 92 | closing | cogs | 19.71 | 22,826.09 | n/a | n/a | n/a |
| 2024-Q4 | 92 | closing | cogs | 19.55 | 26,086.96 | n/a | n/a | n/a |
3. Trends
| From | To | From DPO | To DPO | Change (days) | Relative change | Direction | Working-capital effect | Comparable |
|---|---|---|---|---|---|---|---|---|
| 2024-Q3 | 2024-Q4 | 19.71 | 19.55 | -0.16 | -0.81% | Decrease | 4,173.91 (Cash Out) | Yes |
4. Supplier risk
No supplier-level analysis was made.
5. Draft actions and approval queue
| Action | Type | Supplier | Status | Requires human approval |
|---|---|---|---|---|
| Review DPO drop | Trend Review | N/A | PENDING | Yes |
Controls not performed by design: independent_bank_verification, ledger_reconciliation.
6. Warnings and data gaps
Information gap — organizational validation required: Opening balances not provided; DIO/DSO/CCC could not be calculated.
7. Interpretation and items for human review
- DPO decreased by 0.16 days between Q3 and Q4 (computed result).
- The decrease in DPO resulted in a working capital outflow of 4,173.91 USD (computed result).
- Payables balance increased by 60,000 USD while COGS increased by 300,000 USD (computed result).
This analysis supports, and does not replace, professional judgment and management's decision.
Next steps
- Provide inventory and receivables data to unlock Cash Conversion Cycle analysis.
- Submit a supplier-level export to identify specific payment-term breaches.
- Assign a separate 'Reviewed By' user to satisfy segregation-of-duties controls.
Connects securely to your tools. The creator never sees your data.
About this skill
Inconsistent payables tracking leads to poor cash flow visibility and missed working capital opportunities. This skill automates the calculation of Days Payable Outstanding (DPO), DIO, DSO, and the Cash Conversion Cycle (CCC) using deterministic scripts for absolute accuracy.
What it does
- Multi-Basis Calculation computes DPO using average or closing payables with COGS or credit-purchase denominators.
- Cycle Analysis determines DIO, DSO, and the overall Cash Conversion Cycle across multiple periods.
- Trend Tracking calculates the working capital effect of DPO shifts and provides period-over-period comparisons.
- Risk Tiering flags suppliers paid beyond contractual terms, high overdue shares, and payables concentration.
- Control Checks identifies segregation-of-duties gaps and flags pending bank detail changes for human review.
How it works
- Data Intake reads period cost data, payables balances, and supplier lists to generate a validated JSON request.
- Script Execution runs a dedicated Python arithmetic engine to process financials without rounding errors.
- Status Validation checks the calculation envelope for warnings, data gaps, or items requiring human oversight.
- Reporting generates a structured report covering working capital, supplier risk, and draft approval queues.
Frameworks & tools
Uses a deterministic Python execution environment for arithmetic precision. Validates data against strict JSON schemas and applies segregation-of-duties logic for financial controls.
Why this beats prompting it yourself
LLMs frequently hallucinate financial arithmetic and struggle with consistent DPO denominators across periods. This tool offloads all math to a script, ensuring every decimal is traceable and every risk flag is based on defined thresholds rather than vibes.
Use cases
- Analyzing the cash flow impact of stretching or accelerating supplier payments.
- Auditing supplier payment timing against contractual terms to find friction points.
- Benchmarking the Cash Conversion Cycle across multiple fiscal quarters.
- Identifying payables concentration and supplier dependency risks.
Known limitations
Does not forecast future cash outflows or process actual payments. Actions are limited to drafts and require human approval.
Does not perform cash forecasting, payment runs, or ledger postings. Requires reporting_currency and specific period cost data. Suppliers require authorized access scope.
How to use
- 1
Connect your agent to the Agensi MCP
Copy the prompt and paste it into Claude, ChatGPT, Cursor or any agent that supports MCP. It sets up the connection for you. Manual setup
- 2
Sign in to Agensi
Your agent shows a sign-in link. Sign in and click Allow.
- 3
Ask for what you need
Your agent loads this skill and uses it on your task. It always asks before any payment.
Reviews
No reviews yet
Be one of the first to try it. Every listed skill goes through the trust checks below.
Security scanned
Checked by our 8-point scan before listing
Fresh listing
Recently published to Agensi
Money-back guarantee
Doesn't do what its page promises? You get your money back.
Trust & safety
Security scan
Security scan passed 2 days ago