Connected Ebay to QBO with Onesaas wrong and now my banking shows it as tripled. How do I fix this?

Middle_Class_Values · ‎October 21, 2021

I used Onesaas to connect my Ebay to Quickbooks online and I didnt read the article about using a clearing account before I did it. So I ticked when an order is created in Ebay create a sale invoice in Quickbooks. And I ticked the send payments from Ebay to Quickbooks and I put the account as my actual business bank account. Which my payout from Ebay already goes into there. I was trying to follow along with a youtube video that said it should match the deposit but it didnt work that way. What do I do to fix things back to normal because now quickbooks says I have 3 times as much as I do.

JasroV · ‎October 22, 2021

I appreciate you for sharing some clarifications, @Middle_Class_Values.

Allow me to chime in and provide additional insights on how to get around this issue.

When connecting your bank account to QuickBooks Online (QBO), your transactions will be sent to the For Review tab. This way, you can review them one by one before adding them to your register.

In your case, since the transactions are going directly to your chart of accounts, I recommend deleting them from your register. This way, we can avoid any duplicates records. I'll show you how:

Go to the Accounting menu and select the Chart of accounts tab.
Locate your Business Bank account, and click the View register link under the ACTION column.
Select a duplicate transaction, then click Delete to remove it from your register.
Repeat the process for your other duplicate transactions.

You can also utilize a third-party app that lets you delete those duplicates in your register by batch. Just hover to the Apps menu or visit our QuickBooks Apps Store page for reference. Once you've found an app, select it and click Get app now to link it to your account.

Furthermore, I highly recommend working with your accountant for additional guidance. This way, we can ensure the safety of your account after making these changes. They can also advise you on other ways in handling this matter. If you don't have one, you can visit our ProAdvisor page and look for one from there.

On the other hand, I encourage you to contact the Onesaas support team. One of their live agents can guide you through their integration process.

Once you're all set, check out these links for guidance on how to match your transactions and reconcile your account flawlessly:

Need more help matching your downloaded transactions or reconciling your accounts? Feel free to drop a comment below. I'll be here to assist you anytime. Take care!

View solution in original post

ReymondO · ‎October 21, 2021

Hi there, @Middle_Class_Values.

Thanks for reaching out in the QuickBooks Community.

You can exclude your tripled transactions to correct your bank records in QuickBooks. Let me show you how:

Go to the Banking menu, and select the Banking tab.
Click the For Review tab.
Select the checkbox of the transactions to exclude.
Click Exclude.

In case you accidentally exclude the wrong transaction, that’s easy to fix. Just select the Excluded tab, select the checkbox for the transaction, then click Undo. The transaction goes back to the For Review tab so you can decide what to do with it again.

I'd also recommend contacting Onesaas. This way, they can update their settings and avoid downloading duplicates in the Banking page.

I'm adding this article as an additional reference in categorizing your bank transactions in QuickBooks: How to review downloaded bank and credit card transactions and put them in the correct accounts.

Let me know how else I can help you with QuickBooks by adding a comment below. I'm more than happy to lend a helping hand. Keep safe!

Middle_Class_Values · ‎October 22, 2021

They never went into the for review tab they are just all record in my Business Bank account on the Chart of Accounts. And I get direct deposits from ebay managed payments so it just messed it all up.

Middle_Class_Values · ‎October 22, 2021

Its not in categorized either it just shows up in the bank account on the chart of accounts. I had set it up as an invoice which I think I shouldnt have so its going into accounts receivable and then its going into the bank account.

JasroV · ‎October 22, 2021

I appreciate you for sharing some clarifications, @Middle_Class_Values.

Allow me to chime in and provide additional insights on how to get around this issue.

When connecting your bank account to QuickBooks Online (QBO), your transactions will be sent to the For Review tab. This way, you can review them one by one before adding them to your register.

In your case, since the transactions are going directly to your chart of accounts, I recommend deleting them from your register. This way, we can avoid any duplicates records. I'll show you how:

Go to the Accounting menu and select the Chart of accounts tab.
Locate your Business Bank account, and click the View register link under the ACTION column.
Select a duplicate transaction, then click Delete to remove it from your register.
Repeat the process for your other duplicate transactions.

You can also utilize a third-party app that lets you delete those duplicates in your register by batch. Just hover to the Apps menu or visit our QuickBooks Apps Store page for reference. Once you've found an app, select it and click Get app now to link it to your account.

Furthermore, I highly recommend working with your accountant for additional guidance. This way, we can ensure the safety of your account after making these changes. They can also advise you on other ways in handling this matter. If you don't have one, you can visit our ProAdvisor page and look for one from there.

On the other hand, I encourage you to contact the Onesaas support team. One of their live agents can guide you through their integration process.

Once you're all set, check out these links for guidance on how to match your transactions and reconcile your account flawlessly:

Need more help matching your downloaded transactions or reconciling your accounts? Feel free to drop a comment below. I'll be here to assist you anytime. Take care!

Fiat Lux - ASIA · ‎October 22, 2021

@Middle_Class_Values

Utilize a deleter tool

https://transactionpro.grsm.io/qbo

Topics

Training

Community

Resources

Connected Ebay to QBO with Onesaas wrong and now my banking shows it as tripled. How do I fix this?