Print

Fixed Format Import File Standards

To import successfully, the payment file must conform to TD's file standards.

This import file layout is a TD Bank Proprietary ASCII text file to be used by Fixed Format companies only

Field Name	Start at	Length	Type		Note
Template ID (name)	1	35	Character	Mandatory	1
Payment Amount	36	12	Numeric	Mandatory	2
Payment Currency	48	3	Character	Mandatory
Settlement Account	51	13	Character	Mandatory	3
Payment Due Date	64	10	Character	Mandatory	4
Your Reference	74	35	Character	Optional/ Mandatory	5
TD Instructions	109	70	Character	Optional	6
Beneficiary Instructions	179	70	Character	Optional	6
Contract Type	249	1	Character	Mandatory	7
Contract Number	250	7	Numeric	Optional/ Mandatory	8
Exchange Rate	257	8	Numeric	Optional/ Mandatory	9
Reason for Payment	265	70	Character	Optional	10

The following characters are not permitted:!'~@#$%^&*[];<>"|,`/-?:().+

Notes (includes edit rules):

1. Customer enters Fixed Template ID which already exists in Wire Payment profile. Payment should be rejected from import if Template ID does not exist. NOTE: TD Bank will populate the sender's name and address with the name and address on file at TD for the settlement account entered. Sender name and address stored in the fixed template will no longer be used. Please review this information on the review payment details page.
2. Payment amount must be in the format '999999999.99'. Please note that the Wire Payment Product will only accept payments with an equivalent value up to and including CAD$999,999,999.99 if being settled through a CAD account or USD$999,999,999.99 if being settled through a USD account or FOR 999,999,999.99 if being settled through a Foreign currency account. Please also note that payments in Japanese Yen must be entered with a '.00' at the end. For example, a payment in Japanese Yen of 315555 should be entered as 315555.00.
3. A settlement account must exist in the Wire Payments profile. When entering the settlement account, use the format of the account displayed in the WP customer profile. For example, a TD Deposit Account number (CAD/USD) will be entered as a 12-digit number such as 010230123456 (branch with account number). A TD Deposit Account (Foreign) will be entered as a 12-digit number such as 010203456789. Other TD Accounts will be entered as a 13-digit number such as 0360012345678. The length of the field is 13 characters, so padding may be required. If the 'Payment Currency' on the template is in CAD then the settlement account must be CAD or else the payment will be rejected.
4. Due Date must be in the format of 'MM/DD/YYYY'. Due date must not be < today or > than 45 days in the future. Due date must not fall on a weekend.
5. This field is mandatory when payee type is "To Bank"
6. The TD Instructions Field is used for instructions to Global Business Services. The Beneficiary Instructions field can be used to advise your beneficiary of information regarding the wire payment. During the fixed format import, any Instructions (to either TD or the Beneficiary) entered in the import file will overwrite Instructions saved in the fixed template. If no Instructions are entered in the import file, then any Instructions present in the fixed template will be used in the wire payment.
7. The contract type must be C (Contract) or B (Bulletin). If a foreign exchange contract has been booked, completion of this field is mandatory.
8. Contract number must be quoted if contract type is "C".
9. In the case where the settlement currency is not the same as the payment currency and a foreign exchange contract has been booked, completion of this field is mandatory. When a foreign exchange rate has been booked, the exchange rate must be entered in the format '9.999999' and cannot be zero. If a foreign exchange contract is not necessary, this field can either be padded with blanks or zeros.
10. Reason for Payment - Please include a reason for sending this payment - for Payment to Customer only. Include as much detail as possible; this will expedite your payment. During the fixed format import, any reason for payment entered in the import file will overwrite reason for payment saved in the fixed template. If no reason for payment is entered in the import file, then any reason for payment present in the fixed template will be used in the wire payment.

Import File Standards - Trailer Record

Field Name	Start at	Length	Type	Description
Trailer Identifier	1	1	C	Mandatory Value: "T"
Total Number of Payments	2	3	N	Mandatory Format: 999

Notes:

1. C= Character Fields: Left Justified, padded with spaces.
2. N= Numeric Fields: Right Justified, padded with spaces or zeros.
3. A carriage return feed and line feed (CRFL) are required at the end of each record.
4. Trailer Record Type must be "T".