Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Connect with and learn from others in the QuickBooks Community.
Join nowWhen I called about this issue I got nowhere. And I just don’t have the time for yet another four hour phone call.
Why is this not balanced? The ending balance is correct. The credit is correct the seven charges are correct and yet...there is a $466.98 difference.
Do the math outside of the program the numbers are correct...yet QuickBooks is wrong.
Beginning Balance: 333.97
Charges -314.38
Payment +80.89
Ending Balance 100.48
So how is there a difference $466.98???
Let me help you with your reconciliation issue, Keith61.
We'll have a few things to check so we can fix the issue.
First, aside from checking the ending balance, we'll have to review the opening balance as well. Let's ensure the amount is accurate.
Next, let's check for any edited or delete transactions. It will affect the reconciliation balance.
Then, we'll have to look for reconciliation adjustments. It can cause reconciliation errors.
For the detailed steps, you can check this article: Fix issues when you're reconciling in QuickBooks Desktop.
You can get back to this article if you need more help. We'll be around to assist you. Keep safe!
Everything is correct. the math outside of QuickBooks balances. Your system does not.
ALSO-If you reverse all the transactions it will balance. The issue with that is a credit is a credit and a debit is a debit. I cannot have payments made to the clients account as a debit. Their P&L will be a mess.
Hello @Keith61,
Thank you for posting here in the Community. I'm here to help you fix the reconciliation in QuickBooks Desktop.
This usually happens when there are issues or changes to the transactions. For now, I recommend running a report to isolate and fix the difference.
You can use the Reconciliation Discrepancy report. This shows any transactions that were changed and they're sorted by statement dates.
Here's how:
Also, I suggest unchecking the Hide transactions after the statement's end date box in the Reconcile window (see screenshot below). That should help you find items that were marked cleared.
If the problem persists, I suggest contacting our Customer Support Team again. They have the tools unavailable here to further check the issue in the company file.
Let me walk you through how:
I've also attached an article you can use to resolve data damage, as well as how to download and use the application: Fix common problems and errors with the QuickBooks Desktop Tool Hub.
Drop me a comment below if you have any other questions about the reconciliation. I'll be happy to help you some more.
That does not account for the math done outside the program as being correct AND if you reverse everything it balances in quickbooks. We do not do reconciliation discrepancies. I do not have the time for yet another 4 hour phone call.
Thanks for getting back to us, @Keith61. Allow me to chime in and share additional details to fix the difference.
Your balance will be incorrect if a previously cleared transaction in your register was voided, deleted, or changed, or a new transaction was added and cleared since your last reconciliation.
For now, I'd suggest following the steps shared by my colleague AlcaeusF to run Reconciliation Discrepancy and make sure to uncheck Hide transactions after the statement's end date box in the Reconcile window. The Previous Reconciliation Detail reports can check and compare balances and determine the last correct reconciled transaction. Just go to your Banking menu to find these reports.
Another report that can help you look for recent transactions that may have been cleared or uncleared unintentionally is the Bank Account QuickReport. You can have this by going to the Lists menu and then Chart of Accounts.
Also, you can do a special or mini-reconciliation to correct your opening balance. It's a process that uses an "off-cycle" reconciliation date to correct. Let me guide you on how:
You can learn more about this process through this article: Reconcile previously deleted and re-entered transactions.
Upon sharing the steps above, I'd still suggest consulting your accountant. They can help you resolve the difference and check your account to ensure your books are accurate.
Additionally, you can learn more about fixing beginning balance issues through this article: How to fix the beginning balance discrepancies when doing reconciliation. It includes topics about undoing previous reconciliation and how to redo it.
Please let me know if you have other reconciliation concerns or inquiries. I'm just around to assist you further. Take care always.
If you would take a moment and actually do the math using a calculator you will see that the math is correct and quickbooks is wrong. If you do not know how to balance an account please find someone who can show you.
The math is correct. The beginning balance is correct, the charges are correct, the payment is correct, the ending balance is correct. It balances on my 10 key. It does not in quickbooks.
Please send this up the food chain to get it fixed.
Was this issue ever resolved? I'm having the exact same issue on Quickbooks for Mac. After checking off the items to reconcile, Quickbooks shows I'm off by hundreds of dollars, but it should be zero. I've gone so far as to undo all prior reconciliations and go back to the opening balance and start from scratch. The first month will reconcile, but when I go to the second month it is off by several hundred dollars.
Hi there, @Mike B1.
Thanks for following along with the thread and sharing your concerns here in the QuickBooks Community.
Since you're not locating the discrepancy, I recommend we run a Rebuild and Verify on the company. This is so we can ensure there isn't any data damage in the company file that could be causing the reconciliation to be off by several hundred dollars. You can use the steps I've included below to run the utilities.
To Rebuild:
To Verify:
For additional information about this process, check out Verify and rebuild data in QuickBooks Desktop for Mac.
Once you've completed those steps, let's go ahead and see if your reconciliation is off. If so, I recommend consulting with an accounting professional. An accountant can review your account and help locate any discrepancy within the company file that's causing the reconciliation to be off. If you don't have an accountant, don't sweat. You can find one here in our Resource Center.
Please don't hesitate to let me know if you have any questions or concerns. I'm always around to lend a hand. Take care!
Can you post screenshots or give more info on your second month?
There is no issue with OP's original post - QB is doing everything properly. The OP stated the math was wrong in QB, but when you look at the original screenshot, QB is right:
$333.97 beginning balance
+$314.38 charges
- $80.98 credits/payments
- $100.48 ending balance
= $466.98
Couple of things could be the cause.
Either you are missing a payment that you made to the CC company OR your statement balance is not 100.48 but it is 567.46 (given that all other info you provided are correct.
Do things in order that they happened.
$333.97 Beginning balance
- $ 80.89 (payment/credit)
+$314.38 New charges
$567.46 (what would be the "ending balance" / statement balance)
Alternatively, you statement balance is 100.48 and you are missing a payment of $466.98 that was made.
$333.97 Beginning balance
- $ 80.89 (payment/credit)
-$466.98 (missing payment possibly)
+$314.38 New charges
$100.48
It's nice to see you here in the Community, @CaitCAS.
We appreciate you sharing a response to fix the reconciliation issue. Your reply will be of great help as a reference for other users who have encountered similar concerns who will visit and read this thread.
Just an additional resource, feel free to access our Reconciliation hub whenever needed.
Have a great day ahead and thanks for dropping by.
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.