Available Client Funding Report

The Available Client Funding Report is designed to show a list of Client Fundings that intersect a specified reporting period and show the (pro-rata) portion of a Client's Total Funding budget value relative to that reporting period. 

N.B. It is important to note, that this report DOES NOT have any relation to expenditure, or the unspent budget remaining on a Client's Funding record.

Audience: Finance Team, Team Leaders

Prerequisite

To access the 'Finance' menu and the 'Available Client Funding Report', Staff require the 'View Financial Information' and 'Edit Client Records Across ALL Services' Staff Account Privileges.  

Summary

The following list summarises the content within this article:

• How to generate the Report 
• How does the Report calculate the data 
• The Report

How to generate the Report

To access the  Available Client Funding Report navigate to the Dashboard and select Finance:

Select the 'Available Client Funding Report' from the 'Reports::Funding Reports' section of the Finance menu:

Search Criteria

This report can be filtered by the following criteria.

Set the Reporting Period in the 'From Date' and 'To Date' fields:

N.B. you may wish to view this on a monthly, quarterly, or annual basis

Select the relevant Funding Type:

Select the 'Generate Report' button:

How does the Report calculate the data

If the reporting period was 01/07/2018 through to 31/07/2018, SupportAbility would display a list of Client Funding records which are valid for at least some part of this reporting period. 

For example, a Client Funding record with a funding period from 01/01/2018 to 31/12/2018 overlaps the dates of the selected reporting period and hence would be included in the report. 

If that Client Funding had a total value of $10,000 for the entire funding period (01/01/2018 to 31/12/2018), the purpose of this report is to show how much of that total funding value is relevant to the reporting period (01/07/2018 to 31/07/2018). 

To calculate the portion of the total funding value that is relevant to the reporting period, SupportAbility uses the following pro-rata calculation:

Total Funding Value x (the number of days in the funding period that intersect with the reporting period / total days in funding period) 

To illustrate this using our example, the value of the Client Funding that is relevant to the reporting period can be calculated as follows:

$10,000 x (31/365) = $849.32

The Report

Once generated, the report returns Client Funding records of the requested Funding type which are valid for all or some part of the reporting period. 

The Data presented includes:

• Client Name
• Client Funding Name
• Client Funding Start Date
• Client Funding End Date
• Full Funding Value (the total budget value for the entire funding record)
• Pro-Rata Percentage (If the report date range set covers only 25% of the total Client Funding period, the pro-rata percentage would be 25% to indicate that only 25% of the Full Funding Value is applicable to the reporting period)
• Pro-Rata Funding Value (Full Funding Value * Pro-Rata Percentage = the portion of the Full Funding Value that is relevant to the reporting period)