Summer2017SysDoc1standSysDoc2ndAssignment

JobPayrollProcess

NOTE: This is a simplified version of a process for the purposeof illustrating flowcharting techniques.

NARRATIVE

Employees enter hours worked using the Time & Attendance Program which adds a new record to theTime & AttendanceTransaction file. Employees then create two Job Time Ticketsusing the Time & Attendance Program whichretrieves data from the Employee Master andTime & Attendance Transaction files. The first Job Time Ticket is sent to the Payroll Department. The second Job Time Ticket is filed in theJob Time Ticketsfile cabinet by job number.

The Payroll Department updates the payroll database using the Payroll Program which views the Employee Master file and updates the Payroll Master file.The Direct Deposit is then preparedusing the Payroll Program whichretrieves data from theEmployee Master and Payroll Master files and enters a record into the Payroll Transaction file while creating an electronic Direct Deposit Report and Direct Deposit Pay Stubs. TheDirect Deposit Reportis sent to the Bank. TheDirect Deposit Pay Stubsare sent to the Employees. Two copies of the Payroll Summary Report are printedusing the Payroll Program which retrieves data from the Payroll Masterand Payroll Transaction files.The first copyis sent to the Controller, andthe second copyis sent to the Accountant.

The Accountantprepares a TaxPayment using the Accounts Payable Program which retrieves data from the Payroll Transaction file, updates the Payroll Master file, and adds a record to the Tax Payments Transaction file. A Taxes Paid report is printedusing the Accounts Payable Program which readsdata fromthe Tax PaymentsTransactionfile.The Accountant reconciles the PayrollSummary Report with the Taxes Paid Report then sends the Taxes Paid Report to the Controller and the Tax Payment to the IRS.

The Controller reviews the Payroll Summary Report for reasonableness then files it in the Payroll file cabinet by date. The Controller reviews the Taxes Paid Report for accuracy and files it in the Taxes Paid file cabinet by vendor number and date. The Employees retrieve the Job Time Tickets from the file cabinet so they can compare them with the Direct Deposit Pay Stubs before they file both documents in the Jobs Paid file cabinet by job name and date.

INSTRUCTIONS:

Create one file in Excel with two worksheets (use a new, blank file).

Include your first and last name in the file name.

Name the first worksheet "Table" and complete a Table of Entities and Activities.

Name the second worksheet "Flowchart" and complete a Document Flowchart.

ACADEMIC INTEGRITY:This is not a group project.Do not showyour SysDoc filestoany other student.Students who turn in another student's fileor a portion of another student's file,and students who share their file with any other student,mayreceive a zero onthe assignment. Additional penalties forturning in another student's work as though it was your own, or for sharing your work with others,mayincludeagradeof "F"in the course that cannot be removed by any forgiveness policy or by dropping the course,a notation on the student's transcript stating that the student violated the Code of Academic Integrity, and expulsion from the University orthe School of Accounting. Please see the Academic Integrity sections of the syllabus for more information on this process.