cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
NEW Connect to DBS IDEAL direct bank feeds Click here
TUSSU
Level 5

Match not working

Hi, 

An employee was overpaid and has refunded the overpayment to our back, I have created a journal debiting the payment and crediting the bank. when I go back to the bank and click on match, the match screen opens up and it has detected the overpayment under "Find other matches" but the overpayment is not listed under select transactions to match, what am I doing wrong?

Best regards,

Noel

Solved
Best answer August 12, 2024

Best Answers
TUSSU
Level 5

Match not working

Thank you for your reply, it worked perfectly

Best regards,

Noel

View solution in original post

5 Comments 5
Bryan_M
QuickBooks Team

Match not working

Thanks for posting here, @TUSSU.

 

Let's ensure you can match your created journal entry transactions in QuickBooks Online (QBO). 

 

There are various reasons why transactions don't show when you click the Find match button. Feel free to read the list below:

 

  • The amounts or dates don’t match.
  • The transaction is older than 6 months.
  • The payment's bank account isn't the same as the bank where the match is located.
  • The payment has been reconciled.
  • The record is matched to another transaction.
  • Multiple currencies are involved, and the exchange rate has shifted significantly, making the amounts very different.

 

Feel free to read this article for more infoMatch online bank transactions in QuickBooks Online.

 

Also, you can specify the Journal entries (JE) transactions in the matching section by clicking the Filter by dropdown and selecting it.

 

If the issue persists, you can Exclude the transactions instead of matching them to move them out in the For Review tab and ensure that it won't affect your books.

 

Since you created the JE in QuickBooks, you can clear the corresponding JE in your register manually to reconcile the overpayment refund.

 

Moreover, I recommend contacting your accountant to guide you on the best action to take to avoid book inconsistencies. 

 

If you want to categorise your bank transactions automatically, you can read this article: Set up bank rules to categorise online banking transactions in QuickBooks Online.

 

For additional questions about matching your transactions in QBO, leave a reply below. We'll be happy to help. Take care, and have a good one.

TUSSU
Level 5

Match not working

Hi,

thank you for your quick response, none of the items in your reply apply to this transaction. I have read the documents at the links in your reply and I cannot find a solution there either

Best regards,

Noel

AbegailS_
QuickBooks Team

Match not working

Thanks for getting back to us, @TUSSU. I'm here to help you match the overpayment refund. 

 

To ensure that the overpayment journal entry is properly matched with the bank transaction, please follow these steps:

 

After clicking on Match and the screen opens up, make sure to select Journal entries under the filter by  option to specifically look for the journal entry related to the overpayment refund. Additionally, verify that the date range selected includes the date of the journal entry to capture it in the matching process.

 

If the overpayment is still not listed under Select transactions to match you can exclude the transaction from the match. Since you have recorded the journal entry in QuickBooks, you can manually clear the corresponding journal entry in your register to reconcile the overpayment refund.

 

Moreover, here's an article I'd like to share to help you automatically categorize transactions from your bank: Set up bank rules to categorize online banking transactions in QuickBooks Online.

 

When you're all set, you can start reconciling your accounts. This way, you can ensure they're all accounted for correctly.

 

Let me know in the comment section if you need more banking tips. I'm still here ready to help you.

TUSSU
Level 5

Match not working

Thank you for your reply, it worked perfectly

Best regards,

Noel

Ethel_A
QuickBooks Team

Match not working

I'm glad to know that the resolution provided by my colleague was able to help you resolve the issue you had with matching bank transactions, Noel.

 

For future reference, you can read this article to help you reconcile your accounts in QuickBooks Online: Reconcile an account in QuickBooks Online.

 

Don't hesitate to click the Reply button below if you have other concerns with matching bank transactions in QuickBooks Online. The Community is always here to help. Have a great day.