Sample Payroll Report (Detail sorted by Primary Job)

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



		Payroll Report for 3/2/200X-3/8/200X
Focus Cafe		created at 3/19/200X 9:37:09 PM															Page 1 of 2
	Date	Date	Time		Time						Total	Tipped	8.00	Charge	Declared
Job	In	Out	In		Out		Breaks	Hours	Rate	Pay	Pay	Sales	Sales	Tips	Tips		Adj 1	Adj 2
Bartender
Gonzalez, Ricardo ID1: 987-65-4321 (Meals: 12.50)
Bartender	3/02	3/02	11:45		22:10			10.00	6.50	65.00	69.10	113.65	9.09	12.25	0.00		0.00	0.00
								0.42	9.75	4.10-D
Bartender	3/03	3/03	18:04		22:57			4.88	6.50	31.72	31.72	156.60	12.53	32.98	0.00		0.00	0.00
Bartender	3/04	3/04	8:00		16:00		0.05	7.50	6.50	48.75	48.75	0.00	0.00	0.00	0.00		0.00	0.00
Bartender	3/05	3/05	16:00		22:00			6.00	6.50	39.00	39.00	0.00	0.00	0.00	0.00		0.00	0.00
Bartender	3/07	3/07	18:08		23:38			1.62	6.50	7.28	49.98	465.60	37.25	49.00	0.00		0.00	0.00
								3.88	9.75	37.83-W
Bartender	3/08	3/08	17:53		23:08			5.25	6.50	34.12	34.12	115.55	9.24	15.50	0.00		0.00	0.00
Totals Gonzalez, Ricardo							0.50	35.25		229.12	271.05	851.40	68.11	109.73	0.00		0.00	0.00
								3.88		37.83-W
								0.42		4.10-D
Moreno, Maria ID1: 123-45-6789
Bartender	3/02	3/02				22:00		10.00	6.50	65.00	110.50	50.00	4.00	15.00	0.00		9.95	0.00
								2.00	9.75	19.50-D
								2.00	13.00	26.00-B
Bartender	3/04	3/04		15:00		22:20		7.33	6.50	47.64	47.64	234.50	18.76	39.00	0.00		0.00	0.00
Bartender	3/05	3/05		15:16		22:30		7.23	6.50	47.00	47.00	107.40	8.59	18.15	0.00		0.00	0.00
Bartender	3/06	3/06		15:00		22:47		6.52	6.50	42.38	54.66	74.90	5.99	14.00	0.00		0.00	0.00
								1.26	9.75	12.28-W
Bartender	3/07	3/07		14:45		23:22		8.62	9.75	84.04-W	84.04	103.95	8.32	6.26	0.00		0.00	0.00
Bartender	3/08	3/08		16:18		18:58		2.67	6.50	17.36	17.36	30.00	2.40	4.00	0.00		0.00	0.00
Totals Moreno, Maria								33.75		219.38	361.20	600.75	48.06	96.41	0.00		9.95	0.00
								9.88		96.32-W
								2.00		19.50-D
								2.00		26.00-B
Grand Totals								69.00		448.50	632.25	1452.15	116.17	206.14	0.00		9.95	0.00
								13.76		134.15-W
								2.42		23.60-D
								2.00		26.00-B

W = Weekly Overtime, D = Daily Overtime, B = Daily Double Time



		Payroll Report(Summary) for 3/2/200X-3/8/200X
Focus Cafe		created at 3/19/200X 9:37:09 PM																Page 2 of 2
											Total	Tipped	8.00	Charge		Declared
Job							Breaks	Hours	Rate	Pay	Pay	Sales	Sales	Tips		Tips	Adj 1	Adj 2
Bartender
Gonzalez, Ricardo ID1: 987-65-4321 (Meals: 12.50)
Bartender							0.50	35.25	6.50	229.12	271.05	851.40	68.11	109.73		0.00	0.00	0.00
								3.88	9.75	37.83-W
								0.42	9.75	4.10-D
Moreno, Maria ID1: 123-45-6789
Bartender								33.75	6.50	219.38	361.20	600.75	48.06	96.41		0.00	9.95	0.00
								9.88	9.75	96.32-W
								2.00	9.75	19.50-D
								2.00	13.00	26.00-B
Grand Totals							0.50	69.00		448.50	632.25	1452.15	116.17	206.14		0.00	9.95	0.00
								13.76		134.15-W
								2.42		23.60-D
								2.00		26.00-B

W = Weekly Overtime, D = Daily Overtime, B = Daily Double Time

Figure 8.102 Payroll Report Fields

Field

Description

Job

Employee

The Employee’s Last Name, First Name.

The following fields are displayed if a value is entered.

ID1	The Employee’s ID1.
ID2	The Employee’s ID2.
Employee Meals	The Total Employee Meals charged to the Employee. Note: The Employee Meal Total does not reduce the Total Pay.

Job

The Job the Employee worked.

Date In

The date the Employee clocked in.

Date Out

The date the Employee clocked out.

Time In

The time the Employee clocked in.

Time Out

The time the Employee clocked out.

Breaks

The number of hours on Break.

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.

Rate

Regular Rate	The pay rate associated with the Job.
Weekly Overtime	The pay rate associated with the Job multiplied by Employees > Jobs > Timekeeping > Overtime Options > Weekly Rate.
Daily Overtime	The pay rate associated with the Job multiplied by Employees > Jobs > Timekeeping > Overtime Options > Daily Rate.
Daily Double Time	The pay rate associated with the Job multiplied by Employees > Jobs > Timekeeping > Overtime Options > Double Rate.

Pay

Regular Pay	Regular Hours multiplied by Regular Rate.
Weekly Overtime	Weekly Overtime Hours multiplied by Weekly Overtime Rate.
Daily Overtime	Daily Overtime Hours multiplied by Daily Overtime Rate.
Daily Double Time	Daily Double Time Hours multiplied by Daily Double Time Rate.

Total Pay

Regular Pay plus Weekly Overtime Pay plus Daily Overtime Pay plus Daily Double Time Pay.

Tipped Sales

The total of all Order Type Sales that are tipped as well as the Order Type Charges for those sales. Discounts do not reduce Order Type Sales and thus do not reduce Tipped Sales.

% Sales

Tipped Sales multiplied by the percent defined in Miscellaneous > General > Timekeeping > Tip %.

Charge Tips

The tips entered on all non cash Payments that the employee has received.

Declared Tips

The Tips the user declared when they clocked out.

Adj Fields 1-4

The Amount of Adjustment Field 1-4. Note: These fields only display if a value is established in Miscellaneous > General > Timekeeping > Adjustments > 1-4.

Employee Totals

Breaks

The Total number of hours on Break.

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.

Pay

Regular Pay	Regular Hours multiplied by Regular Rate.
Weekly Overtime	Weekly Overtime Hours multiplied by Weekly Overtime Rate.
Daily Overtime	Daily Overtime Hours multiplied by Daily Overtime Rate.
Daily Double Time	Daily Double Time Hours multiplied by Daily Double Time Rate.

Total Pay

Total Regular Pay plus Total Weekly Overtime Pay plus Total Daily Overtime Pay plus Total Daily Double Time Pay.

Tipped Sales

The Total Tipped Sales.

% Sales

Tipped Sales multiplied by the percent defined in Miscellaneous > General > Timekeeping > Tip %.

Charge Tips

The Total Charge Tips.

Declared Tips

The Total Declared Tips.

Adj Fields 1-4

The Total Adj Fields 1 - 4.

Grand Totals

Breaks

The Total number of hours on Break for all Employees.

Hours

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

Pay

Regular Pay	Total Regular Pay for all Employees.
Weekly Overtime	Total Weekly Overtime Pay for all Employees.
Daily Overtime	Total Daily Overtime Pay for all Employees.
Daily Double Time	Total Daily Double Time Hours for all Employees.

Total Pay

Total Pay for all Employees.

Tipped Sales

Total Tipped Sales for all Employees.

% Sales

Total % Sales for all Employees.

Charge Tips

Total Charge Tips for all Employees.

Declared Tips

Total Declared Tips for all Employees.

Adj Fields 1-4

Total Adj Fields for all Employees.

Figure 8.102 Payroll Report (Summary Section) Fields

Field

Description

Job

Employee

The Employee’s Last Name, First Name.

The following fields are displayed if a value is entered.

ID1	The Employee’s ID1.
ID2	The Employee’s ID2.
Employee Meals	The Total Employee Meals charged to the Employee.

Employee Totals

Breaks

The Total number of hours on Break.

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.

Pay

Regular Pay	Regular Hours multiplied by Regular Rate.
Weekly Overtime	Weekly Overtime Hours multiplied by Weekly Overtime Rate.
Daily Overtime	Daily Overtime Hours multiplied by Daily Overtime Rate.
Daily Double Time	Daily Double Time Hours multiplied by Daily Double Time Rate.

Total Pay

Total Regular Pay plus Total Weekly Overtime Pay plus Total Daily Overtime Pay plus Total Daily Double Time Pay.

Tipped Sales

The Total Tipped Sales.

% Sales

Tipped Sales multiplied by the percent defined in Miscellaneous > General > Timekeeping > Tip %.

Charge Tips

The Total Charge Tips.

Declared Tips

The Total Declared Tips.

Adj Fields 1-4

The Total Adj Fields 1-4.

Grand Totals

Breaks

The Total number of hours on Break for all Employees.

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.

Pay

Regular Pay	Total Regular Pay for all Employees.
Weekly Overtime	Total Weekly Overtime Pay for all Employees.
Daily Overtime	Total Daily Overtime Pay for all Employees.
Daily Double Time	Total Daily Double Time Hours for all Employees.

Total Pay

Total Pay for all Employees.

Tipped Sales

Total Tipped Sales for all Employees.

% Sales

Total % Sales for all Employees.

Charge Tips

The Total Charge Tips for all Employees.

Declared Tips

The Total Declared Tips for all Employees.

Adj Fields 1-4

The Total Adj Fields 1-4 for all Employees.

Figure 8.102.1 Sample Payroll Report Setup Options

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

Related Topics (none)