Exporting 1099 Data from WinMORE

To export 1099 data for use in a 1099 forms Vendor/Software:

1. Click "Year End > 1099 Data Export".
2. Click Yes when presented with the following message:  A window will pop up. It will say, "The File MDAT\SEND\TIN_450.TXT will be created. Do you wish to proceed?"
   (the name of the file includes the MC# and this example is for MC 450.)
3. The file is saved to the \WINMORE3\MDAT\SEND folder where it can be used for processing 1099s through an authorize 1099 provider.

Converting WinMORE txt File to xls for Import

1. Open Excel program
2. Click on open
3. Browse to winmore3/mdat/send and click on the txt_# file
4. At the bottom of the box (files of type) change that to “text files”
5. Click on your txt_# file
6. Click open
7. A text import window opens
8. Click next
9. Change delimiters to “comma” and click next
10. Change “column data format” to "text” 
    NOTE:   If you do not set the column to be text, any leading 0's in a TIN or Zip code will be removed.
11. Click finish

An Excel spreadsheet opens

1. Right click in cell A1 and click “insert”
2. Click “entire row”
3. Type the headers making sure to have no spaces in the headers (see the headers below)
4. Save as Excel 97-2003 workbook and save it in your winmore3/mdat/send folder

The file should then be ready to use as a XLS file.

Headers: Account, TIN, TIN_TYPE, Name, Address, City, State, Zip, Commissions