How to complete the last 12 months worksheet

TranscriptLink to this section

"In the last video, we introduced you to the full financial data workbook.

Now I'll talk you through how to complete the first worksheet on tab one. This is your venture's historical data for the last 12 months [video is displaying the ‘last 12 months’ tab which is the first tab in the worksheet].

If you haven't already, collect your historical data by using your records, bank statements, and receipts to determine the income you've received and the costs you've incurred each month over the last 12 months. This is from the month you are applying in.

Enter your venture name at the top [video navigates to the cell where you should enter the venture name]. For this tutorial, we've used a fictitious social enterprise so you can see what the completed spreadsheet looks like when finished.

Month 12 should be the month you're applying in. If you're unsure whether to include a partial month, it's OK, just make a note on your assumptions. So if you're applying in August 2025, you would label the month 12 column August 2025, then work backwards to month one, labelling each column accordingly [video navigates to the cells where the months should be entered].

Then enter your balance brought forward [video navigates to the cell where you should enter the balance brought forward]. This is the amount of money you had in your account at the start of month one. It's very important that you include this so that we have the whole picture of your current finances.

Now we come to the data entry. You can adapt and add to the headings which best fits your venture. Income should be broken down into sensible headings in enough detail so we can understand the different types of income that the venture generates [video navigates to example headings which are café sales, merchandise, and workshops]. As you can see here, traded income can include sales, workshops and sale of services. Other income includes grants and donations [video navigates to the other income section].

Once you've added all of your income, find the total income [video navigates to the right of the worksheet where the total income is displayed]. This figure should match your answer to the question, ‘what was your last 12 months turnover’ in your application form? Similarly, the total of the traded income should match your answer to the question ‘how much of the money made was traded income’?

Now we can look at expenditure [video navigates to the expenditure section, showing examples of typical types of expenditure]. Expenditure can include, but not limited to salaries, rent, professional fees, IT costs, travel materials and insurance. Again, the expenditure type should be broken down into headings we can easily understand.

In the next video clip, we'll walk through the information we need for the financial forecast."