Question

How do I clear out old transactions in my bank reconciliation from years ago?

Forum|Forum|5 years ago
September 17, 2020
2 replies
0 views

I have taken over the books from someone previous. How do I clear out old transactions in my bank reconciliation from years ago? Most of these are done from journal entries in the past. I don't want to re-reconcile from 10 years ago.

QuickBooks Desktop

BigRedConsulting

If the transactions represent transactions that really happened, or they cancel each other out, and so the ending bank balance is correct, then run a special reconcile and mark them all off at once.

H

hitekcommAuthor

Some are checks and some are journal entries from different years. I don't know why at this point they have not been cleared out. They do not clear each other out. Any other solutions?

R

rvrfrf

Thanks for following up with the Community about this, hitekcomm.

There's a few reasons why previously reconciled transactions can show up as unreconciled:

Cleared transactions were unchecked in your account register.
The reconciled transactions were charged or deleted.
A prior reconciliation was undone.
Money was transferred from a previously reconciled bank account to a sub-account.
A company file conversion was performed (Mac to Windows or QBO to QBDT).
Your transactions were never reconciled successfully. This could be caused by restoring from a backup, which can overwrite existing data.

As BigRedConsulting mentioned, you can perform a special reconciliation to correct these problems.

Here's how:
1. In the top menu bar, go to Banking, then Reconcile.
2. Choose which bank account you're working with.
3. Use the Date of Statement field to enter a date for an off-cycle reconcile. This can be any day between your last reconciliation and the one that's scheduled next.
4. Enter a balance for your last successful reconciliation in the Ending Balance field.
5. Click Continue.
6. On the Reconcile window, check off each transaction you're fixing.
7. Confirm your Difference field shows $0.00.
8. Select Reconcile Now.

I've also included a detailed resource that provides more information about performing special reconciliations: Reconcile previously deleted & re-entered checking or credit card transactions

Feel more than welcome to post a reply if there's any questions. I'll be here to help. Have a wonderful day!

A

ataylor32

How do you reconcile something that was cleared early in the bank statement, but you cannot change the date because it connects to payroll?

J

jeanbiverly_

I'm here to help you with the reconciliation process, @ataylor32.

If you can't change the date of a cleared transaction because it's linked to payroll, you'll need to remove the Date filter to view all your transactions. This will help you reconcile them and match your bank statement.

Here's how:

Go to the Transactions menu.
Select Reconcile.
From the Account dropdown, select the account you want to reconcile.
Click on the Resume reconciling button.
In the Reconcile [account name] page, click the Clear filter or View all option. You can also filter the Date to All.
Manually locate the transaction and put a checkmark next to the amount to mark it as reconciled.

Once you've completed these steps, you can continue reconciling your account. For more detailed guidance, visit this article: Reconcile an account in QuickBooks Online (QBO).

Just in case QBO doesn't match your bank statement at the end of the reconciliation, you can check out this article for steps to fix it: Fix issues at the end of a reconciliation in QBO.

You can always get back to this thread if you have other concerns besides reconciliation. The Community has got your back.

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded