ProConnect HelpIntuit HelpIntuit

Using the Schedule D Import Wizard in Lacerte

SOLVED•by Intuit•32•Updated almost 2 years ago

The Schedule D Import Wizard allows you to import Schedule D data into the tax program from an Excel spreadsheet (or any comma delimited text file such as a CSV file).

If your client can download Schedule D data from a financial institution to an Excel spreadsheet or CSV file, then you can import data from this file into your client's tax return.

How to use the Schedule D Import Wizard

Open the Schedule D Import Wizard using one of these methods:

  1. From the Client menu, select Import, then Schedule D Import.
  2. From the Tools menu, go to Import/Export Data, then select Schedule D Import.
  3. From Screen 17, Dispositions under section Dispositions (Schedule D, 4797, etc.), select the Schedule D Import button.

Once you open the Schedule D Import Wizard, you must complete three steps:

  1. In the Find the File to Import field, browse to the file location you want.
    • If the Designate Transaction As field appears, select the type of return you're filing for this client.
  2. In the Import Options area, choose if you wish to add to, replace, or clear the transactions that you previously imported for this client.
    • Select Help me decide if you need detailed explanations for each option.
  3. Select Next.
  1. In the Worksheet list, select the worksheet you're importing into the tax program (if you're importing a CSV file, it'll label it Sheet 1).
  2. In the Select the field below area, assign a heading to each column.
    • This heading corresponds to the input field in the tax program where the program will import the data.
    • Assign the <Do Not Import> heading to any columns you don't wish to import.
    • Description is the only required column heading.
  3. Select the Ignore box for each row you don't wish to import.
    • This is helpful is the file includes unwanted text, headings, or totals.
  4. When you've finished setting up the data, select Next to preview before importing.
  1. Review the data to make sure it's what you wish to import.
  2. Make any changes by using the Ignore checkboxes to remove unwanted rows, or by selecting the Back button to correct column headings.
  3. After reviewing the information, select Finish to import the data into the tax program.

Additional information and frequently asked questions

  • Single File Import: You can only select and import one file at a time.
  • Password-Protection: Password-protected Excel files aren't supported.
  • File Extensions: If you try to select an unsupported file type, the wizard will warn you that the file isn't supported, or it won't allow you to select the file. To change the file into one Lacerte can import:
    1. Exit the import process and open the file in Excel.
    2. In Excel, go to File, then Save As.
    3. When you see the pop-up screen, select the dropdown menu option, Save as Type.
    4. Select the option Excel 97-2003 Workbook, then select Save.
    5. You can now import the file with the .xls extension.
  • Date Formats: Dates won't import if you use "Various" inside date fields in the Excel file. Negative dates are supported as long as they are preceded by an apostrophe (for example, '-12/31/07 ).
  • Blank Rows: The wizard won't import blank or hidden rows or columns in the Excel or CSV file.
  • Rows and Columns: Each transaction will appear as a single row in the wizard (condense transactions using more than one row in your original file into a single row format shown below). Each column in the wizard represents a single input field.
  • Rounding: Amounts shown on the Wizard screens will include decimals, but all amounts will then be rounded to the dollar when imported into the tax program.

Was this helpful?

You must sign in to vote, reply, or post
Lacerte Tax

Sign in for the best experience

Ask questions, get answers, and join our large community of Intuit Accountants users.

More like this

Dynamic AdsDynamic Ads