How to Purge Cleared Transactions in Bank Reconciliation for Sage 100

Description

How to purge cleared transactions in Bank Reconciliation in Sage 100

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)
  1. 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.
  2. Close Preview Window
  3. 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 ending transaction date used when printing the report.
  4. 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 ending transaction date used when printing the report.
  6. Click Yes to purge the cleared documents

Support

If necessary, seek the assistance of Acute Data Systems to help provide assistance with this process.