This program-based report provides information on service transactions connected to selected funding sources.
The following parameters are available to obtain targeted details in the [EXPS-102] Program Service Expense Review report.
|Select a Funding Source||All agency funding sources (primary and sub-granted) are listed. Select one or multiple funding sources for the report, or select ‘All’ to include all funding sources listed in the dropdown menu.|
|Choose Start Date||This date will reflect the date from which you would like to start generating data.|
|Choose End Date||This date will reflect the date you would like to stop generating data|
|Choose Report Format||You can select Web Page, PDF, or Excel. A Web Page is a functional format that allows you to drill down on data elements to inspect the underlying data supporting it. The PDF is a good option for official reports, grants, etc. If you download the excel file you can can use excel to manipulate the data (e.g. Sort/Check for duplicates, etc.)|
This report provides information on service transactions connected to selected funding sources. These funding sources include both Primary Funding Sources and Secondary Funding Sources. The report is divided according to funding source, in alphabetical order. Each funding source is then further divided into the following sections:
- Client Unique Identifier
- Service Housing
- Service Name
- Expense Amount
- Expense Date
- Start Date
- End Date
At the bottom of each of these sections is a Total Number of Expenses & Total Expense Amount
Client Unique Identifier
Each client who received the service will be listed here by Unique Identifier. They will be listed for each service placement, so some clients may be listed numerous times if they received the same service on multiple occasions.
If the service is linked to a housing program, the clients housing status at entry into into the program will be listed here.
Note that this information is pulled from the program enrollment page as opposed to the client profile page.
The service name will be listed here.
This is configured in Manage > Services
This column represents the amount of funding disbursed for each service transaction. These amounts are recorded during service transactions.
Service Expense Amounts are configured when creating the service item in Manage > Services.
This is the date that the service expense was scheduled for. Note that it may or may not coincide with the date of the service transaction. This date is selected during the service transaction.
Start Date / End Date
This is the date that the service was placed and the date that the service ended.
These dates will be dependent upon the type of attendance applied to the service – services that are long term will be different from one-time services, etc.
All information is summarized in the Details table at the bottom of the report:
Note: Drilldown functionality is not necessary for this report