Exhibit A – University of Maine System Cash Collections Audit Program

Presentation

Exhibit A has a short form followed by text.

Form Fields

  • University
  • Department
  • Location
  • Responsible Manager
  • Authorized Cash Amount
  • Person Responsible for Cash
  • Auditor
  • Date

Text

General Information

  1. Review any prior audit findings and document actions taken to resolve those findings.
  2. Determine cash handling and related procedures by asking the following questions:
    1. For what purpose(s) does the department collect cash?
    2. Who collects and handles the cash, prepares and makes the deposit, and reconciles receipts to amounts deposited per the accounting system?
    3. What is the approximate amount of cash collected annually by the department?
    4. What is the peak cash collection period?
    5. When do personnel restrictively endorse the checks by marking them for deposit only to a University account? (Note: checks should be endorsed upon receipt.)
    6. How are cash collections recorded (i.e., pre-numbered receipt forms, cash register, etc.)?
    7. What are the department’s procedures for making deposits?
    8. How often are cash receipts deposited and to what chartfield combinations are the amounts recorded?
    9. What procedures are used to reconcile the accounting system to cash collections documentation?
    10. If cash collections are posted to another department’s/campus’ chartfield combination, does that department/campus reconcile to the supporting documentation? Has supporting documentation been made available to that department/campus for review?
    11. How is cash kept secure until it is deposited?
    12. Is physical access to cash limited only to personnel responsible for the cash?
    13. Are any loans made out of the funds? If so, to whom and why?
  3. Determine the procedures for reporting shortages and overages.
  4. When did the individuals who handle cash last attend a Cash Management Training session? Agree department’s response to Cash Management Training attendance sheet(s).

Note: Ensure that duties are properly segregated and that other procedures appear adequate for the circumstances. Document any concerns related to the above

Cash Testing

  1. If the department has a change fund, count the cash on hand using the Cash Count Sheet. Reconcile the cash on hand to the authorized amount.
  2. Cash Collections Testing:
    1. For cash register systems, select a minimum sample of five days from various days throughout the year. For those days, compare the register tapes to the deposit receipt(s), other supporting documentation, and to the accounting system. If applicable, compare tape beginning and ending balances to the previous and next day’s balances respectively to ensure completeness.
    2. For manual receipt systems, select a minimum sample of five days. For those days account for the numerical sequence of receipts and note the total cash, checks, and credit card amounts collected. Agree amounts to other original source documents to ensure completeness of funds reported as collected. Further, agree the cash and check amounts to the deposits made with the business office (or bank as applicable). Finally, agree the deposits to the accounting system.

Note results, including timeliness of deposits.

Billing for Goods/Services

  1. Determine whether the department issues invoices. If so, determine:
    1. The invoicing process including what software program is used.
    2. How often bills are generated.
    3. The process used to control invoices (i.e., pre-numbering, retaining copies, etc.).
    4. Who generates the bills.
    5. How uncollected amounts are treated.
    6. Obtain a current aged accounts receivables listing.
    7. If the receivables are recorded in the accounting system.
    8. If duties are properly segregated.

Conclusion

  1. Review observations with the department manager and discuss controls that need to be improved. For material weaknesses, ask management to respond with a written corrective action plan.
  2. Send a summary of the results, as described in APL I-F, to Internal Audit.
  3. Follow up on any open items.

Exhibit B – University of Maine System Cash Count Sheet

Presentation

Exhibit B is a form with five sections.

Section 1 Form Fields

  • Campus
  • Department
  • Cash Custodian
  • Department Location
  • Location $ Amount
  • Total $ Authorized
  • Date
  • Time
  • Auditor

Section 2 Form Fields – Coins

This forms includes space to notate the Quality and Extension of the following fields:

  • Pennies – rolled – value $0.50
  • Pennies – unrolled- value $0.01
  • Nickels – rolled – value $2.00
  • Nickels – unrolled – value $0.05
  • Dimes – rolled – value $5.00
  • Dimes – unrolled – value $0.10
  • Quarters – rolled – value $10.00
  • Quarters – unrolled – value $0.25
  • Halves – rolled – value $10.00
  • Halves – unrolled – value $0.50
  • Dollar – rolled – value N/A
  • Dollar – unrolled – value $1.00

This is followed by space to notate extension of total coins.

Section 3 Form Fields – Bills

This forms includes space to notate the Quality and Extension of the following fields:

  • Ones – pack – value $25.00
  • Ones – single – value $1.00
  • Fives – pack – value $100.00
  • Fives – single – value $5.00
  • Tens – pack – value $100.00
  • Tens – single – value $10.00
  • Twenty – pack – value $100.00
  • Twenty – single – value $20.00
  • Fifty – pack – value $100.00
  • Fifty – single – value $50.00
  • Hundred – pack – value $500.00
  • Hundred – single – value $100.00

This is followed by space to notate extension of total bills.

Section 4 Form Fields

  1. Total cash (coins and bills).
  2. Total Check (attach list including date, maker, amount)
  3. Total Paid Vouchers (attached list including date, payee, amount)
  4. Stamps on Hand (list attached)
  5. TOTAL of Cash, Checks, Paid Vouchers and Stamps (Items 1,2,3 &4)
  6. Less Receipts (per Cash Register or Manual receipts)
  7. Balence
  8. Less Amount Authorized
  9. Balance – Over (Short)

Section 4 Form Fields

Text: “My cash was counted and returned to me intact”

  • Cash Custodian Signature
  • Date

For assistance with this form, please contact 207-581-5491 or emily.bragg@maine.edu.

Back to APL I-F.