Itemplate ye-Excel yolawulo lohlahlo lwabiwo-mali: Isifanekiso seNkcazo yeMali

Uhlahlo lwabiwo-mali imele ubume bemali benkampani kulo nyaka-mali, inkampani nganye inokuzoba isishwankathelo semeko yayo yezemali kolu xwebhu.

I-Excel spreadsheet ilandelayo ibonelela ngethemplethi yohlahlo lwabiwo-mali enokuba luncedo kwi-accounting yamashishini amancinci.

Imimandla ekwiiseli ze-tan ze-spreadsheet ishiywe ingenanto ukuze ikuvumele ukuba ufake i-asethi yakho kunye nedatha yetyala, kwaye unokutshintsha iilebhile zale miqolo ukubonisa iindidi ze-asethi/ityala. Ungaphinda ufake imiqolo eyongezelelweyo kwithempleyithi yebhajethi, kodwa ukuba wenza njalo, uya kufuna ukujonga iifomyula (kwiiseli ezingwevu), ukuqinisekisa ukuba zibandakanya amanani ayo nayiphi na imigca emitsha.

Ithemplethi iyahambelana ne-Excel 2010 kunye neenguqulelo zamva.

Ukukhuphela imodeli cofa qui

Imisebenzi esetyenziswe kwimodeli yimali kunye nabaqhubi be-arithmetic:

• Isishwankathelo: Isetyenziselwa ukubala iitotali zodidi ngalunye lwengeniso okanye iindleko;
• Abaqhubi be-arithmetic: Abaqhubi bokudibanisa kunye nokuthabatha basetyenziselwa ukubala i-asethi iyonke, amatyala ewonke, kunye nomahluko phakathi kwala maxabiso mabini (= itotali ye-net yexabiso).

BlogInnovazione.it