SLFRF 2025 Annual/Q1 Report Demonstration

Hi, everyone. My name is Stephanie Johnson, and I'm the Lead Data and Reporting Analyst for SLFRF. Today, I wanted to go over the process of submitting the 2025 report. To do this, you must first log in to id.me or login.gov. Once you've entered the portal and you navigate to this screen, there are some options for you. I wanted to point out, up in this left-hand corner, you can select your account. By selecting your account, you are able to make adjustments to the POCs associated with your jurisdiction. You can update their information, you can remove or add POCs, as well as change their roles. From there, you will want to navigate to your Compliance Reports section. From there, you will have information regarding your prior reports submitted, as well as any that are currently due. To help navigate this screen, you can use this helpful legend on the right side. If there is a blue pencil icon, that means that that report is available for editing and requires additional information. For the blue eye report, this is a report that has already been submitted, and you are able to view it online. You can also use the download icon to download the information of previously submitted reports. For the purposes of this demonstration, we are going to look at the information that is going to be in the annual report for this period. You can navigate to that by identifying the report name, the report type, the report period, as well as the deadline for the report, and the status of this report. Once we enter the portal, you'll be taken to the Introduction and Bulk Uploads Template screen. Here, you are able to scroll down to the bottom and identify the areas that you may need to the .CSV Bulk Upload Templates or the Excel version of the Bulk Upload Templates. Also, on the right side of the screen, you will see some additional information regarding this reporting period. The current status, because we have entered the report, is now in progress. The name of the report, the report type, the report period, the reporting start and end date. For annual reporters, the starting of the reporting period is for April 1, 2024 through March 31, 2025. For quarterly reporters, the reporting period is January 1, 2025 through March 31, 2025. The submission deadline for both reporting types is April 30, 2025. You will also see your allocation amount listed. This is the amount that this report will be covering. You will also see a newly entered screen that shows the income earned. This is a calculation formula that is based off of the information that you are entering throughout the report based off of self-identified program income earned. Next, you'll want to navigate to the Recipient Profile screen. In the Recipient Profile screen, you'll see pre-populated information based off of the information we have. If you scroll down, you will see that there is additional questions in this section. One is to update your, either your previously responded to UEI, or if it is blank, you can update your UEI. Next, you will also see the question regarding if the recipient is registered in SAM.gov. This is a yes or no question. If you answer no, however, you will have additional questions to respond to based off of your jurisdiction. For the demonstration purposes, we are going to say yes, the recipient is registered in SAM.gov. And lastly on this screen, at the bottom, you'll see your point of contact list. These are all of the POCs associated with your jurisdiction. You can see their name, title, phone number, email, as well as the roles they have. However, you cannot make any edits to this information on this screen. You must navigate back to that home screen and select those three lines and enter in through your account. Next, we're going to go to the Project Overview section. In the Project Overview section, if you scroll down, you will see a summary of the information that has previously been entered on prior reports. It will tell us the number of projects, total adopted budget, total obligations listed, total expenditures listed, as well as a calculation of the remaining funds that will be lost if not obligated by December 31st, 2024. In the reporting period for the annual reporters, annual reporters for 2025 will still be reporting obligations that took place in and before December 31st, 2024. Quarterly reporters in Q1 2025 will no longer be reporting on obligations that took place during this period. In this next section, you will see the total obligations reported by Q4 2024. For quarterly reporters, this is the amount that you had identified in your Q4 report as total obligations that took place prior to the obligation deadline. For annual reporters, this is an amount that is currently adjusting based off of your entries in this reporting period. Next, you will see a question. This question only applies to quarterly reporters that did not submit their Q4 2024 report. This is if a recipient failed to report their report in Q4 and was administratively closed. They do have the option, if they were impacted by a natural disaster, to select that option. This only applies to those that did not submit the Q4 2024 report. If this does not apply to you, do not answer this question. Next, you will see another question asking, up to and including this reporting period, have revenue replacement funds been expended for the government services and reflected in the projects below? It's a yes or no question. Because the projects we have below do have expenditure Category 6 for revenue loss, we are going to say yes. The next question is reflecting upon this remaining amount. The recipient has reported obligating $96,000 of their SLRF allocation amount. $4,000 of that has not been reported as obligated. When completed, this report should include all obligations through December 31, 2024, as discussed in FAQ 17.2. Any SLRF funds that were not reported as obligated in this report will need to be returned to the Treasury. Now, the question is, if the recipient attests that they understand that the $4,000 is not reported as obligated in this report and will need to be returned to the Treasury. Because we will be creating a new project to use these funds, we will say that that is not true and we are going to add a new project. As you scroll down, you can see the current statuses of existing projects already in the report. When you go into a new report every reporting period, you will need to go into your project status for every project and update the current period obligation and expenditures. If you have other changes to make in the cumulative amounts, you will also reflect these in that section. But because we are adding no new obligations or expenditures to this project, we would enter the amount of zero. This field is blank at the opening of the report. You must go in and enter zero for these projects prior to moving forward. So we do see that we have a project here that has yellow checkmarks. We need to make adjustments to these fields. To start off with, you will want to review the project status. In here, we are reflecting that we have obligations of $25,000 and cumulative expenditures of $25,000. And we are showing that there are $0 in current period obligations and $0 in current period expenditures. From there, we will start by looking at what our obligation status looks like. Based off of our cumulative obligations in the project status, we say we have $25,000. However, based on the system entries, it is showing we have $50,000. And we can see those reflected in the less than $50,000 expenditure screen. We have two entries for $25,000 and we should only have one. Also, we can look at the current period information. In the current period information, we are reflecting that we have also updated amounts in this section. And again, you will want to do the same exercise with your cumulative expenditures and your current period expenditures. Once we have identified that issue, we know we need to go to the expenditure screen. From there, we can see our project listed below. We see that there was a prior entry. And then we can also see that there is a current period entry in this white line here. There are two ways to edit this. Because it is a current period entry, you can go in and hit delete expenditure. However, I am going to show you how to remove this expenditure if it was a prior period entry. And so what you want to do is enter the project name S2. As information populates, you will want to re-enter the information associated. And we are going to put negative $25,000 in each section. And we're going to update this expenditure. We did get a green checkbox. And now we are showing for this project, we have $25,000 of total obligations and $25,000 of total expenditures. So when we go back to our project overview section, and we scroll back down, and now we can see we have green checkmarks. That means we have fixed the issue that was identified by the yellow checkmarks. We still do have to create a new project for this $4,000. To do this, we are going to add a new project. We're going to select administrative. And we're going to do this as test 7.1. And then the recipient project ID is something set up by the recipient. We're not going to enter an adopted budget for this project. And then you are going to list your total obligations and total expenditures. In this section, you would have to enter any program income that had been earned or expended prior to 2024. In the below section is obligations and expenditures. That have been taking place after the 2024 deadline, as well as expenditures for the 2024 deadline for the program income. Next for the project, we are going to show that this project is completed. And we are going to enter in the project start date, as well as the project end date. Also, you'll want to make sure that you are including a project description as detailed as possible. Okay, now we are adding our project. As we wait for the project to replicate, we can see that we have the scenario again with the yellow checkmarks. This is because we have entered $4,000 in the project status. However, we have not entered that $4,000 into the other sections of the reporting portal. So to do that, we will again need to go back to the expenditures section because it is a less than $50,000 obligation. And we will need to pull up the new project and the information will populate. From there, we will do our enter information. And it is $4,000 obligations and $4,000 for expenditures. And we will create this new entry. And now we have the new entry created. Now when we go back to our project overview, we will see that we have all green checkmarks again. From there, we are showing that we have fully obligated all of our funds. And we want to continue through the reporting tabs to make sure that all other sections have been fully completed. You always want to make sure that any question that has a red asterisk, there is a response to. It always is good practice to make sure that you have these fields completed. Lastly, you will navigate to the certification section. From there, you will get a project overview status. Again, if you had any errors of different colored checkmarks, they would show up in this section of incomplete below. And that would tell you to go back to your project overview section to make those updates. Also, you will see all the complete projects listed. You will have a summary of all of the information you have entered. And this amount is now updated to zero because we are showing that we have obligated our full allocation amount. Again, your allocation amount is located on the right side of the screen. You will also have additional information regarding the number of projects you have in this section. Next, you will have to answer some questions regarding the Federal Audit Clearinghouse. This is if you have expended $750,000 or more in federal awards during the most recent completed fiscal year, if that fiscal year ended before October 1st, 2024. If your most recent fiscal year ended on or after October 1st, 2024, have you expended more than a million dollars in federal awards? This is a yes or no question. If you answer yes, there will be follow-up questions. However, we did not, so we will answer no. Next, you will have the Alternative Compliance Examination Engagement. Here, this is for recipient entries expending more than $750,000 for fiscal years ending before October 1st, 2024, or a million dollars for fiscal years ending on or after October 1st, 2024. They are now subject to single audit requirements. Together with the Office of Management and Budget and other stakeholders, we developed the Alternative Compliance Examination Engagement. For qualified SLFRF recipients, the ACE is a voluntary alternative to required full single audit that is less burdensome, but still upholds good stewardship by focusing on activities allowed and unallowed and allowable cost and cost principles. For this section, I do want to highlight if you are uploading an ACE, you must answer yes to all of these questions for the ACE portal to be generated for you. You will be able to access the ACE portal by either this hyperlink on your report or in the same section where you went to complete your compliance report, if you go to the Introduction tab, you can scroll down and you may access the ACE that way, or there may be a new section for you on the left side of your screen. For the purposes of this demo, we are saying yes, we would like to submit an ACE. Lastly, you're going to want to read through your Statement of Certification, and you are in the role of authorized representative for reporting and the submission of this record and certifying and submitting this report on your jurisdiction's behalf. You will see your information populate in this section below. And then once that is there, you can select Certify and Submit. And once that is done, your progress will update to a submitted status after your report has saved. From there, we ask that you please fill out the survey based off of how we are doing, and you can submit that survey. And once you are done, you can go back to your compliance records and look up your report, and you can now see that it is in a submitted status. You can still view and download this report. And again, this is also the area where you will be able to access your account to update any information. And that is all we have for today on the demo. Please follow up with us if you have any questions. Thank you.