cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
NEW Connect to DBS IDEAL direct bank feeds Click here
MRU
Level 1

How to enter an opening balance for a bank account?

Hi,
I Have created bank accounts and uploaded statements (connecting to my bank is not possible). I had not created an opening balance and need to add it as a journal entry. However, instructions I find online do not match what I have on the screen
Solved
Best answer June 03, 2024

Best Answers
RogelioL
QuickBooks Team

How to enter an opening balance for a bank account?

Adding an opening balance for a bank account in QuickBooks Online is essential for accurate financial records. Let me guide you through the process, @MRU.

 

We can create a journal entry since you've already made a bank account without entering an opening balance.

 

Before doing so, check your account register and ensure that you don't have an opening balance:

  1. Go to Transactions and select Chart of Accounts.
  2. Find the account and select Account History from the Action column.
  3. Look for an opening balance entry. The Payee Account column should show the Opening Balance Equity, and the Memo column should show the Opening Balance.

 

If you don't find an opening balance, note down the date and amount of the oldest transaction in the account.

 

Now, let's create a journal entry:

  1. Select + New.
  2. Choose a Journal entry.
  3. Enter a date earlier than the oldest transaction in the account as the opening balance date.
  4. Select the account for the opening balance in the first row under the Account column.
  5. Add a note in the Description field for reference.
  6. In the second row, under the Account column, choose Opening Balance Equity.
  7. Use your bank statements to enter the opening balance. Enter the account balance for the chosen date, and ensure to enter both a debit and a credit to maintain accuracy.
  8. For different types of accounts, follow these guidelines:
    • For Asset and Expense Accounts, enter the opening balance in the Debit column in the first row, then enter the same amount in the Credit column in the second row.
    • For Liability, Equity, and Income Accounts, enter the opening balance in the Credit column in the first row, then enter the same amount in the Debit column in the second row.
    • For Accounts Payable and Accounts Receivable, adjust the opening balance based on whether it increases or decreases the balance.
  9. Once done, select Save and Close.

 

For further reference about entering an opening balance, please check these articles:

 

Moreover, if you haven't reconciled the account yet, you'll need to reconcile the journal entry to prevent it from affecting future reconciliations:

  1. Go to Transactions and select Chart of Accounts.
  2. Find the account, then choose Account History from the Action column.
  3. Locate the journal entry you created and select it to expand the view.
  4. Select the box in the tick column until you see an R, which reconciles the journal entry.
  5. Click Save.

 

Feel free to reach out if you need further assistance with your opening balance or any other QuickBooks-related concerns. Keep safe.

View solution in original post

1 Comment 1
RogelioL
QuickBooks Team

How to enter an opening balance for a bank account?

Adding an opening balance for a bank account in QuickBooks Online is essential for accurate financial records. Let me guide you through the process, @MRU.

 

We can create a journal entry since you've already made a bank account without entering an opening balance.

 

Before doing so, check your account register and ensure that you don't have an opening balance:

  1. Go to Transactions and select Chart of Accounts.
  2. Find the account and select Account History from the Action column.
  3. Look for an opening balance entry. The Payee Account column should show the Opening Balance Equity, and the Memo column should show the Opening Balance.

 

If you don't find an opening balance, note down the date and amount of the oldest transaction in the account.

 

Now, let's create a journal entry:

  1. Select + New.
  2. Choose a Journal entry.
  3. Enter a date earlier than the oldest transaction in the account as the opening balance date.
  4. Select the account for the opening balance in the first row under the Account column.
  5. Add a note in the Description field for reference.
  6. In the second row, under the Account column, choose Opening Balance Equity.
  7. Use your bank statements to enter the opening balance. Enter the account balance for the chosen date, and ensure to enter both a debit and a credit to maintain accuracy.
  8. For different types of accounts, follow these guidelines:
    • For Asset and Expense Accounts, enter the opening balance in the Debit column in the first row, then enter the same amount in the Credit column in the second row.
    • For Liability, Equity, and Income Accounts, enter the opening balance in the Credit column in the first row, then enter the same amount in the Debit column in the second row.
    • For Accounts Payable and Accounts Receivable, adjust the opening balance based on whether it increases or decreases the balance.
  9. Once done, select Save and Close.

 

For further reference about entering an opening balance, please check these articles:

 

Moreover, if you haven't reconciled the account yet, you'll need to reconcile the journal entry to prevent it from affecting future reconciliations:

  1. Go to Transactions and select Chart of Accounts.
  2. Find the account, then choose Account History from the Action column.
  3. Locate the journal entry you created and select it to expand the view.
  4. Select the box in the tick column until you see an R, which reconciles the journal entry.
  5. Click Save.

 

Feel free to reach out if you need further assistance with your opening balance or any other QuickBooks-related concerns. Keep safe.