Client Summarty Statement - Paid Invoice Summary Option Selected Only

Client Summary Statement - Paid Invoice Summary Option Selected Only

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.


  1. Category Budget Utilisation Table
  2. Service Provider Category Budget Table
  3. Full Invoice Detail Table
  4. Budget Timeline
  5. Budget Graph


Category Budget Utilisation Table



Total Budget


  1. Total Support Budget i.e., Core, Capacity found under the Plan Budget on the Service Contract.
  2. Category Budget found under the Plan Budget on the Service Contract.   


Unallocated Total


  1. Category Budget, Unallocated Total found under the Plan Budget on the Service Contract.
  2. 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


  1. 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.
  2. 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.
  3. 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.
  4. Calculation for %Used equals Total Delivered/Total Budget * 100.

Total Category Budget % Utilisation Legend


The Legend colour indicator calculation equals (%Used - %Budget Elapsed Time).



  1. Where % Used equals 100 the Legend equals Grey.


  1. Where (% Used - Time Elapsed %) is less than 11 and greater than -11 the Legend equals Green.





  1. Where (% Used - Time Elapsed %) is greater than 11 the Legend equals Amber.





  1. 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.




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.