Blog · Finance metrics and formulas · Finance and FP&A teams
Calculate total revenue from quantities, prices, discounts and returns. Follow a worked invoice example and reconcile the result to the revenue ledger.
The total revenue formula is quantity sold times selling price, added across every product or service in the period. To calculate net revenue, subtract discounts, returns and allowances once. The final amount must represent earned sales and tie to the revenue accounts, rather than merely match invoice face values.
Gross sales = Sum of (Quantity sold × Gross unit price)
Net revenue = Gross sales − Discounts − Returns − Other sales allowances
For a single product at a single price, multiplication gives the answer directly. Across different products, calculate each row first and then add the amounts. A unit of one product does not have the same selling value as a unit of another.
The SEC's guide to financial statements distinguishes gross sales from revenue after returns and allowances. Its explanation also separates revenue from the costs deducted afterward. The broader revenue versus profit comparison covers that distinction; the job here is constructing the top line.
The formula assumes the goods or services belong in the reporting period under your accounting policy. A signed order, an advance invoice and a completed sale can have different dates. Use the recognized-sales schedule to establish the eligible rows before applying the arithmetic.
Export one row per invoice line with invoice ID, line ID, customer, product, quantity, unit price, currency, invoice date and revenue period. Include separate fields for line discounts and credits already attached to the line. Keep sales tax outside these revenue columns for this example.
Bring the credit-memo export as well. Each memo needs its own ID, posting period, amount and original invoice reference where available. A credit already reflected in a net invoice amount must not also appear as a second subtraction.
Choose a consistent sign convention. In the table below, quantities and gross prices are positive; deductions are positive amounts that the formula subtracts. A separate signed credit-memo register can also work, but then its amounts are added algebraically. Mixing the conventions reverses deductions.
Retain customer and product identifiers after summarizing. They let the same underlying rows produce totals by product, customer and month, without treating those views as separate sales to add together.
An illustrative Illinois distributor closes September 2026. All displayed product sales were earned during the month. These rows summarize its eligible invoice lines, with one additional period credit shown separately afterward. Amounts are in USD; no currency conversion is needed.
| Product | Quantity | Gross unit price (USD) | Gross sales (USD) | Discounts (USD) | Attached returns (USD) | Net line revenue (USD) |
|---|---|---|---|---|---|---|
| Standard fittings | 1,200 | 80 | 96,000 | 4,800 | 1,600 | 89,600 |
| Commercial valves | 500 | 150 | 75,000 | 3,000 | 1,500 | 70,500 |
| Premium assemblies | 300 | 200 | 60,000 | 0 | 1,000 | 59,000 |
| Total | 2,000 | 231,000 | 7,800 | 4,100 | 219,100 |
Put the columns in A through G, with headers in row 1. Calculate gross sales in D2 and net line revenue in G2, then fill both down through row 4:
=B2*C2
=D2-E2-F2
The gross-sales check is:
=SUMPRODUCT(B2:B4,C2:C4)
It returns $231,000, the same as summing D2:D4. The SUMPRODUCT documentation describes this multiplication of corresponding ranges followed by addition. Covirage is not affiliated with Microsoft.
The net line total is $231,000 − $7,800 − $4,100 = $219,100. This is an intermediate subtotal, because the separate credit register still needs to be checked.
The controller identifies an additional $4,000 customer allowance posted to September revenue. It is not included in either deduction column above. Its approved period attribution makes it part of this month's revenue reconciliation.
| Reconciliation step | Amount (USD) |
|---|---|
| Gross sales from invoice lines | 231,000 |
| Less line discounts | -7,800 |
| Less attached returns | -4,100 |
| Less separate allowance | -4,000 |
| Calculated net revenue | 215,100 |
| Revenue-ledger control total | 215,100 |
| Unexplained difference | 0 |
All dollar results are exact whole dollars here; there is no intermediate rounding. With real invoice exports, preserve their currency precision and follow the ledger's line-rounding policy.
The control total must come from the accounting report for the same entity, currency and period. A zero difference proves that these included amounts reconcile. It does not prove that the accounting recognition decisions were appropriate, so retain the approval for period adjustments.
The separate guide to credit notes and returns covers deduction timing in more detail. Keep this calculation focused on whether the specified deductions were applied completely and once.
Save both quantities and realized revenue at the product level. Higher revenue can reflect more units, higher earned prices, fewer deductions or a shift toward higher-priced products. The total alone cannot identify the cause.
Start a comparison by matching product IDs and periods, then inspect the underlying amounts before calculating averages. A product introduced this month needs its own explanation, because it has no prior-period selling price. A discontinued product should remain in the comparison with its prior sales visible.
Do not divide the combined revenue by an arbitrary operational count and call the result a company selling price. Units must mean the same thing before a price average is useful. The bookings, billings and revenue bridge addresses another common source of apparent growth: using different stages of the sale in different periods.
Upload your invoice lines, credit summary and revenue schedule, or bring a Google Sheet; Covirage maps the columns, and its tools compute and check the supplied figures. The external AI model explains the result with every figure traced to its rows. Create a free Covirage account, which takes about a minute, and bring a sample of your own data after setting up your business.
See revenue driver analysis for the supporting approach to explaining the changes.
The label needs a definition. Gross sales multiply quantities by prices before sales deductions. Net sales subtract discounts, returns and allowances. For a management report, state which basis you use and reconcile it to the corresponding ledger accounts.
In this calculation, sales tax collected for a government is kept outside revenue. Use the sales amount before that tax, rather than the invoice's amount due. Confirm the treatment in your accounting policy, especially when different jurisdictions appear in one export.
Multiply earned billable hours, days or other service units by their applicable rates, then apply the approved sales deductions. For fixed-fee work or services earned over time, use the recognized amount from the accounting schedule rather than assuming every invoice is current revenue.