cancel
Showing results for 
Search instead for 
Did you mean: 
jw40
Level 1

New Bank Account opening balance not showing in reconciliation

I set up a new bank account in Quickbooks Pro 2020 Desktop.  I created a bill issued to the new account.  I wrote a check to pay the bill.  The balance is in the account and when I tried to reconcile the account, there was no opening balance.  I tried to set the opening balance following the instructions but then the balance in the account was doubled.  How can I get the opening balance to show in the reconciliation?

7 Comments 7
CharleneMaeF
QuickBooks Team

New Bank Account opening balance not showing in reconciliation

It's my top priority to ensure your beginning balance is entered in QuickBooks, jw40.

 

When you reconcile an account for the first time, you can recreate the opening balance but this option is not available in the Begin Reconciliation window. To get the correct balance show on the reconciliation page, I'd suggest creating a journal entry, then do a mini-reconciliation. 

 

To start, we'll have to create a journal entry using the correct date and amount you want to see in the Begin Reconciliation window.

  1. Go to the Company menu and then select Make General Journal Entries.
  2. Change the date to the correct statement date of your beginning balance.
  3. On the first line, select the appropriate account from the Account drop-down menu.
  4. Enter the correct opening balance in the Debit column.
  5. On the second line, select Opening Balance Equity.
  6. Select Save.

 

Then, let's do a mini-reconciliation to correct the beginning balance.

  1. Go to the Banking menu, then select Reconcile.
  2. Choose the appropriate account from the Account drop-down.
  3. Enter the statement date and ending balance that matches your Journal Entry.
  4. Select Continue.
  5. In the Deposits and Other Credits section, select the corresponding Journal Entry.
  6. Click on Reconcile Now.

I'd also recommend visiting this article for further guidance with the process: Fix Beginning Balance Issues.

 

You can also check out our reconciliation guide for reference.

 

Once done, run the Previous Reconciliation report so you can review your past reconciliations. You can also print the report or export it as a PDF or to Excel. This data will serve as a guide to fix some reconciliation issues in the future.

 

Feel free to get back on this thread if you'll need further assistance in recording your beginning balance and reconciling your account. We're always here to help you.

jw40
Level 1

New Bank Account opening balance not showing in reconciliation

I had already done this.  This doubles the balance in the Chart of Accounts, etc.  Remember, I created a bill, paid the bill with a check and the beginning balance is showing in the Chart of Accounts and Balance Sheet.  It is not showing in the reconciliation.

LeizylM
QuickBooks Team

New Bank Account opening balance not showing in reconciliation

Hello there, jw40. 

 

I appreciate you for going through the troubleshooting steps provided by my colleague above. Allow me to share a little more information about reconciliation and help you reconcile your bank account

 

To start, your transactions that have been already reconciled are excluded and will not show on your reconciliation page.

 

With this, may I ask if you can share a screenshot of your register? Any information will surely be able to help share accurate resolutions and will let us solve your reconciliation.

 

In the future, if you want to generate and customize your Previous Reconciliation report so you'll be able to view your reconciled transactions in QuickBooks. You can refer to this article for more detailed steps: View previous bank reconciliation reports.

 

Feel free to leave a comment below if you have any other questions about reconciliation. I'll be waiting for your response and will be always happy to lend a helping hand.

jw40
Level 1

New Bank Account opening balance not showing in reconciliation

I have been using Quickbooks for 8 years and reconcile all my bank accounts each month.  This is the first time I have had trouble seeing the opening balance when I opened a new account at the bank.

I attached the screen shots in a Word Document.

 

I took the following steps:

I set up the new account in Quickbooks:

 

I created a bill to our company to the new bank account.

I paid the bill.

I took the check to the bank and did not create a deposit.

In the chart of accounts the new bank account amount is from the bill I created and is correct.

A/P is $0

The bank account the check was written on is properly reflected.

 

I tried to write over the amount in the chart of accounts for the new bank account but it did not do any good.

To further compound the issue, I tried to fix it myself and so voided the original bill and now the check is not tied to the bill.  Can this be fixed?  Should I delete the bill and the check and just do a journal entry?

 

I do appreciate any help you can give me.

 

Thank you

 

jw40
Level 1

New Bank Account opening balance not showing in reconciliation

I have been using Quickbooks for 8 years and I reconcile all bank accounts each month.  This is the first time I have had an issue seeing the beginning balance of a new bank account. 

 

I have attached a Word Document with screen shots of the steps I took.

 

To further complicate the matter, I tried to fix it myself by voiding the bill and now the bill is not tied to the payment.  Should I just delete the bill and check and create a journal entry.

 

I appreciate any help you can give me.

 

Thank you.

DebSheenD
QuickBooks Team

New Bank Account opening balance not showing in reconciliation

Hello there, jw40.
 

"I appreciate your time letting us know the results of the steps you've done.

Let me share some insights about checks. Voiding or deleting a check is the same.

Once you've voided/deleted the check you can follow the steps on how to do mini reconciliation provided by my peer.

I've also added this link for additional information about reconciliation.

Let me know if you have other concerns about bank reconciliation. I'm always here to help.

 

jw40
Level 1

New Bank Account opening balance not showing in reconciliation

Consider this closed.  I kept getting the same information over and over again.  This solution did not work any of the 3 times I tried it.  I finally found a solution myself.

Need to get in touch?

Contact us