cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Everything you need to know about banking in QuickBooks Online - Discover more
JamesWoodcock
Level 1

Matching a supplier expense and refund in Banking transactions

Within banking transactions I have a hotel expense item for £100 and I also have a refund for £100 from the hotel. I want to clear these transactions. How do I do this?

Solved
Best answer July 02, 2021

Accepted Solutions
ReymondO
Moderator

Matching a supplier expense and refund in Banking transactions

Hey there, @JamesWoodcock.

 

 

If you have recorded the expense and refund from the hotel, you can simply match them to the downloaded transactions from your bank. The original expense you made will be there to match and the bank deposit you created as part of the supplier refund process will match to the amount refunded.

 

  1. Go to the Transactions menu and select Banking.
  2. Click the name of the bank, then find the downloaded transaction with the Match or View option. Please take note that ​View means QuickBooks found more than one potential match.
  3. Review the Matching records found in QuickBooks. This is the possible matching transaction you already entered in QuickBooks.
  4. Select the link next to each match to get more details.
  5. Make sure this is the correct match. In particular, review the Deposit toPayment method, and Bank account fields on forms for the existing transaction in QuickBooks.
  6. If this is the correct match, close the open transaction.
  7. Click ​Match​.

 

If you haven't created these transactions inside QuickBooks, then you can click the Add option instead. This way, the program will use this info to create and add a new transaction to your account.

 

For more details, you can also check out this article: Categorise and match online bank transactions in QuickBooks Online.

 

After categorising your accounts, you can now do your monthly reconciliations.

 

Don't hesitate to tag my name in the comment section below if you have other concerns or questions. I'm always ready to help.

View solution in original post

1 REPLY 1
ReymondO
Moderator

Matching a supplier expense and refund in Banking transactions

Hey there, @JamesWoodcock.

 

 

If you have recorded the expense and refund from the hotel, you can simply match them to the downloaded transactions from your bank. The original expense you made will be there to match and the bank deposit you created as part of the supplier refund process will match to the amount refunded.

 

  1. Go to the Transactions menu and select Banking.
  2. Click the name of the bank, then find the downloaded transaction with the Match or View option. Please take note that ​View means QuickBooks found more than one potential match.
  3. Review the Matching records found in QuickBooks. This is the possible matching transaction you already entered in QuickBooks.
  4. Select the link next to each match to get more details.
  5. Make sure this is the correct match. In particular, review the Deposit toPayment method, and Bank account fields on forms for the existing transaction in QuickBooks.
  6. If this is the correct match, close the open transaction.
  7. Click ​Match​.

 

If you haven't created these transactions inside QuickBooks, then you can click the Add option instead. This way, the program will use this info to create and add a new transaction to your account.

 

For more details, you can also check out this article: Categorise and match online bank transactions in QuickBooks Online.

 

After categorising your accounts, you can now do your monthly reconciliations.

 

Don't hesitate to tag my name in the comment section below if you have other concerns or questions. I'm always ready to help.

Need to get in touch?

Contact us