Blog · Board and management reporting · Finance and FP&A teams
Build a margin dashboard that reconciles gross, operating and net profit across business units. Follow the P&L bridge, use exact spreadsheet formulas and check that unit results tie to the company total.
A margin dashboard reconciles gross, operating and net profit across business units, then divides each company profit total by company revenue. Build the expense bridge first and add the percentages after it balances. Otherwise, an attractive unit margin can hide central costs or an incomplete profit definition.
This review answers where profit falls between revenue and the bottom line. Customer and product drivers belong in a separate gross margin dashboard, where pricing, cost and mix can be examined in detail.
Use a monthly P&L export with period, business unit, account, net revenue and expense classification. Finance should approve the mapping from ledger accounts to cost of goods sold, operating expenses, net interest expense, tax and any other nonoperating items.
The SEC's guide to financial statements explains the sequence: subtract cost of sales to reach gross profit, deduct operating expenses to reach operating profit, then account for interest and income tax in arriving at net profit. A company's actual statement may contain additional items, so preserve them rather than forcing every business into a shortened bridge.
The definitions of gross profit margin and net profit margin explain the individual ratios. Here, the task is to make those levels reconcile across units using one reporting period and one revenue base.
The fictional US company reports September 2026 in USD. Export one summarized row per unit to a sheet, with the input columns A through F in the order below. Revenue is net of returns and discounts; expenses are positive amounts to subtract.
| Business unit | Revenue (USD) | COGS (USD) | Operating expenses (USD) | Net interest expense (USD) | Income tax expense (USD) |
|---|---|---|---|---|---|
| Industrial | 1,000,000 | 600,000 | 250,000 | 20,000 | 30,000 |
| Services | 500,000 | 200,000 | 180,000 | 10,000 | 25,000 |
| Central | 0 | 0 | 80,000 | 5,000 | 0 |
| Company | 1,500,000 | 800,000 | 510,000 | 35,000 | 55,000 |
These are management reporting assignments for interest and tax, rather than separate legal-entity tax calculations. Their totals tie to the company statement. Central expenses remain visible instead of being spread across revenue units, and this example has no interunit sales or other nonoperating items.
Operating expenses include applicable depreciation and amortization in this example. That matters when readers compare operating margin with EBITDA margin, which uses a different profit amount. Keep the cost of goods sold classification consistent across units and periods as well.
Add columns G through L. Enter the following formulas in row 2 and copy them through row 4. They calculate gross profit, operating profit, net profit and the corresponding margins in Google Sheets.
G2 =B2-C2
H2 =G2-D2
I2 =H2-E2-F2
J2 =IF(B2=0,"",G2/B2)
K2 =IF(B2=0,"",H2/B2)
L2 =IF(B2=0,"",I2/B2)
Format J through L as percentages with one decimal place. The blank condition is deliberate: Central has expenses but no revenue, so its individual margins are undefined. Its losses still belong in company profit.
| Business unit | Gross profit (USD) | Operating profit (USD) | Net profit (USD) | Gross margin | Operating margin | Net margin |
|---|---|---|---|---|---|---|
| Industrial | 400,000 | 150,000 | 100,000 | 40.0% | 15.0% | 10.0% |
| Services | 300,000 | 120,000 | 85,000 | 60.0% | 24.0% | 17.0% |
| Central | 0 | -80,000 | -85,000 | — | — | — |
| Company | 700,000 | 190,000 | 100,000 | 46.7% | 12.7% | 6.7% |
For Industrial, the bridge is 1,000,000 - 600,000 = $400,000 gross profit; 400,000 - 250,000 = $150,000 operating profit; and 150,000 - 20,000 - 30,000 = $100,000 net profit. Dividing those amounts by its $1,000,000 revenue gives the displayed margins.
Place the company row at row 5. Sum each amount column, rather than averaging the unit percentages. Google's SUM documentation describes adding numbers or cell ranges.
B5 =SUM(B2:B4)
C5 =SUM(C2:C4)
D5 =SUM(D2:D4)
E5 =SUM(E2:E4)
F5 =SUM(F2:F4)
G5 =SUM(G2:G4)
H5 =SUM(H2:H4)
I5 =SUM(I2:I4)
J5 =IF(B5=0,"",G5/B5)
K5 =IF(B5=0,"",H5/B5)
L5 =IF(B5=0,"",I5/B5)
Company gross margin is 700,000 / 1,500,000 = 46.7%. Operating margin is 190,000 / 1,500,000 = 12.7%, and net margin is 100,000 / 1,500,000 = 6.7%. Calculate from unrounded amounts, then round the display.
The unit profit tie is equally important. Operating profit is 150,000 + 120,000 - 80,000 = $190,000. Removing Central from that calculation would improve the reported result while leaving the business unchanged.
Put these reconciliation formulas beside the company row. Each must return zero:
=G5-(B5-C5)
=H5-(G5-D5)
=I5-(H5-E5-F5)
The full company bridge is 1,500,000 - 800,000 - 510,000 - 35,000 - 55,000 = $100,000. Match every amount column to the corresponding P&L line before interpreting the margin movement. A zero spreadsheet difference proves internal arithmetic; it does not prove that the export includes every ledger account.
If interunit sales exist, include consolidation elimination rows before computing company revenue and profit. Preserve their source accounts and sign convention. For unit comparisons, show whether profits include central allocations and retain a bridge back to the unallocated result.
Finance owns the account mapping and reconciliation. Unit leaders explain local revenue and expense changes. The controller resolves missing accounts, sign errors and consolidation differences before the management review uses the percentages.
Bring a P&L export with business units, account classifications and any central or consolidation rows. Covirage maps the columns, and its tools compute and check the profit bridge and margin ratios; 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 data.
See financial planning and analysis reporting for the supporting business context.
Covirage is not affiliated with Google.
Gross margin deducts cost of goods sold from revenue. Operating margin also deducts operating expenses, while net margin reflects the remaining income and expenses, including interest and income tax. Each divides the relevant profit amount by revenue for the same period and reporting scope.
Use total profit divided by total revenue. A simple average gives a small unit the same influence as a large one and can exclude central costs that have no revenue denominator. Sum all included profit amounts, including consolidation adjustments, before calculating the company percentage.
Keep central costs on a visible row unless the business has an approved allocation policy. Show their effect on the company profit bridge even when central revenue is zero. If costs are allocated to units, retain an allocation reconciliation so they are neither omitted nor counted twice.
Leave the margin blank or mark it as not applicable because dividing by zero does not produce a meaningful percentage. Keep the unit's profit or loss in the consolidated numerator. A central expense center can reduce company profit despite having no revenue of its own.