Itemized Sales Revenue
Calculate using the labelled inputs: Itemized Sales Revenue.
Enter a finite value within the formula’s domain and supported numeric range.
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.