To Set Up Bank Feeds Loaded from the BAI2 Format

You use the Bank Feeds (CA205500) form to set up bank feeds that load bank transactions from a BAI2 or BTRS file. On the same form, you connect to the SFTP folder where source files are stored and specify the mapping between the optional fields of the source file and the settings in MYOB Acumatica.

Before You Proceed

Make sure that the Bank Feed Integration feature is enabled on the Enable/Disable Features (CS100000) form. On the Activate License (SM201510) form, make sure that the needed license is activated.

To Set Up a Bank Feed

  1. On the Bank Feeds (CA205500) form, create a new record.
  2. In the Summary area, specify the following settings:
    • Bank Feed ID: A unique ID that identifies the bank feed
    • Bank Feed Type: File
    • Import Start Date: The date starting from which you want to import bank transactions to the system
    • Description: A description of the bank feed
    • Financial Institution: The name of the bank that will provide source files with transactions
  3. Go to the Source File tab, and specify the following settings in the Connection to Source File section:
    • URL: The path to the SFTP folder, such as sftp://FirstBank/Doc.
    • File Format: BAI2 (Bank Administration Institute).
    • Login: The current user's login to the SFTP folder. This value is provided either by the bank or by your organization.
    • Password: The current user's password to the SFTP folder.
    • SSH Private Key: The private Secure Shell (SSH) key created on the Encryption Certificates (SM200530) form, which will be used for SFTP authentication.
  4. Click Test Connection.

    The system verifies the connection to the SFTP folder.

  5. In the Source File section, click Set Up Data Provider.

    In the Data Provider box, the system automatically inserts the name of the created data provider.

  6. Optional: In the Mapping Rules section, enter the mapping rules between the source file and MYOB Acumatica.

    The settings for which the Active check box is selected and unavailable are required. You cannot edit them. Other settings are optional. You can modify the mapping rules for optional settings only.

  7. Go to the Cash Accounts tab, and click Add Row on the table toolbar. Specify the following settings in the added row:
    • Account Name: The account name as it is specified in the source file.
    • Cash Account: The cash account in MYOB Acumatica that will be mapped to the bank account.
    • Statement Period: The bank statement period required by the bank, for example Month.
    • Statement Start Day: The start date of the bank statement required by the bank, for example 1.
    • Import Transactions From: The date starting on which transactions for the cash account will be imported (inserted automatically by the system and read-only).

      This setting is filled in with the latest of the following dates:

      • The Import Start Date in the Summary area
      • The transaction date of the most recent bank transaction received through the file bank feed for the selected cash account. This date is specified in the Tran. Date column on the Import Bank Transactions (CA306500).
      • The transaction date of the most recent bank transaction for the selected cash account received from a source other than the File bank feed, for example, loaded from Plaid or MX bank feed, an OFX file or entered manually. This is the date specified in the Tran. Date column on the Import Bank Transactions form plus one day.
    • Currency: The currency of the bank transactions

    Repeat this instruction for each bank account and cash account that you want to map.

    Tip: You can click Load Transactions in Test Mode on the More menu to review the exact bank account names that exist in the file located in the specified SFTP folder.
  8. Click Save to save your settings.
  9. On the form toolbar, click Activate to activate the bank feed. The bank feed's status changes to Active.

    You can process this bank feed on the Retrieve Bank Feed Transactions (CA507500) form. For details, see To Load Bank Transactions from a File.