Many companies use other enterprise or accounting software to print and/or electronically submit the 1099’s. Other companies use a third party vendor who offers this as a service. The new option “Create 1099 Spreadsheet” is designed for these situations.

Using this option, REAL/Easy will compute the 1099’s totals for the Independent Associates and Outside Companies in the same manner as with the Print and Disk options. This file contains the information commonly needed by the other software and/or vendor such as names, SSN/EIN’s, the ID type, and the payee name/address information and 1099 total amount.

Operation of spreadsheet creation option is identical selection-wise. On the bottom of the window you must enter the spreadsheet name including the “.xls” extension into the “Excel File Name” box.

To start processing, click the “Save to Excel File” button.

When the process is completed, you can view immediately by pressing the “Open Excel File” button (which will be activated when processing is complete and the file is created).

 Below is a sample 1099 Excel spreadsheet file:

The columns included are:

• Code: the BOS ID code for the agent and/or outside company
• Comp: the state the 1099 is completed for
• SIN: the social security number or federal ID for the Agent/Corporation-Incorporated Agent
• TIN: the tax id type in the previous column, 1=Federal EIN and 2- Social Security number
• NAME: the “Report” name for the Agent/Outside company
• Address, City, State, ZIP are from the payee records entered in REAL/Easy
• Earnings: are the 1099 gross earnings for the payee.

 When you have completed your processing, click the “Close” button to exit.

 Want Everyone in your Company to Run it Like a Business? run REAL/Easy 1-800-REALEASy (1-800-732-5327)