Skip to main content
October 18, 2021
Question

How to properly register Shopify Refunds in QBO

  • October 18, 2021
  • 1 reply
  • 0 views

Hello guys! 

Whenever we receive a payout from Shopify, as you know, the full payment includes: Sales, fees, refunds, etc.

This goes to our bank account as a single transaction. 

These are the steps we follow: 

1. In banking, select the transaction and click in Find match

2. Once open, we select all the orders that correspond to this payout

3. At the bottom we select resolve difference and in there we add: 

a. Shopify fees 

b. Shopify refunds (by separate, assigned to every costumer)

c. any other expense or income reflected in the payout.

4. Save.

 

On the other hand, as when we resolve the difference in the find match part, the system does not create a refund receipt on the costumer's history so, when we issue a refund in the tab Costumers, we look up for the specific person, and follow these steps: 

1. Create a refund receipt, assigned to our costumer and taking funds from our bank where we received the Shopify payout. 

3. Save

 

The thing is that, both the refund receipt and the Shopify matched transaction are taking funds from the same bank, so the refund shows duplicated in chart of accounts. 

 

How can I fix this? We need refund to show in the costumer's profile and also to resolve the difference in the payout, so it is confusing how to proceed.

 

Thank you so much 

 

 

 

1 reply

October 18, 2021

Thank you for joining the QuickBooks Community, Data2021! What we have seen users shared is recording a customer credit instead. This is a solution that worked for most of our users. It reduces the balance (i.e., the amount owed) without taking money out of the bank register.

 

I am providing this article that explains how to handle customer credit in QuickBooks Online. Based on your preference they are a few options on how to apply this.

 

However, it will be best to consult with an accountant for the best solution for your business. If you don't have one, we offer a ProAdvisor Program. Simply enter your zip code and view experts around your area.

 

 

If you have any questions, feel free to let us know by commenting below. My team and I will do our best to help! Take care for now.