Audit 23008

FY End
2022-12-31
Total Expended
$1.26M
Findings
24
Programs
9
Year: 2022 Accepted: 2023-06-07

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
22304 2022-001 Material Weakness Yes L
22305 2022-002 Material Weakness - L
22306 2022-003 Significant Deficiency Yes L
22307 2022-001 Material Weakness Yes L
22308 2022-002 Material Weakness - L
22309 2022-003 Significant Deficiency Yes L
22310 2022-001 Material Weakness Yes L
22311 2022-002 Material Weakness - L
22312 2022-003 Significant Deficiency Yes L
22313 2022-001 Material Weakness Yes L
22314 2022-002 Material Weakness - L
22315 2022-003 Significant Deficiency Yes L
598746 2022-001 Material Weakness Yes L
598747 2022-002 Material Weakness - L
598748 2022-003 Significant Deficiency Yes L
598749 2022-001 Material Weakness Yes L
598750 2022-002 Material Weakness - L
598751 2022-003 Significant Deficiency Yes L
598752 2022-001 Material Weakness Yes L
598753 2022-002 Material Weakness - L
598754 2022-003 Significant Deficiency Yes L
598755 2022-001 Material Weakness Yes L
598756 2022-002 Material Weakness - L
598757 2022-003 Significant Deficiency Yes L

Contacts

Name Title Type
G81BE2ZX8KR1 Heather Petrus Auditee
3152539795 Christina Ondrako Auditor
No contacts on file

Notes to SEFA

Title: basis of presentation Accounting Policies: Expenditures reported on the Schedule are reported on the accrual basis of accounting. The Schedulepresents the activity of all Federal awards administered by Cayuga Counseling Services, Inc. Federalawards received directly from federal agencies, as well as federal awards passed through from othergovernmental agencies, are included on the Schedule. Such expenditures are recognized following thecost principles contained in the Uniform Guidance, wherein certain types of expenditures are notallowable or are limited as to reimbursement. De Minimis Rate Used: N Rate Explanation: The auditee did not use the de minimis cost rate.Indirect costs are included in the reported expenditures to the extent they are included in the federalfinancial reports used as the source for the data provided. Cayuga Counseling Services, Inc. has electednot to use the 10percent de minimis indirect cost rate allowed under the Uniform Guidance. The accompanying schedule of expenditures of federal awards (the Schedule) includes the federal awardactivity of Cayuga Counseling Services, Inc. under programs of the federal government for the year endedDecember 31, 2022. The information in this schedule is presented in accordance with the requirementsof Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, CostPrinciples, and Audit Requirements for Federal Awards (Uniform Guidance). Therefore, some amountspresented in this schedule may differ from amounts presented in, or used in the preparation of, thefinancial statements. CFDA numbers and passthrough numbers are provided, when available.
Title: Health Resources and Services Administration (HRSA) Provider Relief Funds Accounting Policies: Expenditures reported on the Schedule are reported on the accrual basis of accounting. The Schedulepresents the activity of all Federal awards administered by Cayuga Counseling Services, Inc. Federalawards received directly from federal agencies, as well as federal awards passed through from othergovernmental agencies, are included on the Schedule. Such expenditures are recognized following thecost principles contained in the Uniform Guidance, wherein certain types of expenditures are notallowable or are limited as to reimbursement. De Minimis Rate Used: N Rate Explanation: The auditee did not use the de minimis cost rate.Indirect costs are included in the reported expenditures to the extent they are included in the federalfinancial reports used as the source for the data provided. Cayuga Counseling Services, Inc. has electednot to use the 10percent de minimis indirect cost rate allowed under the Uniform Guidance. Cayuga Counseling Services, Inc. received HRSA Provider Relief Funds of approximately $362,000 for theyear ended December 31, 2022. No amounts were received during 2021. Cayuga Counseling Services, Inc.followed the guidance in the 2022 Compliance Supplement, which requires reporting of the fundsreceived during 2022 on the 2023, or future SEFA.

Finding Details

2022-001 - Financial Statement Preparation and Reconciliation of Account Balances Criteria: Effectively designed and executed policies and procedures of financial processes should exist to ensure proper recordkeeping and reporting. Condition: Adjustments to clinical billings were not posted to the general ledger during the year under audit. In addition, the reserve for doubtful accounts was not evaluated and the prior year reserve was liquidated, creating revenue. Further, grant and contract receivables, deferred revenue and associated revenue were not reconciled. Cause: Reconciliation of certain account balances did not take place consistently throughout the year or at year end. Effect: The lack of reconciliations led to material audit adjustments necessary to correct significant errors identified in the following areas: accounts receivable, deferred revenue, bad debt expense and associated revenue accounts. Further, financials were used for decision-making purposes during the year that contained material misstatements. Recommendation: We recommend management ensure reconciliations are performed on a timely basis throughout the year as part of the monthly financial reporting processes before financial records are presented to executive management and the board of directors for decision-making purposes. Views of Responsible Official and Planned Corrective Actions: Management has established a policy for timely and methodical management of clinical billings and reconciliation with the general ledger. In addition, management has established a policy and procedure to reflect receivables in the billing management system at an expected realizable rate to also be reflected in the general ledger at the time of billing. Further, transition in the fiscal manager position is taking place and management will ensure that receivables and associated balances are reconciled and analyzed timely and that revenue is recognized in accordance with Generally Accepted Accounting Principles.
2022-002 - Adequate Financial Analysis and Oversight of Financial Records Criteria: Effectively designed and executed policies and procedures of financial processes should exist to ensure adequate financial analysis and oversight are present to properly record and report financial information. Condition: There was a lack of analysis of financial information and oversight over financial records/reporting throughout the year on an overall and individual program/grant level. Cause: Adequate supervision and timely oversight of grant/contract and program financials did not take place creating certain programs to generate losses for cost that could have been vouchered. Further, there was not adequate communication between finance personnel and programmatic personnel throughout the year. Effect: The lack of supervision and oversight resulted in the need for significant adjustments amongst programs to properly present financial results at the program level. Further, executive management and program management did not have accurate program financial data throughout the year. Recommendation: We recommend the management enhance regular reconciliation and reporting at the program and/or grant/contract level. Further, executive management should work with programmatic personnel to regularly assess the detailed financial results of each program, performing evaluations of the collectability of accounts receivable, budget modifications, and other financial assessments in tandem with programmatic reporting. Views of Responsible Official and Planned Corrective Actions: Executive management will expand regular review of timely monthly financials and will review such details with the finance committee of the board. Executive management will work with the program management team to understand budgeting, review budgets with their program managers on a monthly basis and empower them to complete budget modification timely. Executive management will ensure there is clear supervision and oversight duties and that these duties are adequately segregated.
2022-003 Internal Control Design and Oversight Condition: Two of eight selected payroll charges selected for testing lacked one required signature, either of the employee or a supervisor, on the Personnel Activity Report. In one additional instance, the signatures did not include the required date as evidence of timeliness of preparation or approval. Criteria: Effectively designed and executed controls should be present to ensure proper recordkeeping and reporting. Cause: In certain circumstances, documented processes were not followed. Effect: Payroll and benefits were charged that were not properly reviewed/approved or the approval may not have taken place timely. Recommendation: The auditor recommends that controls be executed to ensure adequate and timely oversight take place. View of Responsible Official: Management agrees and has implemented processes to review Personnel Activity Reports on a timely basis, this process will be reinforced and personnel reminded of the importance of following current procedures.
2022-001 - Financial Statement Preparation and Reconciliation of Account Balances Criteria: Effectively designed and executed policies and procedures of financial processes should exist to ensure proper recordkeeping and reporting. Condition: Adjustments to clinical billings were not posted to the general ledger during the year under audit. In addition, the reserve for doubtful accounts was not evaluated and the prior year reserve was liquidated, creating revenue. Further, grant and contract receivables, deferred revenue and associated revenue were not reconciled. Cause: Reconciliation of certain account balances did not take place consistently throughout the year or at year end. Effect: The lack of reconciliations led to material audit adjustments necessary to correct significant errors identified in the following areas: accounts receivable, deferred revenue, bad debt expense and associated revenue accounts. Further, financials were used for decision-making purposes during the year that contained material misstatements. Recommendation: We recommend management ensure reconciliations are performed on a timely basis throughout the year as part of the monthly financial reporting processes before financial records are presented to executive management and the board of directors for decision-making purposes. Views of Responsible Official and Planned Corrective Actions: Management has established a policy for timely and methodical management of clinical billings and reconciliation with the general ledger. In addition, management has established a policy and procedure to reflect receivables in the billing management system at an expected realizable rate to also be reflected in the general ledger at the time of billing. Further, transition in the fiscal manager position is taking place and management will ensure that receivables and associated balances are reconciled and analyzed timely and that revenue is recognized in accordance with Generally Accepted Accounting Principles.
2022-002 - Adequate Financial Analysis and Oversight of Financial Records Criteria: Effectively designed and executed policies and procedures of financial processes should exist to ensure adequate financial analysis and oversight are present to properly record and report financial information. Condition: There was a lack of analysis of financial information and oversight over financial records/reporting throughout the year on an overall and individual program/grant level. Cause: Adequate supervision and timely oversight of grant/contract and program financials did not take place creating certain programs to generate losses for cost that could have been vouchered. Further, there was not adequate communication between finance personnel and programmatic personnel throughout the year. Effect: The lack of supervision and oversight resulted in the need for significant adjustments amongst programs to properly present financial results at the program level. Further, executive management and program management did not have accurate program financial data throughout the year. Recommendation: We recommend the management enhance regular reconciliation and reporting at the program and/or grant/contract level. Further, executive management should work with programmatic personnel to regularly assess the detailed financial results of each program, performing evaluations of the collectability of accounts receivable, budget modifications, and other financial assessments in tandem with programmatic reporting. Views of Responsible Official and Planned Corrective Actions: Executive management will expand regular review of timely monthly financials and will review such details with the finance committee of the board. Executive management will work with the program management team to understand budgeting, review budgets with their program managers on a monthly basis and empower them to complete budget modification timely. Executive management will ensure there is clear supervision and oversight duties and that these duties are adequately segregated.
2022-003 Internal Control Design and Oversight Condition: Two of eight selected payroll charges selected for testing lacked one required signature, either of the employee or a supervisor, on the Personnel Activity Report. In one additional instance, the signatures did not include the required date as evidence of timeliness of preparation or approval. Criteria: Effectively designed and executed controls should be present to ensure proper recordkeeping and reporting. Cause: In certain circumstances, documented processes were not followed. Effect: Payroll and benefits were charged that were not properly reviewed/approved or the approval may not have taken place timely. Recommendation: The auditor recommends that controls be executed to ensure adequate and timely oversight take place. View of Responsible Official: Management agrees and has implemented processes to review Personnel Activity Reports on a timely basis, this process will be reinforced and personnel reminded of the importance of following current procedures.
2022-001 - Financial Statement Preparation and Reconciliation of Account Balances Criteria: Effectively designed and executed policies and procedures of financial processes should exist to ensure proper recordkeeping and reporting. Condition: Adjustments to clinical billings were not posted to the general ledger during the year under audit. In addition, the reserve for doubtful accounts was not evaluated and the prior year reserve was liquidated, creating revenue. Further, grant and contract receivables, deferred revenue and associated revenue were not reconciled. Cause: Reconciliation of certain account balances did not take place consistently throughout the year or at year end. Effect: The lack of reconciliations led to material audit adjustments necessary to correct significant errors identified in the following areas: accounts receivable, deferred revenue, bad debt expense and associated revenue accounts. Further, financials were used for decision-making purposes during the year that contained material misstatements. Recommendation: We recommend management ensure reconciliations are performed on a timely basis throughout the year as part of the monthly financial reporting processes before financial records are presented to executive management and the board of directors for decision-making purposes. Views of Responsible Official and Planned Corrective Actions: Management has established a policy for timely and methodical management of clinical billings and reconciliation with the general ledger. In addition, management has established a policy and procedure to reflect receivables in the billing management system at an expected realizable rate to also be reflected in the general ledger at the time of billing. Further, transition in the fiscal manager position is taking place and management will ensure that receivables and associated balances are reconciled and analyzed timely and that revenue is recognized in accordance with Generally Accepted Accounting Principles.
2022-002 - Adequate Financial Analysis and Oversight of Financial Records Criteria: Effectively designed and executed policies and procedures of financial processes should exist to ensure adequate financial analysis and oversight are present to properly record and report financial information. Condition: There was a lack of analysis of financial information and oversight over financial records/reporting throughout the year on an overall and individual program/grant level. Cause: Adequate supervision and timely oversight of grant/contract and program financials did not take place creating certain programs to generate losses for cost that could have been vouchered. Further, there was not adequate communication between finance personnel and programmatic personnel throughout the year. Effect: The lack of supervision and oversight resulted in the need for significant adjustments amongst programs to properly present financial results at the program level. Further, executive management and program management did not have accurate program financial data throughout the year. Recommendation: We recommend the management enhance regular reconciliation and reporting at the program and/or grant/contract level. Further, executive management should work with programmatic personnel to regularly assess the detailed financial results of each program, performing evaluations of the collectability of accounts receivable, budget modifications, and other financial assessments in tandem with programmatic reporting. Views of Responsible Official and Planned Corrective Actions: Executive management will expand regular review of timely monthly financials and will review such details with the finance committee of the board. Executive management will work with the program management team to understand budgeting, review budgets with their program managers on a monthly basis and empower them to complete budget modification timely. Executive management will ensure there is clear supervision and oversight duties and that these duties are adequately segregated.
2022-003 Internal Control Design and Oversight Condition: Two of eight selected payroll charges selected for testing lacked one required signature, either of the employee or a supervisor, on the Personnel Activity Report. In one additional instance, the signatures did not include the required date as evidence of timeliness of preparation or approval. Criteria: Effectively designed and executed controls should be present to ensure proper recordkeeping and reporting. Cause: In certain circumstances, documented processes were not followed. Effect: Payroll and benefits were charged that were not properly reviewed/approved or the approval may not have taken place timely. Recommendation: The auditor recommends that controls be executed to ensure adequate and timely oversight take place. View of Responsible Official: Management agrees and has implemented processes to review Personnel Activity Reports on a timely basis, this process will be reinforced and personnel reminded of the importance of following current procedures.
2022-001 - Financial Statement Preparation and Reconciliation of Account Balances Criteria: Effectively designed and executed policies and procedures of financial processes should exist to ensure proper recordkeeping and reporting. Condition: Adjustments to clinical billings were not posted to the general ledger during the year under audit. In addition, the reserve for doubtful accounts was not evaluated and the prior year reserve was liquidated, creating revenue. Further, grant and contract receivables, deferred revenue and associated revenue were not reconciled. Cause: Reconciliation of certain account balances did not take place consistently throughout the year or at year end. Effect: The lack of reconciliations led to material audit adjustments necessary to correct significant errors identified in the following areas: accounts receivable, deferred revenue, bad debt expense and associated revenue accounts. Further, financials were used for decision-making purposes during the year that contained material misstatements. Recommendation: We recommend management ensure reconciliations are performed on a timely basis throughout the year as part of the monthly financial reporting processes before financial records are presented to executive management and the board of directors for decision-making purposes. Views of Responsible Official and Planned Corrective Actions: Management has established a policy for timely and methodical management of clinical billings and reconciliation with the general ledger. In addition, management has established a policy and procedure to reflect receivables in the billing management system at an expected realizable rate to also be reflected in the general ledger at the time of billing. Further, transition in the fiscal manager position is taking place and management will ensure that receivables and associated balances are reconciled and analyzed timely and that revenue is recognized in accordance with Generally Accepted Accounting Principles.
2022-002 - Adequate Financial Analysis and Oversight of Financial Records Criteria: Effectively designed and executed policies and procedures of financial processes should exist to ensure adequate financial analysis and oversight are present to properly record and report financial information. Condition: There was a lack of analysis of financial information and oversight over financial records/reporting throughout the year on an overall and individual program/grant level. Cause: Adequate supervision and timely oversight of grant/contract and program financials did not take place creating certain programs to generate losses for cost that could have been vouchered. Further, there was not adequate communication between finance personnel and programmatic personnel throughout the year. Effect: The lack of supervision and oversight resulted in the need for significant adjustments amongst programs to properly present financial results at the program level. Further, executive management and program management did not have accurate program financial data throughout the year. Recommendation: We recommend the management enhance regular reconciliation and reporting at the program and/or grant/contract level. Further, executive management should work with programmatic personnel to regularly assess the detailed financial results of each program, performing evaluations of the collectability of accounts receivable, budget modifications, and other financial assessments in tandem with programmatic reporting. Views of Responsible Official and Planned Corrective Actions: Executive management will expand regular review of timely monthly financials and will review such details with the finance committee of the board. Executive management will work with the program management team to understand budgeting, review budgets with their program managers on a monthly basis and empower them to complete budget modification timely. Executive management will ensure there is clear supervision and oversight duties and that these duties are adequately segregated.
2022-003 Internal Control Design and Oversight Condition: Two of eight selected payroll charges selected for testing lacked one required signature, either of the employee or a supervisor, on the Personnel Activity Report. In one additional instance, the signatures did not include the required date as evidence of timeliness of preparation or approval. Criteria: Effectively designed and executed controls should be present to ensure proper recordkeeping and reporting. Cause: In certain circumstances, documented processes were not followed. Effect: Payroll and benefits were charged that were not properly reviewed/approved or the approval may not have taken place timely. Recommendation: The auditor recommends that controls be executed to ensure adequate and timely oversight take place. View of Responsible Official: Management agrees and has implemented processes to review Personnel Activity Reports on a timely basis, this process will be reinforced and personnel reminded of the importance of following current procedures.
2022-001 - Financial Statement Preparation and Reconciliation of Account Balances Criteria: Effectively designed and executed policies and procedures of financial processes should exist to ensure proper recordkeeping and reporting. Condition: Adjustments to clinical billings were not posted to the general ledger during the year under audit. In addition, the reserve for doubtful accounts was not evaluated and the prior year reserve was liquidated, creating revenue. Further, grant and contract receivables, deferred revenue and associated revenue were not reconciled. Cause: Reconciliation of certain account balances did not take place consistently throughout the year or at year end. Effect: The lack of reconciliations led to material audit adjustments necessary to correct significant errors identified in the following areas: accounts receivable, deferred revenue, bad debt expense and associated revenue accounts. Further, financials were used for decision-making purposes during the year that contained material misstatements. Recommendation: We recommend management ensure reconciliations are performed on a timely basis throughout the year as part of the monthly financial reporting processes before financial records are presented to executive management and the board of directors for decision-making purposes. Views of Responsible Official and Planned Corrective Actions: Management has established a policy for timely and methodical management of clinical billings and reconciliation with the general ledger. In addition, management has established a policy and procedure to reflect receivables in the billing management system at an expected realizable rate to also be reflected in the general ledger at the time of billing. Further, transition in the fiscal manager position is taking place and management will ensure that receivables and associated balances are reconciled and analyzed timely and that revenue is recognized in accordance with Generally Accepted Accounting Principles.
2022-002 - Adequate Financial Analysis and Oversight of Financial Records Criteria: Effectively designed and executed policies and procedures of financial processes should exist to ensure adequate financial analysis and oversight are present to properly record and report financial information. Condition: There was a lack of analysis of financial information and oversight over financial records/reporting throughout the year on an overall and individual program/grant level. Cause: Adequate supervision and timely oversight of grant/contract and program financials did not take place creating certain programs to generate losses for cost that could have been vouchered. Further, there was not adequate communication between finance personnel and programmatic personnel throughout the year. Effect: The lack of supervision and oversight resulted in the need for significant adjustments amongst programs to properly present financial results at the program level. Further, executive management and program management did not have accurate program financial data throughout the year. Recommendation: We recommend the management enhance regular reconciliation and reporting at the program and/or grant/contract level. Further, executive management should work with programmatic personnel to regularly assess the detailed financial results of each program, performing evaluations of the collectability of accounts receivable, budget modifications, and other financial assessments in tandem with programmatic reporting. Views of Responsible Official and Planned Corrective Actions: Executive management will expand regular review of timely monthly financials and will review such details with the finance committee of the board. Executive management will work with the program management team to understand budgeting, review budgets with their program managers on a monthly basis and empower them to complete budget modification timely. Executive management will ensure there is clear supervision and oversight duties and that these duties are adequately segregated.
2022-003 Internal Control Design and Oversight Condition: Two of eight selected payroll charges selected for testing lacked one required signature, either of the employee or a supervisor, on the Personnel Activity Report. In one additional instance, the signatures did not include the required date as evidence of timeliness of preparation or approval. Criteria: Effectively designed and executed controls should be present to ensure proper recordkeeping and reporting. Cause: In certain circumstances, documented processes were not followed. Effect: Payroll and benefits were charged that were not properly reviewed/approved or the approval may not have taken place timely. Recommendation: The auditor recommends that controls be executed to ensure adequate and timely oversight take place. View of Responsible Official: Management agrees and has implemented processes to review Personnel Activity Reports on a timely basis, this process will be reinforced and personnel reminded of the importance of following current procedures.
2022-001 - Financial Statement Preparation and Reconciliation of Account Balances Criteria: Effectively designed and executed policies and procedures of financial processes should exist to ensure proper recordkeeping and reporting. Condition: Adjustments to clinical billings were not posted to the general ledger during the year under audit. In addition, the reserve for doubtful accounts was not evaluated and the prior year reserve was liquidated, creating revenue. Further, grant and contract receivables, deferred revenue and associated revenue were not reconciled. Cause: Reconciliation of certain account balances did not take place consistently throughout the year or at year end. Effect: The lack of reconciliations led to material audit adjustments necessary to correct significant errors identified in the following areas: accounts receivable, deferred revenue, bad debt expense and associated revenue accounts. Further, financials were used for decision-making purposes during the year that contained material misstatements. Recommendation: We recommend management ensure reconciliations are performed on a timely basis throughout the year as part of the monthly financial reporting processes before financial records are presented to executive management and the board of directors for decision-making purposes. Views of Responsible Official and Planned Corrective Actions: Management has established a policy for timely and methodical management of clinical billings and reconciliation with the general ledger. In addition, management has established a policy and procedure to reflect receivables in the billing management system at an expected realizable rate to also be reflected in the general ledger at the time of billing. Further, transition in the fiscal manager position is taking place and management will ensure that receivables and associated balances are reconciled and analyzed timely and that revenue is recognized in accordance with Generally Accepted Accounting Principles.
2022-002 - Adequate Financial Analysis and Oversight of Financial Records Criteria: Effectively designed and executed policies and procedures of financial processes should exist to ensure adequate financial analysis and oversight are present to properly record and report financial information. Condition: There was a lack of analysis of financial information and oversight over financial records/reporting throughout the year on an overall and individual program/grant level. Cause: Adequate supervision and timely oversight of grant/contract and program financials did not take place creating certain programs to generate losses for cost that could have been vouchered. Further, there was not adequate communication between finance personnel and programmatic personnel throughout the year. Effect: The lack of supervision and oversight resulted in the need for significant adjustments amongst programs to properly present financial results at the program level. Further, executive management and program management did not have accurate program financial data throughout the year. Recommendation: We recommend the management enhance regular reconciliation and reporting at the program and/or grant/contract level. Further, executive management should work with programmatic personnel to regularly assess the detailed financial results of each program, performing evaluations of the collectability of accounts receivable, budget modifications, and other financial assessments in tandem with programmatic reporting. Views of Responsible Official and Planned Corrective Actions: Executive management will expand regular review of timely monthly financials and will review such details with the finance committee of the board. Executive management will work with the program management team to understand budgeting, review budgets with their program managers on a monthly basis and empower them to complete budget modification timely. Executive management will ensure there is clear supervision and oversight duties and that these duties are adequately segregated.
2022-003 Internal Control Design and Oversight Condition: Two of eight selected payroll charges selected for testing lacked one required signature, either of the employee or a supervisor, on the Personnel Activity Report. In one additional instance, the signatures did not include the required date as evidence of timeliness of preparation or approval. Criteria: Effectively designed and executed controls should be present to ensure proper recordkeeping and reporting. Cause: In certain circumstances, documented processes were not followed. Effect: Payroll and benefits were charged that were not properly reviewed/approved or the approval may not have taken place timely. Recommendation: The auditor recommends that controls be executed to ensure adequate and timely oversight take place. View of Responsible Official: Management agrees and has implemented processes to review Personnel Activity Reports on a timely basis, this process will be reinforced and personnel reminded of the importance of following current procedures.
2022-001 - Financial Statement Preparation and Reconciliation of Account Balances Criteria: Effectively designed and executed policies and procedures of financial processes should exist to ensure proper recordkeeping and reporting. Condition: Adjustments to clinical billings were not posted to the general ledger during the year under audit. In addition, the reserve for doubtful accounts was not evaluated and the prior year reserve was liquidated, creating revenue. Further, grant and contract receivables, deferred revenue and associated revenue were not reconciled. Cause: Reconciliation of certain account balances did not take place consistently throughout the year or at year end. Effect: The lack of reconciliations led to material audit adjustments necessary to correct significant errors identified in the following areas: accounts receivable, deferred revenue, bad debt expense and associated revenue accounts. Further, financials were used for decision-making purposes during the year that contained material misstatements. Recommendation: We recommend management ensure reconciliations are performed on a timely basis throughout the year as part of the monthly financial reporting processes before financial records are presented to executive management and the board of directors for decision-making purposes. Views of Responsible Official and Planned Corrective Actions: Management has established a policy for timely and methodical management of clinical billings and reconciliation with the general ledger. In addition, management has established a policy and procedure to reflect receivables in the billing management system at an expected realizable rate to also be reflected in the general ledger at the time of billing. Further, transition in the fiscal manager position is taking place and management will ensure that receivables and associated balances are reconciled and analyzed timely and that revenue is recognized in accordance with Generally Accepted Accounting Principles.
2022-002 - Adequate Financial Analysis and Oversight of Financial Records Criteria: Effectively designed and executed policies and procedures of financial processes should exist to ensure adequate financial analysis and oversight are present to properly record and report financial information. Condition: There was a lack of analysis of financial information and oversight over financial records/reporting throughout the year on an overall and individual program/grant level. Cause: Adequate supervision and timely oversight of grant/contract and program financials did not take place creating certain programs to generate losses for cost that could have been vouchered. Further, there was not adequate communication between finance personnel and programmatic personnel throughout the year. Effect: The lack of supervision and oversight resulted in the need for significant adjustments amongst programs to properly present financial results at the program level. Further, executive management and program management did not have accurate program financial data throughout the year. Recommendation: We recommend the management enhance regular reconciliation and reporting at the program and/or grant/contract level. Further, executive management should work with programmatic personnel to regularly assess the detailed financial results of each program, performing evaluations of the collectability of accounts receivable, budget modifications, and other financial assessments in tandem with programmatic reporting. Views of Responsible Official and Planned Corrective Actions: Executive management will expand regular review of timely monthly financials and will review such details with the finance committee of the board. Executive management will work with the program management team to understand budgeting, review budgets with their program managers on a monthly basis and empower them to complete budget modification timely. Executive management will ensure there is clear supervision and oversight duties and that these duties are adequately segregated.
2022-003 Internal Control Design and Oversight Condition: Two of eight selected payroll charges selected for testing lacked one required signature, either of the employee or a supervisor, on the Personnel Activity Report. In one additional instance, the signatures did not include the required date as evidence of timeliness of preparation or approval. Criteria: Effectively designed and executed controls should be present to ensure proper recordkeeping and reporting. Cause: In certain circumstances, documented processes were not followed. Effect: Payroll and benefits were charged that were not properly reviewed/approved or the approval may not have taken place timely. Recommendation: The auditor recommends that controls be executed to ensure adequate and timely oversight take place. View of Responsible Official: Management agrees and has implemented processes to review Personnel Activity Reports on a timely basis, this process will be reinforced and personnel reminded of the importance of following current procedures.
2022-001 - Financial Statement Preparation and Reconciliation of Account Balances Criteria: Effectively designed and executed policies and procedures of financial processes should exist to ensure proper recordkeeping and reporting. Condition: Adjustments to clinical billings were not posted to the general ledger during the year under audit. In addition, the reserve for doubtful accounts was not evaluated and the prior year reserve was liquidated, creating revenue. Further, grant and contract receivables, deferred revenue and associated revenue were not reconciled. Cause: Reconciliation of certain account balances did not take place consistently throughout the year or at year end. Effect: The lack of reconciliations led to material audit adjustments necessary to correct significant errors identified in the following areas: accounts receivable, deferred revenue, bad debt expense and associated revenue accounts. Further, financials were used for decision-making purposes during the year that contained material misstatements. Recommendation: We recommend management ensure reconciliations are performed on a timely basis throughout the year as part of the monthly financial reporting processes before financial records are presented to executive management and the board of directors for decision-making purposes. Views of Responsible Official and Planned Corrective Actions: Management has established a policy for timely and methodical management of clinical billings and reconciliation with the general ledger. In addition, management has established a policy and procedure to reflect receivables in the billing management system at an expected realizable rate to also be reflected in the general ledger at the time of billing. Further, transition in the fiscal manager position is taking place and management will ensure that receivables and associated balances are reconciled and analyzed timely and that revenue is recognized in accordance with Generally Accepted Accounting Principles.
2022-002 - Adequate Financial Analysis and Oversight of Financial Records Criteria: Effectively designed and executed policies and procedures of financial processes should exist to ensure adequate financial analysis and oversight are present to properly record and report financial information. Condition: There was a lack of analysis of financial information and oversight over financial records/reporting throughout the year on an overall and individual program/grant level. Cause: Adequate supervision and timely oversight of grant/contract and program financials did not take place creating certain programs to generate losses for cost that could have been vouchered. Further, there was not adequate communication between finance personnel and programmatic personnel throughout the year. Effect: The lack of supervision and oversight resulted in the need for significant adjustments amongst programs to properly present financial results at the program level. Further, executive management and program management did not have accurate program financial data throughout the year. Recommendation: We recommend the management enhance regular reconciliation and reporting at the program and/or grant/contract level. Further, executive management should work with programmatic personnel to regularly assess the detailed financial results of each program, performing evaluations of the collectability of accounts receivable, budget modifications, and other financial assessments in tandem with programmatic reporting. Views of Responsible Official and Planned Corrective Actions: Executive management will expand regular review of timely monthly financials and will review such details with the finance committee of the board. Executive management will work with the program management team to understand budgeting, review budgets with their program managers on a monthly basis and empower them to complete budget modification timely. Executive management will ensure there is clear supervision and oversight duties and that these duties are adequately segregated.
2022-003 Internal Control Design and Oversight Condition: Two of eight selected payroll charges selected for testing lacked one required signature, either of the employee or a supervisor, on the Personnel Activity Report. In one additional instance, the signatures did not include the required date as evidence of timeliness of preparation or approval. Criteria: Effectively designed and executed controls should be present to ensure proper recordkeeping and reporting. Cause: In certain circumstances, documented processes were not followed. Effect: Payroll and benefits were charged that were not properly reviewed/approved or the approval may not have taken place timely. Recommendation: The auditor recommends that controls be executed to ensure adequate and timely oversight take place. View of Responsible Official: Management agrees and has implemented processes to review Personnel Activity Reports on a timely basis, this process will be reinforced and personnel reminded of the importance of following current procedures.