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:
- From the Client menu, select Import, then Schedule D Import.
- From the Tools menu, go to Import/Export Data, then select Schedule D Import.
- 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:
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:
- Exit the import process and open the file in Excel.
- In Excel, go to File, then Save As.
- When you see the pop-up screen, select the dropdown menu option, Save as Type.
- Select the option Excel 97-2003 Workbook, then select Save.
- 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.