P&L dashboard: revenue, costs, and margin against budget

A P&L dashboard compares revenue, costs, and profit margins with budget for the same reporting period. It should show which income statement lines explain the profit gap and which business units contributed to it. The essential check is that the business unit results and the variance explanation reconcile to the company statement.

An income statement dashboard measures performance over time. The SEC's financial statement guide distinguishes that period-based income statement from balance sheet balances at a point in time. Cash and liquidity belong in the broader financial dashboard template; this view stays with profit and loss.

Build the view from actual and budget files

Start with the closed general ledger or trial balance for actuals, plus the approved budget file. Both need period, business unit, account, reporting line, and USD amount. Preserve account identifiers so a dashboard line can be checked against the underlying ledger.

Map every account to one reporting line. Use one sign convention in the display: revenue and expense lines appear as positive amounts, while subtotal formulas subtract expenses. Preserve the ledger's original debit and credit signs in the supporting file.

Use the same accounting basis for actual and budget. IRS Publication 538 explains that accrual accounting generally reports income when earned and expenses when incurred, with the purpose of matching them in the correct year. For monthly management reporting, confirm that accruals and cutoff entries are included before treating the month as closed.

If you need the underlying account review, follow how to analyze a P&L. The dashboard summarizes that work rather than replacing it.

A worked P&L dashboard for a US distributor

The following September 2026 inputs come from a US distributor's mapped files. East and West contain all operating revenue and expenses. Interest and income taxes remain with central finance and are not allocated to either unit.

Combine matching source lines before calculating subtotals. Actual revenue is 600,000 + 400,000 = $1,000,000. Actual COGS is 390,000 + 280,000 = $670,000, and operating expenses are 150,000 + 100,000 = $250,000. Budget totals follow the same mappings.

Gross profit = Revenue − COGS

Operating profit = Gross profit − Operating expenses

Net profit = Operating profit − Net interest expense − Income tax expense

This example has no other nonoperating income or expense. If your company has those lines, show them explicitly between operating profit and tax rather than folding them into a unit's operating costs.

The revenue headline meets budget. Profit does not. COGS is above budget, interest expense is also higher, and a lower tax expense offsets part of the shortfall. The tax figures are supplied accounting expenses, not an assumed statutory tax rate.

Add margins beside the dollar results

Divide each profit subtotal by revenue for the same period and scope. Show the difference between rates in percentage points, calculated before rounding. All rates below use two decimal places.

The actual operating margin is 80,000 / 1,000,000 = 8.00%. The budget figure is 106,200 / 1,000,000 = 10.62%. A rate view makes the profitability gap visible even when revenue is on plan, while the dollar view shows its financial size.

Do not replace these calculations with an average of unit margin percentages. The company rate must use company profit and company revenue.

Find the business unit behind the gap

Calculate each unit's operating profit directly from its source rows. East actual is 600,000 − 390,000 − 150,000 = $60,000; its budget is 620,000 − 396,800 − 155,000 = $68,200. West follows the same subtraction.

West is the larger operating-profit shortfall even though its revenue exceeds budget. Its manager should investigate the COGS rows before attributing the gap to price, purchasing costs, or mix. East has a different review: revenue is below plan, partly offset by lower costs.

Finance owns the account mapping and reconciliation. Unit managers own explanations supported by the operating evidence. Put the action owner and next review date beside the explanation so the dashboard leads to a concrete follow-up.

Prove the variance bridge

Start with budget net profit of $68,200 and translate each line difference into its effect on profit. Revenue contributes zero. Higher COGS subtracts $26,200; operating expenses contribute zero; higher interest subtracts $2,000; lower tax adds $5,000.

The check is 68,200 − 26,200 − 2,000 + 5,000 = $45,000 actual net profit. The total change is −$23,200, matching the statement. Subtotal changes are checkpoints, so do not add the gross profit and operating profit variances again as separate causes.

A profit and loss template supports the statement layout. See a separate dashboard implementation for another approach to presenting these lines.

Where the review goes wrong

• Mixed reporting periods. A partial actual month compared with a full budget month produces an incomplete comparison.
• Different mappings. Moving an account between COGS and operating expenses changes margins even if total profit is unchanged.
• Treating every positive variance as favorable. Extra cost reduces profit; extra revenue generally increases it.
• Double-counting subtotal changes. Bridge the underlying lines once, then check the subtotals.
• Allocating central costs inconsistently. Either apply a documented allocation consistently or keep central items visible outside unit operating profit.

Review your own P&L files in Covirage

Upload actual and budget files with account, period, and business unit columns; Covirage maps the columns, and its tools compute and check line variances, margins, and totals. 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 files.

See FP&A reporting for related finance review questions.