Management Accounts – Multi Unit version

Excel Spreadsheet

A new Excel template in our Management Accounts range. This Multi Unit version is ideal for use where a unit, section or department within an organisation has a separate trial balance. This template will create the departmental profit and loss, and balance sheet reports in a clear and modern way. This Excel template also consolidates the departments into whole company reports. All the reports show Current period, Year to date, and Previous period YTD, compared to Budget with the variances calculated. Our Excel work file example contains just three units, but this can be increased quite easily by creating a copy worksheet. Try it for yourself and give us your feedback.

A video to show how it works in practice will be available soon. Check out our You Tube channel for more video tutorials. Meanwhile contact us if you have any questions or if you would like this template adapted for your own club or society.

At Accountancy Templates, we are constantly looking to update and improve our templates. These changes will always be in the unlocked versions of our templates, but not necessarily in the free download version. So to ensure you get the most up to date templates, you will need to make a small investment in the password-free version.

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.