Management Accounts – Departmental model

Management Accounts in an Excel SpreadsheetNot so much a Management Accounts Excel template, more a model that can be adapted to suit a wide variety of circumstances.

More updating of our Management Accounts Template was carried out recently and to avoid confusion it was re-named as the Departmental model.

Not quite what you are looking for? Try our alternatives – “Light” management accounts” version here, or our “Multi-unit” management accounts version here.

What are the latest updates to our best selling Management Accounts Template

We have recently made the following improvements:

Removed the need for a macro button to update budget numbers. This has been replaced by a hidden macro triggered by selecting a month from the drop down month selection list.

Moved the Chart of Accounts information from the Trial Balance sheet to a separate sheet making the information a lot less cluttered.

Some “under the hood” changes to the macros making them simpler, shorter and quicker to activate.

The editable version of this worksheet is without restrictions and passwords, allowing you to freely view and change the code etc, to meet your own requirements. Price will be subject to the current rate of UK VAT where applicable.

We recommend that you add our email address ( to the contacts in your email program to help prevent our emails from going into the spam/junk mail folder.

We do require your email address in order to send the link to your free worksheet, and it would be good to use your name in a personal thank you. Our privacy policy is your assurance that any personal information is safe with us.