cancel
Showing results for 
Search instead for 
Did you mean: 
eva20
Level 1

I disconnected an account before I finished reviewing transactions and it disappeared from the website. How do I see the transactions that need review?

 
Solved
Best answer November 13, 2021

Best Answers
Adrian_A
Moderator

I disconnected an account before I finished reviewing transactions and it disappeared from the website. How do I see the transactions that need review?

Hello there, eva20.

 

Once you disconnects an account,  the automatic online banking updates will delete any transactions in the For Review tab. That said, you can reconnect the account then  add and match all the pending transactions or you can manually add them through an Excel file.

 

You can check this article for the detailed steps of the process: Manually add transactions to account registers.

 

Afterwards, to ensure that your accounts  always match your bank and credit card statements, you'll have to reconcile them.

 

That should do it, eva20. Keep me posted if there's anything that I can help with the reconciliation. Have a good one!

View solution in original post

8 Comments 8
Adrian_A
Moderator

I disconnected an account before I finished reviewing transactions and it disappeared from the website. How do I see the transactions that need review?

Hello there, eva20.

 

Once you disconnects an account,  the automatic online banking updates will delete any transactions in the For Review tab. That said, you can reconnect the account then  add and match all the pending transactions or you can manually add them through an Excel file.

 

You can check this article for the detailed steps of the process: Manually add transactions to account registers.

 

Afterwards, to ensure that your accounts  always match your bank and credit card statements, you'll have to reconcile them.

 

That should do it, eva20. Keep me posted if there's anything that I can help with the reconciliation. Have a good one!

HHINK
Level 1

I disconnected an account before I finished reviewing transactions and it disappeared from the website. How do I see the transactions that need review?

How about if I want to UNDO the transactions that have already been reviewed after disconnecting the connector? I reconnected the connector and added the same dates however now my Shopify channel is denoted with a "-2" and I can't see the previous transactions to undo them. I wouldn't mind going to the sales tab and deleting all transactions for customer ".shopify" however I want to make sure that all imported information (tax, discounts, etc.) are also deleted from my connector. Ideally I would like to "undo" them from the app connector in order to ensure I have truly removed everything pulled in. 

ReymondO
QuickBooks Team

I disconnected an account before I finished reviewing transactions and it disappeared from the website. How do I see the transactions that need review?

Thanks for joining the thread, @HHINK

 

I'd be glad to share info on how to remove all transactions associated with your Shopify. 

 

Since you're unable to find the previous transactions that need to undo, I'd suggest deleting all transactions for this customer. Here's how:

 

  1. Go to Sales and select Customers.
  2. Click the name of the customer, then click the Action drop-down list.
  3. Choose Delete.
  4. Select Yes to confirm.

 

Repeat the steps above until you fully deleted all of your sales transactions. This way, we can ensure that all imported sales will be deleted from your customer's account.

 

Before performing these steps, I'd suggest printing or exporting your sales to Excel. This way, you'll have backup data in case you need them in the future. Please take note that doing these steps will affect your records in QuickBooks. If you're not sure about the process, I'd recommend reaching out to your accountant for further advice.

 

On our Help Articles site, you'll find a wealth of valuable information tailored to address various aspects of QuickBooks usage. Whether you're a beginner looking to learn the basics or an experienced user seeking advanced techniques, we've got you covered.

 

Let me know else I can help you with your transactions. I'm more than happy to provide additional assistance. Keep safe!

HHINK
Level 1

I disconnected an account before I finished reviewing transactions and it disappeared from the website. How do I see the transactions that need review?

Great idea on the excel download just in case anything happens! I was able to successfully delete the sales transactions however there are many more categories that are still showing up. I still have "Channel Adjustments" "Channel Selling Fees" and "Channel Clearing Account" I tried searching the quickbooks support you linked however it's not doing a good job of finding what I need help with. I tried looking at expenses however it doesn't allow for mass deletion and the shopify name doesn't exist in the vendors like it did for sales in the customers. Any ideas? 

HHINK
Level 1

I disconnected an account before I finished reviewing transactions and it disappeared from the website. How do I see the transactions that need review?

Great idea on the excel download just in case anything happens! I was able to successfully delete the sales transactions however there are many more categories that are still showing up. I still have "Channel Adjustments" "Channel Selling Fees" and "Channel Clearing Account" I tried searching the quickbooks support you linked however it's not doing a good job of finding what I need help with. I tried looking at expenses however it doesn't allow for mass deletion and the shopify name doesn't exist in the vendors like it did for sales in the customers. Any ideas? 

JamesAndrewM
QuickBooks Team

I disconnected an account before I finished reviewing transactions and it disappeared from the website. How do I see the transactions that need review?

Hello, 

 

Could you please provide us with more specific information like where does these categories showing up? We'd appreciate it if you could also add screenshots so we can get more details on what's happening.

 

You can leave a response, and we are available to help. Have a great day ahead.

HHINK
Level 1

I disconnected an account before I finished reviewing transactions and it disappeared from the website. How do I see the transactions that need review?

So these were all uploaded via the Quickbooks Shopify Connector tool. These were duplicating the transactions pulled in from QBO connector tool. I was told to disconnect the Quickbooks connector and "undo" the app transactions. I didn't know that I had to "undo" the transactions before I disconnected the connector. After I disconnected I was told the only way to "undo" these transactions was to go to sales and delete these orders. I did that. Only problem is that other transactions are also imported such as the "channel adjustments, channel selling fees, and channel clearing" They are expenses that are cleared through the clearing account. I don't know what's the best way to bulk delete these transactions from my expenses. I explained previously how I can delete fairly easily from sales by choosing the customer "shopify channel" however for these expenses, they're not a vendor for me to choose. I have provided an example of the journal entry I'm trying to delete but I keep getting an error saying authentication ticket mismatch fail. 

Mark_R
QuickBooks Team

I disconnected an account before I finished reviewing transactions and it disappeared from the website. How do I see the transactions that need review?

Thank you for sharing detailed information, @HHINK.

 

Currently, QuickBooks doesn't have the option to delete expense transactions by batch.

 

I understand that you want to delete expenses in bulk the same as your sales transactions. Since this option isn't available, I suggest deleting each expense one at a time. Here's how:

 

  1. Sign in to your QuickBooks Online (QBO) account.
  2. Click Expenses from the left menu, then select the Expenses tab.
  3. Find the expense transaction you want to delete.
  4. From the Action column, click the drop-down and select Delete.
  5. Click Yes to confirm.

 

On the other hand, the authentication ticket mismatch fail error may be caused by a data issue on the browser. To verify, let's log in to your QBO account using a private browser.

 

If this works, you need to clear the browser's cache so the system can start fresh. If you get the same result while using a private browser, I suggest switching to a different one.

 

Just in case you want to learn more about Shopify integration, you can check out these articles for more guidance:

 

 

Come back to this post if you have other concerns or follow-up questions about this. I'm always here to help.

Need to get in touch?

Contact us