cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Everything you need to know about banking in QuickBooks Online - Discover more
augusewicz
Level 1

Duplicate Square and Ebay Transactions

I am new to QBO and recently opened an account on Jan 1. We use Square for both online/in person sales and Ebay for online sales. From about Jan.1-Jan. 17 Ebay and Square applications were inadvertently recording BOTH payouts and every individual transactions leading to almost $35,000 in duplicate entries. There are hundreds of entries which would take forever to delete manually. Is there a way to create a journal entry that would correct the mistake for that time period for Square and then Ebay?

4 REPLIES 4
SarahannC
Moderator

Duplicate Square and Ebay Transactions

Thank you for choosing QuickBooks, @augusewicz

 

You can record or create journal entries in QuickBooks Online to fix a duplicate transactions. This helps your books to balance in specific ways. However, you'll have to consult your accountant to ensure this process.

 

Let me show you how:

 

  1. Go to the +New button.
  2. Select Journal entry.
  3. Select appropriate accounts and enter all the details.
  4. Check the amounts - you should have the same amount in the Credit column on one line and the Debit column on the other. This means the accounts are in balance.
  5. Enter information in the memo section, so you know why you made the journal entry.
  6. Once done, click Save and new or Save and close.

 

For more details, you can check this article: Create a journal entry in QuickBooks Online. Still, I recommend consulting your accountant when doing this process. This is to ensure your accounts and data will remain accurate. This might also share another way to fix this duplicate entries.

 

You can find local accountants who specialise in QuickBooks Online on our ProAdvisor Directory. Visit this link: Find an accountant or bookkeeper near you. Once done, enter your postcode and hit the Find an accountant button.

 

Also, you can check about handling duplicate entries in this article: Exclude a bank transaction you downloaded.

 

Please know that you can post your QuickBooks concerns anytime. I'll be around to assist you. Bye for now, take care augusewicz.

augusewicz
Level 1

Duplicate Square and Ebay Transactions

I know HOW to make a journal entry but I'm not sure if that is the correct way to fix this issue. If anyone is familiar with connecting apps to QBO, it might be helpful to know if there's a way to "undo" transactions?

LollyNino_C
QuickBooks Team

Duplicate Square and Ebay Transactions

Hello there, @augusewicz

 

I'm here to share with you how to undo the transactions in QuickBooks Online.

 

You can undo categorized entries from the Categorized column on the Banking page. Here are the detailed steps:

 

  1. Open your QuickBooks Online account, then go to the Banking tab at the left pane.
  2. Select Banking, then look for your account.
  3. Click on the Categorized column.
  4. Choose the item/transaction, then tap on Undo under Action.

Here’s everything that you need to know on how to use online banking, connect bank accounts, and review your bank feed in QuickBooks Online.

 

If you want to do a bulk journal entry to adjust the balance of the chart of accounts the duplicates hit we'd suggest confirming with an accountant first as we're not trained accountants. We do welcome other users recommendations on this thread.

 

As a reference, you can also check out this article for further guidance: Undo or remove transactions from reconciliations in QuickBooks Online

 

You might also want to visit our QuickBooks Online learning guides for tutorials and webinars about the product.

 

Leave a comment below if there's anything else I can do to help you with your bank transactions. I'm always willing to help. Have a fantastic day!

 

Fiat Lux - ASIA
Level 15

Duplicate Square and Ebay Transactions

@augusewicz 

Consider having a paid connector to reconcile your Square and eBay transactions and avoid any duplications.

 

Need to get in touch?

Contact us