How to Create Bank Rules to Save Time! in QuickBooks Online

These are the ones you need to review every day. I recommend contacting our QuickBook Online Suppor Team. They have the tools to pull up your account in a secure environment and be able to see the cause of why the Manage Consent button is not working on your end. You can follow the steps provided by  Kevin_C on how to reach them.

  • 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.
  • It helps you save time by setting up an automatic categorization of the regular recurring transactions.
  • Mark Calatrava is an accounting expert for Fit Small Business.
  • We provide the convenience of automatic offsite storage, eliminating the need for extra effort and cost on your part.
  • Be sure to rename it versus using the auto-generated (“suggested”) name to avoid cluttering up your rule list when searching later.

It may take some time to establish the criteria and conditions that work best for your organization. But once your rules are established, you’ll save a significant amount of time in reviewing and accepting recurring transactions. This will help to quickly reconcile your accounts and ensure the accurate recording of transactions. The only requirement to add a new transaction is to provide a category, or account, from your chart of accounts. However, we highly recommend that you also provide the vendor, customer/project, class, and location so that QuickBooks has all the available information to run useful management reports.

Bank rules can be set up quickly

Use our product selector to find the best accounting software for you. If everything looks good, select Add to move the transactions directly into an account in QuickBooks. You can also select and review it before you move it. Our professional staff, alongside automated tools, monitor service performance 24/7.

  • There are a couple of different ways to create bank rules in QuickBooks Online.
  • In my separate company, the payroll transactions are still being matched as normal, so it is still possible and should be.
  • This ensures data privacy by allowing only the intended audience to access data and read messages.
  • If the auto-add feature is turned on, the transaction will be automatically added to the bank register without your review.

Here’s more information about manually uploading transactions into QuickBooks Online. If your business processes a high volume of banking transactions, you might consider applying Rules to process them quickly. There are a couple of different ways to create cost of goods sold journal entry.

How to set up bank rules in QuickBooks Online

They have enough tools that can help identify any known issues related to payroll transaction matching and provide additional troubleshooting steps to rectify your situation. Looking for more tips on how to save time with your bank accounts in QBO? Be sure to check out our blog on how to reconcile your bank account in QBO. You can go to the bank’s register to add either a journal entry, transfer, expense, refund, bill payment, receive payment, sales receipt, deposit, or a check.

ALTRUIC® and Helping Nonprofits Create Good® are registered trademarks of Altruic Advisors, PLLC.

You have two options to prevent transactions with incorrect names or accounts. Mark Calatrava is an accounting expert for Fit Small Business. As a QuickBooks ProAdvisor, Mark has extensive knowledge of QuickBooks products, allowing him to create valuable content that educates businesses on maximizing the benefits of the software.

Create rules to categorize transactions in QuickBooks Desktop

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. 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.

Step 2: Review recognized transactions

While we’re incapable of offering you more than 24 hours in a day (if any outsourced solution claims otherwise, run in the opposite direction), we can offer you some of your time back. Whether or not you currently use FA Bean Counters for your bookkeeping needs, this blog is bound to save you some time on your books. The only catch is that you use QuickBooks Online (or QBO as those in the bookkeeping biz call it). You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking “Continue”, you will leave the community and be taken to that site instead. Rules like these can save you from having to update categories and adjust transactions one by one.

You can view which downloaded transactions were recognized by a bank rule. While inside your For review tab, select Recognized from the All transactions ? dropdown menu. This will list all transactions that were recognized by any bank rule. When connecting your business bank account to our bank feeds, you may ask “Is QuickBooks safe to use? ” At QuickBooks Online, safeguarding your financial data is our top priority. The Create rule pop-up should appear on the right of your screen.


So, any transaction that comes into QuickBooks Online from your bank that has Lawn and Garden Supply LLC in the Description field and which is for less than $250 will be treated similarly. There are other options for the first two fields; you’ll find them by clicking the down arrow. This step is also very important as it will decide which account on your books the transaction will go to.

This entry was posted in Bookkeeping. Bookmark the permalink.

Comments are closed.