Set up Customer Mapping for Quickbooks Desktop: recommended workflowLast updated on 11/28/2022
Use this article to understand how to set up Customer Mapping between Quickbooks Desktop and ServiceTitan. This setting allows you to choose whether transactions are exported to the Customer record in QBD (Bill To), or to the Customer Job record (Location).
Things to know
By default, transactions are exported to the ‘Customer Level’ in QBD. This article shows how to alter the Settings so that transactions are exported to the Customer Job (Location) in QBD.
The only difference between ‘Service Location Address’ versus ‘Service Location Name’ is how they display in QBD’s Customer Center.
Customer Mapping does not affect the type of information that is exported to QBD, but rather how the information is displayed and organized within your QBD file.
Set Customer Mapping in ServiceTitan
Go to the navigation bar and click Settings .
In the side panel, click Integrations > Quickbooks Desktop.
Click Customer Mapping.
In the popup, select your QBD connection
Select the customer mapping setting that best fits your needs
Customer level– This is the default setting. Transactions export to QBD at the Customer level (aka: Bill To). This means all Invoices, Payments, etc will appear on the Bill To Customer record in QBD upon export.
Service Location Address– Select this option to export transactions to the Customer Job (aka: Location) level in QBD. Invoices, Payments, etc will appear on both the Location and Customer record in QBD upon export.
Service Location Name– This is the same option as Service Location Address, but the display is slightly different in QBD. When Locations are created in QBD upon export, the Location is created with the Location Name only in the Customer Center. No address is appended.
Note: Selecting ‘Service Location Address’ or ‘Service Location Name’ allows the transactions to live on the Location level as well as the Customer level in QBD, and so this is recommended for shops that work often with Commercial and/or Property Management customers. If the customer is usually the same as the location on jobs, then the ‘Customer Level’ default may be adequate for your needs!
Important note: Some features may not be currently included in your account and additional configuration may be required. Please contact technical support for details.