Installation instructions for annual accounts system

1. Software requirements

You will need Microsoft Excel 2003 or later

2. Downloading files from the website

Download the workbook by clicking here: Annual accounts system 1.3.

Once it is downloaded, open it in Microsoft Excel.

3. Making sure the system will work correctly on your computer

The system uses macros – automated instructions which make the various buttons work. The accounts system won’t work unless macros are enabled. We have digitally signed the macros, which gives a guarantee that they are not harmful.

You need to let your computer know that you want the macros to be enabled when you are using this system. How you do this depends on which version of Excel you have.

3.1 If you are using Excel 2003

Set your security settings to High or Medium. You do this by going to the Tools menu, choose Macro, and then look on the Security tab. If you have never changed this setting before, it is probably already set to High.

The first time you open the document, you will see a message with information about the security certificate. It should look like this:

Screenshot of Excel 2003 Security message

Tick the box that says Always trust macros from this publisher. Then click the Enable Macros button. When you open the document in future, you shouldn’t get any security messages about macros and the system should work fine.

3.2 If you are using Excel 2007

When you first open the spreadsheet, a message bar will appear at the top of the screen, like this:
Screenshot of Excel 2007 Security message bar

Click the Options… button and you will see this box:
Screenshot of Excel 2007 Security message

Choose Trust all documents from this publisher and click OK. The spreadsheet should now work properly and you won’t need to do this again.

3.3 If you are using Excel 2010 or a later version

The first time you open the document, a yellow message bar will appear, like this:
Screenshot of Excel 2010 Security message bar

Click the Enable Content button. This will mean the document becomes a Trusted Document, and should open without problems in future. You will need to repeat this at the start of each year, when you are working on a new document.

To avoid this, you could add the Resource Centre to your list of Trusted Publishers. This means any document published by the Resource Centre will automatically be a Trusted Document.

To add a Trusted Publisher:

  • Click File.
  • The Microsoft Office Backstage view appears. In the Security Warning area, on the Enable Content button, click the down-arrow. Select Advanced Options to learn more about the publisher.
  • A box will appear, with information about the digital signatures for the file
  • Click Trust all documents from this publisher
  • Click OK.

4. Saving the workbook on your computer

Click Save As in the File menu in Excel.

Choose a place in your computer filing system to store these files.We suggest you create a new folder for the accounts system. You could call this Accounts.

Give the spreadsheet a name, which we suggest could include your group name and the current financial year.

Click Save. This will be your new accounts system.

It is a good idea to also make a second blank copy, before you start using the system. You can keep this so that you don’t have to download it again next year. To do this, click Save As again in the File menu in Excel. This time, name it “Blank accounts system”.

At the start of each financial year, open the blank copy and click Save As, to save a new version. Name the new version to reflect the relevant year (for example Accounts 2011-12.xls).

This way, you won’t enter figures into the blank workbook, and it will still be there for you to copy over at the start of the following year. Don’t worry though – you can always just download another copy from our website if you need to.

Updated February 2018

Would you like to make a donation?

We hope you find this page useful. Would you like to make a donation?

All Resource Centre information is available for free because we know small community groups have small budgets. However, we are a small charity, so if you are in a position to make a donation, it will help us to keep running this service into the future.