How to Prepare Employee Payroll Sheet on MS Excel in Amharic

Поделиться
HTML-код
  • Опубликовано: 7 сен 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
    📺 RUclips: • 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
    📺 RUclips: • 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

Комментарии • 108

  • @The_future_is_mine-293
    @The_future_is_mine-293 3 года назад +4

    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 !!!

  • @tseganigussie8560
    @tseganigussie8560 3 года назад +6

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

  • @zerituBelay
    @zerituBelay 2 месяца назад +1

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

  • @ETEXCEL
    @ETEXCEL 3 года назад +8

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

  • @HailegeorgisMaru-o3z
    @HailegeorgisMaru-o3z Месяц назад +1

    I am appreciate for you!

  • @senaitadmasu1612
    @senaitadmasu1612 2 года назад +2

    Fetari yibarkeh yene wendim...

  • @tangutasmamaw4250
    @tangutasmamaw4250 3 года назад +2

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

  • @tezerafalta1979
    @tezerafalta1979 4 года назад +1

    wawu betam yamral betam astemar timret nw tebarek bak

  • @elojiahmevra2221
    @elojiahmevra2221 3 года назад +1

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

  • @yifruteklu2577
    @yifruteklu2577 4 года назад +4

    it is good lecturing....

  • @mihretfetene2254
    @mihretfetene2254 4 года назад +1

    thanks very much you are given for these esential preparing payroll

  • @DesalegnSisay-ud7sn
    @DesalegnSisay-ud7sn 7 месяцев назад +1

    nice

  • @loved4412
    @loved4412 5 месяцев назад +2

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

  • @berhanubadenge3304
    @berhanubadenge3304 3 года назад +1

    wow it is very good continue

  • @ephremtamiru7812
    @ephremtamiru7812 4 года назад +1

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

  • @BelayneshYalew
    @BelayneshYalew 4 месяца назад +1

    thank you so much

  • @tekaligngenebo9418
    @tekaligngenebo9418 3 года назад +1

    Really you Good man God bless you

  • @nargitube9114
    @nargitube9114 4 года назад +1

    Waaw good

  • @girmakebede4288
    @girmakebede4288 3 года назад

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

  • @meronfasil9801
    @meronfasil9801 3 года назад +1

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

  • @eurekatube306
    @eurekatube306 2 года назад +1

    betam enamesegenalen

  • @user-km8hz1vv3g
    @user-km8hz1vv3g 9 месяцев назад

    I 'm very pleasure to meet you

  • @merondemisse
    @merondemisse 10 месяцев назад

    Betam teru new❤

  • @user-km8hz1vv3g
    @user-km8hz1vv3g 9 месяцев назад

    I'm very appretiate you

  • @bayisagemechu5160
    @bayisagemechu5160 Год назад +1

    Thank you!

  • @user-fp5th1hw3j
    @user-fp5th1hw3j 2 года назад +1

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

  • @tsehaywoldgiorgise2995
    @tsehaywoldgiorgise2995 2 года назад +1

    i like it

  • @HilufNega
    @HilufNega Месяц назад

    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.

  • @abimergeya933
    @abimergeya933 3 года назад +1

    Tamerabetalew betam merte new berta

  • @selamawitassefa9124
    @selamawitassefa9124 3 года назад +1

    thank you bro

  • @Jesus-4721
    @Jesus-4721 3 года назад +1

    እናመሰግናለን

  • @muluyemengiebizuayehu2736
    @muluyemengiebizuayehu2736 4 года назад +1

    wow nice !

  • @AmareTibebu-vp2ih
    @AmareTibebu-vp2ih Год назад

    አመሰግናለሁ ጁፒ

  • @storiesoftheheart5745
    @storiesoftheheart5745 3 года назад

    Nice

  • @salamonyibiza8084
    @salamonyibiza8084 3 года назад +1

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

  • @yesewzerabebe4635
    @yesewzerabebe4635 Год назад +3

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

  • @first.boy_112
    @first.boy_112 Год назад

    Thank u

  • @user-rh2qi3pl6s
    @user-rh2qi3pl6s 2 месяца назад +1

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

  • @teslimendris946
    @teslimendris946 2 года назад +1

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

  • @llovenoha
    @llovenoha 2 года назад +3

    11:15 this is where the tutorial actually begins

  • @yhiwotmenged4795
    @yhiwotmenged4795 3 года назад +4

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

  • @abebenegash6800
    @abebenegash6800 Год назад +1

    👍👍

  • @fentabilsefiew9679
    @fentabilsefiew9679 Год назад +1

    thank you go a head!

  • @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

  • @TEgeHailu-ic5jr
    @TEgeHailu-ic5jr 4 месяца назад +1

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

  • @estaos6457
    @estaos6457 3 года назад +2

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

  • @urluvhgdzg
    @urluvhgdzg 3 года назад +2

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

    • @ababahaile1724
      @ababahaile1724 2 года назад

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

  • @misikir20y
    @misikir20y 4 года назад

    tkami tmheret bertalen bro

  • @yousufmohammed7585
    @yousufmohammed7585 2 года назад +1

    i share a ggod things

  • @ipasmlp869
    @ipasmlp869 4 года назад +3

    Please continue the peachtree accounting

  • @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

  • @getneta.6025
    @getneta.6025 3 года назад +1

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

  • @addistsige1135
    @addistsige1135 2 года назад +1

    Betam Tenenshe new Aytayem

  • @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.

  • @MuezMuez-nv9ic
    @MuezMuez-nv9ic 2 месяца назад +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

  • @abebenegash6800
    @abebenegash6800 Год назад +1

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

    • @Jupiter_ttf
      @Jupiter_ttf  Год назад

      i will dear, and thank you for yoour comment

  • @yemaryamworksebsibe6591
    @yemaryamworksebsibe6591 Год назад

    Arif new gin atiften

  • @ethiotoptube9433
    @ethiotoptube9433 2 года назад +1

    arif nw temehertu video quality yelewem

  • @tigisttadesse8918
    @tigisttadesse8918 2 года назад +1

    Ende min honek new ayetayim eko

  • @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

  • @nigstinanigstina632
    @nigstinanigstina632 2 года назад +1

    amount given aserar ibakihn

  • @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

  • @usuuleymaabdallakadir8727
    @usuuleymaabdallakadir8727 2 года назад +1

    On word write bold for eye can't see

  • @maramsol4155
    @maramsol4155 3 года назад +1

    Pension yeserahewe laye tenesh gera gebagn

  • @tisyonadebabaye9033
    @tisyonadebabaye9033 Год назад +1

    enamesgnale ewnet

  • @tivod4483
    @tivod4483 4 года назад +1

    ds yilal enamesegenalen

  • @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 + ....)

  • @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

  • @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

  • @Bizunesh-ou8dw
    @Bizunesh-ou8dw 4 месяца назад +1

    hi Jupiter P.Allowance sint % new mifekedew

    • @Jupiter_ttf
      @Jupiter_ttf  10 дней назад

      Employees side 7% employers side 11%

  • @addisekeleme1713
    @addisekeleme1713 Год назад +1

    Nice job but please don't be fast

  • @abiyotwondemu8440
    @abiyotwondemu8440 2 года назад +1

    600 birre tax ayedrgeme

  • @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

  • @tilahunfentie6412
    @tilahunfentie6412 2 года назад +1

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

    • @Jupiter_ttf
      @Jupiter_ttf  2 года назад

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

  • @semiraabdulwehab1329
    @semiraabdulwehab1329 4 года назад

    btambtam wesagn sew

  • @tilahunfentie6412
    @tilahunfentie6412 2 года назад +1

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

  • @user-yh7ym3cg4c
    @user-yh7ym3cg4c Год назад

    አይታይም ከፍ ቢል

  • @firewbekele1766
    @firewbekele1766 3 года назад +1

    I like it

  • @humanityfirst2700
    @humanityfirst2700 3 года назад +1

    Thank you bro

  • @temesgenmolla5538
    @temesgenmolla5538 3 года назад

    thank you

  • @firehiwotkebede1615
    @firehiwotkebede1615 4 года назад +1

    Nice job but please don't be fast