Works with the AI tools you already use

    CClaude CodeCCursorCCodex CLIGGitHub CopilotGGemini CLI+17 more

    Collection Gap — DSO, CEI & AR Metrics Workbook from Any Invoice Export

    1

    The problem with your DSO report There's a number sitting in your AR report right now that looks fine on the surface.

    $29

    30-day refund guarantee

    Secure checkout via Stripe

    0 installsSecurity scanned

    See it in action

    You say

    I have my weekly AR export from QuickBooks ready. Run the collection gap report.

    Your agent does

    COLLECTION GAP REPORT — Week of June 6, 2026 DSO: 54.2 days BPDSO: 31.0 days Collection Gap: 23.2 days ⚠ Gap widened +2.1 days vs last week CEI: 87.4% ACT: 22.6 days Cash Collected: $184,320 % AR > 90 days: 11.3% CFO INSIGHT: DSO improved 1.4 days this week, but the Collection Gap widened — the improvement came from faster invoicing, not collections performance. Three customers account for 68% of the overdue balance. TOP PRIORITY FOLLOW-UP: 1. Meridian Surgical (Score: 94) — $42,100 | 78 days past due 2. Clearview Health (Score: 81) — $28,500 | 61 days past due 3. Atlas Medical Group (Score: 74) — $19,200 | 55 days past due Full six-tab Excel workbook saved to: collection_gap_2026-06-06.xlsx

    What you get

    Weekly CFO reporting — "I need a clean DSO and collection summary every Monday and my CFO wants week-over-week trends, not just a snapshot."Identifying which customers are actually dragging collections — "Everyone's DSO looks fine until you break it out by customer. I need to know who's 60+ days consistently."Distinguishing billing timing from collections performance — "Our DSO dropped last quarter but I can't tell if collections actually improved or if we just invoiced faster. Collection Gap answers that."AR managers building a weekly work queue — "I need a prioritized list of who to call first — not just sorted by dollar amount, but scored for risk and days overdue."Small finance teams without a data analyst — "I need real AR metrics but I don't have a BI team. I export from QuickBooks and I need something that just works."Month-end close preparation — "Before I close the month I want to confirm what's outstanding, what came in, and whether CEI improved."

    About this skill

    How to install

    Drop the file into your AI Agent. Works with Claude, Cursor, ChatGPT, and 20+ more.

    Reviews

    No reviews yet

    Be one of the first to try it. Every listed skill passes our trust checks below.

    Security scanned

    Passed our 8-point scan before listing

    Fresh listing

    Recently published to Agensi

    30-day refund

    Not a fit? Get your money back

    Trust & safety

    Security scanned

    Verified clean 2 months ago

    Listed2 months ago

    Frequently Asked Questions