Indlela yokwakha i-mini ERP ku-Excel isinyathelo ngesinyathelo

Uma unebhizinisi elincane noma uqala iphrojekthi futhi ubhekene nobunzima inyanga ngayinye ngama-spreadsheet e-Excel axegayo, ama-akhawunti angalingani, kanye nedatha ehlakazekile, ukusetha i- I-mini ERP ku-Excel ingaba yilokho kanye okudingayo.Akudingeki uchithe imali eningi kusofthiwe eyinkimbinkimbi ukuze uqale ukulawula ukuthengisa, izindleko, amakhasimende, isitoko, kanye nezinkokhelo nge-oda elithile kanye nombono womhlaba wonke.

Umqondo uwukwakha uhlelo olulula kodwa oluklanywe kahle ngaphakathi kwe-Excel (o -Google AmaSpredishithi) ahlanganisa ulwazi olubalulekile futhi akuvumela ukuthi uqhathanise isabelomali nemiphumela yangempela, ubuyekeze izinkomba eziyisisekelo, futhi wenze izinqumo njalo ngeviki, ngaphandle kokulinda izinsuku eziyi-10 noma eziyi-15 ukuze kuqedwe ukubalwa kwezimali. Ngezansi uzobona ukuthi ungakusetha kanjani, yimaphi amathebula namashidi owadingayo, yiziphi izindlela ezinhle kakhulu okufanele uzilandele, nokuthi ungakuyisa kanjani ezingeni eliseduze nobungcweti usebenzisa amathuluzi afana ne-Power Query namafomu abasebenzisi.

Iyini i-mini ERP ku-Excel futhi isetshenziselwani?

Uma sikhuluma nge-mini ERP ku-Excel, sibhekisela ku- incwadi yokusebenza ehlelekile ehlanganisa izinqubo zokuphatha eziyisisekelo ndawonyeKuhlanganisa ukuthengisa, ukuthenga, isitokwe, i-treasury, imigomo yokuthengisa, ukulandelwa kwama-akhawunti atholakalayo, kanye nedeshibhodi encane. Akuyona i-ERP ephelele njengaleyo esetshenziswa izinkampani ezinkulu, kodwa uhlelo olususa isidingo samafayela amaningi akhululekile futhi olukuphoqa ukuthi usebenze nge-data logic.

Inhloso enkulu ukuthi nciphisa umsebenzi ophindaphindayo kanye nolwazi lokuxhuma oluvame ukuhlakazekaAma-invoyisi endaweni eyodwa, uhlu lwamakhasimende kwenye, isitoko kwenye, ama-akhawunti asebhange kwenye, njll. Ngefayela elilodwa, noma ngama-ledger amaningana axhumene kahle, ungakha imibiko ezenzakalelayo, uthole ukuphambuka, futhi usabele ngesikhathi uma ukuthengisa kuhamba kancane, uma amakhasimende athile eqoqa izikweletu eziningi kakhulu, noma uma uphelelwa isitoko somkhiqizo obalulekile.

Lolu hlobo lwesisombululo lufanelana kahle kakhulu Ama-SME namabhizinisi amancane adinga ukuhleleka kodwa angakwazi ukukhokhela uhlelo olukhulu lwe-ERP noma labo abafuna ukuqinisekisa izinqubo zabo ngaphambi kokuthatha isinyathelo. Kuwusizo kakhulu nakosomabhizinisi abafuna ukuqonda, ngendlela ebonakala kakhulu, ukuthi imali ihamba kanjani kuphrojekthi yabo: imali engenayo, izindleko eziqondile, izindleko ezihleliwe, imajini, kanye nokugeleza kwemali.

Ngaphambi kokuvula i-Excel: uzolinganisa ini futhi uzosebenzisa yiphi indlela?

Into yokuqala akukhona ukudala amaspredishithi noma amafomula, kodwa nquma ukuthi yiziphi izinkomba ozozilandela nokuthi kangakiUma uzama ukulawula yonke into kusukela ngosuku lokuqala, uzogcina ukhathele futhi ushiye ithuluzi. Kungcono ukuqala ngama-KPI ambalwa akhethwe kahle ahambisana nesabelomali sakho.

Ezinye izinkomba eziyisisekelo ezisebenzayo kakhulu ze-mini ERP yilezi: ukuthengisa (amayunithi kanye nenani), inani lamathikithi noma ama-oda, amahora okukhiqiza, izindleko eziqondile ezibalulekile (izinto zokusetshenziswa, amahora abasebenzi aqondile, ukukhangisa kwansuku zonke noma kwamasonto onke) kanye nokwehlukaniswa okucacile phakathi kwezindleko eziguquguqukayo nezingaguquki. Njengoba ujwayelana kakhulu nohlelo, ungangeza ubukhulu obengeziwe, njengezigaba zomkhiqizo, iziteshi zokuthengisa, noma imingcele ngomkhiqizo ngamunye.

Ku-KPI ngayinye ozoyilandela, chaza ngokucacile izinga lemininingwane (nsuku zonke, masonto onke, noma nyanga zonke), iyunithi yokulinganisa, nokuthi ubani onesibopho sokufaka idathaIsibonelo, ungase ufune ukubona ukuthengisa ngosuku, amahora okukhiqiza ngesonto, kanye nezindleko ezihleliwe ngenyanga. Into ebalulekile ukungahlanganisi amazinga nokuthi umuntu ofaka idatha azi kahle ukuthi kufanele ayifake kuphi, nini futhi nini.

Ngaphezu kwalokho, kubalulekile ukuvumelana kusukela ekuqaleni ku- inqubo yokubamba idathaIsikhathi esithile usuku noma isonto ngalinye sinikezelwe ekurekhodeni ukuthengiswa kwe-POS, izinkokhelo zasebhange, ama-invoyisi akhishwe, kanye nezindleko. Isibonelo, ekupheleni kosuku ngalunye lokuthengisa nokukhiqiza, kanye ngoMsombuluko ekuseni ukurekhoda ukuthengiselana kwebhange kwesonto eledlule. Ngaphandle kwalesi sifundo, uhlelo lwe-mini ERP lubukeka luhle kodwa empeleni alusebenzi.

Isakhiwo sefayela esiyisisekelo: isabelomali kanye neqiniso

Indlela eqinile nelula yokusetha uhlelo lwakho ukuhlukanisa ngokucacile ulwazi lwesabelomali oluvela olwazini lwangempelaNgale ndlela ungaqhathanisa kalula lokho obekuhlela ukukwenza nalokho okwenzekile ngempela bese uhlaziya ukuphambuka usebenzisa izindlela ezithile.

Ngakolunye uhlangothi, dala ishidi noma ifayela elingelakho isisekelo sesabelomaliNgokuvamile kuba ithebula elinamakholomu afana nalawa: usuku noma isonto, umqondo/i-akhawunti/i-KPI, inani elibhajethiwe, futhi, uma unesithakazelo semininingwane eyengeziwe, ukuhlukaniswa okuthile ngohlobo lwezindleko noma imali engenayo. Ungaqala ngethempulethi "yesabelomali vs. yangempela" yamasonto onke bese uyandisa ngezigaba zakho.

Ngakolunye uhlangothi, klama isisekelo se- ukusebenza kwangempelaLapha, umugqa ngamunye umelela umcimbi othize: ukuthengisa, izindleko, ukuthenga, ukukhiqizwa, inkokhelo, njll. Amakholomu ajwayelekile angafaka: usuku, uhlobo lokuthengiselana (ukuthengisa, izindleko, ukuthenga), incazelo noma i-akhawunti, inani, ikhasimende noma umhlinzeki, umkhiqizo, indlela yokukhokha, njll. Kamuva, ungasebenzisa leli thebula njengomthombo wamathebula e-pivot noma imibuzo ye-Power Query ehlanganiswa ngosuku, ngesonto, noma ngenyanga.

Iqhinga liwukuthi Qinisekisa ukuthi izigaba ezikusizindalwazi sakho sangempela ziyafana nalezo ezisesabelomaliUma isabelomali sakho sihlanganisa into ebizwa ngokuthi "Ukukhangisa Ku-inthanethi," awukwazi ukuyifaka ngokungahleliwe leyo zindleko kuthebula lakho langempela njenge-"Izikhangiso," "Ukuthengisa," noma "Ukumaketha Kwedijithali." Chaza ikhathalogi yezinto eziku-inthanethi bese unamathela kuyo, ngoba isabelomali sakho uma siqhathaniswa naso ngeke sinembile. ukuthembeka.

Ideshibhodi kanye neshidi lokuzulazula

Ukuze kube lula ukusebenzisa i-mini ERP eqenjini lonke, kuyasiza kakhulu ukudala i-mini ERP. ikhasi lokuqala njengedeshibhodi kanye nemenyu yokuzulazulaUkusuka lapha ungafinyelela ezinye izingxenye—izilungiselelo, amathebula edatha, imibiko, njll.—usebenzisa izinkinobho noma izixhumanisi, futhi uthuthele ngisho nephaneli ku-PowerPoint. izixhumanisi ezinamandla phakathi kwe-Excel ne-PowerPoint.

Kungumqondo omuhle ukufaka ezinye izinto kule phaneli yokulawula Izinguquko ezijwayelekile njengenyanga unyaka wezimali oqala ngayo, uhlobo lwemali oluyinhloko, kanye nobubanzi besikhathi sokukhokha ofuna ukukusebenzisa ukumaka izexwayiso zokukhokha sekwephuzile. Isibonelo, unganquma ukuthi uma ikhasimende liphuzile izinsuku ezingaphezu kwezingu-15, kuzogqanyiswa embikweni wemigomo yokukhokha.

Ngaphezu kwezinkinobho zokuya esigabeni ngasinye (imikhiqizo, amakhasimende, ukuthengisa, ukuthenga, isitoko, imibiko yezimali, imibiko yenzuzo, njll.), ungabhuka indawo ongayibonisa Izinkomba ezibalulekile ngendlela ebonakala kakhuluImali engenayo iyonke yaleso sikhathi, imali engenayo iyonke, imali engenayo iyonke, ibhalansi yamakhasimende ekhona, kanye nesifinyezo esifushane sokugeleza kwemali kwezinsuku eziyi-7, 14, 30, 90, kanye ne-180. Lokhu kuguqula i-mini ERP ibe uhlobo lwedeshibhodi enikeza umbono osheshayo wempilo yebhizinisi lakho.

Isigaba sokucushwa: izigaba, abasebenzisi, kanye namapharamitha

Ngaphambi kokuthi uqale ukufaka idatha, kungumqondo omuhle ukulungiselela ingxenye yedatha. ukucushwa lapho uchaza khona uhlu oluyinhloko kanye namapharamitha omhlaba wonkeLe ngxenye ivame ukuba "yisicefe" kancane, kodwa yiyona eyenza konke okunye kuhambe kahle futhi ngendlela ehlelekile.

Ekhasini lokucushwa, ungachaza izigaba zomkhiqizo, abameleli bokuthengisa, izindlela zokukhokha, izinhlobo zezindleko, izimali zesibili kanye nanoma iyiphi enye ikhathalogi ongase ufune ukuyisebenzisa njengohlu olwehliswayo kumathebula akho. Ukusebenzisa uhlu olwehliswayo (ukuqinisekiswa kwedatha) kunciphisa kakhulu amaphutha futhi kuqinisekisa ukuthi imiqondo ihlala ihambisana.

Futhi yindawo enhle yokuhlala imikhawulo ebalulekileIsibonelo, isikhathi sokukhokha esikhulume ngaso ekuqaleni, noma inani elizenzakalelayo lezinga lesitoko esibalulekile, ongalicacisa ngomkhiqizo ngamunye uma kudingeka. Ngokufanayo, uma usebenza nama-akhawunti amaningi asebhange, ungagcina amagama amafushane ozowasebenzisa lapho uqopha amarisidi nezinkokhelo lapha.

Incazelo yomkhiqizo kanye nokuphathwa kwempahla okuyisisekelo

Ingxenye eyinhloko yanoma iyiphi i-mini ERP yi- ishidi lomkhiqizoLapha uchaza konke okuthengayo, okugcinayo, noma okuthengisayo: izinto ezibonakalayo, izinsizakalo, okubhaliselwe, njll. Umkhiqizo ngamunye kumele okungenani ube negama elilodwa kanye nekhodi ehlukile.

Kuthebula lomkhiqizo, kunconywa ukufaka izinkambu ezifana nokuthi Igama lomkhiqizo, ikhodi, isigaba, iyunithi yokulinganisa, izinga lesitoko esibucayi (ngezinsuku) Futhi, uma kwengeza inani, umkhiqizo noma umhlinzeki wakho ojwayelekile. Ikhodi kanye nesigaba kuzokwenza impilo yakho ibe lula kakhulu lapho uqoqa futhi uhlaziya kamuva, futhi iyunithi (izingcezu, kg, amamitha, amaphakheji, njll.) ivimbela ukudideka lapho kuhlanganiswa izinkomba.

Umqondo we izinga lesitoko esibucayi ezinsukwini Kunamandla kakhulu: akugcini nje ngokuthi unawo amayunithi amangaki, kodwa ukuthi zingaki izinsuku zokuthengisa leso sitoko ezizosimboza, uma ubheka ukuthengisa kwakho kwansuku zonke okujwayelekile. Kamuva, kuthebula lesitoko, ungabalela izinga lokusetshenziswa kwansuku zonke ngokusekelwe ekuthengisweni komlando bese ulisebenzisa ukuqagela ukuthi isitoko samanje sizohlala izinsuku ezingaki. Uma lelo nani liwela ngaphansi kwezinga elibucayi, ispredishithi ingabonisa isexwayiso esibomvu.

Uma umsebenzi wakho udinga lokho, unganikeza nemininingwane indawo yokugcina impahla, usuku lokuphelelwa yisikhathi, inombolo yesiza noma inombolo yengxenye ukuphatha izindlela ze-FIFO (zokungena kuqala, ukuphuma kuqala) futhi kube nokulandeleka okungcono kweqoqo ngalinye lomkhiqizo.

Isizindalwazi samakhasimende kanye nokuphathwa kwezingozi

Enye insika ye-mini ERP ephumelelayo ku-Excel yi- uhlu lwamakhasimende olugcinwe kahle Isebenza cishe njenge-mini CRM. Lapha awudingi nje kuphela igama leklayenti, kodwa futhi nolwazi lokuxhumana kanye nezindlela zokulandelela ezezimali.

Isakhiwo seshidi lamakhasimende esijwayelekile singase sihlanganise Ikhodi yekhasimende, igama, ikheli, inombolo yocingo, ikheli le-imeyili, ummeleli wokuthengisa obelwe Futhi, okuthakazelisayo kakhulu, imingcele emibili ebalulekile: umkhawulo wesikhathi sokukhokha kanye nomkhawulo wengozi yebhalansi.

El isikhathi sokugcina sokukhokha Khombisa inani lezinsuku ozibona zamukelekile ukuthi ikhasimende likukhokhele. Uma bedlula lelo nani kunoma iyiphi i-invoyisi, uhlelo lungalumaka embikweni wemigomo yokukhokha. umkhawulo wengozi yebhalansi Lena yinani eliphakeme kakhulu ozimisele ukuliqoqa njengesikweletu neklayenti; uma lidlula leli nani ngaphandle kokukhokha futhi, ngaphezu kwalokho, lidlula umkhawulo walo wesikhathi, kufanele ulibone liphawulwe ngokucacile emibikweni yakho.

Ukusebenza ngamakhodi amakhasimende ahlukile kuwumkhuba omuhle, noma ngabe awuwasebenzisi njengamanje. Amakhodi alula ukuhlunga, ukuqoqa, kanye nokugcinwa kwedatha (Isibonelo, uma ushintsha igama lebhizinisi lekhasimende, ikhodi ihlala ifana futhi akukho lutho oluphukayo.) Kunconywa futhi ukugwema ukushintsha isakhiwo sethebula uma selisebenza; kungcono ukusebenzisa izinkinobho noma ama-macro ukuhlunga nokuhlanza isizindalwazi.

Izinhloso zokuthengisa, ukuthengisa kwangempela, kanye nokuhlaziywa kokusebenza

Ngaphandle kokurekhoda nje okwenzekile, i-mini ERP ithola amandla amaningi uma uyifaka izinhloso zokuthengisa kanye nokuqhathaniswa nokuthengisa kwangempelaLokhu kukuvumela ukuthi uhlole ukusebenza kwethimba lokuthengisa futhi ubone ukuthi ususondela yini emigomweni yakho yanyanga zonke.

Ephepheni lemigomo, ungangena ngomkhiqizo ngamunye kanye nenyanga ngayinye inani lokuthengisa ofisa ukulifinyelelaAkudingeki ukuthi kube okuphelele; ngisho nokulinganisa okunengqondo kuzokunikeza iphuzu elihle lokubhekisela. Uma usebenza ngezigaba, ungachaza futhi imigomo ehlanganisiwe ngomndeni womkhiqizo noma isiteshi.

Eshidini elihlukile, ufaka ukuthengisa kwanyanga zonke noma kwansuku zonke (Manje sizohlola ngokujulile isakhiwo sama-invoyisi okuthengisa). Ngemuva kwalokho, usebenzisa amathebula noma amafomula e-pivot, ungakha umbiko "wokusebenza kokuthengisa" okukhombisa ngokubonakalayo ukuthi yiliphi iphesenti lenhloso oyifinyelele ngomkhiqizo, ngesigaba, noma ngomthengisi, uqokomise ngombala izindawo ezingaphansi noma ngaphezulu kwesibikezelo.

Uma uhlanganisa le ndlela nolwazi lwezindleko zamayunithi kanye nentengo yokuthengisa, uzokwazi futhi Hlaziya hhayi nje kuphela ukuthi uthengisa malini, kodwa nokuthi umkhiqizo ngamunye unenzuzo kangakanani.Lokhu ngezinye izikhathi kwembula izimanga: imikhiqizo ethengiswa kakhulu engafaki isandla kangako emalini engenayo, noma izinkomba ezimbalwa ezisekela inzuzo iyonke yebhizinisi.

Izindleko zomkhiqizo, amanani okuthengisa, kanye nezindleko ezizinzile

Ukuze i-mini ERP yakho ibe nobukhulu obuqinile bezezimali, udinga ukufaka izinhlobo ezintathu zedatha yezomnotho: izindleko zomkhiqizo weyunithi, amanani okuthengisa kanye nezindleko ezizinzileNgalolu lwazi, imibiko yenzuzo inengqondo.

Ephepheni lezindleko zomkhiqizo, ungaqopha izindleko zeyunithi ngomkhiqizo ngamunye kanye ngenyangaLokhu kuyasiza ngoba izindleko zokuthenga zingahluka ngokuya el tiempoFuthi kuyalulekwa ukukhombisa lokhu kushintshashintsha ekubalweni kwe-margin. Uma ungakwazi ukulinganisa izindleko zesikhathi esizayo, ungacabanga ngisho nezimo zenzuzo ezinyangeni ezimbalwa kusengaphambili.

Ekhasini lentengo yokuthengisa, uchaza intengo othengisa ngayo umkhiqizo noma isevisi ngayinyeUma uthengisa ngentengo efanayo isikhathi eside, ngeke kudingeke ukuthinta le ngxenye kaningi; uma uphatha ukukhushulwa okuningi noma amanani ngekhasimende ngalinye, uzodinga uhlelo oluyinkimbinkimbi kancane, kodwa nge-ERP encane, intengo ejwayelekile ivame ukwanele.

I-Los izindleko ezingashintshi (Imali yokuqasha, umholo wokuphatha, amalayisense, umshwalense, njll.) ngokuvamile kufakwa njalo ngenyanga futhi kubhekwa njengokuzinzile. Ngokufaka lolu lwazi ohlelweni, imibiko yakho yezezimali izokwazi ukukhombisa iphuzu lokulingana, izitayela ze-margin eziphelele, kanye nesilinganiso sezindleko ezizinzile maqondana nokuthengisa. Kubalulekile ukugwema ukubhala ngaphezulu amaseli ampunga noma amaseli aqukethe amafomula; ngokuvamile, kufanele ugcwalise kuphela amaseli amhlophe, aklanyelwe ukufakwa kwedatha.

Irekhodi le-invoyisi yokuthengisa nokuthenga

Inhliziyo ye-mini ERP ivame ukuba se- ithebula lerekhodi le-invoyisi yokuthengisaLapha ufaka ulwazi mayelana nakho konke ukuthengisa kwakho, kungaba ngesandla, ngokukungenisa nge-Power Query kusuka kufayela le-CSV kusuka ohlelweni lwe-POS, noma kusuka kuhlelo lwakho lokukhokha, uma unalo.

Isakhiwo esijwayelekile saleli thebula sizofaka amasimu anjenge usuku lwe-invoyisi, usuku lokuphelelwa yisikhathi, inombolo ye-invoyisi, ikhodi yomkhiqizo kanye negama, ikhodi yekhasimende kanye negama, inani, iyunithi, intengo, i-VAT Futhi, uma usebenza ngamaqoqo, inombolo yengxenye yokuxhumanisa nesitoko. Amaningi ala makholomu angagcwaliswa ngokuzenzakalelayo kusuka kumathebula amakhulu (isibonelo, iyunithi nohlobo lomkhiqizo kutholwa kusuka eshidini lomkhiqizo, igama lekhasimende litholakala kusuka eshidini lekhasimende, njll.).

Ngesikhathi esifanayo, ungaba neshidi le- ukuthenga amarekhodi Sebenzisa leli thebula ukuze urekhode ukuthengwa kwezimpahla noma izinsizakalo. Nakuba ezinye izibalo ezibalulekile zingase zingathembeli kulo, liwusizo kakhulu ekulandeleni nasekulawuleni isitoko. Ungangeza amakholomu afana nekhodi yentela (uma kudingeka), usuku lokuphelelwa yisikhathi, indawo yokugcina impahla, umhlinzeki, nanoma yiluphi olunye ulwazi olusiza ekutholeni izimpahla ngokoqobo.

Inhlanganisela yamatafula womabili, ukuthengisa nokuthenga, okuphakelayo imojuli yempahla kanye nemibiko yokusetshenziswaFuthi, uma uyixhumanisa kahle nezindleko namanani, inzuzo iyonke iyoba yingxenye yomkhiqizo ngamunye noma umndeni ngamunye.

Ukuphathwa kwempahla kanye nezaziso zesitoko

Ngokuthenga okuqoshiwe kanye nokuthengisa, ungakha ispredishithi amarekhodi esitoko lokho kugcina isimo sesitoko somkhiqizo ngamunye sisesikhathini. Nakuba ungasibala ngamafomula, ngokuvamile kulula kakhulu ukusibeka etafuleni elisibonisa ngokucacile.

Kuleli shidi, ngemva kokukhetha umkhiqizo kanye, uma kusebenza, inombolo yengxenye noma yebhetshi, yonke idatha ingatholakala ngokuzenzakalelayo: amayunithi asesitokweni, usuku lokuthengisa okurekhodiwe kokuqala, usuku lokuthengisa kokugcina, izinga lokusetshenziswa kwansuku zonke elilinganiselwe kanye nezinsuku ezilinganiselwe zesitoko ngokusekelwe kulelo zinga lokusetshenziswa. Konke lokhu kubalwa ngokubhekisela kwedatha yokuthengisa yomlando enamarisidi ewareji.

Ikholomu ye- izinsuku zesitoko ezilinganiselwe Lokhu kuwusizo kakhulu ngoba kukuvumela ukuthi ubone ukuthi isitokwe samanje simboza izinsuku ezingaki zokuthengisa. Uma leli nani liwela ngaphansi kwezinga elibalulekile elichazwe emininingwaneni yomkhiqizo, uhlelo lungabonisa isexwayiso esibomvu sokukukhumbuza ukuthi ufake i-oda. Lokhu kukusiza ukuthi ugweme kokubili ukuphela kwesitokwe kanye nokugcwalisa ngokweqile isitoreji sakho ngezinto ezihamba kancane.

Ukuqapha ukuqoqwa, izinsuku zokugcina kanye nokugcinwa kwezimali

Ukuthengisa kuhle kakhulu, kodwa uma ungakhokhelwa ngesikhathi, ibhizinisi liyahlupheka. Yingakho kubalulekile ukufaka [ulwazi olungekho - okungenzeka ukuthi luyisici noma uhlelo] ku-mini ERP yakho. imodyuli yokulandelela amaqoqo eqopha izinkokhelo zangempela ozithola kumakhasimende bese iziqhathanisa nalokho obekufanele ngabe bakhokhe ngokusho kwama-invoyisi akhishwe.

Ungaqopha ephepheni le-invoyisi usuku lokuqoqa, ikhodi yekhasimende, inombolo yokukhokha noma ireferensi, indlela yokukhokha, inani, usuku okulindeleke ukuthi kufakwe ngalo imali ku-akhawunti, amanothi asebhange kanye nokuzikhethelaUsuku lokufaka imali olulindelekile lubalulekile ngoba ezinye izindlela zokukhokha (njengezikhumulo ze-POS noma amapulatifomu aku-inthanethi) zinokulibaziseka phakathi kwesikhathi ikhasimende elikhokhiswa ngaso kanye nekhredithi yangempela kwi-akhawunti yakho yasebhange.

Ngale datha, nangokuyibhekisa ndawonye nethebula le-invoyisi yokuthengisa, ungakha imibiko yama-akhawunti wamanje, imigomo yokukhokha kanye nezaziso zengoziIsibonelo, umbiko okukhombisa, kuklayenti ngalinye, ukuthi likweleta malini, ukuthi likhokhe malini kuze kube manje, ukuthi yimaphi ama-invoyisi asedlulelwe yisikhathi, nokuthi asephuzile izinsuku ezingaki. Ungahlunga futhi ngommeleli wokuthengisa ukuze ubone ikhwalithi yephothifoliyo ephethwe yilowo nalowo.

Uma futhi wondla iqabunga elincane le- ingcebo ezindaweni ezahlukene (izinsuku ezingu-7, 14, 30, 90 kanye ne-180)Lokhu kuzokuvumela ukuthi ubikezele izinkinga zokuhamba kwemali futhi uxoxisane kahle namabhange kanye nabaphakeli. Lo mbono uhambisana nolwazi ngemali yokusebenza esebenzayo: ama-akhawunti atholakalayo, ama-akhawunti akhokhayo, isitokwe, kanye nezindleko ezikhokhelwa kusengaphambili, kanye nokulandelela izindleko zemali (i-CAPEX), ikakhulukazi uma lezi zimpahla ziqashisiwe futhi zingasabhekwa njengezindleko zokusebenza eziphelele.

Imibiko ebalulekile: imigomo yezezimali, inzuzo kanye neyokukhokha

Uma idatha isihlelekile kahle, ingxenye ezuzisa kakhulu iqala: imibikoKu-Excel mini ERP eyakhelwe kahle, kuvamile ukuba okungenani kube namabhulokhi amane emibiko: isifinyezo sezezimali, ukuhlaziywa kokuthengisa, inzuzo yomkhiqizo, kanye nemibiko yokukhokha kanye nengozi.

El umbiko wezezimali ofingqiwe Lo mbiko uhlanganisa imali engenayo yakho, inzuzo yakho iyonke (ukuthengisa ngaphandle kwezindleko zezimpahla ezithengisiwe), kanye nenzuzo ephelele (ngemuva kwezindleko ezihleliwe nezinye izindleko) ibe umbono owodwa. Njengoba ungeza idatha inyanga nenyanga, lo mbiko uyakhula, ukuvumela ukuthi ubone izitayela: izinyanga ezinamandla nezibuthakathaka, umthelela wokushintsha kwentengo, isisindo sezindleko eziguquguqukayo, nokuningi.

El ukuhlaziywa kwamarekhodi e-invoyisi yokuthengisa Idweba etafuleni lokuthengisa futhi ngokuvamile yakhiwa kusetshenziswa amathebula e-pivot. Ungaqoqa ngomkhiqizo, isigaba, ikhasimende, ummeleli wokuthengisa, indawo, noma isiteshi, bese ubona ngokushesha ukuthi ukuthengisa kwakho kugxile kuphi. Ngisho nokuqonda okuyisisekelo kwamathebula e-pivot, ungakha imibono eguquguqukayo kakhulu ngaphandle kokushintsha isakhiwo esiyisisekelo.

El umbiko wempumelelo yomgomo wokuthengisa Igxila ekuqhathaniseni imigomo yokuthengisa yangempela. Ngokuvamile ivezwa njengedeshibhodi enezithombe, ekhombisa iphesenti lempumelelo ngomkhiqizo noma isigaba ngasinye. Iwusizo kakhulu ekubuyekezweni kwanyanga zonke nethimba lokuthengisa, njengoba inikeza umbono osheshayo wokuthi obani abahlangabezana nemigomo nokuthi obani abadinga ukwesekwa.

El umbiko wenzuzo yomkhiqizo Cishe ingenye yezinto eziveza kakhulu. Ngokubhekisela emananini okuthengisa, izindleko zamayunithi, kanye nezindleko ezizinzile, ikukhombisa ukuthi yimiphi imikhiqizo noma imigqa yebhizinisi ekhiqiza inzuzo nokuthi yikuphi okungase kwehlise imiphumela yakho. Ngezinye izikhathi uthola ukuthi umkhiqizo onevolumu ephansi uyigugu langempela ngokwesilinganiso, noma ukuthi lonke uhlobo lomkhiqizo kufanele lubuyekezwe noma lubekwe kabusha.

Ekugcineni, i umbiko wemigomo yokukhokha Isebenzisa imikhawulo yesikhathi sobungozi kanye nenkokhelo oyichazile kuphrofayela yamakhasimende ukuhlola indlela aziphatha ngayo inkokhelo. Uhlelo lungaphendula imibuzo efana nalokhu: “Leli khasimende likhokha kangaki?”, “Inkokhelo yalo yokuqala neyokugcina yayinini?”, “Ingabe lingaphakathi kwesikhathi sokukhokha esivunyelwene ngaso?” futhi, ngokusekelwe kulokhu, likhipha izexwayiso kulabo abadlula umkhawulo wabo wengozi futhi baqongelela izinkokhelo ezinkulu eziphuzile.

Ukuzenzakalela nge-Power Query, i-UserForms, kanye nama-macros

Uma ufuna ukuthatha igxathu lekhwalithi nokunciphisa imisebenzi yezandla, kufanelekile ukuyisebenzisa Umbuzo Wamandla wokwakha nokuhlanganisa amathebula kanye namafomu omsebenzisi (ama-UserForms ku-VBA) okufaka idatha. Akuphoqelekile, kodwa kuyinguquko yemvelo njengoba i-mini ERP iqala ukukhula.

Nge-Power Query ungakwazi Ngenisa idatha kusuka kumafayela e-CSV, izinhlelo zokuthengisa, izitatimende zasebhange, noma ngisho nezinye izincwadi zomsebenzi ze-ExcelZiguqule (hlanza amakholomu, yenza imiqondo ifane, hlanganisa amathebula) bese uwafaka kumodeli yakho ngaphandle kokukopisha nokunamathisela isikhathi ngasinye, futhi, ukuze wethule, ungasebenzisa futhi Izixhumanisi eziguquguqukayo ze-OLE kanye ne-DDE phakathi kwe-Excel ne-PowerPoint. Ngaphezu kwalokho, ungakwazi ukuchaza ubudlelwano phakathi kwamatafula (isibonelo, phakathi kwama-invoyisi namakhasimende, noma phakathi kokuthengisa nemikhiqizo) ngendlela efana kakhulu nendlela ongayenza ngayo kudathabheyisi elula.

Ama-UserForms nama-macro akuvumela ukuthi wakhe izikrini zokufaka idatha ezisebenziseka kalula neziqondiswayoEsikhundleni sokuthi umsebenzisi ahlele ithebula ngokuqondile, ugcwalisa ifomu ngezinkambu ezidingekayo, ama-dropdown, kanye nokuqinisekiswa, bese uhlelo lugcwalisa ithebula elihambisanayo ngolwazi. Lokhu kunciphisa amaphutha, kuvimbela amaphutha esakhiwo, futhi kuvumela ukulawula okungcono ukuthi ubani ofinyelela ini.

Yebo, kubalulekile ukukhumbula lokho Akunconywa ukushintsha izakhiwo zethebula esezisetshenziswa kakade ngamafomula noma imibuzo.Uma udinga ukushintsha imiklamo, kungcono ukwenza kanjalo ngokucophelela, ubhale phansi ukuncika okukhona, noma usebenze ngamakhophi uze uqiniseke. Kufanele futhi ucabangele ukuhambisana kwe-macro kanye ne-VBA, ikakhulukazi uma uzokwabelana ngefayela nabasebenzisi be- Mac noma izinguqulo ezindala ze-Excel.

Buyekeza inqubo kanye nomsebenzi nomgcinimabhuku

I-mini ERP ku-Excel inikeza inani kuphela uma isetshenziswa njalo futhi ibuyekezwa njalo. Ngakho-ke, ukusungula i-mini ERP ku-Excel inikeza inani kuphela uma isetshenziswa njalo futhi ibuyekezwa njalo. umhlangano omfushane wamasonto onke ukubuyekeza ideshibhodi nokwenza izinqumo eziqondile.

Kulowo mhlangano, esikhundleni sokulahlekelwa imininingwane, ungagxila kulokho Amaphuzu amathathu abalulekile: ukuphambuka okukhulu phakathi kwesabelomali kanye neqiniso, imbangela eyinhloko, kanye nesenzo sokulungisaIsibonelo, uma ukuthengisa kungaphansi kuka-20% kwezilinganiso esigabeni, uhlaziya ukuthi inkinga ihlobene yini namanani, ukukhushulwa, isitoko, noma ukuncintisana, bese uchaza izindlela ezithile. Kuwusizo kakhulu ukubhala phansi lezi zenzo kukholomu "yesenzo" kanye nekholomu "yeqembu elinomthwalo wemfanelo" ngaphakathi kwespredishithi uqobo, ukuze isilinganiso sixhunyaniswe ngqo nokuphathwa.

Kungumqondo omuhle futhi ukuthi ubuze nomgcinimabhuku wakho noma umeluleki ukuthi kanjani nciphisa izinsuku zokugcina zokuletha ulwazi lwezezimaliIzinkampani eziningi zisebenza ngokubambezeleka kwezinsuku eziyi-10 noma ngaphezulu ekuvaleni ama-akhawunti azo, okuyinto engasizi ngalutho ekwenzeni izinqumo zokusebenza. Ungafaka izinqubo zokwenza ngokuzenzakalelayo kanye nokuhlunga kusengaphambili ama-akhawunti ayisihluthulelo ("ngaphambi kokulungiswa") ukuze ube nedatha esesikhathini ngokuthengisa, izindleko eziqondile, eziguquguqukayo, nezizinzile, ukuhamba kwemali, kanye nemali yokusebenza.

Uma uhlanganisa ulwazi olunikezwa yi-akhawunti yakho kanye ne-mini ERP yakho, uzoba ne- umbono ophelele kakhulu: ukubalwa kwezimali, ukusebenza kanye nokugeleza kwemaliLokhu kukuvumela ukuthi ulawule kokubili isikhathi esifushane (umgcinimafa kanye nempahla) kanye nesikhathi esiphakathi (inzuzo kanye nokukhula) ngethuluzi, empeleni, eliseyispredishithi se-Excel esakhiwe kahle.

Ukusetha i-mini ERP ku-Excel akukhona ngokwakha i-macro enkulu noma ukudala amashadi amahle kakhulu, kodwa mayelana Cabanga ngokucophelela ngokuthi yiluphi ulwazi olubalulekile ebhizinisini lakho, luhlele ngamathebula aklanywe kahle, wenze ngokuzenzakalelayo lokho okudingekayo, bese ulubuyekeza ngokuziphatha.Uma uhlela imikhiqizo, amakhasimende, ukuthengisa, ukuthengwa, izindleko, isitoko, ukuqoqwa, kanye nemibiko usebenzisa indlela esibonile, usebenzisa amathuluzi afana ne-Power Query namafomu ukunciphisa amaphutha, futhi ujwayela ukubuyekeza ukuphambuka kanye nokugeleza kwemali masonto onke ngezikhathi ezahlukene, uzoba nohlelo olunamandla ngokumangalisayo ngobukhulu benkampani yakho ngaphandle kokutshala imali ku-ERP yendabuko.