Follow

Tax Form Template Upload Tips

 

Tax Form Template Upload Tips for Forms 1099 and W-2

       

Required Fields

Field Definition

Column

Conditions

Form Type

Form Name

Column A

All capital letters; include hyphen

pfin

Payer TIN

Column B

Format with hyphens

pname

Payer Name

Column C

1099s A-Z, 0-9, hyphen, ampersand allowed; W-2 A-Z, 0-9, hyphen, period, apostrophe allowed

paddress1

Payer Address

Column D

Foreign addresses not allowed

pcity

Payer City

Column F

 

pstate

Payer State

Column G

Two character abbreviation only A-Z; remove extra spaces after abbreviation

pzip

Payer Zip Code

Column H

5-digit ZIP only

pphone

Payer Phone

Column I

Format as XXX-XXX-XXXX

rfin

Recipient TIN

Column K

Format with hyphens

rname1

Recipient Name

Column L

1099s A-Z, 0-9, hyphen, ampersand allowed; W-2 A-Z, 0-9, hyphen, period, apostrophe allowed

raddress1

Recipient Address

Column O

Foreign addresses not allowed

rcity

Recipient City

Column Q

 

rstate

Recipient State

Column R

Two character abbreviation only A-Z; remove extra spaces after abbreviation

rcountry

Recipient Country

Column S

Must contain 2 alpha characters only

rzip

Recipient Zip

Column T

5-digit ZIP only

 

 

 

 

Non-Required Fields

Field Definition

Column

Conditions

Amount Fields

 

Varies by Form

Comma and period only, no dollar signs; if amount is 0, leave blank

Phone Extension

 

Columns J & V

4-digit extension only, do not use phone number

State

 

Varies by Form

Two character abbreviation only

 

 

 

 

Form 1099-S (f3)

Address or  Legal Description

Y

39 character limitation

1099-C (f4)

Debt Description

Z

39 character limitation

       
       

If customer receives notice of errors but the error screen is blank:

 

1)

Check for blank spaces after text in text fields by double clicking on the right end of a cell.

 

If there is space between the last character and the blinking cursor, there are blank spaces in the cell.

       

2)

Check for foreign address.

   
       

NOTE:  All required fields will have the column heading for each tax form shaded red

   
   

Tax Form Template Upload Tips for Form 1042-S

       

Required Fields

Field Definition

Column

Conditions

Form Type

Form Name

Column A

All capital letters; include hyphen

pfin

Payer'd Federal ID Number

Column B

Format with hyphens

pname

Payer Name

Column C

A-Z, 0-9, hyphen, period, apostrophe allowed

paddress1

Payer Address

Column D

Foreign addresses not allowed

pcity

Payer City

Column F

 

pstate

Payer State

Column G

Two character abbreviation only A-Z; remove extra spaces after abbreviation

pzip

Payer Zip Code

Column H

5-digit ZIP only

pphone

Payer Phone

Column I

Format as XXX-XXX-XXXX

rfin

Recipient Tax ID

Column L

Format with hyphens

tRFINType

Recipient Federal ID Number Type

Column M

Enter the 1 digit number for the associated type

 

US TIN is QI-EIN, WP-EIN or WT-EIN that has entered into a withholding agreement with IRS

Column N

Enter True or False

rname1

Recipient Name

Column Q

 

raddress1

Recipient Address

Column T

 

rcity

Recipient City

Column V

 

rstate

Recipient State

Column W

Two character abbreviation only A-Z; remove extra spaces after abbreviation

rcountry

Recipient Country

Column X

Must contain 2 alpha characters only

rzip

Recipient Zip

Column Y

5-digit ZIP only

F17_enc

Recipient GIIN

Column AB

Alpha-numeric format requires alpha characters for 2 digit part of the number : 222222.33333.SP.444

F12a_enc

Withholding Agent EIN

Column AF

Must be 9 numeric digits and include hyphens

tWAEINIndicator

EIN Indicator

Column AG

Enter 0, 1 or 2 according to key

F12b

Ch.3 Status Code

Column AH

2 numeric digits

F12c

Ch.4 Status Code

Column AI

2 numeric digits

tWATitle

Withholding Agent Title

Column AJ

Maximum of 45 alpha-numeric characters

F13a

Withholding Agent Name

Column AK

 

tWAContactName

Withholding Agent Contact Name

Column AL

Maximum of 45 alpha-numeric characters

tWAContactNumber

Contact Number

Column AM

Maximum of 20 characters

F13e

Withholding Agent Address

Column AQ

 

F13f_city

Withholding Agent City

Column AR

 

F13f_state

Withholding Agent State

Column AS

 

F13f_zip

Withholding Agent ZIP

Column AT

maximum of 9 alpha-numeric characters

F1

Income Code

Column BK

Must be 2 numeric digits

F2

Gross Income

Column BL

Maximum of 12 digits and round to nearest whole amount

F7

Federal Tax Withheld

Column BU

Maximum of 12 digits and round to nearest whole amount

       
       

Non-Required Fields

Field Definition

Column

Conditions

GIIN format (non-required other than recipient GIIN)

 

K, AN, BB

Alpha-numeric format requires alpha characters for 2 digit part of the number : 222222.33333.SP.444

Amount fields

 

 

DO NOT INCLUDE DECIMALS.  ROUND TO THE NEAREST WHOLE DOLLAR.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Article is closed for comments.