Skip to main content
L
Lyla Laura
August 19, 2021
Question

Matching shopify payouts that contain sales and refunds in QB

  • August 19, 2021
  • 2 replies
  • 0 views

Hello, 

 

I'm hoping someone can help please. I use shopify to sell my products which mixes sales and refund sin combined payouts. 

 

On 1st August I received a payout from Shopify that included orders #1,2,3,4,5. I created invoices in QB and matched these invoices to the payment. 

 

On the 8th of August, the person who placed order #3 asked for a refund, which came out of the 2nd shopify payment on August the 12th. This payment included orders #6,7,8 and refund of order #3. I am struggling to know how to reflect this in QB. How do I keep the invoice for order #3 matched to payout no.1 and yet create a refund and credit note that can be matched to payout number 2. 

 

If someone could please advise I would be grateful. 

 

Many thanks, 

Laura

 

 

 

2 replies

E
EmmaM
August 19, 2021

Hello Lyla, Thanks for getting in touch with the Community about how to record the refund and changes to invoice payments from Shopify. It may be a case of excluding the ones you can't match as long as the refund is created and the credit note is added so that the bank balance is correct in QuickBooks. Would you be able to attach a screenshot of the transactions that have been uploaded from Shopify so we can take a look?

L
Lyla LauraAuthor
August 19, 2021

Sure. So in the first screen shot you will see that the highlighted order pertains to the original order the customer made. The 6 open invoices were matched easily againist the first Shopify payout, 

 

However, in the 2nd screenshot, you will see that the money received on 18th of August contained various new sales and a refund of £61.99 because the highlighted customer from screen shot 1 decided she didn't want the product. 

 

My question is, can i keep her original payment matched against the first payout, and what do I create to create a match of a refund against the 18th of August payout? 

 

Many thanks

 

 

Adrian_A
Adrian_A
August 19, 2021

Hi, Laura.

 

Thank you for providing the screenshots. This helps me to have a visual overview of your concerns.

 

Yes. You'll have to keep the original payment since it's the basis to match it with the refund. Here's how to match the transactions:

 

  1. Click Banking.
  2. In the For Review tab, select the refund transaction.
  3. Click on Find Match.
  4. On the Match transactions page, select the transaction which the refund was for.
  5. Click on Save.

 

When you're register is ready to be reconciled, you can check this reference: Reconcile an account.

 

 Let me know if there's anything that I can help. Have a good one!

S
SirielJeaB
June 9, 2023

It's my pleasure to welcome you to the Community thread, abdequipmeny. I'll share information about matching transactions in QuickBooks Online. 

 

QuickBooks automatically downloads the most recent transactions from your bank and credit accounts and matches them to the transactions you've already recorded.

 

In some circumstances, transactions won't match up with existing records because the payees, amounts, and dates don't match; the transactions are older than six months; the bank account on the payment is different from the bank where the match is located; the payment has already been reconciled; or there are multi-currency issues within the system.

 

Because QuickBooks can not match mixed payment transactions, you must exclude them. Then, make receive payment for them. After that, reconcile them in QuickBooks Online.

 

I've included the following articles that will help you manage transactions in QuickBooks Online moving forward:

 

 

The Community is always here if you have further questions about matching your transactions in QuickBooks Online. Have a successful year with QuickBooks!

K
KR92
September 1, 2023

I don't think any of the responses here reach a conclusion for OP.

 

I have this same issue too. Basically the quickbooks payout acts as an account in itself. I think this is the solution... create a new "bank account" called Shopify. 

Have all of the transactions added to this account and then match your sales and refunds to these individual events. You can then classify the payout as a transfer.

 

Its just a shame that Quickbooks interface is so; look cool, operate like s**t. Making a new "bank" account is unreasonably difficult.

Terms & ConditionsAccessibility statement