- Information
- AI Chat
Audit-Walkthrough-Documentation-Template
Accountancy (Aec 104)
Holy Cross of Davao College
Recommended for you
Related Studylists
MaryPreview text
Audit Area: Revenue Prepared By Project Name: XXXX Cashier’s Office Reviewed By Project Number: XX -XXX W/P Ref. Audit Period: XXX -XXX Page 1 of 10
Audit Procedures: Initials/Date Completed
WPReference/Comments
PLANNINGi
- Establish Audit Scope:ii All revenue collections at the XXXX Cashier’s Office for the period XXX to XXX.
- Establish Audit Objectives:
Financial: To determine existence, completeness, timeliness and accuracy of revenues collected and recorded, and assigned change/petty cash funds. Compliance: To determine whether revenue collection procedures comply with laws, regulations, and University policies. Operations: To determine if the internal control structure is adequate, and whether controls are functioning as designed.
- Administration: A. Assign staff to the audit B. Send the engagement /audit notification letter. C. Prepare the Statement of Independenceiv. D. Conduct and document the entrance conference. E. Conduct and document initial planning meeting(s). Include SAS 99 considerations. F. Initial Fraud Risk Assessmentv. - Prepare Fraud Exposure forms. Document the inherent opportunities for fraud in each process. Also, identify controls in place (preventive & detective).
PRELIMINARY REVIEWvi
Prior Audits : Identify and review any prior audits (internal or external) performed in the last three years related to the auditee.
Cash Count : A. Perform a surprise cash count of all change and petty cash funds (if a count was not performed in the last 6 months). B. Identify and evaluate internal controls over cash collections by: Observing physical safeguards at the facility. Reviewing current day’s revenue documentation and
Audit Area: Revenue Prepared By Project Name: XXXX Cashier’s Office Reviewed By Project Number: XX -XXX W/P Ref. Audit Period: XXX -XXX Page 2 of 10
Audit Procedures: Initials/Date Completed
WPReference/Comments
prior day’s balancing. Review of applicable laws, rules, policies, and procedures. Meeting and discussing operations with management and staff. Determining if incompatible duties are separated. Assessing risk 6. Conduct and document a preliminary issues meeting with the auditee presenting the results of work performed in step 5a & b above.
- Process and Control Documentation : Document processes and controls by performing walkthroughs of transactions. (To the extent possible, use information already obtained in step 5a & b above, updating as necessary). Include process owner names, process risks, identified controls, and other relevant notes. Whenever necessary to understand or document key steps and controls, obtain copies of screens used for data entry or processing, supporting documents used or generated, reports generated or reviewed, and identify required approvals. Consider both hard (control activities) and soft controls (environment, oversight, training).
A. Document processes and controls for the following:
i. Cash and Check Collections & Deposits ii. Credit Card Collections & Deposits
Process documentation for i. and ii. should:
Distinguish between collections received in person, by mail, online (and any other means identified), and
Include the following types of collections (and any others identified):
- Accepting and recording a sealed deposit received from a department.
- Accepting and recording a payment on existing accounts receivable.
- Accepting and recording charges & payments simultaneously.
Audit Area: Revenue Prepared By Project Name: XXXX Cashier’s Office Reviewed By Project Number: XX -XXX W/P Ref. Audit Period: XXX -XXX Page 4 of 10
Audit Procedures: Initials/Date Completed
WPReference/Comments
transactions D. Validation of Completeness for Key fields (use the IsBlank filter)
Perform classification, summarization, and other analysis steps as deemed relevant and meaningful using available fields like user ID/Teller Numbers, Teller Session Numbers, Transaction Types/System Source Codes, Transaction/Receipt Numbers, Transaction Dates/Timestamps, Deposit Numbers, Deposit Dates.
Follow-up on unusual items such as: Gaps or duplicates in sequentially assigned numbers. Unusually large or repetitive amounts. Negative amounts not offset by corresponding positives. Transactions processed outside normal business hours, Gaps or delays in processing activity.
- For any prior audit issues identified in step 4, determine if control weakness previously identified appear to have been remediated based on preliminary review procedures performed.
10 Risk Assessment viii : Prepare an overall preliminary risk assessment which addresses each process or function reviewed. Include in your risk assessment the inherent risk present in the function and the overall mitigated risk of each function or process. Consider financial risk, compliance risk, media/reputation risk, strategic risk, and operational risks. Document all assessments, and draw an overall preliminary risk assessment. 11 on planning procedures performed, tailor testing procedures (if necessary) to meet audit objectives and scope. NOTE: Advance UAC management approval required 12 on planning procedures performed, obtain UAC management approval to adjust initial budgeted hours (if applicable) TESTINGx:
Substantive Testing:
Audit Area: Revenue Prepared By Project Name: XXXX Cashier’s Office Reviewed By Project Number: XX -XXX W/P Ref. Audit Period: XXX -XXX Page 5 of 10
Audit Procedures: Initials/Date Completed
WPReference/Comments
Perform the following testing procedures designed to achieve the following audit objectives: Financial: To determine existence, completeness, timeliness and accuracy of revenues collected and recorded, and assigned change/petty cash funds. Compliance: To determine whether revenue collection procedures comply with laws, regulations, and University policies. Operations: To determine if the internal control structure is adequate, and whether controls are functioning as designed.
- Select a representative sample of collections days from the audit period to trace from initial receipt to deposits recorded by the bank and in the FAST financial records.
For each day selected obtain the BANNER & FAST!! session reports for each user. Also, obtain copies of balancing forms, BANNER & FAST!! sales reports, credit card batch reports, mail logs, deposit slips, and cashier receipts for the collections selected for testing.
Determine if documentation is complete, accurate, properly approved, and sufficient to support revenue collected.
a. For each day selected for sample, tie each user’s BANNER/FAST!! session reports to the BANNER/FAST!! sales reports. Investigate any variances. b. Tie the credit card batch reports to the BANNER/FAST!! sales reports. c. For collections received via mail, tie the mail logs to the BANNER/FAST!! sales reports. d. Tie the BANNER/FAST!! sales reports to the balancing forms. e. Trace the balancing reports to deposit slips. f. Review the deposit slips and determine if state sales tax is collected where applicable and is deposited in the proper account. Agree sales tax amounts. g. Verify overages and shortages (identified on
Audit Area: Revenue Prepared By Project Name: XXXX Cashier’s Office Reviewed By Project Number: XX -XXX W/P Ref. Audit Period: XXX -XXX Page 7 of 10
Audit Procedures: Initials/Date Completed
WPReference/Comments
iv. By total amount c. Perform statistics on amount (highest – lowest)
- Using the ACL analysis performed in step 4 above, assess the materiality of refunds and determine if performance of step 5 is necessary. If deemed necessary, perform the following: Obtain a list of refunds performed during the audit period. Select a representative sample of refunds from the list and determine the following:
A. Reason for refund is properly documented. B. Preparation & review is documented. C. Conclude on all procedures and document weaknesses or unusual transactions
- CLEARING ACCOUNTS: If a clearing account is maintained, obtain the most recent clearing account(s) reconciliation(s). Determine the following:
A. Items are cleared timely. B. Outstanding items are properly documented. C. Preparation & review is documented. D. Conclude on reconciliation process and document any weaknesses.
- CASH RECONCILIATION: Review the most recent cash account reconciliation (from General Accounting). NOTE: Step 7 applies to Tampa Campus ONLY since Tampa performs this function for all campuses.
Determine the following: A. Reconciliation is appropriately prepared and reviewed by persons outside the Cashier’s Office not involved with custody of cash, authorization of collections transactions, or recordkeeping. B. Reconciliation is performed timely.
SAFEGUARDS:
- Assess physical security over access to and within Cashier’s Office during and after hours. To the extent possible, use information already obtained in planning step 5a & b, updating as necessary to reflect the latest conditions and observations:
Keys:
Audit Area: Revenue Prepared By Project Name: XXXX Cashier’s Office Reviewed By Project Number: XX -XXX W/P Ref. Audit Period: XXX -XXX Page 8 of 10
Audit Procedures: Initials/Date Completed
WPReference/Comments
A. Accounting for keys. B. Determine the key confiscation process upon separation. Date of last termination? Access Code: C. Assess access code usage. (i. individual codes or 1 departmental) D. Who has after-hour access? E. Periodic access changes (codes, etc.). Date of last termination? F. Card access control and tracking. Who has the ability to review? Safe: G. Closed and locked when not in use? H. Employees w/ access to safe? I. Combo/key to safe periodically changed? Date of last change? Other: J. Alarm in place? Linked to UPD? K. Panic button? L. Video surveillance in place? What areas are monitored? How long are they maintained? Who has access? M. All cash register drawers closed when not in use? N. All funds properly secured? O. Personal bags at workstations? P. Cash handling areas physically secured from customers & non-cash handlers? Q. Cashiers observed operating same register? R. Register keys left unsecured? S. Other security measures? T. Conclude on overall safeguards and document weaknesses. TRAINING & POLICIES & PROCEDURES:
- Determine if employees in the Cashier’s Office have been properly trained To the extent possible, use information already obtained in planning step 5a & b, updating as necessary to reflect the latest conditions and observations: . A. All cash handling employees have attended the Cash Collection & Control training. B. All cash handling employees have completed PCI training. C. All cash handling employees have completed other required training. D. Conclude on overall training and document
i Complies with Standard 2200 (Engagement Planning) and Standard 2201 (Planning Considerations) of International
Standards for the Professional Practice of Internal Auditing (IIA) ii Complies with Implementation Standard 2220(Assurance Engagement Scope) of International Standards for the
Professional Practice of Internal Auditing (IIA) iii Complies with Standard 2340 (Engagement Supervision) of International Standards for the Professional Practice of
Internal Auditing (IIA) iv Complies with Standard 1100 (Independence and Objectivity) of International Standards for the Professional Practice of
Internal Auditing (IIA) v Complies with Standard 1210 (Fraud) of International Standards for the Professional Practice of Internal Auditing
(IIA) vi Complies with Standard 2200 (Engagement Planning) and Standard 2201 (Planning Considerations) of International
Standards for the Professional Practice of Internal Auditing (IIA) vii Complies with Practice Advisory 2320-1(Analysis and Evaluation) and Practice Advisory 2210-1 (Engagement
Objectives) of International Standards for the Professional Practice of Internal Auditing (IIA) viii Complies with Standard 2210 Practice Advisory 2210-1 (Risk Assessment in Engagement Planning) of
International Standards for the Professional Practice of Internal Auditing (IIA) ix Complies with Standard 2240 (Engagement Work Program) of International Standards for the Professional Practice of
Internal Auditing (IIA) x Complies with Standard 2100 (Nature of Work) and Practice Advisory 2100-10 (Audit Sampling) of International
Standards for the Professional Practice of Internal Auditing (IIA) xi Complies with Standard 2320 (Analysis and Evaluation) of International Standards for the Professional Practice of
Internal Auditing (IIA) xii Complies with Standard 2410 (Communication) of International Standards for the Professional Practice of Internal
Auditing (IIA)
Audit-Walkthrough-Documentation-Template
Course: Accountancy (Aec 104)
University: Holy Cross of Davao College
- Discover more from:
