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 Monday

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 won'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 bank account on the payment isn't the same as the bank where the match is located.
  • The payment has been reconciled.
  • The record is already matched to another transaction.
  • There are multiple currencies involved, and the exchange rate has shifted significantly, making the amounts very different.

 

Feel free to read this article for more info: Match online bank transactions in QuickBooks Online.

 

After that, if you're unable to find the match, you have the option to Exclude the transactions instead of matching them. This will simply move the transactions out of the For Review tab, and won't impact your books.

 

On top of that, I recommend reaching out to your accountant to guide you on what's 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.