Finding 524237 (2023-003)

Significant Deficiency Repeat Finding
Requirement
ABCEGHLN
Questioned Costs
-
Year
2023
Accepted
2025-02-21

AI Summary

  • Core Issue: Duties related to financial transactions are overly concentrated among a few individuals, increasing the risk of errors or fraud.
  • Impacted Requirements: Internal controls for proper segregation of duties are inadequate, which is essential for effective transaction management.
  • Recommended Follow-Up: The Board and CEO should actively review financial statements and operations to enhance oversight and identify opportunities for better duty separation.

Finding Text

Segregation of Duties Condition: The duties of preparing deposits, investigating discrepancies, maintaining master files, maintaining the general ledger, making deposits, reconciling the bank accounts, investigating problems with payables and resolving inquiries and editing the payroll master file are concentrated in one person's duties. The duties of opening the mail, authorizing write-offs, authorizing and signing checks and authorizing payroll are concentrated in another person's duties. The duties of recording receipts, updating accounts and pledges receivable, initiating checks for expenditure, updating accounts payable and preparing checks are concentrated in another person's duties. The duties of recording receipts, updating accounts and pledge receivable, initiating checks and updating accounts payable are concentrated in another person's duties. The duties of preparing payroll and resolving inquiries and editing payroll master file are concentrated in another person's duties. Criteria: Internal controls should be in place that provide an adequate segregation of duties that separates initiating, processing, recording and reconciling a transaction. Cause: The size of the Organization's accounting staff precludes certain internal controls that would be preferred if staff were large enough to provide optimum segregation of duties. Effect: Without a separation of duties, errors or irregularities can occur and not be discovered in the normal course of business. Recommendation: This deficiency is the result of the limited accounting staff of the Organization. We recommend that the Board and CEO continue active involvement by reviewing operating statements, comparisons to budget, receivables, receipts and disbursements, to add to existing internal controls in the Organization. Response: This will be reviewed and assessed to find where duties can be separated and independently performed within staff.

Corrective Action Plan

Significant Deficiency Finding: Segregation of Duties -Internal controls should be in place that provide an adequate segregation of duties that separates initiating, processing, recording and reconciling a transaction. Questioned Costs None Status Sustained Corrective Action Additional positions/roles will be created or redesigned and implemented so that the duties required involve more participants and would include the following suggested plan: 1. Cash Receipts a. All mail will be opened by the Executive/Administrative Assistant and cash receipts recorded by the Administrative Specialist. b. All other accounts receivables (AR) will be collected by Administrative Specialist and recorded by Executive/Administrative Assistant. c. The cash receipts journal will be totaled by the Chief Financial Officer (CFO), Administrative Specialist will prepare the corresponding deposit and CFO will deposit cash receipts. d. Executive/Administrative Assistant will reconcile the depository bank receipt with the cash receipts journal to verify that all funds are deposited. e. CFO will review AR ledger. f. CEO will authorize write-offs of delinquent accounts. g. CFO will independently investigate AR discrepancies. h. CEO will maintain or authorize AR adjustments. i. Administrative Specialist will edit the AR master file. j. Executive/Administrative Assistant will process customer service calls and CEO will handle complaints. k. CFO will investigate discrepancies or issues related to revenue and CEO will authorize adjustments as needed. I. CFO will reconcile bank accounts. 2. Accounts Payable a. Vendor payments will be initiated by Executive/Ad m in istrative Assista nt. b. Checks will be prepared by Administrative Specialist. c. CEO will review and authorize/sign checks or approve electronic payments. d. Checks $1000 or greater require 2 signatures. The second signer (an Executive Committee member of the Board of Directors) will also review and authorize/sign checks or approve electronic payments. e. Executive/Administrative Assistant will mail checks. f. Administrative Specialist will edit the vendor master file. g. CFO will investigate discrepancies or issues involving expenditures. h. Executive/Administrative Assistant will open the mail or copy checks received. i. CFO will reconcile bank accounts. 3. Payroll a. Human Resources (HR) Director will prepare payroll checks. b. CEO will sign payroll checks. c. CFO will review and authorize electronic payroll disbursements. d. CFO will resolve employee payroll inquiries. e. HR Director will edit the payroll master file. f. Executive/Administrative Assistant will open the mail or copy checks received. 4. Other a. CFO is required to take 1 full week of vacation a year and will not enter the building for at least 10 days. b. A budget is prepared by CEO/CFO and approved annually by the Operations Committee and the Board of Directors. c. Budget revisions are prepared by CEO/CFO and approved by the Operations Committee and the Board of Directors d. An Income Statement Report is prepared monthly by CFO and reviewed by the CEO, Operations Committee and Board of Directors. e. A Balance Sheet report is prepared quarterly by CFO and reviewed by CEO, Operations Committee and the Board of Directors f. A Budget Variance report is prepared monthly and per department quarterly by CFO, reviewed by CEO, Operations Committee and Board of Directors.

Categories

Internal Control / Segregation of Duties

Other Findings in this Audit

  • 524228 2023-006
    Significant Deficiency
  • 524229 2023-007
    Material Weakness
  • 524230 2023-008
    Material Weakness
  • 524231 2023-006
    Significant Deficiency
  • 524232 2023-007
    Material Weakness
  • 524233 2023-008
    Material Weakness
  • 524234 2023-006
    Significant Deficiency
  • 524235 2023-007
    Material Weakness
  • 524236 2023-008
    Material Weakness
  • 524238 2023-004
    Material Weakness Repeat
  • 524239 2023-005
    Material Weakness Repeat
  • 1100670 2023-006
    Significant Deficiency
  • 1100671 2023-007
    Material Weakness
  • 1100672 2023-008
    Material Weakness
  • 1100673 2023-006
    Significant Deficiency
  • 1100674 2023-007
    Material Weakness
  • 1100675 2023-008
    Material Weakness
  • 1100676 2023-006
    Significant Deficiency
  • 1100677 2023-007
    Material Weakness
  • 1100678 2023-008
    Material Weakness
  • 1100679 2023-003
    Significant Deficiency Repeat
  • 1100680 2023-004
    Material Weakness Repeat
  • 1100681 2023-005
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
16.575 Crime Victim Assistance $656,735
93.575 Child Care and Development Block Grant $368,953
14.267 Continuum of Care Program $264,221
16.736 Transitional Housing Assistance for Victims of Domestic Violence, Dating Violence, Stalking, Or Sexual Assault $134,001
16.540 Juvenile Justice and Delinquency Prevention $99,533
14.218 Community Development Block Grants/entitlement Grants $64,600
10.558 Child and Adult Care Food Program $52,202
93.671 Family Violence Prevention and Services/domestic Violence Shelter and Supportive Services $51,526
93.558 Temporary Assistance for Needy Families $36,717
16.017 Sexual Assault Services Formula Program $17,116
93.497 Family Violence Prevention and Services/ Sexual Assault/rape Crisis Services and Supports $14,490
14.231 Emergency Solutions Grant Program $11,908
16.588 Violence Against Women Formula Grants $9,844
97.024 Emergency Food and Shelter National Board Program $4,425