Calculators

Early-payment discount capture rate calculator

Discount capture rate is the share of early-payment discounts suppliers offered that your team actually took, calculated as discounts taken divided by discounts offered.

Discount capture rate calculator

Capture rate
71.2%
Discounts missed
$16,700

Formula: Capture rate = discounts taken / discounts offered

Example

Discounts offered in the period ($)
$58,000
Discounts taken ($)
$41,300
Capture rate
71.2%
Discounts missed
$16,700

What the calculator works out

The calculator divides the dollar value of early-payment discounts your team actually took by the dollar value of discounts suppliers offered in the same period. The result is a capture rate, plus the dollar amount of discounts missed.

Discounts offered is the total potential discount on every invoice in the period that carried discount terms, such as 2/10 net 30, whether or not anyone at your company saw or claimed it. In accounts payable, build this from the invoice register, using the terms on each invoice or on the vendor record. In accounts receivable, it is the discount you extended to customers on invoices you issued.

Discounts taken is the amount actually realized: the reduction your team took on payment, or the discount a customer deducted. In AP, this usually appears in payment history or remittance detail as a separate discount line or a reduced payment amount. In AR, it appears as a deduction on the customer's remittance.

The output is a ratio and a dollar gap. It does not change the ledger or create a journal entry. It is a reading of records you already keep, meant to show whether discount terms are being used or quietly slipping away.

A worked example

Take a period in which suppliers offered $58,000 in early-payment discounts across invoices that carried discount terms. During the same period, your team took $41,300 in discounts. You enter those two figures: $58,000 as discounts offered and $41,300 as discounts taken.

The calculator divides discounts taken by discounts offered. The capture rate is 71.2%. The discounts missed are $16,700.

In plain terms, of the $58,000 in discounts that were on the table, $41,300 was captured and $16,700 was left behind. That $16,700 is the size of the gap to investigate, not a promise that all of it is recoverable. Some invoices may have been in dispute, some may have been paid late for good reason, and some may have been missed because the discount date passed before the payment run.

The two figures tell different parts of the story. The 71.2% says how often the process worked. The $16,700 says how much money is involved. A manager should look at both before deciding where to spend time.

Reading the result

A 71.2% capture rate means the majority of discount dollars offered were taken, but a meaningful share was not. On its own, that number is neither good nor bad. It becomes useful when compared with prior periods, with other business units, or with the terms your suppliers actually offer.

Before treating the whole gap as a failure, split it. Some discounts are intentionally skipped because paying early would cost more than the discount is worth. Compare the discount rate on the invoice with your own cost of funds; if the discount is smaller than what the money costs you to use early, skipping it can be rational. Other misses are operational: an approval sat in a queue, a payment run was scheduled a few days too late, or an invoice arrived after the discount window had nearly closed.

Check discounts taken late. A discount taken after the discount date may be billed back by the supplier, so the capture rate can look better than the cash result. Count how many of the taken discounts were within the window, and reconcile any supplier chargebacks before drawing conclusions.

Use the dollar figure to prioritize. A 71.2% rate on a small discount pool is a different problem from the same rate on a large one. The rate shows process discipline; the dollars missed show where recovery effort and process changes are worth the time.

Where the inputs go wrong

The most common input error is understating discounts offered. Teams pull only the discounts they can see in payment records, which are the ones already taken. That pushes the capture rate toward 100% and hides the misses. Offered must include every invoice in the period with discount terms, whether or not anyone saw it.

The second error is bad terms on the vendor record. A wrong percentage, wrong number of days, or a duplicate vendor record with old terms makes both the offered and taken figures unreliable. Correct discount terms on vendor records are the first thing to check before trusting any capture rate.

The third error is timing. A payment made on the last day of the period may post in the next period, so the discount is counted in the wrong month. A discount date that falls on a weekend or holiday can be missed by a payment run that only operates on business days. Slow approvals and payment runs that miss the discount date are behind most missed discounts.

The fourth error is counting a late-taken discount as captured. If the supplier later bills the discount back, the taken figure was overstated. Keep the taken number tied to remittance advice and check the payment date against the discount date. Also watch for duplicate payments and unapplied credits that distort either side of the ratio; a clean vendor record and a clean payment history are what make the calculator worth reading.

Questions

What is a good discount capture rate?

There is no universal target. A 71.2% rate in one company may be acceptable and in another a sign of missed cash. Track the rate over several periods and compare the dollars missed with the effort required to capture them. Compare the discount rate with your own cost of funds when deciding whether a miss was worth avoiding.

How do I find discounts offered in my accounting records?

Start with every invoice in the period that carried discount terms, not just the invoices where a discount was taken. Use the invoice register and the terms on the vendor record. In accounts receivable, use the invoices you issued with discount terms. The offered figure should represent the full potential discount, including invoices no one acted on.

Why do AP teams miss early payment discounts?

Most misses come from slow approvals and payment runs that fall after the discount date. Incorrect discount terms on the vendor record, invoices that arrive close to the discount deadline, and payment runs that do not operate every business day also contribute. A smaller share of misses is deliberate, where paying early would cost more than the discount is worth.

Can a supplier bill back a discount taken after the discount date?

Yes. Suppliers may invoice back a discount that was taken outside the agreed window. That means a capture rate built only on discounts taken can overstate the real benefit. Reconcile supplier chargebacks and check how many taken discounts were within the window before treating the rate as final.

Updated Nov 9, 2026. Figures on this page are calculated by ERPSav from the definitions shown. The explanatory text is drafted with AI from those figures and checked automatically before it is published. General information only, not legal, tax or financial advice.