Blog · Board and management reporting · Finance and FP&A teams
A P&L dashboard explains how revenue, cost and departmental variances produce the month's operating result. This worked example reconciles actuals to budget, bridges the profit movement and tests one changed expense.
A Power BI P&L dashboard should explain how revenue, costs and departmental changes produced the month's profit. The useful summary compares actuals with a clearly labeled budget or prior period and reconciles back to the closed ledger. A variance chart earns its place when the reader can identify the account, owner and amount behind each movement.
The SEC's guide to financial statements describes the income statement's progression from revenue through costs and operating expenses. That progression gives the dashboard its structure: net revenue, cost of goods sold, gross profit, operating expenses and the resulting operating profit. Include financing and tax lines when the review extends to net income.
Microsoft defines a Power BI dashboard as a single page of highlights connected to underlying reports. Keep that summary centered on the month's result and its largest explanations. Account and department detail should support the summary rather than compete for space with unrelated balance-sheet measures.
The general P&L dashboard covers the broader layout. This example concentrates on an account-level reconciliation and a monthly profit bridge. Covirage is not affiliated with Microsoft Power BI.
Use a ledger export for one closed accounting period, with entity, account code, department, posting date and amount. Include the approved budget for the same entity, period, accounts and departments. Retain the chart-of-accounts mapping that places each account into a P&L line.
Normalize signs before presenting the table. Here, revenue and expenses are both displayed as positive amounts, and profit is calculated by subtracting expenses. The original ledger may use credit and debit signs; preserve those original amounts so the display transformation can be checked.
Write down the treatment of returns, accruals, freight and shared costs. A change in account classification can move gross margin without changing operating profit. The gross profit margin explanation covers the revenue and cost-of-goods-sold relationship; use the same definitions in every review period.
Juniper Office Distribution is an illustrative US wholesaler reviewing September 2026. The simplified export below contains the complete operating P&L for the example. Outbound freight sits in operating expenses under this company's consistent reporting policy; interest and taxes are outside this view.
| Account group | Responsible department | Budget (USD) | Actual (USD) | Actual minus budget (USD) |
|---|---|---|---|---|
| Net sales | Sales | 900,000 | 950,000 | 50,000 |
| Merchandise costs | Operations | 540,000 | 560,000 | 20,000 |
| Sales payroll | Sales | 90,000 | 95,000 | 5,000 |
| Outbound freight | Operations | 50,000 | 62,000 | 12,000 |
| Administration | Corporate | 80,000 | 78,000 | −2,000 |
These account groups are mutually exclusive. Net sales includes the period's discounts and credit adjustments. Merchandise costs contain the cost of the goods sold, while sales payroll, outbound freight and administration make up the operating expenses shown below.
Gross profit = Net sales − Cost of goods sold
Operating profit = Gross profit − Operating expenses
Operating margin = Operating profit / Net sales
| P&L line | Budget calculation | Budget (USD) | Actual calculation | Actual (USD) |
|---|---|---|---|---|
| Net sales | Source row | 900,000 | Source row | 950,000 |
| Cost of goods sold | Merchandise costs | 540,000 | Merchandise costs | 560,000 |
| Gross profit | 900,000 − 540,000 | 360,000 | 950,000 − 560,000 | 390,000 |
| Operating expenses | 90,000 + 50,000 + 80,000 | 220,000 | 95,000 + 62,000 + 78,000 | 235,000 |
| Operating profit | 360,000 − 220,000 | 140,000 | 390,000 − 235,000 | 155,000 |
Actual operating margin is $155,000 / $950,000 = 16.32%. Budget operating margin is $140,000 / $900,000 = 15.56%. Margins are rounded to two decimal places; dollar calculations use the unrounded source amounts.
The raw variance column needs interpretation. Extra revenue adds to profit; extra expense subtracts from it. Convert each account movement to its effect on operating profit before adding the bridge.
| Driver | Calculation of profit effect | Profit effect (USD) |
|---|---|---|
| Higher net sales | 950,000 − 900,000 | 50,000 |
| Higher merchandise costs | 540,000 − 560,000 | −20,000 |
| Higher sales payroll | 90,000 − 95,000 | −5,000 |
| Higher outbound freight | 50,000 − 62,000 | −12,000 |
| Lower administration | 80,000 − 78,000 | 2,000 |
| Net profit movement | 50,000 − 20,000 − 5,000 − 12,000 + 2,000 | 15,000 |
Budget profit of $140,000 plus the $15,000 bridge equals actual profit of $155,000. That is the central proof. Every driver comes from an account row, and no unexplained balancing amount is needed.
Department ownership makes the discussion actionable. Sales owns the revenue and payroll explanation; Operations owns merchandise costs and freight; Corporate owns administration. These are account-level profit effects assigned to departments, not standalone departmental profit figures. Allocating shared revenue or expenses would require another explicit rule.
The bridge shows where the dollars changed. It does not establish why sales increased or freight rose. Ask the owners for volume, pricing, shipment and accrual evidence before attributing causes. The P&L management discussion covers the operating follow-through after the reporting review.
Suppose the actual outbound freight amount had been $50,000 rather than $62,000. Hold every other actual account unchanged. This variation isolates the effect of one input; it does not assume that freight can be reduced without an operational trade-off.
| Measure | Reported actual (USD) | Freight variation (USD) | Calculation for variation |
|---|---|---|---|
| Outbound freight | 62,000 | 50,000 | Changed input |
| Operating expenses | 235,000 | 223,000 | 95,000 + 50,000 + 78,000 |
| Operating profit | 155,000 | 167,000 | 390,000 − 223,000 |
The $12,000 lower expense raises profit by $12,000. Operating margin becomes $167,000 / $950,000 = 17.58%, up from 16.32%. Margin rises by $12,000 / $950,000 = 1.26 percentage points, using unrounded margins for the difference. Revenue and gross profit stay the same because this company's freight classification sits below gross profit.
Before publishing, tie each account group's actual amount to the closed ledger export. Account mappings must assign every included record once, with unmapped accounts reported as exceptions. Reconcile budget totals separately to the approved budget version, then prove that the profit bridge closes.
A workbook dashboard can present the same reconciled P&L, while an executive dashboard can carry the result and largest drivers into the wider business review.
Bring a sample of your own ledger and budget files, or a Google Sheet with period, account, department and amounts. Covirage maps the columns, and its tools compute and check the figures; the external AI model explains the variances with every figure traced to its rows. Create a free Covirage account, then set up your business and bring your exports.
See FP&A reporting for the supporting approach to monthly financial reviews.
Include net revenue, cost of goods sold, gross profit, operating expenses and operating profit, with budget and variance columns. Add interest, taxes and net income if those amounts are in scope. State the period, accounting basis and close status beside the summary.
Choose a sign convention and label it. Actual expense minus budget shows overspending as positive, but a profit bridge treats that overspending as a negative contribution. Showing both raw change and profit effect prevents a favorable-looking color from obscuring the accounting direction.
Missing department codes, duplicated account mappings, unallocated corporate expenses and eliminations can create differences. Reconcile the complete account population first. Then show shared costs and allocation rules explicitly, so department subtotals can be rebuilt into the reported company result.