Chart of accounts balance not in synch with reconciliation

The account balance on your chart of accounts will only match the reconciled balance / statement ending balance when everything in the account is cleared.

For most bank accounts - those in regular use -  that'll never happen because you'll always have new transactions that were created after the statement date, and perhaps even older ones that haven't cleared - like a check you wrote to someone who just sits on it and doesn't cash it.

Thanks for reply. I’m sure that field is frozen at a reconciliation in June. It never changes and I download transactions monthly at time of reconciliation. It is many tens of thousands more than any one month of activity. I have since discovered it is a known issue. I am wondering if anyone knows the status or any suggestions on how to edit. 

I appreciate you getting back, @MVEBA. I'm joining the thread to share additional details about the QuickBooks and Bank Balance under your Chart of Accounts.

The QuickBooks Balance is affected by all your transactions including those you haven't reviewed yet. While the Bank Balance is solely determined based on the transactions on the register. It'll only be updated if the account is connected to online banking. Manually imported or added entries won't affect your Bank Balance.

At this time, consider categorizing and matching your downloaded transactions to match their balances. 

1. Click on Banking on the left pane.
2.  Go to the Banking tab.
3. Look for your bank, then categorize your entries under For Review.

I'm also adding this article for additional guides: Categorize and match online bank transactions in QuickBooks Online.

Additionally, learn more about matching your bank or credit card statements from this link: Reconcile an account in QuickBooks Online.

Always feel free to leave a comment below if you have other banking concerns. I'm here to help. Keep safe!

Thanks. I am not connected directly to online banking. I import from bank to QB with Link Account>upload from file. 7 other accounts in 2 businesses do not have this issue.  I’ve not had any reconciliation  issues with this account. There is one transaction in For Review tab (Interest posted after first of the month). I mostly use the account to auto pay credit cards so occasional deposits and a few transfers and payments a month. In reviewing your suggestions I did notice a manual entry for the date than issue began. It was for interest income and had the green symbol for manual entry under “R”. I deleted and re-entered but nothing changed. (also excluded as then in for review). 

Hi there, @MVEBA. Thanks for getting back and providing detailed information about your concern.

I want to ensure this gets resolved as soon as possible. To further investigate why you're having an issue with the Chart of Account, not in sync with reconciliation, I recommend contacting our Customer Care Team. They have the tools to pull up your account and investigate the cause of the issue. In addition, they can provide other troubleshooting steps to isolate the problem.

To reach them, click the ? Help button at the top-right corner and select Contact Us to talk with a live agent. Ensure to review their support hours to know when agents are available.

If you have other concerns about QuickBooks, feel free to post again in the Community.