ERPSav

Sample report · Supplier Rebate & Contract Price Recovery

$2,160.71 expected back from a 14-row sample

This is ERPSav's own engine run on the sample file. The figures come from sample data, not from a customer.
Rows read
14
Cases opened
3
Money at risk
$2,788.40

Cases

  • Midwest Industrial Supply — 1 duplicate line, 1 line above contract price, 1 missed price break, 1 freight charge on prepaid terms, 1 rebate not received, 1 discount not takenMidwest Industrial Supply

    $2,042.79of $2,611.00 at risk

    • blockerInvoice INV-50190 bills item 4471-A (qty 40 at $48.00) 2 times; 1 duplicate line totalling $1,920.00.
    • warningItem 4471-A was billed above the contract price (MIS-2025-114) on 1 line, e.g. $52.80 against $48.00; $192.00 over contract.
    • warningItem 8820: 1 line reached the 100-unit price break ($2.85) but was billed at $3.15; $36.00 over the break price.
    • warningFreight of $85.00 was charged on 1 line although the freight terms ("FOB Destination, Freight Prepaid") say the supplier pays freight.
    • warningPurchases of $16,410.00 in 2026-Q2 under MIS-2025-114 reach the 2% rebate tier (threshold $10,000.00), earning $328.20; $0.00 has been received, leaving $328.20.
    • infoInvoice INV-50112 (terms "2/10 Net 30") was paid in 8 days, inside the discount window, but none of the 2% discount was deducted; $49.80 of discount was missed.

  • Coastal Packaging Co. — 1 increase above escalator cap, 1 contract discount not honouredCoastal Packaging Co.

    $100.92of $157.40 at risk

    • warningItem BOX-1212 rose from $0.84 to $0.93 (+10.7%), above the 3% escalator cap (allowed $0.8652); $129.60 above the cap.
    • warningInvoice CP-1188 was issued on "Net 45" terms although the contract gives "1/15 Net 45"; it was paid in 10 days, inside the discount window, so a 1% discount of $27.80 applies.

  • Summit Medical Distribution — 1 line above contract priceSummit Medical Distribution

    $17.00of $20.00 at risk

    • warningItem SYR-10ML was billed above the contract price (SMD-GPO-3301) on 1 line, e.g. $0.21 against $0.19; $20.00 over contract.

The letter drafted for the largest case

Subject: Pricing and rebate credit request — Midwest Industrial Supply (Sample Company Inc.)

Dear Midwest Industrial Supply Accounts Receivable team,

During a routine review of our purchase records at Sample Company Inc., we compared your invoices with the pricing, rebate, payment and freight terms we have on file (MIS-2025-114). The items below appear to differ from those terms. We may have misread our records, so please check them against your own.

Invoice lines that appear more than once:
  - Invoice INV-50190 dated 2026-05-04, item 4471-A, qty 40 at $48.00 (billed 2 times); duplicate line to credit: $1,920.00

Lines billed above the contract price:
  - Invoice INV-50112 dated 2026-04-06, item 4471-A, qty 40: billed $52.80 each against the contract price of $48.00 (contract MIS-2025-114); difference to credit: $192.00

Volume price breaks not applied:
  - Invoice INV-50112 dated 2026-04-06, item 8820, qty 120: billed $3.15 each against the price-break price of $2.85; difference to credit: $36.00

Freight charged on prepaid or free-freight terms:
  - Invoice INV-50112 dated 2026-04-06: freight of $85.00 charged; freight terms on file "FOB Destination, Freight Prepaid"; amount to credit: $85.00

Volume rebates earned but not credited:
  - Period 2026-Q2, contract MIS-2025-114: purchases of $16,410.00 at the 2% tier earn $328.20; received to date $0.00; rebate to credit: $328.20

Prompt-payment discounts:
  - Invoice INV-50112 dated 2026-04-06, paid 2026-04-14 (8 days) on terms "2/10 Net 30": 2% of $2,490.00, less $0.00 already deducted; discount to credit: $49.80

Total we are asking you to credit: $2,611.00

Could you please confirm whether these items are correct and either issue a credit memo or refund for the amounts above? If any item reflects pricing or terms we do not have on file, a copy of the relevant price list, amendment or rebate statement would help us reconcile.

Thank you for your help.

Kind regards,
Sample Company Inc.

Run the same check on your own export. Free for 14 days from your first import.

Download the sample fileStart free