Dallas Payroll - Sample Spreadsheets -

Sample Spreadsheets

Sample Check Register

0000*SAMPLE                                             Sample Company, Inc.                                              Page:    1
                                                           Check Register
                                               December 1, 2000 to December 31, 2000
Check number  Date     Payee
          Gross    Overtime       Other        1099        FICA    Medicare         FWT        401k    Misc Ded            Net
10206         12/15/00 General Insurance Group       
           0.00        0.00        0.00        0.00        0.00        0.00        0.00        0.00        0.00           0.00
10208         12/15/00 NATIONS BANK                  
           0.00        0.00        0.00        0.00        0.00        0.00        0.00        0.00        0.00       1,639.41
10209         12/15/00 (2) Adler, Jimmy A.               
       1,332.00        0.00        0.00        0.00      -82.58      -19.31     -141.99        0.00     -115.00         973.12
10210         12/15/00 (4) Bell, Mary Elizabeth          
         650.00        0.00        0.00        0.00      -40.30       -9.43      -63.44        0.00        0.00         536.83
10211         12/15/00 (3) Campbell, Johnnie Sue         
       1,000.00        0.00        0.00        0.00      -62.00      -14.50      -57.19        0.00      -95.00         771.31
10212         12/15/00 (1) Johnson, Charlie L.           
       2,900.00        0.00        0.00        0.00     -179.80      -42.05     -476.85        0.00     -438.00       1,763.30
12013         12/31/00 Texas Child Support Agent     
           0.00        0.00        0.00        0.00        0.00        0.00        0.00        0.00        0.00         300.00
12014         12/31/00 NATIONS BANK                  
           0.00        0.00        0.00        0.00        0.00        0.00        0.00        0.00        0.00       1,640.95
12015         12/31/00 (2) Adler, Jimmy A.               
       1,480.00        0.00        0.00        0.00      -91.76      -21.46     -164.19        0.00     -115.00       1,087.59
12016         12/31/00 (4) Bell, Mary Elizabeth          
         650.00        0.00        0.00        0.00      -40.30       -9.42      -63.44        0.00        0.00         536.84
12017         12/31/00 (3) Campbell, Johnnie Sue         
       1,000.00        0.00        0.00        0.00      -62.00      -14.50      -57.19        0.00      -95.00         771.31
12018         12/31/00 (1) Johnson, Charlie L.           
       2,800.00        0.00        0.00        0.00     -173.60      -40.60     -448.85        0.00     -438.00       1,698.95

                                                           Current Totals
      11,812.00        0.00        0.00        0.00     -732.34     -171.27   -1,473.14        0.00   -1,296.00      11,719.61

Sample Deduction Register

0000*SAMPLE                                             Sample Company, Inc.                                              Page:    1
                                                         Deduction Register
                                               December 1, 2000 to December 31, 2000
Check number  Date     Payee
       Advances  Group Med Ins     Dental Ins  Dependent Ins  Child Support
10206         12/15/00 General Insurance Group       
           0.00           0.00           0.00           0.00           0.00
10208         12/15/00 NATIONS BANK                  
           0.00           0.00           0.00           0.00           0.00
10209         12/15/00 (2) Adler, Jimmy A.               
           0.00        -115.00           0.00           0.00           0.00
10210         12/15/00 (4) Bell, Mary Elizabeth          
           0.00           0.00           0.00           0.00           0.00
10211         12/15/00 (3) Campbell, Johnnie Sue         
           0.00         -95.00           0.00           0.00           0.00
10212         12/15/00 (1) Johnson, Charlie L.           
           0.00        -138.00           0.00           0.00        -300.00
12013         12/31/00 Texas Child Support Agent     
           0.00           0.00           0.00           0.00           0.00
12014         12/31/00 NATIONS BANK                  
           0.00           0.00           0.00           0.00           0.00
12015         12/31/00 (2) Adler, Jimmy A.               
           0.00        -115.00           0.00           0.00           0.00
12016         12/31/00 (4) Bell, Mary Elizabeth          
           0.00           0.00           0.00           0.00           0.00
12017         12/31/00 (3) Campbell, Johnnie Sue         
           0.00         -95.00           0.00           0.00           0.00
12018         12/31/00 (1) Johnson, Charlie L.           
           0.00        -138.00           0.00           0.00        -300.00

                                                           Current Totals
           0.00        -696.00           0.00           0.00        -600.00

Sample Earnings Record

0000*SAMPLE                                             Sample Company, Inc.                                              Page:    1
                                                          Earnings Record
                                               December 1, 2000 to December 31, 2000
          Gross    Overtime       Other        1099        FICA    Medicare         FWT        401k    Misc Ded            Net

Employee # 2           541-32-8861 Adler, Jimmy A.           321 Someother Street     Garland, TX  75040
------------------------------------------------------------------------------------------------------------------------------------
10209         12/15/00    Adler, Jimmy A.               
       1,332.00        0.00        0.00        0.00      -82.58      -19.31     -141.99        0.00     -115.00         973.12
12015         12/31/00    Adler, Jimmy A.               
       1,480.00        0.00        0.00        0.00      -91.76      -21.46     -164.19        0.00     -115.00       1,087.59
------------------------------------------------------------------------------------------------------------------------------------
                                                           Current Totals
       2,812.00        0.00        0.00        0.00     -174.34      -40.77     -306.18        0.00     -230.00       2,060.71
                                                          Quarterly Totals
      11,520.50        0.00        0.00        0.00     -714.27     -167.05   -1,265.55        0.00        0.00       9,373.63
       9,606.13        0.00        0.00        0.00     -595.58     -139.29   -1,094.05        0.00     -230.00       7,547.21
       7,964.25        0.00        0.00        0.00     -493.78     -115.48     -905.57        0.00     -575.00       5,874.42
       8,843.00        0.00        0.00        0.00     -548.27     -128.22     -979.59        0.00     -690.00       6,496.92
                                                        Year to Date Totals
      37,933.88        0.00        0.00        0.00   -2,351.90     -550.04   -4,244.76        0.00   -1,495.00      29,292.18
************************************************************************************************************************************

Employee # 4           745-25-9565 Bell, Mary Elizabeth      5965 Smart Court, #B-45  Dallas, TX  75228
------------------------------------------------------------------------------------------------------------------------------------
10210         12/15/00    Bell, Mary Elizabeth          
         650.00        0.00        0.00        0.00      -40.30       -9.43      -63.44        0.00        0.00         536.83
12016         12/31/00    Bell, Mary Elizabeth          
         650.00        0.00        0.00        0.00      -40.30       -9.42      -63.44        0.00        0.00         536.84
------------------------------------------------------------------------------------------------------------------------------------
                                                           Current Totals
       1,300.00        0.00        0.00        0.00      -80.60      -18.85     -126.88        0.00        0.00       1,073.67
                                                          Quarterly Totals
           0.00        0.00        0.00        0.00        0.00        0.00        0.00        0.00        0.00           0.00
           0.00        0.00        0.00        0.00        0.00        0.00        0.00        0.00        0.00           0.00
           0.00        0.00        0.00        0.00        0.00        0.00        0.00        0.00        0.00           0.00
       3,900.00        0.00        0.00        0.00     -241.80      -56.55     -380.64        0.00        0.00       3,221.01
                                                        Year to Date Totals
       3,900.00        0.00        0.00        0.00     -241.80      -56.55     -380.64        0.00        0.00       3,221.01
************************************************************************************************************************************

Employee # 3           000-00-0000 Campbell, Johnnie Sue     129 South Jones          Dallas, TX  75228
------------------------------------------------------------------------------------------------------------------------------------
10211         12/15/00    Campbell, Johnnie Sue         
       1,000.00        0.00        0.00        0.00      -62.00      -14.50      -57.19        0.00      -95.00         771.31
12017         12/31/00    Campbell, Johnnie Sue         
       1,000.00        0.00        0.00        0.00      -62.00      -14.50      -57.19        0.00      -95.00         771.31
------------------------------------------------------------------------------------------------------------------------------------
                                                           Current Totals
       2,000.00        0.00        0.00        0.00     -124.00      -29.00     -114.38        0.00     -190.00       1,542.62
                                                          Quarterly Totals
       7,400.00        0.00        0.00        0.00     -458.80     -107.30     -367.48        0.00        0.00       6,466.42
       5,800.00        0.00        0.00        0.00     -359.60      -84.10     -313.14        0.00     -190.00       4,853.16
       4,985.00        0.00        0.00        0.00     -309.07      -72.28     -283.70        0.00     -475.00       3,844.95
       6,000.00        0.00        0.00        0.00     -372.00      -87.00     -343.14        0.00     -570.00       4,627.86
                                                        Year to Date Totals
      24,185.00        0.00        0.00        0.00   -1,499.47     -350.68   -1,307.46        0.00   -1,235.00      19,792.39
************************************************************************************************************************************

Sample Hours Worked Report

0000*SAMPLE                                            SAMPLE COMPANY                                      Page:    1
                                                 Departmental Hours Report
                                           December 1, 2000 to December 31, 2000
Check number  Date     Payee
   Regular  Overtime     Bonus  Vacation   Holiday      Sick  Personal  Contract       Total
3667          12/20/02 (2618) McGEE, DWIGHT                 
     23.50      0.00      0.00      0.00      0.00      0.00      0.00      0.00       23.50
22712         12/06/02 (2555) BERNARD, RUBEN                
     40.00      7.00      0.00      0.00      0.00      0.00      0.00      0.00       47.00
22713         12/06/02 (2548) CLAYBORNE, BILLY              
     24.00      0.00      0.00      0.00      0.00      0.00      0.00      0.00       24.00
22714         12/06/02 (2452) EURESTI, GABRIEL              
     16.00      0.00      0.00      0.00      0.00      0.00      0.00      0.00       16.00
22715         12/06/02 (2489) EVERETT, JAMES                
     40.00      9.00      0.00      0.00      0.00      0.00      0.00      0.00       49.00
22716         12/06/02 (2545) FENDLEY, MELISSA              
     40.00     14.75      0.00      0.00      0.00      0.00      0.00      0.00       54.75
22717         12/06/02 (2488) FISHER, JIMMY R.              
     40.00     17.00      0.00      0.00      0.00      0.00      0.00      0.00       57.00
22718         12/06/02 (2360) GENTRY, REX GLENN             
     36.00      0.00      0.00      0.00      8.00      0.00      0.00      0.00       44.00
22719         12/06/02 (2556) HEAD, STEVE                   
     29.00      0.00      0.00      0.00      0.00      0.00      0.00      0.00       29.00
22720         12/06/02 (2579) HENEXSON, GARY                
     15.00      0.00      0.00      0.00      0.00      0.00      0.00      0.00       15.00
22721         12/06/02 (2479) JUAREZ, ALEJANDRO             
     26.00      0.00      0.00      0.00      0.00      0.00      0.00      0.00       26.00
22722         12/06/02 (2587) KILUTU, DESIRE                
     40.00     14.00      0.00      0.00      0.00      0.00      0.00      0.00       54.00
22723         12/06/02 (2598) LANZI, CRAIG                  
     26.00      0.00      0.00      0.00      0.00      0.00      0.00      0.00       26.00
22724         12/06/02 (2318) MCMAHON, BILLY                
     24.00      0.00      0.00      0.00      0.00      0.00      0.00      0.00       24.00
22725         12/06/02 (2451) MEDINA, GEORGE                
     40.00     12.00      0.00      0.00      8.00      0.00      0.00      0.00       60.00
22726         12/06/02 (2551) MEDINA, JOSE                  
     32.00      0.00      0.00      0.00      0.00      0.00      0.00      0.00       32.00
22727         12/06/02 (2389) McLAUGHLIN, CAROLYN           
     24.00      0.00      0.00      0.00      8.00      0.00      0.00      0.00       32.00
22728         12/06/02 (2388) McLAUGHLIN, KEVIN             
      8.00      0.00      0.00      0.00      0.00      0.00      0.00      0.00        8.00
22729         12/06/02 (2420) PAZ, JAVIER                   
     40.00     15.00      0.00      0.00      8.00      0.00      0.00      0.00       63.00
22730         12/06/02 (2539) REYES, DANIEL                 
     40.00      7.00      0.00      0.00      0.00      0.00      0.00      0.00       47.00

Sample Employee Data Sheet

0000*SAMPLE                                Sample Company, Inc.                                  Page:    1
                                            Employee Data Sheet
                                               June 11, 2003

Employee number....2           
Social Security....541-32-8861                                        Family Member         [N]
Name...........Adler, Jimmy A.                                        Citizen               [Y]
Address 1......321 Someother Street                                   Statutory Emp.        [N]
Address 2......Apartment 204                                          Deceased              [N]
City,St. Zip...Garland, TX  75040                                     Pension Plan          [N]
Phone..........(972)555-8794                                          Legal Representative  [N]
Birth Date.....10/06/70                                               Section 942           [N]
Marital Status.Married                                                Deferred Compensation [N]
Hire Date......09/06/89                                               Pay Period............Semi-Monthly
Raise Date.....10/01/98                                               Employee Status.......Active
Department.....     

Pay Chart:
Skill Code & Description                            Type         Hours/Sal       Rate/Amt      Remainder
-----------------------------------------------------------------------------------------------------------
102     Wages                                       Wage             80.00          18.50               
400     FICA Withheld                               Deduction    Calculate        Formula      Unlimited
401     Medicare Withholding                        Deduction    Calculate        Formula      Unlimited
500     FIT Withholding                             Deduction    Calculate        Formula      Unlimited
802     Group Medical                               Deduction    Flat Rate         115.00      Unlimited
-----------------------------------------------------------------------------------------------------------
Exemptions Table:
Description          Exemptions    Addl. W/H Type    Addl. W/H Rate    Dependent Credit
------------------------------------------------------------------------------------------
Federal                  1                                                       
State                                                                            
Local

Dallas Payroll – Sample Spreadsheets

Dallas Payroll – Sample Spreadsheets

Sample Spreadsheets