Check Printing Interface and Positive Pay Layouts
To use Positive Pay, you create a layout that matches your banks layout. Workamajig uses a flexible layout screen to define fields and setup the file. If you click the Copy Layout From button, you can copy the layout from some of the larger banks predefined layouts. To generate a positive pay file, you can either do it at time of printing checks or in larger batches from the Payments screen.
What is a positive pay system?
Positive pay systems are a powerful tool for fighting check fraud. As the incidence of counterfeit checks continues to increase, more and more financial institutions are employing such tools to help reduce their losses. In essence, a positive pay system allows a bank to compare checks presented against its commercial customer's account against items the customer indicates it has written. It will uncover instances where the amount has been altered, a counterfeit has been created using a different check number, or the payee name does not match.
Positive Pay Layouts may be accessed from Menu > Admin/Manager > System Setup > GL Settings> Positive Pay Layouts. Positive Pay information is transmitted to banks in a fixed-width, plain text format known as a "flat file." A bank that accepts Positive Pay data will publish a document specifying the format to use. That document may be used to create an appropriate layout, or a pre-defined layout may be used or modified.
Copy Layout From
We have defaults in place for BMO or BofA. To use one of these, create a new layout and name it. Then use Copy Layout From option to copy in these defaults.
Manually Creating a Layout
- In a fixed width file, each line of data represents a new record and each field of data is a predetermined number of characters. A file of names that had two fields, an 8-character first name field and an 8 character last name field would look like this:
- Names (e.g. "George") that are fewer than 8 characters still take up 8 spaces. Names that are longer than 8 characters (e.g. "Rutherford") are truncated.
- When creating a Positive Pay Layout unique Layout Name is required to identify this layout in the areas of Workamajig it will be used. Typically, there will only be one layout per banking institution and the name could reflect this.
- Workamajig has preloaded some Positive Pay formats. To use one of these, click the Copy Layout from... option in the upper right portion of the screen. This will overwrite any field information that has been input into the layout.
- There are three field sets, Header Fields, Detail Fields, and Footer Fields. Not all layout specifications use the Header or Footer field sets. All use the Detail Fields as each check is represented as a Detail record.
- If not loaded by using the Copy Layout from... feature, each fixed-width column is added (or removed) using the Add and Remove buttons on the left side of the screen.
- Field Label is required in order to refer to the data column (e.g. "Last Name").
- Start Character Index is a required numeric value specifying where the data field begins. In the above example, the Last Name field would have a Start Character Index of "9".
- End Character Index is a required numeric value specifying where the data field ends. In the above example, the Last Name field would have an End Character Index of "16".
- Use Payment Data may be checked in order to specify information from the Payment record in the Data Value field. Otherwise, information in the Data Value field will be printed as shown on each record.
- When Override on Void is checked, voided payments will use the information in the Void Override Value field instead of the Data Value field.
- The Placeholder character is takes up empty data spaces. By default, when the data in a field contains fewer characters than the field definition, spaces are added. In the above example, there are two spaces after the name "George" because the field has 8 characters and "George" only requires 6. If the Placeholder is defined as "*" for the first name the data would then print as "George**".
- Check the Required box if this data is required by the banking institution. This ensures that an error will be issued in the event this report is run with required data missing from the payment record rather than transmitting improper data to the banking institution. This is only relevant for fields that have Use Payment Data checked.
- The Format value specifies how Payment data will be formatted in the report. Layouts will typically need date values, for instance, to be formatted in a uniform manner in order to be interpreted correctly.
- Alignment is set to "Left" by default. This puts the Placeholder character(s) to the right of the data. Some data, typically numeric data, is required to be preceded by the Placeholder(s).
- The Grouping Function is found only in the Header Fields and the Footer Fields sets. This is most often used to "Sum" the Payment Amount for all detail records. In may also be set to "Count" to reflect the total number of payment records in the detail set.
Set New Layout on Check Format
Once the new layout is created, it will need to be selected on the Check Format used for the normal printed check workflow. This allows the system to connect the selected Bank account being used for payments with the print check format and the Positive Pay Layout..
Menu>Admin/Manager>System Setup>GL Settings>Check Formats
Open the check format>select Positive Pay Layout from dropdown list> SAVE
Sending Positive Pay From the Payments View
The Payments view can be found in Purchasing Today > Views > Payments.
Use the filters and then check the box next to the Payments you want to generate a file for.
To be effective for printing voids, a filter should be added to this listing view for Voided Payment. When set to yes, the listing will be restricted to only those payments which have a corresponding void reversal line.
Payments that are to be included in the flat file should be selected. When selecting the Download Positive Pay File button will prompt for the layout to be used if there is more than one. Otherwise the file is generated immediately.
Example of the outputted File