Audit 16675

FY End
2022-12-31
Total Expended
$34.42M
Findings
24
Programs
1
Organization: Upper Palmetto Ymca, Inc. (SC)
Year: 2022 Accepted: 2023-04-26

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
12306 2022-001 Significant Deficiency - L
12307 2022-002 Significant Deficiency - L
12308 2022-001 Significant Deficiency - L
12309 2022-002 Significant Deficiency - L
12310 2022-001 Significant Deficiency - L
12311 2022-002 Significant Deficiency - L
12312 2022-001 Significant Deficiency - L
12313 2022-002 Significant Deficiency - L
12314 2022-001 Significant Deficiency - L
12315 2022-002 Significant Deficiency - L
12316 2022-001 Significant Deficiency - L
12317 2022-002 Significant Deficiency - L
588748 2022-001 Significant Deficiency - L
588749 2022-002 Significant Deficiency - L
588750 2022-001 Significant Deficiency - L
588751 2022-002 Significant Deficiency - L
588752 2022-001 Significant Deficiency - L
588753 2022-002 Significant Deficiency - L
588754 2022-001 Significant Deficiency - L
588755 2022-002 Significant Deficiency - L
588756 2022-001 Significant Deficiency - L
588757 2022-002 Significant Deficiency - L
588758 2022-001 Significant Deficiency - L
588759 2022-002 Significant Deficiency - L

Programs

ALN Program Spent Major Findings
10.766 Community Facilities Loans and Grants $4.46M Yes 2

Contacts

Name Title Type
KXVNCL1EK278 Chris Zamorski Auditee
8033249622 William Drinnon Auditor
No contacts on file

Notes to SEFA

Title: NOTE 4 PASSED THROUGH TO SUBRECIPIENTS Accounting Policies: Expenditures reported on the Schedule are reported on the accrual basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. De Minimis Rate Used: Y Rate Explanation: The auditee used the de minimis cost rate. Upper Palmetto YMCA, Inc. did not pass through any federal awards to other organizations.
Title: NOTE 3 - Loan/loan guarantee outstanding balances Accounting Policies: Expenditures reported on the Schedule are reported on the accrual basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. De Minimis Rate Used: Y Rate Explanation: The auditee used the de minimis cost rate. COMMUNITY FACILITIES LOANS AND GRANTS (10.766) - Balances outstanding at the end of the audit period were 7843470. COMMUNITY FACILITIES LOANS AND GRANTS (10.766) - Balances outstanding at the end of the audit period were 7353254. COMMUNITY FACILITIES LOANS AND GRANTS (10.766) - Balances outstanding at the end of the audit period were 8333687. COMMUNITY FACILITIES LOANS AND GRANTS (10.766) - Balances outstanding at the end of the audit period were 5591743. COMMUNITY FACILITIES LOANS AND GRANTS (10.766) - Balances outstanding at the end of the audit period were 290847. COMMUNITY FACILITIES LOANS AND GRANTS (10.766) - Balances outstanding at the end of the audit period were 4405267.
Title: NOTE 5 BASIS OF PRESENTATION Accounting Policies: Expenditures reported on the Schedule are reported on the accrual basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. De Minimis Rate Used: Y Rate Explanation: The auditee used the de minimis cost rate. The accompanying schedule of expenditures of federal awards (the Schedule) includes the federal award activity of Upper Palmetto YMCA, Inc. under programs of the federal government for the year ended December 31, 2022. The information in this Schedule is presented in accordance with the requirements of Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance). Because the Schedule presents only a selected portion of the operations of Upper Palmetto YMCA, Inc., it is not intended to and does not present the financial position, changes in net assets, or cash flows of Upper Palmetto YMCA, Inc.

Finding Details

SIGNIFICANT DEFICIENCIES: U.S. Department of Agriculture / Community Facilities Loans and Grants / CFDA # 10.776 Finding 2022-001 ? Form RD-442-2 Annual Reporting Requirement Criteria: The U.S. Department of Agriculture utilizes Form RD-442-2 for the borrower to submit its annual budget and its annual projected cash flow. Borrowers are allowed to submit another format in lieu of completing the form as long as it is compatible with all elements being included from the form. The Organization utilizes a Microsoft Excel workbook template in lieu of the form. The design of the Microsoft Excel template acts as an internal control to ascertain that the form?s required reporting elements are inclusive. Condition: The Organization?s workbook does not contain: 1) Schedule 1 Page 1 rows 23 and 26 for equity; 2) Schedule 1 Page 2 #1.e and 3) a worksheet / tab for the form?s Page 3 Schedule 2 of projected cash flow in order to include all elements for the annual reporting requirements. Cause: Management believed that its format was substantially compatible and had requested feedback from the U.S. Department of Agriculture with no response. Management assumed that format was acceptable based on the fact that no feedback was being provided with its annual, timely submissions. Potential Effect: It is possible that if the U.S. Department of Agriculture was relying on the reporting for certain decisions, then the missing information could impact those decisions negatively. Questioned Costs: None identified. Recommendation: Management should incorporate the missing elements to its Microsoft Excel template formats to ascertain that all elements of the form are inclusive for the required annual reporting. Views of Responsible Officials: Management agreed that the missing elements were absent from its template and will add them into the template for all future annual required reporting.
SIGNIFICANT DEFICIENCIES (CONTINUED): U.S. Department of Agriculture / Community Facilities Loans and Grants / CFDA # 10.776 Finding 2022-002 ? Form RD-442-2 Quarterly Reporting Requirement Criteria: The U.S. Department of Agriculture utilizes Form RD-442-2 for the borrower to submit its annual budget, quarterly amounts, and certain supplemental information. Borrowers are allowed to submit another format in lieu of completing the form as long as it is compatible with all elements being included from the form. The Organization utilizes a Microsoft Excel workbook template in lieu of the form. The design of the Microsoft Excel template acts as an internal control to ascertain that the form?s required reporting elements are inclusive. Condition: The Organization?s workbook does not contain: 1) Schedule 1 Page 1 columns 2, 3, and 6 and rows 23 and 26; 2) Schedule 1 Page 2 #6 and #7 and 3) from the Letter of Conditions dated September 8, 2017, [4th quarter only] a list of the names, addresses, and terms of office of the Board Chairperson and Board of Directors in order to include all elements for the quarterly reporting requirements. Cause: Management believed that its format was substantially compatible and had requested feedback from the U.S. Department of Agriculture with no response. Management assumed that format was acceptable based on the fact that no feedback was being provided with its quarterly, timely submissions. Potential Effect: It is possible that if the U.S. Department of Agriculture was relying on the reporting for certain decisions, then the missing information could impact those decisions negatively. Questioned Costs: None identified. Recommendation: Management should incorporate the missing elements to its Microsoft Excel template formats to ascertain that all elements of the form are inclusive for the required annual reporting. Views of Responsible Officials: Management agreed that the missing elements were absent from its template and will add them into the template for all future annual required reporting.
SIGNIFICANT DEFICIENCIES: U.S. Department of Agriculture / Community Facilities Loans and Grants / CFDA # 10.776 Finding 2022-001 ? Form RD-442-2 Annual Reporting Requirement Criteria: The U.S. Department of Agriculture utilizes Form RD-442-2 for the borrower to submit its annual budget and its annual projected cash flow. Borrowers are allowed to submit another format in lieu of completing the form as long as it is compatible with all elements being included from the form. The Organization utilizes a Microsoft Excel workbook template in lieu of the form. The design of the Microsoft Excel template acts as an internal control to ascertain that the form?s required reporting elements are inclusive. Condition: The Organization?s workbook does not contain: 1) Schedule 1 Page 1 rows 23 and 26 for equity; 2) Schedule 1 Page 2 #1.e and 3) a worksheet / tab for the form?s Page 3 Schedule 2 of projected cash flow in order to include all elements for the annual reporting requirements. Cause: Management believed that its format was substantially compatible and had requested feedback from the U.S. Department of Agriculture with no response. Management assumed that format was acceptable based on the fact that no feedback was being provided with its annual, timely submissions. Potential Effect: It is possible that if the U.S. Department of Agriculture was relying on the reporting for certain decisions, then the missing information could impact those decisions negatively. Questioned Costs: None identified. Recommendation: Management should incorporate the missing elements to its Microsoft Excel template formats to ascertain that all elements of the form are inclusive for the required annual reporting. Views of Responsible Officials: Management agreed that the missing elements were absent from its template and will add them into the template for all future annual required reporting.
SIGNIFICANT DEFICIENCIES (CONTINUED): U.S. Department of Agriculture / Community Facilities Loans and Grants / CFDA # 10.776 Finding 2022-002 ? Form RD-442-2 Quarterly Reporting Requirement Criteria: The U.S. Department of Agriculture utilizes Form RD-442-2 for the borrower to submit its annual budget, quarterly amounts, and certain supplemental information. Borrowers are allowed to submit another format in lieu of completing the form as long as it is compatible with all elements being included from the form. The Organization utilizes a Microsoft Excel workbook template in lieu of the form. The design of the Microsoft Excel template acts as an internal control to ascertain that the form?s required reporting elements are inclusive. Condition: The Organization?s workbook does not contain: 1) Schedule 1 Page 1 columns 2, 3, and 6 and rows 23 and 26; 2) Schedule 1 Page 2 #6 and #7 and 3) from the Letter of Conditions dated September 8, 2017, [4th quarter only] a list of the names, addresses, and terms of office of the Board Chairperson and Board of Directors in order to include all elements for the quarterly reporting requirements. Cause: Management believed that its format was substantially compatible and had requested feedback from the U.S. Department of Agriculture with no response. Management assumed that format was acceptable based on the fact that no feedback was being provided with its quarterly, timely submissions. Potential Effect: It is possible that if the U.S. Department of Agriculture was relying on the reporting for certain decisions, then the missing information could impact those decisions negatively. Questioned Costs: None identified. Recommendation: Management should incorporate the missing elements to its Microsoft Excel template formats to ascertain that all elements of the form are inclusive for the required annual reporting. Views of Responsible Officials: Management agreed that the missing elements were absent from its template and will add them into the template for all future annual required reporting.
SIGNIFICANT DEFICIENCIES: U.S. Department of Agriculture / Community Facilities Loans and Grants / CFDA # 10.776 Finding 2022-001 ? Form RD-442-2 Annual Reporting Requirement Criteria: The U.S. Department of Agriculture utilizes Form RD-442-2 for the borrower to submit its annual budget and its annual projected cash flow. Borrowers are allowed to submit another format in lieu of completing the form as long as it is compatible with all elements being included from the form. The Organization utilizes a Microsoft Excel workbook template in lieu of the form. The design of the Microsoft Excel template acts as an internal control to ascertain that the form?s required reporting elements are inclusive. Condition: The Organization?s workbook does not contain: 1) Schedule 1 Page 1 rows 23 and 26 for equity; 2) Schedule 1 Page 2 #1.e and 3) a worksheet / tab for the form?s Page 3 Schedule 2 of projected cash flow in order to include all elements for the annual reporting requirements. Cause: Management believed that its format was substantially compatible and had requested feedback from the U.S. Department of Agriculture with no response. Management assumed that format was acceptable based on the fact that no feedback was being provided with its annual, timely submissions. Potential Effect: It is possible that if the U.S. Department of Agriculture was relying on the reporting for certain decisions, then the missing information could impact those decisions negatively. Questioned Costs: None identified. Recommendation: Management should incorporate the missing elements to its Microsoft Excel template formats to ascertain that all elements of the form are inclusive for the required annual reporting. Views of Responsible Officials: Management agreed that the missing elements were absent from its template and will add them into the template for all future annual required reporting.
SIGNIFICANT DEFICIENCIES (CONTINUED): U.S. Department of Agriculture / Community Facilities Loans and Grants / CFDA # 10.776 Finding 2022-002 ? Form RD-442-2 Quarterly Reporting Requirement Criteria: The U.S. Department of Agriculture utilizes Form RD-442-2 for the borrower to submit its annual budget, quarterly amounts, and certain supplemental information. Borrowers are allowed to submit another format in lieu of completing the form as long as it is compatible with all elements being included from the form. The Organization utilizes a Microsoft Excel workbook template in lieu of the form. The design of the Microsoft Excel template acts as an internal control to ascertain that the form?s required reporting elements are inclusive. Condition: The Organization?s workbook does not contain: 1) Schedule 1 Page 1 columns 2, 3, and 6 and rows 23 and 26; 2) Schedule 1 Page 2 #6 and #7 and 3) from the Letter of Conditions dated September 8, 2017, [4th quarter only] a list of the names, addresses, and terms of office of the Board Chairperson and Board of Directors in order to include all elements for the quarterly reporting requirements. Cause: Management believed that its format was substantially compatible and had requested feedback from the U.S. Department of Agriculture with no response. Management assumed that format was acceptable based on the fact that no feedback was being provided with its quarterly, timely submissions. Potential Effect: It is possible that if the U.S. Department of Agriculture was relying on the reporting for certain decisions, then the missing information could impact those decisions negatively. Questioned Costs: None identified. Recommendation: Management should incorporate the missing elements to its Microsoft Excel template formats to ascertain that all elements of the form are inclusive for the required annual reporting. Views of Responsible Officials: Management agreed that the missing elements were absent from its template and will add them into the template for all future annual required reporting.
SIGNIFICANT DEFICIENCIES: U.S. Department of Agriculture / Community Facilities Loans and Grants / CFDA # 10.776 Finding 2022-001 ? Form RD-442-2 Annual Reporting Requirement Criteria: The U.S. Department of Agriculture utilizes Form RD-442-2 for the borrower to submit its annual budget and its annual projected cash flow. Borrowers are allowed to submit another format in lieu of completing the form as long as it is compatible with all elements being included from the form. The Organization utilizes a Microsoft Excel workbook template in lieu of the form. The design of the Microsoft Excel template acts as an internal control to ascertain that the form?s required reporting elements are inclusive. Condition: The Organization?s workbook does not contain: 1) Schedule 1 Page 1 rows 23 and 26 for equity; 2) Schedule 1 Page 2 #1.e and 3) a worksheet / tab for the form?s Page 3 Schedule 2 of projected cash flow in order to include all elements for the annual reporting requirements. Cause: Management believed that its format was substantially compatible and had requested feedback from the U.S. Department of Agriculture with no response. Management assumed that format was acceptable based on the fact that no feedback was being provided with its annual, timely submissions. Potential Effect: It is possible that if the U.S. Department of Agriculture was relying on the reporting for certain decisions, then the missing information could impact those decisions negatively. Questioned Costs: None identified. Recommendation: Management should incorporate the missing elements to its Microsoft Excel template formats to ascertain that all elements of the form are inclusive for the required annual reporting. Views of Responsible Officials: Management agreed that the missing elements were absent from its template and will add them into the template for all future annual required reporting.
SIGNIFICANT DEFICIENCIES (CONTINUED): U.S. Department of Agriculture / Community Facilities Loans and Grants / CFDA # 10.776 Finding 2022-002 ? Form RD-442-2 Quarterly Reporting Requirement Criteria: The U.S. Department of Agriculture utilizes Form RD-442-2 for the borrower to submit its annual budget, quarterly amounts, and certain supplemental information. Borrowers are allowed to submit another format in lieu of completing the form as long as it is compatible with all elements being included from the form. The Organization utilizes a Microsoft Excel workbook template in lieu of the form. The design of the Microsoft Excel template acts as an internal control to ascertain that the form?s required reporting elements are inclusive. Condition: The Organization?s workbook does not contain: 1) Schedule 1 Page 1 columns 2, 3, and 6 and rows 23 and 26; 2) Schedule 1 Page 2 #6 and #7 and 3) from the Letter of Conditions dated September 8, 2017, [4th quarter only] a list of the names, addresses, and terms of office of the Board Chairperson and Board of Directors in order to include all elements for the quarterly reporting requirements. Cause: Management believed that its format was substantially compatible and had requested feedback from the U.S. Department of Agriculture with no response. Management assumed that format was acceptable based on the fact that no feedback was being provided with its quarterly, timely submissions. Potential Effect: It is possible that if the U.S. Department of Agriculture was relying on the reporting for certain decisions, then the missing information could impact those decisions negatively. Questioned Costs: None identified. Recommendation: Management should incorporate the missing elements to its Microsoft Excel template formats to ascertain that all elements of the form are inclusive for the required annual reporting. Views of Responsible Officials: Management agreed that the missing elements were absent from its template and will add them into the template for all future annual required reporting.
SIGNIFICANT DEFICIENCIES: U.S. Department of Agriculture / Community Facilities Loans and Grants / CFDA # 10.776 Finding 2022-001 ? Form RD-442-2 Annual Reporting Requirement Criteria: The U.S. Department of Agriculture utilizes Form RD-442-2 for the borrower to submit its annual budget and its annual projected cash flow. Borrowers are allowed to submit another format in lieu of completing the form as long as it is compatible with all elements being included from the form. The Organization utilizes a Microsoft Excel workbook template in lieu of the form. The design of the Microsoft Excel template acts as an internal control to ascertain that the form?s required reporting elements are inclusive. Condition: The Organization?s workbook does not contain: 1) Schedule 1 Page 1 rows 23 and 26 for equity; 2) Schedule 1 Page 2 #1.e and 3) a worksheet / tab for the form?s Page 3 Schedule 2 of projected cash flow in order to include all elements for the annual reporting requirements. Cause: Management believed that its format was substantially compatible and had requested feedback from the U.S. Department of Agriculture with no response. Management assumed that format was acceptable based on the fact that no feedback was being provided with its annual, timely submissions. Potential Effect: It is possible that if the U.S. Department of Agriculture was relying on the reporting for certain decisions, then the missing information could impact those decisions negatively. Questioned Costs: None identified. Recommendation: Management should incorporate the missing elements to its Microsoft Excel template formats to ascertain that all elements of the form are inclusive for the required annual reporting. Views of Responsible Officials: Management agreed that the missing elements were absent from its template and will add them into the template for all future annual required reporting.
SIGNIFICANT DEFICIENCIES (CONTINUED): U.S. Department of Agriculture / Community Facilities Loans and Grants / CFDA # 10.776 Finding 2022-002 ? Form RD-442-2 Quarterly Reporting Requirement Criteria: The U.S. Department of Agriculture utilizes Form RD-442-2 for the borrower to submit its annual budget, quarterly amounts, and certain supplemental information. Borrowers are allowed to submit another format in lieu of completing the form as long as it is compatible with all elements being included from the form. The Organization utilizes a Microsoft Excel workbook template in lieu of the form. The design of the Microsoft Excel template acts as an internal control to ascertain that the form?s required reporting elements are inclusive. Condition: The Organization?s workbook does not contain: 1) Schedule 1 Page 1 columns 2, 3, and 6 and rows 23 and 26; 2) Schedule 1 Page 2 #6 and #7 and 3) from the Letter of Conditions dated September 8, 2017, [4th quarter only] a list of the names, addresses, and terms of office of the Board Chairperson and Board of Directors in order to include all elements for the quarterly reporting requirements. Cause: Management believed that its format was substantially compatible and had requested feedback from the U.S. Department of Agriculture with no response. Management assumed that format was acceptable based on the fact that no feedback was being provided with its quarterly, timely submissions. Potential Effect: It is possible that if the U.S. Department of Agriculture was relying on the reporting for certain decisions, then the missing information could impact those decisions negatively. Questioned Costs: None identified. Recommendation: Management should incorporate the missing elements to its Microsoft Excel template formats to ascertain that all elements of the form are inclusive for the required annual reporting. Views of Responsible Officials: Management agreed that the missing elements were absent from its template and will add them into the template for all future annual required reporting.
SIGNIFICANT DEFICIENCIES: U.S. Department of Agriculture / Community Facilities Loans and Grants / CFDA # 10.776 Finding 2022-001 ? Form RD-442-2 Annual Reporting Requirement Criteria: The U.S. Department of Agriculture utilizes Form RD-442-2 for the borrower to submit its annual budget and its annual projected cash flow. Borrowers are allowed to submit another format in lieu of completing the form as long as it is compatible with all elements being included from the form. The Organization utilizes a Microsoft Excel workbook template in lieu of the form. The design of the Microsoft Excel template acts as an internal control to ascertain that the form?s required reporting elements are inclusive. Condition: The Organization?s workbook does not contain: 1) Schedule 1 Page 1 rows 23 and 26 for equity; 2) Schedule 1 Page 2 #1.e and 3) a worksheet / tab for the form?s Page 3 Schedule 2 of projected cash flow in order to include all elements for the annual reporting requirements. Cause: Management believed that its format was substantially compatible and had requested feedback from the U.S. Department of Agriculture with no response. Management assumed that format was acceptable based on the fact that no feedback was being provided with its annual, timely submissions. Potential Effect: It is possible that if the U.S. Department of Agriculture was relying on the reporting for certain decisions, then the missing information could impact those decisions negatively. Questioned Costs: None identified. Recommendation: Management should incorporate the missing elements to its Microsoft Excel template formats to ascertain that all elements of the form are inclusive for the required annual reporting. Views of Responsible Officials: Management agreed that the missing elements were absent from its template and will add them into the template for all future annual required reporting.
SIGNIFICANT DEFICIENCIES (CONTINUED): U.S. Department of Agriculture / Community Facilities Loans and Grants / CFDA # 10.776 Finding 2022-002 ? Form RD-442-2 Quarterly Reporting Requirement Criteria: The U.S. Department of Agriculture utilizes Form RD-442-2 for the borrower to submit its annual budget, quarterly amounts, and certain supplemental information. Borrowers are allowed to submit another format in lieu of completing the form as long as it is compatible with all elements being included from the form. The Organization utilizes a Microsoft Excel workbook template in lieu of the form. The design of the Microsoft Excel template acts as an internal control to ascertain that the form?s required reporting elements are inclusive. Condition: The Organization?s workbook does not contain: 1) Schedule 1 Page 1 columns 2, 3, and 6 and rows 23 and 26; 2) Schedule 1 Page 2 #6 and #7 and 3) from the Letter of Conditions dated September 8, 2017, [4th quarter only] a list of the names, addresses, and terms of office of the Board Chairperson and Board of Directors in order to include all elements for the quarterly reporting requirements. Cause: Management believed that its format was substantially compatible and had requested feedback from the U.S. Department of Agriculture with no response. Management assumed that format was acceptable based on the fact that no feedback was being provided with its quarterly, timely submissions. Potential Effect: It is possible that if the U.S. Department of Agriculture was relying on the reporting for certain decisions, then the missing information could impact those decisions negatively. Questioned Costs: None identified. Recommendation: Management should incorporate the missing elements to its Microsoft Excel template formats to ascertain that all elements of the form are inclusive for the required annual reporting. Views of Responsible Officials: Management agreed that the missing elements were absent from its template and will add them into the template for all future annual required reporting.
SIGNIFICANT DEFICIENCIES: U.S. Department of Agriculture / Community Facilities Loans and Grants / CFDA # 10.776 Finding 2022-001 ? Form RD-442-2 Annual Reporting Requirement Criteria: The U.S. Department of Agriculture utilizes Form RD-442-2 for the borrower to submit its annual budget and its annual projected cash flow. Borrowers are allowed to submit another format in lieu of completing the form as long as it is compatible with all elements being included from the form. The Organization utilizes a Microsoft Excel workbook template in lieu of the form. The design of the Microsoft Excel template acts as an internal control to ascertain that the form?s required reporting elements are inclusive. Condition: The Organization?s workbook does not contain: 1) Schedule 1 Page 1 rows 23 and 26 for equity; 2) Schedule 1 Page 2 #1.e and 3) a worksheet / tab for the form?s Page 3 Schedule 2 of projected cash flow in order to include all elements for the annual reporting requirements. Cause: Management believed that its format was substantially compatible and had requested feedback from the U.S. Department of Agriculture with no response. Management assumed that format was acceptable based on the fact that no feedback was being provided with its annual, timely submissions. Potential Effect: It is possible that if the U.S. Department of Agriculture was relying on the reporting for certain decisions, then the missing information could impact those decisions negatively. Questioned Costs: None identified. Recommendation: Management should incorporate the missing elements to its Microsoft Excel template formats to ascertain that all elements of the form are inclusive for the required annual reporting. Views of Responsible Officials: Management agreed that the missing elements were absent from its template and will add them into the template for all future annual required reporting.
SIGNIFICANT DEFICIENCIES (CONTINUED): U.S. Department of Agriculture / Community Facilities Loans and Grants / CFDA # 10.776 Finding 2022-002 ? Form RD-442-2 Quarterly Reporting Requirement Criteria: The U.S. Department of Agriculture utilizes Form RD-442-2 for the borrower to submit its annual budget, quarterly amounts, and certain supplemental information. Borrowers are allowed to submit another format in lieu of completing the form as long as it is compatible with all elements being included from the form. The Organization utilizes a Microsoft Excel workbook template in lieu of the form. The design of the Microsoft Excel template acts as an internal control to ascertain that the form?s required reporting elements are inclusive. Condition: The Organization?s workbook does not contain: 1) Schedule 1 Page 1 columns 2, 3, and 6 and rows 23 and 26; 2) Schedule 1 Page 2 #6 and #7 and 3) from the Letter of Conditions dated September 8, 2017, [4th quarter only] a list of the names, addresses, and terms of office of the Board Chairperson and Board of Directors in order to include all elements for the quarterly reporting requirements. Cause: Management believed that its format was substantially compatible and had requested feedback from the U.S. Department of Agriculture with no response. Management assumed that format was acceptable based on the fact that no feedback was being provided with its quarterly, timely submissions. Potential Effect: It is possible that if the U.S. Department of Agriculture was relying on the reporting for certain decisions, then the missing information could impact those decisions negatively. Questioned Costs: None identified. Recommendation: Management should incorporate the missing elements to its Microsoft Excel template formats to ascertain that all elements of the form are inclusive for the required annual reporting. Views of Responsible Officials: Management agreed that the missing elements were absent from its template and will add them into the template for all future annual required reporting.
SIGNIFICANT DEFICIENCIES: U.S. Department of Agriculture / Community Facilities Loans and Grants / CFDA # 10.776 Finding 2022-001 ? Form RD-442-2 Annual Reporting Requirement Criteria: The U.S. Department of Agriculture utilizes Form RD-442-2 for the borrower to submit its annual budget and its annual projected cash flow. Borrowers are allowed to submit another format in lieu of completing the form as long as it is compatible with all elements being included from the form. The Organization utilizes a Microsoft Excel workbook template in lieu of the form. The design of the Microsoft Excel template acts as an internal control to ascertain that the form?s required reporting elements are inclusive. Condition: The Organization?s workbook does not contain: 1) Schedule 1 Page 1 rows 23 and 26 for equity; 2) Schedule 1 Page 2 #1.e and 3) a worksheet / tab for the form?s Page 3 Schedule 2 of projected cash flow in order to include all elements for the annual reporting requirements. Cause: Management believed that its format was substantially compatible and had requested feedback from the U.S. Department of Agriculture with no response. Management assumed that format was acceptable based on the fact that no feedback was being provided with its annual, timely submissions. Potential Effect: It is possible that if the U.S. Department of Agriculture was relying on the reporting for certain decisions, then the missing information could impact those decisions negatively. Questioned Costs: None identified. Recommendation: Management should incorporate the missing elements to its Microsoft Excel template formats to ascertain that all elements of the form are inclusive for the required annual reporting. Views of Responsible Officials: Management agreed that the missing elements were absent from its template and will add them into the template for all future annual required reporting.
SIGNIFICANT DEFICIENCIES (CONTINUED): U.S. Department of Agriculture / Community Facilities Loans and Grants / CFDA # 10.776 Finding 2022-002 ? Form RD-442-2 Quarterly Reporting Requirement Criteria: The U.S. Department of Agriculture utilizes Form RD-442-2 for the borrower to submit its annual budget, quarterly amounts, and certain supplemental information. Borrowers are allowed to submit another format in lieu of completing the form as long as it is compatible with all elements being included from the form. The Organization utilizes a Microsoft Excel workbook template in lieu of the form. The design of the Microsoft Excel template acts as an internal control to ascertain that the form?s required reporting elements are inclusive. Condition: The Organization?s workbook does not contain: 1) Schedule 1 Page 1 columns 2, 3, and 6 and rows 23 and 26; 2) Schedule 1 Page 2 #6 and #7 and 3) from the Letter of Conditions dated September 8, 2017, [4th quarter only] a list of the names, addresses, and terms of office of the Board Chairperson and Board of Directors in order to include all elements for the quarterly reporting requirements. Cause: Management believed that its format was substantially compatible and had requested feedback from the U.S. Department of Agriculture with no response. Management assumed that format was acceptable based on the fact that no feedback was being provided with its quarterly, timely submissions. Potential Effect: It is possible that if the U.S. Department of Agriculture was relying on the reporting for certain decisions, then the missing information could impact those decisions negatively. Questioned Costs: None identified. Recommendation: Management should incorporate the missing elements to its Microsoft Excel template formats to ascertain that all elements of the form are inclusive for the required annual reporting. Views of Responsible Officials: Management agreed that the missing elements were absent from its template and will add them into the template for all future annual required reporting.
SIGNIFICANT DEFICIENCIES: U.S. Department of Agriculture / Community Facilities Loans and Grants / CFDA # 10.776 Finding 2022-001 ? Form RD-442-2 Annual Reporting Requirement Criteria: The U.S. Department of Agriculture utilizes Form RD-442-2 for the borrower to submit its annual budget and its annual projected cash flow. Borrowers are allowed to submit another format in lieu of completing the form as long as it is compatible with all elements being included from the form. The Organization utilizes a Microsoft Excel workbook template in lieu of the form. The design of the Microsoft Excel template acts as an internal control to ascertain that the form?s required reporting elements are inclusive. Condition: The Organization?s workbook does not contain: 1) Schedule 1 Page 1 rows 23 and 26 for equity; 2) Schedule 1 Page 2 #1.e and 3) a worksheet / tab for the form?s Page 3 Schedule 2 of projected cash flow in order to include all elements for the annual reporting requirements. Cause: Management believed that its format was substantially compatible and had requested feedback from the U.S. Department of Agriculture with no response. Management assumed that format was acceptable based on the fact that no feedback was being provided with its annual, timely submissions. Potential Effect: It is possible that if the U.S. Department of Agriculture was relying on the reporting for certain decisions, then the missing information could impact those decisions negatively. Questioned Costs: None identified. Recommendation: Management should incorporate the missing elements to its Microsoft Excel template formats to ascertain that all elements of the form are inclusive for the required annual reporting. Views of Responsible Officials: Management agreed that the missing elements were absent from its template and will add them into the template for all future annual required reporting.
SIGNIFICANT DEFICIENCIES (CONTINUED): U.S. Department of Agriculture / Community Facilities Loans and Grants / CFDA # 10.776 Finding 2022-002 ? Form RD-442-2 Quarterly Reporting Requirement Criteria: The U.S. Department of Agriculture utilizes Form RD-442-2 for the borrower to submit its annual budget, quarterly amounts, and certain supplemental information. Borrowers are allowed to submit another format in lieu of completing the form as long as it is compatible with all elements being included from the form. The Organization utilizes a Microsoft Excel workbook template in lieu of the form. The design of the Microsoft Excel template acts as an internal control to ascertain that the form?s required reporting elements are inclusive. Condition: The Organization?s workbook does not contain: 1) Schedule 1 Page 1 columns 2, 3, and 6 and rows 23 and 26; 2) Schedule 1 Page 2 #6 and #7 and 3) from the Letter of Conditions dated September 8, 2017, [4th quarter only] a list of the names, addresses, and terms of office of the Board Chairperson and Board of Directors in order to include all elements for the quarterly reporting requirements. Cause: Management believed that its format was substantially compatible and had requested feedback from the U.S. Department of Agriculture with no response. Management assumed that format was acceptable based on the fact that no feedback was being provided with its quarterly, timely submissions. Potential Effect: It is possible that if the U.S. Department of Agriculture was relying on the reporting for certain decisions, then the missing information could impact those decisions negatively. Questioned Costs: None identified. Recommendation: Management should incorporate the missing elements to its Microsoft Excel template formats to ascertain that all elements of the form are inclusive for the required annual reporting. Views of Responsible Officials: Management agreed that the missing elements were absent from its template and will add them into the template for all future annual required reporting.
SIGNIFICANT DEFICIENCIES: U.S. Department of Agriculture / Community Facilities Loans and Grants / CFDA # 10.776 Finding 2022-001 ? Form RD-442-2 Annual Reporting Requirement Criteria: The U.S. Department of Agriculture utilizes Form RD-442-2 for the borrower to submit its annual budget and its annual projected cash flow. Borrowers are allowed to submit another format in lieu of completing the form as long as it is compatible with all elements being included from the form. The Organization utilizes a Microsoft Excel workbook template in lieu of the form. The design of the Microsoft Excel template acts as an internal control to ascertain that the form?s required reporting elements are inclusive. Condition: The Organization?s workbook does not contain: 1) Schedule 1 Page 1 rows 23 and 26 for equity; 2) Schedule 1 Page 2 #1.e and 3) a worksheet / tab for the form?s Page 3 Schedule 2 of projected cash flow in order to include all elements for the annual reporting requirements. Cause: Management believed that its format was substantially compatible and had requested feedback from the U.S. Department of Agriculture with no response. Management assumed that format was acceptable based on the fact that no feedback was being provided with its annual, timely submissions. Potential Effect: It is possible that if the U.S. Department of Agriculture was relying on the reporting for certain decisions, then the missing information could impact those decisions negatively. Questioned Costs: None identified. Recommendation: Management should incorporate the missing elements to its Microsoft Excel template formats to ascertain that all elements of the form are inclusive for the required annual reporting. Views of Responsible Officials: Management agreed that the missing elements were absent from its template and will add them into the template for all future annual required reporting.
SIGNIFICANT DEFICIENCIES (CONTINUED): U.S. Department of Agriculture / Community Facilities Loans and Grants / CFDA # 10.776 Finding 2022-002 ? Form RD-442-2 Quarterly Reporting Requirement Criteria: The U.S. Department of Agriculture utilizes Form RD-442-2 for the borrower to submit its annual budget, quarterly amounts, and certain supplemental information. Borrowers are allowed to submit another format in lieu of completing the form as long as it is compatible with all elements being included from the form. The Organization utilizes a Microsoft Excel workbook template in lieu of the form. The design of the Microsoft Excel template acts as an internal control to ascertain that the form?s required reporting elements are inclusive. Condition: The Organization?s workbook does not contain: 1) Schedule 1 Page 1 columns 2, 3, and 6 and rows 23 and 26; 2) Schedule 1 Page 2 #6 and #7 and 3) from the Letter of Conditions dated September 8, 2017, [4th quarter only] a list of the names, addresses, and terms of office of the Board Chairperson and Board of Directors in order to include all elements for the quarterly reporting requirements. Cause: Management believed that its format was substantially compatible and had requested feedback from the U.S. Department of Agriculture with no response. Management assumed that format was acceptable based on the fact that no feedback was being provided with its quarterly, timely submissions. Potential Effect: It is possible that if the U.S. Department of Agriculture was relying on the reporting for certain decisions, then the missing information could impact those decisions negatively. Questioned Costs: None identified. Recommendation: Management should incorporate the missing elements to its Microsoft Excel template formats to ascertain that all elements of the form are inclusive for the required annual reporting. Views of Responsible Officials: Management agreed that the missing elements were absent from its template and will add them into the template for all future annual required reporting.
SIGNIFICANT DEFICIENCIES: U.S. Department of Agriculture / Community Facilities Loans and Grants / CFDA # 10.776 Finding 2022-001 ? Form RD-442-2 Annual Reporting Requirement Criteria: The U.S. Department of Agriculture utilizes Form RD-442-2 for the borrower to submit its annual budget and its annual projected cash flow. Borrowers are allowed to submit another format in lieu of completing the form as long as it is compatible with all elements being included from the form. The Organization utilizes a Microsoft Excel workbook template in lieu of the form. The design of the Microsoft Excel template acts as an internal control to ascertain that the form?s required reporting elements are inclusive. Condition: The Organization?s workbook does not contain: 1) Schedule 1 Page 1 rows 23 and 26 for equity; 2) Schedule 1 Page 2 #1.e and 3) a worksheet / tab for the form?s Page 3 Schedule 2 of projected cash flow in order to include all elements for the annual reporting requirements. Cause: Management believed that its format was substantially compatible and had requested feedback from the U.S. Department of Agriculture with no response. Management assumed that format was acceptable based on the fact that no feedback was being provided with its annual, timely submissions. Potential Effect: It is possible that if the U.S. Department of Agriculture was relying on the reporting for certain decisions, then the missing information could impact those decisions negatively. Questioned Costs: None identified. Recommendation: Management should incorporate the missing elements to its Microsoft Excel template formats to ascertain that all elements of the form are inclusive for the required annual reporting. Views of Responsible Officials: Management agreed that the missing elements were absent from its template and will add them into the template for all future annual required reporting.
SIGNIFICANT DEFICIENCIES (CONTINUED): U.S. Department of Agriculture / Community Facilities Loans and Grants / CFDA # 10.776 Finding 2022-002 ? Form RD-442-2 Quarterly Reporting Requirement Criteria: The U.S. Department of Agriculture utilizes Form RD-442-2 for the borrower to submit its annual budget, quarterly amounts, and certain supplemental information. Borrowers are allowed to submit another format in lieu of completing the form as long as it is compatible with all elements being included from the form. The Organization utilizes a Microsoft Excel workbook template in lieu of the form. The design of the Microsoft Excel template acts as an internal control to ascertain that the form?s required reporting elements are inclusive. Condition: The Organization?s workbook does not contain: 1) Schedule 1 Page 1 columns 2, 3, and 6 and rows 23 and 26; 2) Schedule 1 Page 2 #6 and #7 and 3) from the Letter of Conditions dated September 8, 2017, [4th quarter only] a list of the names, addresses, and terms of office of the Board Chairperson and Board of Directors in order to include all elements for the quarterly reporting requirements. Cause: Management believed that its format was substantially compatible and had requested feedback from the U.S. Department of Agriculture with no response. Management assumed that format was acceptable based on the fact that no feedback was being provided with its quarterly, timely submissions. Potential Effect: It is possible that if the U.S. Department of Agriculture was relying on the reporting for certain decisions, then the missing information could impact those decisions negatively. Questioned Costs: None identified. Recommendation: Management should incorporate the missing elements to its Microsoft Excel template formats to ascertain that all elements of the form are inclusive for the required annual reporting. Views of Responsible Officials: Management agreed that the missing elements were absent from its template and will add them into the template for all future annual required reporting.
SIGNIFICANT DEFICIENCIES: U.S. Department of Agriculture / Community Facilities Loans and Grants / CFDA # 10.776 Finding 2022-001 ? Form RD-442-2 Annual Reporting Requirement Criteria: The U.S. Department of Agriculture utilizes Form RD-442-2 for the borrower to submit its annual budget and its annual projected cash flow. Borrowers are allowed to submit another format in lieu of completing the form as long as it is compatible with all elements being included from the form. The Organization utilizes a Microsoft Excel workbook template in lieu of the form. The design of the Microsoft Excel template acts as an internal control to ascertain that the form?s required reporting elements are inclusive. Condition: The Organization?s workbook does not contain: 1) Schedule 1 Page 1 rows 23 and 26 for equity; 2) Schedule 1 Page 2 #1.e and 3) a worksheet / tab for the form?s Page 3 Schedule 2 of projected cash flow in order to include all elements for the annual reporting requirements. Cause: Management believed that its format was substantially compatible and had requested feedback from the U.S. Department of Agriculture with no response. Management assumed that format was acceptable based on the fact that no feedback was being provided with its annual, timely submissions. Potential Effect: It is possible that if the U.S. Department of Agriculture was relying on the reporting for certain decisions, then the missing information could impact those decisions negatively. Questioned Costs: None identified. Recommendation: Management should incorporate the missing elements to its Microsoft Excel template formats to ascertain that all elements of the form are inclusive for the required annual reporting. Views of Responsible Officials: Management agreed that the missing elements were absent from its template and will add them into the template for all future annual required reporting.
SIGNIFICANT DEFICIENCIES (CONTINUED): U.S. Department of Agriculture / Community Facilities Loans and Grants / CFDA # 10.776 Finding 2022-002 ? Form RD-442-2 Quarterly Reporting Requirement Criteria: The U.S. Department of Agriculture utilizes Form RD-442-2 for the borrower to submit its annual budget, quarterly amounts, and certain supplemental information. Borrowers are allowed to submit another format in lieu of completing the form as long as it is compatible with all elements being included from the form. The Organization utilizes a Microsoft Excel workbook template in lieu of the form. The design of the Microsoft Excel template acts as an internal control to ascertain that the form?s required reporting elements are inclusive. Condition: The Organization?s workbook does not contain: 1) Schedule 1 Page 1 columns 2, 3, and 6 and rows 23 and 26; 2) Schedule 1 Page 2 #6 and #7 and 3) from the Letter of Conditions dated September 8, 2017, [4th quarter only] a list of the names, addresses, and terms of office of the Board Chairperson and Board of Directors in order to include all elements for the quarterly reporting requirements. Cause: Management believed that its format was substantially compatible and had requested feedback from the U.S. Department of Agriculture with no response. Management assumed that format was acceptable based on the fact that no feedback was being provided with its quarterly, timely submissions. Potential Effect: It is possible that if the U.S. Department of Agriculture was relying on the reporting for certain decisions, then the missing information could impact those decisions negatively. Questioned Costs: None identified. Recommendation: Management should incorporate the missing elements to its Microsoft Excel template formats to ascertain that all elements of the form are inclusive for the required annual reporting. Views of Responsible Officials: Management agreed that the missing elements were absent from its template and will add them into the template for all future annual required reporting.