Developed and maintained by ProWorkstack · Development and review process
Compare fulfilled units with comparable net customer payments and documented return adjustments.
Your results
Enter your inputs and select Calculate.
How this calculator works
Adjusted fulfilled sales value = fulfilled units × comparable unit charge − documented discounts − return value. Signed difference = adjusted fulfilled value − comparable net payments. Positive review amount = max(signed difference, 0).Worked example
Five hundred fulfilled units at 40 give 20,000. Subtract 1,000 discounts and 800 returns for 18,200 adjusted value. Against 17,700 comparable payments, the signed difference is 500.Assumptions
Defaults are illustrative. Replace them with your own measured quantities and documented assumptions. Use matching periods and a consistent currency wherever monetary amounts are entered.Interpreting your results
No inventory or payment system is audited. The difference can include unpaid terms, timing, mixed prices or refunds, and is not proof of theft or nonpayment. Tax, shipping and processor fees must be treated consistently.Calculation formulas
- expected
units*price-discounts-returns- Sales value minus customer payments
expected-paid- Delivered sales value after adjustments
expected- Positive payment gap to investigate
MAX(expected-paid,0)
Frequently asked questions
What should I check before using the result?
Count shipped or completed units according to one definition and follow the same orders into payments. A customer payment received before fulfillment belongs to a different timing stage and should not be mixed into the group of records.
Does this tool connect to my records?
No. This is a local calculation from the figures you enter. It does not scan accounts, import private records or verify legal, regulatory or exam requirements.
Maintained by ProWorkstack · Last reviewed: 2026-10-04 · Development and review process