Looking for a spreadsheet template you can use to file 1099-NEC Forms?
This page provides a 1099 NEC Excel Template you can download to your computer, populate using spreadsheet program and then import inside W2 Mate software to print and e-File your 1099-NEC tax forms.
DOWNLOAD 1099 NEC EXCEL TEMPLATE GO TO 1099-NEC DETAILS PAGE
Field Name |
Notes |
Example |
---|---|---|
Recipient's Identification number |
This is a mandatory field. Text field, maximum 11 characters long. |
652-45-7888 |
Recipient's Name (Line One) |
This is a mandatory field. Text field, maximum 40 characters long. |
John Doe |
Recipient's Name (Line Two) |
Text field, maximum 40 characters long. |
|
Recipient's Address1 |
Text field, maximum 30 characters long. |
South Orange Drive |
Recipient's Address2 |
Text field, maximum 30 characters long. |
Apt. E. |
Recipient's City |
Text field, maximum 20 characters long. |
Banana Town |
Recipient's State |
Must be one of the following: AA, AC, AE, AK, AL, AP, AR, AS, AZ, CA, CO, CT, DC, DE, FL, GA, GU, HI, IA, ID, IL, IN, KS, KY, LA, MA, MD, ME, MI, MN, MO, MP, MS, MT, NC, ND, NE, NH, NJ, NM, NV, NY, OH, OK, OR, PA, PR, RI, SC, SD, TN, TX, UT, VA, VI, VT, WA, WI, WV, WY |
IL |
Recipient's Zip Code |
Text field, maximum 11 characters long. |
25201 |
Email Address |
Text field, maximum 100 characters long. |
janedoe@janedoeinc.com |
Account Number |
Text field, maximum 12 characters long. |
652-999 |
Box 1 (Nonemployee compensation) |
Numeric field (shouldn’t include any non-numeric characters like a ","). |
5666.26 |
Box 4 (Federal income tax withheld) |
Numeric field (shouldn’t include any non-numeric characters like a ","). |
166.43 |
State tax withheld Line 1 |
Numeric field (shouldn’t include any non-numeric characters like a ","). |
121.1 |
State/Payer's state no. Line 1 |
Text field, maximum 20 characters long. Must be formatted State Abbreviation/State ID such as IL/2851417 . |
IL/2851417 |
State income Line 1 |
Numeric field (shouldn’t include any non-numeric characters like a ","). |
25212.12 |
State tax withheld Line 2 |
Numeric field (shouldn’t include any non-numeric characters like a ","). |
2351.1 |
State/Payer's state no. Line 2 |
Text field, maximum 20 characters long. Must be formatted State Abbreviation/State ID such as IL/2851417 . |
IL/2851417 |
State income Line 2 |
Numeric field (shouldn’t include any non-numeric characters like a ","). |
36212.12 |
FATCA filing requirement |
This field can either be 1 or 0. 1 means the check box is checked and 0, means it is unchecked. |
0 |
2nd TIN not. |
This field can either be 1 or 0. 1 means the check box is checked and 0, means it’s unchecked. |
0 |
Live Chat
sales@realtaxtools.com
1-800-507-1992
info@realtaxtools.com
1-708-479-8731
Real Business Solutions
18313 Distinctive Drive
Orland Park, IL USA 60467
Real Business Solutions was founded in the state of Illinois in 2003.
support@realtaxtools.com
1-708-590-6376
Fax: 1-708-590-0910
In 2013, we celebrated our 10th Anniversary
© Copyright 2019 Real Business Solutions. All Rights Reserved. Privacy statement and terms of use. Uninstall Instructions