When Kolleno processes payments through Payment Service Provider (PSP), it automatically creates deposits in QuickBooks. However, you may need to verify these deposits match your actual bank payouts, especially when processing fee markups are involved.
This article explains how to locate and verify Kolleno created deposits in QuickBooks to ensure your bank reconciliation is accurate.
How Kolleno Deposits Work in QuickBooks
When a payout occurs from Payment Service Provider (PSP) to your bank account, Kolleno creates a Bank Deposit in QuickBooks that includes:
Individual customer payments that are part of the payout
Payment Service Provider (PSP) processing fees
The deposit total should match the actual amount deposited to your bank account by Payment Service Provider (PSP).
Steps to Locate a Kolleno Deposit in QuickBooks
Step 1: Find the Payout in Kolleno
In Kolleno, navigate to Payments > Payouts
Locate the payout you want to verify
Check the "ERP Internal ID" column in the Synchronization Status section
Copy the ERP internal ID
Step 2: Open the Deposit in QuickBooks
Method 1: Using the URL (Fastest)
In QuickBooks Online, navigate to any Bank Deposit
Look at the browser URL - it will look like:
https://qbo.intuit.com/.../deposit?txnId=12345Replace the number after
txnId=with the ERP Internal ID you copied from KollenoPress Enter to navigate directly to the Kolleno created deposit
Method 2: Using the Deposit Detail
In QuickBooks Online, Go to the Reports menu > Banking > Deposit Detail.
Check for Undeposited Funds funds that have been received but not yet deposited into a bank account.
Step 3: Review the Deposit Components
Once you've opened the deposit, verify the following:
Customer payments - Each payment from Kolleno should appear as a line item
Payment Service Provider (PSP) processing fees
The deposit total should match your Payment Service Provider (PSP) payout amount exactly.