Report Purpose & Summary
This is a program-based report that provides details of an agency’s funding source(s) (primary and/or sub-granted funding sources), including a detailed history of their associated service transactions for a specified date range.
The following parameters are available to obtain targeted details in the [EXPS-101] Funding Source Financial Detail:
|Select a Funding Source||Select the funding source(s) you wish to include in the report. You can choose “All Funding Sources”, one funding source, or you can select multiple funding sources by selecting the control key while clicking on each source. The report will display service details for each service that is connected to the funding source(s) you select|
|Include Sub Grants||This will default to ‘No’. Select ‘Yes’ to include any sub-granted funding sources that are connected to a primary funding source selected in the first dropdown menu. If you select ‘Yes’, the report will include details on the services associated with the sub-granted funding source AND any selected primary funding sources|
|Choose a starting date||This date will reflect the date from which you would like to start generating data|
|Choose an ending date||This date will reflect the date you would like to stop generating data|
|Select 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 includes the following data elements. Several of these elements originate from the Service Expense screen when providing a service. Others originate from Editing a service from the History tab:
- Client Name
- Client Address
- Check No.
- Check Date
- Month Paid
This originates from the client profile screen.
This originates from the Location tab in the client profile
Type, Vendor, Check No., Check Date, Month Paid, & Amount
These originate from the service history, “Add Expense” or “Edit” an existing expense Modify Expense screen.
- Type comes from the “Notes” field
- Vendor comes from the “Vendor” field.
- Check No. comes from the “Check number” field
- Check Date comes from the “Expense Date” field.
- Month Pd. comes from the “Expense Date” field.
- Amount comes from the “Amount” field
NOTE: If the expense has not been modified, ‘Month Paid’ and ‘Amount’ will come from the information entered at service placement.
Drilldown functionality is not necessary for this report.