HESG Services & Billing Report

Prevention and Rapid Rehousing projects funded by City of St. Louis ESG dollars (HESG) are required to run the "HESG Services & Billing Report" each month in order to receive reimbursement from the funder.

Running the Report

Report Path

Folders
> Public Folder
> missouri_live_folder
> Public Folder
> Funder-Specific Reports
> St. Louis City DHS
> St. Louis City HESGServices & Billing Report

Recommended Export Format

Schedule to Microsoft Excel - Reports

Setting the Prompts

Prompt	Instructions
EDA Provider	If only one project is selected in the "Select Provider(s):" prompt, select the same project here. If more than one project is selected in the Select Provider(s):" prompt, then select one of the projects.
Enter End Date PLUS 1 Day:	Enter the date after the last date of the reporting period in m/d/yyyy format. For example, if you're running a report for 7/1/2020-6/30/2021, the date entered in this box would be 7/1/2021.
Enter Start Date:	Enter the start date for the reporting period in m/d/yyyy format. For example, if you're running a report for 7/1/2020-6/30/2021, the date entered in this box would be 7/1/2020.
Select Provider(s):	Select the project(s) for which you wish to run the report.

Common Data Entry Mistakes

Unchecked House Household Members (in Service Transactions)

All household members who benefit from the financial assistance service must be selected within each separate service transaction.

Ineligible Service Recorded

If a service type that is not eligible is recorded, the billing report will not show that the service occurred.

Missing/Incorrect Funding Source

All financial assistance services for which any St. Louis City ESG funds were expended must have both the funding source and amount properly recorded within each service. It is vitally important that the correct funding source be selected in order for the report to generate properly.

Project Type	Fund to Select
HESG Prevention	2021 HESG Prevention
HESG Rapid Rehousing	2021 HESG Rapid Rehousing

Need Assistance?

If you need assistance running the report, understanding the information in the report, or troubleshooting potential errors, please reach out to the ICA Missouri Helpdesk. Include the name and date of the BusinessObjects report as it appears in your BI Inbox in your request for assistance. Do not attach the report to any emails going to the helpdesk as the report contains personally identifying information and cannot be transmitted unless encrypted.