Unlike Desktop PICS, the PICSWeb funding calculator generates only one Funding Calculator Report, with different calculations shown in different worksheets. This report contains details for all ILR funding, unlike Desktop PICS, which split between Employer Responsive (i.e. Adult) and Learner Responsive (i.e. Young Persons) calculations.
The table below lists each desktop funding report and explains both where it is found in PICSWeb (if it has been transferred over) and any differences between the two reports.
Where in PICSWeb
Where in PICSWeb
Employer Responsive - SFA Funding Summary
The PICSWeb Summary worksheet will show a summary of earnings for each Funding Basis
The PICSWeb Funding Breakdown worksheet is based on the Desktop’s SFA Funding Summary worksheet with the following differences:
The data is shown in a tabular format, instead of desktop’s nested format, to allow for easier filtering and other processes associated with working with spreadsheets,
The Age band sections from Desktop have been replaced with Funding Line in the PICSWeb report to match those used by the ESFA
Employer Responsive - SFA Funding Detail
Year To Date
The information from Desktop PICS' Period PP-YYYY worksheet is now available in PICSWeb’s Funding Details worksheet
The information from Desktop PICS' YTD worksheet is now available in PICSWeb’s Year To Date worksheet
Employer Responsive - Calculation details
The PICSWeb report contains a number of worksheets for calculation details for each of the Funding Methodologies used, for example FM35 Calc Dets and FM36 Calc Dets.
The FM36 Calc Dets differs from Desktop’s Calculation Details report in that it now shows the calculation details for each Price Episode instance instead of each period to match better with the ESFA’s Indicative / Monthly Payment reports.
Employer Responsive - Process Warnings
Employer Responsive - Occupancy
The PICSWeb Occupancy worksheet, which shows episodes in learning during the year being finalled. The columns for Starter, Leaver and Achiever show if an episode started, ended or was achieved in the period being finalled.
Learner Responsive - “Summary” worksheet
The PICSWeb Summary worksheet will show a Calculation Basis for FM25 where applicable.
The PICSWeb Funding Breakdown worksheet will show a breakdown of funding for each 16-18 Funding Line for any relevant Source Of Funding (typically “107” for Young Person funding) with YTD totals along with totals for the funded period.
Learner Responsive - “FIS values” worksheet
Year To Date
The PICSWeb Year To Date worksheet will show the values earned by each learner in each period for the year.
Learner Responsive - “Monthly values” worksheet
Does not exist
The PICSWeb funding calculation report does not spread earned FM25 funding over periods. Instead, it shows the period in which funding was actually earned within the Year To Date worksheet.
Learner Responsive - “Calc details” worksheet
FM25 Study Prog Calc Dets
Although the formatting of the report has changed, the PICSWeb FM25 Study Prog Calc Dets worksheet retains the information from the Desktop Calc details worksheet.