Skip to main content
All CollectionsPaymentsReporting
QuickBooks Online Integration
QuickBooks Online Integration
Updated over 7 months ago

What does it do?

The QuickBooks Online integration was created to automatically upload transactions to a newly created LawPay Clearing account making deposit reconciliation with LawPay 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.

How to integrate

Log in to your LawPay 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 LawPay login information.

1.png

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

2.png

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.

3.png

Your LawPay account is now successfully integrated with QuickBooks Online

4.png

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

5.png

How to Reconcile

With transactions automatically being uploaded to the newly created LawPay Clearing account located in your Chart of Accounts, it’s necessary to categorize the deposits located in the bank feed as LawPay 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 LawPay deposits are uploaded from your bank.

1.png

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

2.png

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

3.png

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

4.png

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

5.png

Advanced Usage

Automatic categorization of LawPay Credit Card Deposits in Bank Feed

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

Navigate to the Bank Feed in QuickBooks Online where your LawPay 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.

1.png

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

  1. Apply this to transactions that are: Money In in All bank accounts

  2. Include the following: Bank text Contains "Deposit Merch Svc"

  3. Then Assign:

    • Transaction type: Deposit

    • Category: LawPay Clearing

2.png

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

Automatic categorization of LawPay eCheck Deposits in Bank Feed

To automate the categorization of LawPay 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 - LawPay Clearing” to make it clear what the rule does.The following categorization for the below fields is recommended as well:

  1. Apply this to transactions that are: Money In in All bank accounts

  2. Include the following: Bank text Contains "Deposit LawPay"

  3. Then assign:

    • Transaction type: Deposit

    • Category: LawPay Clearing

3.png

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

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

LawPay Uploaded Transaction Categorization

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

What Does It Not Do?

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].

Did this answer your question?