Skip to main content
T
TXFlipo
November 4, 2024
Question

Matching bank transactions older than 180 days

  • November 4, 2024
  • 1 reply
  • 0 views

In my bank register, I 'unmatched" a received payment transaction. The transaction is older than 180 days. QBO will NOT re-match the transaction. Now the transaction shows up as needing to be "reviewed" and I have the option to "add" the transaction. I know the transaction is entered and exists in my QBO entries so I can't add it. I have searched the community for solutions and none of them have worked. It appears I may have to use the "exclude" function to keep the transaction from showing up as an unmatched transaction. It was mentioned to use the exclude option with caution so I am nervous about going that route.  I would prefer to have the ability to manually "match" the transaction just the same as you can manually 'reconcile' a transaction. How do I "re-match" the transaction so it doesn't show up as having to be reviewed? Hope this made sense. 

1 reply

K
Kevin_C
November 4, 2024

You can use the find other matches option from the bank feeds, @TXFlipo. Let me walk you through the process below.

 

Since this transaction was previously matched to a recorded entry, I assume it was posted to the correct bank account and is not matched to another transaction. If that is the case, you can follow these steps to match your bank transaction for that specific entry:

 

  1. Go to the Transactions menu and select the Bank transactions tab.
  2. Pick your bank account tile and go to the For review tab.
  3. Select the transaction and click the Match radio button.
  4. Filter the dates or transactions as needed.
  5. Enable the Suggested matches toggle to see the closest possible match. Turn it off if you cannot find the transaction you're looking for.
  6. Choose Match to complete the process.

 

Refer to this article for more details about the process: Match online bank transactions in QuickBooks Online.

 

Additionally, you may want to explore this insightful article to deepen your understanding of effectively managing your income and expenses, as well as identifying potential discrepancies: Learn the reconcile workflow in QuickBooks.

 

If you have any additional questions regarding matching your bank transactions in QBO, please don’t hesitate to reply to this thread. We are committed to ensuring that everything is taken care of for you. Have a great day!

T
TXFlipoAuthor
November 19, 2024

Kevin_C,

Thanks so much for you reply and assistance with this matter. However, your instructions and screen shots did not exactly match my version of QBO.  Steps 1 – 3 were fine. My screen matches what you show for step 3.  However, at step 4, my screen is totally different from the one you provided above.  I do NOT have a “Suggested Matches” button. This is what my screen looks like after I select the “Match” button:

 

 

 

As you can see, no match was found. The dates shown in the above cover the period of the $1738.50 transaction (11/17/2023) but as you can see there is no match. It’s as if QBO is not looking back that far in the transaction history.  I have seen multiple mentions if the transaction is older than 180 days, QBO will not find the match.  Why is it I can manually mark or unmark a transaction as being reconciled but I can’t do the same with an onIine banking match.  I need to get this re-matched so the transaction does not show up as having to be “reviewed”. 

 

 

JoesemM
JoesemM
November 19, 2024

Thank you for the updates, TXFlipo. Even if a transaction is older than 180 days, you can still match them. However, you’ll need to manually locate them in your transactions. Allow me to provide additional details and assist you with the matching process.

 

Given that the dates and amounts match the specified period, there are a few reasons why we can’t find their match in your existing records:

 

  • The bank account isn't the same as the bank where the match is located.
  • Verify that the transaction has not been reconciled.
  • If it is a deposit or payment received, ensure it is not on the Bank Deposit page (undeposited).
  • The system will look for transaction(s) that fall within a 10% range of the bank transaction dollar amount when trying to match foreign currencies.
  • There are multiple currencies involved, and the exchange rate has shifted significantly, making the amounts very different.

 

If you're still unable to find a match, you can choose to Exclude the transaction. This will remove from the For Review tab without affecting your books. When you exclude, it doesn’t appear in any account registers or financial reports. 

 

Here's how:

 

  1. Go to Transactions, then select Bank transactions.
  2. Select the For Review tab.
  3. Click the checkbox of the transactions to exclude.
  4. Select Exclude.

The transaction moves to the Excluded tab of the Banking page. For more details, open this link: Exclude a bank transaction you downloaded into QuickBooks Online.

 

Once done, you'll want to reconcile your bank account. Reconciling gives you insight into your business and QuickBooks process as easy as possible.

 

Feel free to click the Reply button if you have other questions about matching transactions or concerns related to QuickBooks Online. I’m here to help you further. Stay safe.

Terms & ConditionsAccessibility statement