QuickBooks Desktop

Grouping QuickBooks customers by location

Use Customer Type for regional groups while keeping customer accounts, jobs and balances properly organised.

Updated

Choose the grouping you need

Customer Type can hold a consistent category such as region or customer segment. If your team already uses it for wholesale and retail customers, agree how geographic reporting will fit before replacing those values.

Keep customer addresses accurate too. For state or province reporting, Intuit documents a Sales by Customer Detail report using the address information, which may avoid the need for another category.

Set up and apply Customer Type

The screenshots use an Enterprise Accountant 24.0 sample company. Open Lists, Customer & Vendor Profile Lists, Customer Type List to maintain the categories.

Open the relevant customer or job, choose Additional Info and select its Customer Type. The second screenshot shows this on a job record. Its indented choices are customer types and subtypes, not customer accounts.

Keep account ownership clear

Use a customer record for the party being billed and jobs for its projects or work. Do not put unrelated customers beneath a regional “customer” simply to group a report. That mixes a reporting category with the account relationship.

If a customer has several jobs, check the records that your report actually reads. Do not assume changing the parent record updates every job or every historical report.

Check the report before rolling it out

Create sample records in two regions. Open the required sales or customer report and inspect the available filters and columns. Report options differ, so verify the grouping and totals before entering the category across the whole list.

Agree one naming convention and who can add new types. Save useful report settings with Memorize so staff can run the same report again.

Screenshots

Lists menu showing the route to Customer Type List
Open the Customer Type List from Customer & Vendor Profile Lists. This is a sample company in Enterprise Accountant 24.0.Open the image to view it at full size.
Edit Job window showing regional Customer Type choices
The selected job has a Customer Type under USA, New York State and NYC. The regional hierarchy belongs to the type list; the job remains beneath its actual customer.Open the image to view it at full size.

Intuit documentation

Need help with your setup?

Titan Cloud Servers handles QuickBooks Desktop Enterprise setup, hosting, staff training and ongoing support.

Was this guide useful?

Follow Titan Cloud Servers on Facebook for more QuickBooks guides and practical advice.

Worked with our team? You can share your experience on our Google Business Profile.

Business software we work with every day

We support QuickBooks Desktop Pro, Premier, Enterprise and Enterprise Accountant, plus Sage, Tally, Peachtree, Microsoft Office, SQL Server, Outlook and other Windows business software.

QuickBooks Desktop Sage Tally Peachtree Microsoft Microsoft Office SQL Server Microsoft Outlook
WhatsAppTalk to our team