1099 Electronic Filing Basics

1099-INT Excel Template

Looking for a spreadsheet template you can use to file 1099-INT Forms?

This page provides a 1099-INT 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-INT tax forms.

DOWNLOAD 1099-INT EXCEL TEMPLATE GO TO 1099 SOFTWARE 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.

Suite 500

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

Account Number

Text field, maximum 12 characters long.

652-999

Payer's RTN

Text field, maximum 18 characters long

325272021

Box 1 (Interest income)

Numeric field (shouldn’t include any non-numeric characters like a ",").

5666.26

Box 2 (Early withdrawal penalty)

Numeric field (shouldn’t include any non-numeric characters like a ",").

5721.38

Box 3(Interest on U.S Savings Bonds and Treas. obligations)

Numeric field (shouldn’t include any non-numeric characters like a ",").

5776.5

Box 4 (Federal income tax withheld)

Numeric field (shouldn’t include any non-numeric characters like a ",").

5831.62

Box 5 (Investment expenses)

Numeric field (shouldn’t include any non-numeric characters like a ",").

5886.74

Box 6 (Foreign tax paid)

Numeric field (shouldn’t include any non-numeric characters like a ",").

5941.86

Box 7 (Foreign country or U.S. possession)

Text field, maximum 38 characters long

Japan

Box 8 (Tax-exempt interest)

Numeric field (shouldn’t include any non-numeric characters like a ",").

500.1

Box 9 (Specified private activity bond interest)

Numeric field (shouldn’t include any non-numeric characters like a ",").

100.2

Box 10 Market discount

Numeric field (shouldn’t include any non-numeric characters like a ",").

1458.25

Box 11 Bond premium

Numeric field (shouldn’t include any non-numeric characters like a ",").

863.25

Box 13 Bond premium on tax–exempt bond

Numeric field (shouldn’t include any non-numeric characters like a ",").

55.39

Box 14 Tax-exempt bond CUSIP no.

Text field, maximum 9 characters long.

345370860

Box 15 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

NC

Box 16 State identification no

Text field, maximum 20 characters long.

8554-555-1

Box 17 State tax withheld

Numeric field (shouldn’t include any non-numeric characters like a ",").

205.6

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

Contact Us

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 2018 Real Business Solutions. All Rights Reserved. Privacy statement and terms of use. Uninstall Instructions