Financial Planning Template
5
Column K - Non-demographic growth pressures arising from other population
changes, technological developments, increased prevalence etc. These
numbers will be calculated from the assumptions sheet.
Column L - Cost pressures. These are free cells to enter costs as financial
values directly onto the expenditure template (i.e. they are not driven by the
assumptions sheet). This would include any recurrent cost pressures not
adequately captured by the headings in columns G to K.
Columns M & N – These cells capture the information entered onto the QIPP
sheet. All QIPP schemes will need to have an expenditure type selected from
the drop down box on the QIPP sheet for the information to flow through to
the Financial Plan and reconcile.
Column O - Investment which is not QIPP related, but relating to other service
quality/developments. As above, this is pre-populated once the CCG has
completed the investments worksheet within the template. All costs entered
on the investments worksheet need to be allocated to a cost category on the
drop down menu for the workbook to reconcile.
Column Q - CCGs need to enter any non-recurrent pass through costs here
that the CCG has received and has been assumed in the allocation.
Column R - Non-recurrent pressures, investments (incl. CQUIN where
relevant). Non-recurrent items all at 2014/15 prices.
Column S – Non Recurrent Investments. As with the recurrent investments
this will be captured from the Investments tab
Columns T & U – Non Recurrent QIPPs. As with the recurrent QIPPs, these
will be captured from the QIPPs sheet.
Include Learning Disability costs under Mental Health (hospital-based) or Community
Services.
The CCG’s total Programme Resources should be matched across the expenditure
categories, the difference being its surplus or deficit (shown in the Financial Plan
Summary). Where reserve budgets are expected to be used to fund other
programme expenditure, e.g. the use of reablement funding for community services
investment, this should be shown netting off in the investments column (i.e. reducing
reserves line and increasing service expenditure).
Running costs have been split between CCG pay costs, CSU re-charge, NHS
Property Services Recharge and other non-pay. The Financial Plan Summary will
match the total expenditure to the running costs allocation to check to see whether
the CCG is within target allocation.
Columns Y - AJ - Monthly expenditure profile. Please enter the correct
monthly profile into these columns. The March figure will calculate
automatically to ensure that the monthly totals match the annual plan in
column V.
Page 5/15
Free Download
Financial Planning Template PDF
Favor this template? Just fancy it by voting!
(0 Votes)
0.0
Related Forms
