I have duplicate sales and can't seem to delete. One is from shopify and the other is from paypal (the customer completed the transction through shopify using paypal).

Helping you delete duplicate sales transactions in QuickBooks is my priority, gemsofquartz-gma.

You can use the Exclude feature in QuickBooks Online to delete the duplicate sales transactions in QuickBooks. Let me walk you through the process.

1. Click Transactions in the left panel and choose Banking.
2. In the For Review tab, select the duplicate sales transactions. 
3. Tap on the Exclude button.
4. Go to the Excluded tab, select the transactions again.
5. Hit the Delete button.
   

Check out this article to know more about this process: Exclude expenses from downloaded bank transactions. Also, I recommend editing, assigning, and categorizing your transactions. Also, you can match them to the existing entries in the software. Just go to the For Review tab from the Banking menu. Doing so will help you ensure the accuracy of your financial records.

Please know that I'm just a post away should you need anything else or if you have any follow-up questions about duplicate sales transactions. I'm always here to help and ensure that your questions are addressed accordingly. Wishing you a wonderful week ahead.

Hi, gemsofquartz-gma.

Hope you're doing great. I wanted to see how everything is going about the duplicate sales transactions you had yesterday. Was it resolved? Do you need any additional help or clarification? If you do, just let me know. I'd be happy to help you at anytime.

Looking forward to your reply. Have a pleasant day ahead! 

Hello Rose,

I have the same problem with one of my clients who engaged me last week. I am bit confused as to how this works. When the order is made at Shopify that generates sales in QBO, where does the corresponding entry go?  When the settlement is made obviously the bank has to be credited then where do the credit go?

I shall also appreciate if I am made aware how the inventory and Cost of Goods sold are treated. My client has a big inventory sitting in QBO. Cost of good sold is just a few thousand compared to the sale.

I think the shopify is not set properly.

Do you have any idea to do this please?

Thanks and Kind Regards

Constantine

Thank you for letting us know about the issue you have been experiencing, @Soundra. Allow me to share some information to get this sorted out.

Once you integrate the app, you can enable the setting of your Shopify Payments fees, and payouts are automatically exported to QuickBooks Online. In your scenario, you'll have to check and verify if you have set up a Shopify bank account where your sales are deposited when paid.

 Also, QuickBooks for Shopify lets you choose an existing account or create a new one to import your order information into. That includes being able to classify your gift card sales in a liability account. 

I'm adding this article that provides an overview of Shopify: Shopify for QuickBooks Online. It also contains contact information if you have any other questions about the third-party app.

Regarding your second question, Inventory, and COGS are treated depends how your use the product and service that they set up with Shopify. In QuickBooks Online, we use the First Out (FIFO) concept for your products and services.

To allow the system to adjust COGS, you need to enter inventory items. Learn more about this through this link: What is FIFO and how is it used for inventory cost accounting?

Moreover, you can run an Inventory Valuation Detail report. It contains your transactions for each inventory item, and how they affect quantity on hand, value, and cost.

1. Select Reports, then select Inventory.
2. Select Inventory Valuation Detail then set the dates to All.
3. Click the Customize button and filter the necessary details.
4. Double-click the item in question.

I have here resources that give you more information about inventory management in QuickBooks. It provides the right ways to handle your business essentials.

• Cost of goods sold: How to calculate and record COGS
• Set up and track your inventory in QuickBooks Online
• Adjust inventory quantity on hand in QuickBooks Online

Let me know if you have any other questions. I'll make sure you're all set. Have a lovely day! 

@Soundra 

Explore the trial version of this app to reconcile your PayPal and Shopify transactions. You may find some useful reference to resolve your issue.

https:// synder.grsm.io/quickbooks

Hi, I am following up on this as this didn't answer the question.  We have the Shopify connector and Paypal connector apps that both import transaction data.  For transactions where a customer purchases on shopify and pays using paypal, both shopify and paypal are importing the transactions creating a duplicate transaction.  That said, shopify does not import the paypal fee associated with the transaction and if we delete the Paypal generated transaction, then the fee does not record.  Is there a recommended solution to this problem? It must be fairly common and it's baffling me why there isn't more on this online somewhere.

Also, I'm assuming that if we remove the sales receipt generated by Paypal then the related COGS duplication also goes away but if that isn't the case then let us know also.

Thank you for following this thread, sigruntennis.

Let me guide you in the right direction on how to keep your PayPal and Shopify transactions in order.

Since both programs are connected to QuickBooks Online (QBO), we'll have to disconnect your PayPal app and then connect it through banking to prevent duplicates. I'm here to help make sure you can do this in just a few clicks.

To disconnect:

1. Log in to your QuickBooks Online account via a browser.
2. Head to the Apps menu on the left menu and go to the My Apps tab.
3. Look for the PayPal app and click the Action button.
4. Choose Disconnect and answer the exit survey.
5. Click the Confirm Disconnect button.

After that, connect PayPal to your online banking account. This way, you can manually categorize the entries and then find a match to the imported sales receipts. Then utilize the Resolve Difference function to include the fee when matching the transactions.

Also, make sure to manually delete your duplicate entries to keep your records accurate. Shopify will now import the sales receipts automatically. While your bank feeds will receive any PayPal transactions.

For additional resources, here's an article that tackles the Connect to PayPal app. Also, these links contain topics that will guide you through the process of handling your banking and customer-related tasks:

• Invoices and payments 
• Sales and customers 
• Banking 

Drop a comment below if you have additional questions or concerns on how to handle transactions from the programs above. I'll get back to make sure this is taken care of for you. Have a great day ahead.