Price volume mix Excel template: a checked revenue bridge

A price volume mix Excel template turns product sales rows into a revenue bridge that adds up to the recorded change. Put both periods' units and net revenue beside calculated prices, then add the three effects and a check column. The layout below is ready to copy into a workbook and reuse after each close.

Define the workbook before entering numbers

Use the same comparable product population in both periods. This example is for a US distributor selling products measured in the same unit. It bridges January 2026 to February 2026 in USD, using net revenue after the adjustments included in the sales ledger.

The workbook has three sections: source inputs, formula columns and a small bridge summary. Keep the input export unchanged inside your working process, and record its reporting period and extraction date. That makes a revised bridge explainable when a late credit changes the sales total.

The price volume mix analysis guide owns the detailed derivation and alternative calculation orders. This template uses price at current units, with volume and mix at prior prices. Preserve that convention from month to month so a method change does not look like a business change.

Copy this column layout

Put headers in row 1, products in rows 2 through 4 and totals in row 5. Input columns are A:E; F:M contain formulas. Cells in the totals row are referenced with dollar signs so they stay fixed when formulas are filled down.

Fill F:M down to row 4. Sum B:E, H:L and M in row 5, except that total prices in F5 and G5 must be calculated from total revenue divided by total units. Those total prices describe the full sales blend; do not average the product prices.

B5 =SUM(B2:B4)
C5 =SUM(C2:C4)
D5 =SUM(D2:D4)
E5 =SUM(E2:E4)
F5 =C5/B5
G5 =E5/D5
M5 =SUM(J5:L5)-(E5-C5)

When adding products, extend every source, formula and summary range together. A formula that still stops at row 4 can leave the workbook apparently balanced on an incomplete population.

Fill the inputs from a sales export

The example source rows are below. Match products by a stable identifier, rather than their position in two separately sorted files. Each product-period combination should appear once after aggregation.

Revenue increased by 76,500 - 70,000 = $6,500. Units rose by 2,200 - 2,000 = 200. Prior unit shares are 50%, 25% and 25%, so the current total at the prior mix is 1,100 Basic, 550 Plus and 550 Pro units.

Keep calculated prices unrounded. The displayed current total price is repeating; its source ratio remains 76,500 / 2,200. Rounding a price inside the bridge can create a residual even when the source export is complete.

Read the calculated output

The formula columns produce this bridge. All effects are exact whole-dollar amounts in this example.

For Plus, price contributes (42 - 40) × 700 = $1,400. Volume contributes 200 × 25% × 40 = $2,000. Mix contributes (700 - 550) × 40 = $6,000. Together they explain the $9,400 product revenue increase without a leftover.

Across the business, price and greater total units raise revenue, while the shift away from Pro reduces it. The result supports a commercial discussion about the product blend; it does not establish that a specific promotion or salesperson caused the change. Use variance analysis to place this revenue bridge alongside other changes in the management report.

Add the workbook checks and chart rows

The final identity is:

Prior revenue + Price effect + Volume effect + Mix effect = Current revenue

Here, 70,000 + 2,500 + 7,000 - 3,000 = 76,500. Also check source revenue independently. =SUMPRODUCT(B2:B4,F2:F4) must equal C5, and =SUMPRODUCT(D2:D4,G2:G4) must equal E5. Microsoft's SUMPRODUCT reference describes multiplying corresponding entries and summing the products, which is the reconstruction used here.

These identities check the worksheet's arithmetic. Separately tie C5 and E5 to the two source sales reports and confirm that no product identifiers were omitted or duplicated. A self-consistent worksheet can still exclude a product from both its calculations and its total.

Create chart rows for prior revenue of 70,000, price of 2,500, volume of 7,000, mix of -3,000 and current revenue of 76,500, all in USD. Use a waterfall chart and mark the opening and closing revenue columns as totals. Microsoft lists waterfall among Excel's chart types. Keep the reconciliation cell beside the chart; visual appearance is not a substitute for the zero check.

For a broader reporting layout, see the price volume mix analysis template. For recurring presentation of the checked effects, see the price volume mix dashboard.

Where it goes wrong

• Missing prices become zero. A new product has no observed prior price. Separate new and discontinued products instead of inventing historical prices to force them through comparable-product formulas.
• Unit definitions differ. Cases and individual items must be converted to a consistent basis before their quantities contribute to a mix calculation.
• Currency movements enter price. Choose and document reported-currency or constant-currency inputs. Do not describe a foreign-exchange movement as a commercial price decision.
• Formula ranges stop early. Check that new product rows reach all totals and chart summaries. Preserve the row checks as well as the overall identity.
• Product grouping changes. Combining products with different prices can move an effect between price and mix. Keep the grouping stable and label the level of analysis.

Covirage is not affiliated with Microsoft.

Build a checked bridge from your own file

Upload your product sales workbook or Google Sheet with units and net revenue for the periods being compared. Covirage maps the columns, and its tools compute and check the revenue changes; 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 with Covirage for the supporting workflow.