This is a file of the checks processed that the district sends to the bank. Banks use the positive pay file to match the checks the school issues with those presented for payment to help with fraud detection.
The following options can be configured to control the formatting of the extract file. The required formatting for the file is determined by the bank requirements.
- Select Format Type
- CSV: Comma Separated Values
- Fixed: Fixed width file that will download as a TXT. This can also be changed to (saved as) a SEQ file once downloaded.
- Select bank format extract fields.
- Click the at the bottom of the grid to add fields
- Once added, use the drop down under the Name column to select the data that should appear in that field.
- The Length column determines how many characters make up that field.
- The Format specifier default for each field added. These correspond to standard format specifiers. For more information see the Format Specifiers section below.
Once the format is configured, follow the below steps to generate the extract file.
- Select which checks to include by entering a Starting Date. Checks with a transaction date on or after the date entered will be included in the extract file.
- Select a Bank Account number to be used for the "Bank Account Number field on the extract file. These options correspond to the records entered on the Core > Bank Accounts page.
- Click on Generate to create the extract file.
Format specifiers are used in programs to define the type of data to be printed on standard output. It is a way to define what type of data is expected to be in a field. The table below lists all specifiers, but the following are the most commonly used when configuring the Positive Pay extract.
- %s - Can be a string of any type of value - alpha or numeric
- %d - has to be in integer/numerical value (used with date fields/check number)
A number after % specifies the minimum field length. If there are less characters than specified then the remaining spaces are left blank. If the data for that field is longer than specified then it will show as it is without truncation.
Here is a quick reference to all the conversion specifiers supported.