Audit 8371

FY End
2023-06-30
Total Expended
$167.94M
Findings
0
Programs
35
Organization: City of Portland (OR)
Year: 2023 Accepted: 2023-12-22
Auditor: Moss Adams

Organization Exclusion Status:

Checking exclusion status...

Findings

No findings recorded

Programs

ALN Program Spent Major Findings
14.239 Home Investment Partnerships Program $60.94M Yes 0
21.027 Coronavirus State and Local Fiscal Recovery Funds $57.23M Yes 0
11.307 Economic Adjustment Assistance $4.14M - 0
14.241 Housing Opportunities for Persons with Aids $1.66M - 0
14.905 Lead Hazard Reduction Demonstration Grant Program $1.47M - 0
14.231 Emergency Solutions Grant Program $848,382 - 0
97.042 Emergency Management Performance Grants $312,029 - 0
97.083 Staffing for Adequate Fire and Emergency Response (safer) $261,656 - 0
97.036 Disaster Grants - Public Assistance (presidentially Declared Disasters) $214,594 - 0
20.530 Public Transportation Innovation $202,976 - 0
10.177 Regional Food System Partnerships (b) $144,665 - 0
97.039 Hazard Mitigation Grant $139,160 - 0
16.752 Economic High-Tech and Cyber Crime Prevention $115,380 - 0
21.023 Emergency Rental Assistance Program $115,185 - 0
16.817 Byrne Criminal Justice Innovation Program $93,119 - 0
66.818 Brownfields Assessment and Cleanup Cooperative Agreements $85,689 - 0
97.044 Assistance to Firefighters Grant $75,632 - 0
16.738 Edward Byrne Memorial Justice Assistance Grant Program $70,155 - 0
21.016 Equitable Sharing $66,446 - 0
16.753 Congressionally Recommended Awards $66,377 - 0
20.507 Federal Transit_formula Grants $55,101 - 0
93.945 Assistance Programs for Chronic Disease Prevention and Control $54,687 - 0
16.833 National Sexual Assault Kit Initiative $49,110 - 0
10.558 Child and Adult Care Food Program $41,772 - 0
14.267 Continuum of Care Program $38,483 - 0
20.500 Federal Transit_capital Investment Grants $29,342 - 0
20.614 National Highway Traffic Safety Administration (nhtsa) Discretionary Safety Grants $28,432 - 0
20.616 National Priority Safety Programs $16,938 - 0
15.904 Historic Preservation Fund Grants-in-Aid $15,603 - 0
20.205 Highway Planning and Construction $7,857 - 0
14.218 Community Development Block Grants/entitlement Grants $4,734 - 0
16.922 Equitable Sharing Program $2,184 - 0
15.657 Endangered Species Conservation Ð Recovery Implementation Funds $2,166 - 0
97.067 Homeland Security Grant Program $1,729 Yes 0
20.600 State and Community Highway Safety $1,260 - 0

Contacts

Name Title Type
N5NMTXG2UE65 Sheila Craig Auditee
5038236863 Keith Simovic Auditor
No contacts on file

Notes to SEFA

Title: Basis of Presentation Accounting Policies: Expenditures reported on the Schedule are reported on the modified accrual basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance wherein certain types of expenditures are not allowed or are limited as to reimbursement. Negative amounts shown on the Schedule or Notes to the Schedule represent adjustments or credits made in the normal course of business to amounts reported as expenditures in prior years. Pass-through entity identifying numbers are presented where applicable. De Minimis Rate Used: N Rate Explanation: City develops an annual Indirect Cost Rate Allocation plan following 2 CFR 200 certification process. The accompanying schedule of expenditures of federal awards (the Schedule) includes the federal grant activity of the City of Portland, Oregon (the "City") under programs of the federal government for the year ended June 30, 2023. The information in this Schedule is presented in accordance with the requirements of Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance). Because the Schedule presents only a selected portion of the operations of the City, it is not intended to and does not present the financial position, changes in net position or cash flows of the City.
Title: Summary of Significant Accounting Policies Accounting Policies: Expenditures reported on the Schedule are reported on the modified accrual basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance wherein certain types of expenditures are not allowed or are limited as to reimbursement. Negative amounts shown on the Schedule or Notes to the Schedule represent adjustments or credits made in the normal course of business to amounts reported as expenditures in prior years. Pass-through entity identifying numbers are presented where applicable. De Minimis Rate Used: N Rate Explanation: City develops an annual Indirect Cost Rate Allocation plan following 2 CFR 200 certification process. Expenditures reported on the Schedule are reported on the modified accrual basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance wherein certain types of expenditures are not allowable or are limited as to reimbursement. Negative amounts shown on the Schedule or Notes to the Schedule represent adjustments or credits made in the normal course of business to amounts reported as expenditures in prior years. Pass-through entity identifying numbers are presented where applicable
Title: Federal Loan Programs Accounting Policies: Expenditures reported on the Schedule are reported on the modified accrual basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance wherein certain types of expenditures are not allowed or are limited as to reimbursement. Negative amounts shown on the Schedule or Notes to the Schedule represent adjustments or credits made in the normal course of business to amounts reported as expenditures in prior years. Pass-through entity identifying numbers are presented where applicable. De Minimis Rate Used: N Rate Explanation: City develops an annual Indirect Cost Rate Allocation plan following 2 CFR 200 certification process. The federal loans under the federal program listed subsequently are administered directly by the City and balances and transactions relating to this program are included in the City's basic financial statements. Loans outstanding at the beginning of the year and loans made during the year are included in the federal expenditures presented in the Schedule. The balance of loans outstanding at June 30, 2023 consists of: Federal Assistance Listing Number: 14.239 Program Name: US Department of Housing and Urban Development HOME Investment Partnerships Program Outstanding Balance at June 30, 2023: $60,940,871
Title: Election of De Minimis Indirect Rate Accounting Policies: Expenditures reported on the Schedule are reported on the modified accrual basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance wherein certain types of expenditures are not allowed or are limited as to reimbursement. Negative amounts shown on the Schedule or Notes to the Schedule represent adjustments or credits made in the normal course of business to amounts reported as expenditures in prior years. Pass-through entity identifying numbers are presented where applicable. De Minimis Rate Used: N Rate Explanation: City develops an annual Indirect Cost Rate Allocation plan following 2 CFR 200 certification process. During the year ended June 30, 2023, the City did not elect to use the ten percent de minimis indirect cost rate allowed under the Uniform Guidance.
Title: Economic Adjustment Assistance Program Accounting Policies: Expenditures reported on the Schedule are reported on the modified accrual basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance wherein certain types of expenditures are not allowed or are limited as to reimbursement. Negative amounts shown on the Schedule or Notes to the Schedule represent adjustments or credits made in the normal course of business to amounts reported as expenditures in prior years. Pass-through entity identifying numbers are presented where applicable. De Minimis Rate Used: N Rate Explanation: City develops an annual Indirect Cost Rate Allocation plan following 2 CFR 200 certification process. The City has an EDA revolving loan fund (RLF) under the Economic Adjustment Assistance Program, Federal Assistance Listing Number 11.307. According to the OMB Compliance Supplement, for purposes of completing the Schedule, each EDA RLF (Federal Assistance Listing Number 11.307) should be shown as a separate line item calculated as follows: 1. Balance of RLF loans outstanding at the end of the recipient's fiscal year, plus 2. Cash and investment balance in the RLF at the end of the recipient's fiscal year, plus 3. Administrative expenses paid out of RLF income during the recipient's fiscal year, multiplied by 4. The Federal share of the RLF. The Federal share is defined as the Federal participation rate (or the Federal grant rate) as specified in the grant award. The figures used in this calculation to arrive at the RLF amount to be shown on the Schedule are as of June 30, 2023, and the calculation is as follows: Federal Assistance Listing Number Program Name Outstanding Balance at June 30, 2023 11.307 US Department of Commerce Economic Adjustment Assistance Program-EDA Revolving Loan Fund $ 4,138,805 EDA Agreement #07-79-07618 Loans Receivable $ 1,203,366 Cash $ 180,241 Administrative Costs $ 9,199 $ 1,392,806 Federal Participation Rate 100% Federal Share of Revolving Loan Fund $ 1,392,806 EDA Agreement #07-39-02259 Loans Receivable $ 1,129,165 Cash $ 1,594,008 Administrative Costs $ 72,485 $ 2,795,658 Federal Participation Rate 98% Federal Share of Revolving Loan Fund $ 2,745,999 Total Federal Share of Revolving Loan Fund $ 4,138,805