Skip to main content
June 12, 2023
Solved

Rule error (my mistake!)

  • June 12, 2023
  • 1 reply
  • 0 views

In attempting to set up my first rule I have mistakenly applied it and got the wrong outcome. 

 

I wanted to assign cash bankings from the bank link by a rule but have sent a bunch of transactions to Sales Income rather than Deposits, which I think would have permitted me to choose an account.

I can do a journal to switch accounts but that leaves the sales transactions in place.

I could delete the sales transactions and manually input the deposits to the right account but what effect would that have on bank reconciliation?

Is there anyway of rewinding things back to before applying the rule please?

 

Thanks

Dave

 

Best answer by Mr Tangerine Man

Thank you so much Jovychris_A

 

I'll give it a go and let you know how I get on

 

Dave

1 reply

June 12, 2023

Welcome to the Community, @Mr Tangerine Man.

 

Let me help you correct this to ensure the transactions look fine when returned to the For Review tab.

 

Yes, you can do a couple of journal entries to correct this. When sales transactions are deleted from QuickBooks, it will leave a discrepancy in your bank reconciliation.

 

So what we'll do, is to follow the happy path. I suggest deleting the incorrect bank rule and then undoing the transactions from the Categorized tab to ensure the bank feeds won't auto-confirm once you undo them.

 

Here's how:

  1. Go to the Bookkeeping menu and then select Rules under Manage.
  2. Find the rule in question.
  3. From the Actions column, click the drop-down arrow beside Edit.
  4. Select Delete.
  5. Hit Yes to confirm.

 

Once done, you can go to the Categorized tab to undo transactions. Let me show you how:

  1. From the Transactions window, select Categorized.
  2. Check the box beside the Date header or check multiple transaction boxes.
  3. Select Undo.
  4. Hit Continue.

 

The transactions have now returned in the For review tab. Then you'll want to set a new rule that will help auto-categorize your transactions. I'm adding this reference for more insights: Unmatch downloaded bank transactions.

 

Additionally, I like to share these articles to learn more about handling online transactions and how you can secure your books later:

 

 

Let me know if you need a helping hand. I'm always here to assist. Keep safe and more power to your business!

Mr Tangerine ManAuthorAnswer
June 12, 2023

Thank you so much Jovychris_A

 

I'll give it a go and let you know how I get on

 

Dave

June 13, 2023

Fantastic!!!

 

This worked perfectly....thank you!!!

 

Dave