[EXPS-103] Program Funding Source Financial Detail

This is an enrollment-based report that returns a detailed list of expense service records.

All users can run the report. There are restrictions for which information can be accessed based on the user's access rights.

This report can be found in the following location in the Report Library:

Program(s)	Choose which Program(s) to include: All, Single Select, or Multi-Select (Hold Control/Command or Hold Shift to select multiple options sequentially.)
Funding Criteria	Choose how the 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: All, Single Select, or Multi-Select (Hold Control/Command or Hold Shift to select multiple options sequentially.)
Report Date Range	Choose the date range of expenses to include in the report
Report Output Format	Web page PDF Excel Note: If the report contains more than 80,000 rows, the report format will automatically return as Excel.

The report will include expense records for program-connected services that were dated during the reporting period and meet the parameter selections.

sample report

The report is organized by:

The fields on the report come from the following:

Notes comes from the "Notes" field for the expense
- This is not the Service Note field
Vendor comes from the “Vendor” field in the expense
Check No. comes from the “Check number” field in the expense
Check Date comes from the “Expense Date” field in the expense
Month Pd. comes from the “Expense Date” field in the expense
Amount comes from the “Amount” field in the expense
Address comes from the most recent Client Location available for the user who runs the report or Client Location from the Profile screen, if any

Note: Several of the fields listed above are found on the MODIFY EXPENSE pop-up that appears when an expense record is edited.

Subtotals and grand totals are included for the following:

Following the main expense records tables, a table of included funding sources is provided:

This table will only be included if "Only Primary Funding" or "Primary or Subgrant Funding" parameters were selected .

Updated 01/24/2024