How to calculate revenue from your pricing and volume

To calculate revenue, multiply the price of each product or service by the number of units sold: Revenue = Price × Quantity. For multiple products, sum each line. Deduct returns, discounts, and allowances to reach net revenue. SaaS and service businesses adjust for recurring billing cycles and recognised versus deferred income.

The formula is simple. What branches quickly is how your business model changes what you measure and when you count it. Getting that right before you build a financial plan stops you from projecting numbers that look plausible but measure the wrong thing.

What is the formula for revenue?#

Revenue = Price × Quantity. That is the foundation, and it applies to every business that sells something.

Say you sell three products. Product A sells 200 units at a given price each. Product B sells 50 units at a higher price. Product C sells 400 units at a lower price. Add each line's total to reach your combined revenue.

With more than one product line, calculate each separately and sum them. The formula does not change; you apply it once per line. The mistake is blending all lines into a single figure, which hides which products are driving growth and which are dragging it down. Keep lines separate for as long as you can.

Gross revenue vs net revenue: what is the difference?#

Gross revenue is the full value of everything you sold at list price, before any adjustments. Net revenue is what remains after you subtract returns, discounts, and allowances.

Returns are straightforward: a customer sends the product back, and you refund them. Discounts are reductions you offered before the sale, such as a promotional price or a bulk deal. Allowances are partial credits given after the sale, typically because goods arrived damaged or did not fully meet spec. In retail, allowances also cover trade promotional funding paid to distributors or retailers to place your product.

Revenue and profit are a different distinction. Revenue sits at the top of your P&L. Profit is what survives after costs. Net revenue is still a revenue figure; it has not touched costs yet. The confusion matters because a business can show strong gross revenue while net revenue quietly erodes through high return rates or aggressive discounting. Net revenue is the number that feeds the rest of your plan.

How to calculate revenue for SaaS and subscription businesses#

Subscription businesses do not sell a unit once. They bill a recurring fee, so the base formula adjusts: Monthly Recurring Revenue (MRR) = Number of active subscribers × Monthly price per subscriber. Annual Recurring Revenue (ARR) is MRR × 12.

The harder part is revenue recognition. When a customer pays annually upfront, you collect cash in month one but you have only earned one month of revenue. The remaining eleven months sit as deferred income on your balance sheet until you deliver the service. Recognised revenue moves to your P&L only as you fulfil the obligation. This is not an accounting technicality; it changes what your P&L actually says about the health of the business.

Pricing changes affect both sides of the MRR equation. If you raise prices, some customers will leave. According to A2Z Tools, a 10% price increase breaks even on MRR if it causes no more than a 9.09% loss in customers. That is a tighter margin than most founders expect. Knowing your breakeven price on a pricing change is as important as knowing your breakeven price on a new product.

For a deeper look at how SaaS revenue feeds the rest of your model, the SaaS Financial Model: Key Inputs, Outputs, and Common Mistakes covers the common points where the numbers go wrong.

How to calculate revenue in Excel step by step#

To calculate revenue in Excel, set up one row per product line with price and quantity in separate columns, multiply them to get line revenue, then sum the results and subtract any deductions.

Set up a column for each product or service line in column A.
Enter the unit price for each line in column B.
Enter the expected quantity sold in column C.
In column D, calculate line revenue with =B2*C2 and copy it down for every row.
Add a gross revenue total at the bottom of column D using =SUM(D2:Dn), or use =SUMPRODUCT(B2:Bn, C2:Cn) to calculate the total in a single formula without the intermediate column.
Add a deductions row below the total. Enter returns, discounts, and allowances as separate negative values in column D.
Sum the gross revenue total and the deduction rows to produce net revenue.

The SUMPRODUCT approach is cleaner for models with many lines because it reduces the chance of a row being accidentally excluded from the sum. Label every row clearly. A formula that is correct today becomes a source of errors in six months when someone edits it without understanding what it was doing.

How to calculate marginal revenue and why it matters#

Marginal revenue is the additional revenue you earn from selling one more unit. The formula is: Marginal Revenue = Change in Total Revenue ÷ Change in Quantity.

If selling 100 units generates a certain total and selling 101 units generates a slightly higher total, the difference is the marginal revenue on that extra unit. That figure tells you something the average price does not: whether selling more is actually improving your position. In competitive markets, marginal revenue often falls as you push volume, because you have to cut price to win the next customer.

Founders use marginal revenue alongside how to calculate revenue and profit together. If marginal revenue drops below marginal cost, the next unit destroys value even though total revenue is still rising. That is the most common pricing mistake in early-stage businesses: chasing volume past the point where it helps. The startup financial modelling resources on the bluprnts learning hub cover how to build this logic into a full financial model.

Revenue recognition: recording income at the right time#

Revenue recognition determines when a sale counts as income. The sequence works as follows:

Identify the specific contract held with the customer.
Define the individual performance obligations within that contract.
Establish the total transaction price.
Distribute that price across the performance obligations.
Record the revenue once you have satisfied each obligation.

Cash accounting records revenue when money arrives. Accrual accounting records it when the obligation is fulfilled, regardless of when payment lands. For a business billing annually upfront, cash accounting overstates early revenue and understates it later. That gap can make a business look healthier than it is.

bluprnts is a financial modelling tool that lets founders enter products and pricing, headcount, sales, costs, and financing lines, then automatically derives the full P&L, balance sheet, cashflow, runway, and investor-ready reports. No ledger or accounting software is required to get started.

bluprnts pricing#

FAQs#

What is the difference between revenue and profit?#

Revenue is the total value of sales before any costs are deducted. Profit is what remains after you subtract all costs. Gross profit deducts only the direct cost of producing what you sold. Net profit deducts all operating costs, interest, and tax. Strong revenue and a loss can coexist if costs are high enough.

How do I calculate revenue percentage growth?#

Subtract the previous period's revenue from the current period's revenue, divide the result by the previous period's revenue, then multiply by 100. For example, if revenue rose from one month to the next, divide the increase by the starting figure and multiply by 100 to get the percentage. Apply the same formula across any two comparable periods.

What counts as an allowance when calculating net revenue?#

An allowance is a partial credit given to a customer after a sale, usually because goods arrived damaged, fell short of specification, or because you agreed to fund a promotional activity through a distributor. It reduces the amount you actually collect without the customer returning the product. Allowances are deducted from gross revenue to reach net revenue, alongside returns and pre-sale discounts.

Can I calculate revenue without accounting software?#

Yes. Revenue calculation requires only price and quantity data, which you can hold in a spreadsheet or a financial modelling tool. Accounting software handles historical transaction recording, but it is not required to project or model revenue. The step where you do need to be careful is revenue recognition: if you bill in advance for services delivered over time, you need a method for tracking what has been earned versus what is still deferred.

Conclusion#

Revenue starts with Price × Quantity. The number that matters for planning is net revenue after deductions, recognised at the point you have earned it. For subscription businesses, MRR and ARR replace the one-time sale calculation, and the gap between cash collected and revenue earned can be significant.

The most useful next step is to map your own product lines, assign a price and expected volume to each, and identify which deductions apply. Once you have net revenue, check whether your pricing covers costs by working through your breakeven point using the same inputs.