File Layouts for Import of Payments

Here you can define how the payment import routine interprets external files for important payments.

Creating a new Payment File Layout

Tools > Batch Updates > Batch Load Setup > Templates – Import of Payments

A template for importing cases payments must have a unique code. Enter your new code in the "Code" field.

IMPORTANT: The code should not contain any spaces or characters other than letters or numbers; except a full stop.

Describe the payment import template where indicated. This is what the users will see when selecting the layout to use for a payment import.

Specify which row in the file the data starts. For example, a file may contain column headings in the first row, meaning the payment data commences at row two. In such cases, enter 2.

In some instances it will be necessary to massage the data being loaded. For example, if the file is not a simple column and row type format. In such cases you will need to obtain a quote for an import routine to be created that will allow such files to be interpreted. DebtCol staff will add the import routine program name in the field labeled “Import Routine”.

Each column of data in the import file must be identified. To do this, inside the table, select the column letter from the column labeled “Excel Col” and then identify what it is by selecting from the list labeled “Payment Fields”.

IMPORTANT: Each of the below fields must be identified within the table.
 

When the "debt allocation" is specified in the table and you don't wish to apply any over-payment to the transaction types in the payment allocation rules, tick "no cascading allocation". This will allocate any over-payment to the refund/overpayment transaction type.

Click “Save” to save.

Update an Existing Payment Import Layout

Select the existing layout from the list labeled “Format Types” and the layout will appear.

Make your amendments then click “Save” to save your changes.

Tip: You can copy an existing record by opening the record you wish to copy, then give it a new unique code and click “Save”. A carbon copy will be created with the new code which can be amended as per your requirements.