Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
The balance sheet and check register show the correct balance. In the check writing window (QuickBooks Desktop), the ending balance that appears to the right of the bank account selection is incorrect. All fixes I have seen would change the balance sheet / check register amount. Has anyone else run into this issue?
I hate to ask an obvious question, but the only explanation that comes to mind is that you have a different checking account selected on your Write Checks window. Do you have more than one checking account set up in QuickBooks?
If that's not the issue, I'm sure one of the QuickBooks staff will be along shortly to have you try to rebuild your company file.
Not an obvious question considering the clients I work with! Yes - there are multiple checking accounts, but I triple checked I had the right account and also shared my screen with a couple coworkers to make sure I'm not missing something else. Nobody could figure it out.
The Balance Sheet, check register, and writing check window should always have the same ending balance, Rachel. FishingForAnswers is correct. It could be that you accidentally select another checking account instead of choosing the appropriate one.
I appreciate you for reviewing the name of your checking account and ensure you pick the right account on your Write Checks window.
Since you're getting the same result, I recommend you manually update your QuickBooks Desktop to the latest release. Then, run a rebuild data to fix this odd behavior and other issues in your company file.
Here's an article for further guidance: Verify and Rebuild Data in QuickBooks Desktop.
Let us know if you have more questions about viewing the correct balance and other data in QuickBooks Desktop. We're all right here to help in any way that we can.
@RachelTSites How far off are the balances, anyway? Is the Write Checks window balance higher, or is the check register balance higher?
There are a few things that could be wrong, but I don't think any of them would actually resolve the problem, only satiate curiosity about what happened.
The first and easiest is to see if there is an item in the register for an amount equal to the difference between the two balances. If there is, than for some reason, QuickBooks isn't using that particular item in its calculations for the Write Checks balance.
The second doesn't have a way to verify; it could be that the Write Checks window has some errors in its internal math, since you already stated that the balance sheet had the correct balance.
The third is that it's just a visual bug, and I wouldn't know how to check that out at all; too far up the code monkey ladder for my understanding.
This is probably one of the few instances where rebuilding or otherwise repairing your QuickBooks file would actually help.
Thank you Sarah. I'll see if we can update and run the rebuild utility. Simple steps are sometimes difficult as we operate in a cloud environment.
Thanks for your input! The balance is over $70k off. It actually reset to zero on a day we changed how our cloud hosted QuickBooks clients access their files. So I think you are correct where this is one of the few instances where rebuilding / repairing the file will be a necessity.
You're welcome, @RachelTSites. We're glad to provide relevant information that help you fix your concern in QuickBooks Desktop (QBDT).
Please know that, assisting and providing the right resolution for our valued customers is our top priority. If you have any questions about QuickBooks, you can always drop by and post your concerns. I’ll make sure to address that as soon as I can.
Also, I added this article to your reference when checking the latest updates about the product: The QuickBooks Blog.
I'm wishing you have a prosperous business!
I'm experiencing a technical issue with QBO that you might be able to help with. When writing a check, the check-writing window shows a different balance in the checking account compared to the bank feed transactions tab in QBO.
It's important to note that the balance in the bank feed transaction tab matches the balance in the external checking account.
Is there a way to resolve this? I am eager to align the check-writing window balance with what is available in the account, just as it does in the bank feed transaction tab.
We're glad to have you here in the Community space, @BTCPNC. I can explain why the QuickBooks balance doesn't match the bank balance.
Please note that the QuickBooks balance is impacted only by transactions in your Bank Register. The bank balance is based on your financial institution and includes transactions waiting to be reviewed in the Bank Transactions tab.
To identify this, consider categorizing and matching your downloaded transactions based on your bank statement. Then, compare it to the Bank Register. I also advise comparing your register from your Chart of Accounts to the transactions shown on your bank account to check what causes the discrepancy.
These are some reasons why QuickBooks balance is different from the bank balance:
Moreover, this article can help you identify the problems for reconciled accounts: Fix issues for accounts you've reconciled in the past.
We're here to lend a hand if you require further help with QuickBooks or bank balances or any QuickBooks queries. Have a great day.
Can you please explain this rebuild/rpair data to me in more detail? I am having a similar issue. I import the data from my bank directly to QB desktop, then categorize and I make sure during reconcile screen the accounts (usually transfers) match and I still have this issue of the balances once matched, and now they are way off again and the reconciles match, but the amount quickbooks shows against the account when I am finished with reconciles is usually off. It varies depending on the account or transactions reconciled, but it is never a consistent pattern for me to determine if something is not being matched or was simply duplicated.
Thanks for reaching out regarding your issues with reconciling accounts in QuickBooks Desktop (QBDT), Brittny. I see how challenging it can be when balances don't align despite your efforts to match transactions correctly.
To address your question about the Verify and Rebuild Data in QBDT, the verify tool helps to identify common issues in a company file, while the rebuild tool is used to fix them. For more details, visit this article: Verify and Rebuild Data in QuickBooks Desktop.
Regarding your reconciliation concern, ending balance issues stem from the following:
If you haven't already, ensuring your opening and beginning balances are correct is essential. Once you've confirmed this, you can look for changed, deleted, or added transactions by running these reports:
Additionally, you can look for reconciliation adjustments. Sometimes, users make a reconciliation adjustment to force an account in QB to match their bank records. However, doing this with your accountant's guidance is recommended, as this doesn't fix errors and can cause issues if mistakes are corrected later.
Here's how to review the account:
Once everything is sorted out, you can finish reconciling.
For more detailed information, refer to this article: Fix issues when you're reconciling in QuickBooks Desktop.
Moreover, closing your books is essential to prevent changes in your past entries.
Let me know if you have any other concerns or questions. It's always a pleasure to support you, Brittny. Take care.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here