Test data transactions in a payroll processing program

Assignment Help Accounting Basics
Reference no: EM131625742

Question: Test Data Transactions in a Payroll Processing Program. Use the computer-based electronic audit documentation on the textbook website to perform a test of the computerized payroll processing program. The electronic audit documentation contains a simple program that accepts payroll transaction input and calculates an individual's weekly gross and net pay. When you come to the proper place in the program, you will see places to input these data:

• Employee identification (Social Security number).

• Regular pay rate (round dollars, no cents).

• Regular time (hours, 40 or fewer).

• Overtime (hours over 40).

• Gross earnings to date (gross pay prior to this payroll entry).

According to the client's description of the IT controls in the system:

1. The program checks for valid employee identification.

2. The regular pay rate is tested for reasonableness.

3. The system will accept no more than 40 regular-time hours.

4. There is a limit on the number of overtime hours that will be paid (32 hours). Overtime hours are paid only if the employee works 40 regular-time hours.

5. Overtime is paid at the rate of 150 percent of the regular pay rate.

6. Social Security and Medicare taxes and federal income tax withholdings are calculated automatically according to applicable laws and regulations. Applicable Laws and Regulations (assume the following for this case)

• The minimum wage is $7.25 per regular hour.

• Social Security tax is 6.2 percent on the first $106,800 of gross pay and Medicare tax is 1.45 percent of all pay.

• Federal income tax withholding is assumed to be 23 percent of gross pay.

Required: The payroll calculation program contains control deficiencies. Your job is to identify and describe them. Follow the instructions in the electronic audit documentation. Devise and enter test transactions of your own making. Write a memo to the audit partner identifying and describing the control failures in the payroll calculation program.

Reference no: EM131625742

Questions Cloud

Create an ERD that represents your 3NF relations : Draw a dependency diagram to show the functional dependencies in the relation. Create an ERD that represents your 3NF relations
Research the merits of patent protection in lilys situation : Conclude with a determination on whether a patent would benefit Lily Dance Fitness, and provide a rationale for your answer.
Governs workers compensation for the state : The state workers' compensation board that governs workers' compensation for the state that your company resides andperforms all of its business in
Critical vulnerabilities on the public facing website : Issue in this scenario is why are there critical vulnerabilities on the public facing website to begin with?
Test data transactions in a payroll processing program : Use the computer-based electronic audit documentation on the textbook website to perform a test of the computerized payroll processing program.
What is your opinion of the clients request : Review the, What would you do in this situation? presented on pages 3-8 of your text. What is your opinion of the client's request?
Elaborate on the role of a team covenant and its benefits : Elaborate on the role of a team covenant and its benefits.
Essay on challenges that adults returning to college face : What are the challenges that adults returning to college face in their their first year and how can they be overcome
Concepts relevant to production and operations management : There are two parts to this project: 5-8page paper and a professional and concise PowerPoint Presentation.

Reviews

Write a Review

Accounting Basics Questions & Answers

  How much control does fed have over this longer real rate

Hubbard argues that the Fed can control the Fed funds rate, but the interest rate that is important for the economy is a longer-term real rate of interest.   How much control does the Fed have over this longer real rate?

  Coures:- fundamental accounting principles

Coures:- Fundamental Accounting Principles: - Explain the goals and uses of special journals.

  Accounting problems

Accounting problems,  Draw a detailed timeline incorporating the dividends, calculate    the exact Payback Period  b)   the discounted Payback Period. the IRR,  the NPV, the Profitability Index.

  Write a report on internal controls

Write a report on Internal Controls

  Prepare the bank reconciliation for company

Prepare the bank reconciliation for company.

  Cost-benefit analysis

Create a cost-benefit analysis to evaluate the project

  Theory of interest

Theory of Interest: NPV, IRR, Nominal and Real, Amortization, Sinking Fund, TWRR, DWRR

  Liquidity and profitability

Distinguish between liquidity and profitability.

  What is the expected risk premium on the portfolio

Your Corp, Inc. has a corporate tax rate of 35%. Please calculate their after tax cost of debt expressed as a percentage. Your Corp, Inc. has several outstanding bond issues all of which require semiannual interest payments.

  Simple interest and compound interest

Simple Interest, Compound interest, discount rate, force of interest, AV, PV

  Capm and venture capital

CAPM and Venture Capital

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd