Final Paper

fraud_management_payroll_testing_11.xlsx

Sheet1

					Joe's Engineering	21234 - Paul Trustworthy, Project Accountant
Source:					Labor Testing	22345-Mary Polite, Receptionist
Payroll					2000-2004	24320-Adam Smart, Administrative Accountant
						023000 - Elaine Efficient, Adminsitrative Assistant
						24000- Dan Doubleduty, Admin. Assit/Computer Assist.
Year	Employee Number	Reg. Hours	Leave	Holiday	Overime
2004		Holiday				Purpose: Hourly employee time sheets for misuse of overtime
	21234	2080	80	72	102		and/or ghost employees
	****	1040	0	0	0
	24320	2080	0	72	248
	22300	2080	80	72	0
	22345	2080	80	72	0
	23000	2080	80	72	33
2003
	21234	2080	80	72	104
	0	450	0	0	0
	24320	2080	80	72	204
	22300	2080	80	72	0
	22345	2080	80	72	0
	23000	2080	80	72	0
2002	21234	2080	80	72	104
	24320	2080	80	72	168
	22300	2080	80	72	0
	22345	2080	80	72	0
	23000	702	0	24	0
2001	21234	2080	80	72	104
	20000	1000	80	36	56
	24320	2080	80	72	102
	22300	2080	80	72	0
	22345	2080	80	72	0
2000	21234	2080	80	72	84
	20000	1000	80	36	56
	24320	2080	80	72	48
	22300	2080	80	72	0
	22345	2080	80	72	0