Desktop PICS Funding Reports in PICSWeb

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.

Desktop Report	Where in PICSWeb	Notes

Desktop Report	Where in PICSWeb	Notes
Employer Responsive - SFA Funding Summary	Summary Funding Breakdown	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	Funding Details 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	Various	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	Process Warnings
Employer Responsive - Occupancy	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	Summary Funding Breakdown	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.
Learner Responsive - “Future factors” worksheet	Does not exist