Preparing the Lotus file is very simple. You only need to enter the proper field names in row number one of the worksheet and then save the worksheet as a “.WK1” file. To find the Field Codes, at the 1099-etc Main Main Menu, select Utilities>Import Assistant>View/Print Import Field Names. Follow the prompts.
After all the field codes have been entered and the worksheet saved as a “WK1” file, you can then run the Import Assistant, 1099-etc Main Menu>Utilities>Import Assistant>Import from a Lotus WK1 File or dbase DBF File to generate the import file that will ultimately be imported into the W-2/1099 Forms Filer.