[go: up one dir, main page]

0% found this document useful (0 votes)
108 views52 pages

Note

Here are the steps to backup SQL database: 1. Open SQL Server Management Studio and connect to the database server. 2. In Object Explorer, expand the "Databases" node and right-click on the database you want to backup. 3. Select "Tasks" > "Backup...". 4. In the Backup Database dialog: - Select the database you want to backup from the "Database" dropdown. - Specify a location to save the backup file in the "Backup component" section. - For backup type, select "Full". - Click OK to start the backup. 5. The backup process will run. Once complete, you'll have a full backup file of the

Uploaded by

weekliew
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
108 views52 pages

Note

Here are the steps to backup SQL database: 1. Open SQL Server Management Studio and connect to the database server. 2. In Object Explorer, expand the "Databases" node and right-click on the database you want to backup. 3. Select "Tasks" > "Backup...". 4. In the Backup Database dialog: - Select the database you want to backup from the "Database" dropdown. - Specify a location to save the backup file in the "Backup component" section. - For backup type, select "Full". - Click OK to start the backup. 5. The backup process will run. Once complete, you'll have a full backup file of the

Uploaded by

weekliew
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 52

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

You might also like