Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
lisa-2i-t-com
Level 4

Create bank rule

I have some transactions that come in from one of my banks that are labeled with a Check 9999. These are not *actual* check #s or transactions that should be labeled as checks - but they automatically get labeled as such. They are debit card expenses that are pending. I do not always know which ones wilI be labeled this way. I assume the 'bank text contains' would address the Check 9999 part? However, it looks like I have to pick a category as well, even tho the category will not be the same on all transactions. Is there not an option to create a generic rule that would resolve this? 

 

Thanks!

1 Comment 1
FateCandylaneT
QuickBooks Team

Create bank rule

You can manually review your bank statements to validate the transaction and categorize them to the right account, Lisa.

 

Although QuickBooks Online (QBO) doesn't have a general rule to categorize these transactions into each different category, you can check your financial statements to identify which entries labeled as Check 9999 belong to a specific category.

 

In addition, QBO depends on the data imported from your bank, and downloaded entries represent transactions that have been cleared.

 

That said, if Check 9999 entries have specific details or indicators to help filter and classify the transaction, you can create bank rules to categorize them separately into the right category. To do this:

 

  1. In your QBO account, navigate to Settings and select Rules.
  2. Click New Rule and enter a name.
  3. Under the Apply this to transactions that are ▼ dropdown, select Money in or Money out.
  4. From the in ▼ dropdown, select a bank or credit card account, or select All bank accounts.
  5. Set the rule conditions. You can set a single rule with up to 5 conditions. Click Set and include the following, then select + Add a condition.
  6. In the Conditions fields, specify whether the rule applies to DescriptionBank text, or Amount. Then select ContainsDoesn't contain, or Is exactly to decide how QuickBooks applies the rules.
  7. You can click Test rule to attempt recognition of your transactions.
  8. Then, select the settings for the rule and click Save.

 

Screenshot 2025-07-11 061336.png

 

Once done, QuickBooks automatically applies your rules to transactions in the For review tab.

 

If you require further assistance, let us know in the comments below.

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us