- This topic has 0 replies, 1 voice, and was last updated 19 years, 2 months ago by
.
-
Posts
-
Payroll Report Plugin
Last edited: December 15, 2003 08:14 AM
The Payroll plugin report is an extra report that can be run from within Manager. This report looks similar to the labor summary report currently available in Manager with a few extra columns. The additional information is overtime hours, overtime rate, overtime pay, tip amount and net sales.
This report (and other overtime calculating modules/reports) use the same overtime parameters. The parameters definable are:
The user will define:
1. Week start day – the day of the week the user considers to be the starting day.
2. Minimum wage – the state/federal minimum wage. This figure is used to calculate overtime for employees working in a “server” type job code. The “server” type employees are typically paid less than minimum wage and when working overtime must be paid the overtime multiplier applied to the greater of minimum wage or their wage.For each job code the user may define:
1. Maximum hours per week – number of hours an employee can work before being considered working on overtime.
2. Overtime multiplier – the multiplier to apply to an employee’s rate of pay once considered to be working on overtime.
3. Server type – to specify a job code as a “server” type, and thus applying the special “server” type overtime rules to the employees working on overtime in this job code.This report is configurable from Manager. Select “Configure Extra Reports” from the File menu and then select “Payroll Report” from the list box. This screen will appear showing current overtime parameters and job code specific parameters.
[img:2rislusd]http://www.possupport.net/dealer/kbase/images/payroll1.jpg[/img:2rislusd]
Use this screen to define the Week begin day and the minimum wage. To define specific job code parameters, select the desired job code from the list box and then select the EDIT button. This action will bring up the following screen:
[img:2rislusd]http://www.possupport.net/dealer/kbase/images/payroll2.jpg[/img:2rislusd]
Use this screen to define the maximum hours per week, overtime multiplier and job kind for each job code. Select the OK button to save your changes. (by default all job codes are set to 40 hours per week, 1.5% overtime multiplier and server type turned off)
The report can be run for any range of dates. The way the overtime is calculated is if the beginning day selected is not the defined “Week Begin Day” then Payroll will go back to the “Week Begin Day” for the beginning day selected and start gathering hours from there. The hours up to the beginning day selected are not included in the report, they are used for calculating overtime only.
Sample ReportVersion 6.xx Sample Data
Created by some one at some restaurant
somewhere in the United States of
America on the planet Earth in the Milky
** Payroll Report **
Report Printed on: Thu, Jun 26, 1997 10:33am
Report For: Sun, Jun 01, 1997
> Mon, Jun 16, 1997EMPLOYEE ID JOB CODE SHIFTS REG HRS REG RATE REG PAY OT HRS OT RATE OT PAY TTL HRS TTL PAY TIPS
*, Host AM Takeout (52) AM/PM Host 2 16.42 X 0.00 = 0.00 0.00 X 0.00 = 0.00Totals: 16.42 0.00 0.00 0.00 16.42 0.00 0.00
*, Host PM Takeout (53) AM/PM Host 3 13.62 X 0.00 = 0.00 0.00 X 0.00 = 0.00
Totals: 13.62 0.00 0.00 0.00 13.62 0.00 0.00
Aanestad, Gail (284) Host 7 26.47 X 6.50 = 172.06 0.00 X 9.75 = 0.00
Totals: 26.47 172.06 0.00 0.00 26.47 172.06 48.53
Aguirre, Lorenzo (290) Dishwasher 12 43.86 X 7.00 = 307.02 6.73 X 10.50 = 70.67
Totals: 43.86 307.02 6.73 70.66 50.59 377.68 0.00
Alfano, Mary (2) Server 9 21.80 X 4.90 = 106.82 0.00 X 7.35 = 0.00
Totals: 21.80 106.82 0.00 0.00 21.80 106.82 95.81
Burlison, Deann (4) Server 17 40.65 X 4.90 = 199.19 0.00 X 7.35 = 0.00
Totals: 40.65 199.18 0.00 0.00 40.65 199.18 75.00
Chip (29) Manager 2 17.83 X 0.00 = 0.00 0.00 X 0.00 = 0.00
Totals: 17.83 0.00 0.00 0.00 17.83 0.00 0.00
Coan, Bern (23) Bartender 7 30.26 X 6.00 = 181.56 0.00 X 9.00 = 0.00
Coan, Bern (23) Server 2 10.55 X 4.90 = 51.70 0.00 X 7.35 = 0.00
Totals: 40.81 233.26 0.00 0.00 40.81 233.26 181.80
Corson, Cara (
Server 9 26.48 X 4.90 = 129.75 0.00 X 7.35 = 0.00Totals: 26.48 129.75 0.00 0.00 26.48 129.75 54.08
Crego, Pamela (3) Server 13 44.90 X 4.90 = 220.01 0.00 X 7.35 = 0.00
Totals: 44.90 220.01 0.00 0.00 44.90 220.01 -102.40
Cunningham, Linda (5) Server 6 15.77 X 4.90 = 77.27 0.00 X 7.35 = 0.00
Totals: 15.77 77.27 0.00 0.00 15.77 77.27 -6.00
Dana (35) Manager 1 6.88 X 0.00 = 0.00 0.00 X 0.00 = 0.00
Totals: 6.88 0.00 0.00 0.00 6.88 0.00 0.00
Drake, Krishnee (15) Server 13 51.26 X 4.90 = 251.17 0.00 X 7.35 = 0.00
Totals: 51.26 251.17 0.00 0.00 51.26 251.17 75.45
Garcia, Gilberto (225) Dishwasher 11 19.28 X 7.00 = 134.96 0.00 X 10.50 = 0.00
Garcia, Gilberto (225) PORTER 17 32.06 X 7.00 = 224.42 0.00 X 10.50 = 0.00
Totals: 51.34 359.38 0.00 0.00 51.34 359.38 0.00
Garcia, Santos (231) Prep Cook 10 43.64 X 7.50 = 327.30 0.00 X 11.25 = 0.00
Totals: 43.64 327.30 0.00 0.00 43.64 327.30 0.00
Gilmore, Scott (10) Bartender 9 28.89 X 7.00 = 202.23 0.00 X 10.50 = 0.00
Totals: 28.89 202.23 0.00 0.00 28.89 202.23 234.05
Guzman, Fernando (212) Line Cook 11 49.66 X 8.75 = 434.53 0.00 X 13.13 = 0.00
Totals: 49.66 434.52 0.00 0.00 49.66 434.52 3.00
Henderson, Elisha (14) Expeditor 1 2.83 X 0.00 = 0.00 0.00 X 0.00 = 0.00
Henderson, Elisha (14) Host 1 0.00 X 6.00 = 0.00 0.00 X 9.00 = 0.00
Henderson, Elisha (14) Server 8 13.12 X 4.90 = 64.29 0.00 X 7.35 = 0.00
Totals: 15.95 64.29 0.00 0.00 15.95 64.29 108.35
Herrera, Pedro (184) Prep Cook 6 20.75 X 7.00 = 145.25 0.00 X 10.50 = 0.00
Totals: 20.75 145.25 0.00 0.00 20.75 145.25 0.00
Holmes, Nick (191) Line Cook 15 66.76 X 9.25 = 617.53 0.00 X 13.88 = 0.00
Totals: 66.76 617.53 0.00 0.00 66.76 617.53 0.00
John (37) Manager 2 26.43 X 0.00 = 0.00 0.00 X 0.00 = 0.00
Totals: 26.43 0.00 0.00 0.00 26.43 0.00 0.00
Johnson, Paul (1) Bartender 4 22.83 X 6.25 = 142.69 0.00 X 9.38 = 0.00
Johnson, Paul (1) Server 2 1.93 X 4.90 = 9.46 0.00 X 7.35 = 0.00
Totals: 24.76 152.15 0.00 0.00 24.76 152.15 15.50
Lystad, Steve (164) Line Cook 7 20.80 X 9.00 = 187.20 0.00 X 13.50 = 0.00
Totals: 20.80 187.20 0.00 0.00 20.80 187.20 0.00
Martinez, Sigifredo (267) Line Cook 6 21.01 X 7.50 = 157.58 0.00 X 11.25 = 0.00
Totals: 21.01 157.58 0.00 0.00 21.01 157.58 0.00
Munden, Jason (18) Server 11 25.11 X 4.90 = 123.04 0.00 X 7.35 = 0.00
Totals: 25.11 123.04 0.00 0.00 25.11 123.04 95.75
Ortiz-Alpista, Emigd (222) Prep Cook 1 6.95 X 7.00 = 48.65 0.00 X 10.50 = 0.00
Totals: 6.95 48.65 0.00 0.00 6.95 48.65 0.00
Perry, Matt (13) Bartender 8 35.18 X 6.25 = 219.88 0.00 X 9.38 = 0.00
Perry, Matt (13) Expeditor 1 3.92 X 0.00 = 0.00 0.00 X 0.00 = 0.00
Perry, Matt (13) Server 3 5.63 X 4.90 = 27.59 0.00 X 7.35 = 0.00
Totals: 44.73 247.47 0.00 0.00 44.73 247.47 74.95
Peter (36) Manager 1 0.43 X 0.00 = 0.00 0.00 X 0.00 = 0.00
Totals: 0.43 0.00 0.00 0.00 0.43 0.00 0.00
Pollack, Sarah (287) Busser 2 0.00 X 6.00 = 0.00 0.00 X 9.00 = 0.00
Pollack, Sarah (287) Host 13 37.55 X 6.00 = 225.30 0.00 X 9.00 = 0.00
Totals: 37.55 225.30 0.00 0.00 37.55 225.30 61.28
Pollack, Shawn (285) Expeditor 10 19.61 X 5.50 = 107.86 0.00 X 8.25 = 0.00
Pollack, Shawn (285) 2410:packer 8 14.57 X 7.00 = 101.99 0.00 X 10.50 = 0.00
Totals: 34.18 209.85 0.00 0.00 34.18 209.85 86.80
Ray, Dawn (215) Busser 1 0.00 X 5.50 = 0.00 0.00 X 8.25 = 0.00
Ray, Dawn (215) Host 12 28.16 X 5.50 = 154.88 0.00 X 8.25 = 0.00
Totals: 28.16 154.88 0.00 0.00 28.16 154.88 54.50
Ray, Tony (26) Bartender 3 5.65 X 5.50 = 31.08 0.00 X 8.25 = 0.00
Ray, Tony (26) Server 16 44.72 X 4.90 = 219.13 0.00 X 7.35 = 0.00
Totals: 50.37 250.21 0.00 0.00 50.37 250.21 -6.00
Reyes, Jesus (230) Dishwasher 7 21.35 X 7.00 = 149.45 0.00 X 10.50 = 0.00
Totals: 21.35 149.45 0.00 0.00 21.35 149.45 0.00
Rodriguez, Hilario (167) Line Cook 9 31.19 X 8.75 = 272.91 0.00 X 13.13 = 0.00
Totals: 31.19 272.91 0.00 0.00 31.19 272.91 0.00
Rollin, Wendy (16) Server 5 9.52 X 4.90 = 46.65 0.00 X 7.35 = 0.00
Totals: 9.52 46.65 0.00 0.00 9.52 46.65 45.50
Rueda, Juan (183) Line Cook 6 15.78 X 8.00 = 126.24 0.00 X 12.00 = 0.00
Rueda, Juan (183) Prep Cook 3 6.80 X 8.00 = 54.40 0.00 X 12.00 = 0.00
Totals: 22.58 180.64 0.00 0.00 22.58 180.64 0.00
Sanchez, Elizabeth (124) Host 15 42.65 X 6.25 = 266.56 0.00 X 9.38 = 0.00
Totals: 42.65 266.56 0.00 0.00 42.65 266.56 71.38
Sanchez, Franciso (245) Busser 12 42.02 X 6.00 = 252.12 0.00 X 9.00 = 0.00
Totals: 42.02 252.12 0.00 0.00 42.02 252.12 323.25
Semprimoznik, Tori (25) Server 8 23.35 X 4.90 = 114.42 0.00 X 7.35 = 0.00
Totals: 23.35 114.42 0.00 0.00 23.35 114.42 114.00
Soriano, Luis (190) Line Cook 8 21.76 X 7.50 = 163.20 0.00 X 11.25 = 0.00
Totals: 21.76 163.20 0.00 0.00 21.76 163.20 0.00
Stecher, Robert (220) Line Cook 11 45.44 X 8.75 = 397.60 0.00 X 13.13 = 0.00
Totals: 45.44 397.60 0.00 0.00 45.44 397.60 0.00
Stein, Allison (6) Server 8 20.00 X 4.90 = 98.00 0.00 X 7.35 = 0.00
Totals: 20.00 98.00 0.00 0.00 20.00 98.00 96.00
Trujillo, Rick (7) Server 17 40.34 X 4.90 = 197.67 0.00 X 7.35 = 0.00
Totals: 40.34 197.67 0.00 0.00 40.34 197.67 -83.75
Wampler, Candice (22) Server 9 19.86 X 4.90 = 97.31 0.00 X 7.35 = 0.00
Totals: 19.86 97.31 0.00 0.00 19.86 97.31 92.14
Warner, Ian (21) Server 6 16.32 X 4.90 = 79.97 0.00 X 7.35 = 0.00
Totals: 16.32 79.97 0.00 0.00 16.32 79.97 49.00
Zeller, Jessica (11) Server 20 44.06 X 4.90 = 215.89 0.00 X 7.35 = 0.00
Totals: 44.06 215.89 0.00 0.00 44.06 215.89 222.04
Grand Totals: 1364.66 8135.74 6.73 70.66 1371.39 8206.40 2840.49
(Program: Payroll Version: 6.00)
Installation
Create a directory called Plugins on the same drive as Manager was found. If Manager was found on C: then the directory should becreated on the C: drive.
Place the program files in this directory. The necessary files are:
* Payroll.EXE – the program executable
* Payroll.RES – the resource file
* Payroll.PID – the program definition fileTechnical notes
Below is an excerpt from Plugins.DOC describing the program definition file. For more detailed information about the workings of a plugin, please refer to the Plugins.DOC.
.PID File FormatThe .PID file is a text file that may be created with DOS Edit or any other text editor. It contains settings that Manager will use. Below are a list of possible settings and their meanings.
The file may also contain remarks. A REM indicates that the line is a remark, and will be ignored. Blank lines will also be ignored. A remark may be placed after a setting, on the same line if it is preceeded by a ; symbol.
The following are sample settings, with remarks about each:
Version=5 ;This required line informs manager what version of TouchNET/TouchPRO the report is compatible with.
Name=A Plugin Report ;This is the name that the user will see
Wide=136 ;This is the report width (80 and 136 are common)
UseJournal=yes ;This report will not be launched without the user selecting dates first. Without this line, the /Date=YYMMDD-YYMMDD command line will not be passed.
Revisions6/26/96 Version 6.00
1. Initial Release
7/03/96 Version 6.01
1. Widened the grand total pay and tip fields on the report output.
2. Fixed a bug that would keep the overtime hours from calculating correctly for an employee who had two shifts on the defined Week Start Day.10/02/97 Version 6.02
1. Fixed a bug that would surface when using the report for a date range that spanned more than one week. Hours and pay would not compute properly.
10/03/97 Version 6.03
1. Fixed another bug! This one surfaced when running the report for an employee database that included employees with a 4 digit ID. This would cause an error 6. Fixed.
12/23/97 Version 6.04
1. Added net sales column.
2. Added ability to configure the report format. Now user can run the report totaled by employee OR job code.03/05/98 Version 6.05
1. Fixed a bug related to the tip and sales grand totals.
03/16/98 Version 6.06
1. Fixed a bug related to calculating overtime in a pay period that spans February 28th.
05/05/98 Version 6.07
1. Fixed a bug introduced by version 6.05. The report by employee incorrectly calculated/displayed individual employee’s sales and tip totals. Those totals were always zero in version 6.05 and 6.06.
06/10/98 Version 6.08
1. Year 2000 compliant.
12/16/98 Version 6.09
1. More Year 2000 compliant.
- You must be logged in to reply to this topic.