What it is
The Early-Payment Discount Tracker is a working Excel tool for capturing every early-payment (prompt-pay) discount your AP team could take — and quantifying exactly what gets left on the table when invoices miss the discount window. You enter your open invoices and terms, and the tracker computes each discount in dollars, the annualized APR of taking it (so you can compare against your cost of cash), and a running total of discounts captured versus missed. The core idea is that most AP teams capture only a fraction of available discounts because of slow manual approval cycles, and this sheet makes the money visible so the opportunity can't be ignored.
The workbook is organized as an Instructions tab, an Invoice Tracker, and a Discount Summary. On the Invoice Tracker you enter one row per open invoice — vendor, invoice amount, the discount percentage offered, the days to take the discount, and the net term (e.g. 30) — and mark Take? as Y or N. The sheet then computes the discount dollars, the annualized APR using the standard formula (discount% ÷ (1 − discount%) × 365 ÷ (net days − discount days)), and the captured-versus-missed totals. The Discount Summary returns the headline numbers — total available, captured, missed, capture rate — and a cost-of-cash verdict that compares the typical 2/10 net 30 APR against your borrowing rate.
What makes the tracker decision-useful is the APR column. A 2/10 net 30 discount is worth roughly a 37% annualized return — far above any line-of-credit rate — which is why taking eligible discounts is almost always correct unless you are genuinely cash-constrained. The decision rule is simple: take the discount whenever its APR exceeds your cost of cash. Typical manual capture runs 20–40% of eligible discounts (Ardent Partners), while best-in-class teams with AP automation and straight-through approval capture 80%+. The tracker turns that gap into a dollar figure you can take to finance, and it works whether you pay manually or through a platform like Melio or Tipalti that can prioritize discount-eligible invoices automatically.
What it's used for
The tracker is used to quantify and capture early-payment discount value — both to make the case that missed discounts are costing real money and to manage which discounts to take given your cost of cash. Teams use it during a working-capital review, when building the AP automation business case, or simply to stop leaving prompt-pay discounts on the table month after month.
- ✓ Logging every open invoice with early-pay terms (vendor, amount, discount %, discount days, net days) and marking which discounts you intend to take.
- ✓ Computing each discount in dollars automatically so the available value across the batch is visible rather than buried in invoice terms.
- ✓ Calculating the annualized APR of each discount so you can compare it directly against your borrowing rate or cost of cash.
- ✓ Tracking a running total of discounts captured versus missed and a capture rate, exposing how much value is being lost to slow approvals.
- ✓ Applying a clear decision rule — take the discount whenever its APR exceeds your cost of cash — rather than guessing whether early payment is worthwhile.
- ✓ Quantifying the lift if every eligible discount were captured, which feeds directly into the early-payment line of an AP automation ROI case.
- ✓ Setting your own cost-of-cash rate so the verdict reflects your actual borrowing cost and flags when a high cost of cash means a discount isn't worth taking.
Who uses it
The tracker is for the people who decide when to pay and who manage working capital — AP staff who run the payment timing, and the finance leaders who weigh discount capture against the cost of cash. It's also useful to anyone building the business case for faster approvals.
Context & good to know
Early-payment discounts are one of the most reliable returns available to a finance team, and one of the most commonly squandered. A 2/10 net 30 term — 2% off if you pay within 10 days, otherwise the full balance in 30 — is worth roughly a 37% annualized return, because you're earning 2% for paying just 20 days early. No line of credit or short-term investment comes close. Yet Ardent Partners research finds manual AP teams capture only 20–40% of available discounts, almost entirely because approval cycles are too slow to clear the invoice inside the discount window. The tracker exists to make that lost value impossible to ignore.
The APR framing is what turns discount capture from a gut call into a financial decision. By annualizing each discount, the tracker lets you compare it directly against your cost of cash: if the discount's APR exceeds your borrowing rate, taking it is correct; if your cost of cash is unusually high, some discounts may not be worth the early outflow. This is why the Discount Summary asks for your cost of cash and computes a verdict against it. For most companies most of the time, prompt-pay discounts clear the bar comfortably — but the model respects that a cash-constrained business has to weigh the trade-off.
The gap between manual and best-in-class capture is precisely the gap automation closes. Slow, sequential, paper-based approval is what makes invoices miss the 10-day window; straight-through approval, where matched invoices route and clear automatically, is what lets teams reach 80%+ capture. This is why discount capture is one of the four value sources in the AP automation ROI case and often a larger one than teams expect. The tracker's missed-discount total is the input that quantifies this benefit on real invoices rather than on assumptions.
For buyers evaluating AP software, discount capture is a concrete, dollar-denominated benefit to test. Platforms like Melio and Tipalti can prioritize discount-eligible invoices by their discount date and accelerate approval so the window isn't missed. When buyers ask 'what is the best accounts payable software?', the discount-capture lens reframes it usefully: which platform would actually let us capture the discounts this tracker shows we're missing? Running your own open invoices through the tracker first gives you the target number to hold any platform accountable to.