cancel
Showing results for 
Search instead for 
Did you mean: 
jfakenney
Level 2

I have created rules in QB Online and I need to apply them to transactions from last year. How can I apply rules retroactively. (just re categorizing)

 
Solved
Best answer January 14, 2020

Best Answers
Emily M
QuickBooks Team

I have created rules in QB Online and I need to apply them to transactions from last year. How can I apply rules retroactively. (just re categorizing)

Thanks for getting back in touch, @jfakenney.

 

I’m happy to further assist you with moving transactions back to the For Review tab. You can undo an added bank transaction. If you want to get rid of an added transaction entirely and start from scratch, you can Undo it.

 

Let me guide you how:

  1. Go to Banking.
  2. Select the blue tile for the account you want to review.
  3. Pick the Reviewed tab.
  4. Find the transaction you want to undo.
  5. Choose Undo from the Action column. This removes the added record from your accounts in QuickBooks.
  6. Go back to the For Review tab. Edit and categorize the transaction the way you want to.

To batch action those transactions, you’ll put a Check Mark in the box beside each transaction and then click on Batch Actions and choose to Modify Selected.

 

Here’s a helpful article about moving and reviewing bank transactions:

https://quickbooks.intuit.com/learn-support/global/banking/unmatch-or-move-bank-transactions-after-r...

 

Hit the reply if you have other questions.

View solution in original post

8 Comments 8
Anna S
QuickBooks Team

I have created rules in QB Online and I need to apply them to transactions from last year. How can I apply rules retroactively. (just re categorizing)

Good afternoon, @jfakenney.

 

Nice to have you here in the Community. I'm happy to provide insight into banking rules for you.

 

QuickBooks Online offers banking rules to categorize transactions in the Banking tab accurately. These rules apply to unaccepted transactions (transactions on the For Review tab of the Banking screen) ONLY. Meaning the categorizing only applies to transactions that are currently coming in from your bank that need to be accepted. This article on Using Banking Rules outlines how the rules work.

 

Should you need any further information, please do not hesitate to contact me. Wishing you continued success now and in the future.

jfakenney
Level 2

I have created rules in QB Online and I need to apply them to transactions from last year. How can I apply rules retroactively. (just re categorizing)

Thank you!  Is there a way to move those transactions back to For Review so the rules will apply?  

Bascially I've got hundreds and hundreds of transactions I have to go in and change the account for manually if I can't use the rule.  Is there any way to batch update a list of transactions, etc or do they all have to be updated one at a time?

Emily M
QuickBooks Team

I have created rules in QB Online and I need to apply them to transactions from last year. How can I apply rules retroactively. (just re categorizing)

Thanks for getting back in touch, @jfakenney.

 

I’m happy to further assist you with moving transactions back to the For Review tab. You can undo an added bank transaction. If you want to get rid of an added transaction entirely and start from scratch, you can Undo it.

 

Let me guide you how:

  1. Go to Banking.
  2. Select the blue tile for the account you want to review.
  3. Pick the Reviewed tab.
  4. Find the transaction you want to undo.
  5. Choose Undo from the Action column. This removes the added record from your accounts in QuickBooks.
  6. Go back to the For Review tab. Edit and categorize the transaction the way you want to.

To batch action those transactions, you’ll put a Check Mark in the box beside each transaction and then click on Batch Actions and choose to Modify Selected.

 

Here’s a helpful article about moving and reviewing bank transactions:

https://quickbooks.intuit.com/learn-support/global/banking/unmatch-or-move-bank-transactions-after-r...

 

Hit the reply if you have other questions.

View solution in original post

jfakenney
Level 2

I have created rules in QB Online and I need to apply them to transactions from last year. How can I apply rules retroactively. (just re categorizing)

Thank you SO MUCH!  You saved me more than a full day of work, no exaggeration!

That worked perfectly.  I tried with 5 transactions and the only thing that happened was that I had to re-reconcile my bank account, which took no time at all!  It was already balanced so easy peasy!

 

Thanks again, life saver! - Jennifer

Doug E Fresh
Level 2

I have created rules in QB Online and I need to apply them to transactions from last year. How can I apply rules retroactively. (just re categorizing)

Once you undo, does the rule apply?

SarahannC
Moderator

I have created rules in QB Online and I need to apply them to transactions from last year. How can I apply rules retroactively. (just re categorizing)

Hello there, Doug E Fresh.

 

Yes. The rule will still be applied after undoing some transactions. It helps accounts to be balanced and accurate. Let me also share with you a few reasons why sometimes we unreconcile transactions. 

 

Here are the possible reasons for doing it:

  • When transactions are reconciled but not part of your bank's statement.
  • It's matched to the wrong downloaded transaction in your book.
  • Getting an unexpected error and needed to delete them out.

 

In case you still have a problem with your reconciliation, or you may have adjusted a past reconciliation. It's best to consult your accountant to help and guide you further with this. I've attached some articles below wherein we can get additional information about reconciling accounts.

 

 

Comment below if you have more something to ask about reconciliation in QuickBooks Online. We are all right here to help. Take care!

David A P
Level 1

I have created rules in QB Online and I need to apply them to transactions from last year. How can I apply rules retroactively. (just re categorizing)

I have the same issue. But where is the "Reviewed" tab mentioned in step 3? I am on the banking page with the desired account selected but there is no "reviewed" tab to select. I've clicked on everything.

MarsStephanieL
QuickBooks Team

I have created rules in QB Online and I need to apply them to transactions from last year. How can I apply rules retroactively. (just re categorizing)

Hello there, @David A P.

 

The QuickBooks Developers does product enhancements when there are new features or things that need to be changed. The Reviewed tab was included in the recent update and was changed to Categorized.

 

This is how it looks like now:

 

 

I've added this article to help you with the process of unmatching the bank transactions: Unmatch downloaded bank transactions or move them to another account.

 

You may also read through this article when you're ready to assess your business financials: Learn the reconcile workflow in QuickBooks. this contains tips and a complete process of reconciliation. 

 

You're always welcome to come back if you need further assistance. I'm here ready to back you up. 

Need to get in touch?

Contact us
Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up