If you need help with consolidating your accounts then have a look at our 2 methods shown below that can be used in a variety of ways, as follows:
Accounts Consolidation in Excel 1
Accounts Consolidation in Excel 1 demonstrates two alternative methods, running a macro or applying a Sum formula, for consolidation of tables that have identical layouts.
Accounts Consolidation in Excel 2
Accounts Consolidation 2 has the very special feature, not easily available on the internet, of consolidating statements or accounts that are not necessarily in the same format. For example, in sheet North there is no department B. Yet, the department totals of all the sheets are correctly consolidated on the Consolidation sheet. Also, see our Management Accounts templates, one of which consolidates units or departments in different formats.
Both templates are included in the package. There is accessible below a free sample download as well as a purchased version with access to all the formulas and the VBA code.
Also, have a look at our other management information and accounting packages: our newly-upgraded Management Accounts templates, Cash Accounting System and Complete Accounting System in Excel (CASIE) .
On clicking the Download FREE Spreadsheet button, an email will be sent to you with the restricted template attached. Please note that it may take some time for the email to appear in your email Inbox.
Our macros are entirely safe and secure so please ignore messages that warn of risks to the security of your files from running our macros.
Scroll down to buy the editable version of this worksheet, which is without restrictions and passwords, allowing you to freely view and change the code etc, to meet your own requirements.
We recommend that you add our email address (sales@accountancytemplates.com) to the contacts in your email program to help prevent our emails from going into the spam/junk mail folder. Should you wish to contact us for any matter whatsoever, please complete the contact details on the Contact Us page and click on ‘Submit’.
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.