Skip to main content
T
TUSSU
August 9, 2024
Solved

Match not working

  • August 9, 2024
  • 1 reply
  • 0 views

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

Best answer by TUSSU

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.


Thank you for your reply, it worked perfectly

Best regards,

Noel

1 reply

Bryan_M
Bryan_M
August 9, 2024

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 info: Match 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.

T
TUSSUAuthor
August 9, 2024

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

A
AbegailS_
August 9, 2024

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.

Terms & ConditionsAccessibility statement