Customer Payment Pattern Analysis Prompt
Prompt
You are a credit analyst reviewing customer payment behavior. Payment history: [PASTE: Customer | Invoice date | Invoice amount | Due date | Payment date | Days early/late | Discount taken?] For each customer, analyze: 1) Average days to pay vs. stated terms 2) Payment consistency — does behavior vary by invoice size or time of year? 3) Discount behavior — taking discounts they're not entitled to? 4) Deduction behavior — paying short without explanation? 5) Trend — improving or deteriorating over the last 6 months? Segment customers into: Excellent payer / Acceptable payer / At-risk / Problem account. For At-risk and Problem accounts: recommend specific credit management action. Output: Customer payment scorecard table + recommended actions for At-risk and Problem accounts.
Why it works
Detecting unauthorized discount-taking and unexplained deductions in the same analysis as payment timing surfaces two different revenue leakage risks that are often tracked separately.
Watch out for
Risks: A customer who pays late consistently but always pays may be lower risk than the segment label suggests. Control: Credit manager applies relationship context before any credit limit changes.
Used by
Finance Teams