↑

How to Build Restricted Funding into Budgeting, Forecasting, and Reporting

Restricted Funding Budgeting & Reporting | Solver UK

How to Build Restricted Funding into Budgeting, Forecasting, and Reporting

Restricted funding shapes decisions throughout a non-profit organisation. When a grant is awarded for a particular service or period, the finance team needs to connect that award with the work it supports and follow the financial position as delivery develops.

That connection is rarely contained in a single figure. Consider a grant that funds a community programme for eighteen months. The original budget may assume a full delivery team from the first month, a particular level of activity and an agreed contribution towards central costs. Three months later, recruitment has taken longer than expected and delivery has started more slowly. The ledger shows an underspend, although the organisation still expects much of that expenditure to arise later in the funding period.

At that point, the question is no longer simply how much has been spent. Finance needs to understand what has changed, what the remaining work is expected to cost and whether the award will still be used in line with its conditions. Programme colleagues hold part of that answer, the accounting system holds another part, and the original assumptions may sit in a separate workbook.

Restricted funding becomes easier to manage when those parts of the process remain connected. The organisation gains a more useful view of each award during the year, and finance spends less time rebuilding the story whenever a forecast, management report or funder return is required.

Start with the relationship between the award and the work

Every organisation has its own way of representing restricted activity. One may create a separate fund for each award, while another records the relationship through projects, programmes or cost centres. The right model depends on the accounting policies and reporting responsibilities already in place.

What matters is whether the model preserves the relationship between the funding and the work. In the community programme example, finance should be able to see which income belongs to the award, where the delivery costs are recorded and how the remaining commitment extends across the funding term. If the programme operates from several locations, the organisation may also want to review the position by site without losing sight of the grant as a whole.

Time adds another layer. An eighteen-month award crosses two financial years, so the grant needs to appear correctly in each annual budget while still being managed across its full life. A forecast prepared at year-end should carry the remaining activity into the next period and retain the assumptions behind it. Otherwise, the organisational forecast and the grant schedule begin to describe the same work differently.

Consistent financial dimensions make those views easier to reconcile. The programme manager sees the activity within their remit, finance follows the award across its term, and trustees receive an organisational view that brings restricted and unrestricted resources together. Each report presents the information at a suitable level without requiring a separate version of the underlying figures.

This is where the initial design of the finance structure earns its keep. The aim is to reflect how the organisation already manages responsibility, funding and reporting, then use those relationships consistently across planning and review.

Let delivery changes flow into the forecast when working with restricted funding

A restricted-funding forecast becomes useful when it reflects what is happening in the programme. Staffing is often the strongest example because it represents a significant share of delivery costs and changes frequently during the year.

Suppose the original plan included two new posts from April. One person joins in May and the second role remains vacant until July. The year-to-date underspend is easy to see in the ledger. Its meaning depends on what happens next. Some of the saving may remain available, some may support rescheduled activity and some may require discussion with the funder.

The programme manager knows the likely recruitment date and the effect on delivery. Finance understands the salary assumptions, employer costs and treatment of the award. The forecast needs both perspectives. When the vacancy date changes, the expected staffing cost should update for the remaining months and feed through to the projected grant position.

The same principle applies beyond payroll. A workshop series may move into the following quarter, a supplier cost may rise or a planned activity may no longer be required. Recording those changes alongside the financial assumptions gives finance more than an updated total. It preserves the reason for the movement and creates a stronger basis for review.

Solver planning templates are configured around the organisation’s own finance model, so programme input feeds into the funds, cost centres and reporting periods used by finance. Calculations such as salary costs or phasing rules are managed centrally, while the people closest to delivery update the assumptions for which they are responsible.

This approach also protects the role of the approved budget. The budget remains the agreed starting point, and the forecast records the organisation’s latest expectation. Finance can then explain how recruitment delays or changes in activity have affected the likely year-end and grant-end positions without overwriting the original plan.

When it comes to restricted funding, treat shared costs as part of the funding story

Restricted programmes depend on organisational resources as well as direct delivery expenditure. A service may use office space, technology and support from central teams. Where the funding conditions permit it, an appropriate share of those costs needs to be included in the programme position.

The calculation is only one part of the work. Finance also needs to retain the basis for the allocation and apply it consistently. An organisation may use staff time for one group of costs and headcount for another. A funder may accept one category of overhead while excluding another. Changes in staffing or programme activity may alter the allocation during the year.

If the calculation sits in a standalone spreadsheet, it needs to remain aligned with the current programme structure and the latest forecast. A delayed vacancy in the community programme could affect both its direct salary cost and its share of an allocation based on headcount. Updating one without the other would leave the projected funding position incomplete.

Managing allocation drivers within the planning model keeps the calculation close to the budgets and forecasts that use it. Finance sets the approved method, reviews the result and updates the driver when circumstances change. The programme view then includes its share of eligible costs, while the organisational reports retain the corresponding central-cost perspective.

That connection becomes particularly valuable during review. When a trustee, auditor or funder asks how a figure was produced, finance can follow it back to the allocation basis and the relevant assumptions. The explanation does not have to be reconstructed from an old workbook and a trail of emails.

Bring programme knowledge into a controlled review process

Finance rarely owns every piece of information needed for a restricted-funding forecast. Programme and operational colleagues see changes in delivery first, and their knowledge needs a dependable route into the financial review.

Email often becomes that route by default. A programme manager sends a revised recruitment date or mentions that an activity has moved. Finance updates a working file, asks a follow-up question and waits for confirmation. When several programmes are being forecast at once, it becomes difficult to see which inputs are complete and which version contains the latest explanation.

A structured contribution process gives each manager a defined part of the forecast to update. Access is limited to their area, which is important when the model contains sensitive staffing or funding information. The contributor sees the programmes or templates relevant to their responsibilities, while finance retains oversight of the complete position.

Comments also belong beside the figures they explain. If a programme manager changes a start date or revises an activity cost, the reason remains available when finance reviews the submission. That context is still there when the movement appears later in a management report.

Workflow gives the review a visible status. Finance sees when an input is being prepared, when it has been submitted and when it has passed review. Once the forecast is approved, the period or stage is locked so that the reporting reflects the agreed version. Follow-up becomes more focused because the team knows where information is still outstanding.

Solver supports permissions, contributor input and workflow within the same planning environment used for finance review. This gives operational colleagues a practical way to contribute without exposing the wider model or asking them to work through a finance-owned consolidation file.

Review the future position alongside the ledger

Actual income and expenditure remain the foundation of restricted-funding reporting, although the ledger describes activity that has already been recorded. It does not show a purchase that has been committed but not invoiced, the cost of a vacancy expected to be filled next month or delivery that has moved into a later period.

For the eighteen-month community programme, the early underspend could look favourable in a year-to-date report. When the revised staffing and delivery plans are included, the outlook may show that the award will still be used in full. A different scenario may reveal a genuine underspend that requires action before the funding period ends.

Reviewing actuals against the approved budget and the latest forecast helps finance distinguish between those situations. The value lies in tracing the movement through the model. A reviewer should be able to move from the overall grant position to the period or cost area responsible, then see the assumption or commentary behind the revision.

That depends on actual and planned data using the same financial structure. Solver brings data from the finance system into reporting and planning templates based on shared dimensions. Finance reviews the consolidated position, drills into supporting detail and retains the assumptions used in the forecast.

The same underlying information then supports several reporting needs. A programme manager receives a view of their service, a funder report focuses on the relevant award and trustees see the effect across the organisation. The format and detail change for each audience, while the financial position remains consistent.

This reduces the reconciliation that arises when each output is assembled separately. If the forecast changes after review, finance updates the shared position and produces the required reports from that source. The explanation follows the figure rather than being rewritten for every audience.

Keep the model useful as circumstances develop

Restricted funding rarely proceeds exactly as described in the annual budget. An award may be confirmed later than expected, delivery plans may change or the organisation may agree a revised use of funds. The finance model needs to absorb those developments while retaining the versions used for approval and comparison.

Rolling the same structure from budget into forecast provides continuity. Finance begins with the agreed plan, updates the assumptions that have changed and reviews the effect on the remaining funding period. Where uncertainty remains, alternative scenarios help the team examine the implications of a delayed award or revised activity plan before a decision is made.

Professional judgement remains central throughout. The model organises the financial relationships and applies the agreed calculations; finance and programme leaders decide what the evidence means and what action is appropriate.

Solver UK works with non-profit finance teams to configure reporting and planning around their existing funding, programme and responsibility structures. The implementation considers how data enters the model, who contributes to the forecast, which calculations need to be applied and how the resulting position should appear in management, trustee and funder reporting.

If your organisation is reviewing how restricted funding moves through budgeting, forecasting and reporting, the Restricted Funding Planning and Reporting Review will help you document the current approach and identify the points where information becomes separated or requires repeated reconciliation.

You can also speak to Solver UK about a demonstration built around one of your own funding and reporting processes.

Explore your next step

Explore Solver for nonprofit finance, browse nonprofit resources and see customer stories.

Discuss your budgeting and reporting requirements with Solver UK.