CODE FOR EXPENSES :START WITH 9XX/000
IF DUE DATE ON JUL BUT PAID ON AUG CODE WILL BE 4XX/0XX(BUT WILL KEY IN JUL IN PETTY CASH OR PAYMENT VOUCH
EXP: DESCRIPTION -(NAME - CODE NAME (NO. PLAT ,BILLING PERIOD - INV NO:)
OFFICE REFRESHMENT
买菜,食物用品
STAFF WELFARE
衣服和袜子
UPKEEP OF OFFICE
口罩,贴饭盒,肥皂等,日常用品 , 灭火器,小零件 ,CABLE
租水机CUCKOO(KEY IN RENTAL WATER PURIFIER , RENTAL PERIOD)
PRINTING & STATIONERY
公司文具,文件夹
UPKEEP OF OFFICE EQUIPMENT
修理,耳机 , 手机,床(amount RM 1000以下),CCTV ,冷气机
UPKEEP OF MOTOR VEHICLE(KEY IN NO.PLAT)
修车,轮胎,PUSPAKOM
OFFICE EQUIPMENT
买大型电器(amount RM1000以上)
ENTERTAINMENT
酒和烟
*SEWA VBG 6686 , BORROW CASH , BILL RECORD FOOD 和打包(蓝色单)- NO NEED KEY IN SQL
*PC2211-073 (ANG ) CHANGE TO PC2211-043
*PC2212-060 (CTC) CHANGE TO PC2212-034
(BUT WILL KEY IN JUL IN PETTY CASH OR PAYMENT VOUCHER)
ERIOD - INV NO:)
ROAD & INSURANCE(KEY IN NO. PLAT)
车ROADTAX ,INSURANCE
QUITRENT & ASSESSMENT
门牌税
DAGANG NET FEE
DAGANG NET TECHNOLOGIES SDN BHD
TELEPHONE & FAX CHARGES(MOBILE DATA OR WIFI & KEY IN BILLING PERIOD)
电话费,网费
WATER & ELECTRICTY (BILLING PERIOD)
水,电费
UPKEEP OF MACHINERY
SHUNN SHUNN MACHINERY
PRAYING EXPENSES
拜神物品
asset
就好比这个machine , 公司用这个machine去做生意 这个machine是公司的 然后可以持续用这一个
ACC :PLANT & MACHINERY
包(蓝色单)- NO NEED KEY IN SQL
POSTAGE & COURIER TRAVELLING EXPENSES
POS MALAYSIA BERHAD,CITY-LINK 酒店,搭车
PURCHASE
SING CHONG GAS,BUYING STEEL GAIN ON FOREIGN EXCHANGE
LOSS ON FOREIGN EXCHANGE
SUBCON WAGES USD BANK RECON 因为等值不一样
薪水 看回RECORD
HRDF(HUMAN RESOURCE DEVELOPMENT CORPORATION)
收着员工福利钱的公司
PROVISION FOR TAXATION
给公司的TAX(LEMBAGA HASIL DALAM NEGERI MALAYSIA)
RESIT PENGESAHAN PENERIMAAN BAYARAN 有注明SMACIS METAL SDN BHD
PCB(POTONGAN CUKAI BULANAN)
SISTEM E-PCB
CP39(个人税) CP38(剩下还没有换的税)
ARAHAN POTONGAN SARAAN PEKERJA
然后可以持续用这一个machine带来更多生意
NG EXPENSES
FOREIGN EXCHANGE (等值多了)
FOREIGN EXCHANGE (等值少了)
K RECON 因为等值不一样
OPEN MAINTAIN OPENING BALANCE(KEY IN LOCAL DR AMOUNT OF BANK CLOSING & MAINTAIN ACC & ACC INQUIRY & BA
STEP 1
MAINTAIN ACC
CASH AT BANK AT IN PBB BANK , UOB BANK , AMB BANK , OCBC BANK(MYR) , OCBC BANK(USD)
STEP 2
ACC INQUIRY(为了CHECK 是哪一个BANK)
DATE 看BANK STATEMENT 31JUL'22,就选01/07/22-31/07/22
ACC选310/000 CASH AT BANK
只看DEBIT AMOUNT来对ACC INQUIRY
EXP:TNGO AMOUNT RM4190 在STATEMENT 纸的AMOUNT旁边打勾,然后DOUBLE CLICK 会跳去CASH BOOK ENTRY,
BANK RECON 会跳4190 AMOUNT 出来TICK 就好了
参考DRIVE的 GENEREAL LEDGER & CREDITOR AGING 在MANAGEMENT ACC
CREATE PV
SIA CHIN YIAP
SIA HONG YAP
OPEN MAINTAIN ACC CREATE OTHER CREDITORS
CODE :4S5-001 DESCRIPTION:AMOUNT LOAN TO SIA ……
SMACIS METAL SDN BHD PAYING /LOAN PAYMENT看其他的银行的STATEMENT或其他的银行资料有没有这个
不懂的话放SUSPENSE
EXP:CHAU SENG LONG ADVANCE,CHIA CHIN HUAT
PAY RENTAL
去MAINTAIN ACC EXPENSES CREATE RENTAL OF FACTORY
CREATE PC
TRANSPORT VBG 6886,PAYING SAYUR
TERM LOAN
LOAN PYMT-ATM/EFT
UOB STATEMENT KEY IN TRANS DATE NOT VALUE DATE.
N ACC & ACC INQUIRY & BANK RECON(做完了记得把CASH AT BANK CODE 310-00Y改回去310-000
跳去CASH BOOK ENTRY,改PAYMENT BY:PBB BANK.
资料有没有这个AMOUNT(类似PBB 传钱给OCBC 或其他银行)
1. 开一个Journal reference放ADJ-2023 (这个是暂时的),
credit sales 36000000 和 debit purchase 36000000
2. 放closing stock = 6565000
3. Debtor 跟着pdf改 变少就是开credit note JE reference一样ADJ-2023
(这个也是暂时的 重复了就后面+abc),
变多就是开debit note JE reference一样
4. Creditor 跟着pdf改 变少就是开credit note JE reference一样,
变多就是开debit note JE reference一样
GAIN OR LOSS FOREIGN EXCHANGE
DESCRIPTION :只选一个GAIN FOREIGN EXCHANGE 或 LOSS FOREIGN EXCHANGE
(多rate)
一个月里面的bank charges 只需要create 1 payment voucher enough
rm 0.50 一次过+起来就OK了
SALES INV-SQL CREATE IN SALES - INV (看到unit price , quantiti , item code)
SUPPLIER INV - SQL CREATE IN SUPPLIER - SUPPLIER INV (看到DESCRIPTION & AMOUNT 罢了)
Smacis metal (incomplete document)
AMB statement - Mar'23 & Apr'23 & MAY'23 & JUN'23
Pbb statement - Apr'23 (page 8-11 )
YIR…….(EASTWAY SUPPLIER)
就可能比如銀行收到的5045 其實收到的是5050 只是銀行扣了5塊
這個你要扣5塊在bank charges ,amount + 5块
记得换算USD
adjust去cash account (cash in hand)
以後如果你看到sia ben heng 500塊都是放進去cash in hand就好了
只是給你知道一下 因為那個其實是他的allowance 但是沒有報tax的 所以沒有take in 直接cash adjust
DIRECTOR ACC = AMOUNT LOAN TO SIA HONG YAP OR OTHER DIRECTOR NAME
妳把下面幾個名字在suspense account的都放去
Director account Sia Hong Yap
1. Sia Meng Loo
2. SCF...
3. Foo Kok Fong
CHECK SALES 在LEDGER REPORT 打CODE 500-000
HIT 到85M
*有bank slip的单两个不要拆开
水电单和电话费
key in 的时候留意bank recon 因为有些会累积在一起,假如一月的单没有给但是当做二月的时候出现
CALCULATE
SALARIES ~ EXP:4704.9 + 795.10 =5500
PCB ~ 155.45
EPF ~ 605
SOCSO ~ 24.75
EIS ~ 9.9
PROFESSIONAL FEE = PROFESSIONAL CHARGES (DES:FOLLOW BILL) & DISBURSEMENT (DES:FOLLOW BILL)
GENERAL EXPENSES =REIMBURSEMENT (MISCELLANEOUS OR OTHER FOLLOW BILL) & SST (DES:SST EXPENSES)
**SUPPLIER CODE 如果和行业没有关系的就要放405-000 ,去MAINTAIN ACC-CURRENT LIABILTIES-
除非和行业有关的才是放400-000
SMSD DATE END 30/06/2023
HIGH ART TINT GALLERY ENTERPRISE
因为payment是在7月给但是INV 里有夹着6月的 单
妳的bank recon在year end裡面 就是01.07.2023到30.06.2024 不管你是4月的PV 在5月bank tick
但是account 停在6月 妳不能tick在year end外的時間 6月的PV 不能tick在7月
這個是那個200塊的note
ANSWER: CANCEL PV2306-213 (27/06)
CREATE OTHER CREDITOR 405/000 IN MAINTAIN SUPPLIER
KEY IN SUPPLIER INV INV 2121
KEY IN SUPPLIER PAYMENT PV2307-214
SMSD DATE END 30/06/2023
ASF INDUSTRIAL SUPPLIES
BANK STATEMENT -25/08 (RM5115)
PV2306-214 (RM2670) PAID BY :CASH IN HAND (不要动因为audit了)
PV2307-213 (RM2445) PAID BY :PBB
ANSWER: CREATE NEW PV, 放进钱的日期,acc 放cash in hand
~有收到关于audit之前的文件(比如date end是7月2022-6月2023,但是文件上写着5月2023-7
~有新的loan 也是要说
~paid by cash in hand的payment voucher記得要用PC
~提前问有没有文件要scan
(少rate)
OUNT 罢了)
ake in 直接cash adjust
是当做二月的时候出现double amt那就把一月key的pv delete掉就好。
FOLLOW PCLOUD DOCUMENT IN CLIENT PAYROLL FILE
FOLLOW PCLOUD DOCUMENT IN CLIENT PAYROLL FILE
RATE OF CONTRIBUTION FOLLOW THE WAGES (EMPLOYEE)
RATE OF CONTRIBUTION FOLLOW THE WAGES (EMPLOYEE)
ENT (DES:FOLLOW BILL)
L) & SST (DES:SST EXPENSES)
URRENT LIABILTIES-按NEW -OTHER CREDITORS
PAYMENT 20/07 (RM5274)
PV2306-213
在5月bank tick也沒有關係 PV2307-144
PV2307-210
PV2307-211
6/27/2023
7/20/2023
写着5月2023-7月2023的)bank statement & bank loan 要给kj or sharon
ATTAC DOCUMENT
REQ STATEMENT LETTER MUST ATTAC WITH SMACIS (BORANG 9 AND FORM49 AND IC ) IN PCLOUD
订的时候要打直不要斜的
*EXAMPLE IN SQL ETS METAL JUST FOLLOW N KEY IN
MON/TUE (ETS>SMSB) CREATE INVOIS
~SQL ETS METAL
(SMSB>ETS) CREATE PURCHASE INV
~SQL SMSB
THUR & FRI REMIND KJ INFORM SMSB PAY THE BILL.
PREVIEW>SALES INV SIMPLE(VER.2)>EXPORT TO PDF FILE.
AFTER DONE PDF SEND TO KJ
DOCUMENT NAME IS SALES INV (INV NO)/PURCHASES INV (INV NO)
SQL 旁边三个点,选BACK TO DATABASE GROUP,
选ATLDD01(SQL LINE TO DICKSON 的电脑)
*假如回去我的OFFLINE 就选下面的ACC DATABASE
(BOTH OF THE BILL MUST BE SAME)
O PDF FILE.
CHASES INV (INV NO)
CREATE NEW ACC
*SELECT
OPERATING ACTIVITIES(花费零食水电费等等)
INVESTING ACTIVITIES(投资)
FINANCING ACTIVITIES(借LOAN)
BACKUP SQL
THEN LOG OUT
THIS PC DRIVE
CSC CORP
ACCOUNT
SQL
INSTALLER
最新的v957 OR 还有更新的· (DOUBLE CLICK)
ACCEPT OR SOMETHING YES
一直按NEXT N INSTALL
回去SQL 按YES 就可以了
ID:ADMIN
PW:kt20031011774
right click
send to
compressed (zipped) folder
SUPPLIER INV (PURCHASE)
1. COKE & COAL PRODUCTS (M) SDN. BHD.
JUL'22 , OCT'22 - JUN'23
2. ETS METAL SDN BHD
JUL'22 - AUG'22,OCT'22 - APR'23
3. GEN YAP ENTERPRISE SDN BHD
NOV'22 - APR'23
4. GLOW RECYCLE ENTERPRISE
JUN'23
5. HUP SOON RECYCLE SDN BHD
APR'23 , JUN'23
6. ICB CARBONATE TECHNOLOGIES SDN BHD
JUL'22 , FEB'23 , MAR'23
7. KIAN SENG TYRE & BATTERY SERVICE SDN. BHD.
SEP'22 , APR'23 , JUN'23
8. KT NG ENTERPRISE
JAN'23,MAR'23 - MAY'23
9. SUPSCO STEEL RECYCLE SDN BHD
JUL'22 - SEP'22,NOV'22 - JAN'23,MAR'23 - JUN'23
10. TA CHUAN METAL RECYCLE SDN BHD
JAN'23
11. WNN TECHNOLOGY CENTRE SDN BHD
AUG'22 - MAR'23 , MAY'23 , JUN'23
SUPPLIER INV (OTHER EXPENSES)
1. ALLIANCE JV SERVICES SDN BHD
SEP'22 , MAY'23 , JUN'23
2. BAK GUAN WORKSHOP
FEB'23 , JUN'23
3. BAN LIN TRANSPORT AGNECY SDN. BHD.
MAR'23 - JUN'23
4. BENGKEL KIMPALAN MAWEWLL SDN. BHD.
AUG'22 , APR'23
5. CHUANG NGAI CONSTRUCTION SDN BHD
JUL'22 - JAN'23 , MAR'23 , JUN'23
6. CSC CORPORATE MANAGEMENTT SDN. BHD.
JUL'22 , NOV'22 , DEC'22 , JAN'23 , APR'23 , JUN'23
7. HIGH AUTO CARE
MAY'23 , JUN'23
8. IU IMPRESSIVE RESOURCES (M) SDN BHD
SEP'22 , FEB'23
9. JAGUH PERMAI SDN BHD
JUN'23
10. JPORT TRANSPORT
JUN'23
11. LIAN HUAT MOTOR & ELECTRICAL SERVICES
JUL'22 , AUG'22 , DEC'22 - FEB'23 , APR'23 - JUN'23
12. MA HOE HENG TYRE & BATTERY SDN BHD
DEC'22 , JUN'23
13. MUAR WEIGHING TRADING
JUL'22 , AUG'22 , JAN'23 - MAR'23 , JUN'23
14. SHUNN SHUNN MACHINERY & PARTS SDN. BHD.
APR'23
15. ST AUTO SPARE PARTS TRADING
JUL'22 - DEC'22 , MAR'23 - JUN'23
16. VICTOR TRADING COMPANY
JUN'23
ETS SALES LEGER TO SMACIS PURCHASE LEGER
就好像比如200,000除4.6 就变成43 你就开一个35 就等于开了161,000 然后就是200,000 - 161,000 剩下39,000
SMACIS SALES LEGER TO ETS PURCHASE LEGER
JOURNAL
DATE END 的那一个月 的salary 和其他 单会留在下个月所以要key in journal
exp date end DEC and the bill will postpone key in JAN so should list out all the salary ,epf, socso and other.
EYU HENG THAY - FOR ETS DIRECTOR ONLY IF THEIR REQ CHANGE ACC DIRECTOR IS AMOUNT OWING TO DIRECTOR
SALARY - DIRECTOR'S REMUNERATION
EPF,SOCSO,EIS - DIRECTOR'S EMOLUMENT
ALLOWANCE - DIRECTOR ALLOWANCE
BEFORE THAT CREATE INV AMOUNT MUST MORE THAN PAYMENT .
IF INV AND PAYMENT LESS RM1 BELOW CAN CREATE CN.
WING YING
GAIN OR LOSS FOREIGN EXCHANGE
CREATE JV IN CUSTOMER CREDIT NOTE
1,000 剩下39,000带去下一个用
o and other.
MOUNT OWING TO DIRECTOR
SEND DOCUMENT
去拿白色大信封装文件(在对面的文具桌子有一个盒子装着的)
信封写ATTN: 名字 (client)
H/P : 电话号码(client)
拿city link 的纸袋和长条纸张
(写大力一点,总共有4张COPY第一张撕出来放进蓝色文件夹)写地址,名字,
电话号码,自己的签名和今天日期
*4点之前一定要call
蓝色文件夹里面有citylink电话call 过去然后告诉他acc no(里面·有写最上面),
company 名字 csc carporate management sdn bhd,和自己的名字
等人上来拿文件就拿round chop蓝色ink
REVERSE CHARGE PICK-UP
PRINT UP FROM PDF ON DESKTOP
*可以参考蓝色file 里面
AFTER FILL IN THEN SCAN FORM AND EMAIL TO COURIER(也是在蓝色file里面有写)
EXAMPLE IN EMAIL CAN COPY AND PASTE
*ALSO CAN EMAIL TO CITYLINK IF THE PARCEL BAG ARE ALMOST FINISH
*Grace tan 就去蓝色file里面找有地址号码了。
ID: csccm.00219225
Password: csccm.00219225
LALAMOVE
USE WEBSITE
KEY IN PICK UP AND DROP OFF ADDRESS (ALSO KEY IN NAME & PHONE NO.)
CLICK MOTOR
SELECT WHO PAY
COPY LINK TO AH HUAT
THEN WAIT FOR COLLECT
AND PAY BY TNGO OR CASH WHATEVER
AFTER DELIVERY WILL SEND AN EMAIL ,THEN PRINT OUT(PAY BY RANNIE) AND PUT ON DICKSON DESK
IF jenifer she will collect the document with name of yong wen xuan (ctc chop name)
CLEANER
WHATSAPP TO FARIDAH
提早和他说,通常8:30来
WHATSAPP TO INFORM JASPER
EVERY MONTH
PCLOUD
CASE IN UPDATE
FIND OUT WHICH CLIENT THEN MOVE PICTURE TO FILE(CASE IN UPDATE)
ALSO KEY IN CASE IN UPDATE LISTING
I PDF FILE STAPLER TOGETHER
SET 1 BANK COPY *CHOP CTC(CERTIFIED TRUE COPY) / GOT CSC LETTER HEARD NO NEED CHOP(PUT AT FIRST PG)
OPEN PCLOUD , ANY CLIENT , CLICK SECRETARY,BANK RESOLUTION
*IF FIRST PG GOT BANK LOGO NEED TO OPEN GOOGLE CHROME PRINT OUT (避免print少)ALSO PRINT DOUBLE PAGE
*HLBB APPLICATION JUST PRINT 20-22 3PG ONLY)
*CIMB RESOLUTION ONLY LAST 4 PG.
~AFTER OPEN FILE OF BANK RESOLUTION ALL NEED TO PRINT OUT
(2SET=1SET FOR BANK COPY*NEED CHOP & COSEC COPY*NO NEED CHOP)
~SUPERFORM ARRANGE SECTION 17,14,15,…. PRINT OUT (1SET & STAPLER TOGETHER)
SET 2 COSEC COPY *NO NEED CHOP
~ALREADY PRINT OUT 1 SET AT BANK COPY
~PCLOUD CONSENT CLICK - SEC 201 FORM 48A *旧的公司就不需要print 除非dickson mention是新公
司才print,如果新公司就算几个银行都只print 1set.
~RESOLUTION - APPOINTMENT COSEC *Label COSEC COPY.
SET 3 CLIENT COPY *CHOP CTC
~SUPERFORM -SSM (2SET)
ARRANGE COCES COPY AFTER BANK COPY
STICK NOTE ON ALL DOCUMENT (WRITE DOWN BANK COPY OR COSEC COPY OR CLIENT COPY)
after done put on dickson's desk
YS INNOVATION TECHNOLOGY SDN BHD (BANK COPY ONLY)
NEED TO CHOP DATE
ALL BELOW CTC CHOP ALSO NEED TO CHOP DATE
GOT VIDEO IN DESKTOP
HOP(PUT AT FIRST PG)
TOTAL 2 SET
LSO PRINT DOUBLE PAGE 优先chop 右上角 if 没有字体挡住
有的话才chop 右下角
YONG WEN XUAN IF GOT COMPANY SECRETARY JUST CHOP AT THERE
*一定要chop在线上面
TOTAL 3 SET
(1SET)
TOTAL 2 SET
NOT INCLUDED AVATAR TECH SOMETIMES 3 SET WILL INFORM BY DICKSON
INFORM BY DICKSON
~ IF PRINT 2 SET DOCUMENT NO NEED SEPARATE JUST PIN 2 SAME DOCUMENT TOGEHTHER
同样的才pin一起
GO TO OPEN NEW FILE (ZIP) (看回旧file)
FILE COVER 1: KEY IN COMPANY NAME OR OTHER CAN LOOK BACK TO FILE (DICKSON WILL GIVE IT)
FILE COVER 2: KEY IN COMPANY NAME (粘着FILE旁边)
INSIDE COVER: YELLOW COLOR PAPER PRINT OUT
LIST: PRINT OUT THEN USE 粘纸粘着前后再剪 (像divide) (sx 有多余的在pin的盒子里面)
DEVIDE 只需要这4个隔得,其他的可以不用做先
SSM CORRESPONDENCE,RESOLUTIONS,INCORPRORATION,SEC 58
比较重要其他的可以过后开
example:avatar tech file
的盒子里面)
OPEN EXCEL (TASK)
EVERY MONTH 25TH CAN PREPARE BUT NOT INCLUDE BIDEN 1-5号 20号
GOT INFORMATION IN TASK VAXSON PRO ENTERBIG V
FIRST STEP EDIT MONTH THE PAN
COMPANY: BIG V
EXAMPLE:CLICK PAYROLL,PAYSLIP,2023,OCT,COMPUTATION - OCT2023
DO COMPUTATION EXCEL
*MUST CHECK FOREIGN WORKER WORKING DAY GOT NOTE IN TASK
(2700/26*(WORKING DAY)-GOT EXCEL ATTENDANCE IN PCLOUD)
IF UNPAID 2700/26*24 CAUSE UNPAID 2 DAYS
EMPLOYEE IS 30DAYS/31 DAYS
BASE SALARY: DON’T EDIT
EPF: BASE SALARY X 11%=715
SOCSO: CHECK AT WEBSITE RATE OF CONTRIBUTION(EMPLOYEE) =RM24.75
EIS: CHECK AT WEBSITE RATE OF CONTRIBUTION(EMPLOYEE) =RM9.90
PCB: JADUAL PCB =RM371.65
EPF (EMPLOYER): BASE SALARY X 13%=845
SOCSO (EMPLOYER): CHECK AT WEBSITE RATE OF CONTRIBUTION(EMPLOYEE) =RM86.65
EIS (EMPLOYER): CHECK AT WEBSITE RATE OF CONTRIBUTION(EMPLOYEE) =RM9.90
HRDF (EMPLOYER): JUST FOLLOW NO NEED EDIT
AFTER DONE BECOME PDF CAN CHECK FROM PREVIOS MONTH
ONE BY ONE DO PAYSLIP BECOME KEY IN EXCEL FIRST AFTER CHANGE TO PDF
COPY PASTE FROM PREVIOS MONTH (EXAMPLE EXCEL:PAYSLIP OCT 2023)
EDIT MONTH (IF FOREIGN WOKER JUST EDIT MONTH ONLY)
EPF
SOCSO
EIS
PCB
AFTER DONE BECOME PDF CAN CHECK FROM PREVIOS MONTH
COMPANY : THE PAN ASIA
SAME AS BIG V
COMPANY : Puncak International *AFTER DONE NEED SEND EMAIL TO CLIENT (will inform by dickson)/
open website Sistem e-PCB
click kira pcb/cp38
click kira pcb
below need to key in
tittle:KWSP dan kumpulan wang lain diluluskan
maksimum RM4000 罢了所以1月到5月才key in EMPLOYEE EPF AMOUNT
NO.14 - MAKSIMUM RM 350
KEY IN EMPLOYEE SOCSO + EIS
1. Click name
- find Sosial (PERKESO) and key in 自己出的 SOCSO+EIS (34.65)
~then will appear amount of PCB
~key in the amount into excel (MONTHLY TAX DEDUCTION (PCB))
2. Maklumat Bayaran
~FPX
3. Kemaskini Pegawai Bertanggungjawab
~ 'Director' change to 'Manager'
4. Pengesahan *click kembali first if dickson say can submit then can click simpan
~check amount
5. Output (Bank)
~no need to click
6. Borang CP39
~download the doucument
~log out
~put all the document into file
COMPANY : CANDOR RESOURCES
SAME AS BIG V
COMPANY : SIEW CORPORATE
SAME AS BIG V
SUBMIT PCB AND OTHER DICKSON WILL HANDLE IT
COMPANY : CENTRIGATE SDN BHD
SAME AS BIG V
COMPANY : INFINITY BIDEN INDUSTRIES SDN BHD
SAME AS BIG V
COMPANY : INFINITY BIDEN SDN BHD
EXCEL COMPUTATION NO.4-9 DON’T EDIT
START FROM ANGIE
BASE SALRY : 青色highlight 算1天没有来要扣(GREEN COLOR IN ATTENDANCE MUST DEDUCT 0.5
ALLOWANCE: OPEN ATTENDANCE TO CHECK ALLOWANCE (LOOK STICK NOTE) (蓝色 & 青色highlight
COMMISSION: COMMISION FOLDER
OT: OT FOLDER
ADVANCE: CHECK FROM TASK
EPF: BASIC SALARY *11%
SOCSO: SOCSO WEBSITE
EIS: SOCSO WEBSITE
PCB: Base salary + allowance + commision + OT
+ Incentive/ Target/ Award
看薪水多少然后看第二排
COMPANY : Vaxson
BASE SALARY: FOLLOW WORD EXCEL
EPF: BASE SALARY + INCENTIVE
Payroll
25号 31号
BIDEN PUNCAK ~copy paste rename月份
BIDEN INDUSTRCANDOR
SIEW CORP ENTERPRISE Base Salary
~有缺席就要扣
~Annual/ Sick 算出席
~Unpaid leave 要扣,半天扣0.5
~休息日也要算
EPF
~‘ee 11%
~ ‘er 13%
~Base salary+allowance
~只能up不能down 要整数
~RM0.01 - RM0.99都进位RM1
Socso & EIS
~看Website
~Base salary+allowance+commision+OT+Incentive
PCB
~看Jadual_PCB_2018
~Base salary + allowance + commision + OT
+ Incentive/ Target/ Award
~看薪水多少然后看第二排
Allowance
~A+B
~ A(全勤奖励)
~没有注明要扣就不用扣
~ B (伙食费)
~ Annual leave 要给
~ Unpaid leave/ Sick leave 要扣,半天不扣
~休息日不给
Commision & OT
~ 会给excel key in罢了
nform by dickson)/有什么不懂可以看回上个月的记录
DEDUCT 0.5) (1600/30*28)+150 *edit 红色(多少天有做工)
青色highlight 不算)
EDIT DATE
NAME
YR END
1 BOX & 3 BAGS & ..ENVELOPES 总之里面有多少封就要写
OR OTHER
COLOR PRINT
WILL GIVE IT BACK SO FILLING IN FILE
MAHYR RESOURCES WORKS SDN BHD
3 BOXES & 15 ENVELOPES