Use Query Manager to create a report with a new query in Personal Tax
Whether for tax planning purposes or housekeeping, it’s useful to report on clients meeting specific criteria (such as over a certain age, specific income types, or thresholds. You can do this in the Query Manager.
- Go toTools,Query Manager.
- Select theTemporary (Work In Progress).
- SelectNew, thenQuery.
- In the Group column, select which schedules to report on.
- In the Instance column, you can select a subset of the group.
- You can selectMoreto add specific user assignments to the query or apply the query only to specific tax years.
- You can choose to use theBasicorAdvancedquery method.importantYou should only choose the Advanced query method if you're proficient in SQL or if we've given you text to use in a query. You can ask your Account Manager if you would like us to build a more complex query for you, at a cost.