Excel Specification - Zakat MAINPP

Zakat File Naming Convention

Outgoing Files (To Zakat)

Purpose	File Name Format	Example
Registration Details to Zakat	`Z{STATE}Rddmmyyyy.txt`	ZKLRddmmyyyy.txt, ZSLRddmmyyyy.txt
Payment Details to Pusat Zakat (via Maybank2e.net)	`Z{STATE}Pddmmyyyy.txt`	ZKLPddmmyyyy.txt, ZSLPddmmyyyy.txt

Incoming Files (From Zakat)

Purpose	File Name Format	Example
Registration Status from Zakat	`Z{STATE}Sddmmyyyy.txt`	ZKLSddmmyyyy.txt, ZSLSddmmyyyy.txt

State Codes (2 Characters)

Code	State	Remarks	Code	State
KL	Wilayah Persekutuan KL	Existing	PG	Pulau Pinang
SL	Selangor	Existing	SB	Sabah
NS	Negeri Sembilan	Existing	SR	Sarawak
JH	Johor		TG	Terengganu
KD	Kedah		LB	Labuan
KT	Kelantan		PJ	Putrajaya
ML	Melaka
PH	Pahang
PR	Perak
PL	Perlis

RCMS To Zakat - Registration File

Fixed-width format. If no transaction, produce empty file.

No	Field Name	Data Type	Length	M/O	Bank Remarks	RCMS Remarks
1	Organization name	Alphanumeric	100	M	Mandatory	Provided from front end
2	Address 1	Alphanumeric	100	M	Mandatory	Provided from front end
3	Address 2	Alphanumeric	100	M	Mandatory	Provided from front end
4	Address 3	Alphanumeric	100	M	Mandatory	Provided from front end
5	Address 4	Alphanumeric	100	M	Mandatory for PZS only	Provided from front end
6	Address 5	Alphanumeric	100	M	Mandatory for PZS only	Provided from front end
7	Postcode	Numeric	5	M	Mandatory	Provided from front end
8	Contact Person 1	Alphanumeric	40	M	Mandatory	Provided from front end
9	Phone Number 1	Alphanumeric	15	M	Mandatory	Provided from front end
10	Fax No	Alphanumeric	15	M	Mandatory	Provided from front end
11	Hand Phone Number 1	Alphanumeric	15	O	Optional	Provided from front end
12	Email Address 1	Alphanumeric	50	O	Optional	Provided from front end
13	Contact Person 2	Alphanumeric	40	O	Optional	Provided from front end
14	Phone Number 2	Alphanumeric	15	O	Optional	Provided from front end
15	Hand Phone Number 2	Alphanumeric	15	O	Optional	Provided from front end
16	Email Address 2	Alphanumeric	50	O	Optional	Provided from front end
17	M2e Client code	Alphanumeric	20	O	* 10 for Client Code, 10 for state code (2,8)	Value is required. RCMS Corporate code.
18 v2	Business Registration Number	Alphanumeric	20	O	Optional	Provided from front end

ZAKAT To RCMS - Registration Response File

Response file from Zakat after registration process.

No	Field Name	Data Type	Length	M/O	Bank Remarks	RCMS Remarks
1-17	Same as RCMS To Zakat fields above
18	Returned Status	Alphanumeric	2	O	Status returned by zakat: 00 - Good 99 - Bad	Response from Registration process. 00/99
19 v2.1	Zakat Employer Ref No	Alphanumeric	30	O	Zakat employer ID - returned by zakat if successful/good	Response from Registration process if it's good

RCMS To Zakat - Payment File

Fixed-width format with Header (H) and Detail (D) records.

Header Section

No	Field Name	Data Type	Length	M/O	Bank Remarks	RCMS Remarks
1	Type of Record	Alphanumeric	1	M	Value = `'H'` - Record Header	Value: H
2	Employer's Name	Alphanumeric	100	M	Employer's Name - Left Justify with spaces	Organization name from registration process
3	Month Contribution	Alphanumeric	2	M	The Month's Contribution ie MM - Right Justify with zero	Provided from Front End
4	Year Contribution	Alphanumeric	4	M	The Year's Contribution ie YYYY - The year 4 digit	Provided from Front End
5	Amount	Numeric(15,2)	15	M	The Total Amount of Contribution ie RM 10.50 = `000000000001050`	Provided from Front End
6 v2	Zakat Employer Ref No	Alphanumeric	30	M	Zakat Employer's Ref No	Capture from stats body maintenance
7	CMS Batch Id	Alphanumeric	20	M	Returned by CMS	Batch reference no
8 v2	Business Registration Number	Alphanumeric	20	O	Fill up by Client	Provided from Front End

Content Section (Repeatable)

No	Field Name	Data Type	Length	M/O	Bank Remarks	RCMS Remarks
1	Type of Record	Alphanumeric	1	M	Value = `'D'` - Record Detail	Value: D
2	Old IC No	Alphanumeric	14	O	Employee's Old IC No - Left Justify with spaces	Provided from Front End
3	New IC No	Alphanumeric	14	O	Employee's New IC No - Left Justify with spaces	Provided from Front End
4	Name	Alphanumeric	100	M	Employee's Name - Left Justify with spaces	Provided from Front End
5	Amount	Numeric(15,2)	15	M	Employee's Amount Contribution ie RM 10.50 = `000000000001050`	Provided from Front End
6 v2	Zakat Classification	Alphanumeric	40	M	Zakat Classification: 1 - Zakat Pendapatan 2 - Zakat Harta 3 - Zakat Perniagaan	Provided from Front End

6.1 Zakat File Upload Format

Pipe-delimited (|) format for Maybank2E.net. Used for multiple statutory bodies (SOCSO, EPF, ZAKAT, IRB, ASNB). Only ZAKAT column is relevant here.

HEADER Section (Record Type: 00)

No	Field Name	Description	Type	Length	ZAKAT M/O	Additional Validations
1	Record Type	`'00'` - Message Header If empty - Record type is mandatory If not '00' - Invalid Record Type	N	2	M
2	Product Group	Provider Product Group Name	AN	50	M
3	Statutory body type	To indicate statutory body type: 6 - ZAKAT (Kuala Lumpur) 7 - ZAKAT (Negeri Sembilan) 8 - ZAKAT (Selangor) 9 - ZAKAT (Johor) 10 - ZAKAT (Kedah) 11 - ZAKAT (Melaka) 12 - ZAKAT (Pahang) 13 - ZAKAT (Perak) 14 - ZAKAT (Perlis) 15 - ZAKAT (Pulau Pinang) 16 - ZAKAT (Sabah) 17 - ZAKAT (Sarawak) 18 - ZAKAT (Terengganu) 19 - ZAKAT (Putrajaya) 20 - ZAKAT (Labuan) 21 - ZAKAT (Kelantan) 22 - ZAKAT (Labuan) 23 - ZAKAT (Putrajaya)	N	2	M	If not valid code - Invalid Statutory body type
4	Registration / Payment Indicator	01 - Registration of Employer 02 - Submission of Contribution If empty - mandatory If invalid - Invalid indicator	N	2	M
5	Employer Reference No.	Employer Reference Number If empty - Employer Reference No. is mandatory	AN	30	M/O	For Zakat Registration (01), this field is optional
6	Employer Name	Employer Name If empty - Employer Name is mandatory	AN	50	M
7	Contribution Month and Year	In MMYYYY format If empty - mandatory If invalid - Invalid format	N	6	M/O	For Zakat Registration (01), this field is optional
8	Debiting Account Number	Debiting Account number for transaction If empty - mandatory	AN	20	M/O	For Zakat Registration (01), this field is optional
9	Value date	In DDMMYYYY format If empty - mandatory If invalid format - Invalid value date If past date - Invalid	N	8	M
10	Tax Payment Option	N/A for ZAKAT	N	1	N/A
11	Payment Option	N/A for ZAKAT	X	1	N/A
12	Company State Code	N/A for ZAKAT	N	2	N/A
13	Debit Reference	Debit Reference	AN	55	O	If no value input, default value shall be sent
14	Debit Description	Debit Description	AN	55	O	If no value input, default value shall be sent
15	Credit Reference	Credit Reference	AN	55	O	If no value input, default value shall be sent
16	Credit Description	Credit Description	AN	55	O	If no value input, default value shall be sent
17	Contact Person Name	N/A for ZAKAT	AN	40	N/A
18	Contact Phone Number	N/A for ZAKAT	AN	20	N/A
19	Penalty sequence number	Optional	N	5	O
20	Form F reference no.	N/A for ZAKAT	N	19	N/A
21	Client Batch ID	Client Batch Reference Number	AN	10	O
22	Corporate Code	Corporate Code in which user login with If empty - Corporate Code is mandatory	AN	30	M
23	BRN No	Business Registration Number *Optional Field for Now	AN	20	O	Only applicable to Zakat Payment & Registration
24-63	Filler 3 - Filler 42	Reserved for future use	AN	100 each	O

RECORD Section (Record Type: 01)

No	Field Name	Description	Type	Length	ZAKAT M/O	Additional Validations
1	Record Type	`'01'` - Body If empty - mandatory If not '01' - Invalid	N	2	M
2	Customer Reference Number	Customer Reference Number	AN	30	O
3	Payment Code	N/A for ZAKAT	N	3	N/A
4	Favourite Employee Code	Favourite Employee	AN	5	O
5	Employee Name	Employee Name If empty - mandatory	AN	80	M/O
6	Malaysian	N/A for ZAKAT	AN	1	N/A
7	Country Code	N/A for ZAKAT	AN	2	N/A
8	Employee number / Bill or PRN no	Optional for ZAKAT	N	19	O
9	New ID No.	Employee New ID No (IC Number)	AN	15	M/O
10	Old ID No.	Employee Old ID No	AN	15	M/O
11	Passport No.	Employee Passport No	AN	15	M/O
12	Employee Amount	Zakat Amount Format: 9(13)v9(2) ie RM 10.50 = `000000000001050`	N	15	M/O	For Registration (01), this is optional
13	Employer Amount	N/A for ZAKAT	N	15	N/A
14-20	Various (Wife Code, Staff No, Wages, etc.)	N/A for ZAKAT	-	-	N/A
21	ZAKAT Classification	Zakat classification: 1 - Zakat Pendapatan 2 - Zakat Harta 3 - Zakat Perniagaan 4 - Zakat Simpanan 5 - Zakat Emas 6 - Zakat Saham 7 - Zakat KWSP 8 - Zakat Fitrah	N	1	M/O	For Registration (01), this is optional. Classification is state-dependent.
22	Address 1	Employer Address 1	AN	100	M/O	For Payment (02), this is N/A. For Registration (01), mandatory.
23	Address 2	Employer Address 2	AN	100	M/O	For Payment (02), this is N/A. For Registration (01), mandatory.
24	Address 3	Employer Address 3	AN	100	M/O	For Payment (02), this is N/A. For Registration (01), mandatory.
25	Address 4	Employer Address 4	AN	100	M/O	For Payment (02), this is N/A. For Registration (01), mandatory for some states.
26	Address 5	Employer Address 5	AN	100	M/O	For Payment (02), this is N/A. For Registration (01), mandatory for some states.
27	Postcode	Postcode	N	5	M/O	For Payment (02), this is N/A. For Registration (01), mandatory.
28	Fax Number	Fax Number	N	15	M/O	For Payment (02), this is N/A. For Registration (01), mandatory.
29	Contact Person 1	Contact Person 1	AN	40	M/O	For Payment (02), this is N/A. For Registration (01), mandatory.
30	Phone Number 1	Phone Number 1	AN	15	M/O	For Payment (02), this is N/A. For Registration (01), mandatory.
31	Hand Phone Number 1	Hand Phone Number 1	AN	15	O
32	Email Address 1	Email Address 1	AN	50	O
33-36	Contact Person 2, Phone 2, HP 2, Email 2	Secondary contact details	AN	varies	O
37+	Fillers	Reserved for future use	AN	100 each	O

FOOTER Section (Record Type: 99)

No	Field Name	Description	Type	Length	ZAKAT M/O
1	Record Type	`'99'` - Message Footer If empty - mandatory If not '99' - Invalid	N	2	M
2	Total Employee Amount	Sum of all Employee Amount ie 18,888.30 = `000000000188883` If empty - mandatory	N	15	M/O
3	Total Employer Amount	N/A for ZAKAT	N	15	M
4	Employee Amount Total Record	Sum of record that contains Employee Amount If empty - mandatory	N	7	M
5	Employer Amount Total Record	N/A for ZAKAT Registration	N	7	M/O
6	Total Count	Total number of transaction/record in the batch If empty - mandatory	N	7	M
7	Total Amount	Sum of "Total Employee Amount" and "Total Employer Amount" For ZAKAT = Total Employee Amount	N	15	M
8	Hashing Value	Optional hash value for verification	N	15	O
9-28	Filler 1 - Filler 20	Reserved for future use	AN	100 each	O

Credit Reference for Zakat States Bank Reconciliation

Field	Format	Length	Value	User Input?
Credit Reference	1D1C	20	Default to <ZAKAT Employer Ref No>	Y
Credit Reference		20		N
Credit Description	1D1C	40	<Credit Description>	Y
Credit Description		40	Default to `Maybank2E ZAKAT Payment`	N

Note: Credit Reference defaults to the Zakat Employer Reference Number. Credit Description defaults to "Maybank2E ZAKAT Payment" if not provided by user.

Maybank Zakat File Format Specification

Sheet 2: File Name Format