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