Summary
How to purge cleared transactions in Bank Reconciliation.
Resolution
The following criteria must be satisfied to have the option to purge the cleared transactions:
- Out of Balance shown in Reconcile Bank window is $0.00.
- Out of Balance shown on the Bank Reconciliation Register/Report line is $0.00 Please see steps below on how to verify Bank Reconciliation Register/Report out of balance is $0.00
Note: If the out of balance amounts shown in Reconcile Bank window and on the Bank Reconciliation Register/Report do not match, please see Related Article below.
In versions 4.10 - 4.40.0.2:
- Open Bank Reconciliation, Main, Bank Reconciliation Register.
- Deselect the Summarize Activity check box, and make the following selections:
- Document Types to Print = All Types
- Print Cleared Documents = All Documents
- Bank Code Operand = Equal to
- Bank Code Value = select the applicable bank code
- Document Date Operand = All, Less than, or Range (Note: When selecting Range, enter an ending date in the second Value field. To purge up to a specified date, leave the first date range value blank and select the ending date in the second Value column to purge up through)
- Click Print or Preview
- Note: If the appropriate security is not set up, the report must be printed to a printer, to file, or to deferred.
- Close Preview window
- The message "Do you want to remove cleared documents as of mm/dd/yy?" will display only if the out-of-balance amount on the report is $0.00. This date is the Document Date used when printing the report. If Document Date is left blank then the date displayed will be 12/31/2999.
- Click Yes to purge the cleared documents
In version 4.40.0.3 and above:
- Open Bank Reconciliation, Main, Bank Reconciliation Report.
- Deselect the Summarize Activity check box, and make the following selections:
- Document Types to Print = All Types
- Print Cleared Documents = All Documents
- Bank Code Operand = Equal to
- Bank Code Value = select the applicable bank code
- Document Date Operand = All, Less than, or Range (Note: When selecting Range, enter an ending date in the second Value field. To purge up to a specified date, leave the first date range value blank and select the ending date in the second Value column to purge up through)
- Click Print or Preview
- Note: If the appropriate security is not set up, the report must be printed to a printer, to file, or to deferred.
- Close Preview
- The "Do you want to remove cleared documents as of mm/dd/yy?" will display only if the out-of-balance amount on the report is $0.00. This date is the Document Date used when printing the report. If Document Date is left blank then the date displayed will be 12/31/2999.
- Click Yes to purge the cleared documents
DocLink: Reconcile Bank is in balance but the Bank Reconciliation Report is out of balance or vice versa