Consultants
Menu
Services
Bookkeeping servicesCIC accountsCIC formationCompany secretarial servicesCorporation tax returnsGrant reportingHMRC investigation supportLimited company accountsMaking Tax DigitalManagement accountsPartnership accountsPayroll servicesSole trader accountsSwitching accountantsAll servicesWho we help
Accountants for cafesAccountants for CIC start-upsAccountants for community interest companiesAccountants for community organisationsAccountants for convenience storesAccountants for ecommerce sellersAccountants for family businessesAccountants for fast food franchisesAccountants for franchise ownersAccountants for freelancersEveryone we work withLocations
Accountants in BarryAccountants in BristolAccountants in CaerphillyAccountants in CardiffAccountants in NewportAccountants in Port TalbotAccountants in SwanseaAll locationsServices near youFirm
GuidesBlogAboutContact Start the checkGrant budget and forecast template guide for community interest companies
This is for CIC directors and grant funded organisations in South Wales who have a bid to submit and a budget sheet to fill in. We go through what belongs in the template, how to build the twelve month forecast, and how the same sheet becomes your quarterly spend report later.
Updated 22 October 2026
11 min read
- The short version
- What this guide covers
- What funders ask to see in your budget
- What goes in the budget, line by line
- How to build the twelve month cashflow forecast
- Why the assumptions page decides the bid
- Building the template step by step
- Where grant budgets go wrong
- When to get an accountant involved
- Frequently asked questions
The short version
- A working grant budget and forecast template is one file with three tabs: the budget, a twelve month cashflow, and written assumptions.
- Welsh funders usually want at least twelve months of figures, and many application packs include their own sheet you have to use.
- Use the same cost headings in the budget as in your bookkeeping, so the quarterly spend report is a comparison rather than a rebuild.
- Grant money sitting in the bank is deferred income until you meet the conditions and incur the spend it was given for.
- A CIC answers to the asset lock, transparent directors’ pay and the annual CIC34 report, and funders read all three.
What this guide covers
Almost every funding application asks for two financial documents, and almost every first draft we see gets them muddled. This grant budget and forecast template guide separates them. The budget says what the money will be spent on and under what headings. The forecast says when cash comes in and goes out, month by month, so the funder can see you will still be solvent in month seven when the second payment is late.
Welsh Government and Business Wales guidance expects a newly formed organisation to submit a business plan with at least twelve months of financial forecasts. Several local council prospectuses go further and ask you to show a clear budgeting process and evidence that the organisation can manage money. Those are not separate hoops. One well built spreadsheet answers both.
We write quarterly and six monthly spend, budget and forecast reports for more than ten community interest companies in and around Cardiff, so we see what happens after the bid is won as well. The template you build now decides how painful the first reporting deadline is. The rest of this guide covers the cost headings, the cashflow rows, the assumptions page, how grant income is recognised in your accounts, and the mistakes that cost CICs money.
What funders ask to see in your budget
Funders are checking three things. Can you deliver the activity for the money you have asked for. Will the organisation still be going at the end of the funded period. Can you account for every pound afterwards.
The documents that usually get requested
- A project budget showing income and expenditure under named headings for the funded activity.
- A twelve month cashflow forecast, often on the funder’s own downloadable sheet.
- Your last set of filed accounts, or forecasts and a business plan if you are newly formed.
- A short note on your reserves and what other income you have.
Use their sheet when they give you one
If the application pack includes a cashflow template, fill in that file. Assessors read dozens of bids and look at the same cells each time. Submitting your own layout makes them hunt, and a tired assessor who cannot find your staff costs marks you down on financial management rather than asking.
Where the funder gives you no template, build your own and keep it simple: one tab for the budget, one for the twelve month cashflow, one for assumptions. Export it to PDF for the bid and keep the live spreadsheet for yourself.
Before you type a number, write down the funder’s financial year, their reporting dates and their payment schedule. Those three facts shape the whole sheet.
What goes in the budget, line by line
The budget is a list of cost headings with a figure against each, totalling the amount you are asking for plus anything you are putting in yourself.
Headings that cover most CIC projects
- Staff costs: gross pay, employer National Insurance, employer pension contributions, and cover for holiday and sickness.
- Freelance and sessional costs: tutors, facilitators, interpreters, with a day rate and a number of days.
- Delivery costs: venue hire, materials, equipment, transport, refreshments.
- Participant costs: expenses, childcare, accessibility support.
- Overheads: a fair share of rent, insurance, software, bookkeeping and payroll.
- Monitoring and evaluation: the cost of producing the reports the funder has asked for.
Show your working
A line that reads “Sessional staff 12,000” invites a question. A line that reads “Sessional tutor, 2 days a week for 40 weeks at a stated day rate” answers it. Funders rarely argue with arithmetic they can follow.
VAT
If your CIC is not VAT registered, budget every cost at the gross figure you will actually pay, VAT included. If you are registered and can recover the VAT, budget net and say so in the assumptions. Getting this wrong by a fifth on materials is the quickest way to run short in month nine.
Once the headings are set, copy them across to the cashflow tab before you spread any figures.
How to build the twelve month cashflow forecast
The cashflow forecast takes the same budget headings and spreads them across twelve columns, one per month, then adds a running bank balance. It is the part of the pack assessors look at hardest, because it shows whether the project can actually be delivered in the order you have described.
The rows you need
| Block | What goes in it |
|---|---|
| Opening balance | Cash in the bank on day one of the month |
| Money in | Grant instalments, trading income, donations, other funders |
| Money out | Each budget heading, in the month the payment leaves the account |
| Closing balance | Opening plus in, less out, carried to the next month |
Timing is the whole point
Put grant instalments in the month the funder says they pay, not the month you sign. Many funders pay in arrears or hold back a final instalment until the end report is accepted. Payroll leaves on the same date every month, PAYE goes out by the 22nd, and a venue invoiced in March may be paid in April. If the closing balance goes negative in any month, say what you will do about it on the assumptions tab rather than hoping nobody scrolls.
Build the sheet with formulas, so when one figure changes the whole year updates. Lock the total cell and check it still matches the amount you are requesting.
Why the assumptions page decides the bid
The assumptions tab is a page of short written notes explaining where each figure came from. It takes twenty minutes and it is the difference between a budget an assessor trusts and one they query.
What to write down
- Pay rates used, and whether you have allowed for an increase part way through the year.
- Quotes obtained: supplier name, date, figure.
- Participant numbers and the cost per participant.
- The basis for apportioning overheads, for example a percentage of rent based on room use.
- Confirmed income against applied for income, with dates.
- Your VAT position.
It protects you later
Twelve months on, the person who built the spreadsheet may have moved on and the funder is asking why line four came in over budget. A dated assumptions page answers that in one email. Without it, somebody spends a day reverse engineering their own sheet.
Funders also read the assumptions page as evidence of the clear budgeting process the council prospectuses ask about. You are showing the method, not the finished number.
Save the version you submitted, date the filename, and never overwrite it. Your reporting later compares actual spend against the submitted budget, so you need that exact file intact.
How grant income is recognised in CIC accounts
Money in the bank and income for the year are different things, and this is where CIC accounts most often go wrong.
The rule in short
You recognise a grant once you have met the conditions attached to it and receipt is reasonably assured. A three year grant paid up front in year one does not become three years of income in year one. The unspent portion sits on the balance sheet as deferred income until you deliver the activity it pays for.
Which standard applies
Older articles still quote SSAP 4, which was replaced when FRS 102 came in. Government grants now sit in Section 24 of FRS 102, and you choose between the performance model and the accrual model. Revenue grants are matched to the costs they fund. A capital grant for equipment is spread over the useful life of the asset, alongside the depreciation charge. Grants from charitable trusts and lottery distributors follow the same logic: recognise when you are entitled and the amount can be measured.
Clawback and tax
If you breach the grant conditions the funder can ask for some or all of the money back, and where that looks likely it has to be provided for in the accounts. Tax does not follow the accounting treatment automatically either. Some grants are taxable income for corporation tax with the matching spend deductible, others are outside the scope. Check the funding agreement and ask before you file.
Set your restricted funds up as separate tracking categories in your bookkeeping now, and read our restricted and unrestricted funds guide next.
What a CIC has to show on top
A community interest company follows the Companies Acts and the CIC Regulations, and funders know it. Several of the questions on a funding form exist because of those rules.
The asset lock
Your constitution contains statutory clauses locking assets to the community purpose. Assets cannot be transferred out at less than market value except to another asset locked body, and if the CIC is wound up any surplus is preserved for the community. Funders treat this as a reason to trust you with restricted money, so say it plainly in the bid.
Directors’ pay and the CIC34
Directors’ remuneration has to be transparent. Every year you file a community interest company report, form CIC34, which goes on public record at Companies House and covers what you did for the community, who you consulted, any assets transferred below market value and what directors were paid. An assessor can and does look it up. If your budget includes director salaries, the figures should sit comfortably next to what you have already published.
Shares and surplus
A CIC limited by shares is subject to a dividend cap, with at least 65% of surplus profits kept for the community purpose and up to 35% payable to shareholders. A CIC limited by guarantee has no dividends at all. You can also ring fence funding received so it is clearly used for the purpose it was given for.
Our CIC accounts and CIC34 filing guide walks through the annual filing itself.
Building the template step by step
Work in this order and the sheet comes together in an afternoon. Jumping to the numbers first is what causes the rebuild.
- Read the funder’s financial questions first Open the application pack and write down four things: the funded period, the payment schedule, the reporting dates, and whether a cashflow template is supplied. If a template is supplied, use it. These four facts set the columns, the income rows and the deadlines you will be working to for the next year or more.
- List your cost headings before any figures Write the headings you will actually spend under: staff, freelancers, venue, materials, transport, participant costs, overheads, evaluation. Keep the list short enough to report against and specific enough to be credible. Then open your bookkeeping software and make sure those same headings exist as account codes or tracking categories.
- Price each line with real numbers Get quotes for anything over a few hundred pounds and note the supplier and date. For staff, start from gross pay and add employer National Insurance and the employer pension contribution. For freelancers, use a day rate times a number of days. Round nothing up for comfort; put any contingency on its own line if the funder allows one.
- Spread the costs across twelve months Copy the headings to the cashflow tab and put each cost in the month the money leaves the bank. Add grant instalments in the months the funder pays, including any final instalment held back. Add opening and closing balance rows with formulas, then look for any month that goes negative.
- Write the assumptions down On the third tab, note the pay rates, quotes, participant numbers, overhead apportionment basis and VAT position. Add a line on what you would do if a payment arrived late. This page is what you will reach for when the funder queries a variance eight months from now.
- Save the submitted version and set reminders Date the filename, export a PDF for the bid, and store both somewhere other than one person’s laptop. Put the funder’s reporting dates in a calendar with a two week warning, and tell your bookkeeper which tracking category the grant spend belongs to before the first invoice arrives.
Where grant budgets go wrong
These four come up again and again in the budgets we are asked to check.
- Budgeting salaries at gross pay only A post budgeted at gross pay costs more than the budget line once employer National Insurance and the employer pension contribution are added, and more again if you need cover for holiday. Projects that staff up in month one and find the shortfall in month eight usually started here. Add the employer costs when you price the post.
- Leaving overheads out entirely Rent, insurance, software, bookkeeping and payroll do not stop because the work is grant funded. Most funders accept a fair share of overheads if you explain how you worked it out. Leaving them out looks modest on paper and quietly moves the cost onto your unrestricted funds, which is where reserves disappear.
- Treating the grant payment as income A grant received in advance of the activity is deferred income until the conditions are met and the spend happens. Booking the whole payment as income in the year of receipt overstates your surplus, confuses the corporation tax position and makes next year’s accounts look like a collapse. Split it across the periods it funds.
- Moving money between budget lines quietly Most funding agreements limit how much you can shift between headings without written approval, and spending outside the agreed purpose can trigger a clawback of some or all of the grant. If delivery changes, email the funder, get the variation in writing and update your own spreadsheet the same week.
When to get an accountant involved
If your CIC runs one grant, has no payroll and a volunteer with a decent spreadsheet, you can build this yourself from the steps above. The sheet is arithmetic and honesty.
It is worth getting help in three situations. Where two or more funders want different reporting periods and the restricted balances have to be split properly. Where the grant pays for staff, so the budget has to carry employer National Insurance, pensions and auto enrolment. Where your accounts need to be filed early because the next bid asks for the most recent figures.
We write quarterly and six monthly spend, budget and forecast reports for more than ten community interest companies, prepare annual CIC accounts and the CIC34, and introduce CIC clients to a fundraising consultant who helps find the next grant. The fee is agreed in writing before any work starts, and calls, meetings and emails are never charged on top. We do not do charity accounts, and we will say so on the first call.
Frequently asked questions
Can we use our own template instead of the funder’s sheet?
If the pack includes a cashflow or budget template, use theirs. Assessors compare bids by looking at the same cells in each one, and a different layout slows them down. Where no template is supplied, your own three tab sheet is fine, as long as the totals match the amount requested.
How many months should the forecast cover?
Twelve months is the usual minimum, and Welsh Government and Business Wales guidance expects newly formed organisations to submit a business plan with at least a year of financial forecasts. If the funded project runs longer than a year, forecast the full project period and show the twelve month view as well.
Should the budget figures include VAT?
It depends on your VAT position. If the CIC is not VAT registered, budget everything at the gross price you will pay, VAT included, because you cannot reclaim it. If you are registered and the VAT is recoverable, budget net and write that on the assumptions tab so the funder understands the basis.
What is the difference between a budget and a cashflow forecast?
The budget shows what the money is spent on across the whole funded period, under headings. The cashflow forecast shows when cash moves, month by month, and whether the bank balance holds up. Two projects with identical budgets can have very different cashflows if one funder pays in advance and the other pays in arrears.
Do we need a separate bank account for restricted grant money?
It is not a legal requirement for a CIC, but tracking is. Most organisations use one account with tracking categories in their bookkeeping software so restricted spend is identified at source. A second account helps where a funder asks for it or where several grants run at once and the balances get hard to follow.
Will you check our budget before we submit a bid?
Yes, for clients. Send the funder’s pack and your draft and we will come back the same working day, with the fixed fee agreed in writing before any work starts. This guide is general information about grant budgets and forecasts, not advice on your organisation’s own position, so send the figures and we will look at them properly.
Related guides and services
The other pages CIC directors usually read alongside this one.
In summary
A grant budget and forecast template earns its keep twice. First at the bid, where a funder can follow your arithmetic and see the bank balance holding up in every month of the year. Then afterwards, when the quarterly spend report is a comparison against a file you already have rather than a weekend of work.
Build it in order: the funder’s dates, then your cost headings, then real prices, then the twelve months, then the assumptions page. Keep the same headings in your bookkeeping. Recognise the grant as you meet the conditions and spend, and keep the submitted version of the file untouched.
If you have a deadline coming and want somebody to look at the figures, answer the questions on this page and Mudassir replies the same working day.