Add a budget and compare it with actual figures
You can keep a budget and a latest estimate for each company or for the whole group, each in several versions with one active. Plans are typed into a grid or uploaded as a CSV file. When there is no group plan, the group budget is the sum of the companies' plans.
Budget or latest estimate
A budget is the plan set for the year. A latest estimate is a revised view of the year from where things now stand. Finconsol keeps them side by side, and uploading or activating one does not change the other.
For a company or the whole group
Choose who the plan is for: one company, or Consolidated (the whole group). A company's plan is separate from the group plan. When the group has no plan of its own, the group budget is the sum of the companies' plans.
Enter a plan
- Upload a file. A CSV file with one row per profit and loss line and the twelve months across, or one row per line and month. Download the template, choose Check the file, and save it once every row passes.
- Enter manually. Type an amount for each line and month in the grid. A blank cell means no budget, which is different from zero.
- Start from an existing plan. Copy another plan into this year's months, with a growth percentage applied to every profit and loss line. Nothing is saved until you check and save.
Versions
A year can have several versions of each plan, each with its own label, and one is active. Under Budget versions, choose Make active, Set aside or Delete.
Compare with actual figures
Reports show actual, budget and variance for each line, as an amount and a percentage, marked ahead or behind, for the period and the year to date. A custom report can also show the latest estimate and the variance to it. Where a plan covers only some of the months or lines, the variance is left out rather than shown against a partial plan.