Itemized Sales Revenue

Calculate using the labelled inputs: Itemized Sales Revenue.

Gross entered sales
35.00
Sales after returns and additional discounts
28.00
Number of rows
2

Calculation and assumptions

gross=Σround(quantity·price,2); net=gross−returns−discounts.

Enter 1–100 rows, quantities with up to six decimals and prices with two. Round each line, halves away from zero. Returns plus additional discounts cannot exceed gross sales. Do not deduct discounts twice if already in unit prices. Gross/net refer only to these deductions; no VAT or revenue-recognition rules. In one chosen two-decimal currency; no taxes or current market rates are supplied.

Values must satisfy the formula’s domain. Nonzero results too small or too large for reliable representation are rejected.

Frequently asked questions

How is the result calculated?

gross=Σround(quantity·price,2); net=gross−returns−discounts.

What assumptions apply?

Enter 1–100 rows, quantities with up to six decimals and prices with two. Round each line, halves away from zero. Returns plus additional discounts cannot exceed gross sales. Do not deduct discounts twice if already in unit prices. Gross/net refer only to these deductions; no VAT or revenue-recognition rules. In one chosen two-decimal currency; no taxes or current market rates are supplied.

How precise are the results?

Monetary totals use two decimal places, with exact halves rounded away from zero at the steps described. Ratios and other numbers show up to ten significant digits. Display precision does not improve input accuracy. Values must satisfy the formula’s domain. Nonzero results too small or too large for reliable representation are rejected.

Also try:

Back to category →