Welcome. In this video you’ll learn about the Truist Fraud Management Digital Treasury Positive Pay/Reverse Positive Pay – Create a Custom Import Map process.
Before we begin the video tutorial, let’s look at an overview of Positive Pay services and the processing times associated. This information can be found in the reference guides for each product as well. This table displays many of the common timing your company will need to be aware of when using this service. Positive Pay – Service Overview and Processing Times are listed.
Now, let’s begin with using Digital Treasury with Positive Pay and using a custom Import Map. Before we start the system portion, you will need to format your Import file. The most common is to use MS Excel CSV (Comma Separated Value) to align your files. Note: Truist will allow for CSV or Fixed Width file types, but for this tutorial, we will focus on the more commonly used CSV, or Comma Separated Value format. In a CSV, delimited file, each record appears on its own line, and the fields are separated by a single character called the delimiter. In a fixed-width file, each record appears on a separate line, and the width of each field remains consistent across records. In other words, the length of the first field of every record might always be 1 character, the length of the second field of every record might always be 13 characters, and so on.
Let’s look at the file formatting fields and how to fill in using a CSV file type. This information can be found in the reference guides for each product as well.
- Account Number Files should contain the full Truist Account Number including any preceding zeros, if applicable. For CSV - Format the column as TEXT
- Serial Number - Format the column as TEXT. * Amount - Format the column as NUMBER- with no commas, $ symbol, or negative characters (i.e., 1123.88)
- Date – for Both Formats- Minimum requirement for date is MMDDYY; other acceptable options are MM/DD/YY; MM/DD/YYYY, etc.
- Payee Name- Must match the Payee Name as it appears on the file, including commas, if applicable. Maximum Character length is 80.
- Issue Void Indicator- Standard indicators are the letter I for Issue or the letter V for Void. Other options are acceptable Fixed Width-Standard character length is 1.
Now, let’s look at the system, we are going to Create an Import Map - CSV Delimited File. · Within the Check Issue Management workspace, you can import check issues/voids file in a client specific format.
Begin from Digital Treasury home page, and navigate to the Administration and Settings tab. Select Import.
From the Import screen, you will now see the option to +Add Import Map. For the next step, an import map matching your unique file format must be created.
After you add an Import Map, you will see new fields displayed:
- Map Type
- Payment Type
- Import As
- Clearing Method.
Starting from left to right, use the Map Type drop-down menu and select Delimited. Note: All required fields will be designated with a red asterisk *.
Next, you will select Payment type.
Using the drop-down menu for Payment, select Import Check Issue/Void. · Result: The File Properties section displays.
In the File Properties section, you will need to provide a Format Name.
- Spaces cannot be used in the name.
- You may use the optional description field if desired.
Next, enter a value in Start Import at Row field.
- If your file has no header and the first record to import is on row 1, enter a value of 1.
- If your file has a header record on the first row, enter a value of 2.
Continuing with File Properties
Use the String Delimiter drop-down menu to choose a String Delimiter or leave it set with the Default of Double Quote (34). ·
- The String Delimiter enables you to send your delimiter as a character in a field without it being treated as a delimiter. For example: “Smith, Betty” enables you to send the comma for the payee’s name rather than removing it from the file.
Next, use the Field Delimiter drop-down menu to select the delimiter being used in your file.
- The character’s numeric value equivalent will display (Comma = 44).
- If your delimiter is not available in the drop-down menu, please review Other Delimiters section. Select Other and key the numeric value into the field. For example, to use a Colon delimiter, enter the value of 44.
The next section is the Data Format Details.
- Date Format: use the drop-down menu to choose the date format in your file.
- Date Separator: use the drop-down menu to select a date separator (such as /) if used in your file.
- Implied Number of Positions: use the drop down to select the number of implied positions for the amount field if a decimal is not being used. For example: if the amount of $123.45 is being sent in the file as 12345, the implied positions is 2. (See the Sample A)
- Decimal Separator: if the amount in your file will include a decimal, put a. in the field. The amount field should not include commas. (See the Sample B) · Issue Indicator: type in the value that will be used for issued items. Standard option - I =Issue
- Void Indicator: type in the value that will be used for voided items. Standard option - V =Void
The next section is the File Map.
In the Active column, select the fields that will be included in the file. All required fields must be selected. ·
Note: All fields with an asterisk * are required for Standard Positive Pay Select Active by each field: Account Number, Check Amount, Issue/Void Date, Issue/Void Indicator, and Serial Number
Payee Name is required if you are participating in Payee Positive Pay Field Number – enter the order that the fields appear in the file Default Value – value to be assigned to each record in the file for that field (See Sample).
Note: For traditional Positive Pay, we recommend including the Payee Name in your file. The name will display to the teller for checks being cashed at a Truist branch that match in check number and amount.
Select Save when complete.
With a successful save, the Import Map Submitted message will display. And as a result, the newly created import map is successful and now added to the Import Map list view.
In the case you are not successful with you Import Map, we will display a few common errors that may be simple to correct.
- File Formatting – such as comma and decimal used in the same file.
- Duplicate Entry • Digital Treasury allows 1 Issue Entry and 1 Void Entry per Serial Number. · Incorrect Import Map • Clients who create their own unique Import Map, should not use the System Map included in Digital Treasury. Note: If you chose initially to program a System Map, which is considered standard for Truist. Use the reference guide available to follow the exact process if using a System Map versus a Custom Import Map.
- Uploading File in Test Mode instead of Production - See the Sample displayed. The status will indicate if the file was imported as a test file, or a live file.
- The test files will indicate test in the status field. Status examples include: Test Rejected/Test Entered. A live file will have status of: Entered/ Rejected
To return as we complete this video tutorial, with a successful save, the Import Map Submitted message will display.
This concludes the Truist Fraud Management Digital Treasury Positive Pay– Create a Custom Import Map process tutorial.
Thank you for watching this tutorial where you learned about Truist Fraud Management Digital Treasury Positive Pay – Create a Custom Import Map process.