Skip to content
logo Knowledgebase

How to purge cleared transactions in Bank Reconciliation

Created on  | Last modified on 

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:

  1. Out of Balance shown in Reconcile Bank window is $0.00.
  2. 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:

  1. Open Bank Reconciliation, Main, Bank Reconciliation Register.
  2. 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)
  3. 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.
  4. Close Preview window
  5. 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.
  6. Click Yes to purge the cleared documents


In version 4.40.0.3 and above:

  1. Open Bank Reconciliation, Main, Bank Reconciliation Report.
  2. 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)
  3. 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.
  4. Close Preview
  5. 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.
  6. 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