cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Get your Payroll questions answered by a QuickBooks Product Manager here - https://intuit.me/31Nl3My
karen81
Level 2

How do i remove a partially matched transaction from a previous financial year that has suddenly appeared in the banking review window.

 
Solved
Best answer December 18, 2020

Accepted Solutions
RaymondJayO
Moderator

How do i remove a partially matched transaction from a previous financial year that has suddenly appeared in the banking review window.

I'm here to ensure you're able to remove the partially matched transaction in the Banking page, @karen81

 

The bank may have a limited period in downloading the transactions using a CSV file from their website. That's why they won't allow you to download the file within that date range.

 

To help fix this, I'd suggest creating a journal entry to remove the partially matched transaction since you're unable to exclude it. With this, I recommend consulting your accountant. They can determine the appropriate account types you'll need to use when recording the entry. Also, they can help ensure your books from the previous and current financial years are intact and accurate. 

 

Aside from that transaction, you can edit and categorise the other ones. Just go back to the For Review tab to complete this task. This way, your financial records are correct before you reconcile the account. To learn more about this process, visit this article: Categorising Bank Transactions

 

Please know that I'm here anytime if you have other concerns. Keep safe always. Stay healthy, @karen81

View solution in original post

2BTrusted
Level 2

How do i remove a partially matched transaction from a previous financial year that has suddenly appeared in the banking review window.

In banking click on the "categorized" tab to see which transactions the deposit is partially matched to. Once that is identified you can unmatch those and start over. 

View solution in original post

Angelyn_T
QuickBooks Team

How do i remove a partially matched transaction from a previous financial year that has suddenly appeared in the banking review window.

Thank you for sharing the result of the steps you've performed here in this thread, @KimberlyMolder.

 

In your case, you need to exclude/delete and reimport the transaction to isolate the issue. I'm here to guide you with the detailed process.

 

To delete the transaction:

 

  1. Click on Banking at the left pane, then select Banking.
  2. Choose your bank account, then locate and select the transaction under the Categorised section.
  3. Choose Undo.
  4. Switch the tab under For review, then pick the same transaction.
  5. Tap Exclude.

Then, you can check out this article for the detailed instructions about manually uploading transaction into QuickBooks Online.

 

Once done, here's how you can add, match, and categorise the imported data.

 

Keep me posted with the result. I want to make sure this is resolved. Thanks for coming to the Community, I'll be looking forward to hearing from you again.

View solution in original post

10 REPLIES 10
Ashleigh1
QuickBooks Team

How do i remove a partially matched transaction from a previous financial year that has suddenly appeared in the banking review window.

Hello Karen81, 

 

Welcome to the Community page, 

 

You can just exclude the transaction if it has reappeared in the banking page, tick the little box, batch actions will highlight>click batch action > exclude 

karen81
Level 2

How do i remove a partially matched transaction from a previous financial year that has suddenly appeared in the banking review window.

I am unable to exclude the transaction as it is partially matched.

ShiellaGraceA
QuickBooks Team

How do i remove a partially matched transaction from a previous financial year that has suddenly appeared in the banking review window.

Hello @karen81,

 

You'll want to re-download the transaction excluding the date of the transaction in question. Let me guide you how.

 

  1. Pick a date range. Then, download transactions from your bank.
  2. Review the file format and start uploading.
  3. Upload your file and then categorize your transaction.

Please refer to this article for the detailed steps: Manually upload transactions into QuickBooks Online.

 

Once done, check your review section again. I've added our page about banking in case you need some related articles.

 

Stay in touch if you have other questions. The Community is always here for you. Cheers!

karen81
Level 2

How do i remove a partially matched transaction from a previous financial year that has suddenly appeared in the banking review window.

My bank will not allow me to go back to the date required to download the csv file

RaymondJayO
Moderator

How do i remove a partially matched transaction from a previous financial year that has suddenly appeared in the banking review window.

I'm here to ensure you're able to remove the partially matched transaction in the Banking page, @karen81

 

The bank may have a limited period in downloading the transactions using a CSV file from their website. That's why they won't allow you to download the file within that date range.

 

To help fix this, I'd suggest creating a journal entry to remove the partially matched transaction since you're unable to exclude it. With this, I recommend consulting your accountant. They can determine the appropriate account types you'll need to use when recording the entry. Also, they can help ensure your books from the previous and current financial years are intact and accurate. 

 

Aside from that transaction, you can edit and categorise the other ones. Just go back to the For Review tab to complete this task. This way, your financial records are correct before you reconcile the account. To learn more about this process, visit this article: Categorising Bank Transactions

 

Please know that I'm here anytime if you have other concerns. Keep safe always. Stay healthy, @karen81

View solution in original post

2BTrusted
Level 2

How do i remove a partially matched transaction from a previous financial year that has suddenly appeared in the banking review window.

In banking click on the "categorized" tab to see which transactions the deposit is partially matched to. Once that is identified you can unmatch those and start over. 

View solution in original post

1816Farmhouse
Level 1

How do i remove a partially matched transaction from a previous financial year that has suddenly appeared in the banking review window.

I agree with 2BTrusted's answer..."In banking click on the "categorized" tab to see which transactions the deposit is partially matched to. Once that is identified you can unmatch those and start over." except that I had to add one additional step to completely fix the issue. Until I took that additional step the partially matched transactions kept reappearing in the For Review tab even after I'd added them. 

 

Additional step was: After unmatching on the Categorized tab, I was able to go back to the For Review tab and exclude those transactions. Then I had to reimport the transactions from my back uploading from a csv file. Once the transactions were again visible in the For Review tab, I could add them. Only then did they stop reappearing on the For Review tab. 

KimberlyMolder
Level 1

How do i remove a partially matched transaction from a previous financial year that has suddenly appeared in the banking review window.

Mine says it is partially matched but when I click on the Catagorize, nothing is checked to uncheck.

Angelyn_T
QuickBooks Team

How do i remove a partially matched transaction from a previous financial year that has suddenly appeared in the banking review window.

Thank you for sharing the result of the steps you've performed here in this thread, @KimberlyMolder.

 

In your case, you need to exclude/delete and reimport the transaction to isolate the issue. I'm here to guide you with the detailed process.

 

To delete the transaction:

 

  1. Click on Banking at the left pane, then select Banking.
  2. Choose your bank account, then locate and select the transaction under the Categorised section.
  3. Choose Undo.
  4. Switch the tab under For review, then pick the same transaction.
  5. Tap Exclude.

Then, you can check out this article for the detailed instructions about manually uploading transaction into QuickBooks Online.

 

Once done, here's how you can add, match, and categorise the imported data.

 

Keep me posted with the result. I want to make sure this is resolved. Thanks for coming to the Community, I'll be looking forward to hearing from you again.

View solution in original post

daveda1plummer
Level 1

How do i remove a partially matched transaction from a previous financial year that has suddenly appeared in the banking review window.

This worked for me!  Thank you!