The Accountant’s Guide For QuickBooks Online Bank Feeds

While Working with QuickBooks Online Bank feeds you may face some difficulties such as How to use QBO bank feed in QuickBooks Online. Here we discuss the bank feeds in a more productive and efficient way for your clients. It helps you to take more advantage of QuickBooks Online with Bank Feed.

Tips for Working in QuickBooks Online Bank Feeds


We Discuss the five tips related to working with Bank and credit cards feeds in QuickBooks Online. These are some problem comes in Bank Feed such as, forming connections and keeping your bank feeds organized and populated with the latest transactions to review.

Tip 1: Search for Financial Institutions

Firstly, you use the Add Account button to search for supported banks either by name or URL.

Search for Financial Institutions in Bank Feeds
We prefer URL because some banks have the similar name, the URL is different to all banks. If you do not establish the connections with banks website, you won’t be able to form the connections with QuickBooks.

If you are having trouble in connecting with QuickBooks so first, you check your login works in Bank. You can easily connect the multiple bank and credit card companies.

 you check your login works in Bank

If you do not find result related to search so follow the troubleshooting or request support for your client’s bank and see the Tip#3 below

Tip 2 Select Number Of Days To Import

We offer the option to select a shorter time period than 90 days when you choose which accounts to connect. Because in that reconciled period you can prevent trying to match or add transaction and keep the books clean.

Select Number Of Days To Import

Go to the link and select an option from the drop-down menu as you want. if you only want to import new transactions going forward you select the 0 days from suggestions.
You exclude or include the transactions that are not needed for you from your accounts. Check the all transactions details for future reference.

Tip 3: Use File Upload

You Upload a file of your bank account transactions if you are able to download from banks into CSV, .qbo, .qfx or .ofx file format by clicking the drop-down arrow on the update button and choose file upload.

Use File Upload

One thing noticed or keep in mind, file upload accounts will show a $0.00 bank balance and will need to manually update. And QuickBooks will show the # of days since the last upload.

Tip 4: Use The Update Button:

Update the latest data in your QuickBooks Online for better support, once you click the update button whose located in the upper left corner of the banking page to refresh the feed, Quickbooks update the new data after click update Button.

Use The Update Button

QuickBooks displays the update data in a more recent hour so you no need to stay on this page while it updates.
The best option for troubleshooting connectivity issues is updating because he provides the latest information so work is so faster a dal thing we updated that time.

Tip 5: Rearrange Accounts:

Manage your accounts or rearrange accounts it’s your own Duty in this way you proper focus on your account or specific accounts whose display on the home page and in the banking tab.

Rearrange Accounts:

  • Go to the QuickBooks Online dashboard for rearranging accounts.
  • Now click the pencil icon in the upper right of the Bank account list and drag and drop accounts to the desired order and click save.
  • It will display on your banking page after rearranging accounts.

Managing Bank Rules:

Here we provide the information for bank rules related to the QuickBooks online. When you connect with bank and credit card accounts, bank rules help you customize, control and automate.

Tip 1 Explore Your Conditions:

Firstly, Establishing the condition which is best suitable for your work with QuickBooks online. Only one time create your best conditions or rules, you easily corporate with QuickBooks online and fits your goals.

You choose Money In or Money Out and applicable bank and credit card accounts when you creating the rule for QuickBooks Online.

Explore Your Conditions
First thing for creating a rule is structure, focus on the condition such as ANY or ALL and utilize the Bank Text, Description or amount. It’s your choice rule based on a single condition or combines up to 5 conditions in the single rule.

Bank text is the Transaction detail its include information such as the store, state, city, phone number, date and, among other items etc. QuickBooks access the all these things from the bank.

Bank text is the Transaction detail
A description is the cleaned up QuickBooks interpretation of the blank text. When you creating a rule word description keeping in your mind.

An amount is another term used in the bank when you creating rule remember to establish is greater than, is less than, equals or does not equal for amounts.

Tip 2: Don’t Forget You Can Split

  • Split the transactions into multiple categories or classes.
  • You have the option to split by dollar amount or percentage across up to 20 lines.

split by dollar amount or percentage across up to 20 lines

  • Select the proper category on each line when splitting across classes only.

Select the proper category on each line when splitting across classes only.

Tip 3: Use Automatic Add:

Its save the more time in data entry. Automatic add directly allow the QuickBooks to automatically add this transaction directly to the register, so your valuable time saved.

Use Automatic Add
Use Automatic Add with caution and one thing you also remember, edit the rule to select this option later after you have tested it out.

Tip 4: Rearrange Your Rules:

Open bank sites go to bank rules to manage your list of rules by edit rules, create some different rules, and delete unused rule.

Rearrange Your Rules

Rules modification or rearrange rules is compulsory for a bank and for you because in this way you proper work on Quickbooks online.

Tip 5: Work with a ProAdvisor:

Sometimes we think this task is hard and this task has many difficulties, a reason for this thing is we do not understand with bank rules or other things related to the bank. And regularly time and energy waste for bank work so we looking for expert help with QuickBooks Online.

Find a QuickBooks a Proadvisor In your local area, he will help you and give the proper guidance related to the work

Adding Transactions:

QuickBooks will scan your bank data from your account after connecting your bank and credit cards accounts. You can add transaction directly from the bank feed if your feed transaction does not match the existing transaction in QuickBooks.

Five easy tips of adding transaction are described below.

Tips 1: Configure The Bank Feed Settings:

  • Go to the small Gear, you will find options to configure here.
  • You add and remove the necessary details as you add transactions, and payee and check number columns.
  • Change the date of transactions from the bank by Editable Date Field option, use this with caution.
  • Copy bank Detail to Memo is turned on by default, it’s helpful during reconciliation.

Copy bank Detail to Memo is turned on by default

  • Change the cleaned up QuickBooks description to bank detail in the bank feed itself be turned on and off Show Bank Details.

Tip 2: Sort The Bank Feed:

To sort the bank feed by any column. Choose the more effective option for sorting the bank feed. Newest transaction first or oldest transaction first, this option helps in sorting the bank feed in an easy way and you can swap between styles.

Sort The Bank Feed

To view All or Recognized by additionally filter. Transaction in QuickBooks has auto-categorized based on your past behavior and recognized will displays transactions with a match rule.

Tip 3: Complete Your Transactions Details

Use the split tool in QuickBooks Online Plus, to divide the transaction across multiple categories or classes.

Complete Your Transactions Details

QuickBooks Online Plus has advanced features. You can use this features for expanding the transaction and make sure you are filling in all applicable fields.

Here are a few reasons:

  • The transaction is older than 180 days.
  • The dollar amount in QuickBooks is different than what cleared the bank.
  • The transaction was recorded in a different bank account(see tips #4).

Tip 4: Turn Off Automatic Categorization, As needed:

QuickBooks saves the time of working by learns from your behavior and remembers how you categorize the transaction because you add this features already in QuickBooks.


Turn Off Automatic Categorization, As needed

  • If some transaction not in a category and you want to add this transaction.
  • You simply add and edit the settings.
  • After that check the box to leave the transaction Uncategorised from now on.
  • Leave Uncategorised: What category to use each time these things only appear or indicate when Leave Uncategorised allows you.

Uncategorized Expense or Uncategorised Income will appear going forward and a special Uncategorised rule is saved in QuickBooks.

Tip 5: Utilize Batch Actions to Save Time Adding Like-Transactions

Use Batch action: For Modification purpose select to assign the payee, category and other details in batch to like transitions. If you select multiple transactions at once use your shift key.

Utilize Batch Actions to Save Time Adding Like-Transactions

Here are some common reasons:

  • Two transactions in the bank feed are a match against one transaction in the register.
  • The transaction is already reconciled in QuickBooks.

Additionally: Use Batch Actions, Instead of accepting each transaction individually, you accept Selected to add transactions in a batch.

I hope that you this blog is very helpful for you to understand QuickBooks Online Bank Feeds. If you still have any queries or want help then contact our QuickBooks online support team via toll-free number +1-855-441-4417.

Leave a Reply

error: Content is protected !!

Looking for QuickBooks Support & Help Services?

Talk to our Certified QuickBooks ProAdvisor