I'll make sure that your QuickBooks balance will be corrected, Constantinos Kourris. I know how important it's to have a correct balance in our bank accounts. I have a way to correct the beginning balance in QuickBooks Online (QBO). And I'm happy to outline the detailed steps for you. To fix this, please follow the steps below: In the Accounting tab, select Chart of Accounts. Search your credit card account and click View registers in the Action column. Locate the earliest deposit posted noted as Opening Balance. Click to open the transaction and select Edit. On the Bank Deposit window, change your opening balance amount based on the credit card statement.Hit Save when done. For more information, see this link: Edit an incorrect opening balance. Once everything is good, you may now reconcile your account in QuickBooks. This way, your reports and books will stay accurate at all times. Also, you can always review your work by running the Reconciliation report. Further, check out these articles below on how to fix some reconciliation issues and manage your chart of accounts: Learn the reconciled workflow in QuickBooksLearn about the chart of accounts in QuickBooks Remember that you can always ask me about any topics or other processes within QuickBooks. We're open 24/7 to assist you. Please stay healthy and safe, Constantinos Kourris.

Question

While entering transactions before my first reconciliation I ended up with a discrepancy in the Beginning Balance. Now I cant fix it. Please help ?

Forum|Forum|4 years ago
January 15, 2022
1 reply
1 view

No text available

QuickBooks Online - International

MichelleBh

Level 8

I'll make sure that your QuickBooks balance will be corrected, Constantinos Kourris. I know how important it's to have a correct balance in our bank accounts.

I have a way to correct the beginning balance in QuickBooks Online (QBO). And I'm happy to outline the detailed steps for you.

To fix this, please follow the steps below:

In the Accounting tab, select Chart of Accounts.
Search your credit card account and click View registers in the Action column.
Locate the earliest deposit posted noted as Opening Balance.
Click to open the transaction and select Edit.
On the Bank Deposit window, change your opening balance amount based on the credit card statement.
Hit Save when done.

For more information, see this link: Edit an incorrect opening balance.

Once everything is good, you may now reconcile your account in QuickBooks. This way, your reports and books will stay accurate at all times. Also, you can always review your work by running the Reconciliation report.

Further, check out these articles below on how to fix some reconciliation issues and manage your chart of accounts:

Remember that you can always ask me about any topics or other processes within QuickBooks. We're open 24/7 to assist you. Please stay healthy and safe, Constantinos Kourris.

C

Constantinos KourrisAuthor

Hello MichelleBh,

Thank you for your reply.

My problem is that I ended up with a discrepancy between the account register balance and the 'beginning balance' given by the system when I try to do a reconciliation

The register balance is correct and the same with my actual bank balance as the banks statement.

The problem begins when I want to do a reconciliation

Is there a way to change the 'beginning balance' in the reconciliation screen without affecting the account register ?

Many thanks,

Constantinos Kourris

L

lin_jcaj

Level 9

Hello AileneA,

Thank you for your reply.

I attach two screenshots to better explain my problem.

The register reads the correct amount in the bank account as at 31/12/2019.

The next screenshot is the reconcile window

I do not recognise or understand the 'beginning balance' of the reconcile window

My banking transactions have been reconciled up to 31/01/2021.

The problem was created when I tried to enter banking transactions before 31/12/2019.

Now I am trying to go back to where I was before.

Thanking you in advance for your help.

Constantinos Kourris

Let me ease your confusion and help you fix the discrepancy in the beginning balance, Constantinos Kourris.

The beginning balance amount should match what's on your bank statement for the same start day. Since you've mentioned that you've entered transactions older than the opening balance, you also have to modify the original opening balance entry to reflect the change.

I'll show you how to do it:

Go to the Accounts menu and select Chart of Accounts.
Locate and open the account.
Search the account register for the opening balance entry. It should be labeled Opening Balance Equity with “Opening Balance” in the Memo column.
Sign in to your bank’s website. Set your account so you can see the balance for the new date you want to use for the opening balance in QuickBooks.
Go back to QuickBooks. Select your opening balance entry.
Edit the opening balance so the date and amount match your bank records for the day you choose.

The following steps should help you set the new beginning balance that matches your bank record against the QuickBooks bank register.

Here are reconciliation-related articles for additional guide and reference:

That should get you going, @Constantinos Kourris. If you have any additional questions, let me know by adding them below. I'm always glad to help.

Sign up

Login with SSO

Let's get you signed in

Login with SSO