Question

In: Accounting

Internal controls 1. Any changes to employee master file information since the last payroll period are...

Internal controls

1. Any changes to employee master file information since the last payroll period are evaluated to ensure that they have been properly authorized by the appropriate personnel.

2. The output is reviewed for reasonableness prior to distribution to users.

Consider the four methods of testing the operating effectiveness of controls (inquiry, observation, document examination, and re-performance). For each of the preceding controls, provide an example of how Mark's audit team might choose to test the operating effectiveness of the control using the four methods of test of controls (e.g., how would the audit team use inquiry, observation, document examination, and re-performance to test control #1, the generation and review of the system log?). [Note: Not all types of tests of controls will be appropriate for testing all the controls.]

Solutions

Expert Solution

Internal control is a process designed to provide reasonable assurance regarding the achievement of objectives in the following categories:

· Effectiveness and efficiency of operations

· Reliability of financial reporting

· Compliance with applicable laws and regulations

Internal control process:

Internal control consists of five interrelated components as follows:

· Control (or Operating) environment

· Risk assessment

· Control activities

· Information and communication

· Monitoring

Risk Identification. A risk is anything that could jeopardize the achievement of an objective. For each of the department's objectives, risks should be identified. Here we can explain the risk identification process in following steps:

· What could go wrong?

· How could we fail?

· What must go right for us to succeed?

· Where are we vulnerable?

· What assets do we need to protect?

· Do we have liquid assets or assets with alternative uses?

· How could someone steal from the department?

· How could someone disrupt our operations?

· How do we know whether we are achieving our objectives?

· On what information do we most rely?

· On what do we spend the most money?

· How do we bill and collect our revenue?

· What decisions require the most judgment?

· What activities are most complex?

· What activities are regulated?

· What is our greatest legal exposure?

Now in this case there are some changes in employee master file information since last payroll period:

Verify Active Employees

For each person that received a paycheck during the quarter, verify that the person was employed during the time period for which the check was issued. Pay particular attention to recent changes in job status. Although it is more difficult to commit payroll fraud on a smaller business, one method of financial theft is by cutting checks to terminated employees and then altering the checks for cashing or colluding with the terminated employee to cash the checks and provide a kick back

Verify Employment Records

Payroll centers around each employee's master file and the organization's record of a worker's assigned pay rate. Factors that are taken into account include employee number, benefit eligibility, employment status, and year-to-date earnings. Payroll audits compare file contents against issued pay, track changes and change authorizations, and review security measures such as access. A master file audit also confirms that only active, eligible employees are being paid, and reviews the timeliness of employee separation transactions.

Verify whether they were matched and employees will have a unique code number or identity number for the sake of attendance so verify the employees in payroll with their physical presence and need to concentrate more on the additional employees in the payroll.

If any one is not present mention it in the note so that you can review it later.

If it is found almost half of the employees were not present at the time of verification inquire whether they were present or not and mention it in the note. This is about inquiry and observation

Regarding the documents examination:

Compare the payroll reports with the general ledgers. Compare the totals, such as gross payroll expense, taxes withheld and net check amount, to the general ledger to ensure each payroll processing is correctly recorded on the general ledger. If you have multiple salaries and wages accounts, such as manager payroll, administrative payroll and sales payroll, ensure that each category of payroll reflects the correct expense for the employees in those specified positions.

Regarding test controls:

Bank reconciliation review: Review the bank reconciliation for the payroll account to ensure that all checks cleared for the issued amount and make a note of any stale-dated payroll checks to research. Make sure you receive the hard copy of all payroll checks from your bank, even if you have to pay an additional fee for the service. Review each payroll check to ensure the check does not appear altered in any way.


Related Solutions

The Payroll Department keeps a list of employee information for each pay period in a text...
The Payroll Department keeps a list of employee information for each pay period in a text file. The format of each line of the file is the following: Write a program that inputs a filename from the user and prints to the terminal a report of the wages paid to the employees for the given period. The report should be in tabular format with the appropriate header. Each line should contain: An employee’s name The hours worked The wages paid...
How internal controls in payroll should be communicated to individuals and parties affected by the internal...
How internal controls in payroll should be communicated to individuals and parties affected by the internal controls, i.e., accounting personnel, auditors?
in python language The Payroll Department keeps a list of employee information for each pay period...
in python language The Payroll Department keeps a list of employee information for each pay period . The format of each line of the file is the following: <lastname> < hours worked> < Income> Write a program that inputs from the user and prints to the terminal a report of the wages paid to the employees for the given period. The report should be in tabular format with the appropriate header. Each line should contain an employee’s name, the hours...
What is a payroll master file? Describe the types of errors that may occur in the...
What is a payroll master file? Describe the types of errors that may occur in the master file and how they get there. How would you design payroll procedures to help prevent them?
Attached is a Payroll Flowchart Payroll Flowchart.pdf from your SUA booklet. Identify 3 internal controls from...
Attached is a Payroll Flowchart Payroll Flowchart.pdf from your SUA booklet. Identify 3 internal controls from the attached Flowchart and fully explain them in terms of objectives, activities, functions, segregation of duties (if applicable) and how they work. You will need to write about 6 to 10 COMPLETE sentences for each internal control.
Master file contains the most up-to-date and accurate data in the payroll system. This data is...
Master file contains the most up-to-date and accurate data in the payroll system. This data is input to the payroll system when payroll is processed. Discuss the issues/problems resulting when an unauthorized change is made to the data in the payroll master file and explain its consequences.
1. Compare and contrast the following: 1A) employee internal controls: High Quality Employees, Separation of Duties,...
1. Compare and contrast the following: 1A) employee internal controls: High Quality Employees, Separation of Duties, Required Absences and Bonded Employees. 1B)procedural internal controls: Authority and Responsibility, Procedures Manual and Performance Evaluations. 1C) tactical internal controls and limitations: Prenumbered Documents, Physical Control and Limitations. 1D) any two of the following terms: recover accounts receivable, percentage of sales estimate, aging of receivables estimate, sale on account, write-off accounts receivable and reinstate accounts receivable 1E) allowance method and the direct write-off method...
Complete the following sentences relating to internal controls: The employee in charge of paying vendor invoices...
Complete the following sentences relating to internal controls: The employee in charge of paying vendor invoices is also in charge of reconciling the bank account. This is an example of _____________. Payroll checks are distributed to employees by someone without payroll duties. This is an example of ____________. Vendor contracts are reviewed by the purchasing department. The purchasing agent currently in the position has not been trained. This is an example of ______________. The billing clerk opens the mail, deposits...
16-35 (Potential misstatements/tests of controls—payroll) The following questions are included in the internal control questionnaire on...
16-35 (Potential misstatements/tests of controls—payroll) The following questions are included in the internal control questionnaire on control procedures for payroll transactions in the Pena Company: 1. Are pay rates, payroll deductions, and terminations authorized by the personnel department? 2. Are time clocks and clock cards used? 3. Is there supervisory approval of time worked by each employee? 4. Are payroll checks signed and distributed by treasurer office personnel? 5. Is there internal verification of payroll checks with payroll register data?...
a) Internal controls play an important role in reducing the risks of fraudulent activities in any...
a) Internal controls play an important role in reducing the risks of fraudulent activities in any organization. Further, advanced technology helps accountants in reducing fraud. Explain how an advanced technology transaction processing system reduces fraudulent activities from any organizing.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT