How to add a budget to a consolidated company

Upload group budgets, consolidate subsidiary budgets, merge entity forecasts, run budget vs actuals

This article explains the two ways to add a budget to a consolidated company in ScaleXP: loading a consolidated budget directly at the parent level, or building one up from subsidiary budgets. For an overview of budget options in ScaleXP, see How to set up budgets in ScaleXP (overview).


Where to add budgets in ScaleXP

Budgets can be added at both the subsidiary level and the parent (consolidated) level. The best approach depends on your reporting structure.

Important: If you upload a budget only to the parent entity, you cannot run budget vs actuals by subsidiary. For full reporting flexibility, upload budgets at the subsidiary level and consolidate at the parent.

To review, edit, and view budgets at the parent level, go to the Load Data tab and select Budgets and Forecasts in the sidebar on the left.

Budgets and Forecasts page at the parent level


Option 1 — load a consolidated budget directly

  1. Go to Load Data (top tab), then Budgets & Forecasts (left sidebar).
  2. Click Load new budget here.
  3. Follow the instructions in How to add a budget or forecast.

Load new budget here option on the Budgets and Forecasts page


Option 2 — build the budget up by subsidiary

First, import one or more subsidiary level budgets, following the steps in How to add a budget or forecast. Subsidiary budgets can be imported from either your accounting system or a ScaleXP format spreadsheet.

Subsidiary budgets imported into ScaleXP

Once one or more budgets have been uploaded at subsidiary level:

  1. Go to Load Data (top bar), then Budgets & Forecasts (left sidebar).
  2. Use the dropdown menus by entity to select the budget from each entity.
  3. Name the consolidated budget (top left of the selected budget section).

Once created and named, these budgets are available for use in all reports, dashboard charts and graphs, and presentations.

Selecting entity budgets and naming the consolidated budget

Tip: Manual entry budgets will have a report logo, whereas those uploaded from your accounting system will have the logo of the accounting system next to them.

Logos showing whether a budget was entered manually or imported from an accounting system