Buy now and save 90% off today
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Want an expert to help you set up your QuickBooks Online? Find out how: Click here
3001
Level 1

how to record bank opening balance without affecting the other accounts on credit side. my books show the bank balance on December 31, 2019 but when I start doing reconciliation from January 1, 2020. the opening bank balance does not show in reconciliatio

 
1 Comment 1
MaryLandT
Moderator

how to record bank opening balance without affecting the other accounts on credit side. my books show the bank balance on December 31, 2019 but when I start doing reconciliation from January 1, 2020. the opening bank balance does not show in reconciliatio

Welcome to QuickBooks Community, 3001,

 

I'm here to help record a bank opening balance. Let's start by making sure there isn't an opening balance on your register. It won't show up on the reconciliation page if the entry is already on the "R" status.

 

Hence, you'll want to double-check your entries first. Here's how:

  1. Go to the Accounting menu, then select Chart of Accounts.
  2. Find the account and select Account history from the Action column.
  3. Search your register for an opening balance.
  4. It should have Opening Balance Equity in the Payee/Account column and Opening Balance in the Memo column.
  5. If there's an opening balance under "R" status, then you can clear it by tapping the field until it's blank.

If there isn't an entry, you can create journal entry. Let me show you how it's done:

  1. Select + New.
  2. Select Journal entry. .
  3. Enter a date that comes before the oldest transaction currently in the account. This is your new opening balance date.
  4. On the first line, select the account you want to enter the opening balance for.
  5. Use your bank statements to enter the opening balance.
  6. It should be the balance for your real-life account on the opening balance date.
  7. On the second line, select Opening Balance Equity in the Account column.
  8. Write a note in the Description field so you know what the journal entry is for.
  9. When you're ready, click Save.

To learn more about this entry, check out the What to do if you didn't enter an opening balance link for more details.

 

After that, you can start reconciling your bank account in QuickBooks.

 

Upon sharing this, I still suggest consulting with your accountant. Any changes to your bank account will affect its balance.

 

Should you need anything else, don't hesitate to click the Reply button below. I'm always right here to help.