Home | DOWNLOADS | PRICES | ORDER | Tin Matching | SUPPLIES | IRS Forms/Pubs | Video Help |
Excel Imports |
To quickly understand Copy and Paste from Excel, download and install the program (it takes 15 seconds, no personal data is requested). Then, open the sample Excel spreadsheet Misc.XLS (located on the C:\ drive in the E200x folder). Copy the top 10 rows of the sample spreadsheet. Bring up 1099Express. Click the Edit Menu then "Paste From Excel by Header Name". Notice the columns are re-arranged to match the 1099 Express grid! For more info, just click Help/Index, Topic 4, inside the 1099Express program.
1099 Express can import 50,000 payee records in
less than 1 second. To Copy and Paste from Excel, insert headers in
Row 1 to match your columns, like the samples in red below. Headers must be
spelled like the 1099Express grid headers. There is no need to re-arrange your
spreadsheet manually. Paste by Header Name automatically rearranges
your columns to match the 1099 Express grid. For example, both sheets
below import the same data, even though the columns are in a different order.
If you have a non-used column, just leave the header blank.
Home | DOWNLOADS | PRICES | ORDER | Features | Laser Forms | Service Bureau | Contact Us |
Excel Imports | IRS Forms/Pubs | IRS E-File | FAQs | IRS Quality Certificate | Last Year | Activate Program | Other Links |