Overview
In this article, we'll go over how to reconcile payments in QuickBooks Online when they are entered into Housecall Pro.
Payments that are automatically reconciled and deposited:
Credit Card payments
Credit Card tips
Instapay payments
Mobile Check Deposits
Payments that will need to be manually reconciled and deposited:
Cash
Check
Other
Please keep in mind that the QuickBooks Online integration will need to be set up and connected before payments will sync from Housecall Pro to QBO.
📖 Help Center Article:
If you haven't set up the QuickBooks Online integration yet, please check out our Help Article, "QuickBooks Online: Integration Onboarding Guide"
in the HCP Help Center to get started.
Automatic Payment Reconciliation
With the QuickBooks Online integration, any new Credit Card, Credit Card Tips, Instapay, or Mobile Check Deposit payments entered into Housecall Pro will automatically be sent to QuickBooks Online with the payment amount, type, and date when a job is marked as finished or paid in Housecall Pro.
These payments will be grouped together and placed in your Undeposited Funds account in QuickBooks Online:
Credit Card payments will be deposited into your bank account, less any credit card processing fees within 2-5 business days.
Tips added to Credit Card payments in Housecall Pro are automatically added to line items on invoices and sent as an Income Account called "Housecall Pro Tips" in QuickBooks Online. You'll see this Income Account under the 'Income' category of your reports.
Mobile Check Deposit payments will be automatically reconciled and attributed to the connected bank account once the check clears.
📖 Help Center Article:
To learn more about Mobile Check Deposits in Housecall Pro, check out our Help Article, "Mobile Check Deposit FAQ" in the HCP Help Center.
View Your Undeposited Funds Account in QuickBooks Online
To view your Undeposited Funds account in QuickBooks Online:
Click on 'Transactions' from the menu on the left side of your QuickBooks Online account, then select 'Chart of accounts' from the drop-down.
Use the search bar on the Chart of accounts tab and search "Undeposited Funds."
Click on 'View register' under the Action column on the right side of your screen.
From here, you will be able to view all payments that have been or need to be reconciled.
Match Deposits in QBO to Payouts in HCP
To verify that the deposits in your bank statement match your payouts in HCP when you receive them:
Navigate to the My money page by clicking 'My money' in the navigation bar at the top of your Housecall Pro account.
From there, scroll down to the "My payouts" section and click on each transaction to expand the details.
This will show the date, method, and amount for each payout in that deposit, as well as any processing fees associated with the transactions.
When the deposit is made to your bank:
Housecall Pro creates a transaction in QuickBooks Online that groups together your payments and subtracts any credit card transaction fees.
It then moves the funds from your Undeposited Funds account to your Checking account within 2-5 business days.
When you go to Transactions > Bank Transactions in your QuickBooks Online account, the payments received should match your bank deposit.
Please Note: Housecall Pro creates a "Housecall Pro Payment Processing Fees" account within your Chart of Accounts for payment processing fees. You can keep track of Credit Card processing fees by running a report.
From here, all you'll need to do is match your payments in QuickBooks Online with your bank deposits. All of the other steps are completed automatically.
Please Note: You will need to manually reconcile all Cash, Check, and Other payments. Credit card transactions will auto-reconcile in 2-5 business days when the money hits your account. DO NOT move or reconcile credit card payments.
How to Change Your QuickBooks Online Reconciliation Account
If needed, you can change which bank account your credit card transactions will reconcile to in Quickbooks Online.
To update your QuickBooks Online credit card reconciliation account:
Click on the QuickBooks icon in the top right corner of your Housecall Pro Navigation bar.
Scroll down on the Settings menu on the left and select the 'Banking' option from the "QuickBooks Online" drop-down.
On the Banking settings page, click the drop-down box under "Banking information" to view the bank accounts available in QuickBooks Online.
By selecting one of these accounts, your credit card and mobile check deposits will automatically reconcile to this account in QuickBooks Online.
❗Important:
If you change your Bank Account in the QBO Banking settings,
you must also change the bank account connected in your HCP
My Money Payout Settings to ensure that the reconciliation
account matches. Otherwise, credit card payments
may be attributed to old bank accounts.
📖 Help Center Article:
To learn more about updating your Bank Account in the My Money page, check out our Help Article, "How do I Change the Bank Account Setup for Payments?" in the HCP Help Center.
Manually Reconcile Cash, Check, and Other Payments in QuickBooks Online
Cash, Check, and Other payments are not automatically reconciled from your Undeposited Funds account to your asset account in QuickBooks Online. You’ll need to reconcile these payments manually.
To manually reconcile Cash, Check, or Other payments in QuickBooks Online:
Click on the '+ New' button in the top left corner of your QuickBooks Online account, then select 'Bank deposit' under the "Other" category in the menu.
Select the payment(s) being deposited and confirm that the dates match the actual deposit dates.
Next, click on the green 'Save and new' or 'Save and close' button in the bottom right corner of the page.
You will then need to match the payments you record to the transactions that pull from your bank feed. This essentially matches the payment you log to the deposit recorded in your bank feed.
Keep in mind that we are not QuickBooks Online experts. For the best support with Intuit products, please reach out to QuickBooks Support directly.
How to Manually Reconcile Credit Card Payments
In the event that a Credit Card payment from Housecall Pro did not auto-reconcile in QuickBooks Online, you can follow these steps to manually reconcile the payment:
First, click the '+ New' button in the upper left corner of your QuickBooks Online account and select 'Bank deposit' from the menu.
Next, use the Account drop-down box to select the bank account that you want to move these payments to.
Select the invoices that you need to add to the deposit by checking the box next to the customer name.
From here, add the Credit Card processing fees at the bottom of the deposit, in the 'Add funds to this deposit' section.
Select 'Housecall Pro' for the vendor under the "Received From" column.
Select the 'Housecall Pro Credit Card Processing Fee' expense account from the drop-down in the Account column, then input the Credit Card processing fees as a negative dollar amount. (You can find these fees broken down on the Payouts screen in HCP, under Settings.)
Confirm that the 'Other Funds Total' matches the total of the Credit Card processing fees and that the deposit total now matches the amount that was deposited into your bank.
Finally, the green 'Save and new' (or 'Save and close') button in the bottom right corner of the page.
Payment Reconciliation Reference Guide
When a payment is recorded on a job in Housecall Pro and pushed to QuickBooks Online, the fields in HCP correlate to a related field in QBO.
This reference guide explains how each field in the 'Payment history' section of HCP corresponds to the fields on the 'Receive Payment' screen in QBO when manually reconciling payments.
"Type" field in HCP = "Payment method" field in QBO.
"Amount" field in HCP = "Amount Received" field in QBO.
"Date" field in HCP (the date that the payment was entered/created) =
"Payment Date" field in QBO.
Invoice number and "Note" field in HCP = "Reference no." field in QBO.
HCP Field Name | QBO Field Name |
Type | Payment Method |
Amount | Amount Received |
Date | Payment Date |
Note | Reference No. |
Video Tutorial
Housecall Pro Payments in QuickBooks Online:
Having trouble finding what you need?
Reach out to our Chat Support team via the Blue Chat Bubble in your HCP account, or contact our Phone Support team at (858) 842-5746.