Working with Downloaded Transactions in QuickBooks Online, Part 2

In our previous post, Working with Downloaded Transactions Part 1, we went over the basics of managing financial transactions once you’ve downloaded them into QuickBooks Online. We walked you through the mechanics of connecting to banks and credit card companies online and described the process of reviewing imported transactions, exploring concepts like:

We previously explored QuickBooks Online’s Banking features, including the site’s ability to work with related transactions as groups.

We previously explored QuickBooks Online’s Banking features, including the site’s ability to work with related transactions as groups.

  • Categorizing transactions, and marking them as billable

  • Adding transactions to an account register; matching them to related transactions; or transferring them to another account

  • Using Batch actions to process related groups of transactions




In this post, we will look at the process of setting up rules to automatically classify transactions as they come in from your banks. We’ll also provide a brief overview of the Chart of Accounts.


Bank Rules

We’ve already discussed QuickBooks Online’s ability to guess how transactions should be categorized (it’s not always right, but you can change incorrect ones). QuickBooks Online also allows you to memorize transactions that recur on a regular basis; this saves time and improves accuracy. There’s yet another way the site uses automation to help minimize keystrokes: Bank Rules. Based on your input, it will scan incoming items and classify them, so you don’t have to. This can be very helpful when you regularly import transactions that share specific attributes.

Let’s look at how this works. Click Banking in the navigation toolbar, then click Bank Rules. Once you’ve created your own rule(s), they’ll appear in a grid on this screen. For now, click New rule in the upper right corner. Basically, you’re going to tell QuickBooks Online that when specific conditions are met, as you can see in the example below, it should take the specified action(s): assign a Transaction type, Payee, and/or Category. You can also have the transaction automatically added to your books.

You can create Bank Rules in QuickBooks Online to automatically assign a Transaction type, Payee, and Category to imported items that meet specific conditions.

You can create Bank Rules in QuickBooks Online to automatically assign a Transaction type, Payee, and Category to imported items that meet specific conditions.

If your business processes a lot of transactions, Bank Rules can be incredibly helpful. Just be sure to set them up correctly from the get go or you could spend a lot of time fixing errors after the fact.


Account Registers, Chart of Accounts

In this column and the last, we’ve been working with transactions as they come into QuickBooks Online directly from your financial institutions, before they appear in your account registers. When you clicked Add after you looked at—and perhaps modified—a transaction listed under For Review on the Banking page, you sent it to that account’s register.

Notice that QuickBooks Online’s registers look similar to their paper counterparts; you may remember recording checks and deposits in the back of your checkbook, if you’ve been in business long enough. There are two ways to see them in QuickBooks Online. When you’re on the Banking page, look over to your right. You’ll see a link labeled Go to Register. Click it, and you’ll be taken to that page for the account that’s currently active.

You can also open your account registers from the Chart of Accounts. We don’t talk much about this element of financial management because it’s not something you should be modifying. Nevertheless, it’s the heart of your accounting system. It consists of a comprehensive list of your company’s accounts, divided into assets, liabilities, income, expenses, and equity (along with subaccounts). Transactions are assigned to the appropriate account and recorded in the General Ledger, which is another element of accounting that we don’t discuss because you don’t have to deal with it in QuickBooks Online.

You can view your company’s Chart of Accounts in QuickBooks Online.

You can view your company’s Chart of Accounts in QuickBooks Online.

Click on the Accounting tab in the navigation toolbar, then Chart of Accounts. You’ll see your individual bank accounts listed here, along with a View Register link.


A Critical Concept

Again, you won’t have to deal with the Chart of Accounts, but it’s very important that you understand how to manage downloaded transactions as you move them into your bank accounts in QuickBooks Online. Mistakes here can trigger errors in reports and taxes, as well as create general confusion.