cancel
Showing results for 
Search instead for 
Did you mean: 
kzwin
Level 1

banking rule

i have online qb and a rule that i want to match for the following transaction description

 

"ORIG CO NAME:WATER EPAYS REOC ORIG ID:99999 DESC DATE: CO ENTRY DESCR:DWU WEB SEC:WEB TRACE#:222222 EED:11111 IND ID:000100777888"

 

I tried a "contains" rule with text "ID:000100777888" or with text ("ID:XXXXXXX7888" <= the exact text that qb shows me not the original bank desc as well with just "7888".  All three tests do not work.  Any idea what I am doing wrong.

Solved
Best answer August 05, 2023

Best Answers
Rea_M
Moderator

banking rule

Hello, kzwin. 

 

From your description, I can tell you're already on the right track in setting up bank rules in QuickBooks Online (QBO). You'll first have to make sure QuickBooks shows bank text instead of description so the system can decide where exactly to apply the rule. Let's go to the Banking menu's For review tab to do so. I'll gladly show you how.

 

By default, QuickBooks shows the description in your list of transactions. When you set up a rule based on bank text, you'll first have to apply it in the Banking page. Here's how:

 

  1. Go to Bookkeeping, then Transactions, then select Bank transactions (Take me there).
  2. Above the table, go to Settings ⚙.
  3. Select Show bank details80.PNG

 

Once you're done, go back to the Create rule window to complete your bank rule set up. You can refer to the screenshot below or check out this article for the complete guide: Set up bank rules to categorize online banking transactions in QuickBooks Online.

 

 

Additionally, I encourage you to reconcile your accounts regularly (every month). This helps monitor your income and expense transactions and detect possible errors accordingly. You may want to check out this article as your reference in doing and fixing reconciliations in QBO: Learn the reconcile workflow in QuickBooks.

 

I'm all ears if you have other banking concerns or questions about managing transactions in QBO. You can drop a comment below, and I'll gladly help.

View solution in original post

3 Comments 3
Rea_M
Moderator

banking rule

Hello, kzwin. 

 

From your description, I can tell you're already on the right track in setting up bank rules in QuickBooks Online (QBO). You'll first have to make sure QuickBooks shows bank text instead of description so the system can decide where exactly to apply the rule. Let's go to the Banking menu's For review tab to do so. I'll gladly show you how.

 

By default, QuickBooks shows the description in your list of transactions. When you set up a rule based on bank text, you'll first have to apply it in the Banking page. Here's how:

 

  1. Go to Bookkeeping, then Transactions, then select Bank transactions (Take me there).
  2. Above the table, go to Settings ⚙.
  3. Select Show bank details80.PNG

 

Once you're done, go back to the Create rule window to complete your bank rule set up. You can refer to the screenshot below or check out this article for the complete guide: Set up bank rules to categorize online banking transactions in QuickBooks Online.

 

 

Additionally, I encourage you to reconcile your accounts regularly (every month). This helps monitor your income and expense transactions and detect possible errors accordingly. You may want to check out this article as your reference in doing and fixing reconciliations in QBO: Learn the reconcile workflow in QuickBooks.

 

I'm all ears if you have other banking concerns or questions about managing transactions in QBO. You can drop a comment below, and I'll gladly help.

johnk1112233
Level 3

banking rule

Not solved, nor helpful and just another copy and paste response from the Quickbooks article library. Matching bank details and/or matching description with one word only just - still says "There are 0 transactions that meet this criteria, even though the criteria is clearly within the bank details. 

JessT
Moderator

banking rule

Hi johnk1112233,

 

Thank you for following the steps provided by my colleague. It's great to hear that those steps worked on your test accounts. Now, let's move forward with troubleshooting your specific situation.

 

If you haven't already, I recommend starting with some basic troubleshooting steps. One option is to sign in to QuickBooks Online using a private or incognito window in your web browser. This can help rule out any potential conflicts or issues caused by cached data or browser extensions.

 

If the issue persists, another troubleshooting step you can take is to clear the cached data of your regular browser. Sometimes, cached data can become misconfigured or outdated, leading to unexpected behavior. Clearing the cache can help resolve these issues and ensure a smoother experience.

 

Please feel free to return to this thread if you need further assistance. I'm here and ready to help you throughout the troubleshooting process.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us