THERE WAS AN OLD VENDOR CHECK FROM 2017 IN THE "TO BE PRINTED" STATE FROM 2017. IT WAS PRINTED BY ACCIDENT AND THEN DELETED. NOW MY BEGINNING BALANCE FOR THE RECONCILIATION THIS MONTH SHOWS THAT ACCOUNT POSITIVE FOR THE SAME AMOUNT.
AND THE DISCREPANCY REPORTS SHOW UP BACK TO 2017. PLEASE ADVISE THE BEST WAY TO GET THIS CLEANED UP. THANK YOU IN ADVANCE!
Hello there, TPAINTER.
I'm glad you reached out to us. Let's get this sorted.
To fix this, you'll just need to recreate the vendor check to correct your balances. Below are the steps on how to do it:
For future reference, you can visit this article: Create, modify, and print checks.
Also, you can open the Voided/Deleted Transactions Details report in case you want to have a reference of the details of your vendor check.
You should be all set! If there's anything I can further assist you with, please let me know. I'm always here to help you out.
I've done that, however, it doesn't change my opening balance on my current reconciliation back to the correct balance. What moves can I make to make this happen?
Thank you for your help!
Thanks for getting back and sharing how the steps went on your end. I'm here to help provide additional information to get this working for you.
Now that you're done recreating the check, the next thing you'll have to do is open your bank register and manually reconcile the transaction. To do that, you'll need to put a check-mark to that transaction so it'll reduce the opening balance of the current reconciliation.
That's it. I'm including this article in case you need it for future use: Zero or incorrect Beginning Balance in the Begin Reconciliation Window.
Keep me posted if you have additional questions about reconciliation. I'm here to keep helping.
Let's fix your incorrect opening balance, @TPAINTER.
Deleting, voiding, or modifying cleared and reconciled transactions is the likely reason why the opening balance is off.
You'll have to run the Reconcile Discrepancy and Previous Reconciliation reports to verify what's causing the discrepancy. Then you can compare it to the Audit Trail report to change it back. However, you may need to re-enter or edit the transactions.
For detailed instruction, check out the Zero or incorrect Beginning Balance in the Begin Reconciliation Window article and proceed to the To fix an incorrect balance section.
We can also try undoing the previous reconciliation and redo it:
That should correct your opening balance, @TPAINTER. Please let me know the outcome. I'm still here to help you more.
I have 2 questions before I undo the last Recon....
One is that this check was dated back in 2017 and would I have to unrecon ALL those?
Secondly.... It was a check that was created before me and was only in the "Checks to be printed" Status. Does that effect what is going on?
Please advise and thank you!
Go to Reports / Accountant / Audit Trail and search for the date that it was deleted. When you find it, record the original transaction details. Then re-enter the check as it was originally entered, including the original date.
[OPTION: If you are using accounts payable, deleting the check should have put the invoice back into A/P. You can just cut a new check from A/P as usual, but use the original check date.]
This should get your bank recon back into balance.
Now the question is: was this un-printed check ever marked as cleared? Or was it still outstanding? You may to take additional steps to properly write the check off in the current year.
Let me know if you need anything else.
Mark Wagner, CPA
Let me take over and help you further in fixing your bank reconciliation discrepancy via the QuickBooks Desktop.
To answer your first question, yes, you'll need to undo all the transactions that were reconciled since then. Secondly, the deleted check affects the balance of your 2017 reconciled transactions.
If you decide to undo the last reconciliation, the assistance of an accountant is a must. Your accountant can provide you expert ways of dealing with this situation.
These articles are a good reference:
For additional help, you can also reach out to our QuickBooks Desktop Support.
I'll be around if you need more information about reconciliation in QuickBooks Desktop. Have a great day.