How To Purge Cleared Bank Reconciliation Transactions in Sage 100

To purge cleared transactions in Sage 100 Bank Reconciliation, ensure that the “Out of Balance” amount in both the Reconcile Bank window and the Bank Reconciliation Register/Report is $0.00. Then, open the Bank Reconciliation Register (or Report for version 4.40.0.3 and above), deselect the “Summarize Activity” checkbox, and set the necessary report options including document types and date range. After printing or previewing the report, if the out-of-balance amount is still $0.00, you will be prompted to remove the cleared documents as of the specified date. Confirm the prompt to complete the purging process.

Step-By-Step: Purge Cleared Transactions in Sage 100 Bank Reconciliation

Requirements

Before you can purge cleared transactions from the Sage 100 Bank Reconciliation module, ensure the following:

• The “Out of Balance” amount in the Reconcile Bank window is $0.00.
• The “Out of Balance” amount on the Bank Reconciliation Register/Report line is $0.00.

Steps for Sage 100 4.10 – 4.40.0.2

1. Open Bank Reconciliation Register
   • Go to Bank Reconciliation > Main > Bank Reconciliation Register.
2. Set Report Options
   • Deselect the “Summarize Activity” checkbox.
   • Set “Document Types to Print” to “All Types”.
   • Set “Print Cleared Documents” to “All Documents”.
   • Set “Bank Code Operand” to “Equal to”.
   • Select the applicable bank code for “Bank Code Value”.
   • Set “Document Date Operand” to “All”, “Less than”, or “Range”. If using “Range”, leave the first date blank and select an ending date to purge up to that date.
3. Print or Preview the Report
   • Click “Print” or “Preview”.
   • Note: If security settings are not configured, the report must be printed to a printer, file, or deferred.
4. Purge Cleared Documents
   • Close the Preview window.
   • If the out-of-balance amount is $0.00, a message will appear: “Do you want to remove cleared documents as of mm/dd/yy?”.
   • Click “Yes” to purge the cleared documents.

Steps for Sage 100 4.40.0.3 and Above

1. Open Bank Reconciliation Report
   • Go to Bank Reconciliation > Main > Bank Reconciliation Report.
2. Set Report Options
   • Deselect the “Summarize Activity” checkbox.
   • Set “Document Types to Print” to “All Types”.
   • Set “Print Cleared Documents” to “All Documents”.
   • Set “Bank Code Operand” to “Equal to”.
   • Select the applicable bank code for “Bank Code Value”.
   • Set “Document Date Operand” to “All”, “Less than”, or “Range”. If using “Range”, leave the first date blank and select an ending date to purge up to that date.
3. Print or Preview the Report
   • Click “Print” or “Preview”.
   • Note: If security settings are not configured, the report must be printed to a printer, file, or deferred.
4. Purge Cleared Documents
   • Close the Preview window.
   • If the out-of-balance amount is $0.00, a message will appear: “Do you want to remove cleared documents as of mm/dd/yy?”.
   • Click “Yes” to purge the cleared documents.