Housecall Pro and QuickBooks reconciliation: why deposits don't match your bank

Your bank shows one deposit. QuickBooks shows a handful of customer payments that add up to more. Your P&L says you had a great month, and your checking account says otherwise.

If you use Housecall Pro with QuickBooks Online, reconciliation questions like this come up constantly in the QuickBooks Community. One owner asked it plainly: if we mark a check as paid in Housecall Pro and later deposit a batch of checks, "is it going to be doubled up"? A second person came back to the same thread asking where that bank deposit is supposed to go.

Often the sync is working as designed and the mismatch comes from how the money moves. Once you see the path, most mismatches are easy to spot.

How a Housecall Pro payment gets to QuickBooks

Here's the path Housecall Pro describes in its help center.

When you take a payment in Housecall Pro, it syncs to QuickBooks as a payment on the invoice. The payment lands in Undeposited Funds (some QuickBooks files call it Payments to Deposit), not in checking. Think of it as the cash drawer: money you've received but haven't carried to the bank yet.

What happens next depends on how the customer paid.

Card payments, card tips, Instapay, and mobile check deposits reconcile automatically. Housecall Pro creates a deposit in QuickBooks that groups the payments, subtracts processing fees, and moves the money from Undeposited Funds to your bank account. Their docs say this happens within 2 to 5 business days. Fees go to an account Housecall Pro creates called "Housecall Pro Payment Processing Fees."

Cash, checks, and "other" payments don't move on their own. They sit in Undeposited Funds until someone builds a bank deposit in QuickBooks.

Almost every mismatch below is a break somewhere on that path. If you're still setting up the connection, our Housecall Pro and QuickBooks Online setup guide covers the bank settings that prevent several of them.

Mismatch 1: gross payments, net deposit

A customer pays a card invoice. QuickBooks records the full invoice amount as paid. Your bank receives that amount minus the processing fee, bundled with other payments from the same payout.

That's normal. The deposit Housecall Pro creates should include the fee as a negative line so the total equals what hit your bank. The payouts section on Housecall Pro's My Money page lists each payout with its payments and fees, which is what you compare against.

If a card deposit didn't reconcile automatically, Housecall Pro's help center walks through building it by hand. Select the payments, then add the processing fees as a negative amount to the "Housecall Pro Credit Card Processing Fee" expense account until the total matches the bank. Bookkeepers who work only from the bank feed hit the same gap from the other side. One said on Reddit that they see net deposits and need a payout report to gross up the fees.

Mismatch 2: income counted twice

This is the expensive one. The bank feed downloads the payout deposit, and someone categorizes it as income. The payments that synced from Housecall Pro were already income. Now the same money is on the P&L twice.

It's common enough that a general QuickBooks Community thread titled "Quickbooks is showing that I make double my income" drew dozens of replies. The fix Intuit's team gave there fits here too. Delete the deposit you added by hand, undo the bank feed entry, then use Find match to match the bank line to the payments or deposit that already exist.

Housecall Pro puts it plainly for card payments: "DO NOT move or reconcile credit card payments." Their integration does that part. Your job in the bank feed is to match, not add.

Mismatch 3: cash and checks piling up

If your techs collect checks and cash, those payments stay in Undeposited Funds until you create a bank deposit in QuickBooks. Skip that step and two things happen. Undeposited Funds keeps growing, and the real bank deposit shows up in the feed with nothing to match.

Build the deposit to match the actual deposit slip. In QuickBooks, create a new Bank deposit, check the payments that went to the bank together, confirm the date, and save. Then match the bank feed line to it.

Mismatch 4: the same payment entered in both systems

A QuickBooks App Store reviewer wrote that payments were "posting twice to QuickBooks reflecting that we were paid twice." The common cause is a payment recorded in QuickBooks and then again in Housecall Pro.

Housecall Pro has tools for this. If an invoice was marked paid in QuickBooks first, "Pull Payment from QBO" on the job brings that payment into Housecall Pro without creating a new one. "Add Local Payment" marks the job paid in Housecall Pro without sending anything to QuickBooks. Both live in the QuickBooks Online section at the bottom of the job.

The rule that prevents it: record each payment once, in the system where it happened. For field jobs, that's Housecall Pro.

Mismatch 5: the wrong bank account

Housecall Pro reconciles card deposits to whichever QuickBooks bank account you picked in its Banking settings, and that account has to match the payout account in your Housecall Pro money settings. Change banks and update only one, and card payments can post to the old account.

If that account gets deleted in QuickBooks, you'll see an "Invalid Item Ref" alert and card payments stop reconciling. Make the account active again, then contact Housecall Pro support. Other sync alerts are covered in our post on Housecall Pro sync problems.

Mismatch 6: refunds inside a batch deposit

A refund in Housecall Pro creates a Refund Receipt in QuickBooks. It shows up in Undeposited Funds and leaves a balance on the customer. Housecall Pro also says you're responsible for the processing fees on the original charge when you refund.

It gets harder when the refund comes out of a payout that also holds a stack of other payments. One Housecall Pro user on Reddit refunded a card payment during a two-day sync outage, recorded it in QuickBooks by hand, and ended up with a negative customer balance tangled inside a bulk deposit. Bookkeepers in that thread suggested coding the Refund Receipt to accounts receivable and applying it against the unapplied payment. The poster never confirmed the result, so have your bookkeeper make that call.

Deposits, tips, and surcharges

By default, Housecall Pro records upfront deposits as income. A "Treat as liability" option holds them in a liability account until the final invoice. Decide with your CPA and set it on purpose.

Card tips sync to an income account called "Housecall Pro Tips." If tips pass through to techs, ask your CPA how to record them.

Housecall Pro's card surcharge feature (rolling out gradually, per their docs) adds a "Credit Card Surcharge" line and posts it to a sub-account under the processing fee account, so fees charged and fees collected sit side by side.

Monthly reconciliation checklist

• Open Undeposited Funds. Anything older than your normal payout timing needs a look.
• Compare each Housecall Pro payout, with its fees, to the QuickBooks deposit and the bank line.
• Build bank deposits for every batch of cash and checks.
• In the bank feed, match payout deposits. Don't add them as income.
• Look for payments recorded twice.
• Confirm the Banking setting still matches your payout account.
• Review the processing fees account against your payout reports.
• Check that refunds cleared Undeposited Funds and left no stray customer balances.
• Reconcile the bank account to the statement.

If it's been off for months

A month or two of mismatches is usually a quick fix. A year of double-counted income and a swollen Undeposited Funds account is a catch-up project, worth doing before your CPA files anything off those numbers.

KWK Books reconciles QuickBooks Online files for home-service businesses in Austin every month. Kipp Koeppel is a QuickBooks Online Certified ProAdvisor. See our services for what that includes.