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

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?

Re: if you download a CSV file and import it into QBO will it create duplicate transactions in your books or will it compare each of your entries with the downloaded file and not create an entry if there is a match between the downloaded file and your transactions.

If I import my bank CSV file for the week the unmatched transaction occurred, will QBO automatically rematch it?  Could it be that simple? 

Thank you for bringing this to our attention, @TXFlipo. I appreciate your engagement and would like to clarify the matching process in QuickBooks Online (QBO) for you.

To start, removing the reconciliation status (R) will not move the transaction back to the For review tab, nor will it trigger the system to search for new matches. For it to do so, the transaction needs to be Unmatch.

Moreover, when you import a CSV file into QBO, the system will compare each entry in the file with your existing transactions. If it finds a match, it will not create a duplicate entry in your records.

If you bring over your bank data to QBO for the week, QBO can automatically rematch those transactions as long as the import process is handled correctly. Just ensure that the Automatic matching feature is turned on.

For more details and information about matching transactions, please refer to these articles:

• Match online bank transactions in QuickBooks Online.
• Automatically match QuickBooks Online product transactions.

Moreover, reconcile your accounts in QBO to ensure they correspond to your bank statements.

You can always return here if you have further questions about matching transactions, and other QuickBooks-related concerns. We're here to help. Take care.

@TXFlipo 

You can also use MT Online or csv2qbo converter tool as a workaround.

https://quickbooks.intuit.com/learn-support/en-us/banking/which-banks-are-compatible-with-quickbooks...