We understand how much of a headache keeping your books accurate can be. That’s why we are taking care of reconciling your Pipe Capital advances payout and repayment in QuickBooks Online, so that you can focus on running your business and not on manually tracking the repayments.
⚠️ DISCLAIMER: Nothing in this article or related to your QuickBooks Online integration with Housecall Pro is intended to be accounting or tax advice. We highly recommend you work with an accountant for any tax or accounting questions, including any related to this product. There may be slight discrepancies between what you see in your Housecall Pro dashboard and what you see in QuickBooks Online.
Advance Payout & General Ledger Account Creation
Once your application for advance with Pipe Capital is approved and funds are paid out, we will increase the balance of your default checking account by the amount of the advance.
We will also automatically create a new account in QuickBooks Online's Chart of Accounts - a liability account for recording the amount of your advance (and how much you have left to pay against the balance).
In addition to this main account, we will automatically create an expense and an asset account to fully and diligently reflect the transfer of funds throughout the process.
When your application for advance with Pipe Capital is approved, you'll see a new liability account in your Chart of Accounts.
Checking Account
As mentioned above, when funds are paid out by Pipe Capital, we will increase the balance of your default checking account by your advance amount.
If we use the example above, the balance of your checking account would increase by $2.00 when the invoice is funded and an advance is paid out.
In this example, a Pro's checking account balance increases by $2.00 when a $2.00 advance is paid out. The vendor and liability account associated with this deposit are outlined in purple and teal, respectively, in the example for illustration purposes.
Asset Account 
A clearing account is used to help manage the delay between the funds being earmarked for the liability repayment and the confirmation of how big of the portion of the earmarked amount will be moved towards repayment of the funds taken from Pipe Capital and how much will go towards the expense.
The funds on this account are held temporarily, and the balance will be adjusted as the transactions are being processed.
In this example, the account balance increased by $0.50 when $0.50 were earmarked towards the repayment of Pipe Capital advance. You can see the vendor (purple) and the amount withheld (teal)
The second stage of the process moves the withheld funds towards the repayment of the funds taken and towards the processing fee expense.
In this example, the account balance is decreased by $0.50 (teal). The split shows exactly how the money was divided between the repayment of the liability and the expense (purple)
Liability Account
This short-term liability account will help you keep track of how much of your advance amount remains to be repaid. The balance will decrease as you repay the advance, and increase as you fund more invoices.
If we use the example above, the balance would be $2.00 when your advance is paid out and $5.00 when additional funds are released. The balance would be $0 when you are done repaying your advance.
In the example above, the newly created liability account had an initial balance of $3.00. The account shows $5.00 left to be repaid after an additional $2.00 advance was taken.
Expense Account
The expense account will help you keep track of how much of the fee has been collected. The balance will increase as you repay your advance.
In this example, as the advance repayments happen, the balance on the fee account will increase.
Vendor
When your advance is paid out, we will create a vendor called Pipe Capital (via Housecall Pro) - Vendor.
This vendor will be associated with both the loan payout and any repayment bank deposits.
At the time of loan disbursement, you’ll see this newly created vendor, Pipe Capital (via Housecall Pro) - Vendor, pop up in your QuickBooks Online account:
Pipe Capital (via Housecall Pro) - Vendor in the list of Vendors in QuickBooks.
Advance Repayment 
When you take payments through HCP, repayment towards the Pipe Capital advance will get automatically and seamlessly updated in your newly created QuickBooks Online accounts.
Initially, you will see line items in items in your bank deposits detailing how much of each payment was earmarked towards . The information in QuickBooks Online will match the details visible within Housecall Pro’s My Money page.
The total sum is moved to the clearing account, where it awaits the signal that the liability (primary advance amount) and the expense (processing fees amount) have been processed by Pipe.
In this example, we can see the amounts earmarked for the Pipe Capital repayment.
At that point, you can clearly match the information provided in Payout details, which are available in Housecall Pro’s My Money page, to the deposit details available in QuickBooks.
The information between the systems clearly aligns
Once the withheld funds are processed by Pipe Capital (it can take from 1 to 4 days on average), we will create another bank deposit, which moves the funds from the clearing account and contains exact details of what portion of the withheld amount was assigned towards repayment of the liability (primary advance amount) and how much towards the expense (processing fees amount).
Example:
In this screenshot, a $184.30 is being paid towards the Pipe Capital advance taken. When this deposit goes through, the Pro’s Pipe Capital liability account balance will decrease by $184.30. We can also see that the Pipe Capital fee expense account balance increased by $22.47.
In this screenshot, a $0.50 is being taken out of the clearing account (blue) and split. $0.44 is paid towards the Pipe Capital advance taken (teal). When this deposit goes through, the Pro’s Pipe Capital liability account balance will decrease by $0.44. We can also see that the Pipe Capital fee expense account balance increased by $0.06 (purple).
Special Cases & FAQ
What if I accidentally delete an account that was created for me?
The account will be recreated.
How should I report these funds on my taxes?
Tax reporting is often dependent on your specific situation, so we encourage you to talk with a tax advisor to ensure appropriate accounting and tax reporting.
Why are my repayments separated into two accounts (liability account and expenses account)?
This is to reflect the amount paid against your invoice funding advance and the amount paid toward the processing fee. Please discuss the appropriate accounting treatment with an accountant or tax advisor.
Why is my liability account of type “Other Current Liabilities” (aka a short-term loan)?
This is because the anticipated repayment period for any of the invoice funding advances is less than 12 months.
What if I apply for or draw Pipe Capital funds multiple times?
It is possible to draw funding multiple times within the available limit. Each time you draw additional funds, the balance in the liability account will increase.
ℹ️ We will NOT create new liability and new expense accounts for recording advances, repayments, and collection of fees. Repayment of the advance and fee collection will populate to the same account we created with your first advance.
I made a manual payment to Pipe. Does this get automatically reflected in QuickBooks Online?
No. At the moment, reconciliation of manual repayments against your advance is not automatically recorded in QuickBooks Online. You would need to create a proper manual entry in your books to reflect the date, the amount, and the accounts involved in the transaction.
What if I connect to QuickBooks Online after taking an invoice funding?
Unfortunately, your loan payout and repayment will not automatically reconcile if you connect your HCP account to QuickBooks Online after taking an invoice funding. Please discuss with an accountant or tax advisor how to reflect this in your QuickBooks Online account.
📌 Note: Alternatively, you can reach out to Housecall Pro Support and request to generate a support ticket for engineering to retroactively push the missing transactions.
⚠️ This should only be done IF you have NOT yet taken any actions together with an accountant. If you have already taken actions with an accountant, a retroactive push will only multiply the transactions in QuickBooks, which should be avoided at all costs.
Need help or have questions?
We're here for you! Chat with Support using the Blue Chat Bubble in your Housecall Pro account, or give us a call at (858) 842-5746.









