To download the Sample Cheque Printing File Template follow these steps:
- Log in to iBusiness
- Go to PCM Products >> Services and click on iPrint
- Click on iPrint - Upload on the top
- Click Upload File
- Click Download Template fIle to get the Cheque Printing Template
- You can click the link at the bottom of the page to download the Sample File
To fill the Cheque Printing Template follow these steps:
- This is only applicable for Normal Cheque Stationeries. For Special A4 Size Cheque Stationeries, refer to your respective Client Excellence Officer
- Only the following fields are mandatory for Cheque Printing. The rest of the fields in the template can be left blank.
- The data in the highlighted columns will be printed on the actual cheque stationery.
- The file should be saved as Excel only (.xslx)
Column | Field Name | Data Type | Cell Format | Mandatory/Optional | Max Length | Remarks |
A | Advice Number | Number | Text | Mandatory | 7 | Any reference number for this cheque |
B | Advice Date | Date | Text | Mandatory | 10 | Format: DD/MM/YYYY |
C | NotificationFlag | Number | Text | Mandatory | 5 | Always type the numeric “1” |
D | BeneFullName | String | Text | Mandatory | 50 | |
O | CustomerRef | String | Text | Mandatory | 10 | Any reference number for this cheque |
P | BeneficiaryName | String | Text | Mandatory | 30 | |
R | ChequeDate | Date | Text | Mandatory | 10 | ( DD/MM/YYYY) |
S | Amount | Number | Text | Mandatory | 10 | Amount field should not have comma and only have 2 decimal places. Do not change the data type to numbers or accounting to avoid file rejection. |
AC | Filler1 | String | Text | Optional | 50 | Can type “Account Payee” if required; otherwise. Leave blank. |
Sample File with details: