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
VC ROI Expectations for Different Series
Dark Mode: All the Pros and Cons to Consider
Jazmen Jafar Linkedin
Coverage of the introduction of the Water (Special Measures) Bill
Jailbase Orlando
Affidea ExpressCare - Affidea Ireland
Jesus Calling December 1 2022
Doublelist Paducah Ky
Puretalkusa.com/Amac
David Packouz Girlfriend
Bc Hyundai Tupelo Ms
Echo & the Bunnymen - Lips Like Sugar Lyrics
Craigslist Apartments In Philly
Xomissmandi
Parent Resources - Padua Franciscan High School
Dtab Customs
Virginia New Year's Millionaire Raffle 2022
Hollywood Bowl Section H
[Cheryll Glotfelty, Harold Fromm] The Ecocriticism(z-lib.org)
Tips on How to Make Dutch Friends & Cultural Norms
Craigslist Lewes Delaware
Joan M. Wallace - Baker Swan Funeral Home
Village
About My Father Showtimes Near Copper Creek 9
Encyclopaedia Metallum - WikiMili, The Best Wikipedia Reader
Surplus property Definition: 397 Samples | Law Insider
Bidrl.com Visalia
Geico Car Insurance Review 2024
Netspend Ssi Deposit Dates For 2022 November
Umn Biology
Darknet Opsec Bible 2022
Ilabs Ucsf
The Best Carry-On Suitcases 2024, Tested and Reviewed by Travel Editors | SmarterTravel
How to Play the G Chord on Guitar: A Comprehensive Guide - Breakthrough Guitar | Online Guitar Lessons
Helloid Worthington Login
Carespot Ocoee Photos
Zero Sievert Coop
Watchseries To New Domain
Los Garroberros Menu
Rage Of Harrogath Bugged
Top 25 E-Commerce Companies Using FedEx
O'reilly's Palmyra Missouri
Atu Bookstore Ozark
Suntory Yamazaki 18 Jahre | Whisky.de » Zum Online-Shop
Gw2 Support Specter
The Many Faces of the Craigslist Killer
Tropical Smoothie Address
Sc Pick 3 Past 30 Days Midday
Meee Ruh
Michaelangelo's Monkey Junction
4015 Ballinger Rd Martinsville In 46151
Www Extramovies Com
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.