QuickBooks HelpQuickBooksHelpIntuit

Enter opening balances for accounts in QuickBooks Desktop

by Intuit7 Updated 5 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. Select Bank or Credit Card for the account type. Then select Continue.
    Select 
  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  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
    Select
  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 the Lists menu and select Chart of Accounts.
  2. Search for and open the Opening Balance Equity account.
  3. Check the account balance. It should be 0.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 to Reports and hover over Company & Financial.
  2. Select Balance Sheet Standard.
  3. From the Dates dropdown, select Last Fiscal Year.
  4. In the Equity section, check the Retained 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 Accountant Desktop 2021QuickBooks Accountant Desktop PlusQuickBooks Desktop Enterprise AccountantQuickBooks Desktop Enterprise Accountant 21QuickBooks Desktop Enterprise DiamondQuickBooks Desktop Enterprise Diamond 2021QuickBooks Desktop Enterprise GoldQuickBooks Desktop Enterprise Gold 2021QuickBooks Desktop Enterprise PlatinumQuickBooks Desktop Enterprise Platinum 2021QuickBooks Desktop Premier 2021QuickBooks Desktop Premier PlusQuickBooks Desktop Pro 2021QuickBooks Desktop Pro Plus

Sign in now for personalized help

See articles customized for your product and join our large community of QuickBooks users.

More like this