Documents
Resources
Learning Center
Upload
Plans & pricing Sign in
Sign Out

W2 Tax Forms

VIEWS: 79 PAGES: 5

W2 Tax Forms document sample

More Info
									Office Connector                                      Payroll Year End                                              7/20/2010
761551d8-3622-47c5-8ae8-43e5dc12892e.xls                                                                            12:18 PM


W2 Requirements Worksheet
Timberline Construction
C:\PROGRAM FILES\TIMBERLINE OFFICE\ACCOUNTING\CONSTRUCTION SAMPLE DATA


This worksheet provides a count of the number of employees having YTD wages for federal, each state and each local tax.
This can be used to help you determine the number of W2 forms you require.



Federal Run   Employees       State Run Description          Employees       Local Run    Description         Employees
                      51      OR        Oregon SWH                   51      BVTN         Beaverton Local             33
Event 1Office Connector                           Payroll Year End                                    7/20/2010
761551d8-3622-47c5-8ae8-43e5dc12892e.xls                                                              12:18 PM

Year End Payroll - Pay ID Review
Timberline Construction
C:\PROGRAM FILES\TIMBERLINE OFFICE\ACCOUNTING\CONSTRUCTION SAMPLE DATA

Use this worksheet to verify that Pay Ids have been correctly identified for retaining balances at year-
end. Also identify Pay Ids that are not being used that can potentially be eliminated.



Retain YTD
Totals for these Pay Ids will be retained when the year is closed.
                      General Information                                   Current Usage
                                                                                              Union
                                                                       Employee   Employee     Item
Pay ID                       Description               Pay Type         YTD Pay Pay Records Records
INJ                          Injuries                  Accrual          #NAME?      #NAME? #NAME?
NOSHOW                       No Show Days              Accrual          #NAME?      #NAME? #NAME?
SICK_ACCRU                   Sick Hours Accrual        Accrual          #NAME?      #NAME? #NAME?
VAC_ACCRUE                   Vacation Hours Accrual    Accrual          #NAME?      #NAME? #NAME?

Do Not Retain YTD
Totals for these Pay Ids will be cleared when the year is closed.
                      General Information                                   Current Usage
                                                                                                 Union
                                                                       Employee   Employee        Item
Pay ID                       Description               Pay Type         YTD Pay Pay Records    Records
0                            Salary Pay                Regular          #NAME?      #NAME?     #NAME?
1                            Regular Hourly Pay        Regular          #NAME?      #NAME?     #NAME?
2                            Overtime 1.5              Overtime         #NAME?      #NAME?     #NAME?
3                            Double Time               Overtime         #NAME?      #NAME?     #NAME?
4                            Sick $ Paid               Other            #NAME?      #NAME?     #NAME?
5                            Vac $ Paid                Other            #NAME?      #NAME?     #NAME?
6                            Sick Hrs Earned           Accrual          #NAME?      #NAME?     #NAME?
7                            Sick Hrs Taken            Accrual          #NAME?      #NAME?     #NAME?
8                            Vac Hrs Earned            Accrual          #NAME?      #NAME?     #NAME?
9                            Vac Hrs Taken             Accrual          #NAME?      #NAME?     #NAME?
10                           Cash Fringe               Cash fringe      #NAME?      #NAME?     #NAME?
BONUS                        Bonus                     Other            #NAME?      #NAME?     #NAME?
DT                           Doubletime                Overtime         #NAME?      #NAME?     #NAME?
LOAN                         Loan/Advance              Other            #NAME?      #NAME?     #NAME?
MILES                        Mileage Reimbursement     Reimbursement    #NAME?      #NAME?     #NAME?
OT                           Overtime                  Overtime         #NAME?      #NAME?     #NAME?
REG                          Regular                   Regular          #NAME?      #NAME?     #NAME?
SAL                          Salary                    Regular          #NAME?      #NAME?     #NAME?
SICK                         Sick Taken                Other            #NAME?      #NAME?     #NAME?
U_VAC                        Union Vacation            Other            #NAME?      #NAME?     #NAME?
VAC                          Vacation Taken            Other            #NAME?      #NAME?     #NAME?

To change whether the balance for a Pay ID will be retained or not, open Payroll and go to
Event 1 Office Connector                     Payroll Year End                                       7/20/2010
761551d8-3622-47c5-8ae8-43e5dc12892e.xls                                                            12:18 PM

Year End Payroll - Deduction ID Review
Timberline Construction
C:\PROGRAM FILES\TIMBERLINE OFFICE\ACCOUNTING\CONSTRUCTION SAMPLE DATA

Use this worksheet to verify that Deduction Ids have been correctly identified for retaining
balances at year-end. Also identify Deduction Ids that are not being used that can potentially be
eliminated.



Retain YTD
Totals for these Deduction Ids will be retained when the year is closed.
                    General Information                                     Current Usage
                                                                    Employee Employee
Deduction                                                                YTD      Deduct Union Item
ID             Description                   Deduct Type           Deductions    Records   Records
                                                                      #NAME?     #NAME?    #NAME?
                                                                      #NAME?     #NAME?    #NAME?

Do Not Retain YTD
Totals for these Deduction Ids will be cleared when the year is closed.
                      General Information                                   Current Usage
                                                                    Employee Employee
Deduction                                                                YTD      Deduct Union Item
ID             Description                  Deduct Type            Deductions    Records   Records
401K           401K Deduction               Normal                   #NAME?      #NAME?    #NAME?
DD             Direct Deposit               Net direct deposit       #NAME?      #NAME?    #NAME?
DUES           Union Dues                   Normal                   #NAME?      #NAME?    #NAME?
GARN           Garnishment                  Normal                   #NAME?      #NAME?    #NAME?
LOAN           Loan Repayment               Normal                   #NAME?      #NAME?    #NAME?
MED            Medical Insurance            Normal                   #NAME?      #NAME?    #NAME?
SAV            Savings Plan                 Normal                   #NAME?      #NAME?    #NAME?
U_VAC          Union Vacation               Normal                   #NAME?      #NAME?    #NAME?
Event 1 Office Connector                         Payroll Year End                               7/20/2010
761551d8-3622-47c5-8ae8-43e5dc12892e.xls                                                        12:18 PM

Year End Payroll - Fringe ID Review
Timberline Construction
C:\PROGRAM FILES\TIMBERLINE OFFICE\ACCOUNTING\CONSTRUCTION SAMPLE DATA

Use this worksheet to verify that Fringe Ids have been correctly identified for retaining
balances at year-end. Also identify Fringe Ids that are not being used that can
potentially be eliminated.


Retain YTD
Totals for these Fringe Ids will be retained when the year is closed.
                  General Information                                  Current Usage
                                                                            Employee Union
                                                          Employee YTD Fringe         Item
Fringe ID Description                    Auto Employee          Fringe       Records Records
                                                                  #NAME?      #NAME? #NAME?
                                                                  #NAME?      #NAME? #NAME?

Do Not Retain YTD
Totals for these Fringe Ids will be cleared when the year is closed.
                  General Information                               Current Usage
                                                                         Employee       Union
                                                               Employee      Fringe      Item
Fringe ID   Description                Auto Employee          YTD Fringe   Records    Records
401K        401K Matching                   False               #NAME?     #NAME?     #NAME?
ANN         Annuity                         False               #NAME?     #NAME?     #NAME?
EDC         Education Fund                  False               #NAME?     #NAME?     #NAME?
H&W         Health & Welfare                False               #NAME?     #NAME?     #NAME?
IND         Industry Fund                   False               #NAME?     #NAME?     #NAME?
INSUR       Insurance                       False               #NAME?     #NAME?     #NAME?
PEN         Pension Fund                    False               #NAME?     #NAME?     #NAME?
WC          Workers' Compensation           False               #NAME?     #NAME?     #NAME?

To change whether the balance for a Fringe ID will be retained or not, open Payroll and
Event 1 Office Connector                   Payroll Year End                                   7/20/2010
761551d8-3622-47c5-8ae8-43e5dc12892e.xls                                                      12:18 PM

Year End Allocation Worksheet
Timberline Construction
C:\PROGRAM FILES\TIMBERLINE OFFICE\ACCOUNTING\CONSTRUCTION SAMPLE DATA


This worksheet can be used to determine year-end allocation of payroll costs that are split
between calendar years. The first table shows cost from time entries that have been recorded but
not posted. The second table shows cost from burden that has been processed but not posted.
Both are summarized by Job, Extra, Cost Code, Category and GL expense account.


Percentage to allocate:           25 %

Time
Job Number     Extra      Cost Code Category    GL Account              Amount         Allocation
                                                21-6002            $      214.20   $       53.55
                                                21-6003            $       14.00   $        3.50
03-001                    2-520     L           21-5001            $      157.24   $       39.31
03-001                    2-520     OT          21-5001            $      380.19   $       95.05
03-001                    5-210     L           21-5001            $      799.48   $      199.87
03-001                    5-310     L           21-5001            $    1,942.94   $      485.74
03-001                    6-110     L           21-5001            $    1,316.72   $      329.18
03-001                    6-110     OT          21-5001            $      351.90   $       87.98
03-001                    6-120     L           21-5001            $      879.12   $      219.78
03-002                    4-220     L           21-5001            $    1,523.52   $      380.88
03-003                    3-310     L           21-5001            $    1,266.00   $      316.50
03-003                    3-345     L           21-5001            $    1,734.00   $      433.50
                                                                   $   10,579.31   $    2,644.83



Burden
Job Number     Extra      Cost Code Category    GL Account              Amount         Allocation
                                                10-6005            $       95.24   $       23.81
                                                21-6006            $       17.48   $        4.37
03-001                    2-520     LB          21-5001            $      164.83   $       41.21
03-001                    5-210     LB          21-5001            $      396.74   $       99.19
03-001                    5-310     LB          21-5001            $      940.04   $      235.01
03-001                    6-110     LB          21-5001            $      746.05   $      186.51
03-001                    6-120     LB          21-5001            $      419.23   $      104.81
03-002                    4-220     LB          21-5001            $      520.21   $      130.05
03-003                    3-310     LB          21-5001            $      286.99   $       71.75
03-003                    3-345     LB          21-5001            $      445.99   $      111.50
                                                                   $    4,032.80   $    1,008.20

								
To top