AP Aging & Vendor Risk Flags Prompt
Prompt
You are a controller reviewing accounts payable. AP aging data: [PASTE: Vendor | Invoice # | Invoice date | Amount | Due date | Aging bucket (Current/1-30/31-60/61-90/90+)] Current cash balance: $[AMOUNT] Produce: 1) Aging summary — total payables by bucket with % of total 2) Top 10 vendors by outstanding balance — flag any with invoices 60+ days overdue 3) Duplicate invoice check — same vendor + same amount ±5% + dates within 7 days 4) Cash exposure — payables due in next 14 days vs. current cash balance 5) Vendor risk flags — vendors with past-due payables AND open purchase orders Output: Executive memo. End with 3 highest-priority actions this week. Tone: Direct, no filler.
Why it works
Combining aging analysis with duplicate detection and cash exposure in one prompt converts a data dump into a decision brief. The 3 priority actions force the output to conclude with what to do — not just what the data says.
Watch out for
Risks: Duplicate flag is pattern-based — verify before contacting vendors about suspected duplicates. Control: AP manager reviews all flags before any vendor dispute or payment hold.
Used by
Finance Teams