How to change beginning balance in QuickBooks reconciliation?

How to change beginning balance in QuickBooks reconciliation?

Be it an error or any missing transaction, your smallest mistake can bring huge variation within your books of accounts. If you are setting things manually, then one change in any previous entry can bring a whole lot of other changes, but the same is not true for QuickBooks since it’s automated. Want to make your accounting life easier, use QuickBooks. With that said, let’s check out “How to change beginning balance in QuickBooks reconciliation.”

Are you a Quickbooks user?

How to change beginning balance in QuickBooks reconciliation?

There may be times that you want to reconcile and you see an incorrect beginning balance. Your QuickBooks reconciliation window may show you zero or some incorrect opening balance because of:

  • Balance set incorrectly at the time of account set up.
  • Deleted, modified or changed transaction.
  • Data corruption.
  • Data loss during conversion from outdated to updated version of QuickBooks.

Since there are multiple reasons for why you see changing beginning balance in QuickBooks reconciliation thus there are multiple solutions. Let’s check them out all one by one.

Steps on how to change beginning balance in QuickBooks reconciliation:

First thing first, you cannot edit beginning balance within your QuickBooks reconciliation section.


You heard us right, opening balance cannot be edited directly in the reconciliation window. A journal entry will have to be passed first for your beginning balance which will then be followed by a reconciled entry. Here are the steps on how to change beginning balance in QuickBooks reconciliation.

Incorrect opening figure:

  1. Launch QuickBooks and jump onto creating a journal entry within QB. To pass an entry:
    1. Click on the company file tab.
    2. Choose to create a journal entry.
    3. Click on the date’s tab, to enter the date that relates to your beginning balance.
    4. Provide the amount for your beginning balance.
    5. Hit save and you will be done.
  2. Since now that you have passed a journal entry for your opening balance, it’s time for QuickBooks mini reconciliation. Follow the steps and reconcile your beginning figure to match with your account.
    1. With your QuickBooks logged in, click on the Bank’s tab.
    2. From the drop-down menu, choose the reconcile option.
    3. Choose an account for which you want to pass a reconciled entry.
    4. Enter the date and amount that exactly matches the journal entry you just passed. Click on the continue tab.
    5. From the deposits and credits option, choose journal entry as your preferred choice. The moment you select the above-given option, the differencing figure should now become “0”.
    6. Choose to reconcile now and your beginning balance should appear in your reconciliation window.

Deleted or modified entry:

If you suspect that the cause of error “Beginning balance not showing in QuickBooks reconciliation” is deleted or modified transaction then:

Run the Reconciliation discrepancy report:

To look for any changes done recently you would need to run the reconciliation discrepancy report. This report helps you track all the changes or modifications done in the recent past and can be easily accessed from the bank’s tab. Click on the link to know more on “How to fix a reconciliation discrepancy in QuickBooks”.

Run the audit trail report:

If multiple users are working on your QuickBooks then it becomes all more important to track any changes made. By running the audit trail report, you get access to that every info, activity or changes done by users of QuickBooks. If you don’t know “How to run an audit trail in QuickBooks”, then choose the link provided and follow the steps.

Once you have found the possible cause of the error, simply edit your transactions to fix your transaction. When once done your beginning balance will be corrected in your QuickBooks reconciliation.

If the entry has been messed up by your bank then you would need to contact your banks represented to get your issue fixed by the bank.

Data loss during QuickBooks conversion:

You would need to understand that every version of QuickBooks works differently. For example, QuickBooks desktop will be different from QuickBooks enterprise. Migrating from one version of QuickBooks to another will often lead to loss of reconciled entries. Thus if you have recently migrated or upgraded your software then do look for the possible changes. Match before and after entries and create a reconciled transaction to match your accounting figures.

Hope you are now able to figure out “How to change beginning balance in QuickBooks reconciliation”. If you are still facing issues with your opening balance then we would request you to get our expert help.

Still in Doubt…!

Request a Call Back

Talk to our Quickbooks Proadvisor and resolve your issue over a phone call.

We gaurantee 100% satisfaction

You can easily reach out us at our Quickbooks Proadvisor Canada phone number at ✆ +1800-940-7442 and talk to our Proadvisor now.

Related Articles:

Report Your Issue

(Didn't find what you were looking for! Report your issue and get customized help from our QuickBooks experts.)

QuickBooks Version:
Edition Year:
No of User: Licence
HELP Needed:
Operating System:

What is Qbpro?

We are a Quickbooks and TurboTax consulting firm that takes care of all the issues that people might ever face within these programs. If you are using any of the above platforms and are continuously faced with bugs then we are here to help. You can connect with us for errors related to Quickbooks or TurboTax via any of the medium below:

What Our Clients Say...

Here is what people have to say about us.

Areas we serve:

We are proud to announce that we are covering entire Canada. Thus if you face any issues now, give us a call as our proadvisors work 24/7 to get your issues fixed.

Leave a Reply

Your email address will not be published. Required fields are marked *

Contact Me

Leave a Message

Disclaimer: is a reputable QuickBooks® Consulting firm that provides professional support services related to your accounting software. It is also a front-runner in providing 3rd party technical support services for quickbooks.


"Get QuickBooks Support, no matter where you are living in Canada. Just Call and get issues fixed."

Alberta British Columbia Manitoba New BrunswickNewfoundland and Labrador Northwest Territories Nova ScotiaNunavut Ontario Prince Edward Island Quebec Saskatchewan Yukon


Are you confused and not able to manage your books on QuickBooks…!

Dial us: ✆ +1800-940-7442

Still facing issues

Get Help For Your QuickBooks Accounting Software

Resolve your every issue on a
Free 30 minutes call

Enter your details to get a cheat sheet of 96 awesome tricks to use Quickbooks like a pro.

We hate SPAM and promise to keep your email address safe.

Get FREE 30 minutes, Resolve your issues now!

Call Now: 1-800-940-7442