Integrating Acumatica ERP with Bank Feeds

Acumatica ERP is integrated with Plaid and MX, which are financial service companies that provide secure bank feeds. A bank feed is a secure link between Acumatica ERP and a company’s bank profile, which can include multiple bank accounts. A bank feed is used for the automatic import of bank transactions into the system. A company may create different bank feeds for different banks. Alternatively, if the accounts in one bank are registered to different users, a company may create a bank feed for each user with a separate set of credentials. With this integration, Acumatica ERP users can automatically connect to their bank profiles, import bank transactions to Acumatica ERP, and create expense receipts based on these transactions.

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

If this feature is enabled, Plaid and MX subscriptions will become available to users in Acumatica ERP without the need to register separately in Plaid and MX. Acumatica ERP will store and return Plaid and MX authentication by using a special proxy server through API.

Some banks do not have integration with Plaid or MX bank feeds, but they provide bank transactions to their customers in a file located in an SFTP folder. You can use Acumatica ERP to load bank statements from this type of file. The system then automatically creates the cash transactions and expense receipts that correspond to the transactions in the file.

The Bank Feed Integration feature is subject to licensing. If an organization needs to map more than one bank feed account, it should buy an appropriate license.

Currently, integration with MX works only for financial institutions in the United States and Canada.

Back to TopIn This Chapter

Mapping of Multiple Bank Accounts to One Cash Account

You can set up bank feeds to map multiple bank accounts to one cash account in Acumatica ERP. With this functionality, users can do the following:

To Set Up Plaid Integration

You perform the following instructions to set up the integration of Acumatica ERP with Plaid. You use the Retrieve Bank Feed Transactions (CA507500) form as a starting point and then specify the settings of the bank feed on the Bank Feeds (CA205500) form.

To Set Up MX Integration

You perform the following instructions to set up the integration of Acumatica ERP with MX. You use the Retrieve Bank Feed Transactions (CA507500) form as a starting point and then specify the settings of the bank feed on the Bank Feeds (CA205500) form.

To Set Up Mapping Rules

On the Custom Mapping Rules tab of the Bank Feeds (CA205500) form, 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. You can specify your own mapping or set up the default mapping.

To Import Bank Transactions from a Bank Feed

When Plaid or MX integration has been set up, you perform the instructions described below to import bank transactions from a bank feed into the system. You use the Retrieve Bank Feed Transactions (CA507500) form for this import.

Loading of Bank Feeds from a File

To configure the system for loading of bank feeds from a file, the following configuration steps should be performed:

Loading of Bank Feeds from BAI2 Files

Acumatica ERP supports the Bank Administration Institute Version 2 (BAI2) format of bank statements. The Balance and Transaction Reporting Standard (BTRS) improves upon the BAI2 format. The BAI2 and BTRS formats are banking industry standards for communicating bank statements electronically.

Loading of Bank Feeds from an AMEX GL1025 File

In Acumatica ERP, you can import American Express GL1025 bank statement files through bank feeds. If your organization uses American Express corporate cards, this lets you process large volumes of employee expense transactions efficiently.

To Set Up Bank Feeds Loaded from a CSV File

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

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 Acumatica ERP.

To Set Up Bank Feeds Loaded from an AMEX GL1025 File

You use the Bank Feeds (CA205500) form to set up bank feeds that load bank transactions from an AMEX GL1025 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 Acumatica ERP.

To Load Bank Transactions from a File

You use the Retrieve Bank Feed Transactions (CA507500) form to load bank transactions from a file. Alternatively, you can use the Import Bank Transactions (CA306500) or Process Bank Transactions (CA306000) form. You can load transactions for a bank feed that has the Active status.

Integrating Acumatica ERP with Bank Feeds

 Acumatica ERP is integrated with Plaid and MX, which are financial service companies that provide secure bank feeds. A bank feed is a secure link between Acumatica ERP and a company&rsquo;s bank profile, which can include multiple bank accounts. A bank feed is used for the automatic import of bank transactions into the system. A company may create different bank feeds for different banks. Alternatively, if the accounts in one bank are registered to different users, a company may create a bank feed for each user with a separate set of credentials. With this integration, Acumatica ERP users can automatically connect to their bank profiles, import bank transactions to Acumatica ERP, and create expense receipts based on these transactions.{br}

Bank feed integration is available in the system if the ''Bank Feed Integration'' feature is enabled on the [HelpRoot_FormReference\CS_10_00_00|Enable/Disable Features] ([~/?ScreenId=CS100000|CS100000]) form.{br}

If this feature is enabled, Plaid and MX subscriptions will become available to users in Acumatica ERP without the need to register separately in Plaid and MX. Acumatica ERP will store and return Plaid and MX authentication by using a special proxy server through API.{br}

Some banks do not have integration with Plaid or MX bank feeds, but they provide bank transactions to their customers in a file located in an SFTP folder. You can use Acumatica ERP to load bank statements from this type of file. The system then automatically creates the cash transactions and expense receipts that correspond to the transactions in the file.{br}

The ''Bank Feed Integration'' feature is subject to licensing. If an organization needs to map more than one bank feed account, it should buy an appropriate license.((({S:Warn}Currently, integration with MX works only for financial institutions in the United States and Canada.
)))
==In This Chapter{nestedtopics}==
*[HelpRoot_Integration\CA__MNG_Mapping_Multiple_Acc_to_One_Cash_Acc|Mapping of Multiple Bank Accounts to One Cash Account]
*:You can set up bank feeds to map multiple bank accounts to one cash account in Acumatica ERP. With this functionality, users can do the following:
*[HelpRoot_Integration\CA__HOW_Set_Up_Plaid_Integration|To Set Up Plaid Integration]
*:You perform the following instructions to set up the integration of Acumatica ERP with Plaid. You use the [HelpRoot_FormReference\CA_50_75_00|Retrieve Bank Feed Transactions] ([~/?ScreenId=CA507500|CA507500]) form as a starting point and then specify the settings of the bank feed on the [HelpRoot_FormReference\CA_20_55_00|Bank Feeds] ([~/?ScreenId=CA205500|CA205500]) form.
*[HelpRoot_Integration\CA__HOW_Set_Up_MX_Integration|To Set Up MX Integration]
*:You perform the following instructions to set up the integration of Acumatica ERP with MX. You use the [HelpRoot_FormReference\CA_50_75_00|Retrieve Bank Feed Transactions] ([~/?ScreenId=CA507500|CA507500]) form as a starting point and then specify the settings of the bank feed on the [HelpRoot_FormReference\CA_20_55_00|Bank Feeds] ([~/?ScreenId=CA205500|CA205500]) form.
*[HelpRoot_Integration\CA__HOW_Set_Up_Custom_Mapping_Rules|To Set Up Mapping Rules]
*:On the '''Custom Mapping Rules''' tab of the [HelpRoot_FormReference\CA_20_55_00|Bank Feeds] ([~/?ScreenId=CA205500|CA205500]) form, 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. You can specify your own mapping or set up the default mapping.
*[HelpRoot_Integration\CA__HOW_Bank_Feed_Integration_Import_BankTran|To Import Bank Transactions from a Bank Feed]
*:When Plaid or MX integration has been set up, you perform the instructions described below to import bank transactions from a bank feed into the system. You use the [HelpRoot_FormReference\CA_50_75_00|Retrieve Bank Feed Transactions] ([~/?ScreenId=CA507500|CA507500]) form for this import.
*[HelpRoot_Integration\CA__MNG_Loading_Bank_Feeds_from_File|Loading of Bank Feeds from a File]
*:To configure the system for loading of bank feeds from a file, the following configuration steps should be performed:
*[HelpRoot_Integration\CA__MNG_Loading_Bank_Feeds_for_BAI2|Loading of Bank Feeds from BAI2 Files]
*:Acumatica ERP supports the Bank Administration Institute Version 2 (BAI2) format of bank statements. The Balance and Transaction Reporting Standard (BTRS) improves upon the BAI2 format. The BAI2 and BTRS formats are banking industry standards for communicating bank statements electronically.
*[HelpRoot_Integration\CA__MNG_Loading_Bank_Feeds_for_AMEXGL1025|Loading of Bank Feeds from an AMEX GL1025 File]
*:In Acumatica ERP, you can import '''American Express GL1025 bank statement files''' through bank feeds. If your organization uses American Express corporate cards, this lets you process large volumes of employee expense transactions efficiently.
*[HelpRoot_Integration\CA__HOW_Set_Up_BankFeeds_from_File|To Set Up Bank Feeds Loaded from a CSV File]
*:You use the [HelpRoot_FormReference\CA_20_55_00|Bank Feeds] ([~/?ScreenId=CA205500|CA205500]) form to set up bank feeds that load bank transactions from a CSV file. On the same form, you connect to the SFTP folder where source files are stored and specify the mapping between the fields of the source file and the settings in Acumatica ERP.
*[HelpRoot_Integration\CA__HOW_Set_Up_BankFeeds_from_BAI2|To Set Up Bank Feeds Loaded from the BAI2 Format]
*:You use the [HelpRoot_FormReference\CA_20_55_00|Bank Feeds] ([~/?ScreenId=CA205500|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 Acumatica ERP.
*[HelpRoot_Integration\CA__HOW_Set_Up_BankFeeds_AMEX|To Set Up Bank Feeds Loaded from an AMEX GL1025 File]
*:You use the [HelpRoot_FormReference\CA_20_55_00|Bank Feeds] ([~/?ScreenId=CA205500|CA205500]) form to set up bank feeds that load bank transactions from an AMEX GL1025 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 Acumatica ERP.
*[HelpRoot_Integration\CA__HOW_Load_BankFeeds_from_File|To Load Bank Transactions from a File]
*:You use the [HelpRoot_FormReference\CA_50_75_00|Retrieve Bank Feed Transactions] ([~/?ScreenId=CA507500|CA507500]) form to load bank transactions from a file. Alternatively, you can use the [HelpRoot_FormReference\CA_30_65_00|Import Bank Transactions] ([~/?ScreenId=CA306500|CA306500]) or [HelpRoot_FormReference\CA_30_60_00|Process Bank Transactions] ([~/?ScreenId=CA306000|CA306000]) form. You can load transactions for a bank feed that has the ''Active'' status.