Navigation:  Importing Data >

Import Fields

Previous pageReturn to chapter overviewNext page

What do those different fields actually do?

 

Actually, many of the fields are redundant.  We just use different terms because people use different terms.  But, here is what they all mean....

 

 

Name - Name. The first line of a QuickBooks is labeled Blank but in fact is the name.
All Wage Amounts - This value is added to all wage types.
FedWage - Federal Wages
FedWH - Federal Withholdings
FicaWage & SocSecWage - Same thing.
FicaTips - Tips Subject to FICA.
FicaWh & SocSecWh - Employee portion.
MediWage - Wages subject to Medicare Tax
MediWH  - Employee Medicare Tax Withheld
StateWage - State Wages
StateWH & SWH - State Tax Withheld
State Paid In - The State where the wages were earned.  The State we need to report to.
State2Wage - The Second State if paid in more than 1 state.
State2WH - The State Tax Withheld on State2
StateDisability & SDI - State Disability deducted from wages.
LocalWages
LocalWh
Group Insurance
Uncollected FICA Tips
Advanced EIC
Allocated Tips
Fringe Benefits
Deferred Comp
D 401 K
Dependent Care Bene
Section125
E 403B
F 408 k 6
G 457
H 501 c
Excess Golden Parachute
Business Exp
Uncollected FICA Group
Uncollected Medicare Group
Sick Pay
Pension Plan (Y/N)
Statutory Employee (Y/N)
Box 14 - Amount A
Box 14 - Amount B
Box 14 - Amount C
Tin_Type. If a value is in this field it overrides TINisSSN. Values 1=FEIN, 2=SSN
TINisSSN. If Tin_Type is blank and TINisSSN contains a value (any value), then Tin_Type is set to 2
IGNORE THIS FIELD