cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Created with Sketch. The QuickBooks Community will be unavailable for approximately 1 hour beginning at 10:00 PM PDT on Wednesday, August 14th for database maintenance. All community forums will be unavailable during maintenance but feel free to browse our Support articles for help in the interim.
BigRog
Level 3

RECONCILING BANK ACCOUNT AFTER 2+ YEARS OF SAME COMPANY FILE

Hi I'm using qb for Mac 2016 and using company file that was created better than 2 years ago.. the bank account I am using is just as old and never been reconciled. As of the first of 2020, I decided it was time to see if (more like get serious about recording all transactions) see til the first of this year I was only hit and miss with entering needed company data to keep company up to date, so the beginning balance in account first of the year really wasn't the accurate opening balance.. I'm hoping there is a way that someone can instruct me step by step to correct the beginning balance and then to reconcile month by month the bank account. 

1 Comment 1
KlentB
Moderator

RECONCILING BANK ACCOUNT AFTER 2+ YEARS OF SAME COMPANY FILE

I can help you with that, BigRog.

 

We can simply edit the balance of that account. Since the transactions have already been recorded, you can open the Chart of Accounts and double-click the account to open the register. Then, locate the Opening Balance Equity entry and change it to the correct number.

 

Alternatively, you can sign in to your bank's website or find your bank statement. Then, set your account so you can see the balance for the day you set as your opening balance date in QuickBooks. This way, we'll be able to compare it to your real-life account.

 

Here's how to edit the opening balance:

 

  1. Click the Lists menu, then go to the Chart of Accounts.
  2. Find the account with the incorrect opening balance.
  3. Locate then double-click opening balance transaction to open it. This transaction usually occurs as the first transaction with the label "Opening Balance" in the Account field.
  4. Change the amount of the Opening Balance Equity.
  5. Click OK, then select Yes to confirm the changes.

Once done, we can now start reconciling your accounts on a monthly basis.

 

I've also included an article that will help you identify discrepancies between your bank statement and QuickBooks records.

 

If there's anything else that I can help you with, please don't hesitate to insert a comment below. Stay safe.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us