jenuneekor
Level 4

How to Match Banking Transactions with Invoices and Refund Receipts

Good morning,

 

I see SO MANY questions about this in the QB community, but not one answer that seems to make sense to me so I'm hoping somebody could help.

 

We use Shopify for ecommerce and integrate with QB, so it generates invoices in QB from our Shopify orders. Then, each day, we get our payout from Shopify. I go into my banking and match the payout to the invoices.

 

The issue here is that our payout today includes both invoiced sales, a refund (created a refund receipt in QB), and Shopify fees. How do I match this payout from Shopify with the invoices and refund receipt?

 

Thank you - I would so appreciate a response with all of the steps because I have to imagine most merchants are dealing with this!

Solved