Matching bank transactions older than 180 days

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!

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”. 

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 to assist you in 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 your transactions or concerns related to QuickBooks Online. I’m here to help. Stay safe.

Hello JoesemM, 

In your list of reasons why a match may not be found, the only one which might apply is the "Verify that the transaction has not been reconciled".  In my QBO bank register the transaction IS marked with an "R" so it has been reconciled.  I know you can manually remove the "R" from the bank transaction.  If I remove the 'R" do you think that will allow QBO to find the match?