Works with the AI Agents you already use
ap aging and overdue balance analyst
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
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
| Vendor | Total open | 0-30 days | 31-60 days | 61-90 days | 91+ days | Overdue |
|---|---|---|---|---|---|---|
| Acme Corp | 12,500.00 | 5,000.00 | 2,500.00 | 5,000.00 | 0.00 | 7,500.00 |
| Global Tech | 4,200.00 | 4,200.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Zenith Ltd | 8,900.00 | 0.00 | 0.00 | 2,900.00 | 6,000.00 | 8,900.00 |
| TOTAL | 25,600.00 | 9,200.00 | 2,500.00 | 7,900.00 | 6,000.00 | 16,400.00 |
3. Disputed items
| Vendor | Disputed | Overdue disputed | Overdue undisputed | Stale disputes |
|---|---|---|---|---|
| Acme Corp | 5,000.00 | 5,000.00 | 2,500.00 | 1 |
| Zenith Ltd | 0.00 | 0.00 | 8,900.00 | 0 |
4. Overdue and materiality flags
| Vendor | Overdue | Overdue share | Overdue material | Disputed material | In oldest bucket |
|---|---|---|---|---|---|
| Acme Corp | 7,500.00 | 0.6000 | True | True | False |
| Zenith Ltd | 8,900.00 | 1.0000 | True | False | True |
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_id | Vendor | Action | Amount | Status |
|---|---|---|---|---|
| D-001 | Acme Corp | Resolve stale dispute | 5,000.00 | draft, requires human approval |
| D-002 | Zenith Ltd | Prioritize payment | 8,900.00 | draft, 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
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
- Supply data by providing open invoice exports and defining the analysis date, currency, and authorized entity scope.
- Execute script as the agent builds a structured request and runs a deterministic Python script to ensure arithmetic accuracy.
- Review results through the generated report which categorizes vendors by bucket, overdue share, and materiality status.
- 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
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 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