The QuickBooks Online integration was created to automatically upload transactions to a newly created ClientPay Clearing account making deposit reconciliation with ClientPay easier than ever before.

Let us know how the QuickBooks Online Integration is working for you by sending feedback and questions to [email protected].

Watch our quick video to get started. Complete integration steps below.

Log in to your ClientPay account and click on the name in the upper right corner. From the dropdown menu, click the new Connections option. If prompted, log in to the Connections Manager using your ClientPay login information.
​

Once the Connections manager page loads, click Connect to QuickBooks and log in to your QuickBooks Online account.

Select the start date for the transactions that you’d like uploaded to QuickBooks Online and click on the toggles for the accounts that you’d like to have transactions uploaded.

Your ClientPay account is now successfully integrated with QuickBooks Online

Upon successful integration, ClientPay transactions will be uploaded automatically to the newly created ClientPay Clearing account by the following day.

With transactions automatically being uploaded to the newly created ClientPay Clearing account located in your Chart of Accounts, it’s necessary to categorize the deposits located in the bank feed as ClientPay Clearing.

First, navigate to the bank feed by clicking on Banking from the options provided on the left menu bar and select the account where your ClientPay deposits are uploaded from your bank.

Categorize each deposit located in the bank feed associated with ClientPay to the ClientPay Clearing account.

With transactions and bank deposits now categorized to the ClientPay Clearing account, you can begin the reconciliation process. Navigate back to the ClientPay Clearing account and click on the Reconcile button located in the top right corner.

On the reconciliation screen, select the transactions associated with the deposits that you categorized from the bank feed and click Finish Now.

With reconciliation now complete you’ll see an “R” in the column to the right of the Deposit amounts.

To automate the categorization of your bank feed credit card deposits to the ClientPay Clearing account, consider creating a “Rule” that will categorize and add the deposit to the ClientPay Clearing account. Here’s how:

Navigate to the Bank Feed in QuickBooks Online where your ClientPay deposits are uploaded from your bank and select the Rules tab towards the top of the page and click New Rule located in the top right corner.

It is recommended to name the the Rule: CC Deposit - ClientPay Clearing to make it clear what the rule does. The following categorization for the below fields is recommended as well:

With this rule created, the deposits associated with credit card transactions in your bank feed will automatically be categorized to the ClientPay Clearing account.
​
​

To automate the categorization of ClientPay eCheck deposits in addition to credit card deposits in your bank feed, you’ll create an additional rule.

It is recommend naming the rule: “eCheck Deposit - ClientPay Clearing” to make it clear what the rule does.The following categorization for the below fields is recommended as well:

With this rule created, the deposits associated with eCheck transactions in your bank feed will automatically be categorized to the ClientPay Clearing account.

Quick tip: To further automate deposits being added to the ClientPay Clearing account, toggle the Auto-add switch located at the bottom of the rule creation page.

Transactions uploaded from ClientPay to the ClientPay Clearing account will be categorized in QuickBooks Online as Uncategorized Income to assist in the generation of revenue reports.

Invoice reconciliation is not currently included in this version. Let us know that you’d like that feature added by sending feedback to [email protected].