Bank Reconciliation Initialization Steps

Issue/Symptom/Question

What prerequisites are needed to start using the PENTA Web Bank Reconciliation?

What security do I need for Bank Reconciliation?

Applies To

PENTA Web > Accounting Module > Bank Transaction Initialization

PENTA Version 21.2 and up

System Management > Security > Security Groups

Resolution/Fix/Answer

With the new functionality, the Security needs updating and PENTA needs to establish a starting point for a bank account prior to using the Bank Reconciliation functionality.

Prerequisites:

  1. The Document Type in OnBase for FIN - Bank Reconciliation needs to be assigned to the appropriate OnBase Users or User Groups
  2. Update Security Groups
    1. Menu Security Access is given to the Appropriate Security Groups in PENTA
      1. Bank Reconciliation - gives access to process and complete Bank Reconciliations
      2. Bank Transaction Initialization - gives access to establish which transactions have been previously reconciled
      3. Bank/Bank Account Management - gives ability to create new Banks and Bank Accounts in PENTA Web

    2. Accounting Module Security is correct for the Security Group and/or Users
      1. Allowed to Delete 'In Progress' Bank Reconciliations
      2. Allowed to update 'Completed' Bank Reconciliations 
  3. Initial release of Bank Reconciliation requires notifying PENTA of the previous bank reconciliation cleared balance completed outside of PENTA to set the Starting Balance for reporting purposes
  4. All recorded PENTA Bank Transactions need to be marked as having been previously reconciled
    1. Cannot perform this once a Bank Reconciliation has been completed.  
      1. If Bank Rec completed, need to rollback (delete) all Completed Bank Recs
    2. Use the Bank Transaction Initialization screen to mark all transactions prior to a date as reconciled
      1. If any transactions prior to the date are not reconciled, find that transaction using the Search tools and mark it as unreconciled
      2. Transactions that do not have a check mark in the reconciled column will be used for the first bank reconciliation in PENTA

PENTA Bank Reconciliation will ignore all transactions marked as having been reconciled in the Bank Transaction Initialization window.

Here is an example were all transactions dated prior to or on 12/31/18 were marked as reconciled and then searched so one or more of the transactions could be marked unreconciled:
Â