QuickBooks HelpQuickBooksHelpIntuit

Enter and manage opening balances in QuickBooks Online

by Intuit•1166• Updated about 4 hours ago

When you first add a real-life bank or credit card account to QuickBooks, you enter the account balance on the day you started tracking it in QuickBooks. This helps keep your QuickBooks accounts a match for your bank records.

If you connect your bank and credit card accounts, we add up the transactions you’ve made since the date you picked and use them to get your opening balance. But if you don’t, you can do so manually.

Note: If you’ve already created an account without an opening balance and want to add one, you can add an opening balance later with a journal entry.

The QuickBooks design has been updated! If this video doesn't match what you see in QuickBooks, use the in-app Search bar to navigate to the page you need.

While you can automatically add most bank and credit card accounts to your chart of accounts when you connect them to online banking, there are some accounts that you’ll need to add manually, like loans and fixed assets. Let’s go over how to manually add an account to your chart of accounts and why the opening balance is so important. Then we’ll go over how to add multiple accounts at the same time. Let’s create a new account. Select Settings…Chart of Accounts. Then select New. Next, choose the type of account you want to set up. Account types identify where the account appears on financial statements. Account types from the top of the list down to Equity appear on the Balance Sheet, and account types from Income to Other Expenses appear on the Profit and Loss statement. Check out this video to learn more about account types and how QuickBooks builds your financial statements. For this example, we’ll set up a business bank account. The Detail type provides more info about what the account tracks for your business. We’re setting up a Checking account. Then, enter a name for the account. And a number if you use account numbers. Next, if you’re setting up a Balance Sheet account, pick a starting point for the account and enter it in the As of field. Most businesses choose to start tracking accounts from the beginning of the year. That way QuickBooks matches your bank records from the start. Note that this is only necessary for accounts you set up yourself. When you connect a bank or credit card account to online banking, QuickBooks handles all of this for you. Then, enter the amount of money you had in your real-life bank account on that day. In QuickBooks, this is called an opening balance. The best way to find this is on your bank or credit card statement. This number is very important. It becomes the account’s starting point and will help ensure your QuickBooks records match your bank’s records. You can enter your own notes about the account in the Description field. When you’re done, select Save. Now, you’re ready to start recording new payments and deposits that happened after the starting date you choose. You don’t need to enter anything that cleared the account before that date. If you decide later on to add transactions before the As of date, we recommend working with your accountant. Remember, all of your old transactions were summarized in the opening balance. If you add them now without adjusting the opening balance, you’ll count your money twice. If you have several accounts to add, you can speed up the process by uploading a spreadsheet with the account info. To do that, select Settings...Import Data. Then select Chart of Accounts. Attach the spreadsheet and select Next. Then map the fields in your spreadsheet with the fields in QuickBooks. Once you’ve got everything matched up, select Next. You can make any final changes here. When you’re done, select Import. Note that when you import accounts, you can’t bring in their opening balances. You’ll need to add those after, but make sure you do, as the opening balances are very important. Note that if you use QuickBooks Online Accountant, you can also use Chart of Accounts templates to quickly set up a client’s Chart of Accounts. Now you’re ready to set up your accounts one-by-one or in a batch.

Find flexible solutions for your growing business with QuickBooks Advanced. With unlimited chart of accounts and up to 25 users, you have room to grow. Learn more about QuickBooks Advanced today.

Enter an opening balance

Follow this link to complete the steps in product Open this link in a new window

  1. Select New.
  2. Name your account and select Bank, Asset, Credit card, Liabilities, or Equity, then select the appropriate type of account from the Detail dropdown. 
  3. If this account is a subaccount, check Make this a subaccount, then choose its Parent account.
  4. Enter the Opening balance of your account on the starting date you enter in As of. 
  5. (Optional) Add a Description to add extra information about this account.
  6. Select Save.
  • If this bank or credit card account is new, use the day you opened it at your bank.
  • If the bank or credit card account isn't new, use the beginning date for your next account statement.

If you need to change your opening balance to include older transactions, edit the start date and opening balance of your account.

  1. Follow this link to complete the steps in product .
  2. Locate the account and select View register.
  3. Select the opening balance entry. This entry will be the earliest in the list and show Opening balance equity as the payee.
  4. Edit the date, then the amount. If needed, select Edit to make your changes. 
  5. Select Save.

Next steps

If you need to check what you entered later, find the Opening Balance Equity account in your Chart of accounts. Follow this link to complete the steps in product . The Opening Balance Equity account tracks the opening balance for all your QuickBooks accounts.

Related links

QuickBooks LedgerQuickBooks Online AdvancedQuickBooks Online EssentialsQuickBooks Online PlusQuickBooks Online Simple Start