How to Enter Opening Balances in QuickBooks Online - Gentle Frog Bookkeeping and Custom Training (2024)

  • July 27, 2023

How to Enter Opening Balances in QuickBooks Online - Gentle Frog Bookkeeping and Custom Training (1)

Rachel Barnett

In this post, I’ll show you how to enter accounts and opening balances in QuickBooks Online.

Quick Instructions:

Add accounts:

  1. Click Accounting -> Chart of accounts
  2. Click the New button
  3. Fill in the New account screen (DO NOT fill in Starting date and opening balance)

Enter Opening Balance if Owner’s Contribution

  1. In the Chart of accounts click View register for the account
  2. Click the Add drop-down and select deposit
  3. Under DEPOSIT enter the opening balance amount
  4. Under ACCOUNT select Owner’s Contribution
  5. Click Save

Enter Opening Balances with Trial Balance

  1. Click +New in the upper left
  2. Under OTHER click Journal entry
  3. Enter Journal date as the date on the Trial Balance
  4. Enter the information into the journal entry as it appears on the trial balance
  5. Click Save and close

Keep reading for a complete walkthrough with screenshots:

Add a Bank Account to the Chart of Accounts

First, let’s navigate to the chart of accounts by clicking Accounting in the left-side menu and selecting Chart of accounts.

To add a new account click the green New button in the upper right.

The New account pop-up will appear. Select Bank from the account types across the top.

In the Save account under drop-down select Bank Accounts.

Tax form section is required but doesn’t actually matter, pick whatever you’d like.

Under Account name you’ll name your account. A good rule of thumb is to use the type of account, and the bank name. Example: Checking at Wells Fargo Bank. You can also add the last four digits of the account number if you have more than one account of that type at that bank.

I strongly discourage you from adding a Starting date and opening balance. That will add it as Opening Balance Equity, which is not what we want for this account.

Click the green Save button at the bottom when you’re done.

Next, we’ll add the opening balance. The method used will depend on whether or not this is a new or existing business. If it’s a brand new business use the Owner’s Contribution method. If it’s an existing business you’ll have trial balances so you’ll use that method.

Enter Opening Balance if Owner’s Contribution

Once you save your bank account it will appear in your Chart of accounts. Click the View register link on the right to open the bank register for the account.

To add the opening balance click the drop-down that says Add check and deposit.

Under DEPOSIT enter the amount of the opening balance. Under ACCOUNT select Owner’s Contribution.

Click the green Save button.

Enter Opening Balances With Trial Balance

If you have a Trial Balance you’ll enter the opening balances as a journal entry. This is something you’ll be doing for all the accounts on the Trial Balance, not for a single account.

If you don’t know what a Trial Balance is, it’s a report with debits and credits for your accounts.

Here’s what this report looks like in QuickBooks:

To add the journal entry click the +New button in the upper left corner. Under OTHER click Journal entry.

The Journal date should be the date on the Trial Balance.

Then enter the accounts and debits and credits as it appears on the Trial Balance, then click Save and close.

You now know how to add new accounts and opening balances to QuickBooks Online.

☕ If you found this helpful you can say “thanks” by buying me a coffee… https://www.buymeacoffee.com/gentlefrog

Below is a video if you prefer to watch a walkthrough of how to do this.

If you have questions about adding accounts and opening balances in QuickBooks Online click the green button below to schedule a free consultation.

How to Enter Opening Balances in QuickBooks Online - Gentle Frog Bookkeeping and Custom Training (11)

Need some one-on-one QuickBooks assistance?

Schedule a FREE Consultation

Share Now

This content is for information purposes only and should not be considered legal, accounting, or tax advice, or a substitute for obtaining such advice specific to your business. Additional information and exceptions may apply. Applicable laws may vary by state or locality. No assurance is given that the information is comprehensive in its coverage or that it is suitable in dealing with a customer’s particular situation. Gentle Frog, LLC does not have any responsibility for updating or revising any information presented herein. Accordingly, the information provided should not be relied upon as a substitute for independent research. Gentle Frog, LLC does not warrant that the material contained herein will continue to be accurate, nor that it is completely free of errors when published. Readers and viewers should verify statements before relying on them.

How to Enter Opening Balances in QuickBooks Online - Gentle Frog Bookkeeping and Custom Training (12)

How to Fix a Credit Card Incorrectly Added to QuickBooks Online as a Bank Account

Did accidently add your credit card to QBO as a bank account? Learn how to fix it in this blog post.

  • Rachel Barnett
  • September 5, 2024

How to Enter Opening Balances in QuickBooks Online - Gentle Frog Bookkeeping and Custom Training (13)

How to Use Bookmarks With QuickBooks Online

Learn how bookmarks can make working with QuickBooks a little easier.

  • Rachel Barnett
  • September 2, 2024

How to Enter Opening Balances in QuickBooks Online - Gentle Frog Bookkeeping and Custom Training (14)

How to Access the QuickBooks Online Sample File For Testing

Learn how to access the QuickBooks Online test file, Craig's Design and Landscaping.

  • Rachel Barnett
  • August 29, 2024
How to Enter Opening Balances in QuickBooks Online - Gentle Frog Bookkeeping and Custom Training (2024)

FAQs

How to Enter Opening Balances in QuickBooks Online - Gentle Frog Bookkeeping and Custom Training? ›

Opening balances when starting an accounting

Enter the opening balances of the Assets and Liabilities accounts manually. Liabilities are to be entered preceded by the minus sign. Check if the total Assets equal the total Liabilities so that your accounting squares.

How to enter opening balances in QuickBooks Online? ›

Enter an opening balance
  1. Go to Settings ⚙ and select Chart of accounts (Take me there).
  2. Select New, then set up your account.
  3. In the Opening balance field, add the balance reflecting your bank or credit card account. ...
  4. Select the date you want to start tracking your finances in the As of field. ...
  5. Select Save.

How do you record opening balance? ›

Opening balances when starting an accounting

Enter the opening balances of the Assets and Liabilities accounts manually. Liabilities are to be entered preceded by the minus sign. Check if the total Assets equal the total Liabilities so that your accounting squares.

How to get the opening balance? ›

The opening balance is calculated by taking the amount of cash present on the first day of the month and adding any total income minus total expenses from the previous period.

What if I forgot to enter opening balance in QuickBooks Online? ›

What to do if you didn't enter an opening balance in QuickBooks Online
  1. Go to the Gear icon ( ) and select Chart of Accounts.
  2. Find your account and then go to the Action column and click on View register.
  3. Select the Opening balance entry to edit the amount.
  4. Click on Save once you're done.
Jul 3, 2023

What is the journal entry for opening balance? ›

The journal entry is recorded at the beginning of an accounting period for opening the books of accounts. It supports bringing forth the balances in the ledger accounts and is called the opening entry. The opening entry for the ledger account is based on the opening balance sheet.

When should you enter opening balances? ›

Bank opening balances should be dated before the date entered in the Accounts Start Date field. For example, if the start date is October 1, you should use September 30 as the opening balance date.

What is an example of an opening balance? ›

The opening balance is the first entry in the company's accounts when it first begins trading and at the start of each new accounting period. For example, Steven runs a painting and decorating company. He has a balance of £3,500 in his business account on 31 December, the end of his accounting year.

How do you set up an opening balance sheet? ›

The first step in preparing an opening day balance sheet for new businesses is collecting data on all assets and liabilities. This includes cash, accounts receivable, inventory, equipment, buildings, vehicles, debt obligations such as loans or credit cards, and other investments or liabilities.

How do I customize my balance sheet in QuickBooks Online? ›

Go to Reports (Take me there). In the search bar, search for and open Balance Sheet Comparison. Select Customize. Under Rows/Columns, select the Columns dropdown, then change it to the desired comparison period.

How do I fix the incorrect beginning balance in QuickBooks Online? ›

If the opening balance in QuickBooks doesn't match your bank records, correct it:
  1. In QuickBooks, select the opening balance entry to expand the view.
  2. In the Deposit column, edit the balance so it matches your bank records.
  3. Select Save.

Why do I have a beginning balance in QuickBooks Online? ›

When you create a new account in QuickBooks Online, you pick a day to start tracking transactions and enter the balance for your real-life account for that day. This starting point is the opening balance.

What does open balance mean in QuickBooks? ›

In QuickBooks, an open balance refers to the amount that a customer or vendor owes you or that you owe them. A negative open balance means that you owe the customer or vendor the amount indicated.

How do you enter an opening trial balance? ›

Enter each opening balance as a debit or credit to the relevant category. If you're unsure which opening balances you need to enter, please ask your accountant. The debit and credit balances of the opening balances should be equal if you're entering them fully.

What is the opening entry? ›

Opening entry is referred to as the first entry that is recorded or which is brought forward from a previous accounting period to the new accounting period. In an ongoing business, the closing balance of the previous accounting period serves as an opening balance for the current accounting period.

What is one way opening balances can be entered into a converted QBO company file? ›

One way opening balances can be entered into a converted QBO (QuickBooks Online) company file is by entering them on the Balance Sheet. So, the correct answer is C. on the Balance Sheet. The Balance Sheet is a financial statement that provides a snapshot of a company's financial position at a specific point in time.

How do I write off an open balance in QuickBooks online? ›

  1. From the Vendors menu, select Pay Bills.
  2. Choose the bill that has the balance that you need to write off.
  3. Select Set Discount.
  4. Select the Discount tab. Enter the amount in the Amount of Discount field. ...
  5. Select Pay Selected Bills to close the Pay Bills window.
  6. Select Done in the Payment Summary window.

How to add a beginning balance for a loan in QuickBooks Online? ›

How do i enter opening balance for loan?
  1. Make sure you know the amount you need to enter for your opening balance.
  2. Go to Settings and select Chart of accounts.
  3. Click New, then set up your account.
  4. In the open balances section, pick the start date for tracking your finances, then enter the balance.
  5. Tap Save.
Mar 19, 2023

Top Articles
How Soon Can I Refinance My House? - Experian
How do credit cards on file work? | Stripe
Sdn Md 2023-2024
Ads Supplier Portal
Amazon Ups Drop Off Locations Near Me
How To Find Free Stuff On Craigslist San Diego | Tips, Popular Items, Safety Precautions | RoamBliss
Nsfw Otp Prompt Generator Dyslexic Friendly
Gopher Hockey Forum
Unblocked Games6969: A World Of Unrestricted Gaming Fun - Unblocked Hub
Seat Number Usana Seating Chart With Rows
That Is No Sword Tanjiro X Kakushi
Huffington Horoscope Cancer
Amaya Hodges Missing
2024 Fantasy Basketball Rankings, News and Draft Kit
Lynn Gruson
Hrconnect Kp Login
Generation Zero The Gas Factory Key Location
Www Dermpathdiagnostics.com/Pay-Invoice
Dupage County Fcrc
Elevating security and disease forecasting in smart healthcare through artificial neural synchronized federated learning
Why Do Two Porsche Bucket Seats Cost More Than An Entire Boxster And An Entire Cayenne Combined? - The Autopian
Ll94 Pill
Poochies Liquor Store
Ruthless Rs3
What To Expect When Moving With a U-Haul Trailer (2024)
Harbin Clinic Immediate Care
Tutorial - PyMuPDF 1.24.10 documentation
Unblocked Games Amazon
Kitco 24 Hour Gold
Crazy Stupid Love 123Movies
Prey For The Devil Showtimes Near Phoenix Theatres Kennedy Mall
Soap2Day That 70S Show
Skyward Riverton Il
Strange World Showtimes Near Blackstone Valley 14 Cinema De Lux
Mchoul Funeral Home Of Fishkill Inc. Services
Espn Forecaster
Bhcu Login
Telegram Scat
Drumlin Farm Birthday Party
Julie Green Ministry On Rumble
Rocky Covington Amway Passed Away
Backoffice.paperpie
‘Frontera Madre(hood)’ examines the different aspects of motherhood on the southern border
28 Box St
Spartan 365 - Email and Microsoft Office
1996 Suzuki Cappuccino for sale by owner - Birmingham, AL - craigslist
Ap Spanish Score Calculator
Epguides Fear The Walking Dead
Directions Food Lion
Craigslist Woodward
Ssndob Cm New Domain
Maewing Saddle Command
Latest Posts
Article information

Author: Jeremiah Abshire

Last Updated:

Views: 6461

Rating: 4.3 / 5 (54 voted)

Reviews: 93% of readers found this page helpful

Author information

Name: Jeremiah Abshire

Birthday: 1993-09-14

Address: Apt. 425 92748 Jannie Centers, Port Nikitaville, VT 82110

Phone: +8096210939894

Job: Lead Healthcare Manager

Hobby: Watching movies, Watching movies, Knapping, LARPing, Coffee roasting, Lacemaking, Gaming

Introduction: My name is Jeremiah Abshire, I am a outstanding, kind, clever, hilarious, curious, hilarious, outstanding person who loves writing and wants to share my knowledge and understanding with you.