Please refer to the following information for an explanation of how the statement is configured and
data is presented in the following Statement Content where the
Paid Invoice Summary statement option is selected
only.
- Category
Budget Utilisation Table
- Service
Provider Category Budget Table
- Full
Invoice Detail Table
- Budget
Timeline
- Budget
Graph
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.
Paid Invoice Summary
Category Table
Reports
on all DS Records with a Status of Provider Paid and the where the Paid Date,
falls into the Period of the Statement.
Category Opening Balance
Total
Category Budget less all DS Records with a status of 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 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
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
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.