Works with the AI Agents you already use

    Claude CodeClaude CodeCursorCursorCodex CLICodex CLIDeepSeekDeepSeekMuseMuse+22 more

    ap aging and overdue balance analyst

    1

    Vendor-level AP aging from your open items: days-past-due buckets, disputed amounts, overdue totals, stale disputes and materiality flags, with exact traces. Read-only; follow-ups are drafts needing human approval.

    $2.99

    Secure checkout via Stripe

    Money-back guarantee

    Converts to your local currency at checkout

    Security scanned
    ap aging and overdue balance analyst

    ap aging and overdue balance analyst

    Example session with this skill installed

    Please run an AP aging report as of 2023-12-31 for Entity_A. Use the attached CSV of open items. Materiality threshold is 5000. Authorized by Sarah Miller.

    • Read your context and instructions
    • Compiled the ap aging
    • Generated the data export

    I have processed the open items for Entity_A as of December 31, 2023. The analysis was performed using the deterministic script to ensure arithmetic accuracy across all vendor buckets.

    AP Aging and Overdue Balance — Entity_A, 2023-12-31

    1. Scope, sources and assumptions

    • Sources: E1 (Open_Items_Dec_2023.csv)
    • Authorized Entities: Entity_A (Granted by Sarah Miller)
    • Date/Currency: 2023-12-31 / USD
    • Buckets: 0-30, 31-60, 61-90, 91+ days
    • Assumptions: Materiality threshold $5,000 (user_supplied)

    2. Aging by vendor

    VendorTotal open0-30 days31-60 days61-90 days91+ daysOverdue
    Acme Corp12,500.005,000.002,500.005,000.000.007,500.00
    Global Tech4,200.004,200.000.000.000.000.00
    Zenith Ltd8,900.000.000.002,900.006,000.008,900.00
    TOTAL25,600.009,200.002,500.007,900.006,000.0016,400.00

    3. Disputed items

    VendorDisputedOverdue disputedOverdue undisputedStale disputes
    Acme Corp5,000.005,000.002,500.001
    Zenith Ltd0.000.008,900.000

    4. Overdue and materiality flags

    VendorOverdueOverdue shareOverdue materialDisputed materialIn oldest bucket
    Acme Corp7,500.000.6000TrueTrueFalse
    Zenith Ltd8,900.001.0000TrueFalseTrue

    5. Exceptions and exclusions

    • Exceptions: Vendor Zenith Ltd has one invoice with a due date prior to the invoice date (Ref: INV-992).
    • Exclusions: 2 items excluded (1 paid, 1 zero balance).

    6. Proposed actions (drafts requiring human approval)

    draft_idVendorActionAmountStatus
    D-001Acme CorpResolve stale dispute5,000.00draft, requires human approval
    D-002Zenith LtdPrioritize payment8,900.00draft, requires human approval

    7. Warnings, limitations and items for human review

    • W-004: Potential duplicate invoice number detected for Acme Corp.
    • Controls: Segregation of duties maintained (System as Preparer, Sarah Miller as Reviewer).
    • Note: This analysis supports, and does not replace, professional judgment and management's decision.

    Next steps

    • Review the stale dispute for Acme Corp to determine if the balance is still valid.
    • Investigate the due-date exception for Zenith Ltd (INV-992) before approving the payment draft.
    • Confirm the materiality threshold of $5,000 is aligned with current Q4 audit requirements.

    Open_Items_Dec_2023.csv

    CSV · data export

    Generated

    Example file from a real run - the skill writes it into your workspace.

    Connects securely to your tools. The creator never sees your data.

    About this skill

    Manual accounts payable aging is prone to calculation errors and missed materiality. This skill transforms raw open-item exports into deterministic, vendor-level aging reports with exact decimal precision.

    What it does

    • Vendor-level aging generates aging tables sorted into days-past-due buckets as of any specific date.
    • Dispute tracking identifies disputed invoice exposure and flags stale disputes based on your aging parameters.
    • Materiality assessment applies absolute or relative thresholds to highlight overdue balances that require immediate attention.
    • Exception reporting flags data inconsistencies like identical invoice numbers, dates where due-date precedes invoice-date, or pending bank changes.
    • Draft follow-ups prepares suggested actions for vendors which remain drafts until a human reviewer approves them.

    How it works

    1. Supply data by providing open invoice exports and defining the analysis date, currency, and authorized entity scope.
    2. Execute script as the agent builds a structured request and runs a deterministic Python script to ensure arithmetic accuracy.
    3. Review results through the generated report which categorizes vendors by bucket, overdue share, and materiality status.
    4. Approve actions by reviewing the proposed draft actions for vendor follow-ups or dispute resolutions.

    Frameworks & tools

    This skill utilizes a self-contained Python 3 script for decimal-exact arithmetic. It follows a strict JSON-schema for inputs and outputs to maintain data integrity across different accounting exports.

    Why this beats prompting it yourself

    Generic prompts often struggle with multi-bucket arithmetic and consistent materiality logic. This skill uses a deterministic script to prevent "hallucinated" totals and enforces segregation of duties by flagging when preparers and reviewers are identical.

    Use cases

    • Generating "balance agee fournisseurs" or standard AP aging reports for month-end closing.
    • Identifying high-risk vendors whose overdue balances exceed specific materiality thresholds.
    • Auditing disputed invoices to find stale items that have been open beyond a set grace period.
    • Preparing a prioritized list of vendor follow-up drafts for a finance manager to approve.

    Known limitations

    Does not perform FX conversions, bank detail verification, or ledger reconciliations. It is read-only and cannot post to an ERP or release payments.

    Find more skills like this on the Claude Skills Marketplace, the Codex Skills Marketplace and the Gemini Skills Marketplace, or browse All Claude Skills.

    Read-only. Cannot release payments or verify bank details. Does not handle FX conversion or ledger posting. Requires human approval for all drafted actions.

    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 buying a skill.

    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 3 days ago

    Permissions

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

    What's inside

    Frequently Asked Questions

    The skill uses a self-contained Python 3 script for all calculations, ensuring decimal-exact arithmetic. This eliminates the 'hallucination' risks often found in LLM-based prompting, where agents may struggle with multi-bucket aging totals.

    This skill is compatible with any AI agent framework that supports Python code execution and JSON-schema inputs. It is designed to be platform-agnostic, provided your agent can process raw data exports and run script-based tools.

    No, this skill is strictly read-only for security and audit integrity. It analyzes your data and generates reports or draft follow-ups, but it cannot post entries to your ERP or initiate bank payments.

    You receive the core Python script, the JSON-schema for data integration, and a guide on mapping your open-item exports to the analysis tool. This provides everything needed to deploy the logic within your existing AI agent workflow.

    The skill flags 'Exception Reporting' items, such as duplicate invoice numbers or logical errors like due dates preceding invoice dates. This allows your team to fix data integrity issues in the source system before they impact financial reporting.