Opex Variance report from Xero / MYOB / SAP / Excel

Report on opex variance (budget − actual) from a Xero / MYOB / SAP / Excel export, tracked month by month against your own target. ReportInSite runs in your browser, so the file is read on your device and nothing is uploaded.

Try it with sample data Open the tool →

How to export it

Export a budget-vs-actual report to Excel or CSV with one row per cost centre (or team) per month: Xero (Reports → Budget Variance → Export → Excel), MYOB (Budget analysis → Excel), SAP (cost centre report → Spreadsheet). Positive = under budget.

Report

Budget variance by month, operating expenses, by tracking category / cost centre, last 6 months

Then open ReportInSite, go to the Data tab, choose Export from any app, pick Opex variance (budget − actual) and load the file. The recipe fills in the column mapping and the calculation; you can change any of it before importing.

What you get

This recipe feeds Financial › Opex Variance. It rolls into the steering scorecard, the portfolio roll-up, trends and the PDF packs alongside every other source.

Steering scorecardThe value lands on Financial › Opex Variance for each team, scored red / amber / green against your target.
Portfolio roll-upEvery team side by side on the heatmap, whichever tool each one uses.
TrendsDated rows fill earlier months, so the direction of travel is there from the first import.

For the full financial report (budget vs actual by cost line and month, outlook and bridge), see Playbook section 7.

Related reports

Every recipe, with export steps for each app, is in the Playbook under Data from any app. No recipe for your app? The custom mapper reads any CSV or Excel table.

Nothing to install, nothing to upload.

Try it with sample data All reports →