Open topic with navigation

> Financials / Cash Book / Reconcile bank account / Reconcile electronic bank statement / Configure e-banking reconciliation options

/  More Set the matching facility Set a discard date

Configure e-banking reconciliation options

Open: Cash Book > Period End Routines > Bank Reconciliation.

When using electronic bank reconciliation in Sage 200, within the Bank Reconciliation window, you can:

• Set a discard date to stop transactions before a specified date being displayed in the reconciliation window.

  1. On the Reconciliation form, choose Tools > Set Discard Date.
  2. Enter the required date. All transactions dated before the discard date will not appear in the bank transactions list when the bank file is imported.
  3. To delete all bank transactions before the discard date, select the Delete Discarded Data check box.

• Control how the matching process works for automatic and manual matching.

  1. On the Reconciliation form, choose Tools > Options.
  2. Select the required Match Mode.

     • Match each Bank transaction to transactions in the Sage list.

       Each transaction in the bank statement is selected in turn and the Sage statement is searched for matching transactions. This is the default setting.

     • Match each Sage transaction to transactions in the Bank list.

       Each transaction in the Sage statement is selected in turn and the bank statement is searched for matching transactions.

  3. Select how you want to deal with manual matches.
     • To skip the confirmation stage of reconciliation ensure the Automatically confirm Manual Matches check box is selected.
     • If you want to confirm manually, clear the Automatically confirm Manual Matches check box.