Creating a New Custom Payment File Template

To create a new custom payment file template:

1. Go to Payments > Setup > Payment File Templates > New.

2. In the Name field, enter a name for this payment file template.

3. In the Payment File Type field, select one of the following:

   • EFT – for vendor payments and customer refunds

   • DD – for customer payments

   • Positive Pay – for creating Positive Pay files

4. In the Currency field, select the currencies that you want to include in a single payment run when processing payments using this payment file template. To select all available currencies, check the Include All Currencies box. If you select multiple currencies, you must choose a company G/L bank account that uses the subsidiary base currency. For more information, see Setting Up Multi-Currency Payments Processing.

5. In the Country field, select the countries where you want this payment file to be used.

6. In the Reference Fields field, enter the custom fields that you want to be visible on the company bank details record. To see the fields that you can use, go to Customization > Lists, Records, & Fields > Record Types, and click Format Details.

   To enter custom Reference Fields, you should indicate the id, label, mandatory, and helptext values for each custom field. For example:

                   <refField id="custrecord_2663_acct_num" label="Account Number" mandatory="true" helptext="Enter your company's 8-digit bank account number."/> 
   
                 

   • id – Go to Customization > Lists, Records, & Fields > Record Types, and click Format Details. The attribute is listed on the Fields subtab, in the ID column.

   • label – Enter a name for this field that is meaningful to your users.

     Important:

     Label attribute is required when adding custom Reference Fields to prevent errors when processing payment files.

   • mandatory – Specify if the data field value is required or not.

   • helptext – Provide your users the purpose and function of the custom field to help them understand what the field is about.

7. In the Entity Reference Fields field, enter the custom fields that you want to be visible on the entity bank details record. To see the fields that you can use, go to Customization > Lists, Records, & Fields > Record Types, and click Entity Bank Details.

   To enter custom Entity Reference Fields, you should indicate the id, label, and mandatory values for each custom field. For example:

                   <refField id="custrecord_2663_entity_bank_no" label="Financial Institution Number" mandatory="true"/> 
   
                 

   • id – Go to Customization > Lists, Records, & Fields > Record Types, and click Entity Bank Details. The attribute is listed on the Fields subtab, in the ID column.

   • label – Enter a name for this field that is meaningful to your users.

     Important:

     Label attribute is required when adding custom Entity Reference Fields to prevent errors when processing payment files.

   • mandatory – Specify if the data field value is required or not.

   Note:

   Custom fields that you create for the entity bank details can be used as search columns. For instructions on setting up custom fields as search columns, see Using the Search Customization Page.

8. In the Field Validator field, add validations for the fields on the Company Bank Details record and the fields on the Entity Bank Details records. For more information, see Adding Field Validations to Custom Payment File Templates.

9. In the Maximum Lines field, enter the maximum number of transactions that can be processed using this template.

   A single payment run can process up to 5,000 transactions except for SEPA Direct Debit transactions. SEPA Direct Debit can only process up to 3,000 transactions.

   For Positive Pay, you must enter any value from 1 to 5,000 in the field. Negative numbers, zero, and numbers greater than 5,000 are invalid values and will not be accepted. Leaving the Maximum Lines field blank will not return any transaction result. For more information, see topic Verifying Issued Checks with Positive Pay.

10. If the template is for SEPA Direct Debit, check the Use Advanced SEPA DD Sorting box to enable grouping of payment transactions for a single payment run.

11. Check the Update Entity Bank Details box if updates should be made to the entity bank record after the payment file is created.

    Note:

    This preference is currently not yet supported by the new custom template using FreeMarker.

12. In the Bank File Template field, enter the template body using FreeMarker syntax. If the SuiteTax feature is provisioned in your account, enter the template body in the SuiteTax Bank File Template field.

    Note:

    For SEPA Direct Debit, you can use the template in step 4 of SuiteAnswers article ID 85484 as the template body. For more information, see Payment File Template Changes in NetSuite Electronic Bank Payments 2019.2

    Important:

    The Bank File Template field will be deprecated soon. In preparation for this change, we recommend adding your template body in the SuiteTax Bank File Template field. For more information, see the Payment File Template Changes in NetSuite Electronic Bank Payments 2019.1.

    For more information about using the FreeMarker syntax on your custom templates, see Working with Advanced Templates. When using advanced templates, take note of the specific words that must not be used for your custom variables and function names. See the complete list of words in the topic, Reserved Words.

13. In the Output File Extension field, enter the file extension to use for the output payment file. For example, txt, csv, or aba.

14. In the Output File Encoding field, select the character encoding type to use for the output payment file.

    Note:

    If you are using a custom Zengin payment template, select Shift_JIS as the character encoding type in the Output File Encoding field.

15. Check the Hide Account Number box to hide the Account Number field in view mode on the Company Bank and Entity Bank Details pages.

16. Check the Encrypt Account Numbers box to store the account numbers of Company Bank Details and Entity Bank Details records in encrypted form. After you enable the encryption feature, you cannot disable it. This feature is in accordance with the NACHA 2021 Rules.

17. Click Save.

Related Topics