Skip to main content

Custom Template Types for New Uploads

List of available Custom Template types and their required fields.

Written by Beverley McAllister

The following custom template types are available in the drop down list when using the Template Library.


Migrate Customers

The mandatory fields required in the Selected Columns are:

  • Title

  • First Name

  • Surname

  • Post Code

  • Address Line 1

  • Account Holder Name

  • Bank Sort Code

  • Custom Direct Debit Reference

  • Direct Debit Start Date

  • At the End Behaviour

  • Direct Debit End Type

  • Direct Debit End Date

  • Number of Debits

  • Amount

  • Every

You may add the following fields from the Available Columns to customise the template:

  • Company Name

  • Initials

  • Date of Birth

  • Address Line 2

  • Address Line 3

  • Email

  • Mobile Phone Number

  • Customer Reference

  • First Amount

  • Additional First Amount

  • Final Amount

  • Additional Reference

  • Schedule Name

  • Frequency Name

  • Home Phone Number


New Credit Payments

The mandatory fields required in the Selected Columns are:

  • Amount Date

  • Date

You may add the following fields from the Available Columns to customise the template:

  • Comment

  • Direct Debit Reference

  • Additional Reference

  • Customer Reference


New Customers Ad Hoc

The mandatory fields required in the Selected Columns are:

  • First Name

  • Surname

  • Post Code

  • Address Line 1

  • Account Holder Name

  • Account Number

  • Bank Sort Code

  • Direct Debit Start Date

You may add the following fields from the Available Columns to customise the template:

  • Title

  • Customer Reference

  • Date of Birth

  • Company Name

  • Email

  • Home Phone Number

  • Mobile Phone Number

  • Address Line 2

  • Address Line 3

  • Address Line 4

  • Initials

  • Direct Debit Reference Suffix

  • Additional Reference

  • Custom Direct Debit Reference

  • Schedule Name

  • Frequency Name


New Customers All Fields

The mandatory fields required in the Selected Columns are:

  • First Name

  • Surname

  • Post Code

  • Address Line 1

  • Account Holder Name

  • Account Name

  • Bank Sort Code

  • Direct Debit Start Date

  • Direct Debit End Type

  • At the End Behaviour

  • Direct Debit End Date

  • Number of Debits

  • Amount

  • Every

You may add the following fields from the Available Columns to customise the template:

  • Title

  • Company Name

  • Initials

  • Date of Birth

  • Address Line 2

  • Address Line 3

  • Address Line 4

  • Email

  • Home Phone Number

  • Mobile Phone Number

  • Customer Reference

  • Payment Month in Year

  • Payment Day in Month

  • Payment Day in Week

  • First Amount

  • Additional First Amount

  • Final Amount

  • Direct Debit Reference Suffix

  • Custom Direct Debit Reference

  • Additional Reference

  • Schedule Name

  • Frequency Name


New Customers End on Exact Date

The mandatory fields required in the Selected Columns are:

  • First Name

  • Surname

  • Post Code

  • Address Line 1

  • Account Holder Name

  • Account Number

  • Bank Sort Code

  • Direct Debit Start Date

  • Amount

  • Every

  • Direct Debit End Date

You may add the following fields from the Available Columns to customise the template:

  • Title

  • Company Name

  • Initials

  • Date of Birth

  • Email

  • Address Line 2

  • Address Line 3

  • Address Line 4

  • Home Phone Number

  • Mobile Phone Number

  • Customer Reference

  • First Amount

  • Additional First Amount

  • Final Amount

  • Direct Debit Reference Suffix

  • Custom Direct Debit Reference

  • Additional Reference

  • Schedule Name

  • Frequency Name


New Customer Number of Debits

The mandatory fields required in the Selected Columns are:

  • First Name

  • Surname

  • Post Code

  • Address Line 1

  • Account Holder Name

  • Account Number

  • Bank Sort Code

  • Direct Debit Start Date

  • Amount

  • Every

  • Number of Debits

You may add the following fields from the Available Columns to customise the template:

  • Title

  • Company Name

  • Initials

  • Date of Birth

  • Email

  • Address Line 2

  • Address Line 3

  • Address Line 4

  • Home Phone Number

  • Mobile Phone Number

  • Customer Reference

  • First Amount

  • Additional First Amounts

  • Final Amount

  • Direct Debit Reference Suffix

  • Custom Direct Debit Reference

  • Additional Reference

  • Schedule Name

  • Frequency Name


New Customer Rolling

The mandatory fields required in the Selected Columns are:

  • First Name

  • Surname

  • Post Code

  • Address Line 1

  • Account Holder Name

  • Account Number

  • Bank Sort Code

  • Direct Debit Start Date

  • Amount

  • Every

You may add the following fields from the Available Columns to customise the template:

  • Title

  • Customer Reference

  • Date of Birth

  • Company Name

  • Email

  • Home Phone Number

  • Mobile Phone Number

  • Address Line 2

  • Address Line 3

  • Address Line 4

  • Initials

  • Direct Debit Reference Suffix

  • Additional Reference

  • Custom Direct Debit Reference

  • First Amount

  • Additional First Amounts

  • Final Amount

  • Schedule Name

  • Frequency Name


New Debit Payments

The mandatory fields required in the Selected Columns are:

  • Amount

  • Date

You may add the following fields from the Available Columns to customise the template:

  • Comment

  • Direct Debit Reference

  • Additional Reference

  • Customer Reference


New Patches

The mandatory fields required in the Selected Columns are:

  • From

  • To

  • Type

  • Comment

  • Amount

You may add the following fields from the Available Columns to customise the template:

  • Direct Debit Reference

  • Customer Reference


New Payments All

The mandatory fields required in the Selected Columns are:

  • Amount

  • Date

  • IsCredit

You may add the following fields from the Available Columns to customise the template:

  • Comment

  • Direct Debit Reference

  • Additional Reference

  • Customer Reference


New Pulse Payers

The mandatory fields required in the Selected Columns are:

  • Custom Direct Debit Reference

  • Account Holder Name

  • Bank Sort Code

  • Account Number

  • First Name

  • Surname

You may add the following fields from the Available Columns to customise the template:

  • Title

  • Company Name

  • Address Line 1

  • Address Line 2

  • Address Line 3

  • Post Code

  • Email

  • Frequency Name

  • StartYear

  • StartMonth

  • StartDay

  • EndYear

  • EndMonth

  • EndDay

  • Every

Once you have created, downloaded, and completed your custom file, you can upload it in the usual way.

Did this answer your question?