Step 10: Account Matching

each erp account should have a matching bank account only the matched accounts will be used in your plugin follow these steps to learn how to match your erp accounts with the corresponding bank accounts important the use account numbers preference must be enabled in netsuite to match your bank accounts to do this in netsuite, go to setup > accounting > accounting preferences on the general ledger tab, check the box next to use account numbers after enabling this, click the x in the error banner on this page to reload your accounts if you receive an error during account matching after the feature is enabled, please contact support for further assistance note when installing the plugin in sandbox, bank accounts are for testing only they are not connected to your live bank accounts when installing in production, the listed bank accounts reflect your actual accounts account matching setup match your erp accounts with the corresponding bank accounts by dragging an erp account from the left and dropping it onto the desired bank account once you've successfully matched your accounts, click next step for virtual card payments (if applicable), you will need to map the bank account to a credit card type netsuite account, not a netsuite bank account important it might take a few moments for your accounts to appear, depending on the number of accounts you have and how quickly netsuite is processing them please do not refresh or leave the page until everything has loaded note if you would like to add new accounts or functionalities after your initial installation and set up, please submit a request to your bank representative tip wish to set a default account for payables? let us know which account you'd like by contacting our support please specify the last 4 digits of the bank account number in your request each company can have only one default source account across all subsidiaries account matching error troubleshooting netsuite will load your erp accounts from the chart of accounts depending on the number of accounts you have or your device's security settings, you might see the following error "there was an error loading the bank accounts close this to retry!" if this error appears, click the ' x ' to retry loading the accounts if you see the error again, click next step and finish the rest of the wizard if you are still unable to load the accounts, our support team can manually map them for you to do this, please provide us with the internal id from netsuite provide netsuite internal id search accounts in netsuite go to lists → accounting → accounts → search select use advanced search under the criteria tab, in the filter box, select type and choose bank (and/or credit card if matching for sua payments) then select set filter results with internal id under the results tab, remove all but the name , account type , and description fields, then add the field internal id once complete, select submit download xls format on the account search results page, please select the microsoft excel icon to download this list in an xls format once the download is complete, please open the xls file and add a column with the last 4 digits of the account the internal id should be mapped to save this xls file, and you can contact us here to help troubleshoot jpmc support\@fispan com