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 to
Tools
,
Query Manager
.
Select the
Temporary (Work In Progress)
.
Select
New
, then
Query
.
In the Group column, select which schedules to report on.
In the Instance column, you can select a subset of the group.
You can select
More
to add specific user assignments to the query or apply the query only to specific tax years.
You can choose to use the
Basic
or
Advanced
query method.
important
You 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.