Export Details

                                 

Expand/Collapse all Show/Hide All

Positive Pay is designed for businesses that want to prevent check fraud and want their financial institution to help monitor against suspicious check activity. Positive Pay will match the account number, check number, and dollar amount of each check transmitted for payment against a list of checks previously authorized and issued by your company. All three components of the check must match or it will not be paid.

Positive Pay requires your company to send a file of issued checks to your financial institution each day checks are written. Your financial institution provides you with the file format requirements needed to submit the checks.  

Note Sage does not warrant that the financial institution associated with the name of any particular format will accept submission of that file. Contact your financial institution for their current submission requirements.

Expand/Collapse item  Positive Pay Export Wizard Column Heading Comparisons

The table below provides you with some alternative column heading names collected from various financial institutions that you can use to compare and select the predefined fields for the export file.

Positive Pay Export Wizard -
Column Headings

Financial Institution -
Column Headings

Description/Comments

Field Description

  • Description

  • Data Element

  • Field

  • Field Description

  • Column Headers

  • Field Name

Provides a list of common fields that are used by your financial institution. If the field does not closely match the required fields provided by your financial institution, enter a new field description of up to 30 alphanumeric characters.

Start/End

  • Position

  • From/To

  • Beginning Position

  • Field Position

  • Start Position

  • Character Positions

  • Column Begin/End

  • Row Formatting Instructions

Displayed only when using a fixed format file type.

Column No.

  • Field

  • Field No.

  • Position

  • Column

Displayed when using a comma delimited (csv) file type.

Length

  • Max Length

  • Size

  • Length

  • Field Length

  • Field Size

  • Characters

  • Row Formatting Instructions

Calculated for fixed format file types, and is based on the value entered in the Start and End fields. You can enter the length of the field for comma delimited (csv) file types.

Field Value

  • Value

  • Description

  • Contents

Used for constant values, bank numbers, remote ID, batch ID, service type, destination identifier, and other literal values.

Date Format

  • Date Format

  • Format

  • Notes

  • Content

  • Special Instructions

  • Rules

  • Comments

  • Description

  • Row Formatting Instructions

Contains the following values:

  • YYYYMMDD

  • YYMMDD

  • MMDDYY

  • MMDDYYYY

  • YYYYDDD

  • MM/DD/YY

  • MM/DD/YYYY

  • MM-DD-YYYY

  • YYDDD

Note DDD is the number of the day of the year.

Justification

  • Format/Justification

  • Comment

  • Description

  • Type

  • Rules

  • Value

  • Data Requirements

  • Row Formatting Instructions

  • Specification Overview

Contains the following values:

  • Right

  • Left

Zero Filled

  • Format/Justification

  • Comment

  • Description

  • Type

  • Rules

  • Value

  • Data Requirements

  • Row Formatting Instructions

  • Specification Overview

Select the check box if the field needs to be zero filled.

Implied Decimal

  • Field Type

  • Field Details

  • Row Formatting Instructions

Select the check box if a decimal point should not be exported. If a numeric value has 3 decimal places, it will be rounded to 2 decimal places before the decimal point is removed. Example: 10 will be exported as 1000, 10.1 will be exported as 1010, and 10.125 will be exported as 1013.

 

Note The Length of Record field may be referred to as the Record Length or Record Size by your financial institution. The number in this field is calculated based on the Start and Length columns, or you can enter a value. As lines are added, deleted, or modified this field is populated with the total record length. This only applies to fixed format file types.

 

Expand/Collapse item  Define Formatting Information for the File Header Record, Header Record, Second Header Record, Trailer Record, Second Trailer Record, and File Trailer Record

  • A File Header Record may be referred by your financial institution as a File Header Record, Sign On Record, or CBB/FTS Upload Record.

  • A Header Record may be referred to by your financial institution as a Header Record or a Batch Header Record.

  • A Second Header Record may be referred to by your financial institution as a Header Record, File Header Record, or a Batch Header Record.

  • A Trailer Record may be referred to by your financial institution as a Trailer Record, Control Record, or a Total Record.

  • A Second Trailer Record may be referred to by your financial institution as a Second Trailer Record, Batch Trailer Record, or Total Record.

  • A File Trailer Record may be referred to by your financial institution as a File Trailer Record or a File Total Record.

 

Expand or collapse item  Sample 1 of a Positive Pay Export File Structure - if not combining multiple bank codes into a single file

Note The export file structure may not exactly match your export file structure.

File Header Record

            Bank Code A Header Record

            Bank Code A Header 2 Record

                        Bank Code A Detail Record

                        Bank Code A Detail Record

                        Bank Code A Detail Record

                        Bank Code A Detail Record

                        Bank Code A Detail Record

            Bank Code A Trailer Record

            Bank Code A Trailer 2 Record

File Trailer Record

 

Expand or collapse item  Sample 2 of a Positive Pay Export File Structure - when combining multiple bank codes into a single file

Note The export file structure may not exactly match your export file structure.

File Header Record

            Bank Code A Header Record

            Bank Code A Header 2 Record

                        Bank Code A Detail Record

                        Bank Code A Detail Record

                        Bank Code A Detail Record

                        Bank Code A Detail Record

                        Bank Code A Detail Record

            Bank Code A Trailer Record

            Bank Code A Trailer 2 Record

            Bank Code B Header Record

            Bank Code B Header 2 Record

                        Bank Code B Detail Record

                        Bank Code B Detail Record

                        Bank Code B Detail Record

                        Bank Code B Detail Record

                        Bank Code B Detail Record

            Bank Code B Trailer Record

            Bank Code B Trailer 2 Record

File Trailer Record

 

Expand or collapse item  Sample 3 of a Positive Pay Export File Structure - when combining multiple bank codes into a single file, and one record per file is selected for Header Record and Second Header Record

Note The export file structure may not exactly match your export file structure.

File Header Record

            Bank Code A Header Record

            Bank Code A Header 2 Record

                        Bank Code A Detail Record

                        Bank Code A Detail Record

                        Bank Code A Detail Record

                        Bank Code A Detail Record

                        Bank Code A Detail Record

            Bank Code A Trailer Record

            Bank Code A Trailer 2 Record

                        Bank Code B Detail Record

                        Bank Code B Detail Record

                        Bank Code B Detail Record

                        Bank Code B Detail Record

                        Bank Code B Detail Record

            Bank Code B Trailer Record

            Bank Code B Trailer 2 Record

File Trailer Record

 

Expand or collapse item  Sample 4 of a Positive Pay Export File Structure - when the header sequence number is used in the File Header Record, Header Record, Trailer Record, and File Trailer Record

Note The export file structure may not exactly match your export file structure.

File Header Record (Header Sequence No = 1)

            Bank Code A Header Record (Header Sequence No = 2)

            Bank Code A Header 2 Record (Header Sequence No = 2)

                        Bank Code A Detail Record

                        Bank Code A Detail Record

                        Bank Code A Detail Record

            Bank Code A Trailer Record (Header Sequence No = 2)

            Bank Code A Trailer 2 Record (Header Sequence No = 2)

            Bank Code B Header Record (Header Sequence No = 3)

            Bank Code B Header 2 Record (Header Sequence No = 3)

                        Bank Code B Detail Record

                        Bank Code B Detail Record

                        Bank Code B Detail Record

            Bank Code B Trailer Record (Header Sequence No = 3)

            Bank Code B Trailer 2 Record (Header Sequence No = 3)

File Trailer Record (Header Sequence No = 1)

 

Expand or collapse item  Sample 5 of a Positive Pay Export File Structure - when the header sequence number is used only in the Header Record and Trailer Record

Note The export file structure may not exactly match your export file structure.

File Header Record

            Bank Code A Header Record (Header Sequence No = 1)

            Bank Code A Header 2 Record

                        Bank Code A Detail Record

                        Bank Code A Detail Record

                        Bank Code A Detail Record

            Bank Code A Trailer Record (Header Sequence No = 1)

            Bank Code A Trailer 2 Record

            Bank Code B Header Record (Header Sequence No = 2)

            Bank Code B Header 2 Record

                        Bank Code B Detail Record

                        Bank Code B Detail Record

                        Bank Code B Detail Record

            Bank Code B Trailer Record (Header Sequence No = 2)

            Bank Code B Trailer 2 Record

File Trailer Record

 

Expand or collapse item  Sample 6 of a Positive Pay Export File Structure - when the header sequence number is used in the File Header Record, Header Record, Trailer Record, and File Trailer Record and the checks are sorted by check date

Note The export file structure may not exactly match your export file structure.

File Header Record

            Bank Code A Check Date 05/01/10 Header Record (Header Sequence No = 1)

            Bank Code A Check Date 05/01/10 Header 2 Record

                        Bank Code A Check Date 05/01/10 Detail Record

                        Bank Code A Check Date 05/01/10 Detail Record

                        Bank Code A Check Date 05/01/10 Detail Record

            Bank Code A Check Date 05/01/10 Trailer Record (Header Sequence No = 1)

            Bank Code A Check Date 05/01/10 Trailer 2 Record

            Bank Code A Check Date 05/03/10 Header Record (Header Sequence No = 2)

            Bank Code A Check Date 05/03/10 Header 2 Record

                        Bank Code A Check Date 05/03/10 Detail Record

                        Bank Code A Check Date 05/03/10 Detail Record

                        Bank Code A Check Date 05/03/10 Detail Record

            Bank Code A Check Date 05/03/10 Trailer Record (Header Sequence No = 2)

            Bank Code A Check Date 05/03/10 Trailer 2 Record

            Bank Code B Check Date 05/01/10 Header Record (Header Sequence No = 3)

            Bank Code B Check Date 05/01/10 Header 2 Record

                        Bank Code B Check Date 05/01/10 Detail Record

                        Bank Code B Check Date 05/01/10 Detail Record

                        Bank Code B Check Date 05/01/10 Detail Record

            Bank Code B Check Date 05/01/10 Trailer Record (Header Sequence No = 3)

            Bank Code B Check Date 05/01/10 Trailer 2 Record

            Bank Code B Check Date 05/02/10 Header Record (Header Sequence No = 4)

            Bank Code B Check Date 05/02/10 Header 2 Record

                        Bank Code B Check Date 05/02/10 Detail Record

                        Bank Code B Check Date 05/02/10 Detail Record

                        Bank Code B Check Date 05/02/10 Detail Record

            Bank Code B Check Date 05/02/10 Trailer Record (Header Sequence No = 4)

            Bank Code B Check Date 05/02/10 Trailer 2 Record

File Trailer Record

 

 

Note When defining record requirements for a single record type, only the detail record type needs to be defined.

Use the table below to help select the predefined fields that best match the fields required by your financial institution. The field descriptions are used for the File Header Record, Header Record, Second Header Record, Trailer Record, Second Trailer Record, and File Trailer Record.

Positive Pay Export Wizard Field Descriptions

Description/Comments

 

Record Type

This field indicates the type of record. It is also referred to as the Record Type Code, Record Indicator, Record Code, Header Record Type, Header Record Indicator, Header Record Label, Trailer Record Type, Account Total Indicator, File Total Indicator, or Total Record Indicator. Example: H, 20, 1, or $$ADD

Account Number

This is the Account Number field set up in Bank Code Maintenance. It is also referred to as the Checking Account Number, Bank Account Number, DCH Account Number, or Account.

Bank Number

Provided by your financial institution. It is also referred to as the Bank ID or Bank Code.

Transit ID

It is also referred to as the Routing Transit Number or Bank Transit Number.

Company Name

This is the Company Name field set up in Company Maintenance. The field value can be changed.

File Date

This field is the system date at the time of processing.

It is also referred to as the File Creation Date, Batch Creation Date, Processing Date, Transmission Date, or Date of File.

File Time

This field is the system time at the time of processing. It is also referred to as the File Creation Time, Transmission Time, or Batch Creation Time.

File Sequence No.

This field is a sequence number generated by the program and can also be used in the file name. It applies only for file name formats such as 'Run Date + Bank Code + Seq' and 'ARPxxxxx'. It is blank for other file name formats.

Header Sequence No.

This field is a sequence number generated by the program and is used when there are multiple header records. It increases when a new Header Record is generated. A Header Record is generated when the 'group' changes. A group is usually a Bank Code. If the Sort Checks by Check Date check box is selected, a group is Bank Code + Check Date.

  Total Detail Count

This field is the total number of detail records in the exported file.

  Total Item Count

This field is the total number of records in the exported file, but may not equal the true number of records in the file. A Header or Trailer Record is counted when the Does the header/trailer record need to be included in the total item count? check box is selected in the Positive Pay Export Wizard. Reversed and voided checks are counted when the Do you need to include reversed and voided checks in the total item count? check box is selected in the Positive Pay Export Wizard.

  Total Dollar Amount

This field is the sum of all the amounts in the exported file. Reversed checks can increase, decrease, or not be included in this total.

  Sum of Check Numbers

This field is the total sum of the actual check numbers in the exported file. It is also referred to as a Hash Total.

  Total Bank Count

This field is the total number of bank codes that are included in the export file. This field is available only for the File Header Record and File Trailer Record types.

  Next Batch Number

A batch number can be entered at the time of processing and increments automatically at the end of processing. It is also referred to as a Batch Control Number.

  Runtime Date Option

Can be used for entering a date at the time of processing. It is also referred to as Certification Cutoff Date.

  Runtime Option 1

Can be used for entering a value at the time of processing. It is also referred to as Final Input Indicator.

  Runtime Option 2

Can be used for entering a value at the time of processing.

  User-Defined Fields

User-defined fields appear if they were created for Gl Bank Code Master. UDFs are available in a Header Record and Trailer Record.

 

Expand/Collapse item  Define Formatting Information for the Detail Record

Use the table below to help select the predefined fields that best match the fields required by your financial institution. The field descriptions are used for the Detail Record.

Positive Pay Export Wizard Field Descriptions

Description/Comments

 

Record Type

This field indicates the type of record. It is also referred to as the Record Type Code, Record Indicator, Record Code, Region Code, or Detail Indicator. Example: D, 00, 10, or blank

Account Number

This is the Account Number field set up in Bank Code Maintenance. It is also referred to as the Checking Account Number, Bank Account Number, DCH Account Number, or Account.

Check/Serial Number

It is also referred to as the Check Number, Serial Number, Cheque Sequence Number, or Cheque Serial Number.

Issue Date

It does not apply to voided, reversed, or deleted checks. It is also referred to as the Issue Date of Check, Check Issue Date, Date of Issue, Actual Date of Issue, Check Date of Issue Check, or Date.

Void Date

It does not apply to issue checks. Can be the same as the Issue Date field or your financial institution may require the void date in another position/column in the exported file. It is also referred to as the Check Date of Voided, Reversed Check, or Deleted Check.

Original Issue Date

It does not apply to issue checks. It is also referred to as the Original Check Date, Original Issue Date, Original Issue Date of Voided Check, Original Issue Date of Reversed Check, or Check Date. Example: The check number 00123 was issued on 3/10/10; it was reversed on 3/12/10; the original issue date is 3/10/10.

Amount

It is also referred to as the Check Amount, Transaction Amount, Dollar Amount, or Cheque Amount.

Check Type Indicator

The value in this field defaults from the value entered in the Define Formatting Information for the Detail Record page. It is also referred to as the Action, Transaction Code, Transaction Type, Record Type Code, Status Code, Record Type, Void Indicator, Void Type Indicator, Void Check Indicator, Issue Record, or Payment Type.

Payee Name

This is the Payee Name field on the check. For payroll checks, the payee name is the Employee Name field from Employee Maintenance and it is the employee first name + space + employee last name. It is blank for reversed and voided checks if the Do you need to include the payee name for reversed and voided checks? check box is cleared in the Positive Pay Export Wizard.

Vendor Address

This is the Address field from Vendor Maintenance. It is the full address including the city, state, and ZIP Code. Country code is also part of the address for accounts payable checks.

Employee Address

This is the Address field from Employee Maintenance. It is the full address including the city, state, and ZIP Code.

Highest Deletd Chk No.

This is the last voided check number in the range of checks.

Next Batch Number

A batch number can be entered at the time of processing and increments automatically at the end of processing. It is also referred to as a Batch Control Number.

Runtime Date Option

Can be used for entering a date at the time of processing.

Runtime Option 1

Can be used for entering a value at the time of processing.

Runtime Option 2

Can be used for entering a value at the time of processing.

User-Defined Fields

User-defined fields appear if they were created for GL Bank Code Master.

© Sage Group plc 2019. Privacy Policy | Copyright/Trademarks