You are now leaving our website and entering a third-party website over which we have no control.
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):
-
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.
-
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.
-
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.
-
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.
-
This field is mandatory when payee type is "To Bank"
-
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.
-
The contract type must be C (Contract) or B (Bulletin). If a foreign exchange contract has been booked, completion of this field is mandatory.
-
Contract number must be quoted if contract type is "C".
-
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.
-
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:
-
C= Character Fields: Left Justified, padded with spaces.
-
N= Numeric Fields: Right Justified, padded with spaces or zeros.
-
A carriage return feed and line feed (CRFL) are required at the end of each record.
-
Trailer Record Type must be "T".