title.png (7534 bytes)

Consolidated Budgeting

Please see also Financial Excel Collection - just for $169.95 - contains Consolidated budgeting and many other financial Excel templates.

Consolidated Budgeting features:

- P & L Budgeting and reporting

- Divisional profit & loss budget templates, combined into a Consolidated Budget, plus actuals, and combined year to date variance reporting by P/L division and for the company.

Index of templates:

Index of templates 1altIndex of templates 2

Starting Consolidated Budgeting

Starting Company Budget and P/L Divisions Set Up page
Click to enlarge

Allocate overheads (management charges in the demo) to profit divisions.

Allocate overheads (management charges in the demo) to profit divisions
Click to enlarge

Consolidated Budgeting allocates actual central overhead costs to divisions each month (When you select "Yes – Allocate to Budgets & Actuals" in the Allocate Overhead selector option in the screen above).

You can change monthly percentage allocation rates for any monthly period if you wish.

You can change monthly percentage allocation rates for any monthly period if you wish
Click to enlarge

The next screen shows the 100% revealed template for all budgets.

The next screen shows the 100% revealed template for all budgets
Click to enlarge

Apply Format > Row > Hide to hide unwanted (unfilled) rows and create smarter presentations.

Budget 2 has all empty rows hidden.

Budget 2 has all empty rows hidden
Click to enlarge

All Budgets are totalled and rolled into the Consolidated Budget for the budget year.

Consolidated Budget for the budget year
Click to enlarge

For each Budget pro-forma there is a corresponding reporting (monthly actual) template.

For each Budget pro-forma there is a corresponding reporting (monthly actual) template
Click to enlarge

Budget, Actuals & Variances for each P/L center plus totals are reported to any selected month end date.

Budget, Actuals & Variances for each P/L center plus totals are reported to any selected month end date
Click to enlarge

Each division/p&l center reports its Budget – Actual – Variance summary for the reporting month end, and cumulatively year to date.

Each division/p&l center reports its Budget – Actual – Variance summary for the reporting month end, and cumulatively year to date
Click to enlarge

Same report as above with unwanted rows hidden produces a neater summary.

Same report as above with unwanted rows hidden produces a neater summary
Click to enlarge

Year to date summary for all divisions.

Year to date summary for all divisions
Click to enlarge

Short Year to Date summary supplies an easier company review profile.

Short Year to Date summary supplies an easier company review profile
Click to enlarge

Plus: Quick Look Up reference benchmarks by industry sector for US companies.

Gross margin, expenses and profit benchmarks are as reported for the third quarter 2003.

Gross margin, expenses and profit benchmarks are as reported for the third quarter 2003
Click to enlarge

 

System Requirements

Excel 2000 or  above and MS Windows (all).

Additional Information: Consolidated Budgeting

30 day money-back guarantee!

Buy Online

buy.gif (540 bytes)

$139.95

Please see also Financial Excel Collection - contains Consolidated Budgeting and many other financial Excel spreadsheets for just $169.95

Additional Information: Financial Excel Collection
30 day money-back guarantee!

Buy Online  $169.95

buy.gif (540 bytes)
 

Copyright © Millennium Software All Rights Reserved