How can I import Capital Gains and Losses, form 8949, or form 1099-B into Drake?
You can import information into Drake using the Form 8949 Import / GruntWorx Trades utility. You can import transaction information from Excel 97-2003 and Excel 2007/2010 or later, TAB (tab delimited), or CSV (comma delimited) files. After import, each transaction appears on a separate 8949 screen. For a successful import, the data must be correctly formatted (GruntWorx Trades are already properly formatted). A blank Excel workbook (*.xls) with a header row and date fields formatted as text is available for download (see Attachments at the bottom of this page).
Note: If using the blank workbook to import data into the Drake15 or prior software, use the "2015 and Prior Blank Excel Spreadsheet with 8949 Import Headers" Attachment. The headers have changed to allow more information starting in Drake16. When importing data into Drake16 or future years of Drake Tax, use the "2016 and Future Blank Excel Spreadsheet with 8949 Import Headers" Attachment below.
Start by reading the Help screen instruction. In the client’s tax return, click the Import button on the toolbar and select Form 8949 Import / GruntWorx Trades. Click the Help button in the lower-left corner of the dialog box to display the Help screen instructions about using the import utility. You may want to print the instructions for easy reference (5 pages).
Watch the videos 8949 Import Options and 8949 Import Tool for more details about the process.
For the information to import correctly,
- In an Excel workbook, the import data must be on the first spreadsheet in the workbook. View the workbook and make sure the sheet to be imported is the first tab. The name on the tab does not matter.
- The import file must contain the specified columns in the specified order. Each column represents a field on the 8949 screen as determined by the column location (not the header labels, which are optional):
Drake15 and prior:
Beginning in Drake16:
- For acceptable date formats, see "Avoid Common Import Problems" below.
To import the information, complete the following steps:
- From within the client’s tax return, click the Import button on the toolbar and select Form 8949 Import / GruntWorx Trades from the drop menu. The Form 8949 Import / GruntWorx Trades dialog box opens.
- Review the example spreadsheet format. Click Next to open the Form 8949 Import / GruntWorx Trades - Step 1 dialog box.
- Click the Browse button to locate the file containing the transactions. After locating the file, click Open. The transactions are displayed in the Form 8949 Import / GruntWorx Trades - Step 2 dialog box.
- From the Start import at drop list, choose a line to start the import. If the first row in the transaction list is column headers, begin import at row 2. For example, for a GruntWorx Trades, which have a header row, select 2 from the Start import at drop list.
- Click Next to proceed to the Form 8949 Import / GruntWorx Trades - Step 3 dialog box, which displays the information that will be imported. Confirm the data.
- Click Import to import the transactions. A list of 8949 screen opens. Each imported transaction is listed on a separate 8949 screen. Open the first transaction screen, confirm the entries, and press Page Down to review each screen.
- You can prepare a temporary spreadsheet and import it into a test return to see how the process works.
Avoid common import problems:
Except for column headers, don't put anything in the import file that should not be imported.
- If you include column headers, make sure to start importing on the first data row, not the header row.
- If totals are present, remove them. The totals may be imported, doubling your data.
The TSJ column refers to taxpayer, spouse, or joint in an individual (1040) return. For importing data into other return types, the TSJ column is used as follows:
- When importing into an 1120-S (S corporation) or 1065 (partnership) return, the TSJ column represents the Property type field on screen 8949.
- When importing into a corporation (1120) return, the TSJ column represents the Foreign Expropriation field of the 8949 screen.
- When importing into a fiduciary (1041) return, the TSJ column represents the Grantor field on screen 8949.
If building your own worksheet, include the “QSBS” columns, but enter no amounts in those columns for the business packages; when Form 8949 data is imported into one of the business packages, those two columns are ignored. Do not include the EIN (QOF Only) fields when building your worksheet.
Date formats in the Date Sold and Date Acquired columns –
- CSV files or tab-delimited files. These are text files. Dates must be in one of these formats:
- MMDDYYYY (recommended)
If you open and save a text file in Excel, take care that default formatting changes don't result in the loss of leading zeros. Note that you can also open, edit and save text files in Microsoft Notepad.
- Excel. The best way to enter dates in Excel is to format the date columns as text in MMDDYYYY format (separators can be used or omitted). If you use other Excel formats:
- Dates in columns formatted in Excel as dates will also import correctly.
- Dates in cells using the default Excel general format may cause difficulties if Excel does not recognize the value as a date. Enter dates using slash separators so Excel will recognize the value as a date. Import errors occur if a date value like "02022011" becomes "2022011" when Excel treats it as a number rather than a date and drops a leading zero. This can also happen when you open a file supplied to you as a CSV or tab-delimited file, save it in Excel and import the saved Excel file.