Skip to main content

Knowledge Center

Manual bank reconciliation

Sometimes the bank reconciliation has to be done manually. PAY Reconciliation (RECPAY) lists all banks registered in RamBase which have un-reconciled payment documents (St:4). Finished reconciliation jobs will also be listed in RECPAY (St:9).

  1. To open the PAY Reconciliation (RECPAY) application, find Finance in the RamBase menu and then Cash management. Click Manual bank reconciliation to enter the RECPAY application.

    clip1105.jpg
  2. Click on the magnifying glass on the upper right of the screen to filter the bank to reconcile.

  3. Click on the + icon on the left of the document line.

    clip1106.jpg
  4. To ease the traceability of this manual bank reconciliation, enter a reference to the reconciliation in the BankRef field. The reference should be a combination of year and date (yyyy.mm.dd), or a combination of year and serial number (yyyy.xxx).

  5. Click the OK button.

    clip1108.jpg

    This is the main window for the reconciliation job. Note that the reconciliation is set to status 0 which indicates that this is a new reconciliation which is created by the system. A reconciliation job is not registered before there are PAY documents connected to it.

  6. Click on the magnifying glass in the Title section to bring up the Select Payments popup, and select the documents for this specific period.

    clip1110.jpg
  7. Press Esc.

    clip1111.jpg
  8. Press F12 to open the action menu and choose the option Confirm (St=9). When the reconciliation of a BST document is confirmed (St:9), the connected PAY document will be put to status 9 too. This indicates that it is reconciled and there is no need for further handling. Unreconciled PAY documents will remain in status 4.