Skip to content

Create a positive pay file

A positive pay file lists the checks you’ve written. You upload it to your bank, and the bank clears only the checks in the file.

  1. Send your bank’s positive pay upload format to Nexsyis Support. For example, a bank might ask for a comma-delimited file like this:

    An example check issue file layout with account number, check number, amount, date, issue or void code and payee name

  2. Nexsyis sets up the format for you. See Positive pay template reference.

  3. Select the format on the bank account: open Setup › Accounting › Banking / Cash › Bank Accounts, select the bank, and on the Check Printing tab select the Positive Pay Format.

    The Check Printing tab of a bank account with the Positive Pay Format field

To create a positive pay file, the user needs:

  • The Create Positive Pay File transaction permission. On screen it’s spelled Create Postitive Pay File, in the Banking group.
  • A/P Pmts permission for the bank account.

The Transaction Permissions tab with Create Postitive Pay File allowed

  1. On the Accounting tab, select Create Positive Pay File.

    Create Positive Pay File in the Banking/Cash group of the Accounting tab

  2. Select the date range of the checks to include in Check Dates From and Thru.

  3. Select a Positive Pay Format.

  4. To include one bank only, select it in Bank. Leave Bank blank to include every bank you have permission for that uses that format.

  5. Select Save.

    The Create Positive Pay File screen

Only checks from banks where you have check printing permission, and that use the selected format, are included.

A positive pay template has an optional header line, one detail line per payment and an optional total line. Templates are set up by Nexsyis in the BAPositivePay and BAPositivePayFields tables.

An example positive pay template, with the file settings and the field list for each line

Value Description
NewCheckCode Code for original payments.
NewVoidCode Code for voided payments.
DateSeparator Character between month, day and year, for example - or /.
DateFormat Date format, for example MM-DD-YYYY or MM/DD/YYYY.
FieldType F = fixed length; V = variable length.
ImpliedDecimal 1 = implied decimal (3267 for 32.67); 0 = include the decimal.
AllowSpecialChars 1 = strip non-alphanumeric characters; 0 = allow all characters.
FileExt File extension to add.
Value Description
FieldOrder Position of the field in the line.
FieldName Field constant (see the lists below).
DefaultValue Value to repeat on every line (optional).
FieldLength Length of the field (fixed length only).
Justify L = left; R = right (fixed length only).
RecType D = detail; H = header; T = total.
FieldFormat F = fixed; V = variable.
FieldDelimiter Delimiter for variable length (defaults to a comma).
MaxLength Maximum characters for variable-length fields (0 = no limit).

Header line

  • ACCOUNTNO: account number
  • CDAACCTNO: Canadian account number
  • FILEDATE: file creation date
  • BRANCHTRANSIT: Canadian ABA transit number
  • FILENUMBER: unique ID that increases with each file (assigned by Nexsyis)
  • CONSTANT1 to CONSTANT5: custom constant values
  • SPACE: space characters

Detail line

  • ABATRANSIT: ABA transit number
  • ACCOUNTNO: account number
  • CHECKNO: payment or check reference number
  • CHECKDATE: payment date
  • CHECKAMOUNT: payment amount
  • TRANSTYPE: NewCheckCode or NewVoidCode
  • VOIDIND: “V” for voids; otherwise a space (fixed) or empty (variable)
  • VOIDDATE: void date
  • OPTIONALDATA: check register description (special characters removed if applicable)
  • PAYEENAME: check register description (special characters removed if applicable)
  • SPACE: spaces for the field length
  • CONSTANT1 to CONSTANT5: custom constant values

Total line

  • ACCOUNTNO: account number
  • CHECKTOTAL: sum of all payments
  • DETAILCOUNT: number of detail lines
  • CONSTANT1 to CONSTANT4: custom constant values
  • SPACE: spaces for the field length