Client Summary Statement Explained - Full Invoice Detail - Claim Date Filter Selected

Client Summary Statement Explained - Full Invoice Detail - Claim Filter Selected

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 Full Invoice Detail statement option is selected, and the Claim Date Filter is selected.
 
  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.
  1. 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 Claim Date falls 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 Claim Date falls into the Period of the Statement.


Closing Balance


·         Opening Balance less Funds Used = Closing Balance


% Used


  1.  Category budget utilisation % used in the 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.
  1. 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.

  1.          Calculation is %Used = All DS Records with a status of Extracted, Extract Generated and Provider Paid and the Claim Date, falls into the period, from the start of the Service Contract to the end of the Statement Period.

  1. 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 Claim 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 Claim 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 Claim 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 Claim 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 Claim 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 Claim 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 Claim 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 Claim Date, falls into the period, from the start of the Service Contract to the end of the Statement period.