Vendor Payment Optimizer

Turns your AP aging report into a cash flow weapon. This skill analyzes open vendor invoices, calculates the true annualized ROI of early payment discounts, scores each invoice by priority, and generates an optimized payment queue — so you capture discounts worth capturing and hold cash when you shouldn't pay early.

---

When to Use

Trigger phrases:

• - "Which invoices should we pay early this week?"
• "We have a 2/10 net 30 — is it worth taking the discount?"
• "Optimize our AP payment schedule"
• "What's our cash position if we pay all invoices due this month?"
• "Flag any invoices about to go late"
• "Build a payment priority list from our AP aging"

NOT for:

• - Actually sending payments or syncing to bank — use QBO or banking tools
• Vendor contract renegotiation — use INLINECODE0
• Payroll — use INLINECODE1
• AR (receivables) — use INLINECODE2
• Real-time QBO AP sync — use qbo-automation to pull data first, then feed here

---

Core Concepts

Early Payment Discount Math

The most common discount term is 2/10 net 30: pay within 10 days, get 2% off; otherwise pay in 30 days.

Annualized ROI of taking the discount:

CODEBLOCK0

Decision rule:

• - If annualized ROI > your cost of capital (or opportunity cost of cash) → take the discount
• If annualized ROI < cost of capital → hold cash, pay at net due date
• Typical cost of capital for small business: 8–15%; most 2/10 net 30 discounts are worth taking

Payment Priority Scoring

Score each invoice (0–100) using:

CODEBLOCK1

Factor	High Score	Low Score
Discount ROI	>30% annualized	No discount available
Days to late

≤3 days | >15 days |
| Vendor criticality | Key supplier, sole source | Easily replaceable |
| Invoice size | >$10k (high absolute $ saved) | <$500 |

---

Workflow

Step 1: AP Aging Input

Accept AP data in any of these formats:

• - Pasted table from QBO AP Aging Summary report
• CSV export from accounting software
• Manual entry: vendor, invoice #, amount, due date, discount terms

Minimum fields needed:
CODEBLOCK2

Example input:

Vendor          | Inv #   | Amount    | Due Date   | Terms     | Discount
Acme Supplies   | INV-101 | $5,200    | 2026-03-22 | Net 30    | 2/10
Tech Services   | INV-205 | $12,000   | 2026-03-25 | Net 45    | None
Office Depot    | INV-089 | $840      | 2026-03-19 | Net 30    | 1/10
Contractor LLC  | INV-312 | $18,500   | 2026-04-01 | Net 60    | None
Cloud Hosting   | INV-410 | $3,200    | 2026-03-20 | Net 30    | 2/10

---

Step 2: Discount Opportunity Analysis

For each invoice with discount terms, calculate:

CODEBLOCK4

---

Step 3: Payment Priority Queue

Output a ranked payment list:

CODEBLOCK5

---

Step 4: Cash Flow Impact Summary

CODEBLOCK6

---

Step 5: Late Payment Risk Flags

CODEBLOCK7

---

Advanced Features

Stretching Payment Terms (Ethically)

When cash is tight, identify which vendors are safe to pay at the tail end of net terms:

CODEBLOCK8

Dynamic Discounting Offers

When you have excess cash and want to negotiate discounts with vendors who don't offer them:

CODEBLOCK9

Vendor Spend Concentration Report

Identify AP risk concentration:

CODEBLOCK10

---

Output Formats

Weekly AP Decision Brief (default)

Short, actionable: what to pay, by when, and why. Fits in one screen.

Full AP Analysis Report

Comprehensive with all scenarios, discount math, vendor concentrations. For CFO/board review.

CSV Payment Queue

For importing into QBO or banking batch payment tools:

Vendor,Invoice,AmountToPay,PayBy,DiscountTaken,Notes
Cloud Hosting,INV-410,3136.00,2026-03-19,Yes (2%),Discount expires tomorrow
Office Depot,INV-089,831.60,2026-03-19,Yes (1%),Due today
...

---

Usage Examples

Example 1: Quick Weekly Scan

Input: "Here's my AP aging. What should I pay this week? Cash available: $15k."

Agent output:

1. 1. Parses AP data
2. Flags overdue and discount-expiring invoices
3. Calculates discount ROIs
4. Returns priority queue capped at $15k cash
5. Shows total discount savings captured

Example 2: Discount Decision

Input: "We got an invoice for $8,500 with 2/10 net 30. We have cash. Should we take it?"

Agent output:
CODEBLOCK12

Example 3: Cash Constraint Scenario

Input: "I only have $5k available. I have $20k in AP due this week. What's the triage?"

Agent output:

1. 1. Ranks invoices by criticality (late fee risk + vendor relationship)
2. Identifies which $5k subset to pay to avoid the most damage
3. Flags which vendors to contact proactively about delayed payment
4. Suggests script for requesting payment extension from lowest-risk vendors

---

Integration Points

• - qbo-automation — Pull live AP aging data from QuickBooks to feed this skill
• thirteen-week-cash-flow — Feed payment queue output into 13-week cash model
• ar-collections-agent — Pair AP optimization with AR acceleration for complete cash cycle management
• kpi-alert-system — Trigger alerts when AP aging shows invoices approaching due dates
• financial-analysis-agent — Use vendor spend data for cost analysis and budget variance

---

Key Formulas Reference

CODEBLOCK13

---

Privacy & Compliance Notes

• - AP data contains sensitive vendor relationships and pricing — never share externally
• Payment timing decisions should be reviewed by Irfan for amounts >$10k
• Document all payment decisions with rationale for audit trail
• Never pay invoices directly from this skill — outputs are decision support only