Category Budget Utilisation Table
Total Budget
- Total Support Budget i.e., Core, Capacity found under the Plan Budget on the Service Contract.
- Category Budget found under the Plan Budget on the Service Contract.
Unallocated Total
- Category Budget, Unallocated Total found under the Plan Budget on the Service Contract.
- Support Budget, Unallocated Amount i.e., Core, Capacity found under the Plan Budget on the Service Contract.
Opening Balance
Total Budget less all DS Records with a status of Extracted, Extract Generated and Provider Paid and the Delivered Service and Delivered From Date fall into the period, from the start of the Service
Contract to the end of the Statement period.
Funds Used
All DS Records with a Status of Extracted, Extract Generated and Provider Paid and the Delivered Service and Delivered From Date fall into the Period of the Statement.
Closing Balance
Opening Balance less Funds Used = Closing Balance
% Used
- Category budget utilisation % used in the above table is based on the percentage of the category budget utilised at the time this statement was created versus the amount of time elapsed for the budget and is provided as a guide only.
- Statement Day run equals the date it is created. i.e., Statement Setting is Day 1, on the 1st September it is sent out for a period of 1st August to 31st August.
- Calculation is %Used = All DS Records with a status of Extracted, Extract Generated and Provider Paid and the Delivered Service Date and Delivered From Date, fall into the period, from the start of the Service Contract to the end of the Statement Period.
- Calculation for %Used equals Total
Delivered/Total Budget * 100.
Total Category Budget % Utilisation Legend
The Legend colour indicator calculation equals (%Used - %Budget Elapsed Time).
- Where % Used equals 100 the Legend equals Grey.
- Where (% Used - Time Elapsed %) is less than
11 and greater than -11 the Legend equals Green.
- Where (% Used - Time Elapsed %) is greater
than 11 the Legend equals Amber.
- Where (% Used - Time Elapsed %) is less than
-11 the Legend equals Red.
Service Provider Category Budget Table
Budget
Service Provider Category Budget on the Service Contract.
Funds Used
All DS Records with a Status of Extracted, Extract Generated and Provider Paid and the Delivered Service Date and Delivered From Date, falls into the Period of the Statement.
Remaining
Budget less Total of DS Records with a status of Extracted, Extract Generated and Provider Paid and the Delivered Service Date and Delivered From Date, falls into the statement period.
% Used
Calculation is %Used = All DS Records with a status of Extracted, Extract Generated and Provider Paid and the Delivered Service Date and Delivered From Date, falls into the period, from the start of the Service Contract to the end of the Statement Period.
Full Invoice Detail
Category Table
Reports on all DS Records with a Status of Extracted, Extract Generated and Provider Paid and the Delivered Service Date and Delivered From Date, falls into the Period of the Statement.
Category Opening Balance
Total Category Budget less all DS Records with a status of Extracted, Extract Generated and Provider Paid and the Delivered Service Date and Delivered From Date, falls into the period, from the start of the Service Contract to the end of the Statement period.
Category Closing Balance
Category Opening Balance less Funds Used = Category Closing Balance.
Budget Timeline
Total Funds Used
All DS Records with a Status of Extracted, Extract Generated and Provider Paid and where the Delivered Service Date and Delivered From Date, fall into the period, from the start of the Service Contract to the end of the Statement period.
Time Elapsed Percentage
Is calculated based on the duration between the Start of the Service Contract and the end of the Statement Period and is displayed as a percentage.
Budget Graph
Funds Remaining
Total Support Budget i.e., Core Budget, less all DS Records with a status of Extracted, Extract Generated and Provider Paid and the Delivered Service Date and Delivered From Date, fall into the period, from the start of the Service Contract to the end of the Statement period.
Funds Used
All DS Records for the Support Budget i.e., Core Budget, with a Status of
Extracted,
Extract Generated and
Provider Paid and where the
Delivered Service Date and
Delivered From Date, fall into the period, from the start of the Service Contract to the end of the Statement period.
Related Articles
Client Summary Statement Exclusions Explained