Skip to main content
T
tpesky
Level 3
January 31, 2024
Question

DATABASE

  • January 31, 2024
  • 1 reply
  • 2 views

Can I use the database to say, bring up all the clients that I made non-residents?  Or all the clients that used one particular thing in the tax program?

This topic has been closed for replies.

1 reply

M
Mario B
Level 11
February 2, 2024

if you are using you could adjust the filters to select the tax year and module, then do a query, which will show only the returns with a specific condition

 

we have instructions here for client explorer https://profile.intuit.ca/support/en-ca/help-article/manage-client/query-client-explorer/L7Nbtlhcg_CA_en_CA?uid=ls4yjnbh

and here for classic database we have an example there https://profile.intuit.ca/support/en-ca/help-article/customer-data/create-database-query-method-contact/L8fzj9F4D_CA_en_CA?uid=ls4yoog7

 

The field to use for non-resident in the Query is  T1Info.B[28]

T
tpeskyAuthor
Level 3
February 2, 2024

Thank you Mario, your the best

Terms & ConditionsAccessibility statement
Tax software
Intuit Lacerte Tax
Intuit ProConnect Tax
Intuit ProSeries Tax
Referral Program
Workflow add-ons
Intuit Tax Advisor
Hosting for Lacerte & ProSeries
eSignature
Protection Plus
Pay-by-Refund
Intuit Link
Accounting solutions
QuickBooks Online Accountant
QuickBooks Accountant Desktop
EasyACCT
Training & support
Training Center
Learn & Support
Resources for starting a tax practice
Tax Pro Center
How to get started offering advisory services
Call Sales: 833-564-8436
Sitemap
Turbotax icon creditkarma icon QuickBooks icon Mailchimp icon
About Intuit Join Our Team Press Room Affiliates and Partners Software and Licenses

© 2026 Intuit Inc. All rights reserved.

Intuit, QuickBooks, QB, TurboTax, ProConnect, Credit Karma, and Mailchimp are registered trademarks of Intuit Inc. Terms and conditions, features, support, pricing, and service options subject to change without notice.

By accessing and using this page you agree to the Terms and Conditions.

Terms and Conditions About cookies Manage cookies
Legal Privacy Security
TRUSTe
Products
T1 Tax Module
T2/CO-17 Tax Module
T3 Tax Module
T4, T5 & Other Tax Forms
Tax Suites
Single Returns (OnePay)
ProFile 20
QuickBooks Online Accountant
Pricing
Pricing & bundles
Free trial
Learn
Getting started
Training
Webinars & events
Support
Download & activate
Community & support
System requirements
Refer a friend
Call sales: 1-844-861-3600
Manage cookies

© 2026 Intuit Inc. All rights reserved.

Intuit and QuickBooks are registered trademarks of Intuit Inc. Terms and conditions, features, support, pricing, and service options subject to change without notice.

Legal Privacy Contact Contact
Logiciels
Logiciel d’impôt T1
T2/CO-17 Tax software
Logiciel d’impôt T3
T4, T5 et autres formulaires fiscaux
Suites Fiscales
PayezPourUN
ProFile 20
Signature Intuit pour ProFile
QuickBooks en ligne Comptable
Prix
Prix et offres groupées
Essai gratuit
Apprentissage
Démarrage
Formation
Webinaires et événements
Soutien
Télécharger et activer
Communauté et soutien
Exigences système
Recommandez un ami
Appeler les ventes : 1 800 943-9834
Paramètres des témoins

© 2026 Intuit Inc. Tous droits réservés.

Intuit et QuickBooks sont des marques déposées d’Intuit, Inc. Les modalités, les fonctions, le soutien, les prix et les options de service peuvent être modifiés sans préavis.

By accessing and using this page you agree to the Terms and Conditions.

Nos offres d’emploi Contactez nous Renseignements juridiques Confidentialité