FMS6 CFR UPDATE NOTE No 6 May 2016
PREPARATION OF THE FINAL CFR REPORT AND SUBMISSION TO THE LOCAL AUTHORITY
The final deadline for submission of your Final CFR Report is Friday 10th June 2016 so please ensure that all preparatory work is completed and any queries are resolved as soon as possible
Step 1 (note: in 2015-16 financial year)
Run the validation report to check that all of the codes have been mapped.
Reports
CFR
CFR Reports
Click on Final
Click on Validation Report
If you have any amounts listed – Please contact the FMS6 Helpdesk who will be able to advise you on how to clear these.
Please note if you are a PFI school you should have already apportioned your PFI costs to the appropriate ledger codes as per update 76 which can be found on our website under FMS/Personnel Module resources or using the link below.
http://www.northamptonshire.gov.uk/en/councilservices/EducationandLearning/services/schlfin/Documents/SIMS%20Updates/FMS6%20UPDATE%20No%2076%20PFI%20APPORTIONMENT.pdf
Step 2
Next you will need to check that the Carry Forward Closing Balance agrees to the Final Oracle report Click on the Print CFR Report and check that the summary at the bottom of the report to ensure that both Revenue and Capital agree with your SB1 form.
Please note that there may be pence variances due to FMS using actual whereas the Oracle Carryforward is to the pound.
If this does not agree lease contact the FMS6 Helpdesk by email on who will advise on how this can be corrected.
Step 3
Click on each of the 5 tabs in turn and scroll down to ensure that there is a green tick against all of the codes.
If there is a red cross or yellow warning triangle against a code then please contact the FMS6 Helpdesk by email for further guidance.
Step 4
Once any queries have been resolved and there are no further error messages on any of the tabs, you should now create your Final CFR Report file as follows.
CREATING THE FINAL CFR REPORT FILE
Within Tab 5 is the option to, “Export to XML” as shown below
Select “Export to XML” you will then see the following message on screen:
Please select “Yes” - you will then be presented with the screen below detailing where your CFR report has been successfully exported to and we suggest that you make a note of the file path as you will need it later.
In most instances SIMS will automatically save the file in:
“C:/ProgramFiles/SIMS/FMSSQL/Transfer/Out – XML CFR Report but with your DfE number
FINAL STAGE – SUBMISSION OF YOUR FINAL CFR REPORT TO THE LOCAL AUTHORITY
This action has to be completed by no later than close of business on Friday 10th June 2016.
Open your email programme, attach the xml file from the location which you made a note of previously.
Enter email subject tile “Final CFR Report – School Name” and send to
On receipt your file will be loaded into the DfE COLLECT system which will identify if the report is showing any errors.
If errors are shown, you will be contacted by a member of your Finance team for an explanation which we will insert into the school submission if necessary.
1