How to Prepare Employee Payroll Sheet on MS Excel in Amharic

แชร์
ฝัง
  • เผยแพร่เมื่อ 2 ต.ค. 2024
  • #Subscribe #Like #Comment and #Share
    This video shows you how to prepare on Excel in Amharic
    After watching the tutorial you can prepare a perfect payroll sheet without anyone's help
    MS Excel Part One • How to Use Advanced Ex...
    payroll can refer to the process of actually calculating and distributing wages and taxes.
    Before you can begin to run payroll, you need to collect some information from your employees. Every employee needs to fill out Form W-4. This form will provide you with information about each employee’s federal income tax withholding, along with their name, address, and Social Security number. You need all of this information to properly run and distribute payroll.
    Contact me: @Dubiter
    ----------------------------------------------------------------------------------------------
    #auto_insurance #insurance #car_insurance
    ----------------------------------------------------------------------------------------------
    📌Subscribe To Jupiter Tubeless Tube: • Excel Principles of Ac...
    👌Like, 🗣Share, And 💬Comment
    #lead_generation #gather Knowledge
    -------------------------------------------------------------------------------------------------
    ✅Our Social Media
    📺 TH-cam: • Excel Principles of Ac...
    📩 Telegram: t.me/Dubiter
    🧧 Facebook: / jupitersimeneh
    ----------------------------------------------------------------------------------------------
    📧 Email: Japzgreat2017@gmail.com
    ----------------------------------------------------------------------------------------------
    Thank You!
    ©Copyright 2021
    __________________________________________________________
    Contact me: join.skype.com...
    ----------------------------------------------------------------------------------------------
    #auto_insurance #insurance #car_insurance
    ----------------------------------------------------------------------------------------------
    📌Subscribe To Jupiter Tubeless Tube: • Excel Principles of Ac...
    👌Like, 🗣Share, And 💬Comment
    #lead_generation #gather Knowlesge #Make_birr
    -------------------------------------------------------------------------------------------------
    ✅Our Social Media
    📺 TH-cam: • Excel Principles of Ac...
    📩 Telegram: t.me/Dubiter
    🧧 Facebook: / jupitersimeneh
    ----------------------------------------------------------------------------------------------
    📧 Email: Japzgreat2017@gmail.com
    ----------------------------------------------------------------------------------------------
    Thank You!
    ©Copyright 2021
    __________________________________________________________
    payroll for international employees
    payroll services for 1 employee
    payroll services for one employee
    direct deposit payroll services
    single employee payroll
    best payroll for 1 employee
    payroll one employee
    best payroll service for one employee
    payroll services for independent contractors
    surepayroll workers comp
    payroll for one employee
    employee payroll services
    payroll for self employed
    payroll for 2 employees
    best payroll service for 1 employee
    payroll for 1 employee
    household employee payroll service
    payroll for independent contractors
    quickbooks online self service payroll
    payroll for 1099 employees
    1099 payroll services
    quickbooks self service payroll
    direct deposit for small business
    household payroll service
    pay employees direct deposit
    payroll clocking systems
    household employer payroll
    payroll for contract employees
    workers comp payroll
    self payroll
    quickbooks employee payroll
    household employee payroll
    employee online payroll
    gusto pay contractors
    adp workers comp
    gusto workers comp
    payroll website for employees
    quickbooks pay employees
    paychex workers comp
    employee payroll system
    adp payroll cost per employee
    payroll for remote teams
    payroll for remote employees
    payroll with direct deposit
    inventory management excel formulas
    irr formula excel
    square function in excel
    excel workday function
    irr calculation excel
    workday formula
    fv formula
    importrange google sheets
    google sheet importrange
    count number of cells
    bloomberg excel functions
    google data studio formulas
    excel custom function
    calculate function power bi
    importhtml google sheets
    countif power bi
    excel database functions
    financial functions in excel
    importxml google sheets
    microsoft excel vlookup
    excel count cells
    excel formula cheat sheet

ความคิดเห็น • 111

  • @The_future_is_mine-293
    @The_future_is_mine-293 3 ปีที่แล้ว +5

    God job 👏👏👏keep it in touch till you can to do .we expect more n more educational tutors from you .
    Many thanks for you 🙏🙏🙏
    May God with you !!!

  • @GetanehBualewBualewu
    @GetanehBualewBualewu 2 หลายเดือนก่อน +1

    Selam wendne ye 800 birr alowance tax yemayikoretibet leyetynawum werhawi tekefayi serateyna newu weyis lemengist serateyna bicha newu kelaschigerkuk bitasredayn

  • @TEgeHailu-ic5jr
    @TEgeHailu-ic5jr 5 หลายเดือนก่อน +1

    የባንክ አካውንት ሳስገባ ከጻፈ በኋላ ሌላ ቁጥር ኢያሳየ አስቸገረኝ

  • @martaabaye
    @martaabaye 10 วันที่ผ่านมา +1

    ወንድሜ እጅክ በጣም እናመስግናልን።ስትስራልን በደነብ ሰልማይታይ.በደነብ እንዲታየን አድርግክ ብትስራልን የተሻል ነው

  • @loved4412
    @loved4412 6 หลายเดือนก่อน +2

    Thank you betam ,be peachtree endet payroll endeminseram asayen please 🙏 felge atahut

  • @MuezMuez-nv9ic
    @MuezMuez-nv9ic 3 หลายเดือนก่อน +1

    Selam AdnakihM Teketatayim Negn Kante buzu Temrea Alehu 10Q.1 tiyeakea Alegn Ms Ykirta Liqudition Malet Sher Company Sileyayu Endet new Miseraw Profitachew Weym Loss Kalachew Endeat Ykeflalu

  • @tilahunfentie6412
    @tilahunfentie6412 2 ปีที่แล้ว +1

    It Is not Your Video Ok. Don't Copy From Others' Vedio.......................

    • @Jupiter_ttf
      @Jupiter_ttf  2 ปีที่แล้ว

      አይዞህ ወንድሜ ማበድ ባንተ አልተጀመረም

  • @Bizunesh-ou8dw
    @Bizunesh-ou8dw 5 หลายเดือนก่อน +1

    hi Jupiter P.Allowance sint % new mifekedew

    • @Jupiter_ttf
      @Jupiter_ttf  หลายเดือนก่อน

      Employees side 7% employers side 11%

  • @Alex-k8m1z
    @Alex-k8m1z 7 วันที่ผ่านมา +1

    Gross Salary is the sum of basic salary and all allowances.
    Pension need to ba calculated on basic salary

  • @tseganigussie8560
    @tseganigussie8560 3 ปีที่แล้ว +6

    ሁሉም እንዳንተ ዩ ቲዩብን ለቁም ነገር ቢጠቀመው ጥሩ ነበር ፡፡ የኔ ወንድም በጣም በጣም አመሰግናሁ በዚሁ ቀጥል እ/ሄር ይርዳህ

  • @yhiwotmenged4795
    @yhiwotmenged4795 3 ปีที่แล้ว +4

    በቅድሚያ ላመሰግንህ እወዳለሁ!!!!! በመቀጠል በድርጅቱ የሚከፈለው 11% እዴት እንደሚሰራ ብታሳየን????

  • @ETEXCEL
    @ETEXCEL 3 ปีที่แล้ว +8

    መልካም ስራ ነው፡፡ እርስ በርስ በመማማር ለተሻለ ውጤት እንትጋ፡፡

  • @abebenegash6800
    @abebenegash6800 ปีที่แล้ว +1

    ፒችትሪን በመጠቀም እንዴት የፕሮጀክት ሂሳብ መያዝ እንደሚቻል በትሰራልን ለምሳሌ የውጭ ድርጅቶችን

    • @Jupiter_ttf
      @Jupiter_ttf  ปีที่แล้ว

      i will dear, and thank you for yoour comment

  • @yesewzerabebe4635
    @yesewzerabebe4635 2 ปีที่แล้ว +3

    the tutorial is very good but please update the current laws/proclamations. You are using repealed laws.

  • @Alex-k8m1z
    @Alex-k8m1z 7 วันที่ผ่านมา +1

    Good job

  • @amlakukefyalew6612
    @amlakukefyalew6612 ปีที่แล้ว +1

    በዚህ ቪዲዮ የ8 ሰራተኞችን ደመወዝ አፕሩቭ እና ቸክ ከአደረጉ ባለሙያዎች ጋ በአንድ ፔጅ ነው የተዘጋጀው።ጥያቄዬ አፕሩቭ እና ቸክ ያደረጉ ሀላፊዎችን ስም እና ፊርማ በዬ ገፁ እንዲኖር ምን ማድረግ አለብን

    • @Jupiter_ttf
      @Jupiter_ttf  ปีที่แล้ว +1

      Excel lay header and footer metekem tichilaleh, hulum ga yametalkal

    • @Jupiter_ttf
      @Jupiter_ttf  ปีที่แล้ว +1

      Excel lay header and footer metekem tichilaleh, hulum ga yametalkal

  • @HilufNega
    @HilufNega 2 หลายเดือนก่อน

    what is the difference between gross salary and basic salary?and when we do pension shall we take basic salary/gross salary?why we use gross/basic?anyhow you are a person who can teach whatever you want. cause you are educated.I have lack of words to express my gratitude, but I only say keep it up, and I will follow you. see you.

  • @teslimendris946
    @teslimendris946 2 ปีที่แล้ว +1

    Tankyou 🙏🙏🙏🙏ketlebt financial transaction and bank recounsilation aserar bdeb asredan pleas

  • @senaitadmasu1612
    @senaitadmasu1612 2 ปีที่แล้ว +2

    Fetari yibarkeh yene wendim...

  • @wubshetsintayehu2787
    @wubshetsintayehu2787 ปีที่แล้ว +1

    how to work half day that means one employ it works 20 day only so how it prepare excel formula

    • @Jupiter_ttf
      @Jupiter_ttf  ปีที่แล้ว

      yeken serategna woym per time serategna kehone ezih atakatitewum anyways tiyakeh gilts argligni contact me on telegram for more

  • @urluvhgdzg
    @urluvhgdzg 3 ปีที่แล้ว +2

    Lmndinew you have entered so many function mileng if function b bracket ke zegaw behulaa pls

    • @ababahaile1724
      @ababahaile1724 2 ปีที่แล้ว

      በጣም ደስ ይላል ትምህርቱ ወንድሜ በዝሁ ቀጥልበት ፁፉን ትንሽ ብታደምቅልን ደስ ይለኛል አመሰግናለው

  • @usuuleymaabdallakadir8727
    @usuuleymaabdallakadir8727 2 ปีที่แล้ว +1

    On word write bold for eye can't see

  • @addisekeleme1713
    @addisekeleme1713 ปีที่แล้ว +1

    Nice job but please don't be fast

  • @BizunehGetiye
    @BizunehGetiye ปีที่แล้ว

    አይታይም ከፍ ቢል

  • @zerituBelay
    @zerituBelay 3 หลายเดือนก่อน +1

    ተባረክ ትልቅ ትምርህት ነው የሰጠሄኝ

  • @tangutasmamaw4250
    @tangutasmamaw4250 3 ปีที่แล้ว +2

    ሁሉም ሠዉ እንደዚህ ጥሩ ነገር ይሥራ በርታ

  • @tilahunfentie6412
    @tilahunfentie6412 2 ปีที่แล้ว +1

    ከሰራህ በራስህ አትሰራም፣ ሰው የሰራውን ቪዲዮ ኮፒ አድርገህ የምታቀርብ ደደብ ነህ ሰሂ ዎነዲመ!!!!
    ከየት ኮፒ እንዳደረግህው ላሳይህ እችላለሁ…… ማፈሪያ

    • @Jupiter_ttf
      @Jupiter_ttf  2 ปีที่แล้ว

      Sorry but I consider my haters, my motivators

    • @Jupiter_ttf
      @Jupiter_ttf  2 ปีที่แล้ว

      የTH-cam Algorithm ካንተ የተሻለ በማሰቡ አዝናለሁ

    • @wossenyeleshtilahun8579
      @wossenyeleshtilahun8579 ปีที่แล้ว

      @@Jupiter_ttf

  • @ethiotoptube9433
    @ethiotoptube9433 2 ปีที่แล้ว +1

    arif nw temehertu video quality yelewem

  • @estaos6457
    @estaos6457 3 ปีที่แล้ว +2

    Over time taxable መሆኑን አላውቅም ነበር።ጥሩ ነው

  • @HailegeorgisMaru-o3z
    @HailegeorgisMaru-o3z 2 หลายเดือนก่อน +1

    I am appreciate for you!

  • @llovenoha
    @llovenoha 2 ปีที่แล้ว +3

    11:15 this is where the tutorial actually begins

  • @yifruteklu2577
    @yifruteklu2577 4 ปีที่แล้ว +4

    it is good lecturing....

  • @tigisttadesse8918
    @tigisttadesse8918 2 ปีที่แล้ว +1

    Ende min honek new ayetayim eko

  • @BelayneshYalew
    @BelayneshYalew 5 หลายเดือนก่อน +1

    thank you so much

  • @danieltariku6042
    @danieltariku6042 2 ปีที่แล้ว +1

    Nice work but my question is how can I insert Fidelity in payroll , how can I summarize the payroll sheet and how can I create personal budget??? Can u help me ....?? Plz

  • @አፍረንቀሎ
    @አፍረንቀሎ 2 ปีที่แล้ว +1

    betam amesgnalwe !!! excel alechelem ahune gin lemchale mokeralehu ke zara jemero

  • @nigstinanigstina632
    @nigstinanigstina632 3 ปีที่แล้ว +1

    amount given aserar ibakihn

  • @getneta.6025
    @getneta.6025 3 ปีที่แล้ว +1

    be accounting yetemerke temari bgilu mn lisera yichlal wondime comment adrgene meketer astelagn

  • @hailegizachew8649
    @hailegizachew8649 ปีที่แล้ว +1

    Taxable income ?? Algebagnim

    • @Jupiter_ttf
      @Jupiter_ttf  ปีที่แล้ว

      non taxable income kale example for health, transport .... kale
      Taxable Income= gross salary - non taxable income(transport + health + ....)

  • @tisyonadebabaye9033
    @tisyonadebabaye9033 ปีที่แล้ว +1

    enamesgnale ewnet

  • @addistsige1135
    @addistsige1135 2 ปีที่แล้ว +1

    Betam Tenenshe new Aytayem

  • @abiyotwondemu8440
    @abiyotwondemu8440 2 ปีที่แล้ว +1

    600 birre tax ayedrgeme

  • @salamonyibiza8084
    @salamonyibiza8084 3 ปีที่แล้ว +1

    Thank you your Nice presentation plase add project finance from Advance to interim payment on work executive

  • @yousufmohammed7585
    @yousufmohammed7585 2 ปีที่แล้ว +1

    i share a ggod things

  • @DesalegnSisay-ud7sn
    @DesalegnSisay-ud7sn 8 หลายเดือนก่อน +1

    nice

  • @firehiwotkebede1615
    @firehiwotkebede1615 4 ปีที่แล้ว +1

    Nice job but please don't be fast

  • @abrehamgirma1990
    @abrehamgirma1990 2 ปีที่แล้ว +1

    Is professional allowance deductable?
    what type of allowance not deducted?

    • @Jupiter_ttf
      @Jupiter_ttf  2 ปีที่แล้ว +1

      Any allowance greater than 25% of basic salary must be taxed or not exceed that amount

    • @abrehamgirma1990
      @abrehamgirma1990 2 ปีที่แล้ว

      @@Jupiter_ttf Thanks
      For better clearance, suppose we say that Mr. Abebe gets 10000 basic salary and professional allowance 5000 and posision allowance of 3000. This implies that his gross earning will be 18000 and as the allowances are both mors than 25%, it mean that from the total earning duduction takes place.

    • @Jupiter_ttf
      @Jupiter_ttf  2 ปีที่แล้ว +1

      @@abrehamgirma1990 taxable income = gross salary - non taxable income as u said 18000 gross so non taxable .25 × 5000 + .25 × 3000 = 1250 + 750 = 2000 so 18000 - 2000 = 16000 use this amount for tax

    • @abrehamgirma1990
      @abrehamgirma1990 2 ปีที่แล้ว

      @@Jupiter_ttf Great thanks now becomes clear.

  • @elojiahmevra2221
    @elojiahmevra2221 3 ปีที่แล้ว +1

    Bro Thank you ewunet! betam kelel adergeh new metakrbew! Smart neh! Thanks again!

  • @mihretfetene2254
    @mihretfetene2254 4 ปีที่แล้ว +1

    thanks very much you are given for these esential preparing payroll

  • @tezerafalta1979
    @tezerafalta1979 4 ปีที่แล้ว +1

    wawu betam yamral betam astemar timret nw tebarek bak

  • @seyfusultan930
    @seyfusultan930 ปีที่แล้ว +1

    What about 18%

    • @Jupiter_ttf
      @Jupiter_ttf  ปีที่แล้ว

      11% journalize sinaderg newu yeminasgebawu enji payroll sheet ga anasaferewum, lebelete you contact me telegram

  • @meronfasil9801
    @meronfasil9801 3 ปีที่แล้ว +1

    Thanks 🙏🏼 God bless you 🙏🏼🙏🏼🙏🏼🙏🏼

  • @ephremabera7794
    @ephremabera7794 ปีที่แล้ว

    Basic salary and allowances taxable separately,it is not clear fr me

    • @Jupiter_ttf
      @Jupiter_ttf  ปีที่แล้ว

      Sorry for being late, it is an old one, but now tax is calculated from gross

  • @maramsol4155
    @maramsol4155 3 ปีที่แล้ว +1

    Pension yeserahewe laye tenesh gera gebagn

  • @meazanigatu5115
    @meazanigatu5115 2 ปีที่แล้ว +1

    Over time setesara basic salary badamozahew lek nw mensarawe

    • @Jupiter_ttf
      @Jupiter_ttf  2 ปีที่แล้ว

      yes dear, based on our basic salary

  • @abimergeya933
    @abimergeya933 3 ปีที่แล้ว +1

    Tamerabetalew betam merte new berta

  • @ephremtamiru7812
    @ephremtamiru7812 4 ปีที่แล้ว +1

    You almost solve all of my problem regardness of peachtree and excel, thank u bro

  • @berhanubadenge3304
    @berhanubadenge3304 4 ปีที่แล้ว +1

    wow it is very good continue

  • @bayisagemechu5160
    @bayisagemechu5160 ปีที่แล้ว +1

    Thank you!

  • @tsehaywoldgiorgise2995
    @tsehaywoldgiorgise2995 2 ปีที่แล้ว +1

    i like it

  • @eurekatube306
    @eurekatube306 2 ปีที่แล้ว +1

    betam enamesegenalen

  • @tekaligngenebo9418
    @tekaligngenebo9418 3 ปีที่แล้ว +1

    Really you Good man God bless you

  • @yemaryamworksebsibe6591
    @yemaryamworksebsibe6591 ปีที่แล้ว

    Arif new gin atiften

  • @selamawitassefa9124
    @selamawitassefa9124 3 ปีที่แล้ว +1

    thank you bro

  • @Jesus-4721
    @Jesus-4721 3 ปีที่แล้ว +1

    እናመሰግናለን

  • @firewbekele1766
    @firewbekele1766 3 ปีที่แล้ว +1

    I like it

  • @AmareTibebu-vp2ih
    @AmareTibebu-vp2ih ปีที่แล้ว

    አመሰግናለሁ ጁፒ

  • @TersesWarke
    @TersesWarke 10 หลายเดือนก่อน

    I'm very appretiate you

  • @humanityfirst2700
    @humanityfirst2700 3 ปีที่แล้ว +1

    Thank you bro

  • @tivod4483
    @tivod4483 4 ปีที่แล้ว +1

    ds yilal enamesegenalen

  • @abebenegash6800
    @abebenegash6800 ปีที่แล้ว +1

    👍👍

  • @TersesWarke
    @TersesWarke 10 หลายเดือนก่อน

    I 'm very pleasure to meet you

  • @fentabilsefiew9679
    @fentabilsefiew9679 ปีที่แล้ว +1

    thank you go a head!

    • @Jupiter_ttf
      @Jupiter_ttf  ปีที่แล้ว

      Thank you dear, and i will

  • @ipasmlp869
    @ipasmlp869 4 ปีที่แล้ว +3

    Please continue the peachtree accounting

    • @Jupiter_ttf
      @Jupiter_ttf  4 ปีที่แล้ว

      Ok i will dear ... and thank u dear for ur best comments

    • @qalalahuluqahordofa5304
      @qalalahuluqahordofa5304 2 ปีที่แล้ว

      It is not download what is the Reuther

  • @nargitube9114
    @nargitube9114 4 ปีที่แล้ว +1

    Waaw good

  • @muluyemengiebizuayehu2736
    @muluyemengiebizuayehu2736 4 ปีที่แล้ว +1

    wow nice !

  • @first.boy_112
    @first.boy_112 ปีที่แล้ว

    Thank u

  • @merondemisse
    @merondemisse 11 หลายเดือนก่อน

    Betam teru new❤

  • @jossypetros3509
    @jossypetros3509 2 ปีที่แล้ว +1

    የ286/2002 proclamation ፈልገ ነው ሟጣም ተቸግራያለሁ ወንድም

    • @Jupiter_ttf
      @Jupiter_ttf  2 ปีที่แล้ว

      ok dear i will try my best, as soon as i got it i will send it to your E-Mail

  • @temesgenmolla5538
    @temesgenmolla5538 3 ปีที่แล้ว

    thank you

  • @girmakebede4288
    @girmakebede4288 3 ปีที่แล้ว

    betam des yemil timhirt new wndeme thank you" keep it up on"

  • @storiesoftheheart5745
    @storiesoftheheart5745 4 ปีที่แล้ว

    Nice

  • @misikir20y
    @misikir20y 4 ปีที่แล้ว

    tkami tmheret bertalen bro

  • @semiraabdulwehab1329
    @semiraabdulwehab1329 4 ปีที่แล้ว

    btambtam wesagn sew