Monday 30 December 2013

E-PCB DATA

 Source: https://eapps.hasil.gov.my/?&lang=en

INTRODUCTION

e-Data PCB system allows employer to validate and upload CP39 text file through online. It also helps employer submits the data with the format specified by the Inland Revenue Board of Malaysia.
User has to register before using this system. Please call the Inland Revenue Board Call Center at 1-800-88-5436(LHDN) to activate the account.
Attention: This system will store only validated, PASSED and confirmed submission PCB/CP38 data.

FPX PAYMENT

e-Data PCB users can choose to pay their PCB either through online by using FPX Services or at the payment counter of Inland Revenue Board Malaysia at Jalan Duta, KL, Kuching and Kota Kinabalu.
The FPX service is provided by these banks :
 The payment received date is the payment date through FPX.
 The slip bank is an acknowledgement receipt of payment by the employers.

Friday 27 December 2013

[Allowance Formula] More than one IIF Conditions Function

Example:
1)IIF(CATE="SALES",AW*3,...)
2)IIF(CATE="PURCHASE",AW*5,...)
3)IIF(CATE="ADMIN",AW*2,...)


Combine Formula:-

IIF(CATE="SALES",AW*3,IIF(CATE="PURCHASE",AW*5,IIF(CATE="ADMIN",AW*2,0)))