The Ultimate Guide to Banking in QuickBooks Online

Author

Reads 1K

A vibrant red piggy bank against a minimalist and contrasting studio background, ideal for finance themes.
Credit: pexels.com, A vibrant red piggy bank against a minimalist and contrasting studio background, ideal for finance themes.

QuickBooks Online offers a seamless banking experience, allowing you to connect your bank accounts, credit cards, and other financial institutions to manage your finances in one place.

You can connect up to 100 bank and credit card accounts, including popular institutions like Bank of America, Wells Fargo, and Chase.

To get started, simply click on the "Banking" tab in the navigation menu and select "Add Account." From there, you can enter your account information and connect your accounts in just a few clicks.

QuickBooks Online will then automatically import your transactions, categorize them, and even match them with existing transactions to reduce manual entry.

Getting Started

The QuickBooks Online bank feed is a QuickBooks feature that connects your online business bank account securely to your accounting software.

To get started, you'll need to connect your bank account to QuickBooks Online. This can be done by selecting the bank account you want to connect from the list of available banks in QuickBooks Online.

All banking and merchant account transactions can be imported via the QuickBooks Online bank feed, including cash deposits or withdrawals, online payments, credit or debit card charges, transfers, or loan payments.

What Is The?

1 Us Bank Note
Credit: pexels.com, 1 Us Bank Note

The QuickBooks Online bank feed is a feature that connects your online business bank account securely to your accounting software. It syncs your banking transactions with your QuickBooks Online records, so you don’t have to input every check, charge, transfer, expense or deposit manually.

The QuickBooks Online bank feed is a one-way communication channel, meaning your QuickBooks Online records won't be exported to your bank or credit card processor. This is a secure way to keep your financial information private.

All banking and merchant account transactions, including cash deposits and withdrawals, online payments, credit or debit card charges, transfers, and loan payments, can be imported via the QuickBooks Online bank feed.

Opening Balance

The Opening Balance Equity account is created when you import your transactions from a financial institution into QuickBooks Online.

It brings in the balance on the account as of the first date of your import, making an entry to this account.

Credit: youtube.com, How to Create an Opening Balance in Quickbooks Online in less than 60 seconds

This entry will have no impact on your reconciliations if you don't have any data in QuickBooks Online for the bank or credit card prior to the import.

However, if you have been manually entering or importing your transactions and then you later connect to your financial institution, the Opening Balance Equity entry will impact your next bank reconciliation.

To resolve issues with your first reconciliation after connecting to your financial institution, check your chart of accounts for the Opening Balance Equity account.

Click on "View register" to see the transactions in the account, and find the opening balance entry for the account you are attempting to reconcile.

Unreconcile that transaction by clicking on the "R" until that field is blank.

Managing Transactions

Managing transactions in QuickBooks Online is a breeze. From the left-hand menu, select Transactions > Bank transactions to view a list of transactions that need your attention.

You can review all transactions for accuracy – dates, amounts, and vendors – and categorize them appropriately. This is a crucial step to ensure that your financial records are accurate and up-to-date.

Credit: youtube.com, How to categorize transactions in QuickBooks Online

To enter a new transaction, click on the drop-down menu immediately beneath the column headers in the check register and select either Check or Deposit. Be sure to click the green Save button when you're finished.

Here's a quick rundown of the key fields to complete for each transaction:

Remember to always reconcile your bank account in QuickBooks to ensure that your financial records are accurate and up-to-date.

How to Manage

Managing transactions in QuickBooks Online is a breeze. You can access the For review tab to see all the transactions that have been imported from your bank feeds that haven't yet been matched, added, or excluded from QuickBooks transactions.

To review these transactions, select For review. You'll see all the transactions that need your attention, and you must review each one for accuracy - dates, amounts, and vendors - and categorize them appropriately.

Bank feeds make bank reconciliation far less time-consuming because all inflow and outflow transactions from your bank are downloaded and imported directly into your accounting software. This allows business owners to reconcile their bank and credit card transactions efficiently.

Credit: youtube.com, Transaction Management Part 1

To prioritize multiple QuickBooks Online bank rules, you'll want to move the most important rule to the top, followed by the second most important rule. This way, QuickBooks Online can apply the correct rule to each transaction.

To import bank transactions into QuickBooks Online, you can use a .csv or .qbo file. This is a convenient way to automate the process and save time.

Here's a quick rundown of the steps to reconcile your bank account in QuickBooks Online:

  • Access the Reconcile page
  • Select an account from the drop-down menu
  • Click Reconcile
  • You can save your progress and return to continue the process later

Enter Transactions

Entering transactions in QuickBooks Online can be a breeze. You can do it directly in the check register or use the input screens, which is often faster and more efficient.

To enter a new transaction in the check register, click on the drop-down menu immediately beneath the column headers and select either Check or Deposit. This will give you a line to input the fields, and don't forget to click the green Save button when you're finished.

See what others are reading: Online Banking with Mobile Check Deposit

Credit: youtube.com, Using Banking Rules and Adding Transactions on QuickBooks Online

You can also import bank transactions into QuickBooks Online using a .csv or .qbo file, which can save you a lot of time.

If you're entering transactions directly in the check register, consider using the input screens for recurring transactions. This will help you avoid entering the same transaction multiple times.

Here are some tutorials to help you input bank transactions using the input screens:

Managing Feeds

Managing feeds in QuickBooks Online is a breeze. From the left-hand menu, select Transactions > Bank transactions to view your cash account and see a list of transactions that need your attention.

You can easily manage your bank feeds by using the sort-and-store function provided by QuickBooks Online. This intuitive feature helps you stay on top of your financial management.

Bank feeds make bank reconciliation a whole lot easier, as they download and import all inflow and outflow transactions from your bank directly into your accounting software.

Creating Rules

Credit: youtube.com, DataFeedWatch Internal Fields - Create your feed rules library

Creating rules in QuickBooks Online is a straightforward process that helps you categorize recurring transactions and make your financial management even more efficient. To start, select New Rule on the top right of your screen.

You'll need to give your rule a description, such as "Cell Phone Bill — US Cellular", in the What do you want to call this rule? field. This will help you identify the rule later on.

In the Apply this to transactions that are section, select Money out if it's an expense or Money in if it's income-related. This will determine whether the rule applies to outgoing or incoming transactions.

You'll also need to choose an associated account option, such as All bank accounts or Cash. This will help QuickBooks Online understand which transactions to apply the rule to.

Now it's time to specify the conditions for your rule. You can choose from three options: Description, Bank text, or Amount. The Description option is great for payees like Amazon, while the Bank text option is useful for transactions with specific details from the bank.

Credit: youtube.com, celebird feed rules

To further specify your rule's parameters, select Contains, Doesn't Contain, or Is Exactly. For example, if you selected Description and Contain and entered Amazon, your rule would apply to every Amazon transaction.

You can also add additional conditions to your rule by selecting Add a condition. This will allow you to apply multiple rules to the same transaction.

Finally, you'll need to decide whether to Assign or Exclude the rule to specific transactions. This will determine whether the rule applies to new transactions or excludes them from your bank feeds moving forward.

If this caught your attention, see: The Journal Entry to Record a Payment on Account Will

Managing Feeds

Managing bank feeds is a crucial aspect of financial management, and QuickBooks Online makes it easy. From the left-hand menu, select Transactions > Bank transactions to view your cash account.

You'll see a list of transactions that need your attention, making it simple to manage your bank feeds. This list will give you a clear overview of your business's financial activity.

A Person Holding a Bank Card
Credit: pexels.com, A Person Holding a Bank Card

Bank feeds can be imported into QuickBooks Online using a .csv or .qbo file, saving you time and effort compared to manually entering transactions. This feature is especially useful for business owners with multiple bank accounts or credit cards.

Bank reconciliation is a critical accounting process that ensures accuracy and timeliness, and bank feeds make it far less time-consuming. By importing transactions directly into your accounting software, you can focus on other business duties and responsibilities.

Expand your knowledge: Online Business Ideas

Reconcile Your Accounts

Reconciling your bank accounts in QuickBooks Online is a crucial step in ensuring your financial records are accurate and up-to-date. You should do this on a monthly basis, as soon as your bank statement becomes available.

The Reconcile page can be accessed in two ways: by clicking on Summary, which shows a list of past reconciliations and their dates, or by clicking on History by Account, which shows the same list along with any changes or auto-adjustments made by QuickBooks.

Credit: youtube.com, QuickBooks Online: How to Reconcile your Bank

You can view a list of past reconciliations and the dates they were completed by clicking on Summary. This will help you keep track of your reconciliation history.

Reconciling your bank account helps you ensure that you've accounted for everything you've spent and earned in the prior month and haven't missed anything. During the reconciliation process, you may discover potential issues, such as less money in your account than you thought or fraudulent transactions.

To start the reconciliation process, select the account you want to reconcile from the drop-down menu on the Reconcile page. You can save your progress and return to continue with the process later if needed.

Here are the two ways to access the Reconcile page:

• Click on Summary to view a list of past reconciliations and their dates.

• Click on History by Account to view the same list along with any changes or auto-adjustments made by QuickBooks.

Aaron Osinski

Writer

Aaron Osinski is a versatile writer with a passion for crafting engaging content across various topics. With a keen eye for detail and a knack for storytelling, he has established himself as a reliable voice in the online publishing world. Aaron's areas of expertise include financial journalism, with a focus on personal finance and consumer advocacy.

Love What You Read? Stay Updated!

Join our community for insights, tips, and more.