Shopify and Credit Card Integration

smnelson23 · ‎January 29, 2025

Hello all,

I have been using Quickbooks for my small business since last June, mainly to create Income Statements and Balance Sheets. Until recently, I have been manually entering the sales and expenses in their respective categories/accounts I created to show exactly what I want to see in my income statement.

However, I just integrated my Shopify and Etsy accounts to my QB account, and it pre-categorized all of the sales, discounts as expenses, with no option for me to review and categorize them how I was before (I don't want to categorize each individual sale, but in Shopify I can see the total sales from my online store versus different pop-up events which I would like to see and categorize each pop-up's sales on my Income statement).

The bigger problem is, the Shopify integration went back further than what I needed (I only had Q4 left to do of 2024), and it has messed up all of my past income statements with duplicate revenues and new accounts on the income statement, drastically changing the net incomes for each quarter.

Is there a way to undo the Shopify integration completely, and then re-try it by setting a date it should not go beyond? How can I clean this up and prevent QB from Auto-categorizing the Shopify data?

Erika_K · ‎January 29, 2025

Thank you for providing such a detailed description of your concerns, smnelson23. Yes, you can disconnect and reinitiate your Shopify integration from scratch. Let me discuss the specifics below.

You'll need to first Exclude the For review transactions associated with these platforms to prevent duplicate entries in your financial records. This will prevent QuickBooks from allowing the platforms to import transactions into the bank feed again.

Afterward, we can disconnect your Shopify and Etsy applications from QuickBooks Online (QBO). I'll show you how:

Go to the Apps menu, then select Overview.
Find the app you need to disconnect.
Choose the dropdown menu next to Launch, then click Disconnect.
Complete the short questionnaire.
Hit Disconnect to remove the app from your company profile.

Next, you'll want to reconnect the applications. During this process, ensure you set a specific integration or look-back date to determine when you want transactions to start importing. This will help maintain the accuracy of your financial records in QBO.

Regarding your concern about auto-categorization, you may have configured bank rules for your Shopify and Etsy transactions. These rules could affect how transactions are categorized.

Given this, I suggest checking your bank rules setup. If you choose not to use this feature, you can Delete or Disable the rules according to your preferences. I'll add an image for visual reference.

Lastly, I've compiled a few resources you can browse to learn about the different tips for managing your downloaded transactions in QBO:

For any questions about managing your integration, post in the QuickBooks Community forum. Our experts are ready to provide prompt assistance.

smnelson23

Hello,

Thank you so much for the detailed response it was very helpful. However, unlinking the accounts didn't accomplish much. All of the duplicate sales and expenses are still left as accounts with balances and still showing in my reports.

The only action it lets me do is make the "Channel" accounts accounts inactive, but I am reading online that this wont delete the transactions in those accounts, and it could cause errors with other accounts that reference them (However, we did not reference these accounts in any of the reports or accounts we actually do use).

I cant simply delete all of these duplicate transactions and get accurate Income Statements without exporting them to excel, and then manually deleting the rows of the duplicate accounts.

Are there any solutions to this?

Jovelyn_M

Thank you for returning to this forum with an update, smnelson23.

Your approach is correct. The only way we have to undo the Shopify integration is to remove all the transactions you currently have in QuickBooks. Before doing that, it's important to export these transactions so you have a record of them.

When setting up the import, choose a specific start date for bringing in transactions. This date determines the starting point for importing transactions, ensuring that your QuickBooks Online (QBO) financial records remain accurate and up-to-date. By setting this specific date, you can avoid duplicating existing entries and maintain the integrity of your accounting data within QBO.

To help you better manage your imports and exports in QuickBooks Online, I'll provide a link to a detailed guide: Import/export CSV files.

For your convenience, I've included a helpful resource that'll help you how to reconcile your accounts. This guide will ensure your records align with your bank and credit card statements: Reconcile an account in QuickBooks Online.

We're ready to assist you with your Shopify integration. If you need guidance or have questions, don't hesitate to ask in this forum. We value your participation and are committed to enhancing your QuickBooks experience.