How to create an Inventory/Sales System in Excel (Tagalog)

[@fingerscreations04]

Hello po sir. Thank you so much. Sobrang galing ng explanation. nagawa ko po sya lahat... God bless po ang more power..

[@CyPersia]

Thanks very much sa comment mo. Goodluck sa business!

[@fingerscreations04]

@@CyPersia Welcome po..

[@kiddielearningtv]

Laking tulong po samin to maraming salamat po God bless

[@CyPersia]

Welcome!

[@milkadondoy]

Thank you sir! Ganito yung gusto ko i-achieve na inventory para sa business, salamat po sa guide. More powers! 🙌🤍

[@CyPersia]

You are welcome, all the best sa business!

[@dernoDgreat123]

Thank you Sir...Have a wonderful day, I appreciate you so much for this tutorial...

[@CyPersia]

Thank you for dropping by. Appreciate your nice comment too!

[@aljonbruno6669]

Thank you, Sir! Galing!

[@CyPersia]

Welcome. I am glad I was able to help.

[@riaescala5247]

been looking for this! thank youuuu!!! Godbless youuuu po

[@sheiladimataga]

Thank you sir for a simple yet helpful

[@CyPersia]

You are welcome

[@carongee1006]

Thank u sir for sharing ur knowledge

[@CyPersia]

It's my pleasure, See you next time!

[@queng2que]

thank you for this.. more tutorials pls..

[@CyPersia]

More to come! Stay tune.

[@queng2que]

@@CyPersia next topic po sana.. excel tutorial po to create database from pdf file to excel. pano po sya ma simplify? thanks po

[@janeespanyola5168]

Thank you so much for the tutorial very educational

[@CyPersia]

You’re welcome 😊

[@selassie.k.amenorhu4769]

Thanks very much. I am grateful

[@johnlodirefugio4752]

Thank you po Sir Cy, very helpful po yung KZbin Tutorial ninyo. More Powers po sa inyong Channel. New Subscriber Here 👍

[@CyPersia]

Thank you for subscribing!

[@anamousk]

brilliant! thank you!

[@CyPersia]

Glad you liked it!

[@TheSurVEILance]

Thank you soo much sir!

[@CyPersia]

Most welcome!

[@randomnessssss2556]

nice

[@andreaaicee]

Hello po. This Inventory system will be very useful to my small business. Ask ko lng po sana kung paano po yung monthly inventory sir. Should I create a new set of Masterfile,sales,purchase,deliveries each month? Thank youuu

[@CyPersia]

Thanks for you comment. You will set up the template only once. Meron ng End Inventory column sa template if I understand you question correctly.

[@andreweresmas1092]

No need na po since may date na po Ang deliveries table, u will just have to put a date

[@kurtwee1439]

Hi sir, i downloaded the file and everytime i change the cost/unit sa masterfile, nageerror sa inventory yung cost/unit and inventory value nagiging #NAME?. how do i solve this po?

[@airatolentino1216]

Sir, profit and loss statement naman pls :)

[@CyPersia]

Thanks for the suggestion!

[@mindlzero7108]

Hi sir question po regarding sa cost sa Sales tab pag morethan 1pc qty po ang nabenta hindi nagmumultiply cost which is ung margin po mali computaion cost lng po ng 1 item na less Example to 1 item cost =20 2 item sold dapat po 40 na cost pero 20 pdin naless sa margin

[@hajanpagayao2648]

Pano po gumawa ng inventory kung may stock in or may stock out po kayo halos araw-araw sa parehong product po na automatic magkokonekta agad sa iyong inventory sheet?

[@treblig_sa]

Hi Sir! Salamat po andaming ko kaliwanagan at natutunan sa video na to. May tanong po ako... ang business ko po kasi is Gotohan, Pares, Mami, and Silog. ngayon po may mga ala carte po kasi kami example na po yung egg. So may varieties po xa such as prito, laga etc. Since mayron din po kaming silog so evidently it needs egg supply as part of the meal. ang tanong ko po pano ko po mamanage yung supply count non for the inventory since ang dami niang pinaggamitan na considered unique product... sakit po ulo ko nahinto ako sa pagconstruct dahil sa kalituhan.. sorry po.. hope you can help. thanks in advance Sir! More power!

[@CyPersia]

Maraming Salamat sa comment mo. I am happy that my video help you. Sa iyung tanong, idagdag mo na lang ang boiled or fried egg sa masterlist para maging part ng product list.

[@Gabuna1106]

Sir pd po ba gamitin to sari sari store thank you

[@edmelendres7079]

Hi Sir, is it possible to restrict input of sales if the available stocks is not sufficient? can you teach us how to include it in your template? Thanks in advance!

[@marjsantiago5187]

Hi Sir, where can I download the file? the link kasi po wala dun yung file it only shows "get this domain" please po pa help. Thank you

[@Ormocanon27]

Sir good eve...pwede po ako magpagawa ng format din sayu? Pls dm me sir

[@marjsantiago8651]

Sir san po pwede ma download sa link po kasi it says buy this website.

[@johnlodirefugio4752]

Question po Sir. Paano po pala kapag discounted price or nag Sale yung Regular Price? Thank you!

[@CyPersia]

Just create another item code for the discounted price in the masterlist tab.

[@neilarreola7841]

Hi sir. I have recently opened a small hardware store and I'm having a hard time tracking my inventory until I saw your video. In introducing a new kind of item you just have to press TAB after the last column of the last entry. How about deleting a non-moving item in the masterfile? Will the ITEM CODE in the other sheets (deliveries, sales, etc) automatically update? Thank you.

[@CyPersia]

You can right click the item then Delete > Table Rows. Other sheets will get updated too.

[@neilarreola7841]

@@CyPersia Thank you very much sir😁

[@lizasanangil4916]

Thank you sir Cy.. Sir pwede po humingi ng help sir? Plan ko po sana magopen ng chicken wings online business.. pano po gumawa sa excel para mamonitor po yung sales ang inventory ng mga ingredients po? Thank you po sa answer.. Keep safe!

[@CyPersia]

Thank you din Liza. The tutorial can help you build that in Excel or you can download in my website (see description)

[@janetteesquivelviernes9694]

Sir ask ko lang po kung paano kapag may another delivery para sa isang item paano po sya iaadd sa stocks?

[@CyPersia]

I post mo lang lahat ng deliveries sa "Deliveries Tab". Kung may total row ka, right click then Insert>Table Rows Above. Pwede mo rin mag tab na lang sa last row ng deliveries.

[@janetteesquivelviernes9694]

@@CyPersia thanks Sir.. nagawa ko na po😄

[@doggies1473]

Hello sir, bakit po yung margin hnd na multiply ung qty?

[@CyPersia]

Please watch until the end for the complete formula. Thanks

[@jennymaepingoy18]

How to get the quantity available sir?

[@ritzalbelda8515]

hello sir!bat pag nagTAB ako hindi nagcocopy yung mga ginawa ko?

[@CyPersia]

Hi, baka hindi naka format as Excel table ang file.

[@ritzalbelda8515]

@@CyPersia nakaformat na sya ng excel table...

[@user-oe6vm2bm6l]

Hello po. Any link po to download the file?

[@travelbuddy5173]

Sir applicable po ba ito sa general merchandise business? Salamat po. If you dont mind can I ask your e mail for my query. Salamat po.

[@CyPersia]

Yes pwede.

[@marjsantiago5187]

Hi Sir, how to download po the file? thank you

[@airatolentino1216]

Such a big help! Thank you sir. :) Magagamit k sa business ko CALI Asian Foodmart

[@CyPersia]

You are welcome. Good luck sa business!

[@rosievillaluz4608]

Sir possible po ba magawa din ito using mobile phone? Tia

[@CyPersia]

Hi, hindi yata lahat ng features available sa mobile version.

[@rosievillaluz4608]

Question pa po. Pano po kung may nagbayad ng utang, isasama ba siya sa Sales tab or panibagong tab po? Ang laki ng tulong nitong video mo. meron akong agri supply. Salamat po ulit 👍☺️

[@CyPersia]

Salamat po at nakatulong sa business nyu. Maganda po ang tanong ninyu. Ideally dapat may isa pang tab para sa AR/Billing. Balak ko po gawan ito dahil sa tanong nyu. For the meantime, pwede na lang po ilagay natin sa Sales tab. Mag dagdag lang ng isa pang column for payment.

[@rosievillaluz4608]

Ayun, waiting po ako sa video mo, ☺️. Sige idagdag ko na lang sa Sales tab. Maraming salamat po talaga. Sana magkaroon ka na lang din ng paid apps, para madownload, kasi pangbusiness naman po, parehong nakatulong, sa amin at sayo din. Thumbs up 👍👍 God Bless

[@SaleemKhan-ne1hk]

Download link is not available here

[@CyPersia]

Please try again. Link should work. Thanks for dropping by.

[@alejandrodejesus4121]

Paano sir kung nagkaroon ng changes sa pricing

[@CyPersia]

The simplest solution is to create another item with the new pricing.

[@kyl5480]

@@CyPersia Hi sir,, this is my problem, pag nag change ang price (puhunan), may other way pa po ba na hindi na kailangan mag create ng new item code (same product)

[@NJCOP747]

I appreciate you but when you switch language it gets confusing!!!

[@CyPersia]

Thanks for watching. I used a mix of Tagalog and English in this Tutorial.

[@caliasianfoodmart343]

Thanks for this! Big help in my business :) CALI Asian Foodmart

[@CyPersia]

Any time!

[@Maruthiiee]

Ano tagalog ng margin ? :)

[@Maruthiiee]

Profit ba yun?

[@CyPersia]

Correct profit ang tawag natin.

[@pushandstep6049]

@@CyPersia SIR MAY TANONG LANG AKO JAN SA FORMULA NG MARGIN, SUPPOSED TO BE REVENUE MINUS (COST*QTY), TAMA PO BA?

[@japanessa89]

thank you