Reconcile gross sales to net sales
Use this worksheet for a single reporting period when you know product price, units sold, and dollar deductions for returns, allowances, and discounts. Keep all deductions in the same currency and period as gross sales; enter deduction amounts, not percentages.
Supported arithmetic
The product-defined scenario uses gross sales = unit price × units sold. Total deductions are returns plus allowances plus discounts, and net sales = gross sales - deductions. When gross sales are positive, deduction rate is deductions / gross sales × 100; when gross sales are zero, the displayed rate is 0% even if deductions make net sales negative.
For a $200 product and 100 units, gross sales are $20,000. Returns of $1,000, allowances of $500, and discounts of $1,500 total $3,000, so net sales are $17,000 and deductions equal 15% of gross sales. As a reconciliation step, remove each entered deduction category one at a time to see which input explains the largest arithmetic difference.
Data checks and boundaries
Price, units, and every deduction must be nonnegative. Units accept whole-number steps in the interface, but this is an arithmetic estimate rather than an inventory ledger. Deductions may exceed gross sales, producing negative net sales; review that case rather than assuming an error. Zero gross sales makes the deduction percentage uninformative. Blanks, invalid numeric values, and values outside the displayed ranges are invalid.
This view does not determine revenue-recognition treatment, tax, fees, cost of goods sold, timing, or accounting classification. It is not accounting, tax, or legal advice. After reconciling sales, use the sales commission calculator only if you also need the separate product-defined quota and commission scenario.