Bank Feeds

Form ID: (CA205500)

On this form, you create a bank feed that is connected to Plaid or MX. In addition to accessing this form through a search or a workspace, you can open it by clicking Add New Record on the form toolbar of the Retrieve Bank Feed Transactions (CA507500) form.

This form appears in the system if the Bank Feed Integration feature is enabled on the Enable/Disable Features (CS100000) form.

Form Toolbar

The form toolbar includes standard buttons and form-specific buttons and commands. For the list of standard buttons, see Form Toolbar and More Menu. The form-specific commands can be shown as buttons on the form toolbar, as commands on the More menu, or in both places. These commands are listed in the following table in alphabetical order.


Command	Description
Activate	Sets the status of the bank feed to Active. The command is available on the More menu and shown as a button on the form toolbar if the selected feed has the Suspended status. If at least one cash account that is mapped to a bank account on the Cash Accounts tab is already linked to an active bank feed, the system displays an error message. If any cash account that is mapped to a bank account has a statement import service selected on the Cash Accounts (CA202000) form, when you activate the bank feed, the Statement Import Service box on that form is replaced with the Statement Import Source box, where the system inserts the name of this bank feed.
Connect	Establishes a connection with the selected financial institution, links the bank feed to this financial institution, and sets the status of the bank feed to Setup Required. The command is available on the More menu and shown on the form toolbar only if the status of the bank feed is Disconnected.
Update Credentials	Refreshes the authentication data. The command is available on the More menu and shown on the form toolbar only if the bank feed is linked to a financial institution.
Suspend	Changes the status of the bank feed to Suspended; as a result, transactions cannot be imported for this bank feed. For each cash account that is linked to a bank feed with the Suspended status, the Statement Import Service box replaces the Statement Import Source box on the Cash Accounts (CA202000) form, and you can import transactions for the account from a source other than the bank feed. The command is available on the More menu and shown on the form toolbar if the status of the bank feed is Active.
Disconnect	Removes the bank feed, access token, and linked accounts, and changes the status of the bank feed to Disconnected. The command is available on the More menu if the status of the bank feed is Active.
Show Access ID	Displays the Access ID pop-up window with the credentials (User ID and Item ID/Member ID) that are necessary when you contact your MYOB support provider, Plaid support, or MX support.
Load Transactions in Test Mode	Opens the Load Transactions in Test Mode dialog box so that you can load the bank transactions for a particular date range and bank account from the bank via the bank feed connection without creating the related bank transactions in MYOB Acumatica. This command is available on the More menu if the status of the bank feed is Setup Required, Active, or Suspended.

Table 1. Load Transactions in Test Mode Dialog BoxBy using this dialog box, you can ensure that your bank is able to send transactions through MX or Plaid in a suitable format without mapping bank accounts to MYOB Acumatica cash accounts and activating the bank feed. You use this dialog box to specify the settings for loading transactions in test mode. This dialog box opens if you click Load Transactions in Test Mode on the More menu.
Element	Description
Selection Area You can use the elements of this area to narrow the range of transactions to be loaded in test mode.
Date From	Required. The start date of the period for which transactions will be loaded.
Date To	Required. The end date of the period for which transactions will be loaded.
Max. Number of Recent Transactions	Required. The maximum number of recent transactions that will be loaded. The most recent transactions will be loaded first. The default value is 30. The maximum value allowed in this box is 9999.
Account Name	The account for which you want to load transactions. The lookup table that opens when you click the lookup button shows a list of the accounts that are available for this bank feed (those that are listed on the Cash Accounts tab).
Table Columns The table toolbar includes only standard buttons. For the list of standard buttons, see Table Toolbar. This table is populated with the loaded transactions after you click the Load Transactions button. The table contains the following columns.
Transaction ID	The transaction ID assigned by the financial institution.
Date	The date when the transaction was created.
Amount	The amount of the transaction.
Currency Code	The currency code of the currency in which the transaction amount was entered.
Name	The name of the customer or vendor specified in the transaction.
Category	The category assigned to the transaction by the financial institution.
Pending	A check box that indicates (if selected) that the transaction has not been fully settled.
Pending Transaction ID	The ID of the pending transaction. This column is displayed only if Plaid is selected in the Bank Feed Type box.
Type	The type of the transaction, which can be Receipt or Disbursement.
Account ID	The ID of the customer's or vendor's account in the financial institution.
Account Owner	The name of the account owner, if the bank provides this information.
Check Number	The check number returned by the bank, if the bank provides this information. This column is displayed only if MX is selected in the Bank Feed Type box.
Memo	A text message returned by the bank, if the bank provides this information. This column is displayed only if MX is selected in the Bank Feed Type box.
This dialog box has the following buttons.
Load Transactions	Loads transactions that meet the specified selection criteria into the table.
Close	Closes the dialog box.

Summary Area

In this area, you can specify the settings for a new bank feed connection or select an existing bank feed connection to view and possibly modify its settings. The elements of this area are summarized below.


Element	Description
Bank Feed ID	The ID of the bank feed.
Status	Read-only. The status of the bank feed connection. The status can be one of the following: Active: The bank feed has been connected and at least one cash account has been mapped to an account for the bank feed on the Cash Accounts tab of the current form. Transactions for this bank feed can be retrieved. Suspended: The bank feed connection has been suspended and transactions will not be retrieved. Disconnected: The bank feed has not been connected. This is the initial status. Setup Required: The bank feed connection has been established and a user needs to set up the bank feed by selecting a cash account for at least one account listed on the Cash Accounts tab of the current form.
Bank Feed Type	The type of the connected bank feed. The type can be one of the following: MX: The system is connected to the MX financial service company. Plaid: The system is connected to the Plaid financial service company. Test Plaid: The system is connected to the Plaid sandbox. When you select this option, the system sends a request to the Plaid sandbox, and then AWS uses the sandbox credentials to access to the Plaid sandbox environment. Plaid allows the creation of an unlimited number of connections in its sandbox. You can view the sandbox credentials for different authentication methods at https://plaid.com/docs/sandbox/test-credentials/#sandbox-simple-test-credentials. You can view a demo for a particular bank in the sandbox environment at Plaid website.
Import Start Date	Required. The date starting from which transactions will be imported. This date will be used as the default date in the Import Transactions From column on the Cash Accounts tab of the current form for all mapped accounts in the feed. However, this date will be recalculated for each account if bank transactions have been entered manually for the account on the Import Bank Transactions (CA306500) form or imported earlier from other sources. For example, if Import Start Date is 01/01/2022 but you manually entered bank transactions for a selected account with dates from 02/01/2022 to 02/04/2022, the system will recalculate the Import Transactions From date for this account as 02/05/2022.
Description	Optional. The description of the bank feed.
Financial Institution	Read-only. The name of the financial institution linked to the bank feed.
Create Expense Receipts	A check box that indicates (if selected) that expense receipts will be created for transactions that can be matched to a corporate card. This check box appears on the form if the Expense Management feature is enabled on the Enable/Disable Features (CS100000) form. If this check box is selected, the Corporate Cards and Expense Items tabs appear on the form.
Create Expense Receipts for Pending Transactions	A check box that indicates (if selected) that expense receipts will be created for pending transactions. This check box appears on the form if the Expense Management feature is enabled on the Enable/Disable Features (CS100000) form. This check box can be selected if the Create Expense Receipts check box is selected.
Map Multiple Bank Accounts to One Cash Account	A check box that indicates (if selected) that multiple bank accounts can be matched to a single cash account. This check box appears on the form if the Mapping of Multiple Accounts for Bank Feeds feature is enabled on the Enable/Disable Features (CS100000) form and the status of the selected bank feed is Active, Setup Required, or Suspended. This check box is cleared by default.

Cash Accounts Tab

This tab is used for mapping bank accounts to cash accounts and for reviewing the linked bank accounts.

The table toolbar includes only standard buttons. For the list of standard buttons, see Table Toolbar.


Column	Description
Hidden	A check box that indicates, if selected, that the bank feed account is not matched to a cash account and will be hidden on the current tab. By default, the check box is cleared. This check box is available if no value has been defined in the Cash Account column of this tab. If a cash account is specified in the Cash Account column, the check box is cleared and unavailable. Note: To review both visible and hidden accounts on this tab, select the All Records option in the Search box on the table toolbar.
Account Name	Read-only. The account name returned by the financial institution.
Account Mask	Read-only. The account mask returned by the financial institution.
Description	The description of the account.
Cash Account	The cash account in MYOB Acumatica that is linked to the bank feed account. You can select only an account that has not been linked to a bank account of any bank feed. If the cash account's currency is different from the bank feed account's currency, the system will display a warning message.
Statement Period	The period for which the bank statement is sent. The period can be one of the following: Month (default): The bank statement includes transactions for a month. Week: The bank statement includes transactions for a week. Day: The bank statement includes transactions for the day specified in the Statement Start Day column.
Statement Start Date	The day of the month or the week on which the statement starts. This day is used to determine the Start Balance Date and End Balance Date of the bank statement on the Import Bank Transactions (CA306500) form. If Month is selected in the Statement Period column, the possible values are integers ranging from 1 to 31. If Week is selected in the Statement Period column, the available options are Monday (default), Tuesday, Wednesday, Thursday, Friday, Saturday, and Sunday. If Day is selected in the Statement Period column, this column is empty and unavailable.
Import Transactions From	Read-only. The date starting on which transactions for the cash account will be imported. 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 Plaid or MX bank feed for the selected cash account (specified in the Tran. Date column on the Import Bank Transactions (CA306500) form) The transaction date of the most recent bank transaction for the selected cash account received from a source other than a bank feed, for example loaded from an OFX file or entered manually, specified in the Tran. Date column on the Import Bank Transactions (CA306500) form plus one day
Currency	Read-only. The currency of the account received from the financial institution.
Account Type	Read-only. The account type received from the financial institution.
Account Subtype	Read-only. The account subtype received from the financial institution.
Retrieval Status	Read-only. The status assigned by the financial institution after the retrieval of transactions for the bank feed. The status can be one of the following: Success: Transactions for the bank feed have been retrieved successfully. Error: Transactions for the bank feed have been retrieved with an error. The error message is shown in the Error Message column. Login Failed: The credentials you specified could not be verified by the financial institution.
Retrieval Date	Read-only. The retrieval date received from Plaid.
Error Message	Read-only. The error message received from Plaid, if the retrieval status is Error.
Account ID	Read-only. The account ID in Plaid.

Custom Mapping Rules

On this tab, you can set up optional mapping between the bank feed fields and the bank transaction fields by specifying the source and target fields, respectively, and using formulas in the source field. By default, the table on this tab is empty.

If mapping is defined in the table for a target field and the Active check box is selected, the custom mapping rule will have a priority over the core program mapping, if it exists for this field. The specified rules will affect all bank transactions that will be created for all cash accounts from the current bank feed.

Table 2. Table Toolbar
The table toolbar includes standard buttons and buttons that are specific to this table. For the list of standard buttons, see Table Toolbar. The table-specific buttons are listed below.
Button	Description
Set Default Mapping	Sets up the most common built-in rules for the selected bank feed and displays them in the table. If the table is populated with settings and you click this button, the system displays the Replace Current Rules dialog box informing that the existing mapping rules will be replaced with the default ones. You click Replace to confirm the replacement of the mapping rules.

Table 3. Table ColumnsThe columns of this tab are described below.
Column	Description
Active	This check box indicates, if selected, that the mapping rule is active. The check box is selected by default for each new row.
Target Field	The fields of the resulting bank transactions. If you have clicked Set Default Mapping on the table toolbar, this column is filled in with the default setting for the selected bank feed.
Source Field or Value	The list of all incoming fields of the selected bank feed. If you have clicked Set Default Mapping on the table toolbar, this column is filled in with the default setting for the selected bank feed.

Corporate Cards Tab

On this tab, you can define whether expense receipts should be created and for which employee and corporate card they should be created, based on the transaction account and optional conditions that you can specify.

This tab appears on the form if the Expense Management feature is enabled on the Enable/Disable Features (CS100000) form and the Create Expense Receipts check box is selected in the Summary area of the current form.

The table toolbar includes only standard buttons. For the list of standard buttons, see Table Toolbar.


Column	Description
Account Name	Required. The name of a bank account specified on the Cash Accounts tab.
Cash Account	Read-only. The cash account in MYOB Acumatica that is linked to the selected account.
Field to Match	Optional. The field of the bank feed account to be matched with this corporate card. If Plaid is selected in the Bank Feed Type box, you can leave this column blank or select one of the following values: Account Owner: The owner of the bank account returned by the bank Name: The name on the bank account returned by the bank If MX is selected in the Bank Feed Type box, you can leave this column blank or select one of the following values: Check Number: A check number returned by the bank Memo: A text message returned by the bank Name: The name on the bank account returned by the bank
Rule	Optional. The rule based on which the system will match transactions to corporate cards and employees. One of the following values can be selected: Starts With: Matches the records for which the value of the specified field to match contains at the beginning the value specified in the Value column Contains: Matches the records for which the value of the specified field to match contains the value specified in the Value column Ends With: Matches the records for which the value of the specified field to match ends with the same character or string as the value in the Value column
Value	A value for the rule specified in the Rule column.
Corporate Card ID	Required. The ID of the corporate credit card in MYOB Acumatica that is linked to the account selected in this column.
Card Number	The number of the corporate credit card selected in the Corporate Card ID column.
Name	The name of the corporate credit card selected in the Corporate Card ID column.
Employee ID	The ID of the employee linked to the corporate credit card.
Employee Name	The name of the employee linked to the corporate credit card.

Expense Items Tab

On this tab, you can define expense items for expense receipts based on the transaction category or name. This tab appears on the form if the Expense Management feature is enabled on the Enable/Disable Features (CS100000) form and the Create Expense Receipts check box is selected in the Summary area of the current form.

Table 4. Default Expense Item Element
Element	Description
Default Expense Item	Required. A non-stock item with the Expense type, which will be used by default if a transaction cannot be matched to any expense item in the table.

Table 5. Table Toolbar
The table toolbar includes standard buttons and buttons that are specific to this table. For the list of standard buttons, see Table Toolbar. The table-specific buttons are listed below.
Button	Description
View Categories	Opens a list of expense categories available in the financial institution.

Table 6. Table ColumnsThe columns of this tab are described below.
Column	Description
Field to Match	Required. The field of the bank feed account to be matched with the expense item. You can leave this column blank or select one of the following values: Category: The expense category available for the financial institution. You can review a list of categories by clicking View Categories on the table toolbar. Name: The name on the bank account in the bank.
Rule	Required. The rule based on which the system will match the field specified in the Field to Match column to an expense item. One of the following values can be selected: Starts With: Matches the records for which the value of the specified field to match begins with the value specified in the Value column Contains: Matches the records for which the value of the specified field to match contains the value specified in the Value column Ends With: Matches the records for which the value of the specified field to match ends with the same character or string as the value in the Value column
Value	Required. A value for the rule specified in the Rule column.
Expense Item	The expense item in MYOB Acumatica that is linked to the field selected in the Field to Match column. Expense items are defined on the Non-Stock Items (IN202000) form. This column is required if the check box in the Skip column is cleared.
Skip	This check box indicates (if selected) that expense receipts will not be created for transactions to which the selected rule is applied. By default, this check box is cleared.