cancel
Showing results for 
Search instead for 
Did you mean: 
Danhawthorne
Level 2

Duplicate deposit from commercesync in wrong bank account, correct deposit manually uploaded to correct account.

I have just started to convert my 2020 books from multiple spreadsheets to Quickbooks Online. I am using Commercesync to transfer Square historical records from the 1st quarter 2020 to Quickbooks. I had one bank account at the beginning of the year and opened a second bank account in the 3rd qtr. Since my current bank account in Square is the New bank account, when Commercesync transferred the records from the 1st quarter, they ended up in the new bank account with all the correct details(cash/credit/squarefees). I wasn't aware that the transactions were there so I manually uploaded the historical transactions to the correct account. I'm trying to determine how to 'delete' the manually uploaded transactions and transfer the correct transactions from the new bank account to the one where they belong. I found some references to clean up duplicate bank deposits but when I try to 'create' the new deposit I can't select the transactions because they don't show up in my new bank account. 

My manually uploaded transaction amount is 3.60 the deposited amount including sales tax but not including the square CC fee. ($.19)

The commercesync transaction does include the details for the square fee and the invoice from the commercesync includes the sales tax and square fee somehow. 

I couldn't figure out how to include all the screenshots in this post so I'm attaching a word document with those details. 

 

 

Solved
Best answer August 07, 2021

Best Answers
Danhawthorne
Level 2

Duplicate deposit from commercesync in wrong bank account, correct deposit manually uploaded to correct account.

It turns out that I was confusing transactions to be categorize with transactions recorded in the bank Register. I have transactions to be categorized in the 2388 account but the records transferred from Square via commercesync show up in my 3757 bank register. I worked with quickbooks support who showed me that even though I thought there were duplicate transactions, because the transactions in 2388 were never completed they never showed up in the 2388 bank register. So they were in fact not duplicates yet just 2 sides of the same transaction that I needed to match. All I needed to do was to edit the lines in my 3757 bank register and from the edit window with the transactions that I need to move checked, select my 2388 account from the account drop down on the Bank Deposit. Save,  than say "yes" to the linked transactions warning. And move on to the next record that needs to be moved. Very simple and elegant. Thank you all for trying to help me understand a variety of solutions, that I suspect I will inevitably need to apply as I stumble through this Bookkeeping process. 

View solution in original post

8 Comments 8
JessT
Moderator

Duplicate deposit from commercesync in wrong bank account, correct deposit manually uploaded to correct account.

 Hi Danhawthorne,

 

Thanks for explaining your concern in detail and for including screenshots. I also appreciate your effort in finding a similar post in the Community. I'll help you with this.

 

We cannot apply the steps on the thread that you've read because they are only intended for correcting a Transfer type of transaction, not for moving a transaction to a different account. I've already sent feedback about it.

 

What we can do is remove the first-to-second quarter transactions from the New account (Checking). Then, since you've also uploaded them to the correct account (TD Bank), just add them to your books.

 

The catch here is synced App transactions are a complete package. They include sales transactions, like invoices with taxes, which are not available if you just add transactions from Banking. Therefore, it's up to you to decide whether you want to keep the first-to-second quarter transactions in Checking or not. If you do, you can follow the steps below, and don't add what you've uploaded to TD Bank on the Banking page.

 

Remove first-quarter transactions from Checking:
 

  1. From the Banking section, click on App Transactions beside it.
  2. Click the Reviewed tab.
  3. Put a check on all first-quarter transactions that belong to TD Bank, but I highly suggest trying one transaction first to see the result.
  4. Click Undo to remove them from your books, and then Confirm.

 

Add the uploaded transactions in TD Bank to your books.
 

  1. Go to the Banking section.
  2. Select the TD Bank account.
  3. Review, categorize and match or add your transactions to your books.

 

Let me know if you require further assistance. I'll be happy to continue lending a hand. Take care and enjoy your weekend!

Fiat Lux - ASIA
Level 15

Duplicate deposit from commercesync in wrong bank account, correct deposit manually uploaded to correct account.

@Danhawthorne 

As another option, you may explore other apps to connect Square and QBO.

https://synder.grsm.io/quickbooks

https://bookkeep.grsm.io/quickbooks

 

As for your insurance, utilize the trial version of a backup restore app

https://rewindio.grsm.io/quickbooks

 

Danhawthorne
Level 2

Duplicate deposit from commercesync in wrong bank account, correct deposit manually uploaded to correct account.

My goal would be to somehow get the details out of the "new" Checking account(3757)and into the correct Checking account (2388). Because of all the Sales, invoices, sales tax, and square fees appear to be correctly handled from the Commercesync process. And all I need to do is transfer the deposit to 2388. 

However as you noted that might not be possible. 

The commerce sync transfers don't show up on the App Transfers tab at all.

I suspect now that since I was trying to review the bank deposits 2388 I uploaded manually against the Invoices with deposits sync'd to the 3757 account, I was constantly getting lost and confused about where the sales tax and square fees were being recorded because I was trying to reconcile the Invoices to the wrong deposits.

 

Hopefully I don't have to blow it all away because it is messed up too badly. The downside is that it will likely be Tuesday at the earliest that I could get the historical records transferred by commercesync into the clean Quickbooks instance. So I dread starting over. 

 

 

Danhawthorne
Level 2

Duplicate deposit from commercesync in wrong bank account, correct deposit manually uploaded to correct account.

Commercesync is able to provide me the category detail from Square and I know that bookkeep does not have that option. I also tried the Quickbooks Square connection, and Paytracker by SaasAnt, and all three don't have the category level details I need for tracking my consignment sales. Thanks for the suggestion. I'm not sure what that insurance is for. 

Danhawthorne
Level 2

Duplicate deposit from commercesync in wrong bank account, correct deposit manually uploaded to correct account.

I can't seem to read my earlier reply so apologies for any repeated comments. 

 

I know now that I will not need to upload manually the Square transactions to my 2388 account, but do need to upload the other non-Square related transactions. That is an easy fix for going forward. So I am learning. :)

 

How would I go about deleting all of the invoices, sales tax, square fee and the related deposits in 3757? 

 

I think I would be better off doing that as well as deleting just the square deposits from the transactions I uploaded manually to 2388.

 

And then making the banking change in Square from 3757 to 2388 and having Commercsync reload the historical transactions from Square. This would likely be an iterative eftort with me making the banking change 3757 to 2388 in the morning and Commercesync transferring as many days during the day and then I would need to go back and change the bank from 2388 to 3757 in the evening in Square so that the over night daily sync gets the records in 3757 where the current transactions need to be recorded. 

 

That would at least save me from redoing all the setups I have done with Classes, and Items related to the historical transactions that would be transferred by commercesync again. 

 

But can I really remove all the transaction data between 1/1/2020 and 4/1/2020 in quickbooks for these 2 bank accounts and the related invoices, square fees, and sales taxes where ever they are recorded? 

 

Thanks Dan

katherinejoyceO
QuickBooks Team

Duplicate deposit from commercesync in wrong bank account, correct deposit manually uploaded to correct account.

Thanks for coming back for more support, @Danhawthorne. I'm glad you're learning along the way. 

 

You'll want to exclude these transactions from the banking page to delete them. Here's how: 

 

  1. Go to Banking, then select the transactions in the For review tab.
  2. Select Exclude.
  3. Go to the Excluded tab, then locate the transactions. 
  4. Select Delete.

 

To delete an invoice, here's how:

 

  1. Click Sales on the left pane.
  2. Choose Invoices on the upper part of your screen.
  3. Open the invoice.
  4. Click More, thenDelete.
  5. Click Yes to confirm.

 

For additional reference, check out this article: Void or delete an invoice, bill, or other transactions

 

For future reference, you can check out QuickBooks Articles in case you'll need some easy steps with specific tasks such as sales and customer management.

 

Let me know in the comments below if you have any other concerns.

Danhawthorne
Level 2

Duplicate deposit from commercesync in wrong bank account, correct deposit manually uploaded to correct account.

It turns out that I was confusing transactions to be categorize with transactions recorded in the bank Register. I have transactions to be categorized in the 2388 account but the records transferred from Square via commercesync show up in my 3757 bank register. I worked with quickbooks support who showed me that even though I thought there were duplicate transactions, because the transactions in 2388 were never completed they never showed up in the 2388 bank register. So they were in fact not duplicates yet just 2 sides of the same transaction that I needed to match. All I needed to do was to edit the lines in my 3757 bank register and from the edit window with the transactions that I need to move checked, select my 2388 account from the account drop down on the Bank Deposit. Save,  than say "yes" to the linked transactions warning. And move on to the next record that needs to be moved. Very simple and elegant. Thank you all for trying to help me understand a variety of solutions, that I suspect I will inevitably need to apply as I stumble through this Bookkeeping process. 

Fiat Lux - ASIA
Level 15

Duplicate deposit from commercesync in wrong bank account, correct deposit manually uploaded to correct account.


@Danhawthorne wrote:

I'm not sure what that insurance is for. 


 

@Danhawthorne 

You can utilize the app to backup your QBO account prior to doing something risky to your existing data.

Need to get in touch?

Contact us