How the QBO Integration Works with HCP
The integration between Housecall Pro and QuickBooks Online typically functions one-way, with data automatically syncing from Housecall Pro to QuickBooks Online. There are a few exceptions, and there may be times when you need to push information over to QuickBooks Online from Housecall Pro manually.
In this article, weβll cover everything you need to know about how the integration works between Housecall Pro and QuickBooks Online after the two systems are connected, including:
How information syncs from HCP to QBO
How to manually push information to QBO when needed
How certain information from QBO can be pushed to HCP
Whether information is synced automatically or pushed manually from Housecall Pro, the same data will be transferred to your QuickBooks Online account.
Information that Syncs/Pushes over from HCP to QBO:
Jobs/Invoices
Payments (including Service Plan payments)
New customer information
New Price Book items
β
Please Note: Once the integration has been established, youβll want to
ensure that all work is being completed within Housecall Pro to allow for the automatic transfer of data. Information that is updated in Housecall Pro will not need to be manually updated in QuickBooks Online.
π Help Center Article:
If you haven't set up the QuickBooks Online integration in your Housecall Pro account yet, please check out our Help Article, "QuickBooks Online: Integration Onboarding Guide" in the HCP Help Center to get started.
How Information Syncs from HCP to QBO
After you have set up the QuickBooks Online integration with Housecall Pro, information from your Housecall Pro account will sync to QuickBooks Online when:
Jobs are marked as finished
Jobs are marked as paid
Invoices are sent to customers
To sync invoices and their details from Housecall Pro to QuickBooks Online, create a real or test job, then click one of the following action buttons on the Job Details page:
'Finish'
'Invoice'
'Pay'
This will trigger Housecall Pro to sync the information to your QuickBooks Online account within 2-5 minutes.
β
Information from jobs syncs over to QuickBooks Online alongside customer details. Once an invoice syncs to QuickBooks Online for the first time, a link is established between the invoice in Housecall Pro and the invoice in QuickBooks Online, which allows updates to sync to the invoice in QBO once an action has been completed.
If multiple buttons are pushed throughout the job lifecycle, the first trigger will push the invoice over to QuickBooks and create the link between the HCP and QuickBooks Online invoices.
βAll of the following triggers, such as entering payment or sending the invoice, will update that same invoice via the link moving forward.
Example: If a job is marked as finished and is then marked as paid at a later date, the following triggers (sending the invoice or entering the payment) will update that same invoice via the link established when the job was marked as finished.
Please Note:
Any jobs deleted/canceled in Housecall Pro will need to be
manually deleted/canceled in QuickBooks Online.
This update will not automatically push over.
Syncing Jobs and Invoices
This section provides a brief overview of how the Job # and Due Terms map from Housecall Pro, and what you can expect to see on the QBO side.
Mapping:
The Job number in Housecall Pro will be your Invoice number in QuickBooks.
The Due terms in HCP are the Terms in QBO.
βImportant:
Estimates do not push over to QuickBooks Online, and only specific fields from invoices will appear in QuickBooks, such as the due term or the invoice sent date, as well as any payments taken.
Invoice Due Terms
Housecall Pro allows you to set invoice terms on the job you have created. When the job is finished or sent to QuickBooks Online, your terms will also be reflected in QuickBooks Online.
How to set invoice terms in Housecall Pro:
Find the job you would like to set invoice terms for.
Find the Invoice section of the job and click the highlighted link next to Due.
Select one of the three options: Upon, Net, or On date.
Click Done.
How invoice terms are mapped to QuickBooks Online:
Upon: Receipt
The default due date will be the date the invoice was received.
Upon: Start of Work or Completion of Work
The due date will automatically be set to the date the work was started or the date the work was completed.
Net: 7, 10, 14, 30 etc.
If the invoice net term is not a term already in QuickBooks Online, we will create the term for you. The due date will also be set to the date indicated by the net term and the invoice date to the date sent.
On a Date
If the invoice net term is set to a specific date, we will not set the term and only set the due date and the invoice date.
Please Note: If you update the invoice date or due terms on the job in Housecall Pro, you must manually push the job to QuickBooks Online to reflect the changes.
Syncing Jobs/Invoices with Separate Billing & Service Addresses
When a job with a separate Billing and Service Address is pushed to QuickBooks Online, the Service Address from Housecall Pro will be found under the "Shipping to" section of the QuickBooks Online invoice page.
The service address will not be added to the Customer Details tab in QBO.
Please Note: To separate jobs by address for customers with a single billing entity, you may prefer utilizing a parent/child (Customer/Sub-customer) setup.
Syncing New Customers
When a job for a new customer syncs from Housecall Pro to QuickBooks Online, the customer will be created in QBO and a link will be formed between the profiles for any of their future invoices.
When a customer's Display Name is updated in your Housecall Pro account, the name will also update in QuickBooks Online when the next invoice syncs from HCP to QBO for that customer.
Information will transfer from the Customer Profile page in Housecall Pro to the Customer Details page in QuickBooks Online.
The following tables show which fields in HCP correlate to specific fields in QBO:
Customer Contact Info Fields
Housecall Pro | QuickBooks Online |
First Name | First Name |
Last Name | Last Name |
Display Name | Display Name |
Company | Company name |
Mobile Phone | Mobile Number |
Home Number | Phone number (Primary) |
Work Phone | Other |
Customer Notes | Notes |
Customer Address Fields
Housecall Pro | QuickBooks Online |
Street | Street address 1 |
Unit | Street address 2 |
City | City |
Zip | ZIP code |
State | State |
Please Note: Only one Customer Profile in Housecall Pro can be linked to a customer in QuickBooks Online.
Auto-Syncing Price Book Items
As Service and Material items are created in your Price Book in Housecall Pro, they will be automatically synced with QuickBooks Online immediately.
The first time a new Material item is used and pushed to QuickBooks, it automatically syncs as a service.
If you would like to track the Material item, it will need to be manually changed in QuickBooks Online as an inventory or non-inventory item.
If a Service or Material Item has already been added to your Price Book, the Product/Service item created in QuickBooks Online will match exactly with the item in Housecall Pro.
If you add a new Price Book item directly to the Job Details page without first adding it to the Price Book, the item will be categorized generically as Sales in QuickBooks Online.
A link will be created so the item will be mapped appropriately with any jobs moving forward.
If the category that the item is mapped to in QuickBooks Online needs to be updated, it will have to be updated in Housecall Pro. The item will update to the appropriate category the next time a job with that item is synced to QBO.
Only update the Product/Service information in QBO first when changing the Material Type, or for keeping inventory up-to-date.
βImportant:
At this time, Labor and Materials are not separated when syncing your Price Book information to QuickBooks. When you save Price Book items in Housecall Pro, they will export and link to a Service and Parts item in QuickBooks Online. Once the item is created in QuickBooks Online, you may choose to edit the item type in your QBO account to be that of a Part or Service.
All Material items will be pushed over to Products and Services as a Service.
Any additional mapping (inventory/non-inventory) will need to be
done in QuickBooks Online.
Sync & Map Income Accounts for Price Book Items
Price Book items in Housecall Pro that are included in a job and pushed to QuickBooks will include the default income account or the assigned income account. The income account is assigned to the Service in QuickBooks Online.
You can map income accounts to Price Book items so you can understand your sales transactions for items sold on jobs. By mapping income accounts, you can then analyze your income statements, allowing you to find areas of improvement, including how to improve your margins.
If you import your data from QuickBooks Online to Housecall Pro, any income accounts linked to your services in QBO will be automatically assigned to the corresponding Service or Material in your Housecall Pro account.
Each Service or Material in your Housecall Pro Price Book will include a QuickBooks Online Income account section, with the assigned income account imported from QBO.
To change the income account assigned to an existing Price Book item:
Go to your Price Book in Housecall Pro by selecting 'Price book' from your navigation bar at the top of your account. (If you don't see this option, select 'More,' then 'Price book' from the drop-down).
Select 'Services' or 'Materials' from the menu on the left.
Select a Service or Material industry and category, then select the Service or Material item that you would like to change the income account for.
Select the income account you would like assigned by clicking on the Income account drop-down under the QuickBooks Online box to the right.
Click 'Save' in the top right corner of your screen to update the income account.
Please Note: If you need to add or edit an income account, you will have to create or edit it in QuickBooks Online. The new income account will then appear in the 'QuickBooks Online' section of each Price Book item.
π Check out this QuickBooksHelp article for more information:
Manually Updating Price Book Items in QBO
Any manual updates made to your Price Book items will not sync between the two systems. If you update a Service or Material Price Book item in Housecall Pro, it will also need to be manually updated in your QBO account.
To manually update your Price Book item in QBO:
In QuickBooks Online, click on 'Products & services' from the navigation menu on the left side of your screen, then click 'Edit' to the far right of the item you want to update.
The Product/Service information window will appear on the right where you can update the item information, including the Name, Category, Sales price/rate, and Income account.
If you decide to change an income account on a Price Book item in Housecall Pro, you can do so. However, the income account update will only appear for Price Book items used in a job from that point forward.
βTo retroactively update the item for the new income account, click the 'Also update this account in historical transactions' checkbox.
Once you've updated the information, click the 'Save and close' button in the bottom right corner of your screen.
The information will be updated across any instance of that service across QuickBooks Online, and will then need to be updated in Housecall Pro.
Please Note: Moving Materials from the Services Price Book to the Materials Price Book will create brand-new items within QuickBooks when they are pushed over.
They will not link to the previously created materials in the service category. Once moved from the Service Price Book in HCP to the Materials Price Book, this can not be undone.
π Help Center Articles:
For more information on updating Price Book items in Housecall Pro,
check out our Help Articles, "Service Price Book: A How-to Guide" and "Materials Price Book: A How-to Guide" in the HCP Help Center.
How to Manually Push Information from HCP to QBO
The integration between Housecall Pro and QuickBooks Online only affects new jobs after the initial setup, so jobs that have been marked as Finished, Sent, or Paid before integrating HCP and QBO will need to be manually pushed to your QuickBooks Online account.
If you need to push an invoice to QuickBooks Online for a job that hasn't been completed and no payment has been received, manually pushing the invoice over will also allow you to bypass marking the job as finished or paid, or sending it to the customer.
To manually push information from HCP to QBO:
Navigate to the Job Details page for each job, payment, or customer that you need to push to QuickBooks Online.
βIf a job hasn't been created for the information that you need to push over, you can create a real or test job.
Scroll down to the QuickBooks Online section of the Job Details page, located under the Activity Feed.
Click on the three dots in the top right corner of the QuickBooks Online section and select 'Push invoice/payment to QBO' from the drop-down.
π‘ Pro Tip: This action will also allow you to push a $0.00 invoice to QuickBooks Online, but you must have at least one line item on the invoice, that can be $0.00.
If you receive any alerts when attempting to manually push an invoice into QuickBooks Online:
The QuickBooks Online box will reload and will show "View Alerts" in the top right corner.
βClick "View Alerts" to be taken to the QuickBooks Alert Center in your Housecall Pro account.
π Help Center Article:
To learn more about QuickBooks Online alerts
and how to resolve them, check out our Help Article,
"QuickBooks Online: Sync Alerts" in the HCP Help Center.
When is Information Pulled from QBO to HCP?
During the integration setup, you have the option to import all of your QuickBooks Online data into your HCP account.
βIn cases where a payment was entered in your QuickBooks Online account instead of your Housecall Pro account, you can manually pull those payments from QuickBooks Online.
βDeleting or making a customer inactive in QuickBooks Online will also delete the customer from your Housecall Pro account.
βIf a Parent Customer is deleted or made inactive from a Customer/Sub-customer relationship, the Sub-customer will also be deleted in QuickBooks Online. This change is also applied to Housecall Pro, where both customers will be deleted.
βIf a Sub-customer is deleted or made inactive in QuickBooks Online, but the Parent Customer remains active, the Sub-customer's jobs will still be found under the Parent Customer's profile in Housecall Pro.
β
Please Note: Restoring customers within your Quickbooks Online account
will not restore them in Housecall Pro.
Video Tutorials
In this two-part Mastermind Online, James Griner covers how the Housecall Pro and QuickBooks Online integration works so that you understand what happens in your QuickBooks Online account as you do things within your Housecall Pro account.
Part 1:
Part 2:
Housecall Pro Customers in QuickBooks Online:
Housecall Pro Jobs/Invoices in QuickBooks Online:
π Help Center Articles:
Check out our other QuickBooks Online articles here!