reconciling bank

michaelsrv · ‎April 28, 2021

I am trying to reconcile my bank account and the previous month was reconciled to "0". When I try to reconcile the next month it is telling me there is a $2000 difference (after I get thru selecting all that is on the bank statement that is cleared). My bank statement matches my deposits and my withdrawals but it is still showing a $2000 difference and I can't find where it is coming from. I have tried deleting all my reconciliations from last year and redoing them all and it still shows on there. Any ideas of where I can look to try and find where the $2000 is coming from.

CharleneMaeF · ‎April 28, 2021

Thanks for updating us how it goes, michaelsrv.

It's possible that someone changed or deleted some transactions in your file. Let's perform a special reconciliation to zero out the $2000 balance. This method uses an "off-cycle" date. Please ensure you know the ending balance from the recent reconciliation.

Here's how:

Go to the Banking menu and then select Reconcile.
Choose the bank account with the transactions you need to reconcile.
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.
In the Ending Balance field, enter the balance of your last successful reconciliation.
Select Continue.
From the Reconcile window, check off the transactions you are fixing and re-reconciling.
Make sure the Difference field shows $0.00.
When everything looks good, select Reconcile Now.

For further guidance, please see this article: Do a Special Reconciliation.

I'd also suggest consulting an accountant to avoid messing with your books.

Additionally, I've included these articles to ensure you'll reconcile your account successfully:

Learn the Reconcile Workflow in QuickBooks

In case you'll need assistance in reconciling your account, don't hesitate to get back to this thread. I'm determined to get the difference resolved.

View solution in original post

Kristine Mae · ‎April 28, 2021

I'm here to help you check why you have a difference, Michaelsrv.

It's a good job for going through your bank statement and ensuring all transactions are correct. We'll have some things to check as well.

We'll start with looking for any changed, deleted, or added transactions. We have three reports that you can run to check them out:

Reconciliation Discrepancy report
Missing Checks report
Transaction Detail report

Then, let's also check for reconciliation adjustments. It also affects the balances.

You can refer to this article to better guide you: Fix issues when you're reconciling in QuickBooks Desktop.

Feel free to get back to this thread if you need more help. We'll get back to you as soon as we can. Keep safe!

michaelsrv · ‎April 28, 2021

I have done those three reports and there are no $2000 discrepancies or uncleared balances with that amount. Any other ideas? This is from 2019 and the only reason I found it was because I was reconciling my current bank statements and it kept showing the $2000 which I traced back to 2019. As I said in my earlier remark the month before this amount started showing was "0" after I reconciled (which was 8/2019). Also, the starting balance and ending balance is correct. It is a mystery to me and the first time anything like this has happened. I usually have no trouble reconciling every month. The only thing I can think of is that something was changed somewhere that is effecting 2019 now.

CharleneMaeF · ‎April 28, 2021

Thanks for updating us how it goes, michaelsrv.

It's possible that someone changed or deleted some transactions in your file. Let's perform a special reconciliation to zero out the $2000 balance. This method uses an "off-cycle" date. Please ensure you know the ending balance from the recent reconciliation.

Here's how:

Go to the Banking menu and then select Reconcile.
Choose the bank account with the transactions you need to reconcile.
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.
In the Ending Balance field, enter the balance of your last successful reconciliation.
Select Continue.
From the Reconcile window, check off the transactions you are fixing and re-reconciling.
Make sure the Difference field shows $0.00.
When everything looks good, select Reconcile Now.

For further guidance, please see this article: Do a Special Reconciliation.

I'd also suggest consulting an accountant to avoid messing with your books.

Additionally, I've included these articles to ensure you'll reconcile your account successfully:

Learn the Reconcile Workflow in QuickBooks

In case you'll need assistance in reconciling your account, don't hesitate to get back to this thread. I'm determined to get the difference resolved.

Topics

Training

Community

Resources

reconciling bank