Auto Rules and Auto Adding Intuit Transactions when they keep changing numbers in bank memo

4 replies
31 views

I have an issue where I have a large account that uses QuickBooks Merchants and Payroll. I used to be able to auto add Money in as Income and Noney out as transaction fees. The client has since added payroll so now my auto add doesn’t work anymore and I have to manually go through hundreds of transactions a month to separate because the auto rule will not pick up on the bank memo because it has a generated random number in between intuit and targeted purpose such as tran fee, tax or payroll. To explain better, auto rule will not add in a transaction unless information is consecutive.

Any suggestions on how to auto add these from the bank feed if intuit is putting a random number in between?

QuickBooks Online

JoesemM

QuickBooks Team

Let's edit each of your existing bank rules, change the condition from Is Exactly to Contains, and use only the consistent part of the description as your keyword, such as TRAN FEE for transaction fees and PAYROLL for payroll transactions. The Contains condition only needs to find that keyword anywhere in the description, so the random number in the middle won't matter anymore.

Just keep in mind that if you want your fees, payroll, and deposits going to different accounts, you'll want a separate rule for each using the more specific keyword so they route correctly. Also, you can put a check mark on Show bank details on the Bank Transactions page to see the raw bank text alongside the description, compare that to the condition text in your rule, and adjust it so it matches the field you actually need.

Here's how:

Go to All apps, then Accounting, then Bank transactions.
Click the Gear ⚙ within the Bank transactions section.
Select Show bank details.

Click the Reply button if you need more help with anything else. We're here to help.

K

KimAnnVAAuthor

New Member

Unfortunately this only helps with some payroll but I still have to keep an eye on account to make sure everything that goes in there is for wages. I can’t auto add in tax because that is too broad a term and we pay taxes on everything from Gov, to IRS to Compliance, etc. so I can’t mark everything payroll tax, it would create a mess to separate even with the reclassify tool.

I don’t even know what you were suggesting to use the word “intuit” for as it could be anything including a QuickBooks subscription or financing.

Have you used this product before? I really don’t like it when QuickBooks team members who don’t use the product comment. I’m looking for real help and based on your suggestions, you don’t use the product so you don’t realize this doesn’t help much.

Because we use payroll, merchant services, software fees, financing, we have about 200 or more transactions a month that have the word “intuit”. This is a crazy suggestion.

It’s a shame QuickBooks doesn’t have the option of choosing more than one keywords since they insist on putting a random number in blocking me from auto adding.

Sign up

Login with SSO

Let's get you signed in

Login with SSO