cancel
Showing results for 
Search instead for 
Did you mean: 
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.

Need to get in touch?

Contact us