Skip to main content
P
pfthiessen
February 19, 2019
Question

QB beginning balance doesn't match bank statement

  • February 19, 2019
  • 2 replies
  • 0 views

Hi,

 

I have deleted an adjusting entry (Reconcile Adjustment) to the bank account, as it was wrong in the first place because entries was missing from the feed.

 

When I try to reconcile the account it says that the balance is off, and when I look at the Audit History of the reconciliation adjustment I am not able to edit the entry.

 

Can someone help me out on this, either on how to reverse it or edit it?

 

Thanks

2 replies

A
Anonymous
February 19, 2019

Hello, pfthiessen .

 

You can correct the opening balance by editing it in your register. Here’s how:

  1. Go to Accounting on the left panel.
  2. Select the Chart of Accounts tab.
  3. Locate the account and click View register.
  4. Scroll down until you find the opening balance.
  5. Click the entry and override the amount to correct the balance.  
  6. Click Save. 

For additional information about fixing opening balance, please check this article: https://quickbooks.intuit.com/community/Banking-and-bank-feeds/Fix-an-opening-balance-to-match-a-bank-statement/m-p/186367.


This article about fixing reconciliation discrepancy might also help you along the way: https://quickbooks.intuit.com/community/Banking-and-bank-feeds/Troubleshoot-reconcile-when-opening-balance-is-correct/td-p/185582.


You’re always welcome to drop by again if you have additional questions about QuickBooks.

 

P
pfthiessenAuthor
February 19, 2019

MikiD,

 

there is no opening balance, it was 0.00, so I don't think the error is there, and I cannot locate the adjustment entry in the register.

 

Thanks,

 

J
JamesDuanT
February 19, 2019

Hello pfthiessen,

 

Since you're unable to locate the adjustment entry in your register, you can use the Audit Log to see if it was deleted.


After that you can use the details to reenter the opening balance manually. Let me show you how:

  1. Click the Create (+) menu and select Bank Deposit.
  2. Enter the bank account in the Account field and the deposit date.
  3. Go to the Add funds to this deposit section.
  4. Enter Opening Balance Equity in the ACCOUNT column.
  5. Enter the opening balance amount in the AMOUNT column.
  6. Click Save and close.

You can also use this article for reference: Enter an Opening Balance for a Bank Account.

 

Let us know if you need more assistance with this. We always got your back!

MichelleBh
MichelleBh
November 8, 2021

You're in the right place to get answers, @CTschool. I hope you're doing great right now.

 

Happy to help out here. Don't worry, I'm here to provide some workaround solutions to ensure you can modify your opening balance seamlessly. 

 

Ensure that you're logged in as an administrator to override the amount. Once confirmed and still unable to edit the opening balance on the Bank Register page, you can click the Edit button to open the Bank Deposit window. From there, you're able to modify the balance. See the sample screenshot below for your guide. 

 

If the issue persists, I'd recommend logging in to your account through an incognito window. Unable to override balances in QBO is typically the result of outdated or corrupted cache files in your web browser. This way, we can see if it's browser-related. 

 

Here are the keyboard shortcuts:

  • Ctrl + Shift + N (Google Chrome)
  • Ctrl + Shift + P (Firefox)
  •  Control + Option + P (Safari)
  •  Ctrl + Shift + P (Microsoft Edge)

 

Once signed in, go back to the Register page and re-edit the balance to verify if it's performing adequately. If it works, return to your regular browser and press the CTRL+ Shift and Delete keys on your keyboard to clear the cache. 

 

Everything you do in your account, including editing accounts, can be tracked in the Audit Log report for future use. You have an option to run this anytime in your account. For more information, see this link: Use the audit log in QBO. 

 

Moreover, visit these articles below on how the opening balance works and how to fix this in reconciling accounts in QuickBooks: 

 

 

Let me know if there's anything else you need. I'll be right here to help you with your account. Keep safe, CTschool.

Terms & ConditionsAccessibility statement