Question

Banking Rules not working for Bank feeds

Forum|Forum|6 years ago
March 28, 2020
5 replies
55 views

Good Morning,

- -this note is intended for QB Software Engineer Support--

Our company charges a flat monthly fee and many customers have allowed us to set up and ACH autopay. Which means each month our bank automatically withdraws from their bank and deposits into our bank.

I have set up Banking Rules for each client intending to match this ACH Collection to their open invoice. However, none of the rules have worked and QBO only returns a random client name for all of the ACH debits. Each month (billing cycle) I modify the conditions hoping to find a solution to no avail. I have called QB support and they have let me know many other people are having the same difficulty. My Banking Rules for utilities work just fine. Money out vs. Money in?

I have opened a case with QB in April 2019 Case # 53xxxx173. I have had no contact from QB and have tried calling back many times with zero progress.

I very much hope someone can respond to my case or let me know if this is being worked on. I am happy to provide full case number and examples of rules if you cannot access my account.

Thank you.

QuickBooks Online

A

Arrow98Author

Here is the data from the bank statement:

Date Description Type Amount

Mar 4, 2020 Online ACH Debit [removed] From Smith 1162 ( #####123) ACH Collection $25.00

KarenEdithL

QuickBooks Team

Hello there, @Arrow98.

I'd like to ensure that your concern get's addressed. While the Community can provide answers and troubleshooting solutions to certain questions, there are things that only our phone support can do to resolve the problem.

Since your bank rule is still not working, I highly recommend giving our Customer Care Team a call again. They'll be able to do further investigation about this behavior and can open a investigation ticket if necessary.

To give you more details about Bank Rules, please check out this link: Bank Rules in QBO.

Let me know if you have any other questions. I'll be around to help. Take care.

S

SabrinaS91

Have you had any success with this? My bank rules haven't been working for a few weeks now. I have been back and forth with support, them prematurely closing my cases because they can't solve the issue. I have followed all instructions by support from deleting the rules and re-adding, changing the bank accounts to all bank accounts, changing the conditions from all to any, selecting and de-selecting auto-add, clearing my cache, the list goes on. They are rules that have worked in the past (since I started 12 months ago) but all of a sudden have stopped working. It's happening across all my files with all different banking institutions. If I create new rules with different conditions, they seem to work okay. But I can't for the life of me work out why the rest won't work.

D

DKC

Wow, my first attempt to post went haywire and didn't post. Let's see if this will work...

I'm using QBO, several different subscription levels. I've having the same issues on multiple clients and different banking institutions. It has been particularly problematic for the last couple of weeks and seems to be on the increase! What's up?? I don't not think this is a specific client/institution/subscription level problem!?

I was glad to see comments here and frustrated to read the frustrated unresolved descriptions of the same problems I'm experiencing. I don't want to reach out to support and spend time as described herein without much results. As others have described, previously working rules are not long working. There must be a universal solution to the problems we're experiencing (when it is discovered by support) that can be posted here or an update/fix to QBO that can improve things?

J

Jason_Grant

The problem is the presence of special characters such as colon ":" and probably other stuff...

When you setup the content that you want, try to encircle it with comas ""

Ex :

You want to search for : John Doe in Payment N°XXX : Mr John Doe - 22/07/21

Don't search for : John Doe

Search for : "John Doe"

It worked for me

No it's as simple as misreading special characters. There are key words in the bank description or narrative that QBO is leaving out and is blind to. For example, if the bank description is

"Johns repairs Dec inv"

I'm finding that QBO will have in the description in the rule just "Dec inv". What happened to "Johns repairs" I have no idea.

I can't then simply add "Johns repairs" to the rule (and actually remove "Dec inv" which is the part I don't want), because QBO CANNOT EVEN SEE "Johns repairs".

Am I am going insane or is this case of the Emperors Clothes and the vast majority of users just assume that QBO can't create bank rules???

K

Kirkk

Possible fix

I use Chrome, all I did was clear my History/ Cache. This worked for me, I hope for some of you as well.

In Chrome, Hit the ellipse's (...) History > History > Clear Browsing Data

WARNING - Only do the Basic, Stay away form the Advanced tab, or you may lose stored passwords and such.

Good Luck.

C

cmoran1366

You might want to see if the case is still open. Jean Paul just closed my case without solving problem. If I was you, I would check to see if the case is still open and being worked on. The QB support is not much help, and if they tell you that someone is gonna call you, don’t hold your breath waiting… Good Luck

P

pstahl27

Hi,

I have had the same issue with the rules not working when they have worked for 7 years for my one business. Now none of the rules work except for when a fee from the bank comes across - so I looked at the rules again and noticed this new one at the top which I have the checkmark next to. With this rule in place it would seem it would override all the other rules - so I tried to delete it and the option to delete it is greyed out in both the drop down on the line with the rule and in the Actions menu. I do not want this rule and I think this is causing the issue. Please help as I have a lot of data that will take hours that I wasn't planning on. THank you!

DivinaMercy_N

Moderator

I want to ensure you can seamlessly work with your QuickBooks Desktop (QBDT) tasks, @pstahl27.

In QBDT, the Never Automatically Create Rules is a default rule that can't be deleted or modified. To isolate the issue, you can disable the auto-check status through the Preferences menu. I'm here to guide you how:

Navigate to the Edit menu and choose Preferences.
Click Checking from the left panel, and go to the Company Preferences.
In the Bank Feeds section, uncheck the options for Create rules automatically and Always ask before creating a rule.
Select OK.

I've also added this article for your reference in managing banking rules: Use renaming rules for Bank Feeds. This also provides fixes from common issues you may encounter with bank rules.

You'll also want to reconcile your bank transactions to make sure they are accounted for correctly and ensure your books are accurate.

Click the Reply button if you need more help with deleting bank rules or any banking concerns. Take care and have a productive day.

Sign up

Login with SSO

Let's get you signed in

Login with SSO