QBO Tip: How to Categorize Your Transactions in Bulk with Rules
Get 25% off QuickBooks® Online.
The Accounting Hub brings our accounting expertise directly to you. Schedule your 1-hour consultation and get the support you need – no contract required.
It’s important to categorize transactions, but it takes time. If every day brings several dozen into QuickBooks Online, you can automate this process.
One of the cardinal rules of accounting is this: Go through your new transactions every day. If you wait until there are too many of them, you may miss problems, just as you might skip categorizing some of them because it simply takes too long.
But correct categorization is essential. Your income taxes and reports will not be accurate if you fail to assign the right category to all of your transactions. QuickBooks Online makes this easy with the Rules feature.
If a transaction contains a specific piece of information, a name or an amount, QuickBooks Online allows you to indicate how it should be categorized. This kind of automation will save you time and may even prevent errors – as long as you use it carefully and accurately. Here’s how it works.
Defining Your Rule
We’ll use an easy example to explain how QuickBooks Online’s Rules work. Let’s say your shipping costs have started to increase lately, and you want to make sure you’re seeing any UPS transactions that go above a specified dollar amount, and that they’re categorized accurately. Hover your mouse over Transactions in the toolbar and click on Banking (assuming you’re downloading your bank transactions). Select an account to work with by clicking on it, and make sure the For Review bar is highlighted.
Click on a transaction to open it. On the bottom line, you’ll see a link labeled “Create a Rule.” If you click on it, a panel will slide out from the right, as pictured below:
The upper half of the Create rule panel
This portion of the Create rule panel is fairly self-explanatory. Give your rule a descriptive name (we entered UPS 25 Plus) and indicate whether it should be applied to Money in or Money out. If you want to select a specific bank account or card, click the down arrow in the field to the right and select it. Otherwise, choose All bank accounts. Next, decide whether a transaction has to meet Any of the conditions you’re going to specify or All of them. In this case, we want All.
Now you have to describe the conditions under which a transaction will be affected. We want transactions whose Description Contains The UPS Store. We also want to identify purchases from The UPS Store whose total is more than $25. So you’d click + Add a condition. In the row that opens, click the down arrow in the Description field and select Amount. Click the down arrow again in the next field and choose Is greater than. The final field in the row should contain 25.00.
You could keep adding conditions, but that’s all we need for this rule. You can click Test rule if you want to find out how many transactions in your For review list would meet your specifications.
Next, you want to Assign attributes to the transactions selected. Your options here are Transaction type, Category, Payee, Tags, Class, and Memo. The first two are required and the third is recommended. The last three are optional. If you want QuickBooks Online to automatically confirm transactions this rule applies to, click the Auto-confirm button so it’s showing green. If you choose this option, your matching transactions will be modified to meet your criteria and moved directly into the Categorized queue. You won’t see them in For review.
When you’re done here, click Save.
Each individual report in QuickBooks Online has three related task options.
The lower half of the Create rule screen
Warning: Accurate organization is absolutely critical to having accurate books. If you’re at all unsure as to whether you’re doing it right, we can help! Contact us today!
To recap: Any expense over $25 that comes into your For review queue whose Description reads The UPS Store will be automatically categorized and moved into the Categorized queue.
Conclusion
Rules are just one of the awesome features of Quickbooks Online that allow you to quickly and easily categorize your incoming transactions. If you are able to set these up correctly, rules could save you time and stress in keeping your books in order.
Are you using QuickBooks Online to its full potential for your business? Having effective systems in place will give you the freedom to actually enjoy running your business. We’re QuickBooks system experts, and we can help you get your business’s finances working for you, not the other way around.
Contact us today to let us know what you need help with!
Get Accounting support tailored to fit your unique business.
Schedule your consultation today to get set up on the best accounting software out there for small businesses.
