Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Solved! Go to Solution.
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!
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!
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.
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:
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!
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?
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?
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.
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.
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:
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.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here