Blog · Board and management reporting · Finance and FP&A teams
A profitability report connects segment contribution to company profit. Build a recurring report from ledger exports, compare margins and explain the movement with a reconciliation that closes.
A profitability report shows which business segments contribute to profit and proves how their results connect to the company income statement. Start with revenue and identifiable costs, compare the same measures across periods, and reconcile shared expenses before explaining what changed. A segment ranking without that reconciliation can hide costs rather than explain performance.
Use a closed ledger export with posting date, journal-line ID, account, business segment, description and amount. Add a controlled mapping from accounts to revenue, identifiable segment costs, shared operating costs, interest and income tax. Keep unmapped rows visible until finance resolves them.
For this report, segment contribution means revenue less expenses directly identified with that segment. Those expenses can include identifiable fixed costs; this is a management reporting definition, not automatically the variable-cost definition of contribution margin. State the definition on every recurring report. The distinction between gross, contribution and net margin matters when someone compares this report with another pack.
Use net revenue after credits and returns. Preserve reversals as negative amounts within their mapped category. Normalize revenue and expense balances to positive presentation amounts while retaining each original ledger amount for checking.
Segment contribution = Segment revenue − Identifiable segment costs
Company operating profit = Total segment contribution − Shared operating costs
Consider an illustrative US distributor reporting September and October 2026. Finance assigns warehouse fulfillment and segment payroll directly, while corporate finance and executive costs remain shared. Both months use the same mapping and USD amounts.
| Segment and period | Revenue (USD) | Identifiable costs (USD) | Contribution (USD) | Contribution margin |
|---|---|---|---|---|
| Industrial, September | 400,000 | 280,000 | 120,000 | 30.0% |
| Service, September | 250,000 | 150,000 | 100,000 | 40.0% |
| September total | 650,000 | 430,000 | 220,000 | 33.8% |
| Industrial, October | 450,000 | 306,000 | 144,000 | 32.0% |
| Service, October | 240,000 | 156,000 | 84,000 | 35.0% |
| October total | 690,000 | 462,000 | 228,000 | 33.0% |
Contribution subtracts the cost column from revenue. Margin divides contribution by revenue. Percentages are rounded to one decimal place; dollars are exact. The company margin divides total contribution by total revenue rather than averaging segment percentages.
Suppose the worksheet Lines has period labels in A, segment in B, reporting category in C and normalized amount in D. On the report, H1 contains October 2026 and A2 contains Industrial. Revenue and identifiable costs in B2 and C2 are:
=SUMIFS(Lines!$D$2:$D$9999,Lines!$A$2:$A$9999,$H$1,Lines!$B$2:$B$9999,$A2,Lines!$C$2:$C$9999,"Revenue")
=SUMIFS(Lines!$D$2:$D$9999,Lines!$A$2:$A$9999,$H$1,Lines!$B$2:$B$9999,$A2,Lines!$C$2:$C$9999,"Identifiable cost")
Then calculate contribution in D2 and margin in E2:
=B2-C2
=IF(B2=0,"",D2/B2)
These Excel formulas use SUMIFS to total amounts meeting multiple criteria. Extend every range to cover the full export, and flag zero-revenue segments rather than interpreting a blank margin as healthy performance. Covirage is not affiliated with Microsoft.
Do not stop at the segment subtotal. Shared expenses still belong to the company even when no segment manager controls them. The SEC's financial statement guide distinguishes operating profit from net profit after financing and income tax lines; label the endpoint you are reconciling.
| Reconciliation step | September (USD) | October (USD) |
|---|---|---|
| Segment contribution from above | 220,000 | 228,000 |
| Less shared operating costs | 140,000 | 155,000 |
| Operating profit | 80,000 | 73,000 |
| Less interest expense | 5,000 | 6,000 |
| Less income tax expense | 15,000 | 14,000 |
| Net profit | 60,000 | 53,000 |
October operating expenses are $462,000 plus $155,000, or $617,000. Revenue of $690,000 less $617,000 gives $73,000 of operating profit. Subtracting $6,000 and $14,000 gives $53,000 of net profit.
Compare each mapped total with its corresponding company P&L line. The difference must be zero, with any rounding differences disclosed. A zero grand-total difference alone is insufficient: misclassifying an expense between segments can leave company profit unchanged while producing the wrong ranking.
For narrower views, a customer profitability report groups the same logic by customer, while a product profitability report focuses on product lines. Keep their reporting boundaries separate from this company reconciliation.
Segment contribution increased, but operating profit declined. The bridge identifies where those two statements meet:
| Movement from September operating profit | Effect on profit (USD) |
|---|---|
| Starting operating profit | 80,000 |
| Industrial revenue increase | 50,000 |
| Industrial identifiable cost increase | -26,000 |
| Service revenue decrease | -10,000 |
| Service identifiable cost increase | -6,000 |
| Shared operating cost increase | -15,000 |
| Ending operating profit | 73,000 |
Industrial contribution rose by $24,000; Service contribution fell by $16,000. Their combined improvement of $8,000 was outweighed by $15,000 of additional shared expense, leaving a $7,000 operating-profit decline.
This bridge separates revenue and cost movements; it does not establish price, volume or productivity causes. Ask the sales owner to explain Service revenue, its operating owner to explain costs, and finance to trace shared-expense changes to accounts and journals. Record a named owner and next action beside each explanation. Keep ratio definitions in the existing financial ratios guide.
Upload your ledger export or Google Sheet with segment identifiers and reporting categories. Covirage maps the columns, and its tools compute and check segment comparisons and company totals; the external AI model explains the results with every figure traced to its rows. Create a free Covirage account, which takes about a minute, then set up your business and bring a sample of your own data.
See Covirage for finance teams for the reporting context.
Include the reporting period, segment revenue, defined segment costs, contribution dollars and contribution margin. Add a company reconciliation for shared expenses and other income statement lines, a comparison period, and a short explanation of the changes with an accountable owner.
A monthly report works well alongside the financial close because the ledger and expense accruals are available for reconciliation. A faster operating review can be useful, but label preliminary figures and replace them with closed results before treating movements as final.
Only when the allocation helps the decision and uses a stated, consistent basis. Keep a view before allocations so managers can distinguish identifiable costs from a corporate allocation. Whether allocated or separate, every shared expense must appear once in the company reconciliation.