Solved! Go to Solution.
Look in your check register for items that have been cleared AFTER the date of your last check reconciliation. I JUST NOW found mine. There was nothing in the reconciliation discrepancy reports and every month's statements cleared deposits/debits matched. I somehow managed to check an entry that was AFTER the date of the last statement. Go in, uncheck those entries and that should fix your problem.
I am having the same problem, but I have un-reconciled all the way back to the beginning of a bank account (April '18) and it STILL shows a negative $5,000+ beginning balance, but there are no entries in the QB Bank Account that pre-date April '18. I've verified & rebuilt the data already. No luck. Any other advice?
Hi there, AMPRVA.
Thanks for taking the time to visit the Community. I'd be glad to help you get the beginning and ending balances to match for your reconcile.
There are few reason why these two balances may not be matching up. Some of these reasons may include uncleared checks or duplicate transactions.
I've got a couple articles for you that will walk you through fixing the beginning and ending balances. This first one covers what to do when the opening balance is wrong: https://quickbooks.intuit.com/community/Banking-and-bank-feeds/My-reconcile-opening-balance-is-wrong....
This next write-up shows you the steps for correcting balances if previously reconciled transactions were modified: https://quickbooks.intuit.com/community/Banking-and-bank-feeds/Zero-or-incorrect-Beginning-Balance-i....
This information will allow you to get everything matching up nicely. Feel free to leave a comment if you have any additional questions.
Try simply Ignoring the beginning balance. Use the known Ending balance and reconcile as usual. You likely will find an Uncleared historic transaction, mark it, and the difference will be 0 and you are back on track. This is why you never also had to keep Undoing reconciliations. This is called an Interim Reconciliation or Mini-Rec process. You use that process, including Ignoring the Beginning balance, when you did some housekeeping that affected Cleared Status, or you deleted and recreated transactions, such as Transfers needed splits, so your replaced them with Checks, etc.
Most probably I am also facing same problems. But I have huge difference between my real bank account and QB bank account and I unable to get that how should be fix. Should I pass a adjustment entry for that or should I do something else. Could you please guide me.
I'm here to guide you how you can fix the differences between your accounts.
There are several reasons why these two account balances are not matching. One of these are have modified, deleted, or added to your old reconciled transactions.
If you have previously reconciled an account but it shows a different balance in the next reconciliation, your account has reconciliation discrepancies. To resolve this, please follow the steps to fix the issue.
Here's how you can check for reconciliation discrepancy report:
1. From the Reports menu,
2. Select Banking then click Reconciliation Discrepancy.
3. Review the report to identify any discrepancies.
Once done, if you can't find any discrepancies, you can verify your accounts if there's a missing transactions. See the steps below:
1. From the Reports menu, then choose Banking.
2. Click Missing Check.
3. Choose the appropriate account, then select OK.
4. Review the report transactions that don't match your bank statement.
You can refer to this article for more detailed steps to fix the issue of reconciliation discrepancies.
As always, you can contact our QuickBooks Support team if you need assistance with the steps. This way, they can pull up your account in a secure environment and help you navigate using one of their tools like screen sharing.
That should get you fixed right up. Let me know how it goes or if you're referring to something else by leaving a comment. I'm always here to help. Have a great weekend.
Thank you for your prompt reply.
Yes it was very helpful for me and I understood.
I was one more query like I have rental business and in 2018 the rental income showing huge amount more than 2017. So what could be reason to hike income even I know that our income should not be increase because the customers number are same. But I have make few tenants inactive and it's showing deleted in brackets of transactions. So can we delete those transactions which have inactive(deleted) have added in bank of QB than may be income will reduce. Or there is occurred issue from undeposited fund because we have lots of transactions in undeposited fund from 2016. Or you have any solutions to reduce income..
It may be possible of duplicates deposits then how we can find duplicates deposits, is there any key notes to find duplicates deposits?
Thanks in advance for your prompt reply 😊...
Thanks for getting back to us with the additional information, Rohit.
Let's run the Profit and Loss standard report to check why you're income increased. You can follow the steps below:
You can customize this to check if there's a duplicate deposit, please follow these steps:
Or you can press CTRL+F to see if you the income transaction. Click the duplicate transaction and delete it by pressing CTRL+D on your keyboard.
Let us know how it works for you. We'll be right here to help you. Enjoy your day!
I am having this same problems which resulted after I changed from Mac to WIndows.
Anyone else have this problem and how did you resolve it?
Hello there, @lmargolis,
When you convert QuickBooks Mac to the Windows version, some transactions may get unreconciled. This causes the program to have an incorrect beginning balance.
To help fix this, let's first run any of these reports to locate the unreconciled transactions. You can also review transactions to see if there are edited, deleted, or cleared transactions on these reports.
You can perform the steps provided by ShallyMarR above on how to run the first report. To pull up the second report:
Once verified, you'll have to re-enter or edit the transactions. Then, reconcile the account again.
However, if the balance is zero, you can create a journal entry to recreate the opening amount. Then, perform a mini-reconciliation to correct it. For detailed steps, see the To correct a zero balance section through this article: Zero or Incorrect Beginning Balance.
I want to make sure that your account accurately reflects your business transactions. With this, check out this article for further troubleshooting steps on how to fix discrepancies: Resolve Reconciliation Differences.
I'm just a comment away if you need anything else. Have a great day.
I've tried everything suggested in this Community blog. But I'm still out of balance. My difference is over $10,500. So that is definitely significant. Somehow QB decided to clear 11 checks/electronic withdrawals dated November after I completed and reconciled October (but before I worked on November). I had nothing to do with it. I went to reconcile the November statement and was out over $10,500. The 11 transactions were not in the list to clear. I searched for them and found that they were cleared. I deleted the "cleared" transactions and re-input them with an "A" after the check number to differentiate between the two sets of debits. Still no luck. I finally realized it was the opening balance that carried forward incorrectly because these transactions "cleared." Now what????? Data verification and the numerous other options did nothing. I need to fix this NOW. The tax return needs to be completed.
This isn't what I want you to experience, BAlbert1.
Since the same thing happens, it would be best to reach out to our Phone Support team. This way, they'll validate why this issue persists.
I'm always around if you still need my help.