cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

BANK REC OFF DUE TO OLD CHECK BEING DELETED

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!

 

 

9 Comments
QuickBooks Team

Re: BANK REC OFF DUE TO OLD CHECK BEING DELETED

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:

  1. Go to Banking.
  2. Click Write Checks.
  3. Enter the necessary information and make sure the date is from 2017.
  4. Click Save & Close.

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.

 

Here's how:

  1. Go to Reports.
  2. Click Accountant & Taxes.
  3. Voided/Deleted Transactions Details.

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.

Not applicable

Re: BANK REC OFF DUE TO OLD CHECK BEING DELETED

HI Charles!

 

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!

 

 

Anonymous
Not applicable

Re: BANK REC OFF DUE TO OLD CHECK BEING DELETED

Hello, @TPAINTER.

 

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.

Not applicable

Re: BANK REC OFF DUE TO OLD CHECK BEING DELETED

Hi Lily and thank you.

 

Its not working. Logically, it should buy it’s not.

Any ideas???

 

Thank you!

QuickBooks Team

Re: BANK REC OFF DUE TO OLD CHECK BEING DELETED

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:

  1. Create a backup copy of your company file. This is to ensure weren't messing up your recordings.
  2. Go to the Banking menu and choose Reconcile.
  3. In the Begin Reconciliation window, select Undo Last Reconciliation.
    1.PNG
  4. When prompted, select Continue then OK.
  5. Reconcile the account again.

That should correct your opening balance, @TPAINTER. Please let me know the outcome. I'm still here to help you more.

Not applicable

Re: BANK REC OFF DUE TO OLD CHECK BEING DELETED

Hi HoneyLynn!

 

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!

 

Tricia

 

 

Super Contributor **

Re: BANK REC OFF DUE TO OLD CHECK BEING DELETED

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

Not applicable

Re: BANK REC OFF DUE TO OLD CHECK BEING DELETED

Hi there!

Did you see my questions from earlier?

 

Please advise and thank you!!!

 

Tricia Painter

Moderator

Re: BANK REC OFF DUE TO OLD CHECK BEING DELETED

Hi, TPAINTER.

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.

 

  1. Within your QuickBooks Desktop, click Help at the top menu bar.
  2. Click Contact us.
  3. To route you to the correct support expert, we need to know what type of question you have. Give a brief description of your issue and click Continue.
  4. We’ll provide you a few options. You choose which one is best for you

I'll be around if you need more information about reconciliation in QuickBooks Desktop. Have a great day.

Need to get in touch?

Contact us