Enter opening balances for accounts in QuickBooks Desktop (2024)

by Intuit2 Updated 2 months ago

Learn how to enter an opening balance for a bank, credit card, and other types of accounts.

When you create a new account in QuickBooks Desktop, pick a day to start tracking all of your transactions. You enter the balance of your real-life bank account for the day you pick. This way, QuickBooks matches your bank records from the start.

This starting point is the account's opening balance. It summarizes all the past transactions that came before it. Here's how to enter an opening balance for accounts you create in QuickBooks.

Step 1: Enter an opening balance

Follow the steps for the type of account the opening balance is for:

Bank or credit card accounts

Before you create a new account on your QuickBooks Chart of Accounts, make sure you know what to enter for your opening balance.

You can enter an opening balance for a real-life bank account you just created, or one you've had for a while.

  1. Get your bank statements or sign in to your bank's website.
  2. In QuickBooks Desktop, go to the Company menu and then select Chart of Accounts.
  3. Right-click anywhere on your Chart of Accounts and select New.
  4. SelectBank or Credit Card for the account type. Then select Continue.
    Enter opening balances for accounts in QuickBooks Desktop (1)
  5. Give your account a name. If you have multiple accounts of the same type or at the same bank, give them unique names so they're easy to tell apart.
  6. Fill out the rest of the data fields.
  7. Select Enter Opening Balance. Later on, if you need to edit your opening balance, the button will be Change Opening Balance.Enter opening balances for accounts in QuickBooks Desktop (2) What you enter as the opening balance depends on how you want to handle your past transactions:
    1. If you don't plan to enter older transactions that come before the opening balance date in QuickBooks: Enter the ending balance and ending date from your most recent bank statement. Then select OK. This summarizes all of your past transactions. You'll start tracking new transactions going forward.
    2. If you want to enter your past transactions in detail: Decide how far back you want to go. Pick a date that's older than the oldest transaction you want to track in QuickBooks. Your opening balance summarizes everything before the date you pick.Enter the date you picked in the Ending date field. In the Ending balance field, enter the balance of your real-life account for that date. Then select OK. This method prevents you from counting past transactions twice.
  8. When you're done, select Save & Close to record the opening balance.

If you have pending transactions for your real-life bank or credit card accounts, don't worry. Once you have your bank statement and the pending transactions clear the bank, come back and adjust your opening balance entry.

  1. Get your bank statement or sign in to your bank's website.
  2. In QuickBooks, go to the Company menu and select Chart of Accounts.
  3. Find and right-click the account and select Edit.
  4. Select Change Opening Balance.
  5. Edit the amount. You can also adjust the date.
  6. When you're ready, select Record to save your changes.

Asset, liability, and other types of accounts

You can enter an opening balance for a real-life bank account you just created, or one you've had for a while.

Be careful entering the opening balances for accounts on your Balance Sheet. This includes Fixed Assets, Equity, Long-term Liability, Other Assets, Other Current Assets, and Other Current Liability accounts.

If you're unsure or have questions, reach out to your accountant. If you don't have an accountant, we can help you find one:

  1. Get your bank statements or sign in to your bank's website.
  2. In QuickBooks Desktop, go to the Company menu and then select Chart of Accounts.
  3. Right-click anywhere on your Chart of Accounts and select New.
  4. Select Fixed Asset, Loan, or Equity. For other types of accounts, select the Other Account Types drop-down and one of the types. Then select Continue.
    Enter opening balances for accounts in QuickBooks Desktop (3)
  5. Give your account a name. If you have multiple accounts of the same type or at the same bank, give them unique names so they're easy to tell apart.
  6. Fill out the rest of the data fields.
  7. Select Enter Opening Balance. Later on, if you need to edit your opening balance, the button will be Change Opening Balance.What you enter for the opening balance depends on how you want to handle your past transactions:
    1. If you don't plan to enter older transactions that come before the opening balance date in QuickBooks: Enter the ending balance and ending date from your most recent bank statement. Then select OK. This summarizes all of your past transactions. You'll start tracking new transactions going forward.
    2. If you want to enter your past transactions in detail: Decide how far back you want to go. Pick a date that's older than the oldest transaction you want to track in QuickBooks. Your opening balance summarizes everything before the date you pick. Enter the date you picked in the Ending date field. In the Ending balance field, enter the balance of your real-life account for that date. Then select OK. This method prevents you from counting past transactions twice.
  8. When you're done, select Save & Close to record the opening balance.

As an alternative to the main method, you can enter the opening balance as a journal entry. This can be complicated. We encourage you to work with your accountant if you decide to do this:

  1. Go to the Company menu and select Make General Journal Entries.
  2. Set the date for the journal entry. It should be the date you pick for the opening balance.
  3. On the first line, from the Account drop-down, select the account you're entering the opening balance for.
  4. Enter the balance for your real-life accounts for the day you picked. Depending on the type of account:
    1. Asset: Enter the opening balance in the Debit column.
    2. Liability and Equity: Enter the opening balance in the Credit column.
  5. On the next line, select the Account drop-down and then the Opening Balance Equity account.
  6. Enter the same opening balance amount in the opposite column as the first line. So, if you entered the first amount in the Credit column, enter the next one in the Debit column.
  7. When you're done, select Save & Close.

Create additional journal entries to enter accounts receivable, accounts payable, sales tax payable, and anything else that wasn't included in the initial journal entry.

If there's a left-over balance in the Opening Equity account, it should go to other equity accounts or retained earnings. Work with your accountant to move this money correctly.

Income and expense accounts

You don't need to enter opening balances for income or expense accounts. These accounts simply track your earnings and spending.

Customer or vendor balances in Accounts Payable and Accounts Receivable

If your customers or vendors have outstanding balances from before your opening balance date, enter the individual unpaid invoices or bills. This creates open balances that collectively result in your Accounts Payable and Accounts Receivable opening balances.

Step 2: Check the opening balance entry

After you enter the opening balance, go to your account register and make sure it's accurate. The Opening Balance Equity account shouldn't have a remaining balance.

  1. Go to theLists menu and selectChart of Accounts.
  2. Search for and open theOpening Balance Equity account.
  3. Check the account balance. It should be0.00.

If the balance isn't 0.00, don't worry. Write down the remaining balance. Then run a Balance Sheet Report for last year.

  1. Go toReports and hover overCompany & Financial.
  2. SelectBalance Sheet Standard.
  3. From theDates dropdown, selectLast Fiscal Year.
  4. In the Equity section, check theRetained Earnings balance.
  5. Compare last year's Retained Earnings balance with the remaining balance in the Opening Balance Equity account.

If they match, you're good to go. Everything is balanced. If they don't match,reach out to your accountant. They know how to get your accounts back in balance.

QuickBooks Desktop AccountantQuickBooks Desktop Accountant PlusQuickBooks Desktop PremierQuickBooks Desktop ProQuickBooks Enterprise QuickBooks Enterprise AccountantQuickBooks Enterprise Accountant QuickBooks Enterprise DiamondQuickBooks Enterprise GoldQuickBooks Enterprise Platinum

Enter opening balances for accounts in QuickBooks Desktop (2024)

FAQs

How do you enter opening balances for accounts in QuickBooks desktop? ›

Go to the Company menu and select Make General Journal Entries. Set the date for the journal entry. It should be the date you pick for the opening balance. On the first line, from the Account drop-down, select the account you're entering the opening balance for.

What happens if you didn t enter an opening balance in QuickBooks Desktop? ›

If you forgot to enter an opening balance when you created an account, don't worry. You can go back later and create a journal entry to record it. Then you can get back to business as usual. Important: Only use this method if you haven't reconciled the account yet.

How to fix opening balance equity in QuickBooks desktop? ›

Correct a zero balance
  1. Go to Company, and then select Make General Journal Entries.
  2. Change the date to the correct statement date of your beginning balance.
  3. Select the account you want from the Account dropdown.
  4. Enter the correct opening balance in the Debit column.
  5. Select Opening Balance Equity and then select Save.

What information do you need to enter opening balances in accounting? ›

To enter your opening balances, you need a list of your outstanding customer and vendor invoices and credit notes, your closing trial balance from your previous accounting period, and your bank statements. You also need a list of the unrepresented bank items from your previous accounting system.

Which accounts have opening balances? ›

If you are looking at a trial balance on the first day of a new accounting year, it will show opening balances only for the balance sheet accounts, i.e. the asset accounts and liability accounts.

What is the journal entry of 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.

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

What to do if you didn't enter an opening balance in QuickBooks Online
  1. Step 1: Make sure you don't already have an opening balance. Before you go further, check your account register. ...
  2. Step 2: Create a journal entry. ...
  3. Step 3: Mark the journal entry as reconciled.

How to fix beginning balance in QuickBooks Desktop reconciliation? ›

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.

How do I get rid of opening balance in QuickBooks? ›

Remove an open customer balance.
  1. Sign in to your QuickBooks Online (QBO) account and navigate to the + New menu.
  2. Click Journal entry.
  3. In the first line, select Accounts Receivable A/R under the ACCOUNT column.
  4. Enter the amount under the DEBITS column and select the name of the customer name under the NAME column.
May 12, 2021

What causes a large amount in the opening balance equity account in QuickBooks? ›

Another possible cause, as mentioned, is adding a new vendor or customer entry to your records, along with value balances (e.g., outstanding balances). Without corresponding entries in other accounts to offset these balances, QuickBooks may create balancing entries in the OBE account.

How do you zero out opening balance equity? ›

Bringing an Opening Balance Equity Account to Zero

Here's the most common method: If your company is a corporation: Close out the balance equity to “Retained Earnings.” If your company is a sole proprietorship: Close out the balance equity to “Owner's Equity.”

How do I write off open balance in QuickBooks desktop? ›

Choose the bill that has the balance that you need to write off. Select Set Discount. Enter the amount in the Amount of Discount field. Select Minor A/R and A/P Charge-Off in the Discount Account field.

How to enter opening balances in QuickBooks desktop? ›

Go to the Company menu and select Make General Journal Entries. Set the date for the journal entry. It should be the date you pick for the opening balance. On the first line, from the Account drop-down, select the account you're entering the opening balance for.

What is the formula for 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 are the two basic accounting rules for account balances? ›

The two basic accounting rules are 1) Account balances increase on the normal balance side of the account. 2)Account balances decrease on the opposite side of the normal balance side of the account.

How to show account balances on in QuickBooks Desktop Home page? ›

Account Balances on Home Page
  1. On the top menu bar, click View.
  2. Select Open window list.
  3. Click View again, then click Left Icon Bar.
  4. On the left side of your home page. Click View Balances.
  5. Tick Customize view balances.
  6. Select any account you want to add, then tap OK.
May 14, 2024

Top Articles
Delta Sky Priority: What You Need to Know - NerdWallet
Top 50 Financial News Websites in 2024
Katie Pavlich Bikini Photos
Gamevault Agent
Hocus Pocus Showtimes Near Harkins Theatres Yuma Palms 14
Free Atm For Emerald Card Near Me
Craigslist Mexico Cancun
Hendersonville (Tennessee) – Travel guide at Wikivoyage
Doby's Funeral Home Obituaries
Vardis Olive Garden (Georgioupolis, Kreta) ✈️ inkl. Flug buchen
Select Truck Greensboro
Things To Do In Atlanta Tomorrow Night
How To Cut Eelgrass Grounded
Pac Man Deviantart
Alexander Funeral Home Gallatin Obituaries
Craigslist In Flagstaff
Shasta County Most Wanted 2022
Energy Healing Conference Utah
Testberichte zu E-Bikes & Fahrrädern von PROPHETE.
Aaa Saugus Ma Appointment
Geometry Review Quiz 5 Answer Key
Walgreens Alma School And Dynamite
Bible Gateway passage: Revelation 3 - New Living Translation
Yisd Home Access Center
Home
Shadbase Get Out Of Jail
Gina Wilson Angle Addition Postulate
Celina Powell Lil Meech Video: A Controversial Encounter Shakes Social Media - Video Reddit Trend
Walmart Pharmacy Near Me Open
Dmv In Anoka
A Christmas Horse - Alison Senxation
Ou Football Brainiacs
Access a Shared Resource | Computing for Arts + Sciences
Pixel Combat Unblocked
Cvs Sport Physicals
Mercedes W204 Belt Diagram
Rogold Extension
'Conan Exiles' 3.0 Guide: How To Unlock Spells And Sorcery
Teenbeautyfitness
Weekly Math Review Q4 3
Facebook Marketplace Marrero La
Nobodyhome.tv Reddit
Topos De Bolos Engraçados
Gregory (Five Nights at Freddy's)
Grand Valley State University Library Hours
Holzer Athena Portal
Hampton In And Suites Near Me
Stoughton Commuter Rail Schedule
Bedbathandbeyond Flemington Nj
Free Carnival-themed Google Slides & PowerPoint templates
Otter Bustr
Selly Medaline
Latest Posts
Article information

Author: Horacio Brakus JD

Last Updated:

Views: 5697

Rating: 4 / 5 (51 voted)

Reviews: 90% of readers found this page helpful

Author information

Name: Horacio Brakus JD

Birthday: 1999-08-21

Address: Apt. 524 43384 Minnie Prairie, South Edda, MA 62804

Phone: +5931039998219

Job: Sales Strategist

Hobby: Sculling, Kitesurfing, Orienteering, Painting, Computer programming, Creative writing, Scuba diving

Introduction: My name is Horacio Brakus JD, I am a lively, splendid, jolly, vivacious, vast, cheerful, agreeable person who loves writing and wants to share my knowledge and understanding with you.