Works with the AI Agents you already use

    Claude CodeClaude CodeCursorCursorCodex CLICodex CLIMuseMuseDotsDots+21 more

    days payable outstanding analyzer

    1

    Inconsistent payables tracking leads to poor cash flow visibility and missed working capital opportunities.

    $2.99

    Secure checkout via Stripe

    Money-back guarantee

    Converts to your local currency at checkout

    Security scanned
    days payable outstanding analyzer

    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

    PeriodDaysPayables basisDenominatorDPOValue of one DPO dayDIODSOCash conversion cycle
    2024-Q392closingcogs19.7122,826.09n/an/an/a
    2024-Q492closingcogs19.5526,086.96n/an/an/a

    3. Trends

    FromToFrom DPOTo DPOChange (days)Relative changeDirectionWorking-capital effectComparable
    2024-Q32024-Q419.7119.55-0.16-0.81%Decrease4,173.91 (Cash Out)Yes

    4. Supplier risk

    No supplier-level analysis was made.

    5. Draft actions and approval queue

    ActionTypeSupplierStatusRequires human approval
    Review DPO dropTrend ReviewN/APENDINGYes

    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

    1. Provide inventory and receivables data to unlock Cash Conversion Cycle analysis.
    2. Submit a supplier-level export to identify specific payment-term breaches.
    3. 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

    1. Data Intake reads period cost data, payables balances, and supplier lists to generate a validated JSON request.
    2. Script Execution runs a dedicated Python arithmetic engine to process financials without rounding errors.
    3. Status Validation checks the calculation envelope for warnings, data gaps, or items requiring human oversight.
    4. 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. 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. 2

      Sign in to Agensi

      Your agent shows a sign-in link. Sign in and click Allow.

    3. 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

    Permissions

    Terminal / Shell
    Read Files
    Write Files
    Environment Variables
    Listed2 days ago

    What's inside

    Frequently Asked Questions

    This skill eliminates 'hallucinated' math by offloading all DPO, DSO, and CCC calculations to a deterministic Python engine, ensuring your working capital metrics are audit-ready and accurate to every decimal point.

    The skill requires standard financial data including cost of goods sold (COGS), payables balances, and supplier lists; it works best with agents capable of processing JSON data or structured spreadsheet exports.

    Beyond simple math, the skill identifies high-risk supplier concentration, flags payments that deviate from contractual terms, and highlights potential segregation-of-duties gaps for human review.

    You receive the complete analyzer skill package, including the deterministic execution scripts, data validation schemas, and pre-configured report templates for working capital analysis.

    No, this skill is designed for analysis and reporting only; it generates payment drafts and risk flags that must be reviewed and executed by a human user or a separate treasury system.

    New in Finance & Accounting