[EXPS-103] Program Funding Source Financial Detail

[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


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
Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.