Works with the AI Agents you already use
ap cycle time and bottleneck analyzer
Your accounts payable process is a black box until you measure the gaps between receipt and settlement.
$2.99
ap cycle time and bottleneck analyzer
Example session with this skill installed
Analyze the attached AP log for Entity_A. I am authorized by the Finance Director. Use 3 days for validation and 5 days for approval SLAs. Identify why our P90 is so high.
- Read your context and instructions
- Compiled the ap cycle time
The AP event log for Entity_A (E1) has been processed. The analysis covers 152 invoices processed between 2023-10-01 and 2023-12-31.
AP Cycle Time and Bottleneck Analysis — Entity_A, 2024-01-20
1. Scope, sources and assumptions
Analysis based on source E1. Scope limited to authorized_entities: ["Entity_A"] granted by Finance Director. Total invoices: 152. Analysed: 148. Excluded: 4 (missing receipt_at). Time is calculated as calendar time.
2. Stage cycle times
| Stage | n | Mean | Median | P90 | Max | Share of measured time | SLA | Breaches |
|---|---|---|---|---|---|---|---|---|
| Receipt to Validation | 148 | 2.4 | 1.0 | 4.5 | 12.0 | 18% | 3.0 | 22 |
| Validation to Approval | 130 | 6.8 | 4.0 | 15.2 | 28.0 | 52% | 5.0 | 41 |
| Approval to Posting | 125 | 1.1 | 0.5 | 2.0 | 5.0 | 8% | n/a | 0 |
| Posting to Settlement | 110 | 2.9 | 2.0 | 5.0 | 10.0 | 22% | n/a | 0 |
| End-to-End | 110 | 13.2 | 7.5 | 26.7 | 55.0 | 100% | n/a | 63 |
3. Bottleneck
| Rank | Stage | Impact |
|---|---|---|
| 1 | Validation to Approval | Primary bottleneck (52% of duration) |
| 2 | Posting to Settlement | Secondary delay (External/Terms) |
| 3 | Receipt to Validation | Minor delay |
4. Settlement timeliness
Late rate: 14.5%. Mean days late: 3.2. Open past due: 8 items.
5. Open invoices
| Invoice ID | Pending Stage | Days Waiting | SLA | Over SLA |
|---|---|---|---|---|
| INV-9980 | Approval | 14 | 5 | Yes |
| INV-9985 | Approval | 9 | 5 | Yes |
6. Control exceptions
- SoD Conflict: Invoice INV-8821 (Validated and Approved by ACTOR_042).
- Skipped Stage: Invoice INV-8840 (Posted without recorded Approval).
- Information gap — organizational validation required: Actor ID missing for INV-8855 settlement.
7. Draft actions for human approval
- Investigate approval backlog for Business Unit: North_Logistics. (requires_human_approval: true, executed: false)
- Review SoD conflict for ACTOR_042 on INV-8821. (requires_human_approval: true, executed: false)
Management decision required before any escalation or payment.
8. Warnings and information gaps
W04: Minimum stage sample not met for 'Posting to Settlement' in Dept_Marketing.W09: 22 invoices missingdue_date; late rate may be understated.
9. Interpretation and items for human review
- The Validation to Approval stage is the primary driver of cycle time, exceeding SLA in 31% of cases.
- P90 variance (26.7 days) suggests significant outliers in the approval chain.
- Analytical estimate — validation required: Reducing approval median to 4 days would cut total cycle time by 28%.
This analysis supports, and does not replace, professional judgment and management's decision.
Next steps
- Review the list of 8 open invoices currently past due.
- Confirm if ACTOR_042 has emergency override permissions for SoD conflicts.
- Validate missing due dates for the 22 flagged invoices to correct the late settlement rate.
Connects securely to your tools. The creator never sees your data.
About this skill
Your accounts payable process is a black box until you measure the gaps between receipt and settlement. This skill stops the guesswork by analyzing event logs to identify exactly where invoices stall, from validation delays to approval bottlenecks.
What it does
- Stage timing analysis calculates mean, median, and P90 duration for every step from receipt to settlement.
- Bottleneck ranking identifies and ranks the stages causing the most significant internal processing delays.
- SLA monitoring flags specific invoices and stages that breach defined service level agreements.
- Open item aging tracks currently active invoices, their pending stage, and days elapsed.
- Control auditing identifies segregation-of-duties (SoD) conflicts and skipped process stages for human review.
How it works
- Supply an AP event log containing timestamps for receipt, validation, approval, posting, and settlement.
- Define the analysis scope, including authorized entities and optional SLA thresholds for each stage.
- The skill generates a
request.jsonand executes a deterministic Python script to process the calculations. - Review the structured report detailing cycle times, bottlenecks, late rates, and control exceptions.
Frameworks & tools
This skill uses a deterministic Python processing engine to ensure calculation integrity. It relies on standard JSON schemas for data ingestion and provides outputs in GitHub-flavored Markdown.
Why this beats prompting it yourself
Generic prompts often hallucinate dates or fail to handle time-zone-agnostic calendar days correctly. This skill uses a hard-coded script to ensure every mean, median, and P90 value is mathematically accurate without rounding errors or inferred data.
Use cases
- Identify which business units or vendors experience the longest approval delays.
- Audit segregation-of-duties by flagging invoices handled by the same actor across stages.
- Quantify the impact of late settlements and track the late-payment rate.
- Generate a prioritized list of "stuck" invoices for immediate follow-up.
Known limitations
Does not support three-way matching against POs or receipts. Calculations are restricted to calendar time and do not account for business hours or holidays. Requires a minimum group size for statistical reporting to ensure privacy.
Read-only. No PO matching or duplicate detection. Calendar time only (no holiday logic). Requires minimum sample sizes for group stats. Actor IDs must be provided; does not deanonymize.
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 3 days ago