Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Hi all,
Hoping to connect with somebody that might have encounter similar error we are encounter and hopefully find a solution, before I am embarked with calling QB and spend hours on the phone with someone that might know less than I do from QB. Unfortunately, we have always had issues with bank reconciliation with QB.
Our problem is in the bank reconciliation screen appears a few transaction from previous years. Specifically employees checks done manually via a Payroll YTD adjustment due to some problem with the checks on QB. I can't remember why it has this adjustments. Probably an issue with Payroll. We used Quickbooks payroll.
Now the problem is the beginning balance is correct on the account, reason why discrepancy report is 0 and can not do a mini reconciliation to fix this because the beginning balance is correct. I am very disappointment with QB Enterprise, don't know why they don't have a feature like online that you could marked it as reconciled and be done. It should be as Quick books Online. I have the most expensive QB out there and some things are better ONLINE does not make any sense.
I would appreciate any help I can get.
There might be possible data damage happening, @solocaptan. I'll help you fix beginning balances issues in QuickBooks Desktop.
The Starting Balance is zero or inaccurate when you start the reconciliation process and choose an account to reconcile. It results in one of the following:
You can re-create the opening balance if it's your first time reconciling the account. Then, make a journal entry to correct the beginning balance. Make a note in your journal. On the Begin Reconciliation window, enter the precise date.
Reconcile to correct the Beginning Balance
You can also run a Reconciliation Discrepancy to see a list of changed transactions since your last reconciliation. Use this report to identify the transaction(s) causing the issue.
You run the Audit Trail report for a specific transaction. You can customize and filter the data to locate the invoices.
Here's how:
This article can guide you in generating reports in your QBDT to show the details you need: Customize reports in QuickBooks Desktop.
You can contact us again if you have any more queries or worries. I'd be happy to assist you and find a quick solution. Enjoy your day.
Christine,
Thanks for the reply. First problem, no data damage. Is checked regularly with file doctor and when doing backup. no conversion of any kind.
This account was reconciled reason why beginning balance is correct. Moreover discrepancy reports shown 0.
No solution here.
This is a problem with QB should not have beginning balance correct so this transactions could be marked as reconciled.
I appreciate you for coming back to the thread and adding extra clarifications about your concern, solocaptan. I'll be sharing the possible cause of why there are reconciled entries that keep appearing in your reconciliation and how you can fix it by following the steps below.
Since the beginning balance is correct and discrepancy reports show 0 but the reconciliation screen still shows entries from previous years, it could be there's a duplicate transaction on your books. That said, you can delete the following transactions and make sure they are not linked to the other data to avoid errors in your bank transactions.
Here's how to delete entry:
If you're using the accountant version, you can check out this article to see steps on how to perform the process by bulk: Batch delete or void transactions in QuickBooks Desktop Accountant Edition.
Lastly, you may refer to this article to view different guidelines that can help fix any reconciliation issues: Learn the reconcile workflow in QuickBooks.
Please add a comment below if you require further assistance with reconciling your account. I'm always determined to find a solution, solocaptan. Have a nice day!
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