Sample Payroll Report (40 Column Report)

Purpose

A sample Payroll Report and description of the fields are listed below.

Note: The sample report may differ from the actual report. The options used to configure the report will determine the actual output of the report.

Figure 8.101 Sample Payroll Report

Focus Cafe

Payroll Report Page 1

for 3/2/200X-3/8/200X

created at 3/20/200X 11:57:47 AM

=========================================

Gonzalez, Ricardo

ID1: 987-65-4321

ID2: 11111111

(Meals: 12.50)

Bartender 3/02 11:45 22:10 10.00

0.42-D

Bartender 3/03 18:04 22:57 4.88

Bartender 3/04 8:00 16:00 7.50

Bartender 3/05 16:00 22:00 6.00

Bartender 3/07 18:08 23:38 1.62

3.88-W

Bartender 3/08 17:53 23:08 5.25

-----------------------------------------

Totals Gonzalez, Ricardo 35.25

3.88-W

0.42-D

Moreno, Maria

ID1: 123-45-6789

ID2: 54545454

Bartender 3/02 8:00 22:00 10.00

2.00-D

2.00-B

Bartender 3/04 15:00 22:20 7.33

Bartender 3/05 15:16 22:30 7.23

Bartender 3/06 15:00 22:47 6.52

1.26-W

Bartender 3/07 14:45 23:228.62-W

Bartender 3/08 16:18 18:58 2.67

-----------------------------------------

Totals Moreno, Maria 33.75

9.88-W

2.00-D

2.00-B

=========================================

Grand Totals 69.00

13.76-W

2.42-D

2.00-B

W = Weekly Overtime

D = Daily Overtime

B = Daily Double Time

-----------------------------------------

SUMMARY

-----------------------------------------

Gonzalez, Ricardo

ID1: 987-65-4321

ID2: 11111111

(Meals: 12.50)

Bartender 35.25

3.88-W

0.42-D

Moreno, Maria

ID1: 123-45-6789

ID2: 54545454

Bartender 33.75

9.88-W

2.00-D

2.00-B

=========================================

Grand Totals 69.00

13.76-W

2.42-D

2.00-B

W = Weekly Overtime

D = Daily Overtime

B = Daily Double Time

Figure 8.102 Payroll Report Fields

Field

Description

Employee

The Employee’s Last Name, First Name.

ID1

The Employee’s ID1. Note: This field if ID1 is defined for the Employee.

ID2

The Employee’s ID2. Note: This field if ID2 is defined for the Employee.

Employee Meals

The Total Employee Meals charged to the Employee. Note: The Employee Meal Total does not reduce the Total Pay. This field is only displayed if the Employee has charged an Employee Meal.

Job

Date In

The date the Employee clocked in.

Time In

The time the Employee clocked in.

Time Out

The time the Employee clocked out.

Hours

Regular Hours	The number of Regular Hours worked.
Weekly Overtime	The number of hours in the week that exceed the Miscellaneous > General > Timekeeping > Overtime Options > Weekly Hours but do not exceed the Daily Overtime or Daily Double Time limits.
Daily Overtime	The number of hours in the day that exceed the Miscellaneous > General > Timekeeping > Overtime Options > Daily Overtime Hours but do not exceed the Daily Double Time limit.
Daily Double Time	The number of hours in the day that exceed the Miscellaneous > General > Timekeeping > Overtime Options > Daily Double Time Hours.

Totals

Employee

The Employee’s Last Name, First Name.

Hours

Regular Hours	The Total number of Regular Hours worked.
Weekly Overtime	The Total number of Weekly Overtime Hours worked.
Daily Overtime	The Total number of Daily Overtime Hours worked.
Daily Double Time	The Total number of Daily Double Time Hours worked.

Grand Totals

Hours

Regular Hours	The Total number of Regular Hours worked for all Employees.
Weekly Overtime	The Total number of Weekly Overtime hours worked for all Employees.
Daily Overtime	The Total number of Daily Overtime hours worked for all Employees.
Daily Double Time	The Total number of Daily Double Time hours worked for all Employees.

Figure 8.102 Payroll Report Summary Fields

Field

Description

Employee

The Employee’s Last Name, First Name.

The following fields are displayed if a value is entered.

ID1

The Employee’s ID1. Note: This field if ID1 is defined for the Employee.

ID2

The Employee’s ID2. Note: This field if ID2 is defined for the Employee.

Employee Meals

The Total Employee Meals charged to the Employee. Note: The Employee Meal Total does not reduce the Total Pay. This field is only displayed if the Employee has charged an Employee Meal.

Job

The Job the Employee worked.

Hours

Regular Hours	The Total number of Regular Hours worked.
Weekly Overtime	The Total number of Weekly Overtime Hours worked.
Daily Overtime	The Total number of Daily Overtime Hours worked.
Daily Double Time	The Total number of Daily Double Time Hours worked.

Grand Totals

Hours

Regular Hours	The Total number of Regular Hours worked for all Employees.
Weekly Overtime	The Total number of Weekly Overtime hours worked for all Employees.
Daily Overtime	The Total number of Daily Overtime hours worked for all Employees.
Daily Double Time	The Total number of Daily Double Time hours worked for all Employees.

Figure 8.102.1 Payroll Report Setup Options

Option	Selection
Job	All Jobs were selected.
Detail	Individual Times
Sort	Employee
Payroll File Format	40 Column Report

Related Topics (none)