Skip to content

Configuring Bank Data Download

Using EBICS, banks provide machine-readable bank statement data to be used for automatic payment matching and settlement, as well as human-readable documents for regulatory reasons. JustOn Cash Management can request, retrieve and store these documents, as described in Bank Data Download.

Configuring the bank data download involves the following tasks:

Enabling Structured Bank Document Storage

JustOn Cash Management can download different types of documents from initialized bank accounts and store these documents in Salesforce Files in a dedicated library/folder structure grouped by BIC and IBAN.

For details on how to enable the structured bank data storage for your org, see Globally Enabling Structured Bank Document Storage.

Enabling Manual Bank Statement Download

Enabling the download of bank statements for users involves the following tasks:

Adding Retrieval Button to UI

To enable the option for starting the bank statement download from the user interface, you may have to add the button Retrieve to the Bank Statement list view manually. To do so:

  1. Click to enter Setup, then navigate to the object management settings of the Bank Statement object.
  2. Click List View Button Layout.
  3. In the List View row, click , then select Edit.

  4. Under Custom Buttons, move Retrieve to the Selected Buttons column.

    column_select

  5. Click Save.

You can access the downloaded bank statements or other bank documents via the Files related list on the relevant Bank Account record.

If you have upgraded JustOn Cash Management from a pre-1.42 version, you may have to add the Files related list to the Bank Account layout view manually manually. To do so:

  1. Navigate to the object management settings of the Bank Account object.

    Click to open the Setup menu and select Setup, then open Objects and Fields > Object Manager > Bank Account.

  2. Click Page Layouts.

  3. Click Edit in the row of the layout you intend to modify.
  4. Select the Related Lists palette.
  5. Drag the Files list to the Related Lists section.

  6. Click Save.

    This adds the Files related list to the Bank Account detail view.

Configuring Automatic Bank Data Download

JustOn Cash Management can automatically download bank data on a regular basis.

To this end, JustOn Cash Management provides the dedicated Apex class DownloadBankStatementsJob, which is to be scheduled using the standard Salesforce Schedule Apex functionality.

Info

During the bank data download, JustOn Cash Management only processes bank accounts with the access method set to EBICS. Bank accounts with a different access method are skipped, and a warning is added to the job log.

For IBANs that do not yet exist in Salesforce, you can control whether new bank accounts are created automatically using the Extend Bank Accounts During Download global setting.

Note

Users who intend to schedule the bank data download must be able to access the relevant EBICS bank account credential record. There are two ways to achieve this:

  • The user has created the relevant EBICS bank account credential record, or
  • The relevant EBICS bank account credential record is not locked to the user who has created it (see Sharing Bank Access Configurations).

  1. Click to enter Setup, then open Apex Classes.

    In Salesforce Lightning, navigate to Custom Code > Apex Classes.

    In Salesforce Classic, navigate to Develop > Apex Classes.

  2. Click Schedule Apex on top of the list.

  3. Specify the details as required.

    • Job Name, like Download Bank Statements Job
    • Apex Class: DownloadBankStatementsJob

    • Frequency: Weekly or Monthly (with an according day of week or day of month setting)

      We recommend a daily interval (Weekly with every day selected) so that there will be no gaps in the bank data.

      In case of data gaps after the automatic download, a user must fetch the corresponding bank data manually. Be aware, however, that banks usually provide data for a limited period only, like 14 days.

    • Start

    • End

      Required, so if you want it to run virtually forever, select a date far in the future.

    • Preferred Start Time

  4. Click Save.

    This sets up the bank data download to be executed automatically at the specified time.

Info

Before the bank data download is executed automatically for the first time, the user under whose credentials the job is running must have retrieved bank statements manually once. This is necessary so that the bank can verify the user data and authorizations.

Controlling Bank Account Creation on Data Retrieval

For IBANs that do not yet exist in Salesforce, JustOn Cash Management automatically creates new Bank Account records during the bank data download by default. If required, you can disable this behavior to prevent the automatic creation of new bank accounts.

For details on how to control the automatic bank account creation in your org, see Controlling Bank Account Creation on Data Retrieval.

Automatic bank account creation and structured file storage

For new bank accounts created automatically on data retrieval, no library/folder structure will be created during the data retrieval process. Processed files related to new bank accounts detected on import will be stored under the users' Owned by Me.

To create the library/folder structure, disable structured file storage and re-enable it once the new bank accounts are available.