How to Use Rules in QuickBooks Online Transactions
Last month, we talked about the types of best practices that can lead to more effective use of QuickBooks Online and, ultimately, more thorough knowledge of your finances. The first one was this: Go through your new transactions every day. Categorizing and otherwise expanding on the data brought in by your financial institutions really pays off when it comes to customer billing, reports, and taxes.
Granted, this habit will add time to your daily accounting chores. But there’s a tool on the site that can greatly accelerate this process: Rules. This feature must be used with care to avoid mischaracterizing or, worse, losing track of critical transactions. Here’s how it works.
Creating Rules
There are two ways to create Rules. The easiest is to start with an existing transaction. Hover over Banking in the left vertical pane and select Banking to open your transaction list. Be sure that you’re looking at transactions that are still For review, as these are the only ones that can be assigned to Rules.
Click on a transaction to open its expanded view. At the bottom of the small window that just opened, click on Create rule from this transaction. A screen like this will open:
QuickBooks Online’s Rules feature allows you to automatically document transactions that meet certain conditions.
Let’s say you own a lawn and garden maintenance company. You always order supplies from the same vendor, so there are numerous transactions every month. You want QuickBooks Online to automatically categorize and clear transactions under $250; above that, and you’d want to see them individually.
You’d start by naming the rule, designating it as Money out or Money in, and choosing an account (or leaving this option set at All bank accounts). Next, tell QuickBooks Online whether the conditions you’re about to establish should apply to all or any. That is, if you’re setting multiple conditions, is it all right if just one meets the criteria, or must they all?
Below that, you’d specify the actual conditions that must be present for QuickBooks Online to handle similar transactions in the same way. In our example pictured above:
- The transaction [Description] [is exactly] Lawn and Garden Supply LLC, and,
- The [Amount] [is less than] $250.
Now you have to tell QuickBooks Online what to do with the transactions that meet those criteria. Farther down on this screen, you’ll see these options:
QuickBooks Online will handle the transactions that meet the conditions you set by completing these fields.
Using the drop-down lists of options, you’ll select the Transaction Type, Payee, Category, and Class (if you use them). Every time a transaction comes in that meets the conditions you defined above, QuickBooks Online will apply these options.
Finally, you’ll have to choose from two different ways of processing these matching transactions. You can have QuickBooks Online Auto-categorize and auto-add, in which case the transactions will be automatically processed and moved out of the For review queue. In our example, we chose this so we didn’t have to work with transactions of less than $250; we only wanted to see more expensive purchases. If we had wanted QuickBooks Online to fill in those fields but still show us the transactions, we would have clicked in front of Auto-categorize and manually review. Clicking Save would move this Rule into a list that could be accessed by clicking Banking | Rules, where you can Edit or Delete them.
Complicated Stuff
To recap, because of the Rule that was created here, any transaction in which the Description reads Lawn and Garden Supply LLC and which is for less than $250 will now be auto-completed and moved out of For Review. Any transaction for over that amount will remain in the queue for approval.
QuickBooks Online’s Rules can save time if you have a large volume of similar transactions. But if they’re not created with absolute accuracy, you risk mischaracterizing or missing transactions you should have reviewed before adding them to the Reviewed queue. We’d be happy to help here to ensure that that doesn’t happen, so that you can take full advantage of the helpful Rules feature.
Want tax & accounting tips and insights?
Sign up for our newsletter.
Our Team
At IAM Accounting LLC, we take pride in our diverse and experienced team of professionals, each dedicated to providing exceptional service in accounting, tax planning, payroll, and financial management. Our team members bring a wealth of knowledge from various financial backgrounds, working together to ensure that every client receives the personalized attention and expertise they deserve. From managing complex accounting operations to providing tax-saving strategies, we’re here to help you achieve your financial goals with precision and care.
-
Ibrahim Mohammed
Founder & Tax StrategistIbrahim leads IAM Accounting LLC, offering expert tax strategies and financial guidance to help clients reduce tax liabilities and achieve their financial goals.
-
Jasleen Daswal
ControllerJasleen is a highly skilled Controller with over five years of experience as a Chartered Accountant. She ensures accurate financial management and oversees accounting operations.
-
Sahil Shaikh
Chartered Accountant & Tax PreparerSahil is a Chartered Accountant and tax preparer with expertise in tax compliance, financial reporting, and strategic tax planning, helping clients optimize their financial outcomes.
-
Ankit Gupta
Accounts AssociateAnkit brings a wealth of experience in finance and accounting, providing key support in day-to-day financial operations to ensure accuracy and compliance.
-
Neha Sharma
Key Accounts ManagerNeha manages our most valued client relationships, with over four years of experience as a Chartered Accountant, ensuring that client needs are met efficiently and professionally.
-
Michael Holsinger
Payroll Representative, ADP PartnerMichael is our dedicated payroll expert and ADP partner, managing payroll processes with precision and helping clients navigate payroll services seamlessly.