Bank Feeds

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.

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.

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.

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.

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.

Opens the Load Transactions in Test Mode dialog box so that you can load the bank transactions via the bank feed connection without creating the related bank transactions in MYOB Acumatica. You can load bank transactions for a particular date range and bank account or for a particular file from the SFTP folder if the bank feed has the File type.

This command is available on the More menu if the status of the bank feed is Setup Required, Active, or Suspended.

Reloads the same source file with bank transactions or loads a new file. When you click this command, the Load File Manually dialog box is displayed. In this dialog box, you select one of the files located in the specified SFTP folder.

This command appears on the More menu if File is selected in the Bank Feed Type box of the Summary area.

The dialog box contains a Selection area with elements you can use to narrow the range of transactions to be loaded in test mode.

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.

The account for which you want to load transactions.

The lookup table that opens when you click the magnifier button shows a list of the accounts that are available for this bank feed (those that are listed on the Cash Accounts tab).

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.

The ID of the pending transaction.

This column is displayed only if Plaid is selected in the Bank Feed Type box.

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.

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 contains a Selection area with a box you can use to select a source file.

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.

The amount of the transaction. This column appears when Debit/Credit in Same Column is selected in the Amount Format box on the Source File tab.

The debit or credit property that characterizes the amount.

This column is displayed only if Debit/Credit Property in Separate Column is selected in the Amount Format box on the Source File tab.

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.

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.
• File: Bank transactions can be loaded to the system from a file. The files that contain exported bank transactions must have the comma-separated values (CSV) format. Once this option has been selected, you can change it only if the status of the bank feed type is Setup Required.

  If this option is selected, the Source File tab appears on the form and the Custom Mapping Rules tab does not appear.

• 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.

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.

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.

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.

This check box does not appear for bank feeds with the File type because source files contain only posted transactions.

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.

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.

The account name returned by the financial institution.

If File is selected in the Bank Feed Type box, you can manually enter this value. For other bank feed types, this column is read-only.

The description of the account.

If File is selected in the Bank Feed Type box, you can manually enter this value. For other bank feed types, this column is read-only.

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.

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.

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.

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

The currency of the account received from the financial institution.

If File is selected in the Bank Feed Type box, you can select a currency in this column. For other bank feed types, this column is read-only.

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.

The URL address of the SFTP folder where the source files are stored.

A button that you click to create or update a data provider that will be used for retrieving data from source files.

The data provider will store the schema of the file that is located in the SFTP folder. When you click this button for the first time, a data provider is created. On subsequent clicks, the data provider will be updated with the fields from the first unprocessed file in the specified SFTP folder.

The data provider's name. This name consists of the Bank Feed string, followed by the current bank feed ID and the file format in parentheses. You can click the Edit button near this box to review the data provider on the Data Providers (SM206015) form.

This box appears on the form and is filled in after you click Set Up Data Provider and the data provider has been successfully created.

The format of debit and credit amounts in the source file.

One of the following options can be selected:

• Debit/Credit in Same Column (default): Debit (positive) amounts and credit (negative) amounts are displayed in the same column of the source file. The system will create disbursement transactions from debit entries and receipt transactions from credit entries. If you select this option, the Transaction Amount row in the Mapping Rules table will remain in the list of required fields.
• Debit and Credit in Different Columns: Each amount in the source file is located either in the Debit column or in the Credit column. If you select this option, the Transaction Amount row in the Mapping Rules table is replaced with two required rows: Receipt Amount and Disbursement Amount. You must specify the mapping for each of these rows so that the system creates a disbursement when it finds an amount in one column and creates a receipt when it finds an amount in the other column.
• Debit/Credit Property in Separate Column: Debit amounts and credit amounts in the source file are displayed in the same column, and an amount's debit property (Dr) or credit property (Cr) is displayed in a separate column. If you select this option, the Disbursement Property and Receipt Property boxes appear in the Source File section.
  Important:

  You must specify the exact value of the debit or credit property that indicates whether the amount in the row should be used to create a receipt transaction or a disbursement transaction.

  The Transaction Amount row remains in the Mapping Rules table, and the Debit/Credit Property in Separate Column row is added and marked as required. You must specify which column in the source file contains the debit or credit property.

This box appears on the form and is filled in after you click Set Up Data Provider and the data provider has been successfully created.

The property used for creating disbursement transactions. You must fill in this box with the exact value from the source file.

This box appears on the form if Debit/Credit Property in Separate Column is selected in the Amount Format box.

The property used for creating receipt transactions. You must fill in this box with the exact value from the source file.

This box appears on the form if Debit/Credit Property in Separate Column is selected in the Amount Format box.

The field or value in the source file that is mapped to the target field in MYOB Acumatica.

You can enter formulas in this column. For more details, see The Use of Formulas.

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.

This check box indicates, if selected, that the mapping rule is active. The check box is selected by default for each new row.

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

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

Opens a list of expense categories available in the financial institution.

This button is unavailable for bank feeds with the File type.

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.

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

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.

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.