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

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

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. 

almostthere
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)

It sounds like I can apply a rule retroactively, but do I have to then reconcile again?

AlexV
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)

Hi @almostthere!

 

You can apply the bank rule to past transactions. Let me assist you.

 

The bank rule is designed for the uncategorized or unaccepted transactions on the For Review tab. In order to apply it to the past entries, you'll need to undo or unmatch them so they'll be moved back to the For Review tab.

 

When you undo them, it can affect your accounts especially if they are reconciled. And yes, you'll need to reconcile them again once you add them back to your books.

 

If the purpose why you want the bank rule to apply to these transactions is to move them to a different account, I suggest you reach out to your accountant. They have an option to reclassify or move multiple transactions at once.

 

Lastly, you can check the reconciliation workflow through this article: Learn the reconcile workflow in QuickBooks. This will show you not only how to reconcile, but also how to fix reconciliation issues.

 

I'll be glad to assist you if you need more help with banking. Take care!

almostthere
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)

How do I rereconcile them?  I thought I would just go back to the beginning of the year and walk through each month, but it does not let me do that.  Can I change to "R" in the registry?

MariaSoledadG
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)

Let's make sure you'll be able to correct your transactions on the previous months, almostthere.

 

If you have reconciled a transaction by mistake, you can unreconcile them one at a time. You'll want to undo it manually by following the steps below:

  1. Go to the Accounting menu and select Chart of Accounts.
  2. Find the account and select View register
  3. Locate the transactions you want to unreconcile and select them to expand.
  4. Repeatedly click the box with the letter R until it's blank. Then, Save.

 

You can also check out this article for the detailed steps and if in case you encounter reconciliation errors: Undo Or Remove Transactions From Reconciliations In QuickBooks Online.

 

You can also invite an accountant to review your accounting and undo the reconciliation. Go through this article for your guide: Invite An Accountant To Review Your Accounting In QuickBooks Online.

 

Let me know if there's anything else you need about reconciliation. Don't forget, I'll be right here if you need help. 

Need to get in touch?

Contact us