February 2, 2024 • QuickBooks Online

How to Add a Bank Account in QuickBooks Online?

Adding a bank account to QuickBooks Online is vital to effective financial management for your business. Integrating your bank account allows you to streamline financial transactions, gain real-time insights, and ensure accurate accounting. This detailed guide will walk you through the simple process of adding a bank account to QuickBooks Online. 

Whether you're a seasoned user or just starting your financial journey with QuickBooks, you'll find the instructions easy to follow, keeping your business's financial records intact. Let's get started on this legitimate path for more excellent financial stability.

table-of-contents

Steps to Connect Your Bank Account to QuickBooks Online

To accurately record your firm’s financial transactions, connect your bank account with QuickBooks Online. Let’s see how to add a bank account to QuickBooks and how far back you want QuickBooks to pull your transaction history. 

  1. Select  “Transactions” from the menu and click “Bank Transactions.” 

  1. Click on “Link account” to select your bank from the list of popular bank options available.

  1. You can also enter and select the bank's name from the list.

  1. Log in to your bank account, fill in the credentials, and click “Submit.”


  1. QuickBooks will connect your online account with one on your Chart of Accounts.

  2.  If you’ve already set the account on your chart of accounts, you can choose the relevant account from the dropdown menu.

  1. Choose how far you want QuickBooks to go when it downloads transactions from your bank. The default choice is the beginning of the year, but you can select any date.

  2. If you want to bring in transactions from the beginning of the current year, you can go with that option, too.

  1. Click on “Connect,” when the connection is complete, you’ll see all the business transactions that cleared your bank account from the date you selected to the present date.

  2. When more transactions clear your bank, they’ll appear on this list for you to review.



  1. The next step is to categorize them so QuickBooks adds them to the correct accounts.

Important: Please ensure you don’t enter any transactions before the date you entered. Learn how to upload bank transactions into QuickBooks Desktop to save time from entering your data manually, keep your books updated regularly, and simplify the reconciliation process.

How to Categorize Transactions in QuickBooks Online?

Categorizing transactions in QuickBooks Online is a fundamental aspect of maintaining accurate financial records. This section explores the essential steps to categorize transactions and keep financial data in order efficiently.

Steps to Categorize Transactions in QuickBooks Online

  1. Select “Transactions” from the menu, and in “ Bank Transactions,” click either the “checking” or “savings” account.

  1. QuickBooks will show all your recent transactions and suggest categories for each one.

  2. You can either confirm the suggested category or choose a different one that best describes the transaction.

  1. For income transactions, select the income account (example: “services”) from the drop-down menu to track these transactions.

  1. For purchase transactions, categorize them as expenses or fixed assets.

  1. You can split a transaction into multiple categories or assign it to a particular project or customer.

  1. If you don't know who the transaction was with, you can look at the bank detail information and then select “Confirm.”

  2. You can save time by setting up rules for everyday transactions

  3. You will see transactions you've already recorded in QuickBooks or payments you must apply to open invoices and bills.

  4. If QuickBooks detects that a transaction relates to something you've already entered, you'll see a "Record found" message. Select “Confirm” if the match is correct.

  1. If the match is incorrect, you can select “Categorize” to add it to QuickBooks as a new transaction.

  1.  Or you can select “Find other matches” to match it to the correct transaction.

Categorization with Bank Rules in QuickBooks Online

Handling transactions in QuickBooks Online may seem like a daunting task, especially when you're dealing with a pile of them. Manually categorizing each transaction is time-consuming, especially if you have to do it repeatedly. But don't worry because we've got a trick up our sleeves, and it's called "bank rules." Bank rules are like your trusty sidekick, here to make categorization a breeze and give you back your valuable time.

Bank rules in QuickBooks Online are like having a super helpful assistant who automatically organizes your incoming transactions. They work by following your instructions to sort and categorize downloaded transactions based on specific criteria you set.

How do you use bank rules in QuickBooks Online?

  • Find Repetitive Transactions: Look for transactions with the same descriptions, payees, or amounts. These are perfect for creating rules.

  • Navigate to “Settings": Select “Rules” from the list menu. It's where you manage all your bank rules. But you can have up to only 2000 bank rules.

  • Create a New Rule: Give it a name so you can recognize it later. You can only create a rule for unreviewed transactions.

  • Income or Expense: Decide if the rule is for money coming in or going out.

  • Choose the Accounts: Select which bank accounts the rule should apply.

  • Recognition: Tell QuickBooks how to recognize the transactions using keywords from the description, bank text, or amounts.

  • Test Your Rule: Before using it on real transactions, click "Test Rule" to see if it's catching the right ones.

  • Action and Automation: Decide what QuickBooks should do with matching transactions – categorize them, mark them as transfers, or even confirm them automatically.

  • Refine and Edit: You can always edit your rules to improve or change how they work.

What More Can Bank Rules Do Other than Categorizing Transactions:

  • Split Transactions: Divide a single transaction into different categories, like separating groceries and gas from a supermarket visit.

  • Fill in Payees and Tags: Save time by automatically filling in these details for recurring transactions.

  • Use Custom Fields: Extract specific transaction data for further analysis or reporting.

Frequently Asked Questions

How do you import bank transactions in QuickBooks Online?

Here are the quick instructions on how to import bank transactions in QuickBooks Online:

For accounts connected to online banking:

  • Go to Transactions > Bank transactions.

  • Select the blue tile for the account you want to update.

  • Select the Link account dropdown and then Upload from the file.

  • Choose the file you downloaded from your bank.

  • Review the matching and confirm.

For accounts not connected to online banking:

  • Go to Transactions > Bank transactions.

  • Select Upload transactions.

  • Choose the file you downloaded from your bank.

  • Select the account you want to import the transactions into.

  • Review the matching and confirm.

Additional tips:

File format: QBO accepts .CSV, .QFX, .OFX, .QBO, and .QIF files.

Date range: Download transactions for a specific date range to avoid duplicates.

Review carefully: Check each transaction before confirming to ensure accuracy.

Categorize: Assign categories to transactions to organize your finances.

Reconcile: Match imported transactions with your bank statement for accuracy.

How to connect your bank accounts to QuickBooks Payroll to pay taxes and employees?

  • Go to Payroll, then Overview.

  • From Get Ready to Pay Your Team, select Start Setup.

  • Connect your bank, add your federal tax ID number, and review the rest of the information.

  • Enter your principal officer's information.

  • Connect the company bank account you want to use for payroll. You can only add one bank account.

  • Review your direct deposit funding time and limit if you plan to pay employees with direct deposit.

  • Your funding time is when you'll need to send your payroll to QuickBooks for processing before your payday.

  • Your direct deposit limit is the maximum amount of money you can send direct deposit per payroll within six days.


How do I link my bank account to QuickBooks Online Payroll?

Here are quick instructions on how to link your bank account to QuickBooks Online Payroll:

Log In: Sign in to your QuickBooks Online Payroll account.

Payroll Dashboard: If you still need to do so, navigate to the Payroll Dashboard.

Payroll Setup: Find and access the "Payroll Setup" section.

Bank Account Setup: Look for "Bank Account Setup" or a related option within the Payroll Setup.

Connect Bank Account: Click on the "Connect Bank Account" button.

Choose Bank: Choose your bank from the provided list.

Log into Your Bank Account: Follow the prompts to log in to your bank account using your online banking credentials.

Authorize Access: Complete the authorization process to grant QuickBooks access to your bank account information.

Confirmation: Once authorized, QuickBooks will confirm linking your bank account to your payroll account.

Review and Edit: Take a moment to review the linked bank account information to ensure accuracy.

Completion: You have successfully linked your bank account to QuickBooks Online Payroll. Now, you can conveniently pay your employees and easily manage your payroll.