Ebay Managed Payments Double Counting

Good day, @MarkR66. I can share more information about eBay payment transactions in QuickBooks Online (QBO).

I want to ensure you're taken care of, especially when you need to review your application configuration in eBay to sync transactions in QBO. You'll want to contact eBay app support to check your app setup since they are the ones who know how to configure it well.

On the other hand, I understand where you're coming from. Instead of adding eBay transactions, you'll have to match the eBay payment transactions with the sales receipts in QuickBooks to record this correctly. In addition, on second thought of recording sales receipts directly into the bank chart of accounts on the transaction, I suggest receiving them in the Undeposited Funds account. Since your daily payments from eBay are showing as your total daily sales, you can create a bank deposit to match. We'll have to treat them as banking transactions.

Here's how:

1. Go to Sales and then select All Sales.
2. From the Type field, pick Sales Receipts.
3. Then click Edit from the Action column.
4. Pick Undeposited Funds/Payments to Deposit from the Deposit to drop-down.
5. Hit Save and close.

Once done, you can create a bank deposit to accumulate each sales receipt transaction and deposit it to a bank/eBay chart of accounts that eBay uses.

1. In QBO, click + New.
2. Select Bank deposit.
3. Pick the bank/eBay from the Account field.
4. From there, select all the Sales Receipts for that day by checking the boxes in the Select the payments included in this deposit section.
5. Hit Save and close.

Once all is good, undo all the payment transactions you added recently in eBay's Categorised tab. Please check the steps in this article: Unmatch downloaded bank transactions or move them to another account. It's for online banking, yet the steps are the same.

Those payments will return in the App Transactions' For Review tab. You can then match them to the bank deposit transaction that we created. This way, we can avoid overstating your income in profit and loss reports and accounting.

Alternatively, you can match transactions by hand using the Find match feature to pair the eBay payment with the sales receipts. This resource may be a US article, but the flow is still the same with the QBO UK version: Match online bank transactions in QuickBooks Online.

In addition, you can check this guide for more information about banking features: A beginner's guide to online banking in QuickBooks Online.

Let me know if you need more assistance handling app transactions like eBay. I'll keep my notifications open. Stay safe, and have a prosperous business year.

@MarkR66 

The free connector only offer limited functionality and is not reliable. Consider using a paid one.