St. Louis City ARPA Billing Report

This report provides the information needed to complete billing reports and meet reporting requirements for the following St. Louis City ARPA (American Rescue Plan Act) components (grant types):

Bridge Interim Housing
Emergency Shelter Operations/Services
Mortgage Assistance
Rapid Re-Housing
Supplemental Support for Permanent Supportive Housing
Wrap Around Services

This guide explains how to properly run the report and utilize the information it contains. Any questions about this report may be sent to our helpdesk using the blue "Contact the Helpdesk" button in the lower right-hand corner of the screen.

Running the Report

Report Path

Folders
> Public Folder
> missouri_live_folder
> Funding-Specific Reports
> St. Louis City ARPA
> ARPA Billing Report

Recommended Export Format

Schedule to Adobe Acrobat

Note: If this report is run in "View" mode, warnings may appear (after the report finishes generating) indicating that data could not be found in certain queries. This is normal and to be expected.

Setting the Prompts

Prompt	Instructions
Select ARPA Billing Component:	Select the appropriate ARPA component from the menu. The report can only be run for one ARPA component at a time; agencies with multiple ARPA components will need to submit separate reports per component. If the component for which you're running a report is not in the menu, contact the helpdesk for support. Note: If the wrong ARPA component is selected, the report will provide incorrect KPIs and may also show other inaccurate information.
Select Provider:	Select the provider for which you wish to run the report. If you are unsure whether to select a provider or a reporting group, contact the helpdesk for assistance. Note: If this prompt is completed, the "Select Reporting Group:" prompt must be left incomplete (blank).
Select Reporting Group:	Select the reporting group for which you wish to run the report. If you are unsure whether to select a provider or a reporting group, contact the helpdesk for assistance. Note: If this prompt is completed, the "Select Provider:" prompt must be left incomplete (blank).
Enter Start Date:	Enter the start date for the reporting period in mm/dd/yyyy format. For example, if you're running a report for 07/01/2020-06/30/2021, the date entered in this box would be 07/01/2020.
Enter End Date PLUS 1 Day:	Enter the date after the last date of the reporting period in mm/dd/yyyy format. For example, if you're running a report for 07/01/2020-6/30/2021, the date entered in this box would be 07/01/2021. The answer to this prompt must match the answer to the "Enter effective day" prompt exactly or the report may return invalid results.
Enter effective date	Enter the date after the last date of the reporting period in mm/dd/yyyy format. For example, if you're running a report for 07/01/2020-6/30/2021, the date entered in this box would be 07/01/2021. The answer to this prompt must match the answer to the "Enter End Date PLUS 1 Day:" prompt exactly or the report may return invalid results.
EDA Provider	If a provider is selected in "Select Provider:" above, select the same provider here. If a reporting group is selected in "Select Reporting Group:" above, then select one of the projects within the reporting group.

Using the Report

This report has up to seven tabs, each serving a specific purpose. Tabs with no information are automatically hidden to reduce file size and paper use.

This report does not contain any names or any other directly identifying information about clients so that it may be provided to the St. Louis City Department of Human Services for billing and reimbursement purposes.

Summary

This tab contains multiple tables. The tables shown on the tab will vary based upon ARPA component selected and whether data exists to populate that table.

Key Performance Indicators (KPIs)

A table of key performance indicators (KPIs), as designated by the City of St. Louis, will be the first table on this tab. These numbers should be copied onto the KPI Monthly Report chart provided to the City DHS office for monitoring purposes. If a KPI row says "Non-HMIS," the information for that particular row is not available from HMIS and must be determined from other sources.

For reference, the cells from which the KPIs are pulled are highlighted in yellow boxes with a thick black outline in the tables below the KPI table.

Application Summary

This table appears only for the Bridge Interim Housing, Mortgage Assistance, and Rapid Re-Housing components. This shows the results of applications that were recorded as being received during the report period, plus the information about applications that were processed during the report period.

Enrollment Summary

This table appears for all components and shows the details about project type, total enrolled, newly enrolled, newly exited, exit destinations by category, average length of stay, and average number of clients served on a given night.

Bed Inventory Summary

This table shows a summary of the bed inventory for the shelter(s) included in the report when the Emergency Shelter Operations/Services component is selected.

Service & Referral Summary

This table lists all ARPA-funded service transactions provided, along with the quantity of services and the amount spent on direct financial assistance for each service type. It also shows the number of households and clients who benefited from the specific service type.

Application Detail

This tab shows the list of applications for assistance that were received for the following ARPA component types: Bridge Interim Housing, Mortgage Assistance, and Rapid Re-Housing; these will only appear if one or more applicable applications are present during the report period. All applications that were received during the report period, plus those applications that were processed and closed during the report period, are listed on this tab. For those applications that were processed and closed during the report period, the outcome is also shown.

Enrollment Detail

This tab has a row for each enrollment into one of the selected projects during the report period, and this tab applies to all ARPA component types. If a client has been enrolled in the same project multiple times during the report period, they will have a row for each enrollment. In addition, this table also contains information about entry date, move-in dates (for permanent housing projects), exit dates, lengths of stay from the client's initial entry into the project to either the report period or their exit date, bed nights provided during the report period, and exit destination. In the event there are no enrollments within the report period, the tab will be hidden.

Bed Inventory Detail

This tab will show only if one or more emergency shelter projects is included in the report. When showing, it will provide a list of each bed inventory record which was active during the report period. If any information on this tab is inaccurate, agencies must contact the ICA Missouri Helpdesk for assistance in correcting it. Agencies do not have the ability to modify this data on their own.

Night-by-Night Detail

This tab will show only if one or more nights of stay in a night-by-night emergency shelter is present in the report period and shows each individual night-by-night stay in those shelters.

Service Detail

This tab shows all ARPA-funded service transactions recorded by the providers included in the report during the report period. If a service is recorded but does not show on the report, ensure that the appropriate ARPA funding source was selected in that specific service transaction. This chart indicates the type of service, and if the service was providing referrals, the type of referrals provided, along with the amount of financial assistance provided with that service, if applicable, and the quantity of services provided. In the event that no ARPA-funded service transactions are present in the report period, this tab will be hidden.

Additional Information

This tab contains information about the report that can be utilized by ICA staff to determine whether the report was run properly by the user. If you seek assistance with this report from the ICA Missouri Helpdesk, please be prepared to read/send information off of this tab to the individual who assists you.

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 using the "Contact the Helpdesk" button in the lower right-hand corner of the screen. Please include the name and date of the BusinessObjects report as it appears in your BI Inbox in your request for assistance. Please do not send it as an attachment to the helpdesk unless directly requested by an ICA team member.