Audit 348728

FY End
2024-06-30
Total Expended
$31.82M
Findings
26
Programs
30
Year: 2024 Accepted: 2025-03-26

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
537488 2024-003 Significant Deficiency - GL
537489 2024-003 Significant Deficiency - GL
537490 2024-003 Significant Deficiency - GL
537491 2024-003 Significant Deficiency - GL
537492 2024-003 Significant Deficiency - GL
537493 2024-003 Significant Deficiency - GL
537494 2024-003 Significant Deficiency - GL
537495 2024-003 Significant Deficiency - GL
537496 2024-003 Significant Deficiency - GL
537497 2024-003 Significant Deficiency - GL
537498 2024-003 Significant Deficiency - GL
537499 2024-003 Significant Deficiency - GL
537500 2024-003 Significant Deficiency - GL
1113930 2024-003 Significant Deficiency - GL
1113931 2024-003 Significant Deficiency - GL
1113932 2024-003 Significant Deficiency - GL
1113933 2024-003 Significant Deficiency - GL
1113934 2024-003 Significant Deficiency - GL
1113935 2024-003 Significant Deficiency - GL
1113936 2024-003 Significant Deficiency - GL
1113937 2024-003 Significant Deficiency - GL
1113938 2024-003 Significant Deficiency - GL
1113939 2024-003 Significant Deficiency - GL
1113940 2024-003 Significant Deficiency - GL
1113941 2024-003 Significant Deficiency - GL
1113942 2024-003 Significant Deficiency - GL

Programs

ALN Program Spent Major Findings
20.106 Airport Improvement Program, Infrastructure Investment and Jobs Act Programs, and Covid-19 Airports Programs $8.81M Yes 1
21.032 Local Assistance and Tribal Consistency Fund $1.32M - 0
93.434 Every Student Succeeds Act/preschool Development Grants $701,321 - 0
14.228 Community Development Block Grants/state's Program and Non-Entitlement Grants in Hawaii $301,802 - 0
93.391 Activities to Support State, Tribal, Local and Territorial (stlt) Health Department Response to Public Health Or Healthcare Crises $300,433 - 0
93.959 Block Grants for Prevention and Treatment of Substance Abuse $270,126 - 0
45.310 Grants to States $247,376 - 0
93.623 Basic Center Grant $187,500 - 0
16.710 Public Safety Partnership and Community Policing Grants $100,624 - 0
93.104 Comprehensive Community Mental Health Services for Children with Serious Emotional Disturbances (sed) $100,000 - 0
15.611 Wildlife Restoration and Basic Hunter Education and Safety $77,243 - 0
97.042 Emergency Management Performance Grants $75,866 - 0
95.001 High Intensity Drug Trafficking Areas Program $64,893 - 0
97.067 Homeland Security Grant Program $60,971 - 0
97.082 Earthquake State Assistance $45,000 - 0
16.922 Equitable Sharing Program $40,278 - 0
10.665 Schools and Roads - Grants to States $35,306 - 0
20.219 Recreational Trails Program $30,481 - 0
20.526 Buses and Bus Facilities Formula, Competitive, and Low Or No Emissions Programs $21,320 Yes 0
20.509 Formula Grants for Rural Areas and Tribal Transit Program $17,972 - 0
16.738 Edward Byrne Memorial Justice Assistance Grant Program $17,799 - 0
97.044 Assistance to Firefighters Grant $17,455 - 0
93.301 Small Rural Hospital Improvement Grant Program $11,550 - 0
20.224 Federal Lands Access Program $10,076 - 0
16.607 Bulletproof Vest Partnership Program $5,772 - 0
16.543 Missing Children's Assistance $5,000 - 0
20.600 State and Community Highway Safety $3,438 - 0
20.616 National Priority Safety Programs $780 - 0
45.164 Promotion of the Humanities Public Programs $459 - 0
15.904 Historic Preservation Fund Grants-in-Aid $365 - 0

Contacts

Name Title Type
D3A1DKUM8X91 Angie Flick Auditee
9075865215 Karen Tarver Auditor
No contacts on file

Notes to SEFA

Title: Relationship to Basic Financial Statements Accounting Policies: General The accompanying schedule of expenditures of federal awards (SEFA) presents the activity of all federal financial assistance programs of the City and Borough of Juneau, Alaska (City and Borough). The information in the SEFA 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). Federal awards received directly from federal agencies, as well as federal financial assistance passed through the State of Alaska and other agencies, are included in the SEFA. The City and Borough's reporting entity is defined in Note 1 to the City and Borough’s basic financial statements. Basis of Accounting and Indirect Cost Rate Expenditures reported in the accompanying SEFA are presented using the modified-accrual and accrual basis of accounting, which are described in Note 1 to the City and Borough’s basic financial statements. Such expenditures are recognized following the cost principles contained in the Uniform Guidance and OMB circulars, as applicable, wherein certain types of expenditures are not allowable or are limited as to reimbursement. The following programs may report expenditures on the SEFA using reporting criteria, established by the grantor for the program, which may include prior period expenditures or another basis of satisfying grant reporting requirements: ALN 66.458 and 66.468 EPA Clean Water and Drinking Water Revolving Funds Under this program the City and Borough only reports project expenditures when expenditures have been incurred and reimbursement requested from the awarding agency, because it is considered a subaward, not a direct federal loan. This may result in prior period expenditures being reported on the SEFA. The loan reporting requirements of 2 CFR sections 200.502(b) or (d) do not apply when calculating the amount of federal funds expended. There were no reimbursement requests in fiscal year 2024. The City and Borough has elected not to use the 10-percent de minimis indirect cost rate as allowed under the Uniform Guidance. De Minimis Rate Used: N Rate Explanation: The City and Borough has elected not to use the 10-percent de minimis indirect cost rate as allowed under the Uniform Guidance. The following is a reconciliation of federal revenues reported in the City and Borough’s basic financial statements to federal expenditures reported in the SEFA: Federal revenues as reported in the basic financial statements: Statement of Revenues, Expenditures, and Changes in Fund Balances - Governmental Funds $ 5,533,995 Statement of Revenues, Expenses, and Changes in Net Position - Proprietary Funds 3,636,670 Add: Amounts reported as federal expenditures in the SEFA, but not reported as federal revenue in the basic financial statements: Bartlett Regional Hospital federal grants 659,631 Federal grants passed through the State of Alaska 4,172,199 Federal grants reported as other revenue in the basic financial statements 44,509 Federal grant and loan sources reported as capital contributions in Juneau International Airport, Boat Harbors, and Dock enterprise funds 22,084,645 Less: Amounts reported as federal revenue in the basic financial statements but not included in the SEFA: Revenue reported in prior year SEFA, but not recognized in basic financial statements until fiscal year 2024 (113,394) Payments in Lieu of Taxes and National Forest Receipts (3,286,563) Airport ARPA and ACRGP adjustment (326,284) Juneau International Airport Transportation Security (582,625) Total federal expenditures as reported in the SEFA $ 31,822,783

Finding Details

2024-003: Significant Deficiency in Internal Controls over Compliance and Compliance – Setup and Monitoring of Reporting and Match Agency: U.S. Department of Transportation, Federal Aviation Administration Program(s) and Federal Award Listing Number(s): Airport Improvement Program ALN: 20.106 FAIN: 3-02-0133-092-2022, 3-02-0133-098-2023, 3-02-0133-100-2023 New or Repeat: New Criteria: 2 CFR 200.303 requires internal controls to ensure accuracy in financial reporting, while 2 CFR 200.306 mandates proper tracking and documentation of matching contributions. Condition: Internal controls were not sufficiently designed and implemented to ensure that matching funds were correctly allocated in accordance with grant requirements. As a result, errors in the match setup were not detected in a timely manner, leading to discrepancies between the financial data provided for audit and the City and Borough’s prepared reports submitted to the grantor. Internal controls over reporting were not designed or implemented to detect and correct the errors prior to report submission. Context: The City and Borough’s financial system was not properly configured to allocate matching funds correctly, resulting in discrepancies in reported amounts. Specifically, an under-allocation to an Airport Improvement Program (AIP) grant and an over-allocation to the match occurred in one project of $474,704 and an under-allocation to match and over-allocation of $107,651 to two other AIP grants occurred. Effect: Overall expenses were under-allocated to the AIP and over-allocated to match funding. The overall impact of these errors resulted in discrepancies between reported amounts and supporting documentation. Due to amount reported as AIP costs being under-reported, this is considered immaterial non-compliance and is reported as an other matter. Questioned costs: No questioned costs as overall program impact was the under-allocation of expenses to the grants as of June 30, 2024. The City and Borough elected not to adjust the amounts reported in the schedule of expenditures of federal awards, since allocations and reports can be corrected in the following reporting year. Cause: Internal controls were not designed or implemented to detect the incorrect system configuration for allocating project expenses between grant and match funds in a timely manner, nor was the report preparation review process sufficiently designed or implemented to detect and correct the under-and over-allocations of project costs being reported. Recommendation: We recommend the City and Borough improve monitoring controls over the setup for project expense allocations and the review controls over report preparation process to ensure that errors are detected and corrected in a timely manner. View of responsible officials: Management concurs with this finding, see corrective action plan.
2024-003: Significant Deficiency in Internal Controls over Compliance and Compliance – Setup and Monitoring of Reporting and Match Agency: U.S. Department of Transportation, Federal Aviation Administration Program(s) and Federal Award Listing Number(s): Airport Improvement Program ALN: 20.106 FAIN: 3-02-0133-092-2022, 3-02-0133-098-2023, 3-02-0133-100-2023 New or Repeat: New Criteria: 2 CFR 200.303 requires internal controls to ensure accuracy in financial reporting, while 2 CFR 200.306 mandates proper tracking and documentation of matching contributions. Condition: Internal controls were not sufficiently designed and implemented to ensure that matching funds were correctly allocated in accordance with grant requirements. As a result, errors in the match setup were not detected in a timely manner, leading to discrepancies between the financial data provided for audit and the City and Borough’s prepared reports submitted to the grantor. Internal controls over reporting were not designed or implemented to detect and correct the errors prior to report submission. Context: The City and Borough’s financial system was not properly configured to allocate matching funds correctly, resulting in discrepancies in reported amounts. Specifically, an under-allocation to an Airport Improvement Program (AIP) grant and an over-allocation to the match occurred in one project of $474,704 and an under-allocation to match and over-allocation of $107,651 to two other AIP grants occurred. Effect: Overall expenses were under-allocated to the AIP and over-allocated to match funding. The overall impact of these errors resulted in discrepancies between reported amounts and supporting documentation. Due to amount reported as AIP costs being under-reported, this is considered immaterial non-compliance and is reported as an other matter. Questioned costs: No questioned costs as overall program impact was the under-allocation of expenses to the grants as of June 30, 2024. The City and Borough elected not to adjust the amounts reported in the schedule of expenditures of federal awards, since allocations and reports can be corrected in the following reporting year. Cause: Internal controls were not designed or implemented to detect the incorrect system configuration for allocating project expenses between grant and match funds in a timely manner, nor was the report preparation review process sufficiently designed or implemented to detect and correct the under-and over-allocations of project costs being reported. Recommendation: We recommend the City and Borough improve monitoring controls over the setup for project expense allocations and the review controls over report preparation process to ensure that errors are detected and corrected in a timely manner. View of responsible officials: Management concurs with this finding, see corrective action plan.
2024-003: Significant Deficiency in Internal Controls over Compliance and Compliance – Setup and Monitoring of Reporting and Match Agency: U.S. Department of Transportation, Federal Aviation Administration Program(s) and Federal Award Listing Number(s): Airport Improvement Program ALN: 20.106 FAIN: 3-02-0133-092-2022, 3-02-0133-098-2023, 3-02-0133-100-2023 New or Repeat: New Criteria: 2 CFR 200.303 requires internal controls to ensure accuracy in financial reporting, while 2 CFR 200.306 mandates proper tracking and documentation of matching contributions. Condition: Internal controls were not sufficiently designed and implemented to ensure that matching funds were correctly allocated in accordance with grant requirements. As a result, errors in the match setup were not detected in a timely manner, leading to discrepancies between the financial data provided for audit and the City and Borough’s prepared reports submitted to the grantor. Internal controls over reporting were not designed or implemented to detect and correct the errors prior to report submission. Context: The City and Borough’s financial system was not properly configured to allocate matching funds correctly, resulting in discrepancies in reported amounts. Specifically, an under-allocation to an Airport Improvement Program (AIP) grant and an over-allocation to the match occurred in one project of $474,704 and an under-allocation to match and over-allocation of $107,651 to two other AIP grants occurred. Effect: Overall expenses were under-allocated to the AIP and over-allocated to match funding. The overall impact of these errors resulted in discrepancies between reported amounts and supporting documentation. Due to amount reported as AIP costs being under-reported, this is considered immaterial non-compliance and is reported as an other matter. Questioned costs: No questioned costs as overall program impact was the under-allocation of expenses to the grants as of June 30, 2024. The City and Borough elected not to adjust the amounts reported in the schedule of expenditures of federal awards, since allocations and reports can be corrected in the following reporting year. Cause: Internal controls were not designed or implemented to detect the incorrect system configuration for allocating project expenses between grant and match funds in a timely manner, nor was the report preparation review process sufficiently designed or implemented to detect and correct the under-and over-allocations of project costs being reported. Recommendation: We recommend the City and Borough improve monitoring controls over the setup for project expense allocations and the review controls over report preparation process to ensure that errors are detected and corrected in a timely manner. View of responsible officials: Management concurs with this finding, see corrective action plan.
2024-003: Significant Deficiency in Internal Controls over Compliance and Compliance – Setup and Monitoring of Reporting and Match Agency: U.S. Department of Transportation, Federal Aviation Administration Program(s) and Federal Award Listing Number(s): Airport Improvement Program ALN: 20.106 FAIN: 3-02-0133-092-2022, 3-02-0133-098-2023, 3-02-0133-100-2023 New or Repeat: New Criteria: 2 CFR 200.303 requires internal controls to ensure accuracy in financial reporting, while 2 CFR 200.306 mandates proper tracking and documentation of matching contributions. Condition: Internal controls were not sufficiently designed and implemented to ensure that matching funds were correctly allocated in accordance with grant requirements. As a result, errors in the match setup were not detected in a timely manner, leading to discrepancies between the financial data provided for audit and the City and Borough’s prepared reports submitted to the grantor. Internal controls over reporting were not designed or implemented to detect and correct the errors prior to report submission. Context: The City and Borough’s financial system was not properly configured to allocate matching funds correctly, resulting in discrepancies in reported amounts. Specifically, an under-allocation to an Airport Improvement Program (AIP) grant and an over-allocation to the match occurred in one project of $474,704 and an under-allocation to match and over-allocation of $107,651 to two other AIP grants occurred. Effect: Overall expenses were under-allocated to the AIP and over-allocated to match funding. The overall impact of these errors resulted in discrepancies between reported amounts and supporting documentation. Due to amount reported as AIP costs being under-reported, this is considered immaterial non-compliance and is reported as an other matter. Questioned costs: No questioned costs as overall program impact was the under-allocation of expenses to the grants as of June 30, 2024. The City and Borough elected not to adjust the amounts reported in the schedule of expenditures of federal awards, since allocations and reports can be corrected in the following reporting year. Cause: Internal controls were not designed or implemented to detect the incorrect system configuration for allocating project expenses between grant and match funds in a timely manner, nor was the report preparation review process sufficiently designed or implemented to detect and correct the under-and over-allocations of project costs being reported. Recommendation: We recommend the City and Borough improve monitoring controls over the setup for project expense allocations and the review controls over report preparation process to ensure that errors are detected and corrected in a timely manner. View of responsible officials: Management concurs with this finding, see corrective action plan.
2024-003: Significant Deficiency in Internal Controls over Compliance and Compliance – Setup and Monitoring of Reporting and Match Agency: U.S. Department of Transportation, Federal Aviation Administration Program(s) and Federal Award Listing Number(s): Airport Improvement Program ALN: 20.106 FAIN: 3-02-0133-092-2022, 3-02-0133-098-2023, 3-02-0133-100-2023 New or Repeat: New Criteria: 2 CFR 200.303 requires internal controls to ensure accuracy in financial reporting, while 2 CFR 200.306 mandates proper tracking and documentation of matching contributions. Condition: Internal controls were not sufficiently designed and implemented to ensure that matching funds were correctly allocated in accordance with grant requirements. As a result, errors in the match setup were not detected in a timely manner, leading to discrepancies between the financial data provided for audit and the City and Borough’s prepared reports submitted to the grantor. Internal controls over reporting were not designed or implemented to detect and correct the errors prior to report submission. Context: The City and Borough’s financial system was not properly configured to allocate matching funds correctly, resulting in discrepancies in reported amounts. Specifically, an under-allocation to an Airport Improvement Program (AIP) grant and an over-allocation to the match occurred in one project of $474,704 and an under-allocation to match and over-allocation of $107,651 to two other AIP grants occurred. Effect: Overall expenses were under-allocated to the AIP and over-allocated to match funding. The overall impact of these errors resulted in discrepancies between reported amounts and supporting documentation. Due to amount reported as AIP costs being under-reported, this is considered immaterial non-compliance and is reported as an other matter. Questioned costs: No questioned costs as overall program impact was the under-allocation of expenses to the grants as of June 30, 2024. The City and Borough elected not to adjust the amounts reported in the schedule of expenditures of federal awards, since allocations and reports can be corrected in the following reporting year. Cause: Internal controls were not designed or implemented to detect the incorrect system configuration for allocating project expenses between grant and match funds in a timely manner, nor was the report preparation review process sufficiently designed or implemented to detect and correct the under-and over-allocations of project costs being reported. Recommendation: We recommend the City and Borough improve monitoring controls over the setup for project expense allocations and the review controls over report preparation process to ensure that errors are detected and corrected in a timely manner. View of responsible officials: Management concurs with this finding, see corrective action plan.
2024-003: Significant Deficiency in Internal Controls over Compliance and Compliance – Setup and Monitoring of Reporting and Match Agency: U.S. Department of Transportation, Federal Aviation Administration Program(s) and Federal Award Listing Number(s): Airport Improvement Program ALN: 20.106 FAIN: 3-02-0133-092-2022, 3-02-0133-098-2023, 3-02-0133-100-2023 New or Repeat: New Criteria: 2 CFR 200.303 requires internal controls to ensure accuracy in financial reporting, while 2 CFR 200.306 mandates proper tracking and documentation of matching contributions. Condition: Internal controls were not sufficiently designed and implemented to ensure that matching funds were correctly allocated in accordance with grant requirements. As a result, errors in the match setup were not detected in a timely manner, leading to discrepancies between the financial data provided for audit and the City and Borough’s prepared reports submitted to the grantor. Internal controls over reporting were not designed or implemented to detect and correct the errors prior to report submission. Context: The City and Borough’s financial system was not properly configured to allocate matching funds correctly, resulting in discrepancies in reported amounts. Specifically, an under-allocation to an Airport Improvement Program (AIP) grant and an over-allocation to the match occurred in one project of $474,704 and an under-allocation to match and over-allocation of $107,651 to two other AIP grants occurred. Effect: Overall expenses were under-allocated to the AIP and over-allocated to match funding. The overall impact of these errors resulted in discrepancies between reported amounts and supporting documentation. Due to amount reported as AIP costs being under-reported, this is considered immaterial non-compliance and is reported as an other matter. Questioned costs: No questioned costs as overall program impact was the under-allocation of expenses to the grants as of June 30, 2024. The City and Borough elected not to adjust the amounts reported in the schedule of expenditures of federal awards, since allocations and reports can be corrected in the following reporting year. Cause: Internal controls were not designed or implemented to detect the incorrect system configuration for allocating project expenses between grant and match funds in a timely manner, nor was the report preparation review process sufficiently designed or implemented to detect and correct the under-and over-allocations of project costs being reported. Recommendation: We recommend the City and Borough improve monitoring controls over the setup for project expense allocations and the review controls over report preparation process to ensure that errors are detected and corrected in a timely manner. View of responsible officials: Management concurs with this finding, see corrective action plan.
2024-003: Significant Deficiency in Internal Controls over Compliance and Compliance – Setup and Monitoring of Reporting and Match Agency: U.S. Department of Transportation, Federal Aviation Administration Program(s) and Federal Award Listing Number(s): Airport Improvement Program ALN: 20.106 FAIN: 3-02-0133-092-2022, 3-02-0133-098-2023, 3-02-0133-100-2023 New or Repeat: New Criteria: 2 CFR 200.303 requires internal controls to ensure accuracy in financial reporting, while 2 CFR 200.306 mandates proper tracking and documentation of matching contributions. Condition: Internal controls were not sufficiently designed and implemented to ensure that matching funds were correctly allocated in accordance with grant requirements. As a result, errors in the match setup were not detected in a timely manner, leading to discrepancies between the financial data provided for audit and the City and Borough’s prepared reports submitted to the grantor. Internal controls over reporting were not designed or implemented to detect and correct the errors prior to report submission. Context: The City and Borough’s financial system was not properly configured to allocate matching funds correctly, resulting in discrepancies in reported amounts. Specifically, an under-allocation to an Airport Improvement Program (AIP) grant and an over-allocation to the match occurred in one project of $474,704 and an under-allocation to match and over-allocation of $107,651 to two other AIP grants occurred. Effect: Overall expenses were under-allocated to the AIP and over-allocated to match funding. The overall impact of these errors resulted in discrepancies between reported amounts and supporting documentation. Due to amount reported as AIP costs being under-reported, this is considered immaterial non-compliance and is reported as an other matter. Questioned costs: No questioned costs as overall program impact was the under-allocation of expenses to the grants as of June 30, 2024. The City and Borough elected not to adjust the amounts reported in the schedule of expenditures of federal awards, since allocations and reports can be corrected in the following reporting year. Cause: Internal controls were not designed or implemented to detect the incorrect system configuration for allocating project expenses between grant and match funds in a timely manner, nor was the report preparation review process sufficiently designed or implemented to detect and correct the under-and over-allocations of project costs being reported. Recommendation: We recommend the City and Borough improve monitoring controls over the setup for project expense allocations and the review controls over report preparation process to ensure that errors are detected and corrected in a timely manner. View of responsible officials: Management concurs with this finding, see corrective action plan.
2024-003: Significant Deficiency in Internal Controls over Compliance and Compliance – Setup and Monitoring of Reporting and Match Agency: U.S. Department of Transportation, Federal Aviation Administration Program(s) and Federal Award Listing Number(s): Airport Improvement Program ALN: 20.106 FAIN: 3-02-0133-092-2022, 3-02-0133-098-2023, 3-02-0133-100-2023 New or Repeat: New Criteria: 2 CFR 200.303 requires internal controls to ensure accuracy in financial reporting, while 2 CFR 200.306 mandates proper tracking and documentation of matching contributions. Condition: Internal controls were not sufficiently designed and implemented to ensure that matching funds were correctly allocated in accordance with grant requirements. As a result, errors in the match setup were not detected in a timely manner, leading to discrepancies between the financial data provided for audit and the City and Borough’s prepared reports submitted to the grantor. Internal controls over reporting were not designed or implemented to detect and correct the errors prior to report submission. Context: The City and Borough’s financial system was not properly configured to allocate matching funds correctly, resulting in discrepancies in reported amounts. Specifically, an under-allocation to an Airport Improvement Program (AIP) grant and an over-allocation to the match occurred in one project of $474,704 and an under-allocation to match and over-allocation of $107,651 to two other AIP grants occurred. Effect: Overall expenses were under-allocated to the AIP and over-allocated to match funding. The overall impact of these errors resulted in discrepancies between reported amounts and supporting documentation. Due to amount reported as AIP costs being under-reported, this is considered immaterial non-compliance and is reported as an other matter. Questioned costs: No questioned costs as overall program impact was the under-allocation of expenses to the grants as of June 30, 2024. The City and Borough elected not to adjust the amounts reported in the schedule of expenditures of federal awards, since allocations and reports can be corrected in the following reporting year. Cause: Internal controls were not designed or implemented to detect the incorrect system configuration for allocating project expenses between grant and match funds in a timely manner, nor was the report preparation review process sufficiently designed or implemented to detect and correct the under-and over-allocations of project costs being reported. Recommendation: We recommend the City and Borough improve monitoring controls over the setup for project expense allocations and the review controls over report preparation process to ensure that errors are detected and corrected in a timely manner. View of responsible officials: Management concurs with this finding, see corrective action plan.
2024-003: Significant Deficiency in Internal Controls over Compliance and Compliance – Setup and Monitoring of Reporting and Match Agency: U.S. Department of Transportation, Federal Aviation Administration Program(s) and Federal Award Listing Number(s): Airport Improvement Program ALN: 20.106 FAIN: 3-02-0133-092-2022, 3-02-0133-098-2023, 3-02-0133-100-2023 New or Repeat: New Criteria: 2 CFR 200.303 requires internal controls to ensure accuracy in financial reporting, while 2 CFR 200.306 mandates proper tracking and documentation of matching contributions. Condition: Internal controls were not sufficiently designed and implemented to ensure that matching funds were correctly allocated in accordance with grant requirements. As a result, errors in the match setup were not detected in a timely manner, leading to discrepancies between the financial data provided for audit and the City and Borough’s prepared reports submitted to the grantor. Internal controls over reporting were not designed or implemented to detect and correct the errors prior to report submission. Context: The City and Borough’s financial system was not properly configured to allocate matching funds correctly, resulting in discrepancies in reported amounts. Specifically, an under-allocation to an Airport Improvement Program (AIP) grant and an over-allocation to the match occurred in one project of $474,704 and an under-allocation to match and over-allocation of $107,651 to two other AIP grants occurred. Effect: Overall expenses were under-allocated to the AIP and over-allocated to match funding. The overall impact of these errors resulted in discrepancies between reported amounts and supporting documentation. Due to amount reported as AIP costs being under-reported, this is considered immaterial non-compliance and is reported as an other matter. Questioned costs: No questioned costs as overall program impact was the under-allocation of expenses to the grants as of June 30, 2024. The City and Borough elected not to adjust the amounts reported in the schedule of expenditures of federal awards, since allocations and reports can be corrected in the following reporting year. Cause: Internal controls were not designed or implemented to detect the incorrect system configuration for allocating project expenses between grant and match funds in a timely manner, nor was the report preparation review process sufficiently designed or implemented to detect and correct the under-and over-allocations of project costs being reported. Recommendation: We recommend the City and Borough improve monitoring controls over the setup for project expense allocations and the review controls over report preparation process to ensure that errors are detected and corrected in a timely manner. View of responsible officials: Management concurs with this finding, see corrective action plan.
2024-003: Significant Deficiency in Internal Controls over Compliance and Compliance – Setup and Monitoring of Reporting and Match Agency: U.S. Department of Transportation, Federal Aviation Administration Program(s) and Federal Award Listing Number(s): Airport Improvement Program ALN: 20.106 FAIN: 3-02-0133-092-2022, 3-02-0133-098-2023, 3-02-0133-100-2023 New or Repeat: New Criteria: 2 CFR 200.303 requires internal controls to ensure accuracy in financial reporting, while 2 CFR 200.306 mandates proper tracking and documentation of matching contributions. Condition: Internal controls were not sufficiently designed and implemented to ensure that matching funds were correctly allocated in accordance with grant requirements. As a result, errors in the match setup were not detected in a timely manner, leading to discrepancies between the financial data provided for audit and the City and Borough’s prepared reports submitted to the grantor. Internal controls over reporting were not designed or implemented to detect and correct the errors prior to report submission. Context: The City and Borough’s financial system was not properly configured to allocate matching funds correctly, resulting in discrepancies in reported amounts. Specifically, an under-allocation to an Airport Improvement Program (AIP) grant and an over-allocation to the match occurred in one project of $474,704 and an under-allocation to match and over-allocation of $107,651 to two other AIP grants occurred. Effect: Overall expenses were under-allocated to the AIP and over-allocated to match funding. The overall impact of these errors resulted in discrepancies between reported amounts and supporting documentation. Due to amount reported as AIP costs being under-reported, this is considered immaterial non-compliance and is reported as an other matter. Questioned costs: No questioned costs as overall program impact was the under-allocation of expenses to the grants as of June 30, 2024. The City and Borough elected not to adjust the amounts reported in the schedule of expenditures of federal awards, since allocations and reports can be corrected in the following reporting year. Cause: Internal controls were not designed or implemented to detect the incorrect system configuration for allocating project expenses between grant and match funds in a timely manner, nor was the report preparation review process sufficiently designed or implemented to detect and correct the under-and over-allocations of project costs being reported. Recommendation: We recommend the City and Borough improve monitoring controls over the setup for project expense allocations and the review controls over report preparation process to ensure that errors are detected and corrected in a timely manner. View of responsible officials: Management concurs with this finding, see corrective action plan.
2024-003: Significant Deficiency in Internal Controls over Compliance and Compliance – Setup and Monitoring of Reporting and Match Agency: U.S. Department of Transportation, Federal Aviation Administration Program(s) and Federal Award Listing Number(s): Airport Improvement Program ALN: 20.106 FAIN: 3-02-0133-092-2022, 3-02-0133-098-2023, 3-02-0133-100-2023 New or Repeat: New Criteria: 2 CFR 200.303 requires internal controls to ensure accuracy in financial reporting, while 2 CFR 200.306 mandates proper tracking and documentation of matching contributions. Condition: Internal controls were not sufficiently designed and implemented to ensure that matching funds were correctly allocated in accordance with grant requirements. As a result, errors in the match setup were not detected in a timely manner, leading to discrepancies between the financial data provided for audit and the City and Borough’s prepared reports submitted to the grantor. Internal controls over reporting were not designed or implemented to detect and correct the errors prior to report submission. Context: The City and Borough’s financial system was not properly configured to allocate matching funds correctly, resulting in discrepancies in reported amounts. Specifically, an under-allocation to an Airport Improvement Program (AIP) grant and an over-allocation to the match occurred in one project of $474,704 and an under-allocation to match and over-allocation of $107,651 to two other AIP grants occurred. Effect: Overall expenses were under-allocated to the AIP and over-allocated to match funding. The overall impact of these errors resulted in discrepancies between reported amounts and supporting documentation. Due to amount reported as AIP costs being under-reported, this is considered immaterial non-compliance and is reported as an other matter. Questioned costs: No questioned costs as overall program impact was the under-allocation of expenses to the grants as of June 30, 2024. The City and Borough elected not to adjust the amounts reported in the schedule of expenditures of federal awards, since allocations and reports can be corrected in the following reporting year. Cause: Internal controls were not designed or implemented to detect the incorrect system configuration for allocating project expenses between grant and match funds in a timely manner, nor was the report preparation review process sufficiently designed or implemented to detect and correct the under-and over-allocations of project costs being reported. Recommendation: We recommend the City and Borough improve monitoring controls over the setup for project expense allocations and the review controls over report preparation process to ensure that errors are detected and corrected in a timely manner. View of responsible officials: Management concurs with this finding, see corrective action plan.
2024-003: Significant Deficiency in Internal Controls over Compliance and Compliance – Setup and Monitoring of Reporting and Match Agency: U.S. Department of Transportation, Federal Aviation Administration Program(s) and Federal Award Listing Number(s): Airport Improvement Program ALN: 20.106 FAIN: 3-02-0133-092-2022, 3-02-0133-098-2023, 3-02-0133-100-2023 New or Repeat: New Criteria: 2 CFR 200.303 requires internal controls to ensure accuracy in financial reporting, while 2 CFR 200.306 mandates proper tracking and documentation of matching contributions. Condition: Internal controls were not sufficiently designed and implemented to ensure that matching funds were correctly allocated in accordance with grant requirements. As a result, errors in the match setup were not detected in a timely manner, leading to discrepancies between the financial data provided for audit and the City and Borough’s prepared reports submitted to the grantor. Internal controls over reporting were not designed or implemented to detect and correct the errors prior to report submission. Context: The City and Borough’s financial system was not properly configured to allocate matching funds correctly, resulting in discrepancies in reported amounts. Specifically, an under-allocation to an Airport Improvement Program (AIP) grant and an over-allocation to the match occurred in one project of $474,704 and an under-allocation to match and over-allocation of $107,651 to two other AIP grants occurred. Effect: Overall expenses were under-allocated to the AIP and over-allocated to match funding. The overall impact of these errors resulted in discrepancies between reported amounts and supporting documentation. Due to amount reported as AIP costs being under-reported, this is considered immaterial non-compliance and is reported as an other matter. Questioned costs: No questioned costs as overall program impact was the under-allocation of expenses to the grants as of June 30, 2024. The City and Borough elected not to adjust the amounts reported in the schedule of expenditures of federal awards, since allocations and reports can be corrected in the following reporting year. Cause: Internal controls were not designed or implemented to detect the incorrect system configuration for allocating project expenses between grant and match funds in a timely manner, nor was the report preparation review process sufficiently designed or implemented to detect and correct the under-and over-allocations of project costs being reported. Recommendation: We recommend the City and Borough improve monitoring controls over the setup for project expense allocations and the review controls over report preparation process to ensure that errors are detected and corrected in a timely manner. View of responsible officials: Management concurs with this finding, see corrective action plan.
2024-003: Significant Deficiency in Internal Controls over Compliance and Compliance – Setup and Monitoring of Reporting and Match Agency: U.S. Department of Transportation, Federal Aviation Administration Program(s) and Federal Award Listing Number(s): Airport Improvement Program ALN: 20.106 FAIN: 3-02-0133-092-2022, 3-02-0133-098-2023, 3-02-0133-100-2023 New or Repeat: New Criteria: 2 CFR 200.303 requires internal controls to ensure accuracy in financial reporting, while 2 CFR 200.306 mandates proper tracking and documentation of matching contributions. Condition: Internal controls were not sufficiently designed and implemented to ensure that matching funds were correctly allocated in accordance with grant requirements. As a result, errors in the match setup were not detected in a timely manner, leading to discrepancies between the financial data provided for audit and the City and Borough’s prepared reports submitted to the grantor. Internal controls over reporting were not designed or implemented to detect and correct the errors prior to report submission. Context: The City and Borough’s financial system was not properly configured to allocate matching funds correctly, resulting in discrepancies in reported amounts. Specifically, an under-allocation to an Airport Improvement Program (AIP) grant and an over-allocation to the match occurred in one project of $474,704 and an under-allocation to match and over-allocation of $107,651 to two other AIP grants occurred. Effect: Overall expenses were under-allocated to the AIP and over-allocated to match funding. The overall impact of these errors resulted in discrepancies between reported amounts and supporting documentation. Due to amount reported as AIP costs being under-reported, this is considered immaterial non-compliance and is reported as an other matter. Questioned costs: No questioned costs as overall program impact was the under-allocation of expenses to the grants as of June 30, 2024. The City and Borough elected not to adjust the amounts reported in the schedule of expenditures of federal awards, since allocations and reports can be corrected in the following reporting year. Cause: Internal controls were not designed or implemented to detect the incorrect system configuration for allocating project expenses between grant and match funds in a timely manner, nor was the report preparation review process sufficiently designed or implemented to detect and correct the under-and over-allocations of project costs being reported. Recommendation: We recommend the City and Borough improve monitoring controls over the setup for project expense allocations and the review controls over report preparation process to ensure that errors are detected and corrected in a timely manner. View of responsible officials: Management concurs with this finding, see corrective action plan.
2024-003: Significant Deficiency in Internal Controls over Compliance and Compliance – Setup and Monitoring of Reporting and Match Agency: U.S. Department of Transportation, Federal Aviation Administration Program(s) and Federal Award Listing Number(s): Airport Improvement Program ALN: 20.106 FAIN: 3-02-0133-092-2022, 3-02-0133-098-2023, 3-02-0133-100-2023 New or Repeat: New Criteria: 2 CFR 200.303 requires internal controls to ensure accuracy in financial reporting, while 2 CFR 200.306 mandates proper tracking and documentation of matching contributions. Condition: Internal controls were not sufficiently designed and implemented to ensure that matching funds were correctly allocated in accordance with grant requirements. As a result, errors in the match setup were not detected in a timely manner, leading to discrepancies between the financial data provided for audit and the City and Borough’s prepared reports submitted to the grantor. Internal controls over reporting were not designed or implemented to detect and correct the errors prior to report submission. Context: The City and Borough’s financial system was not properly configured to allocate matching funds correctly, resulting in discrepancies in reported amounts. Specifically, an under-allocation to an Airport Improvement Program (AIP) grant and an over-allocation to the match occurred in one project of $474,704 and an under-allocation to match and over-allocation of $107,651 to two other AIP grants occurred. Effect: Overall expenses were under-allocated to the AIP and over-allocated to match funding. The overall impact of these errors resulted in discrepancies between reported amounts and supporting documentation. Due to amount reported as AIP costs being under-reported, this is considered immaterial non-compliance and is reported as an other matter. Questioned costs: No questioned costs as overall program impact was the under-allocation of expenses to the grants as of June 30, 2024. The City and Borough elected not to adjust the amounts reported in the schedule of expenditures of federal awards, since allocations and reports can be corrected in the following reporting year. Cause: Internal controls were not designed or implemented to detect the incorrect system configuration for allocating project expenses between grant and match funds in a timely manner, nor was the report preparation review process sufficiently designed or implemented to detect and correct the under-and over-allocations of project costs being reported. Recommendation: We recommend the City and Borough improve monitoring controls over the setup for project expense allocations and the review controls over report preparation process to ensure that errors are detected and corrected in a timely manner. View of responsible officials: Management concurs with this finding, see corrective action plan.
2024-003: Significant Deficiency in Internal Controls over Compliance and Compliance – Setup and Monitoring of Reporting and Match Agency: U.S. Department of Transportation, Federal Aviation Administration Program(s) and Federal Award Listing Number(s): Airport Improvement Program ALN: 20.106 FAIN: 3-02-0133-092-2022, 3-02-0133-098-2023, 3-02-0133-100-2023 New or Repeat: New Criteria: 2 CFR 200.303 requires internal controls to ensure accuracy in financial reporting, while 2 CFR 200.306 mandates proper tracking and documentation of matching contributions. Condition: Internal controls were not sufficiently designed and implemented to ensure that matching funds were correctly allocated in accordance with grant requirements. As a result, errors in the match setup were not detected in a timely manner, leading to discrepancies between the financial data provided for audit and the City and Borough’s prepared reports submitted to the grantor. Internal controls over reporting were not designed or implemented to detect and correct the errors prior to report submission. Context: The City and Borough’s financial system was not properly configured to allocate matching funds correctly, resulting in discrepancies in reported amounts. Specifically, an under-allocation to an Airport Improvement Program (AIP) grant and an over-allocation to the match occurred in one project of $474,704 and an under-allocation to match and over-allocation of $107,651 to two other AIP grants occurred. Effect: Overall expenses were under-allocated to the AIP and over-allocated to match funding. The overall impact of these errors resulted in discrepancies between reported amounts and supporting documentation. Due to amount reported as AIP costs being under-reported, this is considered immaterial non-compliance and is reported as an other matter. Questioned costs: No questioned costs as overall program impact was the under-allocation of expenses to the grants as of June 30, 2024. The City and Borough elected not to adjust the amounts reported in the schedule of expenditures of federal awards, since allocations and reports can be corrected in the following reporting year. Cause: Internal controls were not designed or implemented to detect the incorrect system configuration for allocating project expenses between grant and match funds in a timely manner, nor was the report preparation review process sufficiently designed or implemented to detect and correct the under-and over-allocations of project costs being reported. Recommendation: We recommend the City and Borough improve monitoring controls over the setup for project expense allocations and the review controls over report preparation process to ensure that errors are detected and corrected in a timely manner. View of responsible officials: Management concurs with this finding, see corrective action plan.
2024-003: Significant Deficiency in Internal Controls over Compliance and Compliance – Setup and Monitoring of Reporting and Match Agency: U.S. Department of Transportation, Federal Aviation Administration Program(s) and Federal Award Listing Number(s): Airport Improvement Program ALN: 20.106 FAIN: 3-02-0133-092-2022, 3-02-0133-098-2023, 3-02-0133-100-2023 New or Repeat: New Criteria: 2 CFR 200.303 requires internal controls to ensure accuracy in financial reporting, while 2 CFR 200.306 mandates proper tracking and documentation of matching contributions. Condition: Internal controls were not sufficiently designed and implemented to ensure that matching funds were correctly allocated in accordance with grant requirements. As a result, errors in the match setup were not detected in a timely manner, leading to discrepancies between the financial data provided for audit and the City and Borough’s prepared reports submitted to the grantor. Internal controls over reporting were not designed or implemented to detect and correct the errors prior to report submission. Context: The City and Borough’s financial system was not properly configured to allocate matching funds correctly, resulting in discrepancies in reported amounts. Specifically, an under-allocation to an Airport Improvement Program (AIP) grant and an over-allocation to the match occurred in one project of $474,704 and an under-allocation to match and over-allocation of $107,651 to two other AIP grants occurred. Effect: Overall expenses were under-allocated to the AIP and over-allocated to match funding. The overall impact of these errors resulted in discrepancies between reported amounts and supporting documentation. Due to amount reported as AIP costs being under-reported, this is considered immaterial non-compliance and is reported as an other matter. Questioned costs: No questioned costs as overall program impact was the under-allocation of expenses to the grants as of June 30, 2024. The City and Borough elected not to adjust the amounts reported in the schedule of expenditures of federal awards, since allocations and reports can be corrected in the following reporting year. Cause: Internal controls were not designed or implemented to detect the incorrect system configuration for allocating project expenses between grant and match funds in a timely manner, nor was the report preparation review process sufficiently designed or implemented to detect and correct the under-and over-allocations of project costs being reported. Recommendation: We recommend the City and Borough improve monitoring controls over the setup for project expense allocations and the review controls over report preparation process to ensure that errors are detected and corrected in a timely manner. View of responsible officials: Management concurs with this finding, see corrective action plan.
2024-003: Significant Deficiency in Internal Controls over Compliance and Compliance – Setup and Monitoring of Reporting and Match Agency: U.S. Department of Transportation, Federal Aviation Administration Program(s) and Federal Award Listing Number(s): Airport Improvement Program ALN: 20.106 FAIN: 3-02-0133-092-2022, 3-02-0133-098-2023, 3-02-0133-100-2023 New or Repeat: New Criteria: 2 CFR 200.303 requires internal controls to ensure accuracy in financial reporting, while 2 CFR 200.306 mandates proper tracking and documentation of matching contributions. Condition: Internal controls were not sufficiently designed and implemented to ensure that matching funds were correctly allocated in accordance with grant requirements. As a result, errors in the match setup were not detected in a timely manner, leading to discrepancies between the financial data provided for audit and the City and Borough’s prepared reports submitted to the grantor. Internal controls over reporting were not designed or implemented to detect and correct the errors prior to report submission. Context: The City and Borough’s financial system was not properly configured to allocate matching funds correctly, resulting in discrepancies in reported amounts. Specifically, an under-allocation to an Airport Improvement Program (AIP) grant and an over-allocation to the match occurred in one project of $474,704 and an under-allocation to match and over-allocation of $107,651 to two other AIP grants occurred. Effect: Overall expenses were under-allocated to the AIP and over-allocated to match funding. The overall impact of these errors resulted in discrepancies between reported amounts and supporting documentation. Due to amount reported as AIP costs being under-reported, this is considered immaterial non-compliance and is reported as an other matter. Questioned costs: No questioned costs as overall program impact was the under-allocation of expenses to the grants as of June 30, 2024. The City and Borough elected not to adjust the amounts reported in the schedule of expenditures of federal awards, since allocations and reports can be corrected in the following reporting year. Cause: Internal controls were not designed or implemented to detect the incorrect system configuration for allocating project expenses between grant and match funds in a timely manner, nor was the report preparation review process sufficiently designed or implemented to detect and correct the under-and over-allocations of project costs being reported. Recommendation: We recommend the City and Borough improve monitoring controls over the setup for project expense allocations and the review controls over report preparation process to ensure that errors are detected and corrected in a timely manner. View of responsible officials: Management concurs with this finding, see corrective action plan.
2024-003: Significant Deficiency in Internal Controls over Compliance and Compliance – Setup and Monitoring of Reporting and Match Agency: U.S. Department of Transportation, Federal Aviation Administration Program(s) and Federal Award Listing Number(s): Airport Improvement Program ALN: 20.106 FAIN: 3-02-0133-092-2022, 3-02-0133-098-2023, 3-02-0133-100-2023 New or Repeat: New Criteria: 2 CFR 200.303 requires internal controls to ensure accuracy in financial reporting, while 2 CFR 200.306 mandates proper tracking and documentation of matching contributions. Condition: Internal controls were not sufficiently designed and implemented to ensure that matching funds were correctly allocated in accordance with grant requirements. As a result, errors in the match setup were not detected in a timely manner, leading to discrepancies between the financial data provided for audit and the City and Borough’s prepared reports submitted to the grantor. Internal controls over reporting were not designed or implemented to detect and correct the errors prior to report submission. Context: The City and Borough’s financial system was not properly configured to allocate matching funds correctly, resulting in discrepancies in reported amounts. Specifically, an under-allocation to an Airport Improvement Program (AIP) grant and an over-allocation to the match occurred in one project of $474,704 and an under-allocation to match and over-allocation of $107,651 to two other AIP grants occurred. Effect: Overall expenses were under-allocated to the AIP and over-allocated to match funding. The overall impact of these errors resulted in discrepancies between reported amounts and supporting documentation. Due to amount reported as AIP costs being under-reported, this is considered immaterial non-compliance and is reported as an other matter. Questioned costs: No questioned costs as overall program impact was the under-allocation of expenses to the grants as of June 30, 2024. The City and Borough elected not to adjust the amounts reported in the schedule of expenditures of federal awards, since allocations and reports can be corrected in the following reporting year. Cause: Internal controls were not designed or implemented to detect the incorrect system configuration for allocating project expenses between grant and match funds in a timely manner, nor was the report preparation review process sufficiently designed or implemented to detect and correct the under-and over-allocations of project costs being reported. Recommendation: We recommend the City and Borough improve monitoring controls over the setup for project expense allocations and the review controls over report preparation process to ensure that errors are detected and corrected in a timely manner. View of responsible officials: Management concurs with this finding, see corrective action plan.
2024-003: Significant Deficiency in Internal Controls over Compliance and Compliance – Setup and Monitoring of Reporting and Match Agency: U.S. Department of Transportation, Federal Aviation Administration Program(s) and Federal Award Listing Number(s): Airport Improvement Program ALN: 20.106 FAIN: 3-02-0133-092-2022, 3-02-0133-098-2023, 3-02-0133-100-2023 New or Repeat: New Criteria: 2 CFR 200.303 requires internal controls to ensure accuracy in financial reporting, while 2 CFR 200.306 mandates proper tracking and documentation of matching contributions. Condition: Internal controls were not sufficiently designed and implemented to ensure that matching funds were correctly allocated in accordance with grant requirements. As a result, errors in the match setup were not detected in a timely manner, leading to discrepancies between the financial data provided for audit and the City and Borough’s prepared reports submitted to the grantor. Internal controls over reporting were not designed or implemented to detect and correct the errors prior to report submission. Context: The City and Borough’s financial system was not properly configured to allocate matching funds correctly, resulting in discrepancies in reported amounts. Specifically, an under-allocation to an Airport Improvement Program (AIP) grant and an over-allocation to the match occurred in one project of $474,704 and an under-allocation to match and over-allocation of $107,651 to two other AIP grants occurred. Effect: Overall expenses were under-allocated to the AIP and over-allocated to match funding. The overall impact of these errors resulted in discrepancies between reported amounts and supporting documentation. Due to amount reported as AIP costs being under-reported, this is considered immaterial non-compliance and is reported as an other matter. Questioned costs: No questioned costs as overall program impact was the under-allocation of expenses to the grants as of June 30, 2024. The City and Borough elected not to adjust the amounts reported in the schedule of expenditures of federal awards, since allocations and reports can be corrected in the following reporting year. Cause: Internal controls were not designed or implemented to detect the incorrect system configuration for allocating project expenses between grant and match funds in a timely manner, nor was the report preparation review process sufficiently designed or implemented to detect and correct the under-and over-allocations of project costs being reported. Recommendation: We recommend the City and Borough improve monitoring controls over the setup for project expense allocations and the review controls over report preparation process to ensure that errors are detected and corrected in a timely manner. View of responsible officials: Management concurs with this finding, see corrective action plan.
2024-003: Significant Deficiency in Internal Controls over Compliance and Compliance – Setup and Monitoring of Reporting and Match Agency: U.S. Department of Transportation, Federal Aviation Administration Program(s) and Federal Award Listing Number(s): Airport Improvement Program ALN: 20.106 FAIN: 3-02-0133-092-2022, 3-02-0133-098-2023, 3-02-0133-100-2023 New or Repeat: New Criteria: 2 CFR 200.303 requires internal controls to ensure accuracy in financial reporting, while 2 CFR 200.306 mandates proper tracking and documentation of matching contributions. Condition: Internal controls were not sufficiently designed and implemented to ensure that matching funds were correctly allocated in accordance with grant requirements. As a result, errors in the match setup were not detected in a timely manner, leading to discrepancies between the financial data provided for audit and the City and Borough’s prepared reports submitted to the grantor. Internal controls over reporting were not designed or implemented to detect and correct the errors prior to report submission. Context: The City and Borough’s financial system was not properly configured to allocate matching funds correctly, resulting in discrepancies in reported amounts. Specifically, an under-allocation to an Airport Improvement Program (AIP) grant and an over-allocation to the match occurred in one project of $474,704 and an under-allocation to match and over-allocation of $107,651 to two other AIP grants occurred. Effect: Overall expenses were under-allocated to the AIP and over-allocated to match funding. The overall impact of these errors resulted in discrepancies between reported amounts and supporting documentation. Due to amount reported as AIP costs being under-reported, this is considered immaterial non-compliance and is reported as an other matter. Questioned costs: No questioned costs as overall program impact was the under-allocation of expenses to the grants as of June 30, 2024. The City and Borough elected not to adjust the amounts reported in the schedule of expenditures of federal awards, since allocations and reports can be corrected in the following reporting year. Cause: Internal controls were not designed or implemented to detect the incorrect system configuration for allocating project expenses between grant and match funds in a timely manner, nor was the report preparation review process sufficiently designed or implemented to detect and correct the under-and over-allocations of project costs being reported. Recommendation: We recommend the City and Borough improve monitoring controls over the setup for project expense allocations and the review controls over report preparation process to ensure that errors are detected and corrected in a timely manner. View of responsible officials: Management concurs with this finding, see corrective action plan.
2024-003: Significant Deficiency in Internal Controls over Compliance and Compliance – Setup and Monitoring of Reporting and Match Agency: U.S. Department of Transportation, Federal Aviation Administration Program(s) and Federal Award Listing Number(s): Airport Improvement Program ALN: 20.106 FAIN: 3-02-0133-092-2022, 3-02-0133-098-2023, 3-02-0133-100-2023 New or Repeat: New Criteria: 2 CFR 200.303 requires internal controls to ensure accuracy in financial reporting, while 2 CFR 200.306 mandates proper tracking and documentation of matching contributions. Condition: Internal controls were not sufficiently designed and implemented to ensure that matching funds were correctly allocated in accordance with grant requirements. As a result, errors in the match setup were not detected in a timely manner, leading to discrepancies between the financial data provided for audit and the City and Borough’s prepared reports submitted to the grantor. Internal controls over reporting were not designed or implemented to detect and correct the errors prior to report submission. Context: The City and Borough’s financial system was not properly configured to allocate matching funds correctly, resulting in discrepancies in reported amounts. Specifically, an under-allocation to an Airport Improvement Program (AIP) grant and an over-allocation to the match occurred in one project of $474,704 and an under-allocation to match and over-allocation of $107,651 to two other AIP grants occurred. Effect: Overall expenses were under-allocated to the AIP and over-allocated to match funding. The overall impact of these errors resulted in discrepancies between reported amounts and supporting documentation. Due to amount reported as AIP costs being under-reported, this is considered immaterial non-compliance and is reported as an other matter. Questioned costs: No questioned costs as overall program impact was the under-allocation of expenses to the grants as of June 30, 2024. The City and Borough elected not to adjust the amounts reported in the schedule of expenditures of federal awards, since allocations and reports can be corrected in the following reporting year. Cause: Internal controls were not designed or implemented to detect the incorrect system configuration for allocating project expenses between grant and match funds in a timely manner, nor was the report preparation review process sufficiently designed or implemented to detect and correct the under-and over-allocations of project costs being reported. Recommendation: We recommend the City and Borough improve monitoring controls over the setup for project expense allocations and the review controls over report preparation process to ensure that errors are detected and corrected in a timely manner. View of responsible officials: Management concurs with this finding, see corrective action plan.
2024-003: Significant Deficiency in Internal Controls over Compliance and Compliance – Setup and Monitoring of Reporting and Match Agency: U.S. Department of Transportation, Federal Aviation Administration Program(s) and Federal Award Listing Number(s): Airport Improvement Program ALN: 20.106 FAIN: 3-02-0133-092-2022, 3-02-0133-098-2023, 3-02-0133-100-2023 New or Repeat: New Criteria: 2 CFR 200.303 requires internal controls to ensure accuracy in financial reporting, while 2 CFR 200.306 mandates proper tracking and documentation of matching contributions. Condition: Internal controls were not sufficiently designed and implemented to ensure that matching funds were correctly allocated in accordance with grant requirements. As a result, errors in the match setup were not detected in a timely manner, leading to discrepancies between the financial data provided for audit and the City and Borough’s prepared reports submitted to the grantor. Internal controls over reporting were not designed or implemented to detect and correct the errors prior to report submission. Context: The City and Borough’s financial system was not properly configured to allocate matching funds correctly, resulting in discrepancies in reported amounts. Specifically, an under-allocation to an Airport Improvement Program (AIP) grant and an over-allocation to the match occurred in one project of $474,704 and an under-allocation to match and over-allocation of $107,651 to two other AIP grants occurred. Effect: Overall expenses were under-allocated to the AIP and over-allocated to match funding. The overall impact of these errors resulted in discrepancies between reported amounts and supporting documentation. Due to amount reported as AIP costs being under-reported, this is considered immaterial non-compliance and is reported as an other matter. Questioned costs: No questioned costs as overall program impact was the under-allocation of expenses to the grants as of June 30, 2024. The City and Borough elected not to adjust the amounts reported in the schedule of expenditures of federal awards, since allocations and reports can be corrected in the following reporting year. Cause: Internal controls were not designed or implemented to detect the incorrect system configuration for allocating project expenses between grant and match funds in a timely manner, nor was the report preparation review process sufficiently designed or implemented to detect and correct the under-and over-allocations of project costs being reported. Recommendation: We recommend the City and Borough improve monitoring controls over the setup for project expense allocations and the review controls over report preparation process to ensure that errors are detected and corrected in a timely manner. View of responsible officials: Management concurs with this finding, see corrective action plan.
2024-003: Significant Deficiency in Internal Controls over Compliance and Compliance – Setup and Monitoring of Reporting and Match Agency: U.S. Department of Transportation, Federal Aviation Administration Program(s) and Federal Award Listing Number(s): Airport Improvement Program ALN: 20.106 FAIN: 3-02-0133-092-2022, 3-02-0133-098-2023, 3-02-0133-100-2023 New or Repeat: New Criteria: 2 CFR 200.303 requires internal controls to ensure accuracy in financial reporting, while 2 CFR 200.306 mandates proper tracking and documentation of matching contributions. Condition: Internal controls were not sufficiently designed and implemented to ensure that matching funds were correctly allocated in accordance with grant requirements. As a result, errors in the match setup were not detected in a timely manner, leading to discrepancies between the financial data provided for audit and the City and Borough’s prepared reports submitted to the grantor. Internal controls over reporting were not designed or implemented to detect and correct the errors prior to report submission. Context: The City and Borough’s financial system was not properly configured to allocate matching funds correctly, resulting in discrepancies in reported amounts. Specifically, an under-allocation to an Airport Improvement Program (AIP) grant and an over-allocation to the match occurred in one project of $474,704 and an under-allocation to match and over-allocation of $107,651 to two other AIP grants occurred. Effect: Overall expenses were under-allocated to the AIP and over-allocated to match funding. The overall impact of these errors resulted in discrepancies between reported amounts and supporting documentation. Due to amount reported as AIP costs being under-reported, this is considered immaterial non-compliance and is reported as an other matter. Questioned costs: No questioned costs as overall program impact was the under-allocation of expenses to the grants as of June 30, 2024. The City and Borough elected not to adjust the amounts reported in the schedule of expenditures of federal awards, since allocations and reports can be corrected in the following reporting year. Cause: Internal controls were not designed or implemented to detect the incorrect system configuration for allocating project expenses between grant and match funds in a timely manner, nor was the report preparation review process sufficiently designed or implemented to detect and correct the under-and over-allocations of project costs being reported. Recommendation: We recommend the City and Borough improve monitoring controls over the setup for project expense allocations and the review controls over report preparation process to ensure that errors are detected and corrected in a timely manner. View of responsible officials: Management concurs with this finding, see corrective action plan.
2024-003: Significant Deficiency in Internal Controls over Compliance and Compliance – Setup and Monitoring of Reporting and Match Agency: U.S. Department of Transportation, Federal Aviation Administration Program(s) and Federal Award Listing Number(s): Airport Improvement Program ALN: 20.106 FAIN: 3-02-0133-092-2022, 3-02-0133-098-2023, 3-02-0133-100-2023 New or Repeat: New Criteria: 2 CFR 200.303 requires internal controls to ensure accuracy in financial reporting, while 2 CFR 200.306 mandates proper tracking and documentation of matching contributions. Condition: Internal controls were not sufficiently designed and implemented to ensure that matching funds were correctly allocated in accordance with grant requirements. As a result, errors in the match setup were not detected in a timely manner, leading to discrepancies between the financial data provided for audit and the City and Borough’s prepared reports submitted to the grantor. Internal controls over reporting were not designed or implemented to detect and correct the errors prior to report submission. Context: The City and Borough’s financial system was not properly configured to allocate matching funds correctly, resulting in discrepancies in reported amounts. Specifically, an under-allocation to an Airport Improvement Program (AIP) grant and an over-allocation to the match occurred in one project of $474,704 and an under-allocation to match and over-allocation of $107,651 to two other AIP grants occurred. Effect: Overall expenses were under-allocated to the AIP and over-allocated to match funding. The overall impact of these errors resulted in discrepancies between reported amounts and supporting documentation. Due to amount reported as AIP costs being under-reported, this is considered immaterial non-compliance and is reported as an other matter. Questioned costs: No questioned costs as overall program impact was the under-allocation of expenses to the grants as of June 30, 2024. The City and Borough elected not to adjust the amounts reported in the schedule of expenditures of federal awards, since allocations and reports can be corrected in the following reporting year. Cause: Internal controls were not designed or implemented to detect the incorrect system configuration for allocating project expenses between grant and match funds in a timely manner, nor was the report preparation review process sufficiently designed or implemented to detect and correct the under-and over-allocations of project costs being reported. Recommendation: We recommend the City and Borough improve monitoring controls over the setup for project expense allocations and the review controls over report preparation process to ensure that errors are detected and corrected in a timely manner. View of responsible officials: Management concurs with this finding, see corrective action plan.
2024-003: Significant Deficiency in Internal Controls over Compliance and Compliance – Setup and Monitoring of Reporting and Match Agency: U.S. Department of Transportation, Federal Aviation Administration Program(s) and Federal Award Listing Number(s): Airport Improvement Program ALN: 20.106 FAIN: 3-02-0133-092-2022, 3-02-0133-098-2023, 3-02-0133-100-2023 New or Repeat: New Criteria: 2 CFR 200.303 requires internal controls to ensure accuracy in financial reporting, while 2 CFR 200.306 mandates proper tracking and documentation of matching contributions. Condition: Internal controls were not sufficiently designed and implemented to ensure that matching funds were correctly allocated in accordance with grant requirements. As a result, errors in the match setup were not detected in a timely manner, leading to discrepancies between the financial data provided for audit and the City and Borough’s prepared reports submitted to the grantor. Internal controls over reporting were not designed or implemented to detect and correct the errors prior to report submission. Context: The City and Borough’s financial system was not properly configured to allocate matching funds correctly, resulting in discrepancies in reported amounts. Specifically, an under-allocation to an Airport Improvement Program (AIP) grant and an over-allocation to the match occurred in one project of $474,704 and an under-allocation to match and over-allocation of $107,651 to two other AIP grants occurred. Effect: Overall expenses were under-allocated to the AIP and over-allocated to match funding. The overall impact of these errors resulted in discrepancies between reported amounts and supporting documentation. Due to amount reported as AIP costs being under-reported, this is considered immaterial non-compliance and is reported as an other matter. Questioned costs: No questioned costs as overall program impact was the under-allocation of expenses to the grants as of June 30, 2024. The City and Borough elected not to adjust the amounts reported in the schedule of expenditures of federal awards, since allocations and reports can be corrected in the following reporting year. Cause: Internal controls were not designed or implemented to detect the incorrect system configuration for allocating project expenses between grant and match funds in a timely manner, nor was the report preparation review process sufficiently designed or implemented to detect and correct the under-and over-allocations of project costs being reported. Recommendation: We recommend the City and Borough improve monitoring controls over the setup for project expense allocations and the review controls over report preparation process to ensure that errors are detected and corrected in a timely manner. View of responsible officials: Management concurs with this finding, see corrective action plan.
2024-003: Significant Deficiency in Internal Controls over Compliance and Compliance – Setup and Monitoring of Reporting and Match Agency: U.S. Department of Transportation, Federal Aviation Administration Program(s) and Federal Award Listing Number(s): Airport Improvement Program ALN: 20.106 FAIN: 3-02-0133-092-2022, 3-02-0133-098-2023, 3-02-0133-100-2023 New or Repeat: New Criteria: 2 CFR 200.303 requires internal controls to ensure accuracy in financial reporting, while 2 CFR 200.306 mandates proper tracking and documentation of matching contributions. Condition: Internal controls were not sufficiently designed and implemented to ensure that matching funds were correctly allocated in accordance with grant requirements. As a result, errors in the match setup were not detected in a timely manner, leading to discrepancies between the financial data provided for audit and the City and Borough’s prepared reports submitted to the grantor. Internal controls over reporting were not designed or implemented to detect and correct the errors prior to report submission. Context: The City and Borough’s financial system was not properly configured to allocate matching funds correctly, resulting in discrepancies in reported amounts. Specifically, an under-allocation to an Airport Improvement Program (AIP) grant and an over-allocation to the match occurred in one project of $474,704 and an under-allocation to match and over-allocation of $107,651 to two other AIP grants occurred. Effect: Overall expenses were under-allocated to the AIP and over-allocated to match funding. The overall impact of these errors resulted in discrepancies between reported amounts and supporting documentation. Due to amount reported as AIP costs being under-reported, this is considered immaterial non-compliance and is reported as an other matter. Questioned costs: No questioned costs as overall program impact was the under-allocation of expenses to the grants as of June 30, 2024. The City and Borough elected not to adjust the amounts reported in the schedule of expenditures of federal awards, since allocations and reports can be corrected in the following reporting year. Cause: Internal controls were not designed or implemented to detect the incorrect system configuration for allocating project expenses between grant and match funds in a timely manner, nor was the report preparation review process sufficiently designed or implemented to detect and correct the under-and over-allocations of project costs being reported. Recommendation: We recommend the City and Borough improve monitoring controls over the setup for project expense allocations and the review controls over report preparation process to ensure that errors are detected and corrected in a timely manner. View of responsible officials: Management concurs with this finding, see corrective action plan.