Why Your Housecall Pro and QuickBooks Revenue Never Match (And How to Fix It)
The short answer: Housecall Pro and QuickBooks Online revenue numbers don’t match because the integration syncs transactions but doesn’t guarantee they land in the correct account. The three most common causes are: incorrect payment sync settings, refunds mapped to the wrong account, and payments sitting in Undeposited Funds in QBO without being matched to a bank deposit.
Why This Happens More Often Than You’d Think
If you run both Housecall Pro (HCP) and QuickBooks Online (QBO) for your HVAC, plumbing, or electrical business, there’s a good chance your revenue numbers don’t match between the two platforms. HCP shows one total. QBO shows something completely different. And you have no idea which one is right.
You’re not making a mistake. The integration between HCP and QBO is powerful, but it has a fundamental limitation most contractors don’t know about: it moves transactions from one platform to the other, but it doesn’t verify that those transactions land correctly.
The result is books that can’t be trusted, financial reports that feel wrong, and decisions made on bad data.
The 3 Reasons Your HCP and QBO Don’t Match
1. Payment Sync Settings Are Configured Incorrectly
Inside your HCP and QBO integration settings, there’s a configuration for how payments get transferred. If it’s set to sync payments as individual transactions instead of as deposits, QuickBooks ends up with a flood of line items that don’t correspond to actual bank deposits. This creates duplicate entries and inflates your QBO revenue.
The fix: go into your HCP settings, find the QuickBooks integration section, and change the payment sync method from individual transactions to deposits.
2. Refunds Are Mapped to the Wrong Account
When a customer receives a refund in Housecall Pro, that refund doesn’t always map correctly to QuickBooks. In some configurations, refunds disappear from the books entirely. In others, they create negative entries in the wrong account — which distorts both your revenue and your expense totals.
The fix: review your refund mapping in the HCP-QBO integration settings and confirm refunds are posting to the correct income account.
3. Payments Are Sitting in Undeposited Funds
Undeposited Funds is a holding account inside QuickBooks. When payments come in from HCP, they can land in Undeposited Funds rather than being matched directly to a bank deposit. Until those transactions are cleared, your QBO balance won’t match your bank statement — and your revenue totals will be wrong.
The fix: go to your Chart of Accounts in QBO, find the Undeposited Funds account, and review any transactions sitting there. Match them to the corresponding bank deposits.
To fix a Housecall Pro and QuickBooks sync problem, check three settings: (1) change payment sync from individual transactions to deposits, (2) verify refunds are mapped to the correct income account, and (3) clear any payments sitting in the Undeposited Funds account in QBO.
What to Do If the Problem Has Been Going On for Months
Changing your settings stops the problem going forward. But if your sync has been misconfigured for weeks or months, there’s still catch-up work needed — going back through past transactions, identifying duplicates, and reconciling what’s accurate.
This is called a bookkeeping cleanup, and it’s one of the most common services we provide at Profit Clarity Group. Most cleanups take less time than people expect, and the result is a clean starting point with books you can actually trust.
Signs Your HCP + QBO Sync Is Off Right Now
- Your HCP revenue report and your QBO profit and loss show different totals
- You have transactions in QBO you can’t explain or identify
- Your bank balance and QBO balance never quite match
- You dread opening your financial reports because something always looks wrong
Getting Help
At Profit Clarity Group, we specialize in fixing the HCP and QBO integration specifically for HVAC, plumbing, and electrical contractors. We offer a free 20-minute sync diagnosis — a screen share where we look at your specific setup and tell you exactly what’s broken and how to fix it.