Corrective Action Plans

Finding 481045 (2023-001)

Material Weakness 2023

WA

Subrecipient Monitoring Internal Control / Segregation of Duties Procurement, Suspension & Debarment

CORRECTIVE ACTION PLAN FOR FINDINGS REPORTED UNDER UNIFORM GUIDANCE Winlock School District No. 232 September 1, 2022 through August 31, 2023 This schedule presents the corrective action planned by the District for findings reported in this report in accordance with Title 2 U.S. Code of Federal Regu...

CORRECTIVE ACTION PLAN FOR FINDINGS REPORTED UNDER UNIFORM GUIDANCE Winlock School District No. 232 September 1, 2022 through August 31, 2023 This schedule presents the corrective action planned by the District for findings reported in this report in accordance with Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance). Finding ref number: 2023-001 Finding caption: The District did not have adequate internal controls for ensuring compliance with federal wage rate requirements. Name, address, and telephone of District contact person: Gloria Dupree, Business Manager, N.E. 1st Street, Winlock, WA 98596, (360) 785-3582 Corrective action the auditee plans to take in response to the finding: Corrective actions for ensuring compliance with federal wage requirements. 1) Maintain detailed documentation of all wage rate determinations, calculations, and payments made to employees by verifying contractors certified weekly payrolls. 2) Print and maintain all certified payrolls from the L&I website, contractors, sub-contractors and maintain copies onsite with awarded contract. 3) Provide training to employees involved in contracting on federal wage rate requirements to ensure they are aware of their responsibilities. 4) Monitor changes in federal wage rate requirements and update internal controls accordingly to stay compliant. Anticipated date to complete the corrective action: 9/01/2024

View Audit 317184

Finding 481042 (2023-003)

Material Weakness 2023

Mower County

MN

Eligibility Material Weakness Internal Control / Segregation of Duties

Recommendation: We recommend that a supervisor or team lead perform regular internal reviews on MAXIS and METS casefiles to determine that proper policies and procedures are being followed in determining eligibility. Explanation of disagreement with audit finding: There is no disagreement with the ...

Recommendation: We recommend that a supervisor or team lead perform regular internal reviews on MAXIS and METS casefiles to determine that proper policies and procedures are being followed in determining eligibility. Explanation of disagreement with audit finding: There is no disagreement with the audit finding. Action taken in response to finding: The County will implement policies to complete casefile reviews over all Medical Assistance casefiles. Name of the contact person responsible for corrective action: Loni Swenson, Finance Manager Planned completion date for corrective action plan: December 31, 2024

View Audit 317177

Finding 481038 (2023-002)

Material Weakness 2023

Ripley County

IN

Internal Control / Segregation of Duties Allowable Costs / Cost Principles Material Weakness § 200.1 § 200.303

FINDING 2023-002 Finding Subject: COVID-19 – Coronavirus State and Local Fiscal Recovery Funds – Reporting Summary of Finding: The County did not have procedures in place to prevent, or detect and correct, errors on Project and Expenditure (P&E) reports submitted to the U.S. Department of the Treasu...

FINDING 2023-002 Finding Subject: COVID-19 – Coronavirus State and Local Fiscal Recovery Funds – Reporting Summary of Finding: The County did not have procedures in place to prevent, or detect and correct, errors on Project and Expenditure (P&E) reports submitted to the U.S. Department of the Treasury. The report submitted during the audit period included projects with current period obligations and cumulative obligations totaling $3,319,955 that had not yet been obligated by the end of the reporting period. It was recommended that management of the County design and implement a proper system of internal controls, including policies and procedures that would provide segregation of duties to ensure appropriate reviews, approvals, and oversight of federal reports are taking place and to ensure the County provides the Treasury with complete and accurate information for the P&E report. Contact Person Responsible for Corrective Action: Amy Copeland Contact Phone Number and Email Address: acopeland@ripleycounty.com; 812-689-6311 INDIANA STATE BOARD OF ACCOUNTS 21 Ripley County Auditor Amy Copeland – Auditor 102 West 1st North Street, PO Box 235 Versailles, IN 47042 Ph: 812-689-6311 Fax: 812-689-3006 Views of Responsible Officials: We concur with the finding. Description of Corrective Action Plan: I, Amy Copeland, Auditor, plan to have the county attorney sit with me when I fill this report out from now on. I will also have one of my employees look over it before it is submitted. Anticipated Completion Date: April 30, 2025

View Audit 317157

Finding 480998 (2023-001)

Material Weakness 2023

Town of Sutton

MA

School Nutrition Programs Eligibility Internal Control / Segregation of Duties

Organization Name: Sutton Public Schools Address: 16 Putnam Hill Rd Sutton MA 01590 Issue Date: 05/20/2024 Audit Reference: 23-001 Non-Compliance Issue: verification process not completed during school year 22-23 Root Cause Analysis: This was caused by lack of knowledge due to manager change over wi...

Organization Name: Sutton Public Schools Address: 16 Putnam Hill Rd Sutton MA 01590 Issue Date: 05/20/2024 Audit Reference: 23-001 Non-Compliance Issue: verification process not completed during school year 22-23 Root Cause Analysis: This was caused by lack of knowledge due to manager change over with no overlap and managers starting date after verification completion deadline. Corrective Action(s): In planning for next school year, it has been set as a calendar reminder for October 1st to start the verification process with weekly goals set as to what needs to be done each week. As well as a reminder set for November 15th to make sure verification paperwork is submitted prior to the due date of November 17th. 1. Action Item: o Description: Set plans and calendar reminders in place to ensure the verification process is start prior to the end of September and that all is completed to be completed accurately before due date o Responsible Person/Department: Christina Poquette o Expected Completion Date:10/17/2024 Name: Christina Poquette Title: Director of Food and Nutrition Signature: Date: 5/20/2024 Acknowledgement by Responsible Parties: Name: Title: Signature: Date:5/20/2024 Organization Name: Sutton Public Schools Address: 16 Putnam Hill Rd Sutton MA 01590 Issue Date: 05/20/2024

View Audit 317107

Finding 480991 (2023-002)

Material Weakness 2023

Chestnut Ridge Public Service District

WV

Material Weakness Reporting Internal Control / Segregation of Duties

Management's goal is to complete the annual audit on schedule and if required, submit the date collection form into the Federal Audit Clearinghouse.

View Audit 317100

Finding 480964 (2023-001)

Material Weakness 2023

City of Dillingham

AK

Reporting Material Weakness § 200.512

Finding 2023-001 Late Reporting and Noncompliance with Reporting Requirements Name of Contact Person: Anita Fuller, Finance Director Corrective Action Plan: FY23 Audit onsite work has been completed and is still pending review. FY24 Audit has been scheduled in two part. Testwork is scheduled for t...

Finding 2023-001 Late Reporting and Noncompliance with Reporting Requirements Name of Contact Person: Anita Fuller, Finance Director Corrective Action Plan: FY23 Audit onsite work has been completed and is still pending review. FY24 Audit has been scheduled in two part. Testwork is scheduled for the week of September 30, 2024. With the final review in November. Upper-level staffing positions have been filled which will allow for work to be fulfilled in-house. Proposed Completion Date: Immediately

View Audit 317088

Finding 480940 (2023-002)

Material Weakness 2023

Usd #272, Cawker City, Kansas

KS

Material Weakness Reporting Internal Control / Segregation of Duties

2023-002 Reporting to the Federal Audit Clearinghouse (Material Weakness) Federal Agency: U.S. Environmental Protection Agency Program Name: Clean School Bus Program Assistance Listing Number: 66.045 Award Period: June 30, 2023 Recommendation: The Board of Education and management should implem...

2023-002 Reporting to the Federal Audit Clearinghouse (Material Weakness) Federal Agency: U.S. Environmental Protection Agency Program Name: Clean School Bus Program Assistance Listing Number: 66.045 Award Period: June 30, 2023 Recommendation: The Board of Education and management should implement internal control procedures that will ensure timely submission of the audit package and data collection form to the Federal Audit Clearinghouse within the required timeline. Action Taken (Unaudited): Management plans to develop proper written policies and procedures that will ensure timely submission of the audit package and data collection form to the Federal Audit Clearinghouse within the required timeline during years in which the District incurs federal expenditures above the threshold required by Uniform Guidance. Contact Name – Jesse Janssen Expected Completion Date – 12/31/2024

View Audit 317046

Finding 480919 (2023-004)

Material Weakness 2023

Pembroke Hill School

NH

Questioned Costs School Nutrition Programs Internal Control / Segregation of Duties § 200.303

Audit Finding Reference: 2023-004 Excess Food Service Fund Balance Management's View and Planned Corrective Action: Management agrees that the Food Service Fund Balance needs to be reduced The Department of Education in FY2023 they did not require a spend down plan for the application. With that s...

Audit Finding Reference: 2023-004 Excess Food Service Fund Balance Management's View and Planned Corrective Action: Management agrees that the Food Service Fund Balance needs to be reduced The Department of Education in FY2023 they did not require a spend down plan for the application. With that said we currently have a spend down plan in place to reduce the fund balance to a more appropriate fund balance and to meet the regulation. The spend down plan was submitted in March 2024. Name of Contact Person and Completion Date: Name 1 Amber Wheeler Name 2 Danielle Rossetti Anticipated Completion Date - December 31, 2024

View Audit 317015 Questioned Costs: $1

Finding 480698 (2023-002)

Material Weakness 2023

Wayne State University Research and Technology Park in the City of Detroit

MI

Subrecipient Monitoring Material Weakness

Finding Number: 2023-002 Condition: The Organization did not have controls in place to ensure required FFATA reports were submitted in the period of time required. Planned Corrective Action: The subrecipient organizations and the amounts of each sub-award were included in the grant application. The ...

Finding Number: 2023-002 Condition: The Organization did not have controls in place to ensure required FFATA reports were submitted in the period of time required. Planned Corrective Action: The subrecipient organizations and the amounts of each sub-award were included in the grant application. The subrecipients were listed in the Organization’s Prime award Specific Terms and Conditions. The organization has implemented an FFATA policy handbook to ensure awareness of the filing timing requirements. This handbook has been included in the Organization’s Grant Award checklist for all federal grant awards. Contact person responsible for corrective action: Diana Goode, Chief Financial Officer, and Norma Jean Zaleski, Director of Grant and Fiscal Compliance Anticipated Completion Date: 12/31/2024

View Audit 316927

Finding 480663 (2023-008)

Material Weakness 2023

Integrated Community Solutions, Inc.

WI

HUD Housing Programs Allowable Costs / Cost Principles Material Weakness

Action taken in response to finding: A paperless / electronic invoice approval system has begun in 2024. All invoices are received via email or scanned in and saved as a PDF and stored by month paid. Invoices are emailed to a responsible manager for approval and the approval response email is save...

Action taken in response to finding: A paperless / electronic invoice approval system has begun in 2024. All invoices are received via email or scanned in and saved as a PDF and stored by month paid. Invoices are emailed to a responsible manager for approval and the approval response email is saved with the invoice. The invoice and approval is also uploaded into Financial Edge with the invoice. Electronic records are available in an Accounts Payable network folder and in Financial Edge for additional review or reference. Names of the contact persons responsible for corrective action: Matt Roberts, Joe Kahler, Chimeng Vang Planned completion date for corrective action plan: Began January 2024

View Audit 316843

Finding 480544 (2023-001)

Material Weakness 2023

Town of Van Buren

ME

Procurement, Suspension & Debarment Allowable Costs / Cost Principles Material Weakness § 200.318 § 200.327

CORRECTIVE ACTION PLAN (Concerning Finding 2023-001) Contact Person Responsible for Corrective Action: Luke R Dyer, Town Manager Corrective Action: The Town of Van Buren will take the following actions to address finding 2023-001. The municipality is in the process of developing a Procurement Policy...

CORRECTIVE ACTION PLAN (Concerning Finding 2023-001) Contact Person Responsible for Corrective Action: Luke R Dyer, Town Manager Corrective Action: The Town of Van Buren will take the following actions to address finding 2023-001. The municipality is in the process of developing a Procurement Policy as related to all purchases made by Department Heads, within their department’s appropriated budget, and the Town Manager’s ability to authorize purchases. Additional considerations will be reviewed allowing the Town Council to approve purchases beyond the line items indicated in the yearly budget. Anticipated Completion Date: November 6, 2024 Sincerely, Luke R Dyer, Manager

View Audit 316743

Finding 480543 (2023-003)

Material Weakness 2023

McIntosh Senior Living

MN

Special Tests & Provisions Material Weakness Matching / Level of Effort / Earmarking § 200.303

Single Audit Finding 2023-003 Federal Agency Name: Program Name: Finding Summary: Responsible Individuals: Status: United States Department of Agriculture Community Facilities Loans and Grants Cluster Federal Assistance Listing #10.766 Corrective Action Plan The Organization did not have an adeq...

Single Audit Finding 2023-003 Federal Agency Name: Program Name: Finding Summary: Responsible Individuals: Status: United States Department of Agriculture Community Facilities Loans and Grants Cluster Federal Assistance Listing #10.766 Corrective Action Plan The Organization did not have an adequate internal control policy in place to ensure the reserve account was separately tracked and a documented review and approval over the reserve fund occurred. Sharlene Knutson, Administrator We have adopted a policy to enhance internal control to ensure the reserve fund reconciliation has a secondary review and approval that is documented. Anticipated Completion Date: 6/30/2024

View Audit 316739

Finding 480465 (2023-001)

Material Weakness 2023

Arbor Place INC

WI

Allowable Costs / Cost Principles Material Weakness Reporting § 200.303

We recommend Arbor Place to implement internal controls over reporting and allowable costs to ensure all financial records are complete and accurate.

View Audit 316660

Finding 480453 (2023-002)

Material Weakness 2023

Placer Hills Union School District

CA

Questioned Costs Allowable Costs / Cost Principles Subrecipient Monitoring

The district will ensure that all federally paid employees have a supporting and accurate Federal Time Certification record.

View Audit 316649 Questioned Costs: $1

Finding 480447 (2023-008)

Material Weakness 2023

People (projects to Empower & Organ Psychiatrically Labeled), Inc.

NY

Material Weakness Period of Performance

Organization submitted expenses outside of period of performance and was unable to provide proof of extension. Statement of Concurrence or Nonconcurrence: Concur Corrective Action: Although we did receive information via email and phone conversations intimating that extension for said grant was immi...

Organization submitted expenses outside of period of performance and was unable to provide proof of extension. Statement of Concurrence or Nonconcurrence: Concur Corrective Action: Although we did receive information via email and phone conversations intimating that extension for said grant was imminent, we will no longer continue to submit expenses without documented approval for extension in writing. We will also ensure that all expenses for said contracts will be posted to proper period so that we will comply Responsible Person to Oversee Corrective Action Plan: George Thomas Chief Financial Officer 845-452-2728 ext. 224 Date Corrective Plan will be put in Place: Starting today immediately June 13, 2024

View Audit 316636

Finding 480443 (2023-006)

Material Weakness 2023

People (projects to Empower & Organ Psychiatrically Labeled), Inc.

NY

Reporting Material Weakness

Organization was unable to provide Schedule of Expenditures of Federal Awards (SEFA) Statement of Concurrence or Nonconcurrence: Concur Corrective Action: We were unaware of the responsibility to provide this and did not know the origin of all grants received. Due to the information learned we are n...

Organization was unable to provide Schedule of Expenditures of Federal Awards (SEFA) Statement of Concurrence or Nonconcurrence: Concur Corrective Action: We were unaware of the responsibility to provide this and did not know the origin of all grants received. Due to the information learned we are now aware and have taken measures to inquire about the origin of all grants received going forward. With the help of the newly hired compliance officer, we will not have such a finding again because we will track revenues and expenditures for all grants prominently federal awards when they are received and spent to properly record them on the SEFA Responsible Person to Oversee Corrective Action Plan: George Thomas Chief Financial Officer 845-452-2728 ext. 224

View Audit 316636

Finding 480433 (2023-021)

Material Weakness 2023

State of New Hampshire

NH

Special Tests & Provisions Subrecipient Monitoring Cash Management

HSEM concurs with the finding. As a result of the audit, the practice of using individual emails to submit correspondence to FEMA was immediately addressed with staff and future correspondence will only be sent using the general shared email inbox. Regularly during staff meetings employees are remin...

HSEM concurs with the finding. As a result of the audit, the practice of using individual emails to submit correspondence to FEMA was immediately addressed with staff and future correspondence will only be sent using the general shared email inbox. Regularly during staff meetings employees are reminded to copy communications to the general shared inbox. Additionally, HSEM is currently working with the State’s Department of Information and Technology to gain access to prior staff’s emails. To note, the final paragraph in the Conditions section makes an incorrect statement regarding the submittal timeline requirements for Project Completion and Certification reports. PCCs are due within 90 days of project completion, not project obligation.

View Audit 316627

Finding 480431 (2023-019)

Material Weakness 2023

State of New Hampshire

NH

Material Weakness Reporting Matching / Level of Effort / Earmarking § 200.303

(SSA 4513) The department concurs with this finding and plans to work on the following areas to make reviewing and understanding of the reports an easier process: NHDDS will make sure that line 7 on the 4513 report is checked appropriately on all future reporting. NH DDS will update all process d...

(SSA 4513) The department concurs with this finding and plans to work on the following areas to make reviewing and understanding of the reports an easier process: NHDDS will make sure that line 7 on the 4513 report is checked appropriately on all future reporting. NH DDS will update all process directions for all fiscal reporting. For these directions, NH DDS will update all spreadsheets used for reporting purposes, add labels to column headers and link to cells when able for better understanding of our business processes and where amounts are pulled from. NH DDS will keep all backup documentation needed for these directions, to review all current open grant years. NHDDS will create “Mock” documents of each reporting process to help in any further reviews. (SSA 4514) Administrator runs a leave report for a 1-month time frame. Put in alpha order and date order. In an excel spreadsheet, staff are in alpha order. Leave time is added to each individual staff member for a time frame of 3 months (quarterly report). The total for each individual staff member is then populated to a second spread sheet which is broken out by position categories and each position total is then populated to the 4514 report. • On Duty Hours (column A) are the number of days worked in a quarter, times 7.50 hours per day. • Holiday/Leave Hours (column B) are the number of Holidays (7.50 hours per day) during that quarter plus the amount of leave (hours and minutes) per individual staff member during that quarter. • Total Hours (column C) is the amount of column A, plus column B, equals column C. • Total Part-Time Personnel-Is the number of hours the physician worked during that quarter. A report is run in Virtual Time Clock for the quarterly time frame and hours are entered into Part-Time, Medical Consultants (h.) Prior to completing the quarterly report, the excel spread sheet, sheet 2, will be reviewed to ensure cell equations are correct to eliminate formula errors used to calculate quarterly hours. When emailing the Administrator, the quarterly report for signature, the following statement will be in the body of the email to certify cell equations were reviewed prior, to eliminate formula errors: “I certify that I reviewed the SSA-4514 prior to completion, to ensure that cell equations were correct to eliminate formula errors.” Sent to the Administrator for signature then sent off to Region. Sent emails will be saved in an outlook folder for future reference and proofs that reports were sent.

View Audit 316627

Finding 480430 (2023-018)

Material Weakness 2023

State of New Hampshire

NH

Questioned Costs Material Weakness Period of Performance § 200.303

Corrective Action Planned: The identified payments relate to postage expenditures recorded in the Child Support Enforcement Grant. Postage expenditures are controlled in the State's mailing system through mail codes. Agencies send approved postage budgets to the Department of Administrative Service...

Corrective Action Planned: The identified payments relate to postage expenditures recorded in the Child Support Enforcement Grant. Postage expenditures are controlled in the State's mailing system through mail codes. Agencies send approved postage budgets to the Department of Administrative Services (DAS), who then creates a new mail code or adds additional funding to existing codes in the system. All mail processed through the mailing system is charged to these individual mail codes. A monthly expenditure report from the mailing system is interfaced with NH First, and the DAS uploads a journal entry to the general ledger to record these expenditures. The review and approvals for these postage transactions occur upfront at the agency level, not through a NH First approval workflow. DHHS and DAS will work together to document adequate evidence of this upfront review and approval.

View Audit 316627 Questioned Costs: $1

Finding 480414 (2023-010)

Material Weakness 2023

State of New Hampshire

NH

Reporting Subrecipient Monitoring Material Weakness § 200.303

This function (FFATA reporting) has now been designated to our Federal Reporting Group, which will allow for redundancy in personnel. A new policy and procedure, which will include internal controls, will be developed and implemented.

View Audit 316627

Finding 480410 (2023-009)

Material Weakness 2023

State of New Hampshire

NH

Questioned Costs Material Weakness Period of Performance § 200.303

NHED concurs with the finding identified with the expenditures of $3605. The NHED will have the LEA’s submitting for indirect costs after September 30th upload an invoice and back up documentation into GMS. The NHED concurs with the findings identified with expenditures of $5,172. There were i...

NHED concurs with the finding identified with the expenditures of $3605. The NHED will have the LEA’s submitting for indirect costs after September 30th upload an invoice and back up documentation into GMS. The NHED concurs with the findings identified with expenditures of $5,172. There were in fact some items that were charged outside the period of performance. This happened prior to us receiving the FY22 audit finding and putting in place new controls to prevent. We have since put into place DOE-OBM-33 to ensure payments are being reviewed closely to the period of performance at multiple times. We have also corrected any items charged to the wrong CAN. The NHED concurs with the findings identified with expenditures of $816. We will look into the district returning these funds or other enforcement actions. In addition to the DOE-OBM-033 process, the Division of Learner Support has created and implemented a transfer of funds procedure.

View Audit 316627 Questioned Costs: $1

Finding 480402 (2023-008)

Material Weakness 2023

State of New Hampshire

NH

Subrecipient Monitoring Reporting Material Weakness § 200.303

The Office of ESEA Title programs and Covid-19 education programs have established an internal process to sample and test reports compiled to ensure operations are executed as intended. These internal controls include a monthly reporting sign off Excel sheet, certification on each FFATA submission a...

The Office of ESEA Title programs and Covid-19 education programs have established an internal process to sample and test reports compiled to ensure operations are executed as intended. These internal controls include a monthly reporting sign off Excel sheet, certification on each FFATA submission and a secondary certification for accuracy verification, and a division wide process for FFATA filing and verification. Division wide training occurred on October 26, 2023. Due to grant award notification (GAN) changes and development within our grants management system (GMS), the FFATA process has also been developing and shifting; therefore the FFATA process will be revisited annually and updated as needed. A revised procedure for FFATA reporting will be completed prior to additional training being offered. To ensure that processes are being followed, newly hired staff is trained appropriately, and updates to the GAN process are considered within the FFATA process we will hold another training this spring, March 14th, 2024, prior to new subawards being issued.

View Audit 316627

Finding 480400 (2023-006)

Material Weakness 2023

State of New Hampshire

NH

Material Weakness Reporting Matching / Level of Effort / Earmarking § 200.303

BEA will evaluate existing internal controls in place to ensure that the precision level of the control is such that it would detect an error in the expenditures reported in comparison to the expenditures incurred within the general ledger, account for precision level control when changing guidance ...

BEA will evaluate existing internal controls in place to ensure that the precision level of the control is such that it would detect an error in the expenditures reported in comparison to the expenditures incurred within the general ledger, account for precision level control when changing guidance exists, and that all documentation used to support the amounts reported on the federal report are properly maintained. Condition A has been completed. In January 2024, BEA evaluated internal controls related to the review and approval of expenditures. The following additional reconciliation step was added to the processes of preparation of expenditure draws and reporting preparation: • Broadband program Accountant II performs a data extract from NHFirst and reconciles the drawdown calculation totals as well as “dashboard” reporting totals to the NHFirst data extract to confirm accuracy of all data points. This second data validation step has been added to ensure all expenditures recorded in NHFirst are evaluated against program guidelines, submitted for reimbursement and included on required reports. Condition B & C to be completed no later than 12/31/2024.

View Audit 316627

Finding 480397 (2023-003)

Material Weakness 2023

State of New Hampshire

NH

Internal Control / Segregation of Duties Cash Management Material Weakness § 200.303

In order to meet the segregation of duties, the Department will explore the need to create a position to ensure requisite segregation of duties requirements. With regard to the segregation of duties, the SF-270 is required form that DMAVS submits to the National Guard Appendix Program Manager for re...

In order to meet the segregation of duties, the Department will explore the need to create a position to ensure requisite segregation of duties requirements. With regard to the segregation of duties, the SF-270 is required form that DMAVS submits to the National Guard Appendix Program Manager for reimbursement with all back up documentation. The National Guard Appendix Program Manager, National Guard Grants Officer Representative, and National Guard United States Property Fiscal Officer (USPFO)/controller located in Concord, NH review, sign and submit the form to the Department of Defense on behalf of DMAVS to request the cash draw. Prior to the submission of reimbursement of any funds, each billing and invoice is reviewed, entered into a ledger and reconciled by three members of the accounting team. Once reconciled, the SF-270 is prepared and signed by the Financial Administrator. The SF-270 is then submitted to the appendix program manager for concurrence and then to the federal fiscal agent (USPFO) for approval. No funds are drawn down until approved by the USPFO. If this is not a satisfactory level of review, the department will request a new position to ensure that there the business function has the proper level of staffing to meet the requirements for segregation of duties.

View Audit 316627

Finding 480396 (2023-002)

Material Weakness 2023

State of New Hampshire

NH

Internal Control / Segregation of Duties Cash Management Material Weakness § 200.303

For clarity the Department will create a redundant manual ledger that duplicates the functions of the current ledger and Detailed Transaction Register (DTR). DMAVS has existing policies and procedures in place to track all federal funds, state funds and mixed funds, and uses spreadsheets for all tr...

For clarity the Department will create a redundant manual ledger that duplicates the functions of the current ledger and Detailed Transaction Register (DTR). DMAVS has existing policies and procedures in place to track all federal funds, state funds and mixed funds, and uses spreadsheets for all transactions that reconciles every month to NH First Detail Transaction Register (DTR), Federal Fund tracking sheet, and Federal reimbursement tracking sheet with backup documents. The tracking sheet for the federal register is not intended to account for the state share of billing. The state share is accurately accounted for in the DTR, the cumulative accounting in the SF-270 and associated back up documentation. Supporting documentation to substantiate the accuracy of lines a, c, e, and f is in the DTR, the cumulative accounting of each SF-270, the supporting documentation sent with the billing to the Federal Government, and Year-end Agency Report for Federal Awards. This includes reconciliation and analysis of SADB expenditures and revenues to the Statement of Appropriations by each Program Accounting Unit. The SF-270 form is continuous cumulative data that starts Oct 1st and runs through the end of that Federal Fiscal Year. The SF-270 is the required federal form DMAVS submits to the Federal National Guard Appendix Program Manager for reimbursement. Back up documentation is submitted with the SF-270. The National Guard Appendix Program Manager, National Guard Grants Officer Representative, and National Guard United States Property Fiscal Officer (USPFO)/controller located in Concord, NH review, sign and submit the form to the Department of Defense to affect the cash draw. DMAVS does not unilaterally make cash draws to the federal government. The USPFO, who is substantially involved provides an independent review and reconciles any discrepancies prior to approving any requests for reimbursement. One possible explanation for the finding is that the selected test works were not continuous.

View Audit 316627

Corrective Action Plans

Filters