The QuickBooks Online integration was created to automatically upload transactions to a newly created AffiniPay Clearing account making deposit reconciliation with AfffiniPay 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 AffiniPay 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 AffiniPay 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 AffiniPay account is now successfully integrated with QuickBooks Online

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

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

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

With transactions and bank deposits now categorized to the AffiniPay Clearing account, you can begin the reconciliation process. Navigate back to the AffiniPay 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 AffiniPay Clearing account, consider creating a “Rule” that will categorize and add the deposit to the AffiniPay Clearing account. Here’s how:

Navigate to the Bank Feed in QuickBooks Online where your AffiniPay 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 rule: CC Deposit - AffiniPay 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 AffiniPay Clearing account.
​
​

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

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

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

Transactions uploaded from AffiniPay to the AffiniPay 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].