Customized File Format Setup

There are two custom file formats available -- delimited (CSV) and fixed width. You can specify the file format type in the New File Format Setup page, which is accessed through the Recon Input tab.

Adding a New Delimited (CSV) File Format

From the Recon Input tab, select New File Format Setup. At the top left, you will see that the Delimited radio button is selected by default.

setup new file format screen

Recon Input >> Setup New File Format >> Delimited

Recon Input >> Setup New File Format >> Delimited

  1. Enter a File Format Name (e.g., My CSV Format).
  2. Select the Field Separator indicating the character that will separate the data value in each field. The options are Comma, Space and Tab. If using Space, you must enter a Text Delimiter to prevent spaces in text fields from creating a field break.
  3. Enter the Text Delimiter, if needed, indicating the character that will be used to enclose the data value field. The most common delimiter is a double quote ("). 
    Examples:
    "Value1", "Value2" the (") is the delimiter and the (,) is the separator.
    "Syracuse, NY" is a data value that contains a separator.. or character. In order for "Syracuse, NY" to be considered as one data value, the delimiter (") must be used. If the data value doesn’t have a separator character (comma or space) in the value, the delimiter is not needed.
  4. Select In File or On Upload in the Field Details column on the Account number line. This determines whether the account number will be located on each line in the file, or if each file will contain records for only one account. If using On Upload, the account number must be selected online prior to sending a file to the bank. When selecting On Upload, the Field Order box will not appear, as the account number is no longer considered part of the file format.
  5. Enter a number in the Order box of the first field listed. This number will indicate the placement of the field in the file.
  6. Select whether the field is Left or Right justified. When a file is uploaded, if a field contains data beyond the maximum amount allowed, the field will be truncated based on the Left or Right justification specified here.
  7. Repeat Steps 4 and 5 above for all of the required fields, shown in bold blue. All required fields are checked and cannot be unselected.
  8. Click the checkbox next to the remaining optional field names you want to include in the file, and repeat Steps 4 and 5 for the newly checked fields.
  9. Select the format of the Check Date. The Max Length field will auto-update based on the date format selected.
  10. Select Implied Decimal, No Implied Decimal or Auto-Determine Line By Line on the Check Amount line. Implied Decimal means a value of 100 is interpreted as $1.00. No Implied Decimal means a value of 100 is interpreted as $100.00. AutoDetermine Line By Line means the bank will look at each line and determine if a decimal should be included in the amount field. If a decimal is included, the amount will be interpreted for that line as No Implied Decimal. If a decimal is not included, the amount will be interpreted for that line as Implied Decimal. An amount of 100.00 would be interpreted as $100.00 and an amount of 10000 would be interpreted as $100.00.
  11. Selecting the Transaction Indicator field enables you to specify a custom Cancel Indicator, if you prefer not to use the pre-defined indicators of C, c or 2 when sending a Cancel/Void to the bank.
    Note: If you specify a custom Cancel Indicator, the values of C, V and 2 will still be treated as Cancels. Also, if you use other Transaction Indicators that are not in the predefined list, those transactions will be treated as Issues.
  12. Enter a description of the file in the Format Help Comments field. The information entered can be displayed when performing uploads by clicking Format Help.
  13. Click Save.

Note: Customers who have Payee Verification service must include Payee Line 1 and/or Payee Line 2 data in the data files.
Payee Line 1: Indicates the first Payee's name on the first line of the check.
Payee Line 2: Indicates the second Payee's name on the second line of the check.

Adding a New Fixed Width File Format

From the Recon Input tab, select New File Format Setup. At the top left, you will see the Delimited radio button is selected by default. To change to Fixed Width, click the Fixed Width radio button.

setup new file format screen

Recon Input > Setup New File Format > Fixed Width

Recon Input > Setup New File Format > Fixed Width

  1. Enter a File Format Name to indicate the name of the file format. (e.g., My Fixed Format)
  2. You also have the option to copy and paste a line of data from a file you have created into the Sample Data Line field. As you define the layout of the fields, the Sample Data column will be updated to show how the data in the Sample Data Line will be mapped for each field.
  3. Select In File or On Upload in the Field Details column on the Account number line. This determines whether the account number will be located on each line in the file, or if each file will contain records for only one account. If using On Upload, the account number must be selected online prior to sending a file to the bank. When selecting On Upload, the Start box will close, as the account number is no longer considered part of the file format.
  4. Enter a number in the Start box of the first field listed. This number will indicate the placement of the field in the file.
  5. Enter a number in the Length box. This number will indicate the size of the field. Please note that the Length may not be larger than the corresponding Max number to the right of the Length box.
  6. Repeat steps 3 and 4 above for all of the required fields. All required fields are checked and may not be unselected.
  7. Click the checkbox next to the remaining optional field names that you want to include in the file, and repeat steps 3 and 4.
  8. Select the Format of the Check Date. The Length field will auto-update based on the date format selected.
  9. Select Implied Decimal, No Implied Decimal or Auto-Determine Line By Line on the Check Amount line. Implied Decimal means a value of 100 is interpreted as $1.00. No Implied Decimal means a value of 100 is interpreted as $100.00. AutoDetermine Line By Line means the bank will look at each line and determine if a decimal should be included in the amount field. If a decimal is included, the amount for that line will be interpreted as No Implied Decimal. If a decimal is not included, the amount will be interpreted as Implied Decimal. An amount of 100.00 would be interpreted as $100.00 and an amount of 10000 would be interpreted as $100.00.
  10. When the Transaction Indicator field is selected, you can specify a custom Cancel Indicator, if you prefer not to use the pre-defined indicators of C, c or 2 when sending a Cancel/Void to the bank.
    Note: If you specify a custom Cancel Indicator, the values of C, V and 2 will still be treated as Cancels. Also, if you use other Transaction Indicators that are not in the predefined list, those transactions will be treated as Issues.
  11. Enter a description of the file in the Format Help Comments field. You can display the information keyed into the Format Help Comments field by clicking the Format Help button when performing uploads.
  12. Click Save.

Note: Customers who have Payee Verification service need to include Payee Line 1 and/or Payee Line 2 data in the data files.
Payee Line 1: Indicates the first Payee's name on the first line of the check.
Payee Line 2: Indicates the second Payee's name on the second line of the check.

Chase.com | JPMorgan.com | JPMorgan.com/payments

Privacy | Terms of Use | Accessibility | Cookies Policy | Regulatory Disclosures

Remember: We won't ask for confidential information such as your password, personal identification number (PIN) or other account information in a text message or email, or over the phone unless you call us about an issue, such as something to do with your account.

The information provided here is intended to help clients protect themselves from fraud and cyberfraud. It does not provide a comprehensive list of all types of fraud activities or identify all types of cybersecurity best practices. Your company or organization is responsible for determining how to best protect itself against fraud and cyberfraud and for selecting the best practices that are most appropriate to your needs.

Clients who do not use appropriate fraud-prevention tools increase their risk of losses and are liable for all losses incurred for payments originating using any authorized users’ security credentials or others who have designated transaction authority.

© 2024 JPMorgan Chase & Co. All rights reserved.