Knowledge Center

Bankconnector

Bank integration is currently available for Scandinavian banks. To get started, please contact your partner, or RamBase directly if you are not connected to a partner.

Outgoing Payments

Do the following to generate a payment file.

  1. To open the Pay Management (PAM) application, find Finance in the RamBase menu and then Cash management. Click Inbound payments to enter the PAM application.

  2. Enter the Payables tab.

  3. Select documents. It is possible to mark one, some or all of the documents by using the checkboxes.

  4. Click the Select Action button. Verify that there are no extra documents which might have been accidentally selected.

  5. Click the Send To Bank button.

    clip1679.png
  6. Select the bank account you want to pay from in the Bank field. The account balance and file format are displayed in the Bank field.

  7. Select how the payments should be grouped in the Group by field. Either by Invoice, DueDate or Supplier.

  8. Select the pay date in the Pay Date field. Either the documents’ due dates or specify one pay date for all of the documents. This will be currency date on the payment.

  9. Click the Send To Bank button. The payment is now sent to bank, and the user must log in to the online bank to approve the payments.

Note:

If the payment is rejected for some reason the PAY document will stay in status 2.

To read the rejection message you can either enter the PAY item or you can enter the Remittance tab in PAM. This tab gives an overview over all remittance sent and its status.

If, for example, the structure creditor reference is invalid or missing. The user must discard the PAY document, correct the creditor reference on the invoice, and try to pay the invoice one more time.

Incoming payments

When using bankconnector, incoming payments will be directly transferred from bank to RamBase. If RamBase can match the payment against an invoice automatically, the PAY document will go directly to status 4. If there is some payment RamBase can not match automatically, the PAY document will stay in status 2. If this is the case, the user must do the matching manually.

  1. Enter the PAY document.

  2. Press F12 to open the action menu and choose the Reopen Payment (ST=1) option.

  3. Enter the PAY item and connect the payments to the correct invoice or GL account.

  4. Register the payment with the F12 option Register Payment.

Bank Statement (BST)

When using bankconnector there will be imported bank reconciliation files to RamBase daily. The files are imported in two steps:

  1. First all transactions are created on a Bank Statement (BST) document. When this is done, the BST document will receive status 1.

  2. Then the balances are imported to the same BST document. The status of the BST document are now dependent on different factors.

    1. If ingoing balance on the BST document equals outgoing balance on the previous BST document, the document will receive status 2.

    2. If ingoing balance on the BST document does not equal outgoing balance on previous BST document, the document will stay in status 1. This will normally happen for the first BST document after you have started with bankconnector, or if something has gone wrong in the bank. For the first BST document, please see description further below. If something has gone wrong in the bank, please contact RamBase servicedesk, or a RamBase partner.

  3. When BST is created in status 2, RamBase runs automatically reconciliations jobs in given intervals to reconcile the bank statement.

To follow up unmatched transactions, please see the section Automated bank reconciliation (BST) in the RamBase webhelp. The process are described under Reconcile an unmatched transaction (St:2).

First BST document

For the first BST document that is imported, it is not possible to control ingoing balance against any other BST. RamBase will check balance against the balance in the Bank (BANK).

If there is no PAY documents in the BANK, RamBase will check the balance against Balance, Bank in the Key Figures area.

If there is PAY documents registered, RamBase will check the balance against Payments, reconciled in the Key Figures area.

clip1680.png

To get the first BST document in status 2, make sure that all transactions until the date of the first BST is registered and reconciled in RamBase.