Welcome back! Ask questions, get answers, and join our large community of tax professionals.
cancel
Showing results for 
Search instead for 
Did you mean: 

How to import and export W-2s, 1099s and 1098s into the Information Return System

Intuit Help
Intuit

How to import and export W-2s, 1099s and 1098s into the Information Return System

Export W-2 information:

  1. If exporting W-2 information from EasyACCT, first perform the W-2/1099 transfer.
  2. Open the company in the IRS program.
  3. Prepare Forms/Returns and select Form W-2.
  4. From the toolbar select Tools > Export Data.
  5. Assign a path/filename to export and select whether to include column headings.
  6. Select Export.

Import to the Information Return System:

  • Imports are done per form.
  • We can import using Comma Delimited, ASCII Text or Fixed Length Text formats.
  • Comma Delimited is the recommended format to import because of it's ease.
  • Comma Delimited is a spreadsheet format.
    • Open the spreadsheet, and select Save As.
    • In the file type field, choose CSV (this is the comma delimited format).
  • Social Security numbers should be in text format to be imported correctly.

  1. Access the input display of the form for what you are importing data (for example, 1099-MISC, 1099-INT, W-2).
  2. Select Tools > Import Data.
  3. Enter a name for the import selection, if applicable. This lets you perform the import again without reentering the criteria.
  4. Select the appropriate file format:
    • Comma Delimited
      • If you're importing a comma-delimited file, you'll need to indicate the Number of Delimited Fields in the Import File.
        • This can be done by counting the "columns" in the file.
        • If you don't have Excel, simply count the number of commas in one of the records (rows) and add one.
      • Select View Import File to display the file on-screen.
      • Don't include fields that contain data you don't need.
      • Indicate what column in the file the noted data can be found.
        • For example, if on a 1099-INT the recipient's ID can be found in the first column, enter 1 for the Delimited Sequence.
        • It's OK if there's more data in the file than you want to import. You don't have to enter a value in each field, just the ones with the * next to them.
    • Text
      • Enter the starting position for data corresponding to an import field.
        • This can be done in Microsoft Word or Wordpad by noting the column that you are on when the cursor is placed at the beginning of the data.
      • Count the number of characters that make up the field and enter that number as the Field Length.
        • The field length and starting position should accommodate the longest field of all the records.
    • Fixed Length Text
      • Follow the same steps as a text file, but make sure that the number displayed as the Total Record Length is equal to the number of characters and spaces of one record in the file.
      • Select Begin Import and indicate if to save your settings.
      • If the program indicates that there were errors during the import, view the log file to help troubleshoot the cause of the errors.
  5. Select to append or replace existing data.
  6. Enter the appropriate path/filename of the file.

Was this helpful?

You must sign in to vote, reply, or post
Labels (1)