Create a report of clients who have filed a certain form or schedule
Use Data Mining to identify clients who have filed a specific form or schedule. Follow these steps to create a report identifying all clients who filed a Schedule C.
- In UltraTax CS, selectUtilities, thenData Mining.
- Select the database you want to search. For this example, select1040 Individualfrom theClient databasedropdown, thenContinue (Step 2).
- In thePrint Selectionwindow, selectReportsfrom the dropdown in thePrint selectionarea and select a report, such as theCS Client Contact Informationreport.
- In theClient Searchwindow, select the form to search for from the dropdown in the Print selection area. For this example, selectSchedule C clients.tipThe items in the dropdown are ordered alphabetically, so look under the letter F for forms (ex: Form 1045), and the letter S for schedules (ex: Schedule F). If the form or schedule isn't listed in the dropdown list, see the following additional search options section.
- SelectContinue (Step 3)to perform the search.
- After the search is completed:
- If no clients passed the search, theSearch Resultswindow opens.
- If 1 or more clients passed the search, thePrintwindow opens.
- SelectPreviewto view the report.
Additional search options
Follow these steps if a form or schedule isn't available in the dropdown in the
Search Name
field.- SelectAdd/Modify Searchesnext to theSearch namefield.
- SelectAdd.
- Enter a name in theSearch Namefield (such as the name of the form).
- To search for a federal form, selectFederalin theProductfield. To search for a state form, select the arrow next to theProductfield, then the state.
- Turn onFormfollowing theProductfield.
- Select the form (ex: Form 2555 [prepared]).
- Turn onPrepared. Turn onNot preparedto search for clients that haven't prepared the form.
- SelectDonetwice to return to thePrint Selection and Client Searchwindow. Verify that the name entered for the search in Step 3 displays in theSearch Namefield. If not, select the arrow in the field and select the name from the dropdown.
- SelectContinue (Step 3)to perform the search.
- After the search is completed:
- If no clients passed the search, theSearch Resultswindow opens.
- If 1 or more clients passed the search, thePrintwindow opens.
- SelectPreviewto view the report.