Let’s Enter and Manage Opening Balances in QuickBooks Online

If you are a first-time user or at the beginning of a fiscal year, you must enter the opening balance to ensure financial accuracy, better auditing, and more effective reconciliation. An opening balance helps keep track of finances, ensures your business is in the right position, prevents possible financial errors throughout the year, and maintains compliance with statutory requirements.

The opening balance represents the total funds available in a business’s account at the very start of a new fiscal year. In this detailed guide, you will learn how to enter and manage the opening balance in QuickBooks Online, and the steps to fix discrepancies when reconciling your account for the first time. Let’s go through this detailed guide carefully:

What is an Opening Balance in QuickBooks Online?

In QuickBooks Online, an opening balance is the initial amount of money in an account when you set up your books or begin tracking finances in the software. It represents the starting point for recording your business transactions for a financial year and is later reconciled with your bank transactions from the same date.

Entering an accurate opening balance ensures that your financial reports, such as the balance sheet and profit and loss statement, begin from the correct baseline and reflect a true picture of your business’s financial health from day one.

Related links – Connect bank and credit card accounts to QuickBooks Online

How to Enter and Manage Opening Balances in QuickBooks Online?

When you start using QuickBooks Online, entering accurate opening balances is essential to ensure your financial reports reflect the true state of your business from day one.

You will require the following: 

• Your credit card statement or the account balance from your real-life bank account.  
• The specific date when you started tracking the account. 

Note: if you already created an account with an opening balance and still wish to add one, you can do so later with a journal entry.

Enter an opening balance

If you connect your bank or credit card to QuickBooks, it will automatically download all the transactions and reconcile up to a certain date. It also automatically totals up the amount and enters the opening balance and date for you. In case you prefer doing it manually without connecting a bank or credit card account, here’s how you can do so: 

• In QuickBooks, go to All apps. 
• Choose Accounting, then select Chart of accounts.
• Select New account and set it up.
• In the Opening balance field, add the same balance as your bank or credit card account. 

Tip: Ensure you know the exact figure for your current starting balance.

• Now, choose the date you want to start tracing your finances using QuickBooks in the As of field. 

Note: You may enter details in the Description box to include information about this account.

• Finally, click Save.

Read More – Set up the Chart of Accounts in QuickBooks

Edit an opening balance 

If the opening balance was entered incorrectly or you wish to include older transactions, you can easily edit the start date and opening balance of your account. Here are the steps to change an opening balance in QuickBooks: 

• In QuickBooks Online, go to All apps. 
• Choose Accounting and then click the Chart of accounts. 
• Now, locate your account and choose View register. 
• Choose the opening balance entry. Remember that this entry will be earliest in the list and will be shown as the opening balance equity as the payee. 
• Change the date of the opening balance and then the amount. Click Edit to make the changes only if required. 
• Finally, click Save. 

Now, let’s enter the opening balance amount in the account: 

• Move back to the All apps menu. 
• Choose Accounting, then Chart of accounts. 
• Locate your account and click on Account history. 
• Now, select the opening balance entry. This entry will be the earliest in the list and will be shown as Opening balance equity as the payee.
• Modify the date and the amount as required or click Edit to make your changes.  
• Finally, click Save.

Next steps

If you want to review what you entered later, locate the Opening Balance Equity account in your Chart of accounts. Go to All apps, choose Accounting, then select Chart of accounts. The Opening Balance Equity account records the starting balance for all your QuickBooks accounts.

Fix Discrepancies When Reconciling an Account for the First Time in QuickBooks Online

Before you begin reconciling, it’s important to understand that discrepancies often stem from setup issues or missing transactions when you first start. 

Prerequisites

Make sure the opening balance for the account you’re reconciling is accurate. In some cases, it may not reflect transactions that were still pending when the account was first set up. The opening balance should reflect the amount in your bank account on the date you began tracking activity.

Note: If you’ve recently added older transactions dated before your opening balance, follow the steps to reconcile those first, then proceed with the process.

Step 1: Review the opening balance in QuickBooks

When you set up a new account in QuickBooks, you choose a date to begin tracking transactions. You enter the balance of your actual bank account for that selected date. This initial amount is the opening balance. We suggest setting the opening balance at the start of a bank statement. This makes your first reconciliation much simpler.

• Go to the All apps menu. 
• Choose Accounting and then the Chart of accounts. 
• If you have entered the older transaction dates before the opening balance, make sure to reconcile them and proceed further.
• Choose your account from the list.
• Click on Account history.
• Look for the opening balance entry. You will find it as “Opening Balance Equity” in the Payee Account column and “Opening Balance” in the Memo column. 
• Now, note down the date and the balance.

Step 2: Compare the opening balance with your real-life account

Now that you have both the date and the amount of the opening balance in QuickBooks Online, match them with your bank records: 

• Log in to your bank’s website or locate your bank statement. 
• Verify the account balance for the same date as the opening balance in QuickBooks. 
• Compare both balances. 
• If the balances match 
  • You entered the opening balance correctly. Proceed to Step 3. 
• If your balance doesn’t match your bank records, fix it:
  • In QuickBooks, select the opening balance entry to expand the details. 
  • In the Deposit column, adjust the balance so it matches your bank records. 
  • Click Save. 
• In QuickBooks, select the opening balance entry to expand the details. 
• In the Deposit column, adjust the balance so it matches your bank records. 
• Click Save. 

Step 3: Review your account history

When you reconcile an account for the first time, only the opening balance entry should be reconciled. No other transactions should be marked as reconciled. To verify:

• Go to All apps, select Accounting, then choose Chart of accounts.
• Locate the account in the list.
• Select Account history to view more details.
• Look for the opening balance entry. It should show “Opening Balance Equity” in the Account column.
• Check the tick column. There should be an R in the box.
• Review the remaining transactions in the list. Each should show a C or a blank box in the tick column.
• If any other transaction shows an R, select it to expand the details.
• Click the box in the tick column. Keep selecting it until the box is blank, then click Save.

Next steps: Start reconciling the account

Once you’ve verified that your opening balance is correct, you can start the reconciliation process. If you see a warning indicating the starting balance is incorrect, review additional factors that might be causing the issue.

Conclusion 

An accurate opening balance is crucial for better financial management and even compliance. This detailed blog explains how to enter and manage opening balances in QuickBooks Online and how to fix potential discrepancies when reconciling your account in the software.

In case you need help with the opening balance or are unable to resolve discrepancies, we recommend consulting QuickBooks ProAdvisors.

Frequently Asked Questions 

How do I enter opening balances in QuickBooks Online?

To enter the opening balance in QuickBooks, you can either create a new account in the Chart of Accounts with a balance and date or use a Journal Entry for complex opening balances, such as a full trial balance. 

What is the journal entry for the opening balance?

An opening balance journal entry transfers the closing balances of assets, liabilities, and equity from the previous accounting period to the new one, ensuring continuity. It is generally recorded on the first day of the new fiscal year by debiting all asset accounts and crediting all liability and equity accounts. 

How to correct the opening balance in QBO?

To correct an opening balance in QuickBooks Online (QBO), navigate to the Chart of Accounts, locate the specific account, and select View register. Find the entry labeled “Opening Balance“, select it, update the amount and date, and click Save. 

How to fix the incorrect beginning balance in QuickBooks Online reconciliation?

To fix an incorrect beginning balance in QuickBooks Online, identify the discrepancy using the Reconcile Discrepancy report, then fix it by either re-reconciling changed transactions (re-marking them with an “R” in the Chart of Accounts register) or adjusting the opening balance entry. 

What should you do if discrepancies occur during the reconciliation process?

When reconciliation discrepancies occur, immediately investigate by comparing bank statements to company ledgers, checking for duplicate transactions, missing entries, or incorrect amounts. Common actions include auditing the transaction history, reviewing the opening balance, or undoing/redoing the reconciliation. Document all changes and consult an accountant if errors persist.