P&L Variance Bridge
Paste two periods of P&L lines and get the bridge that explains the movement, every driver ranked by contribution, with a waterfall you can read out in a meeting. The chart Excel makes you build by hand.
How do I build a P&L variance bridge?
Take the same set of line items across two periods, calculate the movement on each line, then rank those movements by absolute contribution to the total change. The result is a bridge that walks from the prior period figure to the current one, showing which lines drove it and in what order of size. Building this in a spreadsheet means a difference column, a sort, a running total, and then a waterfall chart assembled from stacked bars with invisible spacer series, roughly twenty minutes of work that has to be redone every time a line moves.
How to use this tool
- 1
Paste both periods
Line item, prior period, current period. One row per line, straight from two P&L exports.
- 2
Read the bridge
A waterfall from prior total to current total, with every driver in order of contribution and colour-coded by direction.
- 3
Take the top drivers
The ranked table gives you the three lines that explain most of the movement: the version you actually read out in the meeting.
The largest movement is not always the one to explain
A bridge ranks by size. Deciding which movements matter takes four further judgements the chart cannot make for you.
Offsetting movements net to nothing
Two lines moving in opposite directions can leave the total nearly unchanged while both represent real events. A bridge built only at the summary level shows a flat quarter and hides them both.
Timing versus structural
A cost that shifted between periods creates a movement in both and means nothing for the forecast. A price increase creates a movement that repeats indefinitely. The chart renders them identically.
Percentage against a small base
A line that moved 400% from a $2,000 base is noise. A line that moved 3% from a $4,000,000 base is the story. Ranking by percentage rather than absolute contribution inverts the priority.
Mix inside a stable total
Revenue flat at the total level while the mix shifts from high-margin to low-margin product produces no revenue movement and a real margin problem. Bridging revenue alone never surfaces it: you have to bridge margin too.
The bridge shows what moved, not why
Every bridge produces the same next question: why did that line move, and does it repeat. Answering it means going below the line into the transactions, joined to vendors, headcount changes, contract terms, and the same period last year. That is the work that turns a two-minute chart into a two-day analysis, and it starts over every month with slightly different lines and a slightly different question.
See how DataWyse answers thisQuestions finance teams ask about this tool
What is a P&L bridge?
A visualisation that walks from one period's result to another, showing each line item's contribution to the change as a step up or down. It answers the question a variance table leaves open, of everything that moved, which movements actually explain the difference.
Should I bridge revenue, gross profit, or net income?
Bridge whichever line the audience asks about, and be ready with the level below it. Boards usually ask about the bottom line and then immediately want the gross margin bridge underneath, because that is where mix and pricing effects become visible.
How many drivers should a bridge show?
Five to eight named steps with everything else grouped into an 'other' bucket. Beyond that the chart becomes unreadable and stops doing the job of directing attention, which is the only reason to build a bridge rather than show a table.
How do I handle lines that appear in only one period?
Treat them as full movements: a new cost line is a step down for its entire value, and a discontinued one is a step up. Flag them separately in the commentary, because a new line is a structural change rather than a variance on an existing one.
What is the difference between a bridge and a variance report?
A variance report lists every line's difference. A bridge orders those differences by contribution and shows how they accumulate into the total change. The variance report is for investigation; the bridge is for explaining the result to someone who has two minutes.
Is this tool really free?
Yes. No signup, no email required, no usage limit. It runs entirely in your browser: nothing you type is uploaded to a server or stored anywhere. We build these because the people who find them useful are the people who eventually need a financial analyst that works the same way.
DataWyse answers the next thirty
Variance deep-dives, cash re-forecasts, scenario plans, board prep: asked in plain English, answered in minutes, with every number traceable to its formula and source data.