/
Creating USPS Positive Pay Extract

Creating USPS Positive Pay Extract

Oct 21, 2021

This document will walk you through how to generate a positive pay extract from USPS. Positive Pay extract 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. 



Please contact NWOCA Fiscal Support and they will assist in setting up the format. 

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. 

  1. Select Format Type

    1. CSV: Comma Separated Values



    2. Fixed: Fixed width file that will download as a TXT. This can also be changed to (saved as) a SEQ file once downloaded.



  2. Select bank format extract fields.

    1. Click the 

       at the bottom of the grid to add fields

    2. Once added, use the drop down under the Name column to select the data that should appear in that field.

    3. The Length column determines how many characters make up that field.

    4. The Format specifier default for each field added. These correspond to standard format specifiers. 



Once the format is configured, follow the below steps to generate the extract file.

  1. Go to Utilities/Automatic Payment Reconciliation/Pay Rec Extract tab

  2. Select which checks to include by entering a Starting Date. The date needs to be before the Issue Date of the check in order for it to be included in the Extract File

  3. Select a Bank Account number to be used for the 'Bank Account Number' field on the extract file.



  4. Payment Transaction Type:  

    1. Payroll Check

    2. Deduction Check

    3. Group Deduction Check

    4. Refund of Payroll Item

    5. All

  5. Click on Generate Extract to create the extract file. If a PDF is desired click on Generate Report.