Skip to main content
December 12, 2021
Question

Refund via Square; Matching Transactions in Quickbooks Online

  • December 12, 2021
  • 1 reply
  • 0 views

Hi there!

 

I run a short term rental cottage business with 3 cottages in total. My merchant is Square. On 12/02/2021, I accepted a virtual payment from a Customer A via Square for a total of $345.00 ($300.00 + $45.00 NS HST). On 12/03/2021, I had to issue Customer A a $172.50 ($150.00 + $22.50 NS HST) refund from my Square terminal. I thought the Square terminal would withdraw $172.50 from my bank account (this would have made matching the transaction in QuickBooks Online very easy). 

 

On 12/03/2021, I accepted a payment of $194.35 from Customer B. Instead of Square paying me out the full amount for Customer B, Square withdrew the refund amount for Customer A from Customer B's deposit. So, the deposit I received was for $22.56 (total for Customer B minus refund amount for Customer A minus merchant service charge for Customer A). 

 

I have no idea how to match these transactions in Quickbooks Online. I processed the refund for Customer A by issuing a refund receipt in Quickbooks Online but I am not entirely sure if this was the correct way to do it. If you have a closed invoice (paid in full), are you able to issue a refund receipt in Quickbooks Online? How am I supposed to match up these transactions in Quickbooks Online? 

 

Thank you.

1 reply

December 13, 2021

Hello as316018, 

 

Congrats on your first post in the Community! QuickBooks Online offers the versatility you need to manage your transactions with ease. It's essential you're able to match your transactions with ease and I'll be happy to assist you with that. 

 

When it comes to matching transactions in QB Online, I highly recommend referencing this helpful article that shows you how to: Categorize and match online bank transactions in QuickBooks Online. It's also essential to make sure you're recording the refunds the right way so you can match and categorize your transactions with ease. This article here shows how to record a refund in QuickBooks. Once you've recorded the refund, you can match it using the steps in the article above. 

 

You're more than welcome to ask other questions in the comments below. I'm here to help you reach your QuickBooks goals.