Quickbooks deleted an old paycheck and is now out of balance

Let me guide you on how to fix your reconciliation so everything will go back to balance, Zenbutcher.

Normally, once you've already saved your reconciliation, QuickBooks doesn't have the option to do any changes to your account unless it was done by another admin. You'll want to do a mini-reconciliation so you can fix everything. But before doing so, I still recommend reaching out to your accountant to guide you through the process. To start, you'll have to fix transactions in a bank account. Here's how:

1. Go to the Banking menu and select Reconcile.
2. Select the bank account with the transactions you need to reconcile.
3. In the Date of Statement field, enter the date for an "off-cycle reconciliation." This date can be any date between your last reconciliation and the next scheduled one.
4. In the Ending Balance field, enter the balance of your last successful reconciliation. Then select Continue.
5. In the Reconcile window, check off the transactions you are fixing and re-reconciling.
6. Make sure the Difference field shows $0.00.
7. When everything looks good, select Reconcile Now.

Once done, QuickBooks asks if you want to Create a Payment Check or Create a Bill to Pay Later after you select Reconcile now. To know more about how you'll be able to do this, you can check this article for more details: Reconcile Previously Deleted And Re-Entered Checking Or Credit Card Transactions. 

Furthermore, to ensure that your QuickBooks Desktop account is protected, you'll want to reset your admin password. This is to ensure that only you have the access to your account. I've added this article so you'll have a quick reference with the process: Reset Your Password For QuickBooks Desktop.

Fill me in if you have any concerns with your reconciliation. I'm always right here to help you anytime.

Hello Maria - no this does not work.  I am not needing to do a reconciliation.  My bank account is not linked to QB.  I also do not reconcile in QB monthly.  I just manually reconcile the month ending bank balance to my month ending Expense Account Operations QB account off the books.

Please see the attached file.  This is where I am off.  It has added $1,332.88 to my Expense Account Operations balance.  Every month ending is now different from the inception in September 2018 to the last month ending October 2022.  Each has an additional $1,332.88 from the original correct balance.  

How do I get rid of this?

Hello Maria,

The solution you have here does not work.  I do not reconcile in QB.  I only manually do this with my checking account balance and compare it to month end for my QB Expense Account Operations balance.

I have attached what is in the Deleted Transactions Summary.  The amount of $1,332.88 was added back into the Expense Account Operations balance on 11-2-22 from 9-4-18 onward.  Thus every month end from Sept 2018 to Oct 2022 is off by exactly $1,332.88 from what it originally was.  Thus for month end Oct 2022 the balance should be $62,894.38 as it showed on my printed report for Oct 31 when I printed it on 11-1-22.  As of today that month end balance now shows it to be $64,227.26, exactly $1,332.88 higher.

How do you fix this?

Thank you for the screenshot, Zenbutcher.

You'll want to run the Verify and Rebuild data utilities to check if is just caused by random issues. Please back up your company file to keep a copy of your file.

Here are the articles for your reference:

• Back up your QuickBooks Desktop company file
• Verify and Rebuild Data in QuickBooks Desktop

If you have any other concerns, feel free to reach back out. Have a good one!

I am not understanding what you wanting me to do Jess.  I don't care what caused it, I want to know how to fix it.

Now are you showing me how to save the company file before I try to fix/reverse the problem that was created on the attachment I sent?  

All I need to know how to do is how to reverse what is shown on the attachment.  How do I do that?

To me it would appear what needs to be done here is to to restore check #17651.  That is the only way the Expense Account Operations account will be brought back into balance since it is overstated by $1,332.88.  Since that transaction is from Sept 2018 I would assume I also have to restore that check using that date.

Please advise if this is correct before this turns into an even bigger fiasco.

Thanks.

Thank you Rainflurry.  In order to recreate the check you also have to put in the same gross amount, and do the deductions the same for Fed, SS, Medicare, State Tax for employee and then the Employer contribution part as well.  This was all done as of 9-4-18 so hopefully nothing will appear on my reports for November 2022.

My Expense Account Operations balance is back to where it should be and matches my bank account balance.

THANK YOU!!!!!!!!!

I have deleted the wrong duplicate before and had to undo recon and re reconcile multiple months worth of data. This has save me sooo much time. I never though about changing the data and it not messing things up after that date.

You have saved me!! THANK YOU! In the past I would have too reconcile each month again. When it was an old check it took forever. I never knew I could change the date and not effect the other reconciliations.