Audit 319539

FY End
2023-12-31
Total Expended
$8.38M
Findings
60
Programs
3
Organization: Overdose Lifeline, Inc. (IN)
Year: 2023 Accepted: 2024-09-13
Auditor: Pile CPAS

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
496767 2023-001 Material Weakness - L
496768 2023-002 Significant Deficiency Yes L
496769 2023-004 Significant Deficiency - L
496770 2023-003 Significant Deficiency Yes H
496771 2023-005 Material Weakness - B
496772 2023-001 Material Weakness - L
496773 2023-002 Significant Deficiency Yes L
496774 2023-004 Significant Deficiency - L
496775 2023-003 Significant Deficiency Yes H
496776 2023-001 Material Weakness - L
496777 2023-002 Significant Deficiency Yes L
496778 2023-004 Significant Deficiency - L
496779 2023-001 Material Weakness - L
496780 2023-002 Significant Deficiency Yes L
496781 2023-004 Significant Deficiency - L
496782 2023-001 Material Weakness - L
496783 2023-002 Significant Deficiency Yes L
496784 2023-004 Significant Deficiency - L
496785 2023-001 Material Weakness - L
496786 2023-002 Significant Deficiency Yes L
496787 2023-004 Significant Deficiency - L
496788 2023-001 Material Weakness - L
496789 2023-002 Significant Deficiency Yes L
496790 2023-004 Significant Deficiency - L
496791 2023-001 Material Weakness - L
496792 2023-002 Significant Deficiency Yes L
496793 2023-004 Significant Deficiency - L
496794 2023-001 Material Weakness - L
496795 2023-002 Significant Deficiency Yes L
496796 2023-004 Significant Deficiency - L
1073209 2023-001 Material Weakness - L
1073210 2023-002 Significant Deficiency Yes L
1073211 2023-004 Significant Deficiency - L
1073212 2023-003 Significant Deficiency Yes H
1073213 2023-005 Material Weakness - B
1073214 2023-001 Material Weakness - L
1073215 2023-002 Significant Deficiency Yes L
1073216 2023-004 Significant Deficiency - L
1073217 2023-003 Significant Deficiency Yes H
1073218 2023-001 Material Weakness - L
1073219 2023-002 Significant Deficiency Yes L
1073220 2023-004 Significant Deficiency - L
1073221 2023-001 Material Weakness - L
1073222 2023-002 Significant Deficiency Yes L
1073223 2023-004 Significant Deficiency - L
1073224 2023-001 Material Weakness - L
1073225 2023-002 Significant Deficiency Yes L
1073226 2023-004 Significant Deficiency - L
1073227 2023-001 Material Weakness - L
1073228 2023-002 Significant Deficiency Yes L
1073229 2023-004 Significant Deficiency - L
1073230 2023-001 Material Weakness - L
1073231 2023-002 Significant Deficiency Yes L
1073232 2023-004 Significant Deficiency - L
1073233 2023-001 Material Weakness - L
1073234 2023-002 Significant Deficiency Yes L
1073235 2023-004 Significant Deficiency - L
1073236 2023-001 Material Weakness - L
1073237 2023-002 Significant Deficiency Yes L
1073238 2023-004 Significant Deficiency - L

Programs

ALN Program Spent Major Findings
93.137 Community Programs to Improve Minority Health Grant Program $56,493 - 3
93.788 Opioid Str $19,750 Yes 3
21.027 Coronavirus State and Local Fiscal Recovery Funds $18,541 - 3

Contacts

Name Title Type
T1GLAGYX6G71 Justin Phillips Auditee
8445543354 Jeremy Kopeck Auditor
No contacts on file

Notes to SEFA

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. Pass-through entity identifying numbers are presented where available. De Minimis Rate Used: N Rate Explanation: The Organization has elected not to use the 10 percent de minimis indirect cost rate as allowed under the Uniform Guidance.

Finding Details

Finding 2023-001 Accounting for Prepaid Expenses Type of Finding: Material Weakness in Internal Control over Financial Reporting Criteria: According to accounting principles generally accepted in the United States of America ("GAAP"), an organization must have effective internal controls over accounting for prepaid expenses to ensure that transactions are recorded in the correct accounting period. This includes properly accounting for the timing of the receipt of prepaid supplies. Condition: Invoices for prepaid supplies were included in accounts payable for supplies that were not received in the same period. This resulted in an overstatement of expenses related to the prepaid supplies, as the expenses were not properly matched with the periods in which the supplies were actually received and used. Cause: The underlying cause of the condition was a failure to account for the timing of receipt for the supplies. This indicates a deficiency in the internal controls and procedures related to the recording of prepaid expenses. Possible or Known Effect: The effect of this condition was an overstatement of expenses, which could potentially mislead financial statement users and impact decision-making. This could also lead to inaccurate financial reporting and potential non-compliance with federal grant requirements. Questioned Costs: There are no specific questioned costs identified in this finding as the overstatement impacts the accuracy of financial reporting rather than a direct disallowed cost. However, the overstatement of expenses may affect the accuracy of financial statements and compliance with grant terms. Repeat Finding: This finding is not a repeat finding from the prior year. Recommendation: It is recommended that the organization implement a corrective action plan to address the internal control deficiencies identified. This plan should focus on revising procedures to ensure that prepaid supplies are accurately recorded in the period in which they are received. Additionally, enhancing training for staff involved in accounting for prepaid expenses will help ensure proper understanding and execution of these procedures. Regular reviews and reconciliations of accounts payable and prepaid supplies records should be conducted to prevent similar issues in the future. Finally, performing periodic audits of internal controls will help ensure ongoing compliance with accounting standards and grant requirements. Views of Responsible Officials: The Organizations’ Board and Executive Team consisting of the Chief Executive Officer (CEO) and the Chief Operating Officer (COO) and key Overdose Lifeline (ODL) Staff to include the independent bookkeeper and Grant and Finance Manager recognize the internal control deficiencies identified during the year 2023. As noted by the Independent Public Accounting Firm (Pile CPAs) significant improvements have occurred and in the first half of 2024 ODL implemented a new inventory accounting process through QuickBooks. This finding is addressed through this new accounting process. Overdose Lifeline moved from tracking inventory manually in excel spreadsheets to utilizing inventory management in Quickbooks Online (QBO). The process is: - Receipts: Once inventory is physically received, a QBO bill is entered identifying the quantity and cost of the items. - Shipments: Shipments are reflected on a weekly basis identifying the items and quantity shipped per item on a zero-dollar invoice. QBO utilizes FIFO (First In/First Out) methodology for inventory valuation. The physical inventory is reconciled to the QBO inventory counts monthly. Additionally the Grants and Finance Manager, Executive Team and other key personnel will conduct periodic audits of internal controls.
Finding 2023-002 Schedule of Expenditures of Federal Awards Preparation Type of Finding: Significant Deficiency over Financial Reporting. Criteria: Federal regulations and GAAP require the preparation of a comprehensive and accurate Schedule of Expenditures of Federal Awards ("SEFA"), which includes transparent disclosure of federal funds expended, including the source of funds, program titles, award numbers, and expenditure amounts. Condition: This year’s audit revealed significant improvements in the Organization’s SEFA preparation. The SEFA now more accurately reflects federal awards received and expended, and there have been enhancements in documenting award numbers, funding sources, and program titles. However, some inaccuracies and omissions persist, impacting the completeness and reliability of the SEFA. Cause: Ongoing gaps in the skills, knowledge, and experience of personnel responsible for SEFA preparation and reporting contribute to the persistence of some inaccuracies. Continued deficiencies in training and procedural adherence are factors in these issues. Possible or Known Effect: While improvements have mitigated the risk of misrepresentation, the remaining discrepancies could still lead to misinterpretation of federal funds received and expended. This could affect the Organization’s compliance with federal reporting requirements and potentially impact eligibility for future federal funding. Questioned Costs: There were no questioned costs identified. Repeat Finding: This finding is a repeat from the prior year. The previous finding number was 2022-002. Recommendation: Management should continue to build on recent improvements by further refining SEFA preparation processes. Enhanced controls should be implemented to ensure complete and accurate recording of federal awards and expenditures. Ongoing training for financial reporting personnel should be sustained, addressing remaining knowledge gaps and procedural issues. Documented procedures should be reviewed and updated regularly to ensure adherence to best practices and continuous improvement in SEFA preparation. Views of Responsible Officials: The Organizations’ Board and Executive Team consisting of the Chief Executive Officer (CEO) and the Chief Operating Officer (COO) and key Overdose Lifeline (ODL) Staff to include the independent bookkeeper and Grant and Finance Manager recognize the need to further refine the SEFA preparation process. This will be accomplished through the completion of a formal course that covers performing a single audit and consultation with the Independent Public Accounting Firm (Pile CPAs).
Finding 2023-004 Accounting for Revenues and Accrued Receivables Type of Finding: Significant Deficiency in Internal Control over Financial Reporting Criteria: According to Generally Accepted Accounting Principles (GAAP), revenues must be recorded in the period in which they are earned, even if the claims or payments are received in a subsequent period. Condition: Revenues earned during the fiscal year but claimed in the following fiscal year were inconsistently accrued as receivables. Specifically, revenues related to reimbursement-based grants were not recognized, despite expenses being recorded, and revenues were excluded even though costs of goods sold were included. Cause: The deficiency stemmed from inadequate internal controls and procedures for accruing revenues and receivables, reflecting a failure to adhere to proper revenue recognition practices. Possible or Known Effect: While the adjustments required were not material, they were significant and warrant the attention of those charged with governance. Improper accrual of revenues could mislead financial statement users and impact financial decision-making. Questioned Costs: There are no specific questioned costs identified in this finding. The issue pertains to revenue recognition practices rather than direct disallowed costs. Repeat Finding: This finding is not a repeat finding from the prior year. Recommendation: It is recommended that the organization improve its internal controls and procedures for accruing revenues. This should involve refining procedures for recognizing revenues from reimbursement-based grants and sales of supplies, enhancing staff training on GAAP revenue recognition, and regularly reviewing and reconciling accrued revenues and receivables to ensure they are recorded in the correct period. Significant discrepancies should be reviewed by those charged with governance to ensure timely resolution. Views of Responsible Officials: The Organizations’ Board and Executive Team consisting of the Chief Executive Officer (CEO) and the Chief Operating Officer (COO) and key Overdose Lifeline (ODL) Staff to include the independent bookkeeper and Grant and Finance Manager recognize the need to further refine the internal controls and procedures for accruing revenues. This will be accomplished through the completion of a formal course that covers performing a single audit and consultation with the Independent Public Accounting Firm (Pile CPAs) Additionally staff will regularly meet with the independent bookkeeper to review and reconcile accrued revenues ands receivables.
Finding 2023-003 Expenditure of Funds Outside Contract Period Type of Finding: Noncompliance and Significant Deficiency in Internal Control over Compliance. Criteria: Federal regulations and grant guidelines require expenditures to align with the grant’s period of performance. Organizations must obtain prior authorization from the pass-through entity for any expenditures claimed against the grant before the official grant start date. Proper internal controls should include mechanisms to ensure compliance with grant periods and approval processes for any deviations. Condition: Testing revealed that the Organization claimed expenditures against the grant that occurred before the official grant period. Although these expenditures were made outside the period of performance, they were submitted for reimbursement without securing prior authorization from the pass-through entity. Cause: The Organization's internal controls for managing grant expenditures did not sufficiently address the need for pre-authorization of expenditures incurred before the grant period. Additionally, there was a lack of effective monitoring to ensure compliance with grant start dates and required approvals. Possible or Known Effect: Claiming expenditures prior to the grant period without prior authorization could result in improper use of grant funds. This practice may impact the organization’s ability to meet grant objectives and cause misalignment between actual expenditures and grant reporting. Questioned Costs: Known questioned costs total $6,286. Repeat Finding: This finding is a repeat from the prior year. The previous finding number was 2022-003. Recommendation: We recommend that the Organization enhance its internal controls to ensure compliance with grant periods by implementing a process to obtain prior authorization from the pass-through entity for any expenditures made before the official grant start date. Additionally, the Organization should strengthen monitoring mechanisms to prevent similar issues in the future. Views of Responsible Officials: The Organizations’ Board and Executive Team consisting of the Chief Executive Officer (CEO) and the Chief Operating Officer (COO) and key Overdose Lifeline (ODL) Staff to include the independent bookkeeper and Grant and Finance Manager recognize the need to enhance internal controls and mechanisms to ensure purchase do not occur outside grant periods.
Finding 2023-005 Misallocation of Grant Funds Type of Finding: Noncompliance and Material Weakness in Internal Control over Compliance. Criteria: The Uniform Guidance establishes criteria for allowable costs and the proper use of federal funds. According to Uniform Guidance, costs must be necessary and reasonable for the performance of the federal award and allocated correctly. Additionally, costs must be charged to the federal award based on the benefits received. Condition: The Organization claimed purchases under a reimbursement-based federal grant but then used these supplies for a different grant. This improper use of grant-funded supplies is a violation of the grant’s terms and conditions. Cause: The root cause of the noncompliance is the Organization’s failure to implement effective internal controls to ensure proper communication between departments. While the Organization was aware of the grant terms prohibiting such actions, the lack of controls and processes to coordinate the use of grant-funded supplies resulted in their misallocation. Possible or Known Effect: The misuse of resources risks undermining the programmatic impact intended by the grant. By not using the supplies as specified in the grant agreement, the Organization may fail to achieve the grant’s objectives and intended outcomes, ultimately diminishing the effectiveness of the funded program. Questioned Costs: The total questioned costs amount to $85,178, reflecting the value of supplies used improperly. Repeat Finding: This finding is not a repeat finding from the prior year. Recommendation: To address the identified issue, it is crucial the Organization implement and enhance internal controls and communication processes between departments to ensure compliance with grant requirements. The Organization should implement enhancements in the tracking of supplies by grant. Additionally, the Organization should establish effective oversight mechanisms and provide training to staff on proper grant management practices. A review and revision of grant management policies are necessary to prevent similar issues in the future. Views of Responsible Officials: The Organizations’ Board and Executive Team consisting of the Chief Executive Officer (CEO) and the Chief Operating Officer (COO) and key Overdose Lifeline (ODL) Staff to include the independent bookkeeper and Grant and Finance Manager recognize the need to further significantly improve on the oversight and reconciliation of supply ordering and inventory. This is already underway with the QB inventory process described previously and an improved process for backup documentation. Additionally key staff will complete of a formal course that covers performing a single audit and engage in consultation with the Independent Public Accounting Firm (Pile CPAs).
Finding 2023-001 Accounting for Prepaid Expenses Type of Finding: Material Weakness in Internal Control over Financial Reporting Criteria: According to accounting principles generally accepted in the United States of America ("GAAP"), an organization must have effective internal controls over accounting for prepaid expenses to ensure that transactions are recorded in the correct accounting period. This includes properly accounting for the timing of the receipt of prepaid supplies. Condition: Invoices for prepaid supplies were included in accounts payable for supplies that were not received in the same period. This resulted in an overstatement of expenses related to the prepaid supplies, as the expenses were not properly matched with the periods in which the supplies were actually received and used. Cause: The underlying cause of the condition was a failure to account for the timing of receipt for the supplies. This indicates a deficiency in the internal controls and procedures related to the recording of prepaid expenses. Possible or Known Effect: The effect of this condition was an overstatement of expenses, which could potentially mislead financial statement users and impact decision-making. This could also lead to inaccurate financial reporting and potential non-compliance with federal grant requirements. Questioned Costs: There are no specific questioned costs identified in this finding as the overstatement impacts the accuracy of financial reporting rather than a direct disallowed cost. However, the overstatement of expenses may affect the accuracy of financial statements and compliance with grant terms. Repeat Finding: This finding is not a repeat finding from the prior year. Recommendation: It is recommended that the organization implement a corrective action plan to address the internal control deficiencies identified. This plan should focus on revising procedures to ensure that prepaid supplies are accurately recorded in the period in which they are received. Additionally, enhancing training for staff involved in accounting for prepaid expenses will help ensure proper understanding and execution of these procedures. Regular reviews and reconciliations of accounts payable and prepaid supplies records should be conducted to prevent similar issues in the future. Finally, performing periodic audits of internal controls will help ensure ongoing compliance with accounting standards and grant requirements. Views of Responsible Officials: The Organizations’ Board and Executive Team consisting of the Chief Executive Officer (CEO) and the Chief Operating Officer (COO) and key Overdose Lifeline (ODL) Staff to include the independent bookkeeper and Grant and Finance Manager recognize the internal control deficiencies identified during the year 2023. As noted by the Independent Public Accounting Firm (Pile CPAs) significant improvements have occurred and in the first half of 2024 ODL implemented a new inventory accounting process through QuickBooks. This finding is addressed through this new accounting process. Overdose Lifeline moved from tracking inventory manually in excel spreadsheets to utilizing inventory management in Quickbooks Online (QBO). The process is: - Receipts: Once inventory is physically received, a QBO bill is entered identifying the quantity and cost of the items. - Shipments: Shipments are reflected on a weekly basis identifying the items and quantity shipped per item on a zero-dollar invoice. QBO utilizes FIFO (First In/First Out) methodology for inventory valuation. The physical inventory is reconciled to the QBO inventory counts monthly. Additionally the Grants and Finance Manager, Executive Team and other key personnel will conduct periodic audits of internal controls.
Finding 2023-002 Schedule of Expenditures of Federal Awards Preparation Type of Finding: Significant Deficiency over Financial Reporting. Criteria: Federal regulations and GAAP require the preparation of a comprehensive and accurate Schedule of Expenditures of Federal Awards ("SEFA"), which includes transparent disclosure of federal funds expended, including the source of funds, program titles, award numbers, and expenditure amounts. Condition: This year’s audit revealed significant improvements in the Organization’s SEFA preparation. The SEFA now more accurately reflects federal awards received and expended, and there have been enhancements in documenting award numbers, funding sources, and program titles. However, some inaccuracies and omissions persist, impacting the completeness and reliability of the SEFA. Cause: Ongoing gaps in the skills, knowledge, and experience of personnel responsible for SEFA preparation and reporting contribute to the persistence of some inaccuracies. Continued deficiencies in training and procedural adherence are factors in these issues. Possible or Known Effect: While improvements have mitigated the risk of misrepresentation, the remaining discrepancies could still lead to misinterpretation of federal funds received and expended. This could affect the Organization’s compliance with federal reporting requirements and potentially impact eligibility for future federal funding. Questioned Costs: There were no questioned costs identified. Repeat Finding: This finding is a repeat from the prior year. The previous finding number was 2022-002. Recommendation: Management should continue to build on recent improvements by further refining SEFA preparation processes. Enhanced controls should be implemented to ensure complete and accurate recording of federal awards and expenditures. Ongoing training for financial reporting personnel should be sustained, addressing remaining knowledge gaps and procedural issues. Documented procedures should be reviewed and updated regularly to ensure adherence to best practices and continuous improvement in SEFA preparation. Views of Responsible Officials: The Organizations’ Board and Executive Team consisting of the Chief Executive Officer (CEO) and the Chief Operating Officer (COO) and key Overdose Lifeline (ODL) Staff to include the independent bookkeeper and Grant and Finance Manager recognize the need to further refine the SEFA preparation process. This will be accomplished through the completion of a formal course that covers performing a single audit and consultation with the Independent Public Accounting Firm (Pile CPAs).
Finding 2023-004 Accounting for Revenues and Accrued Receivables Type of Finding: Significant Deficiency in Internal Control over Financial Reporting Criteria: According to Generally Accepted Accounting Principles (GAAP), revenues must be recorded in the period in which they are earned, even if the claims or payments are received in a subsequent period. Condition: Revenues earned during the fiscal year but claimed in the following fiscal year were inconsistently accrued as receivables. Specifically, revenues related to reimbursement-based grants were not recognized, despite expenses being recorded, and revenues were excluded even though costs of goods sold were included. Cause: The deficiency stemmed from inadequate internal controls and procedures for accruing revenues and receivables, reflecting a failure to adhere to proper revenue recognition practices. Possible or Known Effect: While the adjustments required were not material, they were significant and warrant the attention of those charged with governance. Improper accrual of revenues could mislead financial statement users and impact financial decision-making. Questioned Costs: There are no specific questioned costs identified in this finding. The issue pertains to revenue recognition practices rather than direct disallowed costs. Repeat Finding: This finding is not a repeat finding from the prior year. Recommendation: It is recommended that the organization improve its internal controls and procedures for accruing revenues. This should involve refining procedures for recognizing revenues from reimbursement-based grants and sales of supplies, enhancing staff training on GAAP revenue recognition, and regularly reviewing and reconciling accrued revenues and receivables to ensure they are recorded in the correct period. Significant discrepancies should be reviewed by those charged with governance to ensure timely resolution. Views of Responsible Officials: The Organizations’ Board and Executive Team consisting of the Chief Executive Officer (CEO) and the Chief Operating Officer (COO) and key Overdose Lifeline (ODL) Staff to include the independent bookkeeper and Grant and Finance Manager recognize the need to further refine the internal controls and procedures for accruing revenues. This will be accomplished through the completion of a formal course that covers performing a single audit and consultation with the Independent Public Accounting Firm (Pile CPAs) Additionally staff will regularly meet with the independent bookkeeper to review and reconcile accrued revenues ands receivables.
Finding 2023-003 Expenditure of Funds Outside Contract Period Type of Finding: Noncompliance and Significant Deficiency in Internal Control over Compliance. Criteria: Federal regulations and grant guidelines require expenditures to align with the grant’s period of performance. Organizations must obtain prior authorization from the pass-through entity for any expenditures claimed against the grant before the official grant start date. Proper internal controls should include mechanisms to ensure compliance with grant periods and approval processes for any deviations. Condition: Testing revealed that the Organization claimed expenditures against the grant that occurred before the official grant period. Although these expenditures were made outside the period of performance, they were submitted for reimbursement without securing prior authorization from the pass-through entity. Cause: The Organization's internal controls for managing grant expenditures did not sufficiently address the need for pre-authorization of expenditures incurred before the grant period. Additionally, there was a lack of effective monitoring to ensure compliance with grant start dates and required approvals. Possible or Known Effect: Claiming expenditures prior to the grant period without prior authorization could result in improper use of grant funds. This practice may impact the organization’s ability to meet grant objectives and cause misalignment between actual expenditures and grant reporting. Questioned Costs: Known questioned costs total $6,286. Repeat Finding: This finding is a repeat from the prior year. The previous finding number was 2022-003. Recommendation: We recommend that the Organization enhance its internal controls to ensure compliance with grant periods by implementing a process to obtain prior authorization from the pass-through entity for any expenditures made before the official grant start date. Additionally, the Organization should strengthen monitoring mechanisms to prevent similar issues in the future. Views of Responsible Officials: The Organizations’ Board and Executive Team consisting of the Chief Executive Officer (CEO) and the Chief Operating Officer (COO) and key Overdose Lifeline (ODL) Staff to include the independent bookkeeper and Grant and Finance Manager recognize the need to enhance internal controls and mechanisms to ensure purchase do not occur outside grant periods.
Finding 2023-001 Accounting for Prepaid Expenses Type of Finding: Material Weakness in Internal Control over Financial Reporting Criteria: According to accounting principles generally accepted in the United States of America ("GAAP"), an organization must have effective internal controls over accounting for prepaid expenses to ensure that transactions are recorded in the correct accounting period. This includes properly accounting for the timing of the receipt of prepaid supplies. Condition: Invoices for prepaid supplies were included in accounts payable for supplies that were not received in the same period. This resulted in an overstatement of expenses related to the prepaid supplies, as the expenses were not properly matched with the periods in which the supplies were actually received and used. Cause: The underlying cause of the condition was a failure to account for the timing of receipt for the supplies. This indicates a deficiency in the internal controls and procedures related to the recording of prepaid expenses. Possible or Known Effect: The effect of this condition was an overstatement of expenses, which could potentially mislead financial statement users and impact decision-making. This could also lead to inaccurate financial reporting and potential non-compliance with federal grant requirements. Questioned Costs: There are no specific questioned costs identified in this finding as the overstatement impacts the accuracy of financial reporting rather than a direct disallowed cost. However, the overstatement of expenses may affect the accuracy of financial statements and compliance with grant terms. Repeat Finding: This finding is not a repeat finding from the prior year. Recommendation: It is recommended that the organization implement a corrective action plan to address the internal control deficiencies identified. This plan should focus on revising procedures to ensure that prepaid supplies are accurately recorded in the period in which they are received. Additionally, enhancing training for staff involved in accounting for prepaid expenses will help ensure proper understanding and execution of these procedures. Regular reviews and reconciliations of accounts payable and prepaid supplies records should be conducted to prevent similar issues in the future. Finally, performing periodic audits of internal controls will help ensure ongoing compliance with accounting standards and grant requirements. Views of Responsible Officials: The Organizations’ Board and Executive Team consisting of the Chief Executive Officer (CEO) and the Chief Operating Officer (COO) and key Overdose Lifeline (ODL) Staff to include the independent bookkeeper and Grant and Finance Manager recognize the internal control deficiencies identified during the year 2023. As noted by the Independent Public Accounting Firm (Pile CPAs) significant improvements have occurred and in the first half of 2024 ODL implemented a new inventory accounting process through QuickBooks. This finding is addressed through this new accounting process. Overdose Lifeline moved from tracking inventory manually in excel spreadsheets to utilizing inventory management in Quickbooks Online (QBO). The process is: - Receipts: Once inventory is physically received, a QBO bill is entered identifying the quantity and cost of the items. - Shipments: Shipments are reflected on a weekly basis identifying the items and quantity shipped per item on a zero-dollar invoice. QBO utilizes FIFO (First In/First Out) methodology for inventory valuation. The physical inventory is reconciled to the QBO inventory counts monthly. Additionally the Grants and Finance Manager, Executive Team and other key personnel will conduct periodic audits of internal controls.
Finding 2023-002 Schedule of Expenditures of Federal Awards Preparation Type of Finding: Significant Deficiency over Financial Reporting. Criteria: Federal regulations and GAAP require the preparation of a comprehensive and accurate Schedule of Expenditures of Federal Awards ("SEFA"), which includes transparent disclosure of federal funds expended, including the source of funds, program titles, award numbers, and expenditure amounts. Condition: This year’s audit revealed significant improvements in the Organization’s SEFA preparation. The SEFA now more accurately reflects federal awards received and expended, and there have been enhancements in documenting award numbers, funding sources, and program titles. However, some inaccuracies and omissions persist, impacting the completeness and reliability of the SEFA. Cause: Ongoing gaps in the skills, knowledge, and experience of personnel responsible for SEFA preparation and reporting contribute to the persistence of some inaccuracies. Continued deficiencies in training and procedural adherence are factors in these issues. Possible or Known Effect: While improvements have mitigated the risk of misrepresentation, the remaining discrepancies could still lead to misinterpretation of federal funds received and expended. This could affect the Organization’s compliance with federal reporting requirements and potentially impact eligibility for future federal funding. Questioned Costs: There were no questioned costs identified. Repeat Finding: This finding is a repeat from the prior year. The previous finding number was 2022-002. Recommendation: Management should continue to build on recent improvements by further refining SEFA preparation processes. Enhanced controls should be implemented to ensure complete and accurate recording of federal awards and expenditures. Ongoing training for financial reporting personnel should be sustained, addressing remaining knowledge gaps and procedural issues. Documented procedures should be reviewed and updated regularly to ensure adherence to best practices and continuous improvement in SEFA preparation. Views of Responsible Officials: The Organizations’ Board and Executive Team consisting of the Chief Executive Officer (CEO) and the Chief Operating Officer (COO) and key Overdose Lifeline (ODL) Staff to include the independent bookkeeper and Grant and Finance Manager recognize the need to further refine the SEFA preparation process. This will be accomplished through the completion of a formal course that covers performing a single audit and consultation with the Independent Public Accounting Firm (Pile CPAs).
Finding 2023-004 Accounting for Revenues and Accrued Receivables Type of Finding: Significant Deficiency in Internal Control over Financial Reporting Criteria: According to Generally Accepted Accounting Principles (GAAP), revenues must be recorded in the period in which they are earned, even if the claims or payments are received in a subsequent period. Condition: Revenues earned during the fiscal year but claimed in the following fiscal year were inconsistently accrued as receivables. Specifically, revenues related to reimbursement-based grants were not recognized, despite expenses being recorded, and revenues were excluded even though costs of goods sold were included. Cause: The deficiency stemmed from inadequate internal controls and procedures for accruing revenues and receivables, reflecting a failure to adhere to proper revenue recognition practices. Possible or Known Effect: While the adjustments required were not material, they were significant and warrant the attention of those charged with governance. Improper accrual of revenues could mislead financial statement users and impact financial decision-making. Questioned Costs: There are no specific questioned costs identified in this finding. The issue pertains to revenue recognition practices rather than direct disallowed costs. Repeat Finding: This finding is not a repeat finding from the prior year. Recommendation: It is recommended that the organization improve its internal controls and procedures for accruing revenues. This should involve refining procedures for recognizing revenues from reimbursement-based grants and sales of supplies, enhancing staff training on GAAP revenue recognition, and regularly reviewing and reconciling accrued revenues and receivables to ensure they are recorded in the correct period. Significant discrepancies should be reviewed by those charged with governance to ensure timely resolution. Views of Responsible Officials: The Organizations’ Board and Executive Team consisting of the Chief Executive Officer (CEO) and the Chief Operating Officer (COO) and key Overdose Lifeline (ODL) Staff to include the independent bookkeeper and Grant and Finance Manager recognize the need to further refine the internal controls and procedures for accruing revenues. This will be accomplished through the completion of a formal course that covers performing a single audit and consultation with the Independent Public Accounting Firm (Pile CPAs) Additionally staff will regularly meet with the independent bookkeeper to review and reconcile accrued revenues ands receivables.
Finding 2023-001 Accounting for Prepaid Expenses Type of Finding: Material Weakness in Internal Control over Financial Reporting Criteria: According to accounting principles generally accepted in the United States of America ("GAAP"), an organization must have effective internal controls over accounting for prepaid expenses to ensure that transactions are recorded in the correct accounting period. This includes properly accounting for the timing of the receipt of prepaid supplies. Condition: Invoices for prepaid supplies were included in accounts payable for supplies that were not received in the same period. This resulted in an overstatement of expenses related to the prepaid supplies, as the expenses were not properly matched with the periods in which the supplies were actually received and used. Cause: The underlying cause of the condition was a failure to account for the timing of receipt for the supplies. This indicates a deficiency in the internal controls and procedures related to the recording of prepaid expenses. Possible or Known Effect: The effect of this condition was an overstatement of expenses, which could potentially mislead financial statement users and impact decision-making. This could also lead to inaccurate financial reporting and potential non-compliance with federal grant requirements. Questioned Costs: There are no specific questioned costs identified in this finding as the overstatement impacts the accuracy of financial reporting rather than a direct disallowed cost. However, the overstatement of expenses may affect the accuracy of financial statements and compliance with grant terms. Repeat Finding: This finding is not a repeat finding from the prior year. Recommendation: It is recommended that the organization implement a corrective action plan to address the internal control deficiencies identified. This plan should focus on revising procedures to ensure that prepaid supplies are accurately recorded in the period in which they are received. Additionally, enhancing training for staff involved in accounting for prepaid expenses will help ensure proper understanding and execution of these procedures. Regular reviews and reconciliations of accounts payable and prepaid supplies records should be conducted to prevent similar issues in the future. Finally, performing periodic audits of internal controls will help ensure ongoing compliance with accounting standards and grant requirements. Views of Responsible Officials: The Organizations’ Board and Executive Team consisting of the Chief Executive Officer (CEO) and the Chief Operating Officer (COO) and key Overdose Lifeline (ODL) Staff to include the independent bookkeeper and Grant and Finance Manager recognize the internal control deficiencies identified during the year 2023. As noted by the Independent Public Accounting Firm (Pile CPAs) significant improvements have occurred and in the first half of 2024 ODL implemented a new inventory accounting process through QuickBooks. This finding is addressed through this new accounting process. Overdose Lifeline moved from tracking inventory manually in excel spreadsheets to utilizing inventory management in Quickbooks Online (QBO). The process is: - Receipts: Once inventory is physically received, a QBO bill is entered identifying the quantity and cost of the items. - Shipments: Shipments are reflected on a weekly basis identifying the items and quantity shipped per item on a zero-dollar invoice. QBO utilizes FIFO (First In/First Out) methodology for inventory valuation. The physical inventory is reconciled to the QBO inventory counts monthly. Additionally the Grants and Finance Manager, Executive Team and other key personnel will conduct periodic audits of internal controls.
Finding 2023-002 Schedule of Expenditures of Federal Awards Preparation Type of Finding: Significant Deficiency over Financial Reporting. Criteria: Federal regulations and GAAP require the preparation of a comprehensive and accurate Schedule of Expenditures of Federal Awards ("SEFA"), which includes transparent disclosure of federal funds expended, including the source of funds, program titles, award numbers, and expenditure amounts. Condition: This year’s audit revealed significant improvements in the Organization’s SEFA preparation. The SEFA now more accurately reflects federal awards received and expended, and there have been enhancements in documenting award numbers, funding sources, and program titles. However, some inaccuracies and omissions persist, impacting the completeness and reliability of the SEFA. Cause: Ongoing gaps in the skills, knowledge, and experience of personnel responsible for SEFA preparation and reporting contribute to the persistence of some inaccuracies. Continued deficiencies in training and procedural adherence are factors in these issues. Possible or Known Effect: While improvements have mitigated the risk of misrepresentation, the remaining discrepancies could still lead to misinterpretation of federal funds received and expended. This could affect the Organization’s compliance with federal reporting requirements and potentially impact eligibility for future federal funding. Questioned Costs: There were no questioned costs identified. Repeat Finding: This finding is a repeat from the prior year. The previous finding number was 2022-002. Recommendation: Management should continue to build on recent improvements by further refining SEFA preparation processes. Enhanced controls should be implemented to ensure complete and accurate recording of federal awards and expenditures. Ongoing training for financial reporting personnel should be sustained, addressing remaining knowledge gaps and procedural issues. Documented procedures should be reviewed and updated regularly to ensure adherence to best practices and continuous improvement in SEFA preparation. Views of Responsible Officials: The Organizations’ Board and Executive Team consisting of the Chief Executive Officer (CEO) and the Chief Operating Officer (COO) and key Overdose Lifeline (ODL) Staff to include the independent bookkeeper and Grant and Finance Manager recognize the need to further refine the SEFA preparation process. This will be accomplished through the completion of a formal course that covers performing a single audit and consultation with the Independent Public Accounting Firm (Pile CPAs).
Finding 2023-004 Accounting for Revenues and Accrued Receivables Type of Finding: Significant Deficiency in Internal Control over Financial Reporting Criteria: According to Generally Accepted Accounting Principles (GAAP), revenues must be recorded in the period in which they are earned, even if the claims or payments are received in a subsequent period. Condition: Revenues earned during the fiscal year but claimed in the following fiscal year were inconsistently accrued as receivables. Specifically, revenues related to reimbursement-based grants were not recognized, despite expenses being recorded, and revenues were excluded even though costs of goods sold were included. Cause: The deficiency stemmed from inadequate internal controls and procedures for accruing revenues and receivables, reflecting a failure to adhere to proper revenue recognition practices. Possible or Known Effect: While the adjustments required were not material, they were significant and warrant the attention of those charged with governance. Improper accrual of revenues could mislead financial statement users and impact financial decision-making. Questioned Costs: There are no specific questioned costs identified in this finding. The issue pertains to revenue recognition practices rather than direct disallowed costs. Repeat Finding: This finding is not a repeat finding from the prior year. Recommendation: It is recommended that the organization improve its internal controls and procedures for accruing revenues. This should involve refining procedures for recognizing revenues from reimbursement-based grants and sales of supplies, enhancing staff training on GAAP revenue recognition, and regularly reviewing and reconciling accrued revenues and receivables to ensure they are recorded in the correct period. Significant discrepancies should be reviewed by those charged with governance to ensure timely resolution. Views of Responsible Officials: The Organizations’ Board and Executive Team consisting of the Chief Executive Officer (CEO) and the Chief Operating Officer (COO) and key Overdose Lifeline (ODL) Staff to include the independent bookkeeper and Grant and Finance Manager recognize the need to further refine the internal controls and procedures for accruing revenues. This will be accomplished through the completion of a formal course that covers performing a single audit and consultation with the Independent Public Accounting Firm (Pile CPAs) Additionally staff will regularly meet with the independent bookkeeper to review and reconcile accrued revenues ands receivables.
Finding 2023-001 Accounting for Prepaid Expenses Type of Finding: Material Weakness in Internal Control over Financial Reporting Criteria: According to accounting principles generally accepted in the United States of America ("GAAP"), an organization must have effective internal controls over accounting for prepaid expenses to ensure that transactions are recorded in the correct accounting period. This includes properly accounting for the timing of the receipt of prepaid supplies. Condition: Invoices for prepaid supplies were included in accounts payable for supplies that were not received in the same period. This resulted in an overstatement of expenses related to the prepaid supplies, as the expenses were not properly matched with the periods in which the supplies were actually received and used. Cause: The underlying cause of the condition was a failure to account for the timing of receipt for the supplies. This indicates a deficiency in the internal controls and procedures related to the recording of prepaid expenses. Possible or Known Effect: The effect of this condition was an overstatement of expenses, which could potentially mislead financial statement users and impact decision-making. This could also lead to inaccurate financial reporting and potential non-compliance with federal grant requirements. Questioned Costs: There are no specific questioned costs identified in this finding as the overstatement impacts the accuracy of financial reporting rather than a direct disallowed cost. However, the overstatement of expenses may affect the accuracy of financial statements and compliance with grant terms. Repeat Finding: This finding is not a repeat finding from the prior year. Recommendation: It is recommended that the organization implement a corrective action plan to address the internal control deficiencies identified. This plan should focus on revising procedures to ensure that prepaid supplies are accurately recorded in the period in which they are received. Additionally, enhancing training for staff involved in accounting for prepaid expenses will help ensure proper understanding and execution of these procedures. Regular reviews and reconciliations of accounts payable and prepaid supplies records should be conducted to prevent similar issues in the future. Finally, performing periodic audits of internal controls will help ensure ongoing compliance with accounting standards and grant requirements. Views of Responsible Officials: The Organizations’ Board and Executive Team consisting of the Chief Executive Officer (CEO) and the Chief Operating Officer (COO) and key Overdose Lifeline (ODL) Staff to include the independent bookkeeper and Grant and Finance Manager recognize the internal control deficiencies identified during the year 2023. As noted by the Independent Public Accounting Firm (Pile CPAs) significant improvements have occurred and in the first half of 2024 ODL implemented a new inventory accounting process through QuickBooks. This finding is addressed through this new accounting process. Overdose Lifeline moved from tracking inventory manually in excel spreadsheets to utilizing inventory management in Quickbooks Online (QBO). The process is: - Receipts: Once inventory is physically received, a QBO bill is entered identifying the quantity and cost of the items. - Shipments: Shipments are reflected on a weekly basis identifying the items and quantity shipped per item on a zero-dollar invoice. QBO utilizes FIFO (First In/First Out) methodology for inventory valuation. The physical inventory is reconciled to the QBO inventory counts monthly. Additionally the Grants and Finance Manager, Executive Team and other key personnel will conduct periodic audits of internal controls.
Finding 2023-002 Schedule of Expenditures of Federal Awards Preparation Type of Finding: Significant Deficiency over Financial Reporting. Criteria: Federal regulations and GAAP require the preparation of a comprehensive and accurate Schedule of Expenditures of Federal Awards ("SEFA"), which includes transparent disclosure of federal funds expended, including the source of funds, program titles, award numbers, and expenditure amounts. Condition: This year’s audit revealed significant improvements in the Organization’s SEFA preparation. The SEFA now more accurately reflects federal awards received and expended, and there have been enhancements in documenting award numbers, funding sources, and program titles. However, some inaccuracies and omissions persist, impacting the completeness and reliability of the SEFA. Cause: Ongoing gaps in the skills, knowledge, and experience of personnel responsible for SEFA preparation and reporting contribute to the persistence of some inaccuracies. Continued deficiencies in training and procedural adherence are factors in these issues. Possible or Known Effect: While improvements have mitigated the risk of misrepresentation, the remaining discrepancies could still lead to misinterpretation of federal funds received and expended. This could affect the Organization’s compliance with federal reporting requirements and potentially impact eligibility for future federal funding. Questioned Costs: There were no questioned costs identified. Repeat Finding: This finding is a repeat from the prior year. The previous finding number was 2022-002. Recommendation: Management should continue to build on recent improvements by further refining SEFA preparation processes. Enhanced controls should be implemented to ensure complete and accurate recording of federal awards and expenditures. Ongoing training for financial reporting personnel should be sustained, addressing remaining knowledge gaps and procedural issues. Documented procedures should be reviewed and updated regularly to ensure adherence to best practices and continuous improvement in SEFA preparation. Views of Responsible Officials: The Organizations’ Board and Executive Team consisting of the Chief Executive Officer (CEO) and the Chief Operating Officer (COO) and key Overdose Lifeline (ODL) Staff to include the independent bookkeeper and Grant and Finance Manager recognize the need to further refine the SEFA preparation process. This will be accomplished through the completion of a formal course that covers performing a single audit and consultation with the Independent Public Accounting Firm (Pile CPAs).
Finding 2023-004 Accounting for Revenues and Accrued Receivables Type of Finding: Significant Deficiency in Internal Control over Financial Reporting Criteria: According to Generally Accepted Accounting Principles (GAAP), revenues must be recorded in the period in which they are earned, even if the claims or payments are received in a subsequent period. Condition: Revenues earned during the fiscal year but claimed in the following fiscal year were inconsistently accrued as receivables. Specifically, revenues related to reimbursement-based grants were not recognized, despite expenses being recorded, and revenues were excluded even though costs of goods sold were included. Cause: The deficiency stemmed from inadequate internal controls and procedures for accruing revenues and receivables, reflecting a failure to adhere to proper revenue recognition practices. Possible or Known Effect: While the adjustments required were not material, they were significant and warrant the attention of those charged with governance. Improper accrual of revenues could mislead financial statement users and impact financial decision-making. Questioned Costs: There are no specific questioned costs identified in this finding. The issue pertains to revenue recognition practices rather than direct disallowed costs. Repeat Finding: This finding is not a repeat finding from the prior year. Recommendation: It is recommended that the organization improve its internal controls and procedures for accruing revenues. This should involve refining procedures for recognizing revenues from reimbursement-based grants and sales of supplies, enhancing staff training on GAAP revenue recognition, and regularly reviewing and reconciling accrued revenues and receivables to ensure they are recorded in the correct period. Significant discrepancies should be reviewed by those charged with governance to ensure timely resolution. Views of Responsible Officials: The Organizations’ Board and Executive Team consisting of the Chief Executive Officer (CEO) and the Chief Operating Officer (COO) and key Overdose Lifeline (ODL) Staff to include the independent bookkeeper and Grant and Finance Manager recognize the need to further refine the internal controls and procedures for accruing revenues. This will be accomplished through the completion of a formal course that covers performing a single audit and consultation with the Independent Public Accounting Firm (Pile CPAs) Additionally staff will regularly meet with the independent bookkeeper to review and reconcile accrued revenues ands receivables.
Finding 2023-001 Accounting for Prepaid Expenses Type of Finding: Material Weakness in Internal Control over Financial Reporting Criteria: According to accounting principles generally accepted in the United States of America ("GAAP"), an organization must have effective internal controls over accounting for prepaid expenses to ensure that transactions are recorded in the correct accounting period. This includes properly accounting for the timing of the receipt of prepaid supplies. Condition: Invoices for prepaid supplies were included in accounts payable for supplies that were not received in the same period. This resulted in an overstatement of expenses related to the prepaid supplies, as the expenses were not properly matched with the periods in which the supplies were actually received and used. Cause: The underlying cause of the condition was a failure to account for the timing of receipt for the supplies. This indicates a deficiency in the internal controls and procedures related to the recording of prepaid expenses. Possible or Known Effect: The effect of this condition was an overstatement of expenses, which could potentially mislead financial statement users and impact decision-making. This could also lead to inaccurate financial reporting and potential non-compliance with federal grant requirements. Questioned Costs: There are no specific questioned costs identified in this finding as the overstatement impacts the accuracy of financial reporting rather than a direct disallowed cost. However, the overstatement of expenses may affect the accuracy of financial statements and compliance with grant terms. Repeat Finding: This finding is not a repeat finding from the prior year. Recommendation: It is recommended that the organization implement a corrective action plan to address the internal control deficiencies identified. This plan should focus on revising procedures to ensure that prepaid supplies are accurately recorded in the period in which they are received. Additionally, enhancing training for staff involved in accounting for prepaid expenses will help ensure proper understanding and execution of these procedures. Regular reviews and reconciliations of accounts payable and prepaid supplies records should be conducted to prevent similar issues in the future. Finally, performing periodic audits of internal controls will help ensure ongoing compliance with accounting standards and grant requirements. Views of Responsible Officials: The Organizations’ Board and Executive Team consisting of the Chief Executive Officer (CEO) and the Chief Operating Officer (COO) and key Overdose Lifeline (ODL) Staff to include the independent bookkeeper and Grant and Finance Manager recognize the internal control deficiencies identified during the year 2023. As noted by the Independent Public Accounting Firm (Pile CPAs) significant improvements have occurred and in the first half of 2024 ODL implemented a new inventory accounting process through QuickBooks. This finding is addressed through this new accounting process. Overdose Lifeline moved from tracking inventory manually in excel spreadsheets to utilizing inventory management in Quickbooks Online (QBO). The process is: - Receipts: Once inventory is physically received, a QBO bill is entered identifying the quantity and cost of the items. - Shipments: Shipments are reflected on a weekly basis identifying the items and quantity shipped per item on a zero-dollar invoice. QBO utilizes FIFO (First In/First Out) methodology for inventory valuation. The physical inventory is reconciled to the QBO inventory counts monthly. Additionally the Grants and Finance Manager, Executive Team and other key personnel will conduct periodic audits of internal controls.
Finding 2023-002 Schedule of Expenditures of Federal Awards Preparation Type of Finding: Significant Deficiency over Financial Reporting. Criteria: Federal regulations and GAAP require the preparation of a comprehensive and accurate Schedule of Expenditures of Federal Awards ("SEFA"), which includes transparent disclosure of federal funds expended, including the source of funds, program titles, award numbers, and expenditure amounts. Condition: This year’s audit revealed significant improvements in the Organization’s SEFA preparation. The SEFA now more accurately reflects federal awards received and expended, and there have been enhancements in documenting award numbers, funding sources, and program titles. However, some inaccuracies and omissions persist, impacting the completeness and reliability of the SEFA. Cause: Ongoing gaps in the skills, knowledge, and experience of personnel responsible for SEFA preparation and reporting contribute to the persistence of some inaccuracies. Continued deficiencies in training and procedural adherence are factors in these issues. Possible or Known Effect: While improvements have mitigated the risk of misrepresentation, the remaining discrepancies could still lead to misinterpretation of federal funds received and expended. This could affect the Organization’s compliance with federal reporting requirements and potentially impact eligibility for future federal funding. Questioned Costs: There were no questioned costs identified. Repeat Finding: This finding is a repeat from the prior year. The previous finding number was 2022-002. Recommendation: Management should continue to build on recent improvements by further refining SEFA preparation processes. Enhanced controls should be implemented to ensure complete and accurate recording of federal awards and expenditures. Ongoing training for financial reporting personnel should be sustained, addressing remaining knowledge gaps and procedural issues. Documented procedures should be reviewed and updated regularly to ensure adherence to best practices and continuous improvement in SEFA preparation. Views of Responsible Officials: The Organizations’ Board and Executive Team consisting of the Chief Executive Officer (CEO) and the Chief Operating Officer (COO) and key Overdose Lifeline (ODL) Staff to include the independent bookkeeper and Grant and Finance Manager recognize the need to further refine the SEFA preparation process. This will be accomplished through the completion of a formal course that covers performing a single audit and consultation with the Independent Public Accounting Firm (Pile CPAs).
Finding 2023-004 Accounting for Revenues and Accrued Receivables Type of Finding: Significant Deficiency in Internal Control over Financial Reporting Criteria: According to Generally Accepted Accounting Principles (GAAP), revenues must be recorded in the period in which they are earned, even if the claims or payments are received in a subsequent period. Condition: Revenues earned during the fiscal year but claimed in the following fiscal year were inconsistently accrued as receivables. Specifically, revenues related to reimbursement-based grants were not recognized, despite expenses being recorded, and revenues were excluded even though costs of goods sold were included. Cause: The deficiency stemmed from inadequate internal controls and procedures for accruing revenues and receivables, reflecting a failure to adhere to proper revenue recognition practices. Possible or Known Effect: While the adjustments required were not material, they were significant and warrant the attention of those charged with governance. Improper accrual of revenues could mislead financial statement users and impact financial decision-making. Questioned Costs: There are no specific questioned costs identified in this finding. The issue pertains to revenue recognition practices rather than direct disallowed costs. Repeat Finding: This finding is not a repeat finding from the prior year. Recommendation: It is recommended that the organization improve its internal controls and procedures for accruing revenues. This should involve refining procedures for recognizing revenues from reimbursement-based grants and sales of supplies, enhancing staff training on GAAP revenue recognition, and regularly reviewing and reconciling accrued revenues and receivables to ensure they are recorded in the correct period. Significant discrepancies should be reviewed by those charged with governance to ensure timely resolution. Views of Responsible Officials: The Organizations’ Board and Executive Team consisting of the Chief Executive Officer (CEO) and the Chief Operating Officer (COO) and key Overdose Lifeline (ODL) Staff to include the independent bookkeeper and Grant and Finance Manager recognize the need to further refine the internal controls and procedures for accruing revenues. This will be accomplished through the completion of a formal course that covers performing a single audit and consultation with the Independent Public Accounting Firm (Pile CPAs) Additionally staff will regularly meet with the independent bookkeeper to review and reconcile accrued revenues ands receivables.
Finding 2023-001 Accounting for Prepaid Expenses Type of Finding: Material Weakness in Internal Control over Financial Reporting Criteria: According to accounting principles generally accepted in the United States of America ("GAAP"), an organization must have effective internal controls over accounting for prepaid expenses to ensure that transactions are recorded in the correct accounting period. This includes properly accounting for the timing of the receipt of prepaid supplies. Condition: Invoices for prepaid supplies were included in accounts payable for supplies that were not received in the same period. This resulted in an overstatement of expenses related to the prepaid supplies, as the expenses were not properly matched with the periods in which the supplies were actually received and used. Cause: The underlying cause of the condition was a failure to account for the timing of receipt for the supplies. This indicates a deficiency in the internal controls and procedures related to the recording of prepaid expenses. Possible or Known Effect: The effect of this condition was an overstatement of expenses, which could potentially mislead financial statement users and impact decision-making. This could also lead to inaccurate financial reporting and potential non-compliance with federal grant requirements. Questioned Costs: There are no specific questioned costs identified in this finding as the overstatement impacts the accuracy of financial reporting rather than a direct disallowed cost. However, the overstatement of expenses may affect the accuracy of financial statements and compliance with grant terms. Repeat Finding: This finding is not a repeat finding from the prior year. Recommendation: It is recommended that the organization implement a corrective action plan to address the internal control deficiencies identified. This plan should focus on revising procedures to ensure that prepaid supplies are accurately recorded in the period in which they are received. Additionally, enhancing training for staff involved in accounting for prepaid expenses will help ensure proper understanding and execution of these procedures. Regular reviews and reconciliations of accounts payable and prepaid supplies records should be conducted to prevent similar issues in the future. Finally, performing periodic audits of internal controls will help ensure ongoing compliance with accounting standards and grant requirements. Views of Responsible Officials: The Organizations’ Board and Executive Team consisting of the Chief Executive Officer (CEO) and the Chief Operating Officer (COO) and key Overdose Lifeline (ODL) Staff to include the independent bookkeeper and Grant and Finance Manager recognize the internal control deficiencies identified during the year 2023. As noted by the Independent Public Accounting Firm (Pile CPAs) significant improvements have occurred and in the first half of 2024 ODL implemented a new inventory accounting process through QuickBooks. This finding is addressed through this new accounting process. Overdose Lifeline moved from tracking inventory manually in excel spreadsheets to utilizing inventory management in Quickbooks Online (QBO). The process is: - Receipts: Once inventory is physically received, a QBO bill is entered identifying the quantity and cost of the items. - Shipments: Shipments are reflected on a weekly basis identifying the items and quantity shipped per item on a zero-dollar invoice. QBO utilizes FIFO (First In/First Out) methodology for inventory valuation. The physical inventory is reconciled to the QBO inventory counts monthly. Additionally the Grants and Finance Manager, Executive Team and other key personnel will conduct periodic audits of internal controls.
Finding 2023-002 Schedule of Expenditures of Federal Awards Preparation Type of Finding: Significant Deficiency over Financial Reporting. Criteria: Federal regulations and GAAP require the preparation of a comprehensive and accurate Schedule of Expenditures of Federal Awards ("SEFA"), which includes transparent disclosure of federal funds expended, including the source of funds, program titles, award numbers, and expenditure amounts. Condition: This year’s audit revealed significant improvements in the Organization’s SEFA preparation. The SEFA now more accurately reflects federal awards received and expended, and there have been enhancements in documenting award numbers, funding sources, and program titles. However, some inaccuracies and omissions persist, impacting the completeness and reliability of the SEFA. Cause: Ongoing gaps in the skills, knowledge, and experience of personnel responsible for SEFA preparation and reporting contribute to the persistence of some inaccuracies. Continued deficiencies in training and procedural adherence are factors in these issues. Possible or Known Effect: While improvements have mitigated the risk of misrepresentation, the remaining discrepancies could still lead to misinterpretation of federal funds received and expended. This could affect the Organization’s compliance with federal reporting requirements and potentially impact eligibility for future federal funding. Questioned Costs: There were no questioned costs identified. Repeat Finding: This finding is a repeat from the prior year. The previous finding number was 2022-002. Recommendation: Management should continue to build on recent improvements by further refining SEFA preparation processes. Enhanced controls should be implemented to ensure complete and accurate recording of federal awards and expenditures. Ongoing training for financial reporting personnel should be sustained, addressing remaining knowledge gaps and procedural issues. Documented procedures should be reviewed and updated regularly to ensure adherence to best practices and continuous improvement in SEFA preparation. Views of Responsible Officials: The Organizations’ Board and Executive Team consisting of the Chief Executive Officer (CEO) and the Chief Operating Officer (COO) and key Overdose Lifeline (ODL) Staff to include the independent bookkeeper and Grant and Finance Manager recognize the need to further refine the SEFA preparation process. This will be accomplished through the completion of a formal course that covers performing a single audit and consultation with the Independent Public Accounting Firm (Pile CPAs).
Finding 2023-004 Accounting for Revenues and Accrued Receivables Type of Finding: Significant Deficiency in Internal Control over Financial Reporting Criteria: According to Generally Accepted Accounting Principles (GAAP), revenues must be recorded in the period in which they are earned, even if the claims or payments are received in a subsequent period. Condition: Revenues earned during the fiscal year but claimed in the following fiscal year were inconsistently accrued as receivables. Specifically, revenues related to reimbursement-based grants were not recognized, despite expenses being recorded, and revenues were excluded even though costs of goods sold were included. Cause: The deficiency stemmed from inadequate internal controls and procedures for accruing revenues and receivables, reflecting a failure to adhere to proper revenue recognition practices. Possible or Known Effect: While the adjustments required were not material, they were significant and warrant the attention of those charged with governance. Improper accrual of revenues could mislead financial statement users and impact financial decision-making. Questioned Costs: There are no specific questioned costs identified in this finding. The issue pertains to revenue recognition practices rather than direct disallowed costs. Repeat Finding: This finding is not a repeat finding from the prior year. Recommendation: It is recommended that the organization improve its internal controls and procedures for accruing revenues. This should involve refining procedures for recognizing revenues from reimbursement-based grants and sales of supplies, enhancing staff training on GAAP revenue recognition, and regularly reviewing and reconciling accrued revenues and receivables to ensure they are recorded in the correct period. Significant discrepancies should be reviewed by those charged with governance to ensure timely resolution. Views of Responsible Officials: The Organizations’ Board and Executive Team consisting of the Chief Executive Officer (CEO) and the Chief Operating Officer (COO) and key Overdose Lifeline (ODL) Staff to include the independent bookkeeper and Grant and Finance Manager recognize the need to further refine the internal controls and procedures for accruing revenues. This will be accomplished through the completion of a formal course that covers performing a single audit and consultation with the Independent Public Accounting Firm (Pile CPAs) Additionally staff will regularly meet with the independent bookkeeper to review and reconcile accrued revenues ands receivables.
Finding 2023-001 Accounting for Prepaid Expenses Type of Finding: Material Weakness in Internal Control over Financial Reporting Criteria: According to accounting principles generally accepted in the United States of America ("GAAP"), an organization must have effective internal controls over accounting for prepaid expenses to ensure that transactions are recorded in the correct accounting period. This includes properly accounting for the timing of the receipt of prepaid supplies. Condition: Invoices for prepaid supplies were included in accounts payable for supplies that were not received in the same period. This resulted in an overstatement of expenses related to the prepaid supplies, as the expenses were not properly matched with the periods in which the supplies were actually received and used. Cause: The underlying cause of the condition was a failure to account for the timing of receipt for the supplies. This indicates a deficiency in the internal controls and procedures related to the recording of prepaid expenses. Possible or Known Effect: The effect of this condition was an overstatement of expenses, which could potentially mislead financial statement users and impact decision-making. This could also lead to inaccurate financial reporting and potential non-compliance with federal grant requirements. Questioned Costs: There are no specific questioned costs identified in this finding as the overstatement impacts the accuracy of financial reporting rather than a direct disallowed cost. However, the overstatement of expenses may affect the accuracy of financial statements and compliance with grant terms. Repeat Finding: This finding is not a repeat finding from the prior year. Recommendation: It is recommended that the organization implement a corrective action plan to address the internal control deficiencies identified. This plan should focus on revising procedures to ensure that prepaid supplies are accurately recorded in the period in which they are received. Additionally, enhancing training for staff involved in accounting for prepaid expenses will help ensure proper understanding and execution of these procedures. Regular reviews and reconciliations of accounts payable and prepaid supplies records should be conducted to prevent similar issues in the future. Finally, performing periodic audits of internal controls will help ensure ongoing compliance with accounting standards and grant requirements. Views of Responsible Officials: The Organizations’ Board and Executive Team consisting of the Chief Executive Officer (CEO) and the Chief Operating Officer (COO) and key Overdose Lifeline (ODL) Staff to include the independent bookkeeper and Grant and Finance Manager recognize the internal control deficiencies identified during the year 2023. As noted by the Independent Public Accounting Firm (Pile CPAs) significant improvements have occurred and in the first half of 2024 ODL implemented a new inventory accounting process through QuickBooks. This finding is addressed through this new accounting process. Overdose Lifeline moved from tracking inventory manually in excel spreadsheets to utilizing inventory management in Quickbooks Online (QBO). The process is: - Receipts: Once inventory is physically received, a QBO bill is entered identifying the quantity and cost of the items. - Shipments: Shipments are reflected on a weekly basis identifying the items and quantity shipped per item on a zero-dollar invoice. QBO utilizes FIFO (First In/First Out) methodology for inventory valuation. The physical inventory is reconciled to the QBO inventory counts monthly. Additionally the Grants and Finance Manager, Executive Team and other key personnel will conduct periodic audits of internal controls.
Finding 2023-002 Schedule of Expenditures of Federal Awards Preparation Type of Finding: Significant Deficiency over Financial Reporting. Criteria: Federal regulations and GAAP require the preparation of a comprehensive and accurate Schedule of Expenditures of Federal Awards ("SEFA"), which includes transparent disclosure of federal funds expended, including the source of funds, program titles, award numbers, and expenditure amounts. Condition: This year’s audit revealed significant improvements in the Organization’s SEFA preparation. The SEFA now more accurately reflects federal awards received and expended, and there have been enhancements in documenting award numbers, funding sources, and program titles. However, some inaccuracies and omissions persist, impacting the completeness and reliability of the SEFA. Cause: Ongoing gaps in the skills, knowledge, and experience of personnel responsible for SEFA preparation and reporting contribute to the persistence of some inaccuracies. Continued deficiencies in training and procedural adherence are factors in these issues. Possible or Known Effect: While improvements have mitigated the risk of misrepresentation, the remaining discrepancies could still lead to misinterpretation of federal funds received and expended. This could affect the Organization’s compliance with federal reporting requirements and potentially impact eligibility for future federal funding. Questioned Costs: There were no questioned costs identified. Repeat Finding: This finding is a repeat from the prior year. The previous finding number was 2022-002. Recommendation: Management should continue to build on recent improvements by further refining SEFA preparation processes. Enhanced controls should be implemented to ensure complete and accurate recording of federal awards and expenditures. Ongoing training for financial reporting personnel should be sustained, addressing remaining knowledge gaps and procedural issues. Documented procedures should be reviewed and updated regularly to ensure adherence to best practices and continuous improvement in SEFA preparation. Views of Responsible Officials: The Organizations’ Board and Executive Team consisting of the Chief Executive Officer (CEO) and the Chief Operating Officer (COO) and key Overdose Lifeline (ODL) Staff to include the independent bookkeeper and Grant and Finance Manager recognize the need to further refine the SEFA preparation process. This will be accomplished through the completion of a formal course that covers performing a single audit and consultation with the Independent Public Accounting Firm (Pile CPAs).
Finding 2023-004 Accounting for Revenues and Accrued Receivables Type of Finding: Significant Deficiency in Internal Control over Financial Reporting Criteria: According to Generally Accepted Accounting Principles (GAAP), revenues must be recorded in the period in which they are earned, even if the claims or payments are received in a subsequent period. Condition: Revenues earned during the fiscal year but claimed in the following fiscal year were inconsistently accrued as receivables. Specifically, revenues related to reimbursement-based grants were not recognized, despite expenses being recorded, and revenues were excluded even though costs of goods sold were included. Cause: The deficiency stemmed from inadequate internal controls and procedures for accruing revenues and receivables, reflecting a failure to adhere to proper revenue recognition practices. Possible or Known Effect: While the adjustments required were not material, they were significant and warrant the attention of those charged with governance. Improper accrual of revenues could mislead financial statement users and impact financial decision-making. Questioned Costs: There are no specific questioned costs identified in this finding. The issue pertains to revenue recognition practices rather than direct disallowed costs. Repeat Finding: This finding is not a repeat finding from the prior year. Recommendation: It is recommended that the organization improve its internal controls and procedures for accruing revenues. This should involve refining procedures for recognizing revenues from reimbursement-based grants and sales of supplies, enhancing staff training on GAAP revenue recognition, and regularly reviewing and reconciling accrued revenues and receivables to ensure they are recorded in the correct period. Significant discrepancies should be reviewed by those charged with governance to ensure timely resolution. Views of Responsible Officials: The Organizations’ Board and Executive Team consisting of the Chief Executive Officer (CEO) and the Chief Operating Officer (COO) and key Overdose Lifeline (ODL) Staff to include the independent bookkeeper and Grant and Finance Manager recognize the need to further refine the internal controls and procedures for accruing revenues. This will be accomplished through the completion of a formal course that covers performing a single audit and consultation with the Independent Public Accounting Firm (Pile CPAs) Additionally staff will regularly meet with the independent bookkeeper to review and reconcile accrued revenues ands receivables.
Finding 2023-001 Accounting for Prepaid Expenses Type of Finding: Material Weakness in Internal Control over Financial Reporting Criteria: According to accounting principles generally accepted in the United States of America ("GAAP"), an organization must have effective internal controls over accounting for prepaid expenses to ensure that transactions are recorded in the correct accounting period. This includes properly accounting for the timing of the receipt of prepaid supplies. Condition: Invoices for prepaid supplies were included in accounts payable for supplies that were not received in the same period. This resulted in an overstatement of expenses related to the prepaid supplies, as the expenses were not properly matched with the periods in which the supplies were actually received and used. Cause: The underlying cause of the condition was a failure to account for the timing of receipt for the supplies. This indicates a deficiency in the internal controls and procedures related to the recording of prepaid expenses. Possible or Known Effect: The effect of this condition was an overstatement of expenses, which could potentially mislead financial statement users and impact decision-making. This could also lead to inaccurate financial reporting and potential non-compliance with federal grant requirements. Questioned Costs: There are no specific questioned costs identified in this finding as the overstatement impacts the accuracy of financial reporting rather than a direct disallowed cost. However, the overstatement of expenses may affect the accuracy of financial statements and compliance with grant terms. Repeat Finding: This finding is not a repeat finding from the prior year. Recommendation: It is recommended that the organization implement a corrective action plan to address the internal control deficiencies identified. This plan should focus on revising procedures to ensure that prepaid supplies are accurately recorded in the period in which they are received. Additionally, enhancing training for staff involved in accounting for prepaid expenses will help ensure proper understanding and execution of these procedures. Regular reviews and reconciliations of accounts payable and prepaid supplies records should be conducted to prevent similar issues in the future. Finally, performing periodic audits of internal controls will help ensure ongoing compliance with accounting standards and grant requirements. Views of Responsible Officials: The Organizations’ Board and Executive Team consisting of the Chief Executive Officer (CEO) and the Chief Operating Officer (COO) and key Overdose Lifeline (ODL) Staff to include the independent bookkeeper and Grant and Finance Manager recognize the internal control deficiencies identified during the year 2023. As noted by the Independent Public Accounting Firm (Pile CPAs) significant improvements have occurred and in the first half of 2024 ODL implemented a new inventory accounting process through QuickBooks. This finding is addressed through this new accounting process. Overdose Lifeline moved from tracking inventory manually in excel spreadsheets to utilizing inventory management in Quickbooks Online (QBO). The process is: - Receipts: Once inventory is physically received, a QBO bill is entered identifying the quantity and cost of the items. - Shipments: Shipments are reflected on a weekly basis identifying the items and quantity shipped per item on a zero-dollar invoice. QBO utilizes FIFO (First In/First Out) methodology for inventory valuation. The physical inventory is reconciled to the QBO inventory counts monthly. Additionally the Grants and Finance Manager, Executive Team and other key personnel will conduct periodic audits of internal controls.
Finding 2023-002 Schedule of Expenditures of Federal Awards Preparation Type of Finding: Significant Deficiency over Financial Reporting. Criteria: Federal regulations and GAAP require the preparation of a comprehensive and accurate Schedule of Expenditures of Federal Awards ("SEFA"), which includes transparent disclosure of federal funds expended, including the source of funds, program titles, award numbers, and expenditure amounts. Condition: This year’s audit revealed significant improvements in the Organization’s SEFA preparation. The SEFA now more accurately reflects federal awards received and expended, and there have been enhancements in documenting award numbers, funding sources, and program titles. However, some inaccuracies and omissions persist, impacting the completeness and reliability of the SEFA. Cause: Ongoing gaps in the skills, knowledge, and experience of personnel responsible for SEFA preparation and reporting contribute to the persistence of some inaccuracies. Continued deficiencies in training and procedural adherence are factors in these issues. Possible or Known Effect: While improvements have mitigated the risk of misrepresentation, the remaining discrepancies could still lead to misinterpretation of federal funds received and expended. This could affect the Organization’s compliance with federal reporting requirements and potentially impact eligibility for future federal funding. Questioned Costs: There were no questioned costs identified. Repeat Finding: This finding is a repeat from the prior year. The previous finding number was 2022-002. Recommendation: Management should continue to build on recent improvements by further refining SEFA preparation processes. Enhanced controls should be implemented to ensure complete and accurate recording of federal awards and expenditures. Ongoing training for financial reporting personnel should be sustained, addressing remaining knowledge gaps and procedural issues. Documented procedures should be reviewed and updated regularly to ensure adherence to best practices and continuous improvement in SEFA preparation. Views of Responsible Officials: The Organizations’ Board and Executive Team consisting of the Chief Executive Officer (CEO) and the Chief Operating Officer (COO) and key Overdose Lifeline (ODL) Staff to include the independent bookkeeper and Grant and Finance Manager recognize the need to further refine the SEFA preparation process. This will be accomplished through the completion of a formal course that covers performing a single audit and consultation with the Independent Public Accounting Firm (Pile CPAs).
Finding 2023-004 Accounting for Revenues and Accrued Receivables Type of Finding: Significant Deficiency in Internal Control over Financial Reporting Criteria: According to Generally Accepted Accounting Principles (GAAP), revenues must be recorded in the period in which they are earned, even if the claims or payments are received in a subsequent period. Condition: Revenues earned during the fiscal year but claimed in the following fiscal year were inconsistently accrued as receivables. Specifically, revenues related to reimbursement-based grants were not recognized, despite expenses being recorded, and revenues were excluded even though costs of goods sold were included. Cause: The deficiency stemmed from inadequate internal controls and procedures for accruing revenues and receivables, reflecting a failure to adhere to proper revenue recognition practices. Possible or Known Effect: While the adjustments required were not material, they were significant and warrant the attention of those charged with governance. Improper accrual of revenues could mislead financial statement users and impact financial decision-making. Questioned Costs: There are no specific questioned costs identified in this finding. The issue pertains to revenue recognition practices rather than direct disallowed costs. Repeat Finding: This finding is not a repeat finding from the prior year. Recommendation: It is recommended that the organization improve its internal controls and procedures for accruing revenues. This should involve refining procedures for recognizing revenues from reimbursement-based grants and sales of supplies, enhancing staff training on GAAP revenue recognition, and regularly reviewing and reconciling accrued revenues and receivables to ensure they are recorded in the correct period. Significant discrepancies should be reviewed by those charged with governance to ensure timely resolution. Views of Responsible Officials: The Organizations’ Board and Executive Team consisting of the Chief Executive Officer (CEO) and the Chief Operating Officer (COO) and key Overdose Lifeline (ODL) Staff to include the independent bookkeeper and Grant and Finance Manager recognize the need to further refine the internal controls and procedures for accruing revenues. This will be accomplished through the completion of a formal course that covers performing a single audit and consultation with the Independent Public Accounting Firm (Pile CPAs) Additionally staff will regularly meet with the independent bookkeeper to review and reconcile accrued revenues ands receivables.
Finding 2023-001 Accounting for Prepaid Expenses Type of Finding: Material Weakness in Internal Control over Financial Reporting Criteria: According to accounting principles generally accepted in the United States of America ("GAAP"), an organization must have effective internal controls over accounting for prepaid expenses to ensure that transactions are recorded in the correct accounting period. This includes properly accounting for the timing of the receipt of prepaid supplies. Condition: Invoices for prepaid supplies were included in accounts payable for supplies that were not received in the same period. This resulted in an overstatement of expenses related to the prepaid supplies, as the expenses were not properly matched with the periods in which the supplies were actually received and used. Cause: The underlying cause of the condition was a failure to account for the timing of receipt for the supplies. This indicates a deficiency in the internal controls and procedures related to the recording of prepaid expenses. Possible or Known Effect: The effect of this condition was an overstatement of expenses, which could potentially mislead financial statement users and impact decision-making. This could also lead to inaccurate financial reporting and potential non-compliance with federal grant requirements. Questioned Costs: There are no specific questioned costs identified in this finding as the overstatement impacts the accuracy of financial reporting rather than a direct disallowed cost. However, the overstatement of expenses may affect the accuracy of financial statements and compliance with grant terms. Repeat Finding: This finding is not a repeat finding from the prior year. Recommendation: It is recommended that the organization implement a corrective action plan to address the internal control deficiencies identified. This plan should focus on revising procedures to ensure that prepaid supplies are accurately recorded in the period in which they are received. Additionally, enhancing training for staff involved in accounting for prepaid expenses will help ensure proper understanding and execution of these procedures. Regular reviews and reconciliations of accounts payable and prepaid supplies records should be conducted to prevent similar issues in the future. Finally, performing periodic audits of internal controls will help ensure ongoing compliance with accounting standards and grant requirements. Views of Responsible Officials: The Organizations’ Board and Executive Team consisting of the Chief Executive Officer (CEO) and the Chief Operating Officer (COO) and key Overdose Lifeline (ODL) Staff to include the independent bookkeeper and Grant and Finance Manager recognize the internal control deficiencies identified during the year 2023. As noted by the Independent Public Accounting Firm (Pile CPAs) significant improvements have occurred and in the first half of 2024 ODL implemented a new inventory accounting process through QuickBooks. This finding is addressed through this new accounting process. Overdose Lifeline moved from tracking inventory manually in excel spreadsheets to utilizing inventory management in Quickbooks Online (QBO). The process is: - Receipts: Once inventory is physically received, a QBO bill is entered identifying the quantity and cost of the items. - Shipments: Shipments are reflected on a weekly basis identifying the items and quantity shipped per item on a zero-dollar invoice. QBO utilizes FIFO (First In/First Out) methodology for inventory valuation. The physical inventory is reconciled to the QBO inventory counts monthly. Additionally the Grants and Finance Manager, Executive Team and other key personnel will conduct periodic audits of internal controls.
Finding 2023-002 Schedule of Expenditures of Federal Awards Preparation Type of Finding: Significant Deficiency over Financial Reporting. Criteria: Federal regulations and GAAP require the preparation of a comprehensive and accurate Schedule of Expenditures of Federal Awards ("SEFA"), which includes transparent disclosure of federal funds expended, including the source of funds, program titles, award numbers, and expenditure amounts. Condition: This year’s audit revealed significant improvements in the Organization’s SEFA preparation. The SEFA now more accurately reflects federal awards received and expended, and there have been enhancements in documenting award numbers, funding sources, and program titles. However, some inaccuracies and omissions persist, impacting the completeness and reliability of the SEFA. Cause: Ongoing gaps in the skills, knowledge, and experience of personnel responsible for SEFA preparation and reporting contribute to the persistence of some inaccuracies. Continued deficiencies in training and procedural adherence are factors in these issues. Possible or Known Effect: While improvements have mitigated the risk of misrepresentation, the remaining discrepancies could still lead to misinterpretation of federal funds received and expended. This could affect the Organization’s compliance with federal reporting requirements and potentially impact eligibility for future federal funding. Questioned Costs: There were no questioned costs identified. Repeat Finding: This finding is a repeat from the prior year. The previous finding number was 2022-002. Recommendation: Management should continue to build on recent improvements by further refining SEFA preparation processes. Enhanced controls should be implemented to ensure complete and accurate recording of federal awards and expenditures. Ongoing training for financial reporting personnel should be sustained, addressing remaining knowledge gaps and procedural issues. Documented procedures should be reviewed and updated regularly to ensure adherence to best practices and continuous improvement in SEFA preparation. Views of Responsible Officials: The Organizations’ Board and Executive Team consisting of the Chief Executive Officer (CEO) and the Chief Operating Officer (COO) and key Overdose Lifeline (ODL) Staff to include the independent bookkeeper and Grant and Finance Manager recognize the need to further refine the SEFA preparation process. This will be accomplished through the completion of a formal course that covers performing a single audit and consultation with the Independent Public Accounting Firm (Pile CPAs).
Finding 2023-004 Accounting for Revenues and Accrued Receivables Type of Finding: Significant Deficiency in Internal Control over Financial Reporting Criteria: According to Generally Accepted Accounting Principles (GAAP), revenues must be recorded in the period in which they are earned, even if the claims or payments are received in a subsequent period. Condition: Revenues earned during the fiscal year but claimed in the following fiscal year were inconsistently accrued as receivables. Specifically, revenues related to reimbursement-based grants were not recognized, despite expenses being recorded, and revenues were excluded even though costs of goods sold were included. Cause: The deficiency stemmed from inadequate internal controls and procedures for accruing revenues and receivables, reflecting a failure to adhere to proper revenue recognition practices. Possible or Known Effect: While the adjustments required were not material, they were significant and warrant the attention of those charged with governance. Improper accrual of revenues could mislead financial statement users and impact financial decision-making. Questioned Costs: There are no specific questioned costs identified in this finding. The issue pertains to revenue recognition practices rather than direct disallowed costs. Repeat Finding: This finding is not a repeat finding from the prior year. Recommendation: It is recommended that the organization improve its internal controls and procedures for accruing revenues. This should involve refining procedures for recognizing revenues from reimbursement-based grants and sales of supplies, enhancing staff training on GAAP revenue recognition, and regularly reviewing and reconciling accrued revenues and receivables to ensure they are recorded in the correct period. Significant discrepancies should be reviewed by those charged with governance to ensure timely resolution. Views of Responsible Officials: The Organizations’ Board and Executive Team consisting of the Chief Executive Officer (CEO) and the Chief Operating Officer (COO) and key Overdose Lifeline (ODL) Staff to include the independent bookkeeper and Grant and Finance Manager recognize the need to further refine the internal controls and procedures for accruing revenues. This will be accomplished through the completion of a formal course that covers performing a single audit and consultation with the Independent Public Accounting Firm (Pile CPAs) Additionally staff will regularly meet with the independent bookkeeper to review and reconcile accrued revenues ands receivables.
Finding 2023-003 Expenditure of Funds Outside Contract Period Type of Finding: Noncompliance and Significant Deficiency in Internal Control over Compliance. Criteria: Federal regulations and grant guidelines require expenditures to align with the grant’s period of performance. Organizations must obtain prior authorization from the pass-through entity for any expenditures claimed against the grant before the official grant start date. Proper internal controls should include mechanisms to ensure compliance with grant periods and approval processes for any deviations. Condition: Testing revealed that the Organization claimed expenditures against the grant that occurred before the official grant period. Although these expenditures were made outside the period of performance, they were submitted for reimbursement without securing prior authorization from the pass-through entity. Cause: The Organization's internal controls for managing grant expenditures did not sufficiently address the need for pre-authorization of expenditures incurred before the grant period. Additionally, there was a lack of effective monitoring to ensure compliance with grant start dates and required approvals. Possible or Known Effect: Claiming expenditures prior to the grant period without prior authorization could result in improper use of grant funds. This practice may impact the organization’s ability to meet grant objectives and cause misalignment between actual expenditures and grant reporting. Questioned Costs: Known questioned costs total $6,286. Repeat Finding: This finding is a repeat from the prior year. The previous finding number was 2022-003. Recommendation: We recommend that the Organization enhance its internal controls to ensure compliance with grant periods by implementing a process to obtain prior authorization from the pass-through entity for any expenditures made before the official grant start date. Additionally, the Organization should strengthen monitoring mechanisms to prevent similar issues in the future. Views of Responsible Officials: The Organizations’ Board and Executive Team consisting of the Chief Executive Officer (CEO) and the Chief Operating Officer (COO) and key Overdose Lifeline (ODL) Staff to include the independent bookkeeper and Grant and Finance Manager recognize the need to enhance internal controls and mechanisms to ensure purchase do not occur outside grant periods.
Finding 2023-005 Misallocation of Grant Funds Type of Finding: Noncompliance and Material Weakness in Internal Control over Compliance. Criteria: The Uniform Guidance establishes criteria for allowable costs and the proper use of federal funds. According to Uniform Guidance, costs must be necessary and reasonable for the performance of the federal award and allocated correctly. Additionally, costs must be charged to the federal award based on the benefits received. Condition: The Organization claimed purchases under a reimbursement-based federal grant but then used these supplies for a different grant. This improper use of grant-funded supplies is a violation of the grant’s terms and conditions. Cause: The root cause of the noncompliance is the Organization’s failure to implement effective internal controls to ensure proper communication between departments. While the Organization was aware of the grant terms prohibiting such actions, the lack of controls and processes to coordinate the use of grant-funded supplies resulted in their misallocation. Possible or Known Effect: The misuse of resources risks undermining the programmatic impact intended by the grant. By not using the supplies as specified in the grant agreement, the Organization may fail to achieve the grant’s objectives and intended outcomes, ultimately diminishing the effectiveness of the funded program. Questioned Costs: The total questioned costs amount to $85,178, reflecting the value of supplies used improperly. Repeat Finding: This finding is not a repeat finding from the prior year. Recommendation: To address the identified issue, it is crucial the Organization implement and enhance internal controls and communication processes between departments to ensure compliance with grant requirements. The Organization should implement enhancements in the tracking of supplies by grant. Additionally, the Organization should establish effective oversight mechanisms and provide training to staff on proper grant management practices. A review and revision of grant management policies are necessary to prevent similar issues in the future. Views of Responsible Officials: The Organizations’ Board and Executive Team consisting of the Chief Executive Officer (CEO) and the Chief Operating Officer (COO) and key Overdose Lifeline (ODL) Staff to include the independent bookkeeper and Grant and Finance Manager recognize the need to further significantly improve on the oversight and reconciliation of supply ordering and inventory. This is already underway with the QB inventory process described previously and an improved process for backup documentation. Additionally key staff will complete of a formal course that covers performing a single audit and engage in consultation with the Independent Public Accounting Firm (Pile CPAs).
Finding 2023-001 Accounting for Prepaid Expenses Type of Finding: Material Weakness in Internal Control over Financial Reporting Criteria: According to accounting principles generally accepted in the United States of America ("GAAP"), an organization must have effective internal controls over accounting for prepaid expenses to ensure that transactions are recorded in the correct accounting period. This includes properly accounting for the timing of the receipt of prepaid supplies. Condition: Invoices for prepaid supplies were included in accounts payable for supplies that were not received in the same period. This resulted in an overstatement of expenses related to the prepaid supplies, as the expenses were not properly matched with the periods in which the supplies were actually received and used. Cause: The underlying cause of the condition was a failure to account for the timing of receipt for the supplies. This indicates a deficiency in the internal controls and procedures related to the recording of prepaid expenses. Possible or Known Effect: The effect of this condition was an overstatement of expenses, which could potentially mislead financial statement users and impact decision-making. This could also lead to inaccurate financial reporting and potential non-compliance with federal grant requirements. Questioned Costs: There are no specific questioned costs identified in this finding as the overstatement impacts the accuracy of financial reporting rather than a direct disallowed cost. However, the overstatement of expenses may affect the accuracy of financial statements and compliance with grant terms. Repeat Finding: This finding is not a repeat finding from the prior year. Recommendation: It is recommended that the organization implement a corrective action plan to address the internal control deficiencies identified. This plan should focus on revising procedures to ensure that prepaid supplies are accurately recorded in the period in which they are received. Additionally, enhancing training for staff involved in accounting for prepaid expenses will help ensure proper understanding and execution of these procedures. Regular reviews and reconciliations of accounts payable and prepaid supplies records should be conducted to prevent similar issues in the future. Finally, performing periodic audits of internal controls will help ensure ongoing compliance with accounting standards and grant requirements. Views of Responsible Officials: The Organizations’ Board and Executive Team consisting of the Chief Executive Officer (CEO) and the Chief Operating Officer (COO) and key Overdose Lifeline (ODL) Staff to include the independent bookkeeper and Grant and Finance Manager recognize the internal control deficiencies identified during the year 2023. As noted by the Independent Public Accounting Firm (Pile CPAs) significant improvements have occurred and in the first half of 2024 ODL implemented a new inventory accounting process through QuickBooks. This finding is addressed through this new accounting process. Overdose Lifeline moved from tracking inventory manually in excel spreadsheets to utilizing inventory management in Quickbooks Online (QBO). The process is: - Receipts: Once inventory is physically received, a QBO bill is entered identifying the quantity and cost of the items. - Shipments: Shipments are reflected on a weekly basis identifying the items and quantity shipped per item on a zero-dollar invoice. QBO utilizes FIFO (First In/First Out) methodology for inventory valuation. The physical inventory is reconciled to the QBO inventory counts monthly. Additionally the Grants and Finance Manager, Executive Team and other key personnel will conduct periodic audits of internal controls.
Finding 2023-002 Schedule of Expenditures of Federal Awards Preparation Type of Finding: Significant Deficiency over Financial Reporting. Criteria: Federal regulations and GAAP require the preparation of a comprehensive and accurate Schedule of Expenditures of Federal Awards ("SEFA"), which includes transparent disclosure of federal funds expended, including the source of funds, program titles, award numbers, and expenditure amounts. Condition: This year’s audit revealed significant improvements in the Organization’s SEFA preparation. The SEFA now more accurately reflects federal awards received and expended, and there have been enhancements in documenting award numbers, funding sources, and program titles. However, some inaccuracies and omissions persist, impacting the completeness and reliability of the SEFA. Cause: Ongoing gaps in the skills, knowledge, and experience of personnel responsible for SEFA preparation and reporting contribute to the persistence of some inaccuracies. Continued deficiencies in training and procedural adherence are factors in these issues. Possible or Known Effect: While improvements have mitigated the risk of misrepresentation, the remaining discrepancies could still lead to misinterpretation of federal funds received and expended. This could affect the Organization’s compliance with federal reporting requirements and potentially impact eligibility for future federal funding. Questioned Costs: There were no questioned costs identified. Repeat Finding: This finding is a repeat from the prior year. The previous finding number was 2022-002. Recommendation: Management should continue to build on recent improvements by further refining SEFA preparation processes. Enhanced controls should be implemented to ensure complete and accurate recording of federal awards and expenditures. Ongoing training for financial reporting personnel should be sustained, addressing remaining knowledge gaps and procedural issues. Documented procedures should be reviewed and updated regularly to ensure adherence to best practices and continuous improvement in SEFA preparation. Views of Responsible Officials: The Organizations’ Board and Executive Team consisting of the Chief Executive Officer (CEO) and the Chief Operating Officer (COO) and key Overdose Lifeline (ODL) Staff to include the independent bookkeeper and Grant and Finance Manager recognize the need to further refine the SEFA preparation process. This will be accomplished through the completion of a formal course that covers performing a single audit and consultation with the Independent Public Accounting Firm (Pile CPAs).
Finding 2023-004 Accounting for Revenues and Accrued Receivables Type of Finding: Significant Deficiency in Internal Control over Financial Reporting Criteria: According to Generally Accepted Accounting Principles (GAAP), revenues must be recorded in the period in which they are earned, even if the claims or payments are received in a subsequent period. Condition: Revenues earned during the fiscal year but claimed in the following fiscal year were inconsistently accrued as receivables. Specifically, revenues related to reimbursement-based grants were not recognized, despite expenses being recorded, and revenues were excluded even though costs of goods sold were included. Cause: The deficiency stemmed from inadequate internal controls and procedures for accruing revenues and receivables, reflecting a failure to adhere to proper revenue recognition practices. Possible or Known Effect: While the adjustments required were not material, they were significant and warrant the attention of those charged with governance. Improper accrual of revenues could mislead financial statement users and impact financial decision-making. Questioned Costs: There are no specific questioned costs identified in this finding. The issue pertains to revenue recognition practices rather than direct disallowed costs. Repeat Finding: This finding is not a repeat finding from the prior year. Recommendation: It is recommended that the organization improve its internal controls and procedures for accruing revenues. This should involve refining procedures for recognizing revenues from reimbursement-based grants and sales of supplies, enhancing staff training on GAAP revenue recognition, and regularly reviewing and reconciling accrued revenues and receivables to ensure they are recorded in the correct period. Significant discrepancies should be reviewed by those charged with governance to ensure timely resolution. Views of Responsible Officials: The Organizations’ Board and Executive Team consisting of the Chief Executive Officer (CEO) and the Chief Operating Officer (COO) and key Overdose Lifeline (ODL) Staff to include the independent bookkeeper and Grant and Finance Manager recognize the need to further refine the internal controls and procedures for accruing revenues. This will be accomplished through the completion of a formal course that covers performing a single audit and consultation with the Independent Public Accounting Firm (Pile CPAs) Additionally staff will regularly meet with the independent bookkeeper to review and reconcile accrued revenues ands receivables.
Finding 2023-003 Expenditure of Funds Outside Contract Period Type of Finding: Noncompliance and Significant Deficiency in Internal Control over Compliance. Criteria: Federal regulations and grant guidelines require expenditures to align with the grant’s period of performance. Organizations must obtain prior authorization from the pass-through entity for any expenditures claimed against the grant before the official grant start date. Proper internal controls should include mechanisms to ensure compliance with grant periods and approval processes for any deviations. Condition: Testing revealed that the Organization claimed expenditures against the grant that occurred before the official grant period. Although these expenditures were made outside the period of performance, they were submitted for reimbursement without securing prior authorization from the pass-through entity. Cause: The Organization's internal controls for managing grant expenditures did not sufficiently address the need for pre-authorization of expenditures incurred before the grant period. Additionally, there was a lack of effective monitoring to ensure compliance with grant start dates and required approvals. Possible or Known Effect: Claiming expenditures prior to the grant period without prior authorization could result in improper use of grant funds. This practice may impact the organization’s ability to meet grant objectives and cause misalignment between actual expenditures and grant reporting. Questioned Costs: Known questioned costs total $6,286. Repeat Finding: This finding is a repeat from the prior year. The previous finding number was 2022-003. Recommendation: We recommend that the Organization enhance its internal controls to ensure compliance with grant periods by implementing a process to obtain prior authorization from the pass-through entity for any expenditures made before the official grant start date. Additionally, the Organization should strengthen monitoring mechanisms to prevent similar issues in the future. Views of Responsible Officials: The Organizations’ Board and Executive Team consisting of the Chief Executive Officer (CEO) and the Chief Operating Officer (COO) and key Overdose Lifeline (ODL) Staff to include the independent bookkeeper and Grant and Finance Manager recognize the need to enhance internal controls and mechanisms to ensure purchase do not occur outside grant periods.
Finding 2023-001 Accounting for Prepaid Expenses Type of Finding: Material Weakness in Internal Control over Financial Reporting Criteria: According to accounting principles generally accepted in the United States of America ("GAAP"), an organization must have effective internal controls over accounting for prepaid expenses to ensure that transactions are recorded in the correct accounting period. This includes properly accounting for the timing of the receipt of prepaid supplies. Condition: Invoices for prepaid supplies were included in accounts payable for supplies that were not received in the same period. This resulted in an overstatement of expenses related to the prepaid supplies, as the expenses were not properly matched with the periods in which the supplies were actually received and used. Cause: The underlying cause of the condition was a failure to account for the timing of receipt for the supplies. This indicates a deficiency in the internal controls and procedures related to the recording of prepaid expenses. Possible or Known Effect: The effect of this condition was an overstatement of expenses, which could potentially mislead financial statement users and impact decision-making. This could also lead to inaccurate financial reporting and potential non-compliance with federal grant requirements. Questioned Costs: There are no specific questioned costs identified in this finding as the overstatement impacts the accuracy of financial reporting rather than a direct disallowed cost. However, the overstatement of expenses may affect the accuracy of financial statements and compliance with grant terms. Repeat Finding: This finding is not a repeat finding from the prior year. Recommendation: It is recommended that the organization implement a corrective action plan to address the internal control deficiencies identified. This plan should focus on revising procedures to ensure that prepaid supplies are accurately recorded in the period in which they are received. Additionally, enhancing training for staff involved in accounting for prepaid expenses will help ensure proper understanding and execution of these procedures. Regular reviews and reconciliations of accounts payable and prepaid supplies records should be conducted to prevent similar issues in the future. Finally, performing periodic audits of internal controls will help ensure ongoing compliance with accounting standards and grant requirements. Views of Responsible Officials: The Organizations’ Board and Executive Team consisting of the Chief Executive Officer (CEO) and the Chief Operating Officer (COO) and key Overdose Lifeline (ODL) Staff to include the independent bookkeeper and Grant and Finance Manager recognize the internal control deficiencies identified during the year 2023. As noted by the Independent Public Accounting Firm (Pile CPAs) significant improvements have occurred and in the first half of 2024 ODL implemented a new inventory accounting process through QuickBooks. This finding is addressed through this new accounting process. Overdose Lifeline moved from tracking inventory manually in excel spreadsheets to utilizing inventory management in Quickbooks Online (QBO). The process is: - Receipts: Once inventory is physically received, a QBO bill is entered identifying the quantity and cost of the items. - Shipments: Shipments are reflected on a weekly basis identifying the items and quantity shipped per item on a zero-dollar invoice. QBO utilizes FIFO (First In/First Out) methodology for inventory valuation. The physical inventory is reconciled to the QBO inventory counts monthly. Additionally the Grants and Finance Manager, Executive Team and other key personnel will conduct periodic audits of internal controls.
Finding 2023-002 Schedule of Expenditures of Federal Awards Preparation Type of Finding: Significant Deficiency over Financial Reporting. Criteria: Federal regulations and GAAP require the preparation of a comprehensive and accurate Schedule of Expenditures of Federal Awards ("SEFA"), which includes transparent disclosure of federal funds expended, including the source of funds, program titles, award numbers, and expenditure amounts. Condition: This year’s audit revealed significant improvements in the Organization’s SEFA preparation. The SEFA now more accurately reflects federal awards received and expended, and there have been enhancements in documenting award numbers, funding sources, and program titles. However, some inaccuracies and omissions persist, impacting the completeness and reliability of the SEFA. Cause: Ongoing gaps in the skills, knowledge, and experience of personnel responsible for SEFA preparation and reporting contribute to the persistence of some inaccuracies. Continued deficiencies in training and procedural adherence are factors in these issues. Possible or Known Effect: While improvements have mitigated the risk of misrepresentation, the remaining discrepancies could still lead to misinterpretation of federal funds received and expended. This could affect the Organization’s compliance with federal reporting requirements and potentially impact eligibility for future federal funding. Questioned Costs: There were no questioned costs identified. Repeat Finding: This finding is a repeat from the prior year. The previous finding number was 2022-002. Recommendation: Management should continue to build on recent improvements by further refining SEFA preparation processes. Enhanced controls should be implemented to ensure complete and accurate recording of federal awards and expenditures. Ongoing training for financial reporting personnel should be sustained, addressing remaining knowledge gaps and procedural issues. Documented procedures should be reviewed and updated regularly to ensure adherence to best practices and continuous improvement in SEFA preparation. Views of Responsible Officials: The Organizations’ Board and Executive Team consisting of the Chief Executive Officer (CEO) and the Chief Operating Officer (COO) and key Overdose Lifeline (ODL) Staff to include the independent bookkeeper and Grant and Finance Manager recognize the need to further refine the SEFA preparation process. This will be accomplished through the completion of a formal course that covers performing a single audit and consultation with the Independent Public Accounting Firm (Pile CPAs).
Finding 2023-004 Accounting for Revenues and Accrued Receivables Type of Finding: Significant Deficiency in Internal Control over Financial Reporting Criteria: According to Generally Accepted Accounting Principles (GAAP), revenues must be recorded in the period in which they are earned, even if the claims or payments are received in a subsequent period. Condition: Revenues earned during the fiscal year but claimed in the following fiscal year were inconsistently accrued as receivables. Specifically, revenues related to reimbursement-based grants were not recognized, despite expenses being recorded, and revenues were excluded even though costs of goods sold were included. Cause: The deficiency stemmed from inadequate internal controls and procedures for accruing revenues and receivables, reflecting a failure to adhere to proper revenue recognition practices. Possible or Known Effect: While the adjustments required were not material, they were significant and warrant the attention of those charged with governance. Improper accrual of revenues could mislead financial statement users and impact financial decision-making. Questioned Costs: There are no specific questioned costs identified in this finding. The issue pertains to revenue recognition practices rather than direct disallowed costs. Repeat Finding: This finding is not a repeat finding from the prior year. Recommendation: It is recommended that the organization improve its internal controls and procedures for accruing revenues. This should involve refining procedures for recognizing revenues from reimbursement-based grants and sales of supplies, enhancing staff training on GAAP revenue recognition, and regularly reviewing and reconciling accrued revenues and receivables to ensure they are recorded in the correct period. Significant discrepancies should be reviewed by those charged with governance to ensure timely resolution. Views of Responsible Officials: The Organizations’ Board and Executive Team consisting of the Chief Executive Officer (CEO) and the Chief Operating Officer (COO) and key Overdose Lifeline (ODL) Staff to include the independent bookkeeper and Grant and Finance Manager recognize the need to further refine the internal controls and procedures for accruing revenues. This will be accomplished through the completion of a formal course that covers performing a single audit and consultation with the Independent Public Accounting Firm (Pile CPAs) Additionally staff will regularly meet with the independent bookkeeper to review and reconcile accrued revenues ands receivables.
Finding 2023-001 Accounting for Prepaid Expenses Type of Finding: Material Weakness in Internal Control over Financial Reporting Criteria: According to accounting principles generally accepted in the United States of America ("GAAP"), an organization must have effective internal controls over accounting for prepaid expenses to ensure that transactions are recorded in the correct accounting period. This includes properly accounting for the timing of the receipt of prepaid supplies. Condition: Invoices for prepaid supplies were included in accounts payable for supplies that were not received in the same period. This resulted in an overstatement of expenses related to the prepaid supplies, as the expenses were not properly matched with the periods in which the supplies were actually received and used. Cause: The underlying cause of the condition was a failure to account for the timing of receipt for the supplies. This indicates a deficiency in the internal controls and procedures related to the recording of prepaid expenses. Possible or Known Effect: The effect of this condition was an overstatement of expenses, which could potentially mislead financial statement users and impact decision-making. This could also lead to inaccurate financial reporting and potential non-compliance with federal grant requirements. Questioned Costs: There are no specific questioned costs identified in this finding as the overstatement impacts the accuracy of financial reporting rather than a direct disallowed cost. However, the overstatement of expenses may affect the accuracy of financial statements and compliance with grant terms. Repeat Finding: This finding is not a repeat finding from the prior year. Recommendation: It is recommended that the organization implement a corrective action plan to address the internal control deficiencies identified. This plan should focus on revising procedures to ensure that prepaid supplies are accurately recorded in the period in which they are received. Additionally, enhancing training for staff involved in accounting for prepaid expenses will help ensure proper understanding and execution of these procedures. Regular reviews and reconciliations of accounts payable and prepaid supplies records should be conducted to prevent similar issues in the future. Finally, performing periodic audits of internal controls will help ensure ongoing compliance with accounting standards and grant requirements. Views of Responsible Officials: The Organizations’ Board and Executive Team consisting of the Chief Executive Officer (CEO) and the Chief Operating Officer (COO) and key Overdose Lifeline (ODL) Staff to include the independent bookkeeper and Grant and Finance Manager recognize the internal control deficiencies identified during the year 2023. As noted by the Independent Public Accounting Firm (Pile CPAs) significant improvements have occurred and in the first half of 2024 ODL implemented a new inventory accounting process through QuickBooks. This finding is addressed through this new accounting process. Overdose Lifeline moved from tracking inventory manually in excel spreadsheets to utilizing inventory management in Quickbooks Online (QBO). The process is: - Receipts: Once inventory is physically received, a QBO bill is entered identifying the quantity and cost of the items. - Shipments: Shipments are reflected on a weekly basis identifying the items and quantity shipped per item on a zero-dollar invoice. QBO utilizes FIFO (First In/First Out) methodology for inventory valuation. The physical inventory is reconciled to the QBO inventory counts monthly. Additionally the Grants and Finance Manager, Executive Team and other key personnel will conduct periodic audits of internal controls.
Finding 2023-002 Schedule of Expenditures of Federal Awards Preparation Type of Finding: Significant Deficiency over Financial Reporting. Criteria: Federal regulations and GAAP require the preparation of a comprehensive and accurate Schedule of Expenditures of Federal Awards ("SEFA"), which includes transparent disclosure of federal funds expended, including the source of funds, program titles, award numbers, and expenditure amounts. Condition: This year’s audit revealed significant improvements in the Organization’s SEFA preparation. The SEFA now more accurately reflects federal awards received and expended, and there have been enhancements in documenting award numbers, funding sources, and program titles. However, some inaccuracies and omissions persist, impacting the completeness and reliability of the SEFA. Cause: Ongoing gaps in the skills, knowledge, and experience of personnel responsible for SEFA preparation and reporting contribute to the persistence of some inaccuracies. Continued deficiencies in training and procedural adherence are factors in these issues. Possible or Known Effect: While improvements have mitigated the risk of misrepresentation, the remaining discrepancies could still lead to misinterpretation of federal funds received and expended. This could affect the Organization’s compliance with federal reporting requirements and potentially impact eligibility for future federal funding. Questioned Costs: There were no questioned costs identified. Repeat Finding: This finding is a repeat from the prior year. The previous finding number was 2022-002. Recommendation: Management should continue to build on recent improvements by further refining SEFA preparation processes. Enhanced controls should be implemented to ensure complete and accurate recording of federal awards and expenditures. Ongoing training for financial reporting personnel should be sustained, addressing remaining knowledge gaps and procedural issues. Documented procedures should be reviewed and updated regularly to ensure adherence to best practices and continuous improvement in SEFA preparation. Views of Responsible Officials: The Organizations’ Board and Executive Team consisting of the Chief Executive Officer (CEO) and the Chief Operating Officer (COO) and key Overdose Lifeline (ODL) Staff to include the independent bookkeeper and Grant and Finance Manager recognize the need to further refine the SEFA preparation process. This will be accomplished through the completion of a formal course that covers performing a single audit and consultation with the Independent Public Accounting Firm (Pile CPAs).
Finding 2023-004 Accounting for Revenues and Accrued Receivables Type of Finding: Significant Deficiency in Internal Control over Financial Reporting Criteria: According to Generally Accepted Accounting Principles (GAAP), revenues must be recorded in the period in which they are earned, even if the claims or payments are received in a subsequent period. Condition: Revenues earned during the fiscal year but claimed in the following fiscal year were inconsistently accrued as receivables. Specifically, revenues related to reimbursement-based grants were not recognized, despite expenses being recorded, and revenues were excluded even though costs of goods sold were included. Cause: The deficiency stemmed from inadequate internal controls and procedures for accruing revenues and receivables, reflecting a failure to adhere to proper revenue recognition practices. Possible or Known Effect: While the adjustments required were not material, they were significant and warrant the attention of those charged with governance. Improper accrual of revenues could mislead financial statement users and impact financial decision-making. Questioned Costs: There are no specific questioned costs identified in this finding. The issue pertains to revenue recognition practices rather than direct disallowed costs. Repeat Finding: This finding is not a repeat finding from the prior year. Recommendation: It is recommended that the organization improve its internal controls and procedures for accruing revenues. This should involve refining procedures for recognizing revenues from reimbursement-based grants and sales of supplies, enhancing staff training on GAAP revenue recognition, and regularly reviewing and reconciling accrued revenues and receivables to ensure they are recorded in the correct period. Significant discrepancies should be reviewed by those charged with governance to ensure timely resolution. Views of Responsible Officials: The Organizations’ Board and Executive Team consisting of the Chief Executive Officer (CEO) and the Chief Operating Officer (COO) and key Overdose Lifeline (ODL) Staff to include the independent bookkeeper and Grant and Finance Manager recognize the need to further refine the internal controls and procedures for accruing revenues. This will be accomplished through the completion of a formal course that covers performing a single audit and consultation with the Independent Public Accounting Firm (Pile CPAs) Additionally staff will regularly meet with the independent bookkeeper to review and reconcile accrued revenues ands receivables.
Finding 2023-001 Accounting for Prepaid Expenses Type of Finding: Material Weakness in Internal Control over Financial Reporting Criteria: According to accounting principles generally accepted in the United States of America ("GAAP"), an organization must have effective internal controls over accounting for prepaid expenses to ensure that transactions are recorded in the correct accounting period. This includes properly accounting for the timing of the receipt of prepaid supplies. Condition: Invoices for prepaid supplies were included in accounts payable for supplies that were not received in the same period. This resulted in an overstatement of expenses related to the prepaid supplies, as the expenses were not properly matched with the periods in which the supplies were actually received and used. Cause: The underlying cause of the condition was a failure to account for the timing of receipt for the supplies. This indicates a deficiency in the internal controls and procedures related to the recording of prepaid expenses. Possible or Known Effect: The effect of this condition was an overstatement of expenses, which could potentially mislead financial statement users and impact decision-making. This could also lead to inaccurate financial reporting and potential non-compliance with federal grant requirements. Questioned Costs: There are no specific questioned costs identified in this finding as the overstatement impacts the accuracy of financial reporting rather than a direct disallowed cost. However, the overstatement of expenses may affect the accuracy of financial statements and compliance with grant terms. Repeat Finding: This finding is not a repeat finding from the prior year. Recommendation: It is recommended that the organization implement a corrective action plan to address the internal control deficiencies identified. This plan should focus on revising procedures to ensure that prepaid supplies are accurately recorded in the period in which they are received. Additionally, enhancing training for staff involved in accounting for prepaid expenses will help ensure proper understanding and execution of these procedures. Regular reviews and reconciliations of accounts payable and prepaid supplies records should be conducted to prevent similar issues in the future. Finally, performing periodic audits of internal controls will help ensure ongoing compliance with accounting standards and grant requirements. Views of Responsible Officials: The Organizations’ Board and Executive Team consisting of the Chief Executive Officer (CEO) and the Chief Operating Officer (COO) and key Overdose Lifeline (ODL) Staff to include the independent bookkeeper and Grant and Finance Manager recognize the internal control deficiencies identified during the year 2023. As noted by the Independent Public Accounting Firm (Pile CPAs) significant improvements have occurred and in the first half of 2024 ODL implemented a new inventory accounting process through QuickBooks. This finding is addressed through this new accounting process. Overdose Lifeline moved from tracking inventory manually in excel spreadsheets to utilizing inventory management in Quickbooks Online (QBO). The process is: - Receipts: Once inventory is physically received, a QBO bill is entered identifying the quantity and cost of the items. - Shipments: Shipments are reflected on a weekly basis identifying the items and quantity shipped per item on a zero-dollar invoice. QBO utilizes FIFO (First In/First Out) methodology for inventory valuation. The physical inventory is reconciled to the QBO inventory counts monthly. Additionally the Grants and Finance Manager, Executive Team and other key personnel will conduct periodic audits of internal controls.
Finding 2023-002 Schedule of Expenditures of Federal Awards Preparation Type of Finding: Significant Deficiency over Financial Reporting. Criteria: Federal regulations and GAAP require the preparation of a comprehensive and accurate Schedule of Expenditures of Federal Awards ("SEFA"), which includes transparent disclosure of federal funds expended, including the source of funds, program titles, award numbers, and expenditure amounts. Condition: This year’s audit revealed significant improvements in the Organization’s SEFA preparation. The SEFA now more accurately reflects federal awards received and expended, and there have been enhancements in documenting award numbers, funding sources, and program titles. However, some inaccuracies and omissions persist, impacting the completeness and reliability of the SEFA. Cause: Ongoing gaps in the skills, knowledge, and experience of personnel responsible for SEFA preparation and reporting contribute to the persistence of some inaccuracies. Continued deficiencies in training and procedural adherence are factors in these issues. Possible or Known Effect: While improvements have mitigated the risk of misrepresentation, the remaining discrepancies could still lead to misinterpretation of federal funds received and expended. This could affect the Organization’s compliance with federal reporting requirements and potentially impact eligibility for future federal funding. Questioned Costs: There were no questioned costs identified. Repeat Finding: This finding is a repeat from the prior year. The previous finding number was 2022-002. Recommendation: Management should continue to build on recent improvements by further refining SEFA preparation processes. Enhanced controls should be implemented to ensure complete and accurate recording of federal awards and expenditures. Ongoing training for financial reporting personnel should be sustained, addressing remaining knowledge gaps and procedural issues. Documented procedures should be reviewed and updated regularly to ensure adherence to best practices and continuous improvement in SEFA preparation. Views of Responsible Officials: The Organizations’ Board and Executive Team consisting of the Chief Executive Officer (CEO) and the Chief Operating Officer (COO) and key Overdose Lifeline (ODL) Staff to include the independent bookkeeper and Grant and Finance Manager recognize the need to further refine the SEFA preparation process. This will be accomplished through the completion of a formal course that covers performing a single audit and consultation with the Independent Public Accounting Firm (Pile CPAs).
Finding 2023-004 Accounting for Revenues and Accrued Receivables Type of Finding: Significant Deficiency in Internal Control over Financial Reporting Criteria: According to Generally Accepted Accounting Principles (GAAP), revenues must be recorded in the period in which they are earned, even if the claims or payments are received in a subsequent period. Condition: Revenues earned during the fiscal year but claimed in the following fiscal year were inconsistently accrued as receivables. Specifically, revenues related to reimbursement-based grants were not recognized, despite expenses being recorded, and revenues were excluded even though costs of goods sold were included. Cause: The deficiency stemmed from inadequate internal controls and procedures for accruing revenues and receivables, reflecting a failure to adhere to proper revenue recognition practices. Possible or Known Effect: While the adjustments required were not material, they were significant and warrant the attention of those charged with governance. Improper accrual of revenues could mislead financial statement users and impact financial decision-making. Questioned Costs: There are no specific questioned costs identified in this finding. The issue pertains to revenue recognition practices rather than direct disallowed costs. Repeat Finding: This finding is not a repeat finding from the prior year. Recommendation: It is recommended that the organization improve its internal controls and procedures for accruing revenues. This should involve refining procedures for recognizing revenues from reimbursement-based grants and sales of supplies, enhancing staff training on GAAP revenue recognition, and regularly reviewing and reconciling accrued revenues and receivables to ensure they are recorded in the correct period. Significant discrepancies should be reviewed by those charged with governance to ensure timely resolution. Views of Responsible Officials: The Organizations’ Board and Executive Team consisting of the Chief Executive Officer (CEO) and the Chief Operating Officer (COO) and key Overdose Lifeline (ODL) Staff to include the independent bookkeeper and Grant and Finance Manager recognize the need to further refine the internal controls and procedures for accruing revenues. This will be accomplished through the completion of a formal course that covers performing a single audit and consultation with the Independent Public Accounting Firm (Pile CPAs) Additionally staff will regularly meet with the independent bookkeeper to review and reconcile accrued revenues ands receivables.
Finding 2023-001 Accounting for Prepaid Expenses Type of Finding: Material Weakness in Internal Control over Financial Reporting Criteria: According to accounting principles generally accepted in the United States of America ("GAAP"), an organization must have effective internal controls over accounting for prepaid expenses to ensure that transactions are recorded in the correct accounting period. This includes properly accounting for the timing of the receipt of prepaid supplies. Condition: Invoices for prepaid supplies were included in accounts payable for supplies that were not received in the same period. This resulted in an overstatement of expenses related to the prepaid supplies, as the expenses were not properly matched with the periods in which the supplies were actually received and used. Cause: The underlying cause of the condition was a failure to account for the timing of receipt for the supplies. This indicates a deficiency in the internal controls and procedures related to the recording of prepaid expenses. Possible or Known Effect: The effect of this condition was an overstatement of expenses, which could potentially mislead financial statement users and impact decision-making. This could also lead to inaccurate financial reporting and potential non-compliance with federal grant requirements. Questioned Costs: There are no specific questioned costs identified in this finding as the overstatement impacts the accuracy of financial reporting rather than a direct disallowed cost. However, the overstatement of expenses may affect the accuracy of financial statements and compliance with grant terms. Repeat Finding: This finding is not a repeat finding from the prior year. Recommendation: It is recommended that the organization implement a corrective action plan to address the internal control deficiencies identified. This plan should focus on revising procedures to ensure that prepaid supplies are accurately recorded in the period in which they are received. Additionally, enhancing training for staff involved in accounting for prepaid expenses will help ensure proper understanding and execution of these procedures. Regular reviews and reconciliations of accounts payable and prepaid supplies records should be conducted to prevent similar issues in the future. Finally, performing periodic audits of internal controls will help ensure ongoing compliance with accounting standards and grant requirements. Views of Responsible Officials: The Organizations’ Board and Executive Team consisting of the Chief Executive Officer (CEO) and the Chief Operating Officer (COO) and key Overdose Lifeline (ODL) Staff to include the independent bookkeeper and Grant and Finance Manager recognize the internal control deficiencies identified during the year 2023. As noted by the Independent Public Accounting Firm (Pile CPAs) significant improvements have occurred and in the first half of 2024 ODL implemented a new inventory accounting process through QuickBooks. This finding is addressed through this new accounting process. Overdose Lifeline moved from tracking inventory manually in excel spreadsheets to utilizing inventory management in Quickbooks Online (QBO). The process is: - Receipts: Once inventory is physically received, a QBO bill is entered identifying the quantity and cost of the items. - Shipments: Shipments are reflected on a weekly basis identifying the items and quantity shipped per item on a zero-dollar invoice. QBO utilizes FIFO (First In/First Out) methodology for inventory valuation. The physical inventory is reconciled to the QBO inventory counts monthly. Additionally the Grants and Finance Manager, Executive Team and other key personnel will conduct periodic audits of internal controls.
Finding 2023-002 Schedule of Expenditures of Federal Awards Preparation Type of Finding: Significant Deficiency over Financial Reporting. Criteria: Federal regulations and GAAP require the preparation of a comprehensive and accurate Schedule of Expenditures of Federal Awards ("SEFA"), which includes transparent disclosure of federal funds expended, including the source of funds, program titles, award numbers, and expenditure amounts. Condition: This year’s audit revealed significant improvements in the Organization’s SEFA preparation. The SEFA now more accurately reflects federal awards received and expended, and there have been enhancements in documenting award numbers, funding sources, and program titles. However, some inaccuracies and omissions persist, impacting the completeness and reliability of the SEFA. Cause: Ongoing gaps in the skills, knowledge, and experience of personnel responsible for SEFA preparation and reporting contribute to the persistence of some inaccuracies. Continued deficiencies in training and procedural adherence are factors in these issues. Possible or Known Effect: While improvements have mitigated the risk of misrepresentation, the remaining discrepancies could still lead to misinterpretation of federal funds received and expended. This could affect the Organization’s compliance with federal reporting requirements and potentially impact eligibility for future federal funding. Questioned Costs: There were no questioned costs identified. Repeat Finding: This finding is a repeat from the prior year. The previous finding number was 2022-002. Recommendation: Management should continue to build on recent improvements by further refining SEFA preparation processes. Enhanced controls should be implemented to ensure complete and accurate recording of federal awards and expenditures. Ongoing training for financial reporting personnel should be sustained, addressing remaining knowledge gaps and procedural issues. Documented procedures should be reviewed and updated regularly to ensure adherence to best practices and continuous improvement in SEFA preparation. Views of Responsible Officials: The Organizations’ Board and Executive Team consisting of the Chief Executive Officer (CEO) and the Chief Operating Officer (COO) and key Overdose Lifeline (ODL) Staff to include the independent bookkeeper and Grant and Finance Manager recognize the need to further refine the SEFA preparation process. This will be accomplished through the completion of a formal course that covers performing a single audit and consultation with the Independent Public Accounting Firm (Pile CPAs).
Finding 2023-004 Accounting for Revenues and Accrued Receivables Type of Finding: Significant Deficiency in Internal Control over Financial Reporting Criteria: According to Generally Accepted Accounting Principles (GAAP), revenues must be recorded in the period in which they are earned, even if the claims or payments are received in a subsequent period. Condition: Revenues earned during the fiscal year but claimed in the following fiscal year were inconsistently accrued as receivables. Specifically, revenues related to reimbursement-based grants were not recognized, despite expenses being recorded, and revenues were excluded even though costs of goods sold were included. Cause: The deficiency stemmed from inadequate internal controls and procedures for accruing revenues and receivables, reflecting a failure to adhere to proper revenue recognition practices. Possible or Known Effect: While the adjustments required were not material, they were significant and warrant the attention of those charged with governance. Improper accrual of revenues could mislead financial statement users and impact financial decision-making. Questioned Costs: There are no specific questioned costs identified in this finding. The issue pertains to revenue recognition practices rather than direct disallowed costs. Repeat Finding: This finding is not a repeat finding from the prior year. Recommendation: It is recommended that the organization improve its internal controls and procedures for accruing revenues. This should involve refining procedures for recognizing revenues from reimbursement-based grants and sales of supplies, enhancing staff training on GAAP revenue recognition, and regularly reviewing and reconciling accrued revenues and receivables to ensure they are recorded in the correct period. Significant discrepancies should be reviewed by those charged with governance to ensure timely resolution. Views of Responsible Officials: The Organizations’ Board and Executive Team consisting of the Chief Executive Officer (CEO) and the Chief Operating Officer (COO) and key Overdose Lifeline (ODL) Staff to include the independent bookkeeper and Grant and Finance Manager recognize the need to further refine the internal controls and procedures for accruing revenues. This will be accomplished through the completion of a formal course that covers performing a single audit and consultation with the Independent Public Accounting Firm (Pile CPAs) Additionally staff will regularly meet with the independent bookkeeper to review and reconcile accrued revenues ands receivables.
Finding 2023-001 Accounting for Prepaid Expenses Type of Finding: Material Weakness in Internal Control over Financial Reporting Criteria: According to accounting principles generally accepted in the United States of America ("GAAP"), an organization must have effective internal controls over accounting for prepaid expenses to ensure that transactions are recorded in the correct accounting period. This includes properly accounting for the timing of the receipt of prepaid supplies. Condition: Invoices for prepaid supplies were included in accounts payable for supplies that were not received in the same period. This resulted in an overstatement of expenses related to the prepaid supplies, as the expenses were not properly matched with the periods in which the supplies were actually received and used. Cause: The underlying cause of the condition was a failure to account for the timing of receipt for the supplies. This indicates a deficiency in the internal controls and procedures related to the recording of prepaid expenses. Possible or Known Effect: The effect of this condition was an overstatement of expenses, which could potentially mislead financial statement users and impact decision-making. This could also lead to inaccurate financial reporting and potential non-compliance with federal grant requirements. Questioned Costs: There are no specific questioned costs identified in this finding as the overstatement impacts the accuracy of financial reporting rather than a direct disallowed cost. However, the overstatement of expenses may affect the accuracy of financial statements and compliance with grant terms. Repeat Finding: This finding is not a repeat finding from the prior year. Recommendation: It is recommended that the organization implement a corrective action plan to address the internal control deficiencies identified. This plan should focus on revising procedures to ensure that prepaid supplies are accurately recorded in the period in which they are received. Additionally, enhancing training for staff involved in accounting for prepaid expenses will help ensure proper understanding and execution of these procedures. Regular reviews and reconciliations of accounts payable and prepaid supplies records should be conducted to prevent similar issues in the future. Finally, performing periodic audits of internal controls will help ensure ongoing compliance with accounting standards and grant requirements. Views of Responsible Officials: The Organizations’ Board and Executive Team consisting of the Chief Executive Officer (CEO) and the Chief Operating Officer (COO) and key Overdose Lifeline (ODL) Staff to include the independent bookkeeper and Grant and Finance Manager recognize the internal control deficiencies identified during the year 2023. As noted by the Independent Public Accounting Firm (Pile CPAs) significant improvements have occurred and in the first half of 2024 ODL implemented a new inventory accounting process through QuickBooks. This finding is addressed through this new accounting process. Overdose Lifeline moved from tracking inventory manually in excel spreadsheets to utilizing inventory management in Quickbooks Online (QBO). The process is: - Receipts: Once inventory is physically received, a QBO bill is entered identifying the quantity and cost of the items. - Shipments: Shipments are reflected on a weekly basis identifying the items and quantity shipped per item on a zero-dollar invoice. QBO utilizes FIFO (First In/First Out) methodology for inventory valuation. The physical inventory is reconciled to the QBO inventory counts monthly. Additionally the Grants and Finance Manager, Executive Team and other key personnel will conduct periodic audits of internal controls.
Finding 2023-002 Schedule of Expenditures of Federal Awards Preparation Type of Finding: Significant Deficiency over Financial Reporting. Criteria: Federal regulations and GAAP require the preparation of a comprehensive and accurate Schedule of Expenditures of Federal Awards ("SEFA"), which includes transparent disclosure of federal funds expended, including the source of funds, program titles, award numbers, and expenditure amounts. Condition: This year’s audit revealed significant improvements in the Organization’s SEFA preparation. The SEFA now more accurately reflects federal awards received and expended, and there have been enhancements in documenting award numbers, funding sources, and program titles. However, some inaccuracies and omissions persist, impacting the completeness and reliability of the SEFA. Cause: Ongoing gaps in the skills, knowledge, and experience of personnel responsible for SEFA preparation and reporting contribute to the persistence of some inaccuracies. Continued deficiencies in training and procedural adherence are factors in these issues. Possible or Known Effect: While improvements have mitigated the risk of misrepresentation, the remaining discrepancies could still lead to misinterpretation of federal funds received and expended. This could affect the Organization’s compliance with federal reporting requirements and potentially impact eligibility for future federal funding. Questioned Costs: There were no questioned costs identified. Repeat Finding: This finding is a repeat from the prior year. The previous finding number was 2022-002. Recommendation: Management should continue to build on recent improvements by further refining SEFA preparation processes. Enhanced controls should be implemented to ensure complete and accurate recording of federal awards and expenditures. Ongoing training for financial reporting personnel should be sustained, addressing remaining knowledge gaps and procedural issues. Documented procedures should be reviewed and updated regularly to ensure adherence to best practices and continuous improvement in SEFA preparation. Views of Responsible Officials: The Organizations’ Board and Executive Team consisting of the Chief Executive Officer (CEO) and the Chief Operating Officer (COO) and key Overdose Lifeline (ODL) Staff to include the independent bookkeeper and Grant and Finance Manager recognize the need to further refine the SEFA preparation process. This will be accomplished through the completion of a formal course that covers performing a single audit and consultation with the Independent Public Accounting Firm (Pile CPAs).
Finding 2023-004 Accounting for Revenues and Accrued Receivables Type of Finding: Significant Deficiency in Internal Control over Financial Reporting Criteria: According to Generally Accepted Accounting Principles (GAAP), revenues must be recorded in the period in which they are earned, even if the claims or payments are received in a subsequent period. Condition: Revenues earned during the fiscal year but claimed in the following fiscal year were inconsistently accrued as receivables. Specifically, revenues related to reimbursement-based grants were not recognized, despite expenses being recorded, and revenues were excluded even though costs of goods sold were included. Cause: The deficiency stemmed from inadequate internal controls and procedures for accruing revenues and receivables, reflecting a failure to adhere to proper revenue recognition practices. Possible or Known Effect: While the adjustments required were not material, they were significant and warrant the attention of those charged with governance. Improper accrual of revenues could mislead financial statement users and impact financial decision-making. Questioned Costs: There are no specific questioned costs identified in this finding. The issue pertains to revenue recognition practices rather than direct disallowed costs. Repeat Finding: This finding is not a repeat finding from the prior year. Recommendation: It is recommended that the organization improve its internal controls and procedures for accruing revenues. This should involve refining procedures for recognizing revenues from reimbursement-based grants and sales of supplies, enhancing staff training on GAAP revenue recognition, and regularly reviewing and reconciling accrued revenues and receivables to ensure they are recorded in the correct period. Significant discrepancies should be reviewed by those charged with governance to ensure timely resolution. Views of Responsible Officials: The Organizations’ Board and Executive Team consisting of the Chief Executive Officer (CEO) and the Chief Operating Officer (COO) and key Overdose Lifeline (ODL) Staff to include the independent bookkeeper and Grant and Finance Manager recognize the need to further refine the internal controls and procedures for accruing revenues. This will be accomplished through the completion of a formal course that covers performing a single audit and consultation with the Independent Public Accounting Firm (Pile CPAs) Additionally staff will regularly meet with the independent bookkeeper to review and reconcile accrued revenues ands receivables.
Finding 2023-001 Accounting for Prepaid Expenses Type of Finding: Material Weakness in Internal Control over Financial Reporting Criteria: According to accounting principles generally accepted in the United States of America ("GAAP"), an organization must have effective internal controls over accounting for prepaid expenses to ensure that transactions are recorded in the correct accounting period. This includes properly accounting for the timing of the receipt of prepaid supplies. Condition: Invoices for prepaid supplies were included in accounts payable for supplies that were not received in the same period. This resulted in an overstatement of expenses related to the prepaid supplies, as the expenses were not properly matched with the periods in which the supplies were actually received and used. Cause: The underlying cause of the condition was a failure to account for the timing of receipt for the supplies. This indicates a deficiency in the internal controls and procedures related to the recording of prepaid expenses. Possible or Known Effect: The effect of this condition was an overstatement of expenses, which could potentially mislead financial statement users and impact decision-making. This could also lead to inaccurate financial reporting and potential non-compliance with federal grant requirements. Questioned Costs: There are no specific questioned costs identified in this finding as the overstatement impacts the accuracy of financial reporting rather than a direct disallowed cost. However, the overstatement of expenses may affect the accuracy of financial statements and compliance with grant terms. Repeat Finding: This finding is not a repeat finding from the prior year. Recommendation: It is recommended that the organization implement a corrective action plan to address the internal control deficiencies identified. This plan should focus on revising procedures to ensure that prepaid supplies are accurately recorded in the period in which they are received. Additionally, enhancing training for staff involved in accounting for prepaid expenses will help ensure proper understanding and execution of these procedures. Regular reviews and reconciliations of accounts payable and prepaid supplies records should be conducted to prevent similar issues in the future. Finally, performing periodic audits of internal controls will help ensure ongoing compliance with accounting standards and grant requirements. Views of Responsible Officials: The Organizations’ Board and Executive Team consisting of the Chief Executive Officer (CEO) and the Chief Operating Officer (COO) and key Overdose Lifeline (ODL) Staff to include the independent bookkeeper and Grant and Finance Manager recognize the internal control deficiencies identified during the year 2023. As noted by the Independent Public Accounting Firm (Pile CPAs) significant improvements have occurred and in the first half of 2024 ODL implemented a new inventory accounting process through QuickBooks. This finding is addressed through this new accounting process. Overdose Lifeline moved from tracking inventory manually in excel spreadsheets to utilizing inventory management in Quickbooks Online (QBO). The process is: - Receipts: Once inventory is physically received, a QBO bill is entered identifying the quantity and cost of the items. - Shipments: Shipments are reflected on a weekly basis identifying the items and quantity shipped per item on a zero-dollar invoice. QBO utilizes FIFO (First In/First Out) methodology for inventory valuation. The physical inventory is reconciled to the QBO inventory counts monthly. Additionally the Grants and Finance Manager, Executive Team and other key personnel will conduct periodic audits of internal controls.
Finding 2023-002 Schedule of Expenditures of Federal Awards Preparation Type of Finding: Significant Deficiency over Financial Reporting. Criteria: Federal regulations and GAAP require the preparation of a comprehensive and accurate Schedule of Expenditures of Federal Awards ("SEFA"), which includes transparent disclosure of federal funds expended, including the source of funds, program titles, award numbers, and expenditure amounts. Condition: This year’s audit revealed significant improvements in the Organization’s SEFA preparation. The SEFA now more accurately reflects federal awards received and expended, and there have been enhancements in documenting award numbers, funding sources, and program titles. However, some inaccuracies and omissions persist, impacting the completeness and reliability of the SEFA. Cause: Ongoing gaps in the skills, knowledge, and experience of personnel responsible for SEFA preparation and reporting contribute to the persistence of some inaccuracies. Continued deficiencies in training and procedural adherence are factors in these issues. Possible or Known Effect: While improvements have mitigated the risk of misrepresentation, the remaining discrepancies could still lead to misinterpretation of federal funds received and expended. This could affect the Organization’s compliance with federal reporting requirements and potentially impact eligibility for future federal funding. Questioned Costs: There were no questioned costs identified. Repeat Finding: This finding is a repeat from the prior year. The previous finding number was 2022-002. Recommendation: Management should continue to build on recent improvements by further refining SEFA preparation processes. Enhanced controls should be implemented to ensure complete and accurate recording of federal awards and expenditures. Ongoing training for financial reporting personnel should be sustained, addressing remaining knowledge gaps and procedural issues. Documented procedures should be reviewed and updated regularly to ensure adherence to best practices and continuous improvement in SEFA preparation. Views of Responsible Officials: The Organizations’ Board and Executive Team consisting of the Chief Executive Officer (CEO) and the Chief Operating Officer (COO) and key Overdose Lifeline (ODL) Staff to include the independent bookkeeper and Grant and Finance Manager recognize the need to further refine the SEFA preparation process. This will be accomplished through the completion of a formal course that covers performing a single audit and consultation with the Independent Public Accounting Firm (Pile CPAs).
Finding 2023-004 Accounting for Revenues and Accrued Receivables Type of Finding: Significant Deficiency in Internal Control over Financial Reporting Criteria: According to Generally Accepted Accounting Principles (GAAP), revenues must be recorded in the period in which they are earned, even if the claims or payments are received in a subsequent period. Condition: Revenues earned during the fiscal year but claimed in the following fiscal year were inconsistently accrued as receivables. Specifically, revenues related to reimbursement-based grants were not recognized, despite expenses being recorded, and revenues were excluded even though costs of goods sold were included. Cause: The deficiency stemmed from inadequate internal controls and procedures for accruing revenues and receivables, reflecting a failure to adhere to proper revenue recognition practices. Possible or Known Effect: While the adjustments required were not material, they were significant and warrant the attention of those charged with governance. Improper accrual of revenues could mislead financial statement users and impact financial decision-making. Questioned Costs: There are no specific questioned costs identified in this finding. The issue pertains to revenue recognition practices rather than direct disallowed costs. Repeat Finding: This finding is not a repeat finding from the prior year. Recommendation: It is recommended that the organization improve its internal controls and procedures for accruing revenues. This should involve refining procedures for recognizing revenues from reimbursement-based grants and sales of supplies, enhancing staff training on GAAP revenue recognition, and regularly reviewing and reconciling accrued revenues and receivables to ensure they are recorded in the correct period. Significant discrepancies should be reviewed by those charged with governance to ensure timely resolution. Views of Responsible Officials: The Organizations’ Board and Executive Team consisting of the Chief Executive Officer (CEO) and the Chief Operating Officer (COO) and key Overdose Lifeline (ODL) Staff to include the independent bookkeeper and Grant and Finance Manager recognize the need to further refine the internal controls and procedures for accruing revenues. This will be accomplished through the completion of a formal course that covers performing a single audit and consultation with the Independent Public Accounting Firm (Pile CPAs) Additionally staff will regularly meet with the independent bookkeeper to review and reconcile accrued revenues ands receivables.
Finding 2023-001 Accounting for Prepaid Expenses Type of Finding: Material Weakness in Internal Control over Financial Reporting Criteria: According to accounting principles generally accepted in the United States of America ("GAAP"), an organization must have effective internal controls over accounting for prepaid expenses to ensure that transactions are recorded in the correct accounting period. This includes properly accounting for the timing of the receipt of prepaid supplies. Condition: Invoices for prepaid supplies were included in accounts payable for supplies that were not received in the same period. This resulted in an overstatement of expenses related to the prepaid supplies, as the expenses were not properly matched with the periods in which the supplies were actually received and used. Cause: The underlying cause of the condition was a failure to account for the timing of receipt for the supplies. This indicates a deficiency in the internal controls and procedures related to the recording of prepaid expenses. Possible or Known Effect: The effect of this condition was an overstatement of expenses, which could potentially mislead financial statement users and impact decision-making. This could also lead to inaccurate financial reporting and potential non-compliance with federal grant requirements. Questioned Costs: There are no specific questioned costs identified in this finding as the overstatement impacts the accuracy of financial reporting rather than a direct disallowed cost. However, the overstatement of expenses may affect the accuracy of financial statements and compliance with grant terms. Repeat Finding: This finding is not a repeat finding from the prior year. Recommendation: It is recommended that the organization implement a corrective action plan to address the internal control deficiencies identified. This plan should focus on revising procedures to ensure that prepaid supplies are accurately recorded in the period in which they are received. Additionally, enhancing training for staff involved in accounting for prepaid expenses will help ensure proper understanding and execution of these procedures. Regular reviews and reconciliations of accounts payable and prepaid supplies records should be conducted to prevent similar issues in the future. Finally, performing periodic audits of internal controls will help ensure ongoing compliance with accounting standards and grant requirements. Views of Responsible Officials: The Organizations’ Board and Executive Team consisting of the Chief Executive Officer (CEO) and the Chief Operating Officer (COO) and key Overdose Lifeline (ODL) Staff to include the independent bookkeeper and Grant and Finance Manager recognize the internal control deficiencies identified during the year 2023. As noted by the Independent Public Accounting Firm (Pile CPAs) significant improvements have occurred and in the first half of 2024 ODL implemented a new inventory accounting process through QuickBooks. This finding is addressed through this new accounting process. Overdose Lifeline moved from tracking inventory manually in excel spreadsheets to utilizing inventory management in Quickbooks Online (QBO). The process is: - Receipts: Once inventory is physically received, a QBO bill is entered identifying the quantity and cost of the items. - Shipments: Shipments are reflected on a weekly basis identifying the items and quantity shipped per item on a zero-dollar invoice. QBO utilizes FIFO (First In/First Out) methodology for inventory valuation. The physical inventory is reconciled to the QBO inventory counts monthly. Additionally the Grants and Finance Manager, Executive Team and other key personnel will conduct periodic audits of internal controls.
Finding 2023-002 Schedule of Expenditures of Federal Awards Preparation Type of Finding: Significant Deficiency over Financial Reporting. Criteria: Federal regulations and GAAP require the preparation of a comprehensive and accurate Schedule of Expenditures of Federal Awards ("SEFA"), which includes transparent disclosure of federal funds expended, including the source of funds, program titles, award numbers, and expenditure amounts. Condition: This year’s audit revealed significant improvements in the Organization’s SEFA preparation. The SEFA now more accurately reflects federal awards received and expended, and there have been enhancements in documenting award numbers, funding sources, and program titles. However, some inaccuracies and omissions persist, impacting the completeness and reliability of the SEFA. Cause: Ongoing gaps in the skills, knowledge, and experience of personnel responsible for SEFA preparation and reporting contribute to the persistence of some inaccuracies. Continued deficiencies in training and procedural adherence are factors in these issues. Possible or Known Effect: While improvements have mitigated the risk of misrepresentation, the remaining discrepancies could still lead to misinterpretation of federal funds received and expended. This could affect the Organization’s compliance with federal reporting requirements and potentially impact eligibility for future federal funding. Questioned Costs: There were no questioned costs identified. Repeat Finding: This finding is a repeat from the prior year. The previous finding number was 2022-002. Recommendation: Management should continue to build on recent improvements by further refining SEFA preparation processes. Enhanced controls should be implemented to ensure complete and accurate recording of federal awards and expenditures. Ongoing training for financial reporting personnel should be sustained, addressing remaining knowledge gaps and procedural issues. Documented procedures should be reviewed and updated regularly to ensure adherence to best practices and continuous improvement in SEFA preparation. Views of Responsible Officials: The Organizations’ Board and Executive Team consisting of the Chief Executive Officer (CEO) and the Chief Operating Officer (COO) and key Overdose Lifeline (ODL) Staff to include the independent bookkeeper and Grant and Finance Manager recognize the need to further refine the SEFA preparation process. This will be accomplished through the completion of a formal course that covers performing a single audit and consultation with the Independent Public Accounting Firm (Pile CPAs).
Finding 2023-004 Accounting for Revenues and Accrued Receivables Type of Finding: Significant Deficiency in Internal Control over Financial Reporting Criteria: According to Generally Accepted Accounting Principles (GAAP), revenues must be recorded in the period in which they are earned, even if the claims or payments are received in a subsequent period. Condition: Revenues earned during the fiscal year but claimed in the following fiscal year were inconsistently accrued as receivables. Specifically, revenues related to reimbursement-based grants were not recognized, despite expenses being recorded, and revenues were excluded even though costs of goods sold were included. Cause: The deficiency stemmed from inadequate internal controls and procedures for accruing revenues and receivables, reflecting a failure to adhere to proper revenue recognition practices. Possible or Known Effect: While the adjustments required were not material, they were significant and warrant the attention of those charged with governance. Improper accrual of revenues could mislead financial statement users and impact financial decision-making. Questioned Costs: There are no specific questioned costs identified in this finding. The issue pertains to revenue recognition practices rather than direct disallowed costs. Repeat Finding: This finding is not a repeat finding from the prior year. Recommendation: It is recommended that the organization improve its internal controls and procedures for accruing revenues. This should involve refining procedures for recognizing revenues from reimbursement-based grants and sales of supplies, enhancing staff training on GAAP revenue recognition, and regularly reviewing and reconciling accrued revenues and receivables to ensure they are recorded in the correct period. Significant discrepancies should be reviewed by those charged with governance to ensure timely resolution. Views of Responsible Officials: The Organizations’ Board and Executive Team consisting of the Chief Executive Officer (CEO) and the Chief Operating Officer (COO) and key Overdose Lifeline (ODL) Staff to include the independent bookkeeper and Grant and Finance Manager recognize the need to further refine the internal controls and procedures for accruing revenues. This will be accomplished through the completion of a formal course that covers performing a single audit and consultation with the Independent Public Accounting Firm (Pile CPAs) Additionally staff will regularly meet with the independent bookkeeper to review and reconcile accrued revenues ands receivables.