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.




2 Responses to “Management Accounts – Departmental model”

Read below or add a comment...

  1. John Barnes says:

    Thanks for the opportunity to look at this. I can see it would be valuable to those who are used to using spreadsheets and want to use specific parts for reports. I wonder if I could share with you my ideal.
    Say a bookkeeping job has 30 P&L nominal codes and 15 Balance Sheet Codes plus the usual Depreciation and VAT elements. An ideal way reporting would be to present a matrix of P&L and BS nominal codes, plus time periods, say months, and be able to select by clicking on the matrix, which codes and which periods to include – and then (icing on the cake) to be able to drill down from the report (say by double click) to that nominal code activity, then to individual bookkeeping entries – a sort of automatic search facility.
    This would be ideal for drafting management reports and VAT returns as well as comparing budget to actual.
    Am I in fantasy land by any chance?
    Thanks for all the good work. John

    • Derek says:

      Hi John, Thank you for your comment. Not in fantasy land by any means. As long as the bookkeeping entries have sufficient detail, then it is reasonably easy to create a BS and P&L using an Excel Pivot table. A pivot table has the drill down facility that you require. Further pivot tables can be created from the original data (bookkeeping entries) for VAT returns, management accounts etc. In the past I have created something similar from data extracted from Sage programs where the reports did not meet the management requirements. Derek