Enabling Legacy Bank Feeds (NetSuite)

note these set of instructions cover the setup of our legacy bank feeds solution that will no longer be supported as of bank plugin version 2024 2 0 if you are an existing user of our legacy bank feeds solution, please refer to migrating bank feeds (netsuite) docid\ jhyjibemfvyb5vt il9yx to switch to the new solution if you are new to bank feeds are are not currently using our legacy solution, please refer to enabling bank feeds (netsuite) docid\ omoofe9g3i y39zlzpoew to set up the new bank feeds solution note upon setup, netsuite will automatically import 60 days of past transactions into the match bank data module the timing and 60 day date range of this import cannot be customized you can find more information about this module by clicking this link to the oracle netsuite applications suite help center entry bank feeds suiteapp faq the bank bundle adds support for bank feeds through a custom connectivity method, which allows transactions from your bank accounts to flow automatically into netsuite's match bank data module to enable bank feeds in your netsuite environment, please follow the steps outlined in this guide this guide will walk you through two methods of enabling bank feeds, via csv bai2 which method to use is your choice, but most users prefer csv for richer detail please note that aside from the custom connectivity method that is named after your bank, everything else discussed in this guide is owned and managed by netsuite this includes, but is not limited to, the following match bank data module bank statement parsers bundle financial institution configuration format profile configuration banking import history page while owned and managed by netsuite, the following cannot be customized timing of when the daily bank transaction import begins netsuite randomly assigns a time, usually between 4 7 am pt timing of when the first automatic bank transaction import is the first import occurs immediately after a new format profile as per instructions in this guide is setup and saved number of days of past transactions imported upon setup netsuite will import 60 days worth of transactions after initial setup the bank feeds feature requires your bank bundle to be updated to version 2021 16 0 or newer for users on newer version, you may skip to step 3 install bank statement parsers updating the bank bundle step 1 locate bundle go to customization → suitebundler → search & install bundles → list step 2 update bundle find the commerce connections direct bundle from the list then, hover over the green icon and select update select update bundle , and select ok on the confirmation pop up note non administrator users who will be setting up and managing bank feeds must have the following permission setup → financial institution records – level full they must also be added as an audience for the following script deployment (can be found under customization → scripting → script deployments) commerce bank trans feed config (id customdeploy commerceconnections rpt feed s) step 3 install bank statement parsers bundle navigate to customization → suitebundler → search & install bundles then, search for bank statement parsers , select the appropriate bundle (293699), and select install the bundle will take a few moments to install – it will appear as pending and then show the progress of the install once complete, the status column on the installed bundles page will show a check mark step 4 enable bank account feature go to setup → accounting → chart of accounts select edit on the bank account for which you would like to use the reconciliation feature select the “ use match bank data and reconcile account statement pages” box to enable this feature for the account then, select save step 5 create financial institution go to setup → accounting → financial institution enter a name for the financial institution then, select save enabling csv bank feeds users have the option to enable either csv bank feeds or bai2 bank feeds while some users may wish to have some bank accounts connected to csv and others to bai2, this is uncommon and does not provide any added benefit we recommend users to pick either csv or bai2 for all bank accounts they wish to enable bank feeds for refer to the below steps on how you can enable csv bank feeds, otherwise skip down to the enabling bai2 bank feeds section of this guide \[csv] step 1 create a format profile with primary information note each format profile can only support one linked bank account only the top most account with a “linked gl account” in the format profile will have data imported, and other imports will show as failed within the banking import history page to enable bank feeds for your other bank accounts, please create a separate format profile for each account by repeating the steps below to add a new format profile, navigate to setup → accounting → financial institution → list select view for the financial institution you created previously, and then add under the format profile configuration tab 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 my bank csv transaction feed transaction parser csv 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 \[csv] step 2 define parser configuration parameters on the format profile then, select the parser configuration sub tab ensure the following fields are shown under the field mapping sub tab account number date amount payee or payer name transaction number memo transaction type customer name customer id invoice numbers then, select the formatting preferences tab within parser configuration please ensure the number format is set to 1000000 00 , and negative number format is set to 100 then, select submit to save the parser configurations do not click save yet on the format profile \[csv] step 3 link a 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 now you may finally click save for this format profile note each format profile can only support one linked bank account only the top most account with a “linked gl account” in the format profile will have data imported, and other imports will show as failed within the banking import history page to enable bank feeds for your other bank accounts, please create a separate format profile for each account by repeating the steps you actioned above to add a new format profile, navigate to setup → accounting → financial institution → list select view for the financial institution you created previously, and then add under the format profile configuration tab \[csv] step 4 monitor bank import process as soon as the format profile was 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 → your 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 please take a screenshot of the error message and download the csv provided from the link in the error message then, email this information to support commerce support\@fispan com enabling bai2 bank feeds refer to the below steps on how you can enable bai2 bank feeds \[bai2] step 1 create a format profile with primary information 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 \[my bank] 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 \[bai2] step 2 link a 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 each format profile can only support one linked bank account only the top most account with a “linked gl account” in the format profile will have data imported to enable bank feeds for additional accounts, repeat these steps for each account navigate to setup → accounting → financial institution → list select view for the financial institution you created previously, and then add under the format profile configuration tab depending on whether your bank has additional bank transaction codes, we may revisit the code type mapping tab later you may safely skip any changes to this tab for now and the parser configuration tab, which is only used for csv formatted bank feeds click save to save this format profile \[bai2] step 3 monitor bank import process as soon as the format profile was 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 support team commerce support\@fispan com \[bai2] step 4 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 why code type mapping could not be completed during initial set up of this format profile is because the system has not read any bank transactions yet, and therefore 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 how to determine whether your bank transaction code is a credit or debit, please refer to the below table 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 215,578 trueleft unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type 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 fispan support 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 fispan support at the below email address commerce support\@fispan com faqs "how many days of transactions will the initial sync import? up to 60 days of settled transaction data, if available "will duplicates be removed?" netsuite will attempt to remove duplicates if any remain, they can be manually removed via the "exclude" option in the page "when will the daily sync occur?" between 4 00am and 7 00am est "how will the data be transmitted?" a pre formatted csv is uploaded to netsuite "is it possible to add additional fields?" netsuite does not allow the addition of fields at this time, nor can we customize special data on a per client basis "why are the 'bank balance' and 'balance as of' fields in the match bank data page empty, despite a successful import?" due to a netsuite limitation, we are unable to import the balance data for bank accounts