M9 PKD Key Data external updater – version 7.17.09.0a – 12 January 2018
A fixer for the month 9 Key Data Return has been uploaded to the Additional Documents section of your NHSI portal.
This update contains fixes for:
Trusts who received a post audit reallocation of STF bonus relating to 2016/17.
The PPA line on row 41, which was hidden in error and will now allow providers to enter any PPAs with an impact on adjusted financial performance that have been identified for month 9.
The fixer version 7.17.09.0a must be run against the Month 9 Key Data file PKD_D_FY2017-18_M09_[NHSCode].xlsm by all providers who received a post audit reallocation of STF bonus relating to 2016/17 prior to submitting on 16 January. For all other providers this fixer is optional.
Month 9 PFR mandatory fixer version 1.17.09.1 - 11 January 2018
A fixer for the month 9 PFR return has been uploaded to the Additional Documents section of your NHSI portal. It can be downloaded by clicking the three dots to the right of the document, then the three dots at the bottom of the dialog box that opens, then selecting ‘download a copy’.
This update contains:
- Fixes for all known issues listed below
- Populates DH financing data to activate TAC validations 156 to 160
- Updates to sheet ‘8a. STF’ for winter funding and CQUIN risk reserves
- Updates to capital financing information and limits (NHS Trusts only) in tabs 16 and 18 of the monthly monitoring information
The fixer must be run by all providers prior to submitting on 23 January. Please ensure that “Month 9 main submission” is selected in cell D26 on the cover sheet of your PFR return (as required for submission 1) prior to running the fixer.
Known issues in Month 9 Key Data Return - 11 January 2018
|Will not be fixed||40. Variances - cell P46||The previous month forecast for CDEL has not been prepopulated into cell P46, consequently the variance reported in cell Q46 is incorrect. This will not be corrected by the fixer but we would request a commentary be included if there is a significant movement in FOT from month 8, despite the flag not showing.|
|Fixed version 7.17.09.0a||04. SoCI - row 42||Trusts who received a post audit reallocation of STF bonus relating to 2016/17 will note that this is not visible within 04. SoCI sheet within the month 9 Key Data return and is therefore not currently adjusted out of the 17/18 performance as in previous months.|
|Fixed version 7.17.09.0a||04. SoCI - row 41||The PPA line on row 41 is hidden in error. This row should be unhidden to allow providers to enter any PPAs with an impact on adjusted financial performance that have been identified for month 9. Any provider with such a PPA who is needing to record the impact within the month 9 Key Data Return can run the STF fixer to update this.|
|Will not be fixed||Cover||We are aware that a number of trusts are unable to paste an electronic signature onto the Cover sheet in cell D32. In these circumstances, for Month 9 Key Data Return only, we will accept the submission but trusts are requested to type in the name of the signatory to clear any validation.|
Known issues in TAC schedules and M9 PFR Return – 11 January 2018
|Will not be fixed||TAC65 Audit sheet||The formulas from E491 to H504 are incorrectly picking up the wrong counterparty information from the WGA tabs. No fixer will be issued for this but it will be corrected for the M12 PFR return.|
|Not yet fixed||TAC15 Investments & groups - cell F96||The formula in F96 is not picking up the correct signage from subcode IGR0475. This will be corrected by fixer to be issued no later than 19th January.|
|Fixed version 1.17.09.1||13. SoCI Other – cell AH58||The formula in cell AH58 is incorrectly picking up TAC22 Provisions F37 (change in discount rate) instead of F36 (absorption transfer).|
|Fixed version 1.17.09.1||08a. STF||The expected STF figure before finance override is not being correctly pulled through to cells O62 and O78 due to an issue within a hidden cell.|
|Fixed version 1.17.09.1||TAC62 WGA – NHS and DH||Two CCG name changes that occurred on 1 April 2017 have not been reflected in the list of DH bodies. Row 52 should read North Cumbria CCG (code 01H) and row 103 should read Morecambe Bay CCG (code 01K). Please refer to the codes rather than the names for these two rows.|
|Fixed version 1.17.09.1||TAC07 Op Inc 2: Table 2B – row 84||Trusts who received a post audit reallocation of STF bonus relating to 2016/17 will note that it is not currently possible to enter this 2017/18 figure in Table 2B. Row 84 is currently hidden for all trusts in error.|
Release of month 9 PFR form including TAC schedules – 22 December 2017
Your month 9 Provider Finance Return (PFR) form is now available on your Portal inbox. As previously advised, the month 9 PFR form also contains the TAC schedules. You should refer to section 1.1 of the TAC completion instructions document for overarching guidance on how to complete the TAC forms. We shared a sample of the TAC schedules with you on 5 December. Changes to the TAC schedules compared to that version are listed in annex 2 of the attached TAC Completion Instructions.
The monthly monitoring tabs are essentially in the same format to those used at month 8. However, please note that many of the year to date fields previously requiring input are now linked to the equivalent data in the TAC forms. This is only the case for year to date; the appropriate forecast outturn fields still require input. The updated monthly monitoring guidance for PFR forms is available on your Portal. Changes are included in appendix 4 to the guidance.
TAC Completion Instructions - 201718 month 9
DH GAM updates and NHS Pensions requests – 22 December 2017
The Department of Health has published updates to the DH Group Accounting Manual 2017/18 today. This is available at https://www.gov.uk/government/collections/department-of-health-group-accounting-guidance. This includes an important update on accounting for the apprenticeship levy. The dedicated line in TAC staff costs (TAC09, STA0025) should be used for amounts paid under the levy. For in-year monitoring these costs should continue to be recorded in the ‘other’ row of the employee expenses note on tab 11 staff costs. If trusts are receiving benefit from the fund, please follow the guidance in the DH GAM update and use the ‘education and training’ rows in TAC07 income (INC1240) and TAC08 expenditure (EXP0330) for the non-cash items at month 9.
The NHS Business Services Authority has now published details for the 2017/18 process for submitting ‘Greenbury’ requests: details are available at https://www.nhsbsa.nhs.uk/sites/default/files/2017-12/Disclosure%20of%20Snr%20Man%20Rem%20%28Greenbury%29%202018-20171204-%28V1%29.pdf
Accounts and reporting timetable 2017/18 – 6 December 2017 (updated)
The attached letter sets out the accounts and reporting timetable for NHS trusts and NHS foundation trusts for the remainder of 2017/18.
This letter was updated on 6 December to correct referencing on the 21 March and 27 March rows.
FT Annual Reporting Manual 2017/18 – 23 November 2017
The Foundation Trust Annual Reporting Manual for 2017/18 has now been published here. There are no significant changes compared to 2016/17. We proposed to the HFMA Provider Technical Interest Group that we should issue the FT ARM without a consultation given the minimal changes in order to give certainty to the sector. The group agreed to this proposal.
This document only applies to NHS foundation trusts. NHS trusts should refer to the Department of Health Group Accounting Manual.
IAS 7 amendments – 23 November 2017
Injury Cost Recovery scheme 2017/18 – 23 November 2017
The Compensation Recovery Unit has advised that the percentage to use for the probability of not receiving the income is now 22.84%. Please refer to the Department of Health’s guidance on the Injury Cost Recovery scheme available here.
2017/18 reporting timetable (key dates) - 23 October 2017
NHS Improvement has worked with the Department of Health and NHS England to develop the 2017/18 reporting timetable. We can confirm the main submission dates at month 9 and month 12 as:
- Tuesday 23 January, noon – submission of month 9 PFR return, containing accounts data and monthly monitoring
- Tuesday 24 April, noon – submission of month 12 PFR return, containing draft accounts data and monthly monitoring
- Tuesday 29 May, noon – submission of month 12 PFR return, containing audited accounts data and monthly monitoring
At month 9 and month 12 there will be an earlier submission of a ‘key data’ return providing financial headlines. The timing for these is being confirmed, but is likely to be to a similar number of working days after the month end as the monthly monitoring in other months.In the next couple of weeks we will provide a full timetable letter which sets out the detailed agreement of balances, monitoring and accounts timetable for the rest of 2017/18.
Agreement of balances guidance for 2017/18, 28 September 2017
DH has now issued the month 6 'Agreement of balances' guidance which can be found here.
Additionally on 15 September 2017 providers should have received an email from NHSI which contained the four AoB counterparty contact files (note: the password to the file is in the body of the email). If you have not received said email please contact email@example.com to request a copy.
Preparations for month 9 financial reporting, 23 August 2017
We’ve written to NHS trusts and NHS foundation trusts providing an update on our plans for financial reporting at month 9 and month 12 2017/18. Given the different legacy systems, different versions of the letter were sent to the NHS trust and NHS foundation trust sectors: please see attachments below.
Publication of the Department of Health (DH) Group Accounting Manual (GAM) 2017/18, 30 June 2017
Following a consultation earlier in the year, DH has now published the Group Accounting Manual (GAM) for 2017/18.
This provides the detailed requirements for accounts for NHS trusts and NHS foundation trusts, and annual report requirements for NHS trusts. The formal accounts direction and requirements for annual reports for foundation trusts will be contained in the FT Annual Reporting Manual, to be published later in the year.
Provider financial monitoring form completion guidance: updated for month 2, 5 June 2017
We have now released the provider financial monitoring form and associated completion guidance for NHS providers and you can find these on your trust portals. These new portals are being used for 2017/18 onwards.
Update on Department of Health Group Accounting Manual 2017/18, 2 May 2017
Publication of the post-consultation DH Group Accounting Manual (GAM) for 2017/18 is delayed by the purdah period in advance of the general election. The manual is expected to be published in June or July.
The draft version issued for consultation continues to be available here
Agreement of balances guidance for 2016/17, 28 March 2017
DH has now issued the month 12 'Agreement of balances' guidance and quarter 4 update documents.
Previous financial accounting and reporting updates
These are previous updates that we've published. They are primarily relevant to foundation trusts but some may also be of use to NHS trusts.
Get updates to this page by RSS feed