Blog · Finance metrics and formulas
Sales price per unit divides net sales by the matching net quantity sold. Work the calculation from invoices and returns, prove the weighted total and distinguish product price changes from a change in sales mix.
Sales price per unit is net sales divided by the matching net units sold. It measures the price a company actually realized after discounts, allowances and returns. Use the same product, customer, period and unit definition on both sides of the calculation.
An invoice can show a stable list price while the realized price falls. Discounts may have changed, customers may have returned products, or the business may have sold a different product mix. The calculation identifies the result; a comparison of its component rows explains it.
Sales price per unit = Net sales / Net units sold
Net sales = Gross sales − Discounts and allowances − Return credits
Net units sold = Gross units sold − Returned units
The IRS explanation of sales returns and allowances describes customer credits for returned merchandise and other sales allowances as deductions from gross sales when figuring net sales. For management analysis, preserve those adjustments as separate columns so the movement remains visible.
Use revenue from the sales ledger, rather than customer cash receipts. A deposit, late payment or collection timing change does not establish the price of the units sold in the reporting period. Also keep promotional allowances distinct from product returns: an allowance can reduce revenue without reducing quantity.
This is a measurement of realized sales. For setting a cost-based target price, use markup versus margin. The adjacent unit selling price guide covers its own pricing workflow; neither calculation replaces the invoice reconciliation here.
Bring invoice number and line, invoice date, customer, SKU, gross quantity, unit of measure, gross sales, discounts or allowances, returned quantity and return credit. Keep the original invoice reference on a return wherever possible.
Choose the period policy before aggregating. A booked-period report includes the sales and credits posted in that period. An original-sale cohort report attaches subsequent credits to the invoices they reverse. Both can answer useful questions, but they produce different period totals and must not be combined silently.
Standardize cases, packs and individual items before adding quantities. Products sold in incompatible units should have separate price measures. An all-product average is useful only when its shared unit has an intelligible business meaning; a dollar-per-case measure cannot also include pounds without conversion.
A US distributor reviews two products sold in individual units during one month. The discounts and allowances below apply to the retained sales. Return credits are listed separately, and there is no sales tax, freight revenue or service revenue in the table.
| Product | Gross units | Returned units | Gross sales (USD) | Discounts and allowances (USD) | Return credits (USD) |
|---|---|---|---|---|---|
| A | 120 | 20 | 6,000 | 300 | 1,000 |
| B | 80 | 0 | 3,200 | 400 | 0 |
| Total | 200 | 20 | 9,200 | 700 | 1,000 |
Compute the matching net amounts before dividing:
| Product | Net-unit calculation | Net units | Net-sales calculation (USD) | Net sales (USD) | Sales price per unit (USD) |
|---|---|---|---|---|---|
| A | 120 − 20 | 100 | 6,000 − 300 − 1,000 | 4,700 | 47.00 |
| B | 80 − 0 | 80 | 3,200 − 400 − 0 | 2,800 | 35.00 |
| Total | 200 − 20 | 180 | 9,200 − 700 − 1,000 | 7,500 | 41.67 |
The company price is 7,500 / 180 = $41.67 per unit, rounded to two decimal places. Keep unrounded values in the workbook. Dividing net sales by the original 200 units would instead produce $37.50, because returned products would remain in the denominator after their revenue had been removed.
Put the input table in columns A through F, with product A on row 2 and product B on row 3. For net units in G2, enter:
=B2-C2
For net sales in H2 and realized price in I2, use these formulas respectively, then fill the three formulas down:
=D2-E2-F2
=IF(G2=0,NA(),H2/G2)
The total price divides the totals:
=IF(SUM(G2:G3)=0,NA(),SUM(H2:H3)/SUM(G2:G3))
Two checks prove the result. First, total net sales must be $9,200 − $700 − $1,000 = $7,500, and total net quantity must be 200 − 20 = 180. Tie those totals to the sales and quantity reports under the same reporting policy.
Second, each product's unrounded price multiplied by its units must reconstruct revenue: 100 × $47 + 80 × $35 = $7,500. Microsoft's SUMPRODUCT documentation describes the function as adding the products of corresponding ranges. It supplies the independent weighted-price check:
=SUMPRODUCT(G2:G3,I2:I3)/SUM(G2:G3)
That returns the same unrounded company price. The simple average of $47 and $35 is $41.00, which gives the smaller product quantity the same weight as the larger one. Excel is a Microsoft product; Covirage is not affiliated with Microsoft.
Now change only the quantities sold, leaving both product prices fixed. The second period still contains 180 net units:
| Product | Previous net units | New net units | Unchanged price (USD) | New net sales (USD) |
|---|---|---|---|---|
| A | 100 | 50 | 47.00 | 2,350 |
| B | 80 | 130 | 35.00 | 4,550 |
| Total | 180 | 180 | 38.33 blended | 6,900 |
The blended price falls from $41.67 to $38.33, but neither product received a price reduction. Shifting 50 units from A to B reduces revenue by 50 × ($47 − $35) = $600. Divide the new $6,900 by 180 to verify the new average; the displayed prices are rounded to two decimals.
For discount-control questions, price realization by customer compares invoiced and reference prices. For the economics after the sale, match this revenue measure with cost per unit and profit per unit.
Upload invoice quantities, net sales adjustments and matching return references. Covirage maps the columns; its tools compute and check realized prices by product, customer and month, and the external AI model explains the results with every figure traced to its rows. Create a free Covirage account and bring a sample of your own export.
See revenue driver analysis for the supporting price and mix perspective.
List price is the stated price before transaction adjustments. Sales price per unit is the realized amount after the discounts, allowances and returns included in net sales. The figures match only when those adjustments do not change the revenue per unit.
Yes. A larger share of lower-priced products or customers can reduce the overall average even when every individual selling price stays constant. Compare the same products and customer groups first, then measure the effect of the changed unit mix.
A price per unit cannot be calculated when the denominator is zero. Flag the result as unavailable and inspect the underlying invoices and credits. A period containing only financial allowances or offsetting shipments and returns needs separate review.
For this management measure, use merchandise revenue excluding sales tax collected for a taxing authority. Keep separately billed services or freight outside the numerator unless the unit definition deliberately includes them, and use the same policy in every period.