Integration with Kickserv & QB Online

Explore this app to reconcile your Stripe transactions into QBO.

https://partnerstack.synder.com/quickbooks

Hello there, @BevCapeCod.

I am here to provide you with some insights about your payment transactions showing in the Bank deposit page. To help you avoid any confusion, the payments you see on your bank deposit statement are from Kickserv and can be easily matched to the transactions stored in the undeposited funds. This process will ensure that you have no duplicate entries and that your financial records are accurate.

Please follow the steps below to get you going.

1. Go to +New and select Bank deposit.
2. Under the Account, choose a bank account where you want to deposit these payments.
3. Once done, click Save and close.
4. Go to your Banking page and click the transaction with the same amount as your bank deposit.
5. It says there that there's a match found. Under the Action section, select Match.

Now you successfully matched the transactions from your Bank deposit to the transaction in your Bank feed.

Moreover, I'm adding this article for detailed information about matching your bank and credit card transactions: Match online bank transactions in QuickBooks Online.

If you need help with matching bank transactions, please don't hesitate to reply below. I'm more than happy to assist you in any way I can.

You don't really understand the problem.  There are two different procedures that happen.  Kickserv removes their fees before the batch of several customers is exported to QuickBooks.  First, the batch is sent over minus the fees and it doesn't break down which customers are in a batch.  Second, it sends over the individual customer amounts to the QB Bank Deposit page.  The batch is what actually goes into our bank account so that is accepted on the Transaction page and goes into the check register.  The individual customer amounts match with their accounts and they stay in the Bank Deposit page.  I can't get rid of them.  We started using Kickserv's Stripe online payment program in May and I now have 7 months worth of individual customer payments in Bank Deposits and I can't clear them.  If I delete them, they are deleted from the customer account and it looks like they didn't pay.  If I accept them, it duplicates the batch amount plus it looks like a full payment without the KS fee.  For example, if client John Doe has a bill for $100 and Jane Smith has a bill for $50 the batch amount might be $148 because it's minus their fees.  It migrates over to QuickBooks as a batch for $148 into our bank account which is correct.  But then the individual payments of $100 and $50 show up in the bank deposit credited to John and Jane.  And they sit there.  I can't delete them and I can't accept them.

Hi there, @BevCapeCod.

I understand the urgency of resolving this matter, and I'm here to provide valuable insights to help you integrate with Kickserv & QuickBooks Online (QBO).

The first is to accept the Bank deposit (the individual customer payment) from Kickserv. Once done, deduct the fees (from Kickserv) from that Bank deposit by editing it in QBO. If you don't know how much the total fees is, just subtract the Bank deposit from that Batch payment (in your example, the $148).

Here's how:

1. Enter the bank fee as a line item in the "Adds fund to this deposit" section.
2. Select your new Bank Fee expense account and enter a negative value that reflects the bank fee amount. 
3. If you know the fee is 1% of the total, enter this formula -(total)* .01, and hit the tab key to quickly calculate the fee. 

Once the seven months of individual payments have already been deposited in the program, I suggest deleting the batch payment (to avoid duplication) and then reconcile the transactions in QBO.

Moreover, I'll be sharing the following resources on how to reconcile transactions in QBO:

Reconcile an account in QuickBooks Online.

Feel free to contact me if you need further assistance with your financial transactions. Best of luck!