Ungayithola kanjani i-VAT ku-Excel? Umhlahlandlela Ongokoqobo!

Kuwo wonke lo mbhalo sizobe sikhuluma ngawo ungayithola kanjani i-VAT ku-Excel, ngakho-ke ngikumema ukuthi ujoyine nami futhi ufunde ukuthi ungakwenza kanjani ngalolu lwazi olubalulekile.

Ungayithola kanjani i-VAT ku-Excel?

Le software ye-Microsoft Office isetshenziswa emhlabeni wonke namuhla ukwenza imisebenzi ehlukahlukene. Ikakhulukazi bonke labo abahlobene nemininingwane kanye nezibalo zezinombolo. Ngoba lolu hlelo lubandakanya imisebenzi ehlukahlukene kanye namafomula azokunika amandla okwenza yonke le misebenzi.

I-Excel isiphenduke isandla sokudla samabhizinisi amaningi, izinhlangano zezezimali, kanye nezikhungo zemfundo ngenxa yokusebenza kahle kokubala. Ngakho-ke, imisebenzi noma amaphrojekthi afaka ukubalwa kwe-VAT efakwe emikhiqizweni enhlobonhlobo yemikhiqizo kufanele yenziwe njalo.

Ngakho-ke, lolu hlelo lweMicrosoft lukuhlinzeka ngamathuluzi abalulekile ukuqala ukubala izintela ezibekwe yisizwe ngasinye sezwe ngamaphesenti ahlukahlukene ama-athikili nezinsizakalo. Ngakho-ke, ngokulandelayo sizokukhombisa ungayithola kanjani i-VAT ku-Excel. Mayelana nalokhu, landela ngokucophelela le miyalo elandelayo:

Yini i-VAT futhi ithinta kanjani ama-akhawunti wakho we-Excel?

ELatin America, i-VAT noma i-value added tax njengoba yaziwa, noma i-value added tax uma sibheka eSpain, intela engaqondile okumele isetshenziswe ngokuphoqelela ekusetshenzisweni kwezinsizakalo, ukuthengiselana, imikhiqizo nokungeniswa kwempahla. Ngakho-ke, kubhekwa njengentela engaqondile ngokuya ngokusetshenziswa.

Izinga lale ntela lingahluka emazweni ahlukene, kepha inqubo yokuyibala ku-Excel izohlala ifana. Lokho kusho ukuthi, kuthatha iphesenti lokukhuphuka kwentengo ephelele yomkhiqizo ngamunye noma amasevisi atholakalayo. Ngenxa yalokho, uma uthenga okuthile esitolo, ukhokha inani laleyo nto kanye namaphesenti we-VAT engezwe entengo.

Kubalulekile ukuveza ukuthi umuntu othengisa umkhiqizo noma ohlinzeka insizakalo akayigcini iphesenti engezwe enanini lokugcina ngoba kufanele akhokhe uMgcinimafa njalo ezinyangeni ezintathu umehluko phakathi kwentela eqoqwe ngama-invoyisi athunyelwe kumakhasimende awo futhi intela etholakele yama-invoyisi wezindleko ezidingekayo ekuthuthukiseni umsebenzi wawo (okwaziwa njengezindleko ezingadonswa).

Le ntela kumele yaziswe uhulumeni. Ngenxa yalokho, umuntu ngamunye omemezela i-VAT kufanele agcine ibhalansi phakathi kwawo wonke ama-invoyisi awatholayo nalawo awakhiphayo, wonke njengezindleko ezingadonswa.

I-Resumiendo

Lokhu kusho ukuthi i-VAT intela engaqondile esetshenziswa kuzindleko zokukhiqiza nokuthengisa inkampani futhi ayithinti imali engenayo yokugcina efanayo nganoma yisiphi isikhathi. Imali etholakala kule ntela isebenza ukuhlinzeka ngezinsizakusebenza kuMbuso. Kunezinhlobo ezintathu ze-VAT ngokuya ngamaphesenti asetshenziswe entengo yokuthengisa.

Lapho umuntu ezimele noma esebenza kahle futhi enza iphrojekthi yezentengiso, kuzofanele akhiphe ama-invoice futhi, ngenxa yalokho, kuzofanele asebenzise i-VAT emisebenzini yakhe.

Noma kunjalo, izikhathi eziningi, lapho uzama ukubala i-VAT yempahla ethile noma insizakalo ethile, indlela ayicaci ngokuphelele. I-Excel isibe ngelinye lamathuluzi asebenza kahle kakhulu ukwenza izibalo ngokushesha futhi kalula. Kungakho-ke sizokuqondisa kuzinqubo ezibalulekile ukuze ukwazi ukukubala ngalolu hlelo lokusebenza lwe-Microsoft.

Funda ukuthi kanjani thola i-VAT ku-Excel

Kubalulekile ukukwazi ukubala le ntela ku-Excel, ikakhulukazi uma usebenza enkampanini noma enkampanini lapho ulawula khona isabelomali, noma ngabe unikezwe wena njengephrojekthi yaseyunivesithi.

Kubalulekile ukuthi wazi ukuthi i-VAT yintela okufanele wonke amakhasimende ayikhokhe ngesikhathi sokwenza ngakunye kwebhizinisi okugunyaziwe. Ngokwengeziwe, kufanele kuqashelwe ukuthi inani lale ntela liyahluka ezweni ngalinye, iningi linenani elihlukile kunamanye. Ngakho-ke, kufanele ulandele lezi zinyathelo ezilandelayo ukwenza ukubala kusuka ku-Microsoft Excel:

Bala i-VAT ngenani elilodwa

• Isinyathelo sokuqala ukufaka intengo yomkhiqizo noma isevisi kwelinye lamaseli espredishithi.
• Bese, kwesinye iseli, faka inani le-VAT njengephesenti.
• Njengesinyathelo esilandelayo kufanele uphindaphinde amanani amaseli ukunquma inani le-VAT, ngakho-ke kufanele ufake ifomula = B1 * B2 endaweni yomsebenzi. Khumbula ukuthi lawa manani ancike kumaseli owasebenzisayo.
• Ukuze ubale inani eliphelele lentengo yomkhiqizo, engeza intengo yomkhiqizo nenani le-VAT, kulokhu usebenzisa ifomula: = B1 + B3.
• Ngale ndlela, intela yenani lomkhiqizo owodwa inganqunywa kalula futhi kalula.

Okulandelayo, sizokwenza ukubalwa kwemikhiqizo ehlukahlukene:

Kubalwa intela yohlu lwemikhiqizo

Enye indlela yokubala i-VAT ku-Excel, futhi okungenzeka ibe yinto ejwayelekile kakhulu uma usebenzisa uhlelo, ukuyenzela uhlu lwemikhiqizo futhi okudingeka ukubalwa kwe-VAT ngakunye. Ngokuya ngalokhu, sizokukhombisa ukuthi ungakwenza kanjani, udlule kusinyathelo ngasinye esiboniswe ngezansi:

• Ukuze uqhubeke nale ndlela udinga uhlu lwemikhiqizo noma izinsizakalo, njengoba kwethulwe esikrinini. Uzobona-ke, ukuthi lolu hlu luqukethe izinto eziyi-15, futhi ngayinye enenani elabelwe.
• Amagama womkhiqizo avela kukholamu yokuqala, alandelwa amanani awo kukholamu yesibili. Ngemuva kwalokho kufanele ungeze ifomula ukubala i-VAT ngayinye yazo kukholamu yesithathu, okwamanje, inani eliphelele kufanele libalwe kukholamu yesine. Ekugcineni, kukholamu F2, kungabonakala ukuthi i- "VAT rate" ingu-16% kulesi sibonelo.

Ezinye izinyathelo

• Lesi sibalo samaphesenti sizosetshenziswa ekubalweni ngakunye okufanele kwenziwe. Lapha ifomula yokubala inani le-VAT yile: =B2 * $ F $ 2.
• Njengoba umgomo waleli nani kwifomula ukuhlala uhleli lapho ukopisha ifomula phansi, uphawu lwe- $ lusetshenziselwe ukubhekisa kuseli F2. Ngemuva kokufaka lo msebenzi, uzothola umphumela olandelayo.
• Ngemuva kokuthola umphumela wokuqala kukholamu, kopisha ifomula phansi ukuze uthole ukubalwa kwe-VAT kwazo zonke ezinye izinto ezisohlwini. Ukuze wenze lokhu, kufanele uchofoze ekhoneni elingezansi leseli bese ulihudulela kumkhiqizo wokugcina kulayini.
• Ekugcineni, ibala inani eliphelele, kucatshangelwa ukuthi inani eliphelele lilingana nenani lomkhiqizo kanye namaphesenti wentela. Ngenxa yalokho, kulesi simo, kufanele usebenzise ifomula = B2 + C2, futhi ngemuva kokuthola umphumela wokuqala, kufanele ulayishe iseli phansi ukuze uthole amanani asele.

Amafomula ohlelweni asebenzisa izinkomba eziphelele. Lokhu kusho ukuthi uma ushintsha inani le-VAT kuseli F2, uhlelo luzoshintsha ngokuzenzakalela wonke amanani ukubonisa iphesenti elisha. Ufuna ukwazi ungazifaka kanjani izithombe ku-Excel? Chofoza kusixhumanisi esiphiniwe!

Bala inani eliphelele ngaphandle kokubala i-VAT

Kuzinqubo ezedlule, inani eliphelele lanqunywa ngemuva kokubalwa kwe-VAT. Lapha sizokukhombisa ifomula elizokuvumela ukuthi ubale inani eliphelele ngaphandle kokungeza iseli le-VAT, elizokuvumela ukuthi uthole umphumela ngendlela elula kakhulu.

Le fomula isuselwa eqinisweni lokuthi uma inani liphindaphindwe ngamaphesenti angaphezu kwe-100%, amaphesenti amakhulu afakwa kunani langempela. Isibonelo, uma inani le-VAT lingu-10%, inani kufanele libe ngu-110%.

Sinesimo lapho kufanele uphindaphinde inani ngo-116%, ngakho-ke, njengoba kuchaziwe esigabeni esandulele, kufanele sazi ukuthi inani lephesenti le-VAT elizokhuphuka liyi-16%. Njengoba inani lephesenti le-VAT likuseli E2, kufanele usebenzise ifomula elandelayo ukubala inani eliphelele lomkhiqizo ngamunye ohlwini: = B2 * (1 + $ E $ 2).

Njengoba amaphesenti angamanani wedesimali, futhi u-100% alingana no-2, intengo yomkhiqizo kufanele iphindwe ngeyodwa kanye nephesenti eliboniswe kuseli EXNUMX. Ngemuva kokufaka ifomula, uzothola umphumela okhonjisiwe esithombeni.

Uphawu lwe- $ selusetshenzisiwe futhi, kepha kulokhu ukubhekisa kuseli E2, elivumela ukuthi ligcinwe lilungisiwe lapho lisetshenziswa kuwo wonke amaseli ohlwini, njengasesimweni esedlule. Ngemuva kokupheqa phansi, uzobona imiphumela elandelayo.

Lokhu kukuvumela ukuthi uqale ukuthola inani eliphelele lento ngayinye ngendlela elula kakhulu. Imiphumela yaleli thebula ingaqhathaniswa naleyo yenqubo edlule futhi iqinisekise ukuthi inani lokugcina lazo zonke izindatshana liyefana.

Uyikhipha kanjani i-VAT ku-Excel?

Ngizokufundisa ukuthi ungayikhipha kanjani i-VAT enanini lentengo lomkhiqizo ukuze uthole intengo yokuthengiswayo ususe intela. Unenani eliphelele layo yonke imikhiqizo kuseli F1 nenani le-VAT kuseli F2. Singasebenzisa ifomula elandelayo ukubala intengo yomkhiqizo ngaphandle kwe-VAT = B2 / (1 + $ F $ 2).

Njengoba ukwehlukanisa inombolo ngamaphesenti amakhulu kuno-100% sizobe sisusa iphesenti elingaphezu kuka-100%, lokhu kubalwa kulandela ukucabanga okuphindayo kwesibonelo esedlule. Ngenxa yalokho, ukwehlukanisa inani ngo-116% kuzoholela ekwehlisweni kwamaphesenti ayi-16 kulelo nani.

Ifomula engenhla ihlukanisa inani eliphelele lomkhiqizo kuseli B2 ngo-1 kanye nephesenti elishiwo kuseli F2. Uphawu lwe- $ selungeziwe kule nkomba ukuqinisekisa ukuthi ihlala ilungisiwe lapho kukopishwa ifomula phansi.

Uma inani lento litholakele ngaphandle kwentela, i-VAT inganqunywa kusetshenziswa ifomula elandelayo: = C2 * $ F $ 2. Ngale ndlela, inani le-VAT nenani lento litholwe kusuka enanini eliphelele nakwisilinganiso esisetshenzisiwe ekubaleni.

Yini okufanele uyicabangele ngaphambi kokwazi ungayithola kanjani i-VAT ku-Excel?

Ngesikhathi sika ungayithola kanjani i-VAT ku-Excel komkhiqizo noma kwensizakalo, kufanele kubhekwe izinto ezahlukahlukene, enye yazo okuyipesenti ye-VAT okumele ingezwe ezindlekweni zomkhiqizo ngamunye. Ngakolunye uhlangothi, lapho wenza lesi senzo sezibalo ku-Excel, kufanele ukhumbule ukuthi yimaphi amafomula okufanele uwasebenzise nokuthi idatha ngayinye itholakala kuphi kumaseli we-Excel.

Kufanele ukhumbule ukuthi inani lentela kufanele limane lifakwe kunani langempela lomkhiqizo; Isibonelo, uma into ibiza ama-euro angama-100 kanti intela ingama-euro ayi-10, intengo yokugcina yendatshana izoba ngama-euro ayi-110. Njengoba sekushiwo, umthengisi akawugcini umehluko, kepha kufanele awudlulisele ezinhlanganweni zikahulumeni ezibhekele le ntela.

I-VAT emazweni amakhulu akhuluma iSpanishi Iyini iphesenti kulelo nalelo zwe?

Njengoba sekushiwo kule ndatshana, izwe ngalinye linenani lalo le-VAT, eliguquka ngokuya ngemithetho kahulumeni ngayinye. Kodwa-ke, noma ngabe izwe ngalinye lisebenzisa amanani ahlukile, kubalulekile ukukhumbula ukuthi ukubalwa kokulinganisa inani elifanayo kunoma yimuphi umkhiqizo noma insizakalo kwenziwa ngendlela efanayo kuzo zonke izimo.

Leli nani kufanele licatshangwe yiwo wonke umuntu, ngoba ngaso sonke isikhathi uma uthenga kusikhungo esisemthethweni esifaka izikweletu, leli nani selivele lifakiwe kunani lomkhiqizo wabo ngamunye. Ngenxa yalokho, uzogcina ukhokha inani eliphakeme lomkhiqizo. Ngenxa yalokhu okungenhla, ngizokunikeza inani lentela emazweni amakhulu akhuluma iSpanishi:

• I-Uruguay VAT (VAT)% = 22 Yehlisiwe i-VAT% = 10
• I-Argentina VAT (VAT)% = 21 Yehlisiwe i-VAT% = 10.5
• I-Spain VAT (VAT)% = 21 Yehlisiwe i-VAT% = 10 Yehlisiwe i-VAT 2% = 4
• IChile VAT (VAT)% = 19
• I-VAT yaseBrazil (VAT)% = 17-19 Yehlisiwe i-VAT% = 12 Yehlisiwe i-VAT 2% = 7
• IPeru VAT (VAT)% = 18
• IDominican Republic VAT (VAT)% = 18
• I-Mexico VAT (VAT)% = 16
• I-Colombia VAT (VAT)% = 16 Yehlisiwe i-VAT% = 10
• IHonduras VAT (VAT)% = 15
• I-Nicaragua VAT (VAT)% = 15
• IBolivia VAT (VAT)% = 13
• I-El Salvador VAT (VAT)% = 13
• I-Ecuador VAT (VAT)% = 12
• IGuatemala VAT (VAT)% = 12
• IVenezuela VAT (VAT)% = 12 Yehlisiwe i-VAT% = 8
• I-VAT yasePuerto Rico (VAT)% = 11.5
• IParaguay VAT (VAT)% = 10 Yehlisiwe i-VAT% = 5
• IPanama VAT (VAT)% = 7

Siyabonga ngokuvakashelwa. Uma ngabe uyithandile le ndatshana futhi ibithakazelisa futhi isiza, ngikumema ukuthi uphinde usivakashele futhi ufunde indatshana elandelayo ephathelene nayo zonke izingxenye zeZwi.