BAI2 Configuration

this set of instructions addresses the configuration of bai2 bank feeds in our legacy bank feeds solution if you are an existing user of our legacy bank feeds solution, please refer to docid\ ei25axdjlazge0nmv 3cb to switch to the new solution if you are looking for instructions for our legacy bank feeds solution, please refer to docid\ tvborxgjfqocqtdnnriit enabling bai2 bank feeds refer to the steps below on how you can enable bai2 bank feeds create a format profile each format profile can only support one linked bank account complete the following steps for each of your bank accounts select the format profile configuration tab and select add fill in the following fields under primary information profile name any name we recommend you name this after the bank account you are linking profile type bank reconciliation connectivity method {{mybank}} bai2 transaction feed transaction parser bai2 plugin implementation do not click save yet note the connectivity method we ask you to select above is custom and comes from your bank bundle everything outside of this connectivity method is considered native to netsuite link gl account to the format profile now, select the account linking tab choose the appropriate linked gl account in the right hand column for the bank account you can skip the code type mapping tab for now and revisit it later if your bank has additional transaction codes also, skip the parser configuration tab, as it is required only for csv bank feeds click save to save this format profile important each format profile supports only one linked bank account; data will be imported only for the top most account with a linked gl account to enable bank feeds for additional accounts, you must repeat these steps for each one navigate to setup → accounting → financial institution → list select view for the financial institution you previously created, then click add under the format profile configuration tab monitor bank import process as soon as the format profile is saved, a blue banner will appear to notify you that netsuite is beginning the bank import process select track your status in the blue banner that appears, or go to transactions → bank → banking import history if the import was successful, you will see completed under the import status column if the import fails, you will see failed in the import status column select the plus (+) sign to expand the failure reason details if your failure reason states that a three digit number “is not one of your recognized bank transaction codes”, please proceed to the next step if your failure reason is anything other than an unrecognized bank transaction code, please take a screenshot of the error message and email it to the {{supportname}} team mailto\ jpmc support\@fispan com bai2 code type mapping return to setup → accounting → financial institution click edit on the financial institution that you have created previously select the format profile configuration tab and select edit on the format profile that had a failed import click on the code type mapping tab note if the code type mapping could not be completed during the initial setup of this format profile, it is because the system has not read any bank transactions yet and does not know if there are additional codes that require mapping fill in the following fields for the bank transaction code that was unrecognized bank transaction code description bank data type credit / debit the bank transaction code will be the three digit code from the error message seen on the banking import history page fill in description with something that will help you identify the bank transaction code bank data type and credit / debit values will be the same they both must be either credit, debit, or n/a to determine whether your bank transaction code is a credit or debit, refer to the table below type codes description 001 099 account status type codes 100 total credits summary type codes 101 399 credit summary and detail type codes 400 total debits summary type codes 401 699 debits summary and detail type codes 700 799 loan summary and detail type codes 900 999 customized type codes source https //www bai org/docs/default source/libraries/site general downloads/cash management 2005 pdf customized type codes should fall within the following ranges type codes description 900 919 account status codes 920 959 credit summary and detail 960 999 debit summary and detail source https //www bai org/docs/default source/libraries/site general downloads/cash management 2005 pdf for any codes between the 900 999 range that are continuing to fail, please reach out to {{supportname}} after filling in the above fields, click save this will trigger another import return to the banking import history page by either clicking track your status in the blue banner that appears, or by navigating to transactions → bank → banking import history if you receive a failure reason once more for an unrecognized bank transaction code, please repeat the above steps until the banking import status returns as completed for any issues with enabling bank feeds or code type mapping, please reach out to {{supportname}} at the below email address https //support fispan com/jpmorgan/contact us