The QuickBooks Online (QBO) integration automates deposit reconciliation by uploading transactions directly to a dedicated AffiniPay Clearing account.
Feedback: Have questions? Email the team at [email protected].
Watch our quick video to get started:
Review integration steps below:
1. How to Integrate
Log in to AffiniPay, click your name (top right), and select Connections.
Click the + sign to Add Connection.
Select QuickBooks and click Connect to Quickbooks.
Log in with your QBO credentials.
Choose your transaction Start Date and toggle the specific accounts you wish to sync.
Transactions will begin uploading to your "AffiniPay Clearing" account by the following day.
2. How to Reconcile
To keep your books balanced, categorize your bank deposits to match the integrated transactions:
Go to Banking in QBO and select the account receiving AffiniPay deposits.
Set the category for these deposits to AffiniPay Clearing.
Go to the AffiniPay Clearing account, click Reconcile, select the matching transactions, and click Finish Now.
With reconciliation now complete you’ll see an “R” in the column to the right of the Deposit amounts.
3. Advanced Usage
1. Automatic categorization of AffiniPay Credit Card Deposits in Bank Feed
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:
Apply this to transactions that are: Money In in All bank accounts
Include the following: Bank text Contains "Deposit Merch Svc"
Then Assign:
Transaction type: Deposit
Category: AffiniPay Clearing
With this rule created, the deposits associated with credit card transactions in your bank feed will automatically be categorized to the AffiniPay Clearing account.
2. Automatic categorization of AffiniPay eCheck Deposits in Bank Feed
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:
Apply this to transactions that are: Money In in All bank accounts
Include the following: Bank text Contains "Deposit Affinipay"
Then Assign:
Transaction type: Deposit
Category: AffiniPay Clearing
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.
3. AffiniPay Uploaded Transaction Categorization
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.
Limitations
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].