Home / Event / INED2017 ver 074 2017.11.13

INED2017 ver 074 2017.11.13

Posted on
Nov
13

13_11_17 12:00 ver 074

 

Salarii->Administrare->Comparatie salarii 2108…2017

 

Parametri pentru calcul:

Brut de la, pentru vechi(2017) si nou(2018)

Brut pana la, pentru vechi(2017) si  nou(2018)

Pas = marirea de salariu brut in ciclul de calcul de la salariul brut… , pana la salariul brut…

Procenta CAAMBP(accidente)

Conditii de Munca N=Normale D=Deosebite S=Speciale

Impozit pe venit Bifat=16(2017), 10(2018) altfel =0 pentru a studia si impozit = zero

NPI Numar Persoane in Intretinere

VTCK Valoare Tichete

 

SalV.DBF(2017)

brutv N(06), ;

casomv N(06), cassomv N(06), somajomv N(06), ;

venitnetv N(06), deduceriv N(06), VTCKv N(06), NPIv N(01), bcimpomv N(06), impozitomv N(06), salnetv N(06), ;

proccasfiv N(5,2), casfiv N(06), cassfiv N(06), somajfiv N(06), CPCIv N(06), friscv N(06), FGSv N(06), cheltv N(06), ;

 

brutN_V N(06) diferenta brutn-brutv

salnetN_V N(06) diferenta salnetn-salnetv

cheltN_V N(06) diferenta cheltn-cheltv

 

SalN.DBF(2018)

brutn N(06), ;

casomn N(06), cassomn N(06), ;

venitnetn N(06), deducerin N(06), VTCKn N(06), NPIn N(01), bcimpomn N(06), impozitomn N(06), salnetn N(06), ;

proccasfin N(5,2), casfin N(06), solidarn N(06), cheltn N(06) ;

 

Deducerile se calculeaza dupa schema:

2017

‘IIF((m.VBL+m.VTCK)<=1500,(IIF(m.NPI<4,300+100*m.NPI,800)),IIF((m.VBL+m.VTCK)>3000,0,CEILING((IIF(m.NPI<4,300+100*m.NPI,800))*(1-((m.VBL+m.VTCK)-1500)/1500)/10)*10))’

 

2018

‘IIF((m.VBL+m.VTCK)<=1950,(IIF(m.NPI<4,510+160*m.NPI,1310)),IIF((m.VBL+m.VTCK)>3600,0,CEILING((IIF(m.NPI<4,510+160*m.NPI,1310))*(1-((m.VBL+m.VTCK)-1800)/1800)/10)*10))’

 

Listari Excel:

 

1) Salariu NET egal

-salv in relatie cu saln dupa salariul net (salnetv=salnetn)

mansalnet17_18rezumat.XLS

mansalnet17_18extins.XLS

mansalnet17.XLS

mansalnet18.XLS

 

2) Salariu BRUT egal

-salv in relatie cu saln dupa salariul brut (brutv=brutn)

manbrut17_18rezumat.XLS

manbrut17_18extins.XLS

manbrut17.XLS

manbrut18.XLS

 

3) Cheltuiala egala

-salv in relatie cu saln dupa cheltuiala (cheltv=cheltn)

manchelt17_18rezumat.XLS

manchelt17_18extins.XLS

manchelt17.XLS

manchelt18.XLS

 

Fisierele DBF si XLS se gasesc in folderul : user local

 

Top