工資表-帶計(jì)算公式

1、XXXX公公司司工工資資表表月份：編編號(hào)號(hào)部部門門姓姓名名全全勤勤出出勤勤缺缺勤勤考考核核天天數(shù)數(shù)基基本本工工資資崗崗位位工工資資出出勤勤工工資資考核標(biāo)準(zhǔn)考核得分考考核核工工資資加加班班工工資資補(bǔ)補(bǔ)助助標(biāo)標(biāo)準(zhǔn)準(zhǔn)應(yīng)應(yīng)發(fā)發(fā)補(bǔ)補(bǔ)助助應(yīng)應(yīng)發(fā)發(fā)工工資資扣扣款款項(xiàng)項(xiàng)目目三險(xiǎn)罰款1部門1262512680022001644.231100.0098970.20290.492904.92138.292262512680012001211.54600.0098529.20193.421934.15138.29326224228001000990.00500.00100380.77152.311523.08138.

2、29426262680026001890.001300.001001170.00340.003400.00138.29526268001200600.0096138.2962626800600300.0094138.297部門2262680022001100.0070138.2982626800600300.00100138.2992626800600300.0080138.291026268001600800.0080138.29112626800400200.00805.715.71138.29122626800400200.00100210.82210.82138.29132626800

3、400200.0080108.93108.93138.29142626800400200.0010077.8077.80138.29152626800400200.00100298.35298.35138.29162626800400200.00770.300.30138.291726268001000500.001001826268001000500.0090138.29192626800600300.00100138.29202626800400200.00809.759.75138.29212626800400200.0080138.29222626800400200.0075138.2

4、923262680010050.00100242626800400200.001002526265002626268001200600.00100138.2927262680027001350.0010028262680022001100.00100292626800207.4830262680022001100.001003126268001000500.00100138.293226268001000500.00100138.293326268001000500.00100138.29342626800800400.00100138.293526268001400700.00100138.

5、293626268001400700.00100138.293726268001000500.00100138.29382626800400200.00100138.29392626800600300.00100402626800600300.00100138.29412626800400200.00100138.29422626800800400.00100138.294326268001400700.00984426268001000500.00100138.294526268001200600.00100138.29462626800400200.00100138.29472626800

6、42002100.001004826268001200600.00100492626100030001500.00100207.48502626100035001750.00100207.48512626100040002000.00100207.485226268001000500.00100138.2953262680048002400.0098138.295426268001200600.0099138.295526268001600800.0098138.295626268001400700.0088138.295726268001400700.00100138.29582626800

7、1200600.0088138.295926268001600800.0097138.296026268001200600.0075138.296126268001200600.00100138.296226268001000500.0096138.296326268001000500.00100138.2964262680047002350.0099138.29652626800800400.00996626268001200600.0090138.296726268001000500.001006826268001000500.00100138.2969262680026001300.00

8、98138.297026268001000500.00100712626100040002000.00100722626100040002000.0010073262680044002200.0096138.2974262680032001600.008275262680024001200.0085138.29162262680024001200.009077262680024001200.0010078262680024001200.00100138.2979262680021001050.0097138.2980262680021001050.0097138.298126268001800

9、900.009782262680021001050.009883262680024001200.009084262680021001050.0097138.2985262680021001050.0090138.2986262680021001050.0090138.298726268001520760.001008826268001400700.0090138.298926268001400700.00909026268001520760.001009126268001520760.001009226268001520760.001009326268001520760.00100942626

10、8001520760.001009526268001520760.001009626268001520760.001009726268001520760.001009826268001520760.0010099262680022001100.001001002626100040002000.00100207.48101262680036001800.00100138.2910226268001800900.00100138.2910326268001200600.00100138.291042626800700350.00100138.2910526268001000500.00100106

11、262680021001050.00100138.2910726268001400700.00100138.2910826268001200600.00100138.2910926268001200600.00100138.2911026268001200600.0010011126268001800900.0010011226268001200600.00100138.2911326268001200600.00100138.29114262680021001050.00100138.2911526268001600800.00100138.291162626800550275.001001

12、38.2911726268001400700.001001182626100040002000.00100207.481192626800總總 計(jì)計(jì)96300.00185450.005735.7792725.0011190.003050.17976.22711.6610473.8111478.34各部門費(fèi)用統(tǒng)計(jì)部門15600.005800.002900.00698.00829.74部門2800.001200.00600.00100.00138.29部門31600.004900.002450.00200.00部門414900.0011700.005850.001592.00711.66711.6

13、62074.35部門58800.0010800.005400.001000.001313.80部門64800.008800.005735.774400.00586.003050.17976.229762.15829.74部門715200.0030900.0015450.001825.002212.64部門823600.0062200.0031100.002789.001244.61部門914600.0029250.0014625.001800.002005.25部門104600.0015900.007950.00500.00622.442626100040002000100207.481080

14、096300.00185450.005735.7792725.0011190.003050.17976.22711.6610473.8111478.34各部門費(fèi)用統(tǒng)計(jì)實(shí)實(shí)發(fā)發(fā)工工資資簽簽 名名備備 注注所得稅扣款其他小計(jì)51.66189.952714.97遲到2次138.291795.86遲到1次,年假4天138.291384.79遲到2次，年假0.5天101.17239.463160.54138.29-138.29遲到1次138.29-138.29遲到2次200.00338.29-338.295月發(fā)錯(cuò)貨連帶責(zé)任罰款138.29-138.29138.29-138.29138.29-138.29

15、138.29-132.58年假5天138.2972.53138.29-29.36遲到1次138.29-60.49138.29160.06138.29-137.99遲到1次138.29-138.29400.00538.29-538.295月發(fā)錯(cuò)貨扣款138.29-128.54年假3天138.29-138.29138.29-138.2905.23入職加6月份1483.221621.51-1621.51189.18189.18-189.18XXXX公公司司工工資資表表扣扣款款項(xiàng)項(xiàng)目目207.48-207.48189.18189.18-189.18138.29-138.29138.29-138.291

16、38.29-138.29138.29-138.29138.29-138.29138.29-138.29138.29-138.29138.29-138.29138.29-138.29138.29-138.29138.29-138.29138.29-138.29138.29-138.29138.29276.58-276.58207.48-207.48207.48-207.48207.48-207.48138.29-138.29138.29-138.29138.29-138.29138.29-138.29138.29-138.29138.29-138.29138.29-138.29138.29-13

17、8.29138.29-138.29138.29-138.29138.29-138.29138.29-138.29138.29-138.29138.29-138.29138.29-138.293137.143275.43-3275.43138.29-138.29138.29-138.29162.12162.12-162.12138.29-138.29192.00330.29-330.29138.29-138.29213.18213.18-213.18138.29-138.29138.29-138.29138.29-138.29138.29-138.29144.76144.76-144.76207.48-207.48138.29-138.29138.29-138.29138.29-138.29138.29-138.29138.29138.29-138.29138.29-138.29138.29-138.29138.29-138.29138.29-138.2997.1997.19-97.19144.76144.76-144.76138.29-138.29138.29-138.29138.29-138.29138.29-138.29138.29-138.29289.52289.52-289.52207.