Credit memo tracking: recover the money owed for returns and shortages
Track supplier credits for returns, shortages, substitutions, and pricing errors—and quantify uncredited-return loss.
A restaurant decision is only as reliable as its source and assumptions. Uncredited-return loss = returned quantity × invoice unit cost; age every request until the credit appears on a statement. Write the baseline, show the formula, and separate an observed result from an illustrative estimate. A good guide gives the manager a practical review path, a threshold for action, and a date to check whether the correction worked.
What the data can and cannot tell you
- Capture the request date, original invoice, SKU, quantity, unit cost, reason, and contact.
- Use statuses requested, promised, received, disputed, and written off.
- Age open credits at 7, 14, and 30 days and escalate with the register attached.
- Report recovered value and unrecovered value separately so performance is honest.
A worked example
A restaurant compares a dated source with an expected result and finds a gap. These numbers show the method only; they are not a verified customer case.
| Returned cases | 3 × €48 | €144 requested credit |
|---|---|---|
| Short shipment | 6 × €4.20 | €25.20 requested credit |
| Received memo | €96 | €73.20 remains open |
| Ageing | 21 days | Escalate with invoice evidence |
Use the calculation only when the source, unit, and exception log are visible. Treat it as illustrative until your own records confirm it.
A repeatable process
- 1Define the question. Write the decision, source, unit, time window, and threshold before opening the spreadsheet.
- 2Reconcile inputs. Match identifiers, quantities, dates, credits, and exceptions. Flag missing evidence instead of guessing.
- 3Calculate the gap. Show formula, baseline, observed result, and illustrative impact. Keep price separate from waste or process variance.
- 4Review and act. Have a manager review material exceptions, agree one action, and set a date to measure it.
FAQ
- What is the most common mistake?
- Comparing numbers that look similar but use different units, dates, specifications, or commercial terms.
- How precise should the result be?
- Precise enough to support a decision, not more precise than the source. Preserve the underlying invoice, image, or count.
- When should a person review it?
- Whenever confidence is low, the amount is material, the item is unusual, or an exception changes the conclusion.
- Are the savings figures guaranteed?
- No. All figures in this guide are illustrative. Validate the formula and opportunity against your own records.
Keep reading
- A 15-minute invoice review that catches what audits miss
Five checks, in order, that surface pricing errors before they reach your books.
- Invoice matching issues and how to fix each one
The six ways a three-way match breaks — duplicate invoices, phantom vendors, price drift, quantity gaps, substitution fraud, and statement mismatches.
- Catch invoice line-price drift before it eats your margin
Compare each invoice line against expected unit prices and act on real variances, not noise.
Browse by category
Want to review your purchasing?
Submit the details and we will confirm which invoices are useful.
Get in touch