Variance attribution for finance teams
Varibridge tells you which customer, product, vendor or account moved the number, and proves that the answer foots to the ledger. In the app, and inside the Excel you already work in.
Connects to QuickBooks Online in minutes. No consultants, no implementation project. Commentary is computed from your books, not generated by an AI model.
| Line | Jun '26 | Δ ($) | Δ (%) | Commentary |
|---|---|---|---|---|
| Income | ||||
| Revenue | 1,178,432 | +247,428 | +26.6% | Meridian Healthcare +$48k (19%); Cedar & Co −$36k, lost; Lumen Studios +$27k, new. Volume +$214k, price +$74k, mix −$41k. |
| Cost of goods sold | ||||
| COGS | 422,798 | +87,688 | +26.2% | Hardware & Devices +$52k (59%). Vendors: Globex Materials +$27k, PrimeStaff +$16k. |
| Gross profit | 755,634 | +159,740 | +26.8% | Revenue +$247k (155%); COGS −$88k (−55%). |
| Operating expenses | ||||
| Salaries & wages | 309,120 | +36,819 | +13.5% | Engineering +$14k, Sales +$11k. Benefits +$6k. |
| Operating income | 248,163 | +72,158 | +41.0% | Gross profit +$160k; OpEx −$69k. |
The question every CFO asks
Dashboards tell you a number moved. Varibridge decomposes the movement across every dimension in your data and ranks the contributors by their share of the variance, with the price, volume and mix bridge alongside.
Each dimension gets a ranked table: current, compare, Δ, Δ%, share of variance, and whether a customer is new, lost, grew or shrank.
Where you have units, revenue and cost movements split into what you sold, what you charged, and how the mix shifted, line by line.
Gross profit, EBIT and net income decompose into their components first, then each component into its own drivers.
Prior period, prior year, budget, or your driver-based plan. Change the basis and every table and sentence recomputes.
| Customer | Current | Prior year | Δ ($) | Δ (%) | Share | Status |
|---|---|---|---|---|---|---|
| Meridian Healthcare | 549,400 | 416,600 | +132,900 | +31.9% | 11% | Grew |
| Cedar & Co | 0 | 108,500 | −108,500 | −100% | −9% | Lost |
| Northwind Traders | 297,000 | 199,300 | +97,700 | +49.0% | 8% | Grew |
| Lumen Studios | 84,200 | 0 | +84,200 | – | 7% | New |
| Vantage Logistics | 403,400 | 326,800 | +76,600 | +23.4% | 6% | Grew |
| Not attributed (no customer detail) | 2,877,721 | 2,363,594 | +514,127 | +21.8% | 41% | Not attributed |
| Total | 6,596,490 | 5,354,321 | +1,242,170 | +23.2% | 100% |
Excel, where the work actually happens
Insert an Explore sheet: a two-period income statement with Δ, Δ% and the commentary column, under a header block that records the data table, filters, result size and timestamp. Click any line and drill to every detail row behind it, or pivot it by customer, vendor, account or entity. Every sheet is an Excel Table you can filter, pivot and paste into the board pack.
=VB.GET("revenue","2026-06") for a number, =VB.DRILL(...) to spill the drivers into a range, =VB.TABLE(...) for any dataset.
No add-in required for a refreshable table: every dataset is a URL that Power Query reads in one step.
=VB.GET("gross_profit","2026-04","all","actual","2026-06")Connect
Connect an entity's accounting system and Varibridge maps accounts to a canonical statement, tags product lines and departments, and rolls entities up with FX and intercompany eliminations. Multi-entity groups get a consolidated P&L with an Eliminations column, and every drill-down still knows which entity each row came from.
Revenue planned as volume × price per product line, COGS at unit cost, headcount by department. The plan is the budget basis, so "vs plan" attribution uses real budgeted units.
An ensemble forecast per metric, backtested on the months it did not see, with the error shown next to it rather than hidden.
Budget misses, margin compression, overdue receivables, burn. Each alert names its largest driver on the same basis you chose.
Monthly review and board package templates that carry variance commentary forward month to month, published as immutable versions.
Click a figure anywhere and trace it: formula to components, components to GL accounts, accounts to customer sales or vendor bills.
Read-only, org-scoped keys give Power Query, BI tools and your own scripts the same datasets the app and the add-in use.
How we show our work
Most "AI commentary" is a language model's opinion about your numbers. Varibridge's commentary is a computation: the same inputs give the same sentence, every figure in it can be clicked back to a ledger row, and when data is missing, it says so.
Every driver table sums to the P&L line, in both periods. Shares are shares of the metric's variance, not of a partial.
No customer-level budget? The table shows the actual split and marks the shares unavailable rather than inventing them.
Every Excel sheet opens with the data table, rows, columns, filters, options, result size and timestamp it was built from.
Questions
Connect QuickBooks, pick a month, and read why it moved. Thirty days free, no card.