Pay Slip Excel Template

Document Sample
Pay Slip Excel Template Powered By Docstoc
					Event 1 Import Tools                               PR Time          3/9/2011
for Sage Timberline Office                                          12:05 PM
                                                   Information


       Template Name

       Purpose


       Requirements




       Initial Setup




       Using This Template




       About the Design




       Template Revision




D:\Docstoc\Working\pdf\81657872-5dcb-4a5f-b250-4d7b0b5dff98.xls   Page 1 of 15
Event 1 Import Tools                                       PR Time                          3/9/2011
for Sage Timberline Office                                                                  12:05 PM
                                                          Information


PR Time Entry (OC).xlt

This template is an Excel-based time sheet that utilizes Office Connector Query to
provide lists from Timberline in addition to custom macros.

 Event 1 Import Tools
 Event 1 Office Connector Query
 Sage Timberline Office - Payroll

This template is designed to use the standard time sheet view named "DAILY". If
you do not have this time sheet view or your "DAILY" time sheet view has been
modified, you must create a time sheet view having the following set of columns in
the order shown below. Make sure to use this time sheet view when importing files
created from this template.
   Date
   Employee
   Job
   Cost Code
   PayID
   Units
   Rate
   Amount

IMPORTANT - Make sure that Macros are enabled in Excel when using this
template.

1. At the top of the Time worksheet, enter dates for the period begin and end date.
2. In the entry grid record time entries. You can click Date/Time while in the Date,
Start Time, and End Time columns to insert the current date or time. In the
Employee, Job, Cost Code, and Pay ID columns, you can click List Items (or press
Ctrl+L) to display a list of available items. To add a new blank row to the grid, click
New Row. Click Copy Last to add a new row to the grid that copies information
from the last row entered.
3. Once all time has been recorded, click Save Import Files on the ImportTools
toolbar.
4. Provide a name for the import file and click Save.
5. Follow the steps documented in the Payroll module's help to import the file into
the Payroll module.


Hidden column J through N provide validation logic for the values being entered in
the grid.
Hidden column O provides a code indicating whether the entry represents regular or
overtime hours.
Hidden column P includes a TSImport function that acts as an instruction for
ImportTools to write data from the worksheet to the import file.

Revision 2
Monday, January 21, 2008 at 4:41 PM




D:\Docstoc\Working\pdf\81657872-5dcb-4a5f-b250-4d7b0b5dff98.xls                           Page 2 of 15
Event 1 Import Tools                               PR Time                                                3/9/2011
for Sage Timberline Office                                                                                12:05 PM
                                                   Worksheet

     Pay Period
     Period Begin
     Period End


     Summary Information (for Current Row)
     Employee
     Job
     Cost Code
     Hours                     0 Regular               0 Overtime




     Time Entry Details

          Date      Employee    Job        Cost Code    Pay ID      Start Time    End Time     Hours
                                                                                                   -

                                                                                 Total Hours       -




                                           CONFIDENTIAL
D:\Docstoc\Working\pdf\81657872-5dcb-4a5f-b250-4d7b0b5dff98.xls                                        Page 3 of 15
Event 1 Import Tools                             AR Invoice                                            3/9/2011
for Sage Timberline Office                                                                             12:05 PM
                                                 Sample Values

      To try this template using the "Construction Sample Data", you can try using the following values:



      Batch Details
      Period Begin Date5/1/2001
      Period End Date 5/7/2001

      Time Entry
      Date               5/2/2001
      Employee           101
      Job                03-001
      Cost Code          1-040
      Pay ID             REG
      Start Time         8:00 AM
      End Time           5:00 PM




D:\Docstoc\Working\pdf\81657872-5dcb-4a5f-b250-4d7b0b5dff98.xls                                    Page 4 of 15
101    Jones; Robert E
102    Sanford; Dennis G
103    Lovett; Gregory
104    Franks; Jimmy D
105    Grant; Randy P
106    Elliott; Chris M
107    Garcia; Jose
108    Brock; Terry W
109    Kelly; Matthew P
110    Daniels; Wayne H
111    Thomas; Ford
112    Turner; Keith A
113    Hardy; Bruce J
114    Rogers; Jeffrey C
115    Prescott; Daniel L
116    Hanson; Virgil C
117    Garner; Colin K
118    Crocker; Mark W
119    Brooks; Tom B
120    Smith; Harry D
121    Olson; Barry W
122    Williams; Joseph E
123    King; Tammy D
124    Taylor; Billy
125    Jackson; Gordon
126    Galloway; Frank
127    Stevens; Mark A
128    Joe; Wai
129    Hernadez; Carlos
130    Graham; Joseph S
131    Howard; William L
132    Carson; John W
133    Dumont; Theodore H
134    Becker; Laurie B
135    Brown; Stanley S
136    Shaw; Debra R
137    Black; Donald M
138    White; Henry J
139    Cooper; Gary S
140    Wayne; Bruce M
142    Starr; Jason G
143    Wall; Jeffery L
144    Grant; Kirk W
1001   Peters; Jerry E
1002   Peters; Sally D
1003   Campbell; Lisa M
1004   Gibson; Rebecca L
1005   Moffet; Doug W
1006   Perkins; Michael J
1007   Johnson; Steve M
1008   Erickson; John E
03-001   NW Food Warehouse
03-002   Clackamas Office Park #4
03-003   Fort Wayne Officer's Club
03-004   Metro Bus Stop 47
03-005   Metro Bus Stop 39
03-006   PGE Line WO#345
03-007   Low Income Housing
03-008   Rose Garden Arena Rewiring
03-009   OHSU Lighting Renovation
03-010   Tri-Tech Fab Lab
03-011   Cordova Middle School
03-012   Tri Tech Lab
03-014   Downtown Supermarket
03-015   Beaverton Office Park
08-001   Office Extension
09-157   Cardiff City Nuclear Facility
1-010   Summary of Work
1-020   Allowances
1-035   Modification Proc.
1-040   Coordination
1-041   Project Coordination
1-045   Insurance
1-060   Reg. Requirements
1-065   Permits - General
1-330   Survey & Layout Data
1-510   Temp Utilities
1-520   Temp Construction
1-525   Construction Aids
1-530   Barriers & Enclosure
1-540   Security
1-560   Temporary Controls
1-570   Traffic Regulation
1-580   Project Identification
1-660   Testing Systems
1-710   Final Cleaning
1-720   Project Documents
2-010   Std Soil Tests
2-050   Demolition
2-070   Selective Demolition
2-075   Concrete Removal
2-140   Dewatering
2-142   Sand Drains
2-146   French Drains
2-148   Relief Wells
2-210   Grading
2-220   Excavate & Backfill
2-225   Trucking & Hauling
2-240   Soil Stabilization
2-270   Erosion Control
2-280   Soil Treatment
2-290   Earth Dams
2-300   Tunneling
2-350   Piles and Caissons
2-355   Pile Driving
2-360   Driven Piles
2-380   Caissons
2-450   Railroad Work
2-510   Asphalt Paving
2-520   Cement Paving
2-575   Pvmt Repair/Sealing
2-580   Pavement Marking
2-600   Utility Piping
2-610   Pipe and Fittings
2-665   Water Dist. Systems
2-670   Water Wells
2-685   Gas Distribution Systems
2-710   Subdrainage Systems
2-720   Storm Sewerage
2-740   Septic Systems
2-810   Irrigation Systems
2-830   Fences and Gates
2-840   Walk/Road/Park Equip
2-860   Playfield Equipment
2-870   Site & Street Equip
2-900   Landscaping
2-920   Soil Preparation
2-930   Lawns and Grasses
2-950   Trees & Plants
3-110   Structural Formwork
3-130   Permanent Forms
3-210   Reinforcing Steel
3-220   Welded Wire Fabric
3-230   Stressing Tendons
3-250   Concrete Accessories
3-310   Structural Concrete
3-345   Concrete Finishing
3-360   Specialty Concrete
3-370   Concrete Curing
3-410   Structural Precast
3-450   Architectural Precast
3-470   Tilt-Up Precast
3-510   Gypsum Concrete Deck
3-520   Insulate Concrete Deck
3-530   Cement/Wood Fiber
3-600   Grout
3-710   Concrete Cleaning
3-730   Concrete Rehab
4-100   Mortar & Mason Grout
4-150   Masonry Accessories
4-210   Brick Unit Masonry
4-220   Concrete Unit Masonry
4-270   Glass Unit Masonry
4-280   Gypsum Unit Masonry
4-400   Stone
4-450   Stone Veneer
4-455   Stone Marble
4-460   Stone Limestone
4-465   Stone Granite
4-475   Stone Slate
4-510   Masonry Cleaning
4-520   Masonry Restoration
4-550   Refractories
4-555   Flue Liners
4-560   Combustion Chambers
4-565   Firebrick
4-570   Castable Refractories
4-600   Corrosn Resis. Mason
4-605   Chem. Resist. Brick
5-050   Metal Fastening
5-120   Structural Steel
5-210   Steel Joists
5-310   Steel Decking
5-410   L-B Metal Stud Sys.
5-420   C-F Metal Joist Sys.
5-510   Metal Stairs
5-515   Ladders
5-520   Handrails & Railings
5-540   Castings
5-720   Ornamental Handrail
5-725   Ornamental Castings
5-730   Ornamental Sheet
5-810   Expan. Joint Cover Assemblies
6-050   Fasteners
6-110   Wood Framing
6-120   Structural Panels
6-180   Glued-Lam Constr.
6-190   Wood Trusses
6-220   Millwork
6-240   Laminates
6-260   Board Paneling
6-300   Wood Treatment
6-410   Custom Casework
6-430   Stairwork & Handrail
6-450   Standing & Run Trim
6-460   Exterior Frames
6-480   Custom Wood Turning
7-110   Sheet Membrane Waterproofing
7-120   Fluid Applied Waterproofing
7-130   Bentonite Waterproofing
7-140   Metal Oxide Waterproofing
7-160   Bituminous Dampproof
7-175   Cementitious Dampproofing
7-190   Vapor Retarders
7-200   Insulation
7-210   Building Insulation
7-220   Roof & Deck Insulatn
7-250   Fireproofing
7-310   Shingles
7-410   Roof & Wall Panels
7-460   Manufactured Siding
7-510   Built-Up Bituminous Roof
7-520   Prepared Roll Roof
7-530   Single Ply Membrane Roof
7-540   Fluid Applied Roof
7-610   Sheet Metal Roofing
7-620   Sheet Metal Flashing & Trim
7-630   Sheet Metal Roof Specialty
7-720   Roof Accessories
7-800   Skylights
7-810   Plastic Skylights
7-820   Metal Skylights
7-910   Joint Filler & Gasket
7-920   Sealants and Calking
8-110   Steel Doors & Frames
8-120   Alum. Doors & Frames
8-210   Wood Doors
8-305   Access Doors
8-310   Sliding Doors
8-320   Security Doors
8-330   Coiling Doors
8-350   Folding Doors
8-360   Rollup Doors
8-365   Vertical Lift Doors
8-375   Hangar Doors
8-390   Screen & Storm Doors
8-410   Entrance Doors
8-470   Revolving Doors
8-510   Steel Windows
8-520   Aluminum Windows
8-610   Wood Windows
8-660   Screen Windows
8-670   Storm Windows
8-710   Door Hardware
8-810   Glass
8-850   Glazing Accessories
8-920   Glazed Alum. Curtain Wall
9-205   Furring and Lathing
9-210   Drywall Plaster
9-220   Portland Cement Plaster
9-225   Adobe Finish
9-250   Drywall
9-260   Gypsum Board Systems
9-270   Gypsum Board Access.
9-310   Floor Tile
9-330    Floor - Quarry Tile
9-410    Portland Cement Terrazzo
9-420    Precast Terrazzo
9-430    Conductive Terrazzo
9-510    Acoustical Ceilings
9-530    Acoustical Insulate
9-560    Wood Strip Flooring
9-565    Wood Block Flooring
9-570    Wood Parquet Floor
9-590    Resilient Wood Floor
9-635    Brick Flooring
9-660    Resilient Tile Floor
9-670    Fluid-Appld Res. Flr
9-675    Static Control Res. Flr
9-682    Carpet Cushion
9-685    Carpet
9-720    Epoxy-Marble Chip Floor
9-790    Slip Resist. Finishes
9-910    Painting - Exterior
9-920    Painting - Interior
9-930    Painting - Transparent
9-950    Wall Cover - Access
9-960    Wall Cover - Vinyl
9-965    Wall Cover - Cork
9-975    Wall Cover - Fabrics
9-980    Wall Cover - FlexWood
10-160   Toilet Part. Metal
10-170   Toilet Part. Plastic
10-185   Dressing Compartment
10-190   Cubicles
10-270   Access Flooring
10-290   Pest Control
10-350   Flagpoles
10-410   Bulletin Boards
10-420   Plaques
10-430   Exterior Signs
10-456   Turnstyles
10-500   Lockers
10-522   Fire Ext. Portable
10-526   Fire Ext. Cabinet
10-551   Mail Chutes
10-552   Mail Boxes
10-605   Wire Mesh Partitions
10-615   Demountable Partitions
10-650   Operable Partitions
10-670   Storage Shelving
10-800   Toilet & Bath Access.
10-900   Wardrobe & Closet
11-012   Vacuum Systems
11-020   Security & Vault Eq
11-060   Theater & Stage Eq
11-090   Checkroom Equipment
11-110   Laundry & Dry Clean Eq
11-161   Dock Levelers
11-163   Portable Ramps
11-164   Dock Seals & Shelter
11-165   Dock Bumpers
11-171   Packaged Incinerator
11-172   Waste Compactors
11-175   Chutes & Collectors
11-405   Food Storage Equip
11-410   Food Preparation Eq
11-420   Food Cooking Equip
11-435   Ice Machines
11-440   Cleaning & Disposal Eq
11-450   Residential Equip
11-458   Disappearing Stairs
11-460   Unit Kitchen
11-470   Darkroom Equipment
11-480   Athletic/Therapeutic Eq
11-700   Medical Equipment
11-730   Patient Care Equip
12-100   Artwork
12-500   Window Treatment
12-510   Blinds
12-530   Curtain Hardware
12-600   Furniture & Access.
12-670   Rugs and Mats
12-700   Multiple Seating
12-800   Interior Plants
12-900   Janitorial Material
13-056   Vaults
13-090   Radiation Protection
13-121   Pre-Engineered Building
13-122   Metal Building System
13-152   Swimming Pool Eq
13-810   Energy Monitoring System
14-210   Electric Traction Elevator
14-240   Hydraulic Elevators
14-310   Escalators
14-320   Moving Walks
14-410   People Lifts
14-420   Wheelchair Lifts
14-440   Sidewalk Lifts
14-450   Vehicle Lifts
14-560   Chutes
14-580   Pneumatic Tube Systems
14-600   Hoists and Cranes
14-620   Trolley Hoists
14-630   Bridge Cranes
14-900   Transportation Systems
15-100   Mechanical Sub
15-300   Fire Protection
15-400   Plumbing
15-500   HVAC
15-650   Refrigeration
16-100   Electrical Sub
0        Salary Pay               Regular
1        Regular Hourly Pay       Regular
2        Overtime 1.5             Overtime
3        Double Time              Overtime
4        Sick $ Paid              Other
5        Vac $ Paid               Other
6        Sick Hrs Earned          Accrual
7        Sick Hrs Taken           Accrual
8        Vac Hrs Earned           Accrual
9        Vac Hrs Taken            Accrual
10       Cash Fringe              Cash fringe
BONUS    Bonus                    Other
DT       Doubletime               Overtime
INJ      Injuries                 Accrual
LOAN     Loan/Advance             Other
MILES    Mileage Reimbursement    Reimbursement
NOSHOW No Show Days               Accrual
OT       Overtime                 Overtime
REG      Regular                  Regular
SAL      Salary                   Regular
SICK     Sick Taken               Other
         Sick
SICK_ACCRU Hours Accrual          Accrual
U_VAC    Union Vacation           Other
VAC      Vacation Taken           Other
         Vacation Hours Accrual
VAC_ACCRUE                        Accrual

				
DOCUMENT INFO
Shared By:
Categories:
Stats:
views:1509
posted:3/9/2011
language:English
pages:15
Description: Pay Slip Excel Template document sample