ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQARASATAUAVAWAXAYAZBABBBCBDBEBFBGBHBI
1
#VALUE!#VALUE!
Template Version 3.0
2
GROUP NAME:DBA IF APPLIEDPayroll vendor - Internal (Int) or External (Ext) = Market Director Name and Email
3
ADDRESSEFFECTIVE DATEExternal payroll vendor name- Affiliate Name and Email
4
CITY, STATE, ZIPEmployer Contact Name.Phone.emailAddress:
5
SIC CODEPayrollContact Name.Phone.Email
6
7
*Required
**Conditionally Required; (see State Input Requirements Tab for specifics)
8
Division ID Employee IDFirst Name*Last Name*SSN# Full Number*State Employee Files In*Pay Schedule Week/Bi/Monthly...*Exempt From SSGross Wages Per Pay Period*Employee Contribution Major Medical Total PP*401K*Additional Pre-tax Deductions Total PP*Post-tax Deductions Total PP*Federal Additional Withholding Amt $*Federal 2020 W4 Used (Y/N)*Federal Marital/Filing Status*2020 W4 Box 2c: Two Jobs (Y/N)2020 W4 Box 4a $2020 W4 Box 4b $2020 W4 Box 3 $2020 W4 Federal Dependents Amount $Federal Exemptions Claimed*State Marital/Filing Status**State Exemptions Claimed - 1**State Exemptions Claimed - 2State Exemptions Claimed - 3State Additional Withholding Amt $Withholding Rate %
(AZ Only)		Exemption $ Amount Claimed
(MS Only)		Spouse Works (Y/N)
(MO Only)		DO NOT REMOVEDOB*Gender*Hire Date*Email*Mobile Phone
(10 digits no formatting)*		Business Phone
(10 digits no formatting)		Street Address*City*State*Zip
(5 digits)*
9
Company Code. This field is primarily used to differentiate between companies or divisions/locations that are running separate payrolls. If all payrolls are processed at once, this field is no longer necessary.Each employee must have one employee ID, and no employee IDs can be shared between employees.NecessaryNecessaryNo dashes2 Letter abbreviationMust be one of the formats below:If they are exempt from Social Security, they should have a "Y" in this column.This field must be the per pay period amount. It cannot be year to date, or the annual amount.Employee Paid Medical Pre-tax deductionsFlat amount, never a percentageAny other pre-tax deductions. For example, Dental, Vision, anything that subtracts from the employee's gross pay prior to taxes.Any deductions from the employee's net. Examples include Garnishments, life insurance, etc.Any additional Federal withholdings that the employee has elected on their W4. This is a cash amount.Input Y for employees hired in 2020 or later OR employees that have changed their withholding in 2020 that used the new 2020 federal form W-4. Input N if employee has 2019 or earlier W-4 on file.Refer to "Federal Input Instructions" Row 8. Please use the full description from your payroll system.If 2020 W-4 applies, input Y if employee checked the box in Step 2c (Two Jobs), otherwise input N or leave blankColumns R and S are for extreme detail. If we can pull that information great, but we do not require it.Columns R and S are for extreme detail. If we can pull that information great, but we do not require it.If 2020 W-4 applies, input the dollar amount for Step 3 of W-4. This field is interchangeable with the "2020 W4 Federal Dependents Amount $" Column.If 2020 W-4 applies, input the dollar amount for Step 3 of W-4. This field is interchangeable with the "2020 W4 Box 3 $" Column.If 2020 W-4 does NOT apply and employee is using older W-4, input total number of allowances claimedThis will be specific to each state. Please give us the description here as detailed below.This column is for personal state exemptionsThis column is for dependent State ExemptionsIf a state has exemptions other than Personal and Dependent exemptions, this is where those can be housed. Michigan for example has a blind exemption that would be housed here.Any additional state withholdings elected by the employee go in this column.See column E in "State Input Requirements" and look at the comments in cell H5.This is a MS specific column where they claim a cash amount instead of a number like other statesMO specific column that indicates whether a spouse is working.Do Not Remove ColumnStandard MM/DD/YYYY format. Must be presentM, F, or N. N represents anything other than male or female.RequiredPersonal email preferred. Work email is fine.Spaces between numbers are optional.Not RequiredMust be in this format and is necessaryNecessary2 letter abbreviation preferred5 digits only.
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100