cancel
Showing results for 
Search instead for 
Did you mean: 
kany tc
Level 1

find matching on banking for transaction of mix sales and refund

My company has a transaction deposited from Woo Commerce, and the amount is included sales and couple refunds. I added refunds by using new tap, and sales. However, when i match transactions, I only see sales receipt not "refunds". How do i have to record it? 

 

Can i use any other option by using "resolve" function or do i have to not use matching transactions for this case?

3 Comments 3
MirriamM
Moderator

find matching on banking for transaction of mix sales and refund

Let me get the help you need in matching your transactions, kany tc.

 

When matching your downloaded transaction and the data manually entered in QuickBooks, let's ensure that the bank account selected on the refund receipt is the same bank account where the transaction downloads. To verify, open the transaction once more and check the bank details.

 

Once everything is verified, try to match transactions again. You can see this article for guidance: Categorize and match online bank transactions in QuickBooks Online. After that, you have the option to do your regular bank reconciliation

 

If you have additional assistance while managing your bank transactions, let me know. I'll be around to provide further assistance. Have a nice day.

kany tc
Level 1

find matching on banking for transaction of mix sales and refund

Thank you for the answer. 

I double checked the bank account, and I put correct bank account for the refund.

The problem that i have is that the transaction is combination of sale and refund. Is the reason why i cannot find the refund receipt under matching for banking? 

 

I read articles that you posted as well, but my question was not solved yet. 

MaryLurleenM
Moderator

find matching on banking for transaction of mix sales and refund

Yes, you're unable to match both the refund and sales transaction,  kany tc.

 

Here's what you can do instead, you can add the refund amount as a negative line item when depositing the payments in QuickBooks Online (QBO). This way, you'll be able to match the deposited transactions to the downloaded ones.

 

  1. In QBO, go to the + New option at the top left to get to the Bank Deposit.
  2. In the Account drop-down, pick the bank where you want it to be deposited.
  3. Place a checkmark on the payments in the Select the payments included in this deposit section.
  4. In the Add funds to this deposit section, select the customer's name in the Received From field.
  5. For the Account, choose an sales/income account, then enter the amount as negative.
  6. Once done, hit Save and close

For more information, consider checking out this article: Record and make Bank Deposits in QuickBooks Online.

 

After that, you can now proceed with matching the transactions. Please refer to this article for further guidance: Categorize and match online bank transactions in QuickBooks Online.

 

If you have additional questions, don't hesitate to leave a reply.

Need to get in touch?

Contact us