✏️Prompts

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