[EXPS-103] Program Funding Source Financial Detail

Background and Specifications

This is an enrollment-based report that returns a detailed list of expense service records. Anyone can run the report, but the returned information will be limited based on the access rights of the user.

The report universe includes the following:

Program-connected Services
o Must include Expense record
o Date of the Expense is within the reporting period
Funding Source must meet the criteria selected in the parameters
Address - The client's most recent address the user has access to

Subtotals and grand totals are included for the following:

Service Item Totals
Service Totals
Program Totals
Totals

Instructions

Make sure you are operating in Clarity under the agency you are running the report for. You can check and change this under your name in the top right corner.

Step 1: Click on the Launchpad, then click on the Reports icon.

Step 2: Once on the Reports main page, click the down arrow next to the Program Based Reports to expand the section.

Step 3: Click the Run button next to [EXPS-103] Program Funding Source Financial Detail.

Reporting Parameters

Step 4: Enter the following parameters

Program(s)	Choose which program(s) to include in the report (hold either control/command/shift button to select multiple)
Funding Criteria	Choose how Funding Source should be considered in the report Not Based on Funding Source - will include all expense service records regardless of funding source information No Funding Source - will only include expense service records with no associated funding source Only Primary Funding - will only include expense service records where the program is the Primary grantee for the funding Primary and Subgrant Funding - will include expense service records where the program is either the Primary grantee or sub-grantee programs
Funding Status	All Fundings Active Fundings Inactive Fundings
Funding(s)	Choose which fund(s) to include or choose "Any Funding Source" (hold either control/command/shift button to select multiple)
Report Date Range	The date range for the expenses to include in the report
Report Output	The report is available in the following formats Web page PDF Excel Note: If the report contains more than 80,000 rows, the report format will automatically return as Excel

Step 5: click Submit

The file will be sent to the Report Queue. Once the report is processed, you send a notification that the report is ready.

To open the report, either select Open on the popup or click the Queue icon and then click Download to open your report.

Reporting Details

The information in this report is pulled from service placements. The report provides the following information:

Unique ID
Client Name
Notes
Vendor
Check Number
Check Date
Month Paid
Amount