This part of the spreadsheet is to help with your annual return. To access the section using the Menu, select Year End.
Despite the spreadsheet automating a lot of the analysis, there is still a considerable amount of work that needs your involvement.
On Row 6, to help when you come to file with OSCR, the pages on this worksheet are numbered. But, the Trustee’s Annual Report needs to go before the Statement of Receipts and Payments. Thus to ensure that the page numbering flows correctly, in cell E6, you can state how many pages the Trustee’s Annual Report is and the spreadsheet will factor this in.
In cell H6, there is a drop down that allows you to turn off the pale orange highlighting. The pale orange highlighting is where you need to enter information, but again to provide a clean print for filing with OSCR, you can deactivate the highlighting by selecting ‘Yes’.
The Spreadsheet automates all of the current year data relating to the receipts and payments, leaving:
- Total funds last period
- Transfers to / (from) funds
- The Statement of Balances
- Notes to the Accounts
On Section A, the ‘Total funds last period’, need to be entered. This is the total from last years Statement of receipts and payments. This is basically acting as a comparison between the current and previous periods. This should just be a matter of coping the totals from last years statement of receipts and payments.
Row 59, requires you to input if funds have been moved in-between Unrestricted, Restricted, Expandable and Permanent Endowments.
Section B, the Statement of balances, unfortunately is completely blank, the spreadsheet doesn’t ask for this information, thus both the current and previous periods needs to be entered.
Row 69 is asking for Bank Balances at the start of the year, again split between the four categories (Unrestricted, Restricted and Expendable and Permanent Endowments. The total of these four will show in G69. H69 is just the total from the period year.
Rows 71 and 72 are included for any adjustments. Based on the opening bank balance (row 69) and the surplus or deficit on row 70, the totals on row 73 should match your closing balance, of your bank statement. If it doesn’t it is more likely that there are entries on the bank statements that have not been entered into the spreadsheet. You are only going to use Rows 71 and 72 for say transfers between the funds.
The next three sections are unlikely to be used by most charities. If your charity has investments, other assets (not including the bank balance – that has been dealt with above section B1) or liabilities this is where they need to be entered. If you do need to use these sections, where is asks ‘Fund to which asset belongs’, this is referring to unrestricted, restricted, or the expendable or permanent endownments.
The accounts do need to be signed by at least one trustee.
Section C starts with the ‘Nature and purpose of the funds’, this is information about the restricted funds (there is space later to cover the unrestricted). Just a brief overview of the purpose of the restricted funds.
C2 Grants, this relates to whether your charity made a grant to another organisation or individual (it is not about any grants your charity received).
Next is C3a and C3b, your charity needs to declare whether the Trustee’s received any renumeration. If they did, then details need to be provided in C3b. As a general guide, provide as much information you can in the space provided, if renumeration needs to be merged due to a limited space, this can be done.
Next is C4a and C4b, again a declaration needs to be made as to whether the Trustee’s received any expenses, if they did then details need to be provided in C4b. As with the renumeration, is expenses need to be merged they can but make sure all of the pace is used to communicate as much information as you can
Next is C5 Transactions with trustees and connected persons. As it states, if the charity has had any transactions with any of the trustees then it needs to be detailed here. An example of this could be a Trustee was paid to deliver some training.
Finally, the purpose of the annual return is to inspire trust with the funders and service users. If there is any other information which any stakeholder would question about the running of the charity, then state that relationship or transaction here.
The Additional analysis (1) section only requires the previous period’s totals.
The Additional analysis (2) screen requires the totals from the previous year, along with any transfers between the funds.
As Additional analysis (2) is focused on the unrestricted funds, the final box here is to record the purpose of the unrestricted funds.
The final Additional analysis, number (3), is focused on the restricted funds. Again, just the previous years total and any adjustments between the funds needs to be entered.
That’s it, between the automated analysis and the extra pieces of information you’ve entered you now have a complete set of annual accounts to attach to the Trustee’s Annual Report. All you need to do now is arrange an Independent Examination and add that report to the end of the pack.