Skip to main content

SUMMER SAVINGS 90% OFF QuickBooks for 3 months* Ends 8/27

Buy now
Switch to QuickBooks and 70% off for 3 Months
November 10, 2018
Question

How do I match a sales receipt and a refund receipt to one quickbooks banking transaction?

  • November 10, 2018
  • 22 replies
  • 41 views
I use Shopify which records daily payouts which include both sales and refunds in the same transaction. Then I use Webgility which manually creates sales receipts and refunds receipts in Quickbooks. I am unable to match banking transactions (shopify payouts) that include both sales receipts and refund receipts. How do I do this?

22 replies

Regina_Lend_A_Hand_Accounting
Level 2
November 11, 2018

The key is to recreate what actually happened, in the order it happened, then you will have a match within your bank feed. Drill down into your sales and refund receipts in question and change the "Refund From" and "Deposit To" accounts to "Undeposited Funds". Then go to "Bank Deposits" and select only the transactions that total the amount that hit your bank account that you need to match. Make the deposit on the same day the deposit went into your bank feed, then you will have a match to add the transactions that make up the deposit for that day.

January 22, 2020

Hi I am also trying to match a receipt and refund. I have changed to undeposited funds but i dont see the 'bank deposits' bit you mention?

Tori B
QuickBooks Team
January 22, 2020

Hey there, @allyson3.

 

Welcome to Community. Glad to have you here.

 

Let's drill down where bank deposits are located:

 

  1. Click the + New icon at the top of the screen.
  2. Under the Other column choose Bank deposit.

 

For more details about matching receipts and recording bank deposits, you can check out these articles:

 

If you have further questions or concerns, feel free to reach back out anytime. I'm always happy to lend a helping hand. Take care and have a great day ahead!