Overview

Each year, certain ITIN holders are required to renew their ITINs. You can run a report for taxpayers, spouses, and dependents that may have an ITIN so that you can know which of your clients will need to renew.

To get a list of expiring ITINs, first, generate the ITIN report using the steps below. Then, export the report to Excel and sort the results to determine which ITINs are expiring.

Once you have a list of ITIN holders that need to be renewed, follow the process detailed in Drake Tax - ITIN: Form W-7 to renew the ITIN.

Report Steps

The reports within Drake Tax can be customized in order to generate a list of taxpayers, spouses, and dependents who have ITINs. Use the following process to customize and generate this report:

1. From the main screen of the software go to Reports > Report Manager.

2. Under the Client Reports category, choose Client Contact. To capture clients and their addresses, select the Address List report. To capture email and phone numbers, select the Contact List (individual) report.

3. After selecting a report, click Edit Report at the bottom of the screen.

4. In the Report Editor – Step One screen, customize the report title by adding ITIN to the end of the name.

5. In the Select Report Columns section, add Spouse ID and Spouse Name columns as well as Dependent ID and Dependent First Name columns to the report.

6. Drag and drop the items in the list to re-order the columns so that the Spouse First Name column is beside the Spouse ID, and the Dependent First Name column is beside the Dependent ID.

7. Click Next at the bottom of the screen.

8. In the Report Editor – Step Two screen, click the Edit Filters button beside Select a report filter.

9. On the Filter Manager screen, click the New Filter button. Enter ITIN to indicate that this new filter will be used to capture ITIN information.

10. Click OK.

11. In the Additional Search Conditions for the Selected Filter section, click Add Condition.

12. In the Filter Condition Editor window, choose Taxpayer ID from the Keyword Name drop-down field.

13. In the Comparison field, choose starts with and enter the Value as 9.

14. Click OK.

15. Conditions will also need to be set for ITIN values for the Spouse ID and Dependent ID categories. Repeat steps 11-14 to add conditions for Spouse ID and Dependent ID keywords.

16. Make sure that the radio button ​Match Any Condition​ is marked.

17. Click Save at the bottom to return to the Report Editor - Step 2 screen.

18. The Additional Report Options section provides an option to sort the report results by category.

19. Confirm all options and click Save at the bottom.

20. The customized report appears in the My Reports section of the Report Manager.

21. Select the Report and click View Report.

22. Once the report has generated, it can be printed, exported to Excel, or exported to a CSV file.