HomeBusiness

How To Enter Bank Transactions in QuickBooks Online Manually

How To Enter Bank Transactions in QuickBooks Online Manually

In this tutorial, we’ll show you how to enter bank transactions manually in QuickBooks Online. You’ll learn how to enter bank transactions directly in

PNC Bank Business Checking Review 2022
Wells Fargo Bank Business Checking Review 2022
Best Bank of America Business Credit Cards for 2022

This post may contain affiliate links, which means that I may earn a commission if you click on the link & sign-up or make a purchase. You will NOT be charged extra for using the link, but it goes a long way in supporting this blog. I only recommend products or services that I have personally used or believe will add value to my readers.

In this tutorial, we’ll show you how to enter bank transactions manually in QuickBooks Online. You’ll learn how to enter bank transactions directly in the check register as well as how to modify any of the information you entered. We also discuss why it’s usually not a good idea to enter bank transactions directly into the check register unless the need arises for quick data entry.

This free tutorial aims to help you use QuickBooks Online effectively, which we rank our best overall pick for small business accounting software. To make the most out of this guide, we recommend following along in your own QuickBooks account. If you haven’t subscribed to QuickBooks yet, you can choose from a 30-day free trial or 50% off for three months.

Visit QuickBooks Online

This tutorial is one in our series of Free QuickBooks Tutorials. You can watch the video below or read the step-by-step illustrated instructions that follow.

Select Accounting in the left menu bar of your QuickBooks Online dashboard, and then click Chart of Accounts to display your chart of accounts list.

Navigate to Chart of Accounts in QuickBooks Online.

Navigate to Chart of Accounts in QuickBooks Online


Find your bank account in the chart of accounts and click on View register in the far right column. In the screenshot below, we’re going to input transactions for Paul’s Plumbing’s checking account with Bank of America.

View checking account register in QuickBooks Online.

View checking account register in QuickBooks Online


All transactions affecting your bank balance will be reflected in the check register, regardless of whether you entered the transactions directly in the register, entered them through the appropriate input screen, or accepted them from your list of imported bank transactions. We highly recommend you complete all fields for each transaction, but the only fields required are Date, Amount, Type, and Account.

Check register in QuickBooks Online.

Check register in QuickBooks Online

  1. Bank register: This field displays which bank account register you’re viewing. You can switch bank accounts by clicking the drop-down arrow and selecting a different bank account.
  2. Date: Indicate the date of the transaction you’re inputting.
  3. Ref no./type: Enter the transaction number, such as the check number, as the reference number. The transaction type is selected when you create a new transaction and will appear here.
  4. Payee: For payments, select the vendor or employee for this field. For deposits, select the customer.
  5. Account: Choose the account from the chart of accounts where the payment or deposit should be characterized. For example, if you’re entering a check to pay the monthly rent, choose the rent expense.
  6. Memo: Provide a brief description of the transactions. For example, “July rent check.”
  7. Class/Location: Assign the transaction to your user-defined Classes and Locations. If these fields don’t appear (and you want to track activity by Class or Location), you need to activate Track Classes and/or Locations, as shown in How To Set Up Advanced Settings in QuickBooks Online.
  8. Foreign Currency Exchange Rate: For foreign currency transactions, you can set your own currency exchange rate or let QuickBooks Online apply exchange rates automatically.
  9. Payment: Enter the amount of the check or leave it blank for a deposit.
  10. Deposit: Enter the amount of the deposit or leave it blank for a check.
  11. Reconciled: A checkmark will appear in the column once you indicate the transaction has cleared your bank during the bank reconciliation. Don’t add or remove a checkmark manually. To keep your records accurate, we recommend that you always reconcile your bank account.
  12. Balance: This is the account balance after each transaction.

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. There are many other types of bank transactions that will flow from input screens, but everything input directly in the check register can only be designated as either a check or deposit.

Short video on Create a new check or deposit in QuickBooks Online.

Create a new check or deposit in QuickBooks Online

The register will now provide a line for you to input the fields as described above. Be sure to click the green Save button when you’re finished.

Click Save to record your bank transaction.

Click Save to record your bank transaction

Tip:

Never enter a payment received from a customer for an outstanding invoice as a deposit, or a payment made to a vendor on an outstanding bill as a check. Doing so will double-count income or expense rather than offset the outstanding invoice or bill. You can learn the correct way to enter these transactions in our tutorials How To Receive Payments in QuickBooks Online and How To Pay Bills in QuickBooks Online.


How To Modify Bank Transactions in QuickBooks Online

In the bank register, highlight the transaction you want to modify. This will enable you to change any of the information you input in the register. You can go to the input screen to add or change additional information by clicking Edit, as shown below.

Click Edit to modify a bank transaction from the check register in QuickBooks Online.

Click Edit to modify a bank transaction from the check register in QuickBooks Online

When To Consider Entering Bank Transactions Directly in the Check Register

Entering transactions in the check register is considerably faster than using the input screens. You might consider entering transactions directly in the register if you’re doing last year’s bookkeeping. For instance, if you’re doing the 2021 bookkeeping in March 2022, it’ll be faster to enter all bank transactions as checks and deposits in the check register.

However, if you’re using Quickbooks to manage your company throughout the year, we highly recommend avoiding entries directly to your check register, as discussed next.

Why You Should Not Enter Bank Transactions Directly in the Check Register

Unless you’re entering a lot of data and only care about classifying income and expenses, it’s not a good idea to enter bank transactions directly in the check register.

One of the strengths of QuickBooks Online is the use of easy-to-understand screens for inputting transactions. These input screens provide fields for all the information QuickBooks needs to account for the transactions properly and provide in-depth reporting. The check register doesn’t provide all the necessary fields. For instance, the check register doesn’t provide fields for:

  • Items: The check register doesn’t allow you to assign transactions to Items in your products and services list. The register only allows assigning amounts directly to an account, sometimes called a category in QuickBooks Online. Any purchase or sale of inventory must be assigned to the correct Inventory Item for QuickBooks Online to track your inventory quantity and cost. Any sale of services should be assigned to the correct Service Item so that QuickBooks Online can provide a helpful breakdown of your revenue by service.
  • Multiple accounts: The entire bank transaction recorded in the check register must be assigned to a single account. Amounts recorded through the proper input screens can be assigned to any combination of multiple accounts and items.
  • Customer/project: Amounts entered in the check register cannot be assigned to a customer or project, which prevents QuickBooks Online from preparing accurate profit and loss reports by customer or project.
  • Billable/markup: An expense entered in the check register cannot be classified as billable, and a markup percentage cannot be provided. It’s vital to mark expenses that will be billed to a customer as “billable” so that the expense is available to add to the customer invoice.

In addition, checks added manually to the register cannot be applied against outstanding bills from the vendor. Similarly, payments received from a customer cannot be applied against their invoice if you enter the deposit in the check register.

Transactions entered in the input screens will flow automatically to the check register. If you’ve already entered a transaction in the check register, you can open the appropriate input screen by selecting the transaction in the register and clicking Edit. Below is a list of our tutorials that demonstrate the best way to input bank transactions using the input screens.

Wrap Up

You’ve completed another tutorial in our QuickBooks Online Training Course. You’ve learned why it’s not recommended to enter bank transactions directly into the check register, but also how to do so if the need arises. The next tutorial in our QuickBooks Online Training Course is How to Manage QuickBooks Online Bank Feeds. That tutorial will teach you how to accept imported bank transactions as well as how to match them to existing transactions within QuickBooks Online.

COMMENTS

WORDPRESS: 0
    error: Content is protected !!