Nemiqondiso nama. Njengoko sheet fill ixesha (isampuli)

ixesha accounting zayo zokusebenza - amacandelo ebalulekileyo nawuphi na umbutho ukuze esweni imisebenzi yenkampani kunye nabasebenzi ingqeqesho. nama - Ukuze lula le nkqubo, uhlobo elikhethekileyo iye yaphuhliswa. Oko ikhona kokubini iphepha-elektroniki. Kwaye uhlobo ngalunye kujonge izinto zalo ekuhlanganiseni.

Ngubani igcwalisa ngaphandle ikhadi ingxelo

kumbutho ngamnye umisa unoxanduva ukugcina nama, ugxininise nkcukacha lomsebenzi kunye nenani labasebenzi. Ukuba umbutho omncinane yaye wonke umsebenzi owenziweyo kule ofisi, abasebenzi tabeliruet umhloli kubasebenzi, mali okanye omnye umntu ogunyazisiweyo.

Kwimeko apho inkampani iye iziza eziliqela lula abasebenzi tabelirovat ngqo kwiindawo zawo emsebenzini. Kulo mzekelo, olu xanduva kwamagxa inkosi okanye intloko unit okanye umyalelo eyahlukileyo emiselweyo ngokwemvumelwano yengqesho.

I algorithm isebenza ngekhadi ingxelo

Okokuqala kufuneka wazi ukuba yonke ishishini kufuneka nakanjani abe nama zesiqhelo (okt ephepheni). Le fom liprintwe nokuba ngokwazo okanye umyalelo yoshicilelo.

Kukho iintlobo ezimbini ezivunyiweyo: T-12 ne T-13. umahluko wabo ukuba ngowokuqala, ithatha nje kuphela kwi-akhawunti iiyure zomsebenzi, kodwa kukho iigrafu zokubala ngenyanga kumvuzo. Bazele indlela enye, oko kukuthi, ngosuku lokuqala lwenyanga nganye kuvula itafile entsha. Kuyimfuneko ukuba bazalise kwiikholam:

• igama lenkampani ( amaxwebhu okuqala), inani lezibuko kunye nomhla kokugcwaliswa.
• Ixesha apho ikhadi ingxelo ivulwa.
• amanani Uthotho kwabasebenzi kunye data zabo evela amakhadi.

Ezinye iinkcukacha ungeneyo inyanga uzalise inxalenye leyo inxulumene umvuzo, oko ukuba accountant.

Nemiqondiso timesheet

Kuba ukuzaliswa ngokukhawuleza kwaye kulula ixesha sheet sele ziphuhlisiwe kwaye uphunyeziwe yi le notation. Zibonisa lo msebenzi kunye nabanye kunye nezinye bokuqonda. Kukho 36 imiqondiso. Kodwa ngamanye amaxesha, eli nani alanelanga ukuba ukubonisa ngokuchanekileyo zonke iinkcukacha malunga umsebenzi.

Table ingqalelo ezininzi eziqhele ukusetyenziswa nemiqondiso ngexesha sheets. Inkcazelo eneenkcukacha ezininzi kwaye uluhlu olupheleleyo ngokuqhelekileyo akhiwe kwi iphepha lokuqala ungenanto. Oku kwenza kube lula ukuba ukukhangela le notation yaye isigqibo imeko apho kuyo wayifaka esiseleni.

ifomu ukugcwaliswa avareji

Ukugcwalisa amakhadi ingxelo - umsebenzi onzima edinga ukunikwa ingqalelo. Kuyenzeka ukwenza, umzekelo, ukusebenzisa indlela inkangeleko rhoqo kunye nokungabikho emsebenzini.

Kulo mzekelo, i-data angenileyo kwibhokisi nganye. Phawu lubonisa ubukho abasebenzi emsebenzini, kunye nokungabikho echaza izizathu. Kwakhona ibonisa inani leeyure echithwe emsebenzini.

Xa icwecwe lengxelo, ukuba uya kukhangela ngolu hlobo: ubeke ileta "B" ngemini, ngaphantsi 0, ngosuku lokusebenza, ngokulandelelana "Mna" kunye inani leeyure, umzekelo 8. Ngokufanayo veki kwaphawula unobangela ezahlukeneyo non-ukuya emsebenzini, ekuqaleni nasekupheleni kohambo kunye nohambo ukungabikho ngenxa yezizathu ncam.

nama Calculation kulo mzekelo ku tirhisa lula kancinci, kuba onke amanani namagama ziphambi kwamehlo. Oku kusebenza ingakumbi iingcali kunye namava - ngoko baya kuba kungenzeka kancinane ukufumana bedidekile nokwenza iimpazamo.

Gcwalisa ngokuhlakanipha sheet ixesha

Kukho kwakhona indlela lokufumana okuthile. Oku kusetyenziswa xa ixesha of ithuba elilinganayo lonke ixesha. Kulo mzekelo waphawula kwiimeko ezingaqhelekanga, ngamanye ukungabikho, kuphela ixesha, zokuhamba njalo njalo. N. Xa usebenzisa le ndlela nalo ixesha elininzi, yaye isiphumo lokugqibela iyafana kuzo zombini ezi meko.

Kuxwebhu lumi ngolu hlobo lulandelayo: nasengcamangweni top of data ezivunyiweyo kwi lokungabikho kwabasebenzi emisebenzini -, K, OT, HH, PR, B kunye nabanye. Undoqo ihlala ayinanto. Emva kokuba amaxabiso count lokugqibela abayi- azinikezelwanga ukuchitha ixesha, kodwa ihlala kuphela ukwenza iintshukumo elula ngexesha elinye ngosuku: ukubala inani zingabinanto iiseli kumqolo ophezulu (ukuvela) kwaye liphindaphindwe ngenani leeyure.

Le ndlela sifaneleke ngakumbi ukuba abaphathi HR banamava accountants. Kwakhona awunankinga imibutho ezincinane, apho kukho inani elincinane labasebenzi. Ukuba ulawulo wakho ayazi inkqubo ixesha nokuya elula ngakumbi, lixesha ukuba alinikele kubo.

Ukugcina kwimakhishithi ye-akhawunti leeyure zomsebenzi kwi computer

Ukongeza kuguqulelo bephepha, kwaye kukho electronic eziliqela. Njengoko kukhankanyiwe ngasentla, amakhadi ingxelo kufuneka kunyanzeleka ukuba zenze. Oku kwenzelwa ukuqinisekisa ukuba iinkcukacha abasebenzi ukuba basebenze abayi kulahleka kwaye baqinisekisa ukuchana kwayo (musa usoloko ithuba lokusebenzisa ikhompyutha).

Omnye efikelelekayo ngakumbi ukhetho wadala kwiinkqubo Office nama. Excel ilungele le njongo ngokugqibeleleyo. Spreadsheet zikuvumela ukuba ukudala naluphi na uhlobo kunye nobungakanani xwebhu. Kwakhona, enkosi amathuba msebenzi ifomula lula kakhulu, kwaye UPawulos i eliphakathi data count.

Ukusebenzisa software ekhethekile

Ukuba kukho izakhono zaneleyo ngumsebenzi okanye isikhokelo ezinye iinkqubo ezifanayo spreadsheet kungenziwa olukhethiweyo. sheet Ixesha kulo mzekelo kuya kuba ifomu efana iphepha libe LINYE kwaphela. Oku kuya kunceda ekunciphiseni ixesha ukusebenza kunye nolu xwebhu.

Kufuneka kuqatshelwe ukuba inkqubo nganye kubandakanya ukusetyenziswa iinguqulelo mvume. zabathengisi ezahlukeneyo, ngokwendalo, kuba ukuxabiseka kwazo. Umzekelo, inkqubo 'nama' iya kuxabisa abasebenzisi ukususela 1000 engange. nangaphezulu - kuxhomekeka kwinani labasebenzi.

Enye inzuzo izixhobo ezinjalo kukuba awukwazi uzalise nama iphepha. Ifomu onke amanqaku ngokulula uprinte nangawuphi na umzuzu oyifunayo. Lo msebenzi ukuba ezithile kwinkqubo nganye enjalo.

Malunga ukugcinwa amaxwebhu

Kutheni ukusebenzisa ikhadi ingxelo? Oku sisiseko accounting ngenxa yemivuzo kwindawo mali enikwa, kwakunye ubungqina ephambili ukuba umqeshwa lowo kwisiza nako kuthwalelwa phandle imisebenzi yakhe. Ngaphandle kwamathandabuzo, olu xwebhu kubaluleke kakhulu ukuba yonke imibutho.

Ke, njengoko le fomu igcinwe? Nama kufuneka igcinwe, ukuba ibe unyaka. Oku ebekwe ngumthetho kunye nemigaqo ezinjalo kufuneka iqalwe.

Ukuba ulahlekelwa ikhadi lakho ingxelo sele ivaliwe akukho mfuneko ukuba abuze ukuba uphaphazele. Oko kubuyiselwa kusoloko namanye amaxwebhu. Ukulungiselela le njongo, explanatory, ikhefu lokugula, iinkcukacha ukuhamba, ishedyuli iholide kunye nabanye. Zonke engqina kwaye acacise ukungabikho umntu emsebenzini, ingasetyenziselwa recovery data.

Ngubani kusenokufuneka ikhadi ingxelo?

Olu xwebhu afuneka iimvavanyo ezahlukeneyo. Umzekelo, i-ofisi yerhafu sijonga ubukho zombutho kunye ngokuzalisa ngokuchanekileyo.

Ukungabikho wetshati nkqu inkampani lincinane zinokuba sisihlandlo isohlwayo enkulu ngokwaneleyo. Le nto inye eyenzeka kwi Kwingcingane iimpazamo ukugcwalisa iifomu. Oku okwe zombini izibalo kunye gwenxa yeesimboli.

Ukubakho sheets ezifunekayo. Kuba iyimfuneko inkampani (accounting, ukuqeqesha abasebenzi) kwaye ukuhlola nemibutho. Kwaye okona kubalulekileyo - ilungelo ukusebenzisa iisimboli ngexesha sheets. Emva koko kunokusinceda siphephe ezininzi iingxaki kunye nabasebenzi kunye iziphathamandla ezilawulayo.