A copy of your school's Consistent Financial Reporting (CFR) return has been produced, which has now been submitted to the ESFA.
To view your school’s data, please enter your school’s 4 digit DfE number in the yellow box in cell B4 of the 'Consistent financial reporting school report' spreadsheet. Please note, this spreadsheet works with Excel 365 and Excel 2021 only. If you are using a desktop version of Excel which pre-dates these, you will need to open the spreadsheet via the Microsoft 365 web browser instead, which is free to use.
To do this, you will need to save the spreadsheet to your computer, then sign in or create a Microsoft 365 account. Once created, open ‘Apps’ from within Microsoft 365 (on the left-hand side), select ‘Excel’ and then click ‘Upload’ and select the CFR spreadsheet from your computer.
The spreadsheet should open from here, however, if it doesn’t, please click on ‘My Content’ (on the left-hand side) and it should be in there, where you will be able to open it. You should now be able to view the data.
Also in the related documents section is a list of GL codes and the CFR code to which it maps to. If you have any issues with the spreadsheets, please contact Karen Sellors at karen.sellors@derbyshire.gov.uk.
Community-focused school revenue balance
Please could you check your school's B06 Community-focused school revenue balance (found in cell H96), this balance is rolled forward each year, please notify Accountancy if this does not match the balance you have recorded or if this should be zero.
Schools holding money on behalf of other schools
There are instances where schools hold money on behalf of other schools as part of a hub or network to carry out projects. The DfE recognises that this issue distorts schools' CFR returns, and as a consequence has asked for the appropriate income/expenditure to be netted off prior to the return. As this information cannot be picked up from the ledger, it has not been included in the draft return and any schools in this position will need to notify accountancy of the appropriate amounts.
Voluntary aided schools
Voluntary aided schools do not show their capital income or expenditure on SAP; however this still needs reporting on the CFR return. If you are a VA school please email Karen Sellors at karen.sellors@derbyshire.gov.uk, with details of your capital income and expenditure as soon as possible.
Related Content