Learning Center
We keep you up-to-date on the latest tax changes and news in the industry.
Too Many Transactions in QuickBooks Online? Create Rules
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’re likely to give them short shrift. 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.
The site also provides a way for you to accelerate the process by automating it. It allows you to create Rules. That is, 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. Here’s how it works.
Defining Your Rules
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. (If you’ve never explored what you can do with a downloaded transaction, study this box carefully while you’re there, and contact us with any questions.) On the bottom line, you’ll see a link labeled. Create a rule. Click on it, and a panel slides 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. So consider this carefully.
When you’re done here, click Save.
The lower half of the Create rule screen
Warning: QuickBooks Online allows you to create new categories directly from this window. But accurate categorization is so critical that we’d rather you schedule a session with us to go over your list of categories and make any modifications necessary.
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.
QuickBooks Online’s Rules can save you time, but if they’re not created correctly, you may have errors in your company file without even knowing it. We recommend that you let us help you set these up from the start to avoid this. If you’re new to downloading transactions onto the site, you may also want to consult with us.
Want our best tax and accounting tips and insights delivered to your inbox?
Sign up for our newsletter.
Benefits of having a business advisor
Your CFO, Reimagined as a Financial Doctor
Diagnosing root causes, prescribing solutions, and guiding your property business toward long-term wealth.
Our CFO | Advisor
Raquel is a passionate business owner. Now, she is returning to her grassroots with a twist - guiding clients with her expertise as a CPA, she can advise your company as your trusted CFO and Advisor.
-
Raquel Deodanes, MS, CPA
Co-Founder✅ CPA with Real-World Experience – I help property managers stay profitable, tax-efficient, and cash flow positive.
✅ Tax Strategist – Former advisor at California’s revenue agency.
✅ Trusted by 4,000+ Businesses – Experience across CA, FL, TX, NV, and beyond.
✅ Real Estate Investor – I understand the financial realities of property management.
✅ Entrepreneur – I’ve built businesses and know the challenges you face.
Frequently Asked Questions
-
We diagnose financial inefficiencies, treat problems like poor cash flow or rising costs, and guide you to long-term financial health. That includes cleaning up your books, forecasting cash flow, optimizing operations, and helping you grow your portfolio with confidence — just like a doctor builds a custom care plan for a patient.
-
Bookkeepers record transactions. CPAs file your taxes. We connect the dots — helping you understand your numbers, strategically improve them, and make smarter decisions throughout the year. We work alongside your existing team to drive performance, not just compliance.
-
If you're unsure where your cash is going, struggling with rising costs, planning to scale, or just tired of reacting instead of planning — now is the right time. We help you get ahead of problems, not just clean up after them.
-
Clients typically see improved cash flow, cleaner books, higher NOI, better financial reporting, and a lot less stress at tax time. More importantly, you gain clarity, confidence, and control over your business — and a partner who helps you grow it.
Pricing
Painless, transparent pricing.
Let us take away your stress and give you back your time. Choose your perfect package today.
Base
-
Dedicated finance expert
-
Bookkeeping with accrual basis
-
Includes P&L, balance sheet, and cash flow statements
Core
-
Includes everything in Base, PLUS
-
Industry KPIs and financial ratios
-
Monthly virtual 1-hr meetings
-
Monthly rolling budget forecasts
Growth
-
Includes everything in Base, CORE
-
Budget vs. actuals variance analysis and review
-
Payroll and HR Platform