Welcome to the Fit Small Business QuickBooks Online training course. In this lesson, we’re going to cover how to manage QuickBooks bank feeds. After connecting your bank accounts to QuickBooks, you will need to review each transaction to ensure the date, amount, and account are correct before adding them to the QuickBooks check register.
To complete this lesson, you can either watch the QuickBooks bank feeds tutorial video below, read through the step-by-step instructions, or do both. Let’s begin.
If you’d like to learn more about managing income, expenses and reporting in QuickBooks download our free 39 course QuickBooks tutorial here.
Why It’s Important to Manage QuickBooks Online Bank Feeds
When you import bank transactions into any version of QuickBooks Online, they are unposted. This simply means you need to review them and provide some additional information before they can be added to the register in QuickBooks. In this lesson, we will show you how to review and categorize your transactions so they can be added to the register and your financial statements.
QuickBooks Bank Feeds Banking Center Layout
The QuickBooks bank feeds banking center includes a tile for each bank and credit card account that is connected to QuickBooks. Each tile includes the name of the financial institution, the current bank balance and the current balance in QuickBooks.
As indicated below, each bank and credit card account is located at the top of the page:
A brief description of the information you will find in the banking center is below:
- Bank balance of accounts connected to QuickBooks: If the bank account is connected to QuickBooks, the top portion of the tile will show the bank balance as of the date of the last sync. If your bank or credit card account is not connected, the bank balance will be zero.
- QuickBooks balance: The bottom portion of each tile displays the current balance in the QuickBooks register and the number of transactions in the For Review tab for each bank and credit card account.
- Bank balance of accounts not connected to QuickBooks: If the bank or credit card account is not connected to QuickBooks, the bank balance will show a $0.00 balance in the top portion of the tile.
- QuickBooks balance for accounts not connected to QuickBooks: Similar to the linked account, the bottom portion of the account box displays the current balance in the QuickBooks register and the number of transactions in the For Review tab below.
- Bank feed transactions are organized into the following three tabs:
- For review: This tab will show all of the unposted transactions. For example, when you import transactions into QuickBooks, this is where they will appear until you review them and take action.
- In QuickBooks: This tab will show all of the transactions that have been matched or added to the register in QuickBooks.
- Excluded: This tab will show the transactions that have been removed from the For Review tab by you.
How to Manage QuickBooks Online Bank Feeds
Once transactions have been downloaded into the banking center, you will need to review them for accuracy before adding them to the QuickBooks check register. First, head over to the banking center. Next, review the transactions listed on the review tab. Confirm the transactions that QuickBooks has recognized and matched first. Review the remaining transactions to ensure the information is correct before adding it to check register.
The steps to manage QuickBooks Online bank feeds are:
1. Navigate to the Banking Center
To review and manage downloaded transactions, select Transactions and then Banking. The Banking Center should display on your screen so that you can review and take action on transactions that have been downloaded.
From the Homepage, click on Transactions located on the left-hand menu bar and select Banking as indicated below:
2. Review the Transactions Tab
Once a transaction is downloaded into QuickBooks, it is listed in the review transactions tab.
You should begin to review transactions in the review tab. Within the review tab, transactions are listed in the all tab and if it is a transaction recognized by QuickBooks, it will also appear on the Recognized tab.
Downloaded transactions are categorized in one or both of the following tabs:
- All: This tab will list all transactions (including those on the recognized tab)
- Recognized: If QuickBooks recognizes a transaction that is already recorded in your register, it will display a green Match tag next to the transaction and add it to the Recognized tab as indicated below.
To add the transaction to the register, just click the Match link located in the Action column. QuickBooks will add the transaction to the QuickBooks register and include it in your financial statements.
As indicated below, QuickBooks will attempt to match downloaded transactions by tagging them with “Match.”
TIP: QuickBooks can also recognize common vendor names and will make suggestions as to which account it should be coded to. If you accept the suggested account, QuickBooks will change the account for all transactions of that same name.
For example, if you have previously coded Bluehost.com transactions to Advertising (as indicated below) then the next time a Bluehost.com transaction is downloaded QuickBooks will suggest coding it to the Advertising account. If you accept the suggestion then QuickBooks will categorize all transactions with the Bluehost.com description to the Advertising account.
In the screenshot below, QuickBooks has automatically populated the category based on how the transaction was previously coded:
3. Add a New Transaction
Click on the transaction that you want to add in the Banking Center and complete the fields as indicated below:
A brief description of the information to include in the add new transaction window is below:
- Vendor or payee: Select the vendor from the drop down. If you have not set up the vendor yet, you can do so by selecting Add New from the drop down. Be sure to watch our video tutorial on Setting up Vendors.
- Account or category: Select the account that you want to code the transaction to.
- Description: Put a brief description in this field of what the expense is for.
- Add: Click the “Add” button to add this transaction to QuickBooks.
Troubleshooting QuickBooks Bank Feeds
When managing downloaded banking transactions you may encounter a few errors that you will need to troubleshoot. A couple of the most common errors that occur are transactions that have already been matched and an issue with the ability for QBO to download transactions due to a sign in error.
The two most common issues with QuickBooks bank feeds and how to troubleshoot them are:
Transactions Already Matched
Sometimes a transaction has been matched to the wrong transaction in the register. This can happen for a number of reasons, but usually because the register transactions are for the same amount and fall within the same date range. You can easily fix this issue by undoing it. This will return the transaction to the For Review tab where you can match it to the correct transaction.
Click the In QuickBooks tab and click Undo next to the transaction as indicated below:
QuickBooks Bank Feeds Error Sign-in
If you see a red error message in the Banking Center indicating an error has occurred, more than likely your user id or password for your bank account has changed. In order to reconnect your bank account to QuickBooks, you need to update QuickBooks with the new sign-on information.
Click on the Fix It link as indicated below, and follow the on-screen instructions to update your user id and password:
How to Create Bank Rules to Streamline QuickBooks Online Bank Feeds
You can reduce the amount of time it takes to code and record transactions in the Banking Center by setting up bank rules. First, you will navigate to manage rules. Second, you will create the new rule. Third, you will set the conditions of the rule. QuickBooks will use these bank rules to automatically code transactions to the right account for you.
Follow the three steps below to create bank rules:
1. Navigate to Manage Rules
Click on the drop-down arrow to the right of the Update button and select Manage rules as indicated below:
2. Click New Rule
Click the New rule button in the upper right-hand corner of the screen as indicated below:
3. Set Up Conditions for New Rule
Part of creating a new rule involves setting the conditions of the rule. This involves completing several fields of information such as the name of the rule, the bank account it applies to and the action you would like the program to take such as assigning a payee and category.
Complete the following fields to set up the conditions for bank rules:
A brief description of the information required to set up bank rules is below:
- Rule name: Give each rule a name so that you can easily identify it.
- For: Select the type of transactions the rule applies to. For example, money in (deposits) or money out (withdrawals).
- In: From the drop down, you can select which bank accounts this rule applies to. The default is All bank accounts.
- Conditions: You have the option to set the conditions that the transaction must meet for this rule to apply:
- From the drop down, select all or any
- From the drop down, you can select bank text, description or amount.
- From the drop down, you can select contains, is exactly, or doesn’t contain.
- In this field, you can enter the bank text, description or amount.
- Transaction type: Select whether the transaction is an expense, transfer, or check.
- Payee: Select the payee (if applicable).
- Category: Select the account the transaction should be categorized to.
Frequently Asked Questions (FAQs) About QuickBooks Bank Feeds
The most frequently asked questions about QuickBooks bank feeds have been included in this section. If you don’t see your question, visit the Fit Small Business Forum and post your question there. One of our industry experts will be happy to answer your question.
The most frequently asked questions about QuickBooks Bank Feeds are:
How do I enter bank feeds in QuickBooks?
You can establish a bank feed in QuickBooks Online by following these five steps:
- Navigate to the Banking center by clicking on Banking located on the left menu bar
- Click the Add Account button which is located in the upper right corner of the screen
- Type the name of your bank in the search box
- Sign into your bank account using the online user id and password you use to sign into your bank account
- Select the date range you would like to start downloading transactions
How do I connect my bank feed in QuickBooks Online?
To connect your bank feed in QuickBooks, log in to your QuickBooks Online account. Navigate to the Banking Center and click the Add Account button. Type the name of your bank in the search box and follow the on-screen instructions. You can watch our QuickBooks bank feeds tutorial to see how this is done.
Does QuickBooks Sync with a Bank Account?
Many financial institutions allow account holders to connect their bank accounts to QuickBooks. If it’s supported by your bank, connecting your bank account to QuickBooks allows your bank transactions to be automatically downloaded into the software program.
That wraps up the how to manage QuickBooks bank feeds tutorial. The next lesson in our QuickBooks Online Training Course will be how to make deposits. In this lesson, we will walk you through how and when to enter bank deposits in QuickBooks Online. To access this lesson or any of the others in the series, click the buttons below. Be sure to sign up for a free 30-day trial of QuickBooks Online.
To access this lesson or any of the others in the series, click here.
Our Recommended QuickBooks Apps