- 6 weeks ago
Ating alamin ang mga stock-in at stock-out na transaction sa Inventory Valuation Detail na nakafocus muna sa quantity ng mga items natin.
Category
📚
LearningTranscript
00:08Now, when you know how to use and how to use the stock card report,
00:13we'll try to go to the accounting system on QuickBooks Desktop.
00:17Before we go, I want to know that I have a new inventory type item here at Inventory Center.
00:27At ang inventory type na item na ito ay Silver Swan Soy Sauce na 330 ml.
00:33Right-click ko lang tapos Edit Item para po makita ninyo yung mga details na nilagay ko.
00:40Ito po yung item name, description, cost, at sales price.
00:47Gumawa po ako ng bagong item para ma-isolate po yung example natin.
00:52Kung gusto nyo po gumawa ng additional inventory item, gawa po kayo.
00:56Click natin tong OK.
00:57Kaya ayan, meron tayong Silver Swan na Soy Sauce na 330 ml na bottle.
01:03Bago din natin umpisahan, gusto kong malaman ninyo na meron po tayong lesson
01:07tungkol sa mga transactions natin dito sa QuickBooks na nagpapagalaw sa ating mga inventory type na items.
01:12Unahin po natin yung mga stock in na transactions
01:14o yung mga nagdadagdag ng balance sa ating mga inventory type na items.
01:17Ito po yung mga bills na transactions na located sa ating vendor section.
01:22Right-checks naman, located po sa banking section.
01:25At itong refunds and credits na located po sa customer section.
01:30Tapos po, yung mga transactions naman na stock out o yung mga bumabawa sa balance ng ating inventory.
01:35Ito naman po yung great invoice, great sales receipts na makikita sa customer section.
01:41At credits na makikita po sa ating vendors sa loob ng receive inventory with bill.
01:47Na ang tawag ay credit.
01:50Return po sa ating vendor.
01:53Kaya stock out po yan o babawas sa balas ng mga inventory items.
01:57Una, gawa muna tayo ng stock in na transaction.
01:59Kaya pili lang po kayo sa base na transactions or write transactions.
02:03Ako po, dito sa vendors.
02:05Receive inventory with bill.
02:11The vendor name 2.
02:14Tapos, yung ginawa nating silver swana soy sauce na 330 ml.
02:18Mag-i-stock in ako ng 100 as purchase.
02:22Save and close.
02:23Kaya ayan, meron na po tayong stock in.
02:26Para po malocate natin yung stock card report dito sa ating QuickBooks,
02:29punta lang po tayo dito sa reports.
02:31Tapos, inventory.
02:34Tapos, inventory valuation detail.
02:36Dito po sa QuickBooks, hindi po stock card ang pangalan sa report.
02:39Ang pangalan po dito sa QuickBooks ay inventory valuation detail.
02:42Click natin.
02:45Ito po ang pinaka-stock card ni QuickBooks.
02:47Inventory valuation detail na report.
02:50Ngayon po, magkasama dito yung value at yung quantity.
02:53Focus muna tayo sa quantity.
02:55Kaya tatanggalin ko muna itong average cost, asset value, at itong cost.
03:00Iwan ko lang itong type, date,
03:02name, number, quantity, at on hand.
03:05Kahit itong number, tanggalin na rin natin.
03:07Para mas malinaw.
03:10So, sa first line po ng ating report sa ating inventory valuation detail,
03:13which is ang stock card,
03:14meron po tayong pumasok ng 100.
03:17Gamit ang bill na transaction.
03:20Subukan naman natin yung write checks,
03:22which is stock in din.
03:24I-minimize muna natin itong report.
03:26Write checks tayo.
03:29Vendor name to pa rin.
03:33Toy sauce na silver swan.
03:36Tapos 100 ulit.
03:40Even close.
03:43Balik tayo sa ating report.
03:46Ayan po, tumatakbo na yung stock card na report natin na inventory valuation detail.
03:51Kung makikita nyo dito,
03:53pumasok ng 100,
03:54kaya 100 yung on hand natin o yung ending balance sa ating bill.
03:59Ginamit naman natin yung check na stock in,
04:01kaya dumagdag ang 100.
04:03Kaya 100 plus 100 equals 200.
04:06At 200 ang ending balance after natin mag-transact ng check.
04:11Subukan naman natin itong refunds in credits,
04:14which is stock in din.
04:19Kay company customer 2.
04:22O kunwari kay ano na lang, kay Jenny Ramirez.
04:25Tapos,
04:26bumili ng silver swan na soy sauce.
04:28Kunwari, 75 yung binili.
04:3175 pieces yung binili
04:33ni Jenny Ramirez.
04:35Save and close natin.
04:38Close lang.
04:39Tapos, balikan natin yung ating report.
04:41Yes lang para ma-refresh.
04:44May dumagdag ng linya
04:45na ang transaksyon ay credit memo.
04:48Kung makikita natin dito ngayon,
04:50nung bill na transaksyon,
04:51meron pong 100 na pumasok.
04:53At yun din ang ending balance.
04:55Pagkatapos,
04:55nagtansak tayo ng write checks,
04:57which is stock in din,
04:58meron 100 na pumasok.
05:00Kaya bill na 100
05:01plus check na 100
05:02equals 200 ang on hand.
05:04Ngayon po, makikita natin dito,
05:06may dumagdag na 75
05:07galing kay Jenny Ramirez
05:09kasi sinoli niya.
05:10Kaya yung last balance natin na 200
05:11na pinurchase natin
05:13kay vendor name 2
05:13na dagdagan naman ng 75.
05:16Galing sa ating customer
05:17na si Jenny Ramirez.
05:18Tapos, credit memo
05:19ang ginamit natin,
05:20which is stock in na transaksyon.
05:22Kaya, padagdag po ito.
05:23Kaya ngayon,
05:24yung total ng on hand natin
05:26o yung ending balance natin
05:27is 275 na.
05:29Kaya ito po,
05:30yung tatlong transaksyon
05:31na dumadagdag sa ating balance
05:32o yung mga stock in na transaksyon.
05:35Subukan naman natin
05:36yung mga stock out.
05:39Subukan naman natin
05:40dito sa invoice.
05:44Sa invoice,
05:45bumili
05:46si Randy Ortiz
05:47ng Silver Swan pa rin
05:48ng 100.
05:53Bibilihin ito
05:54pero utang
05:54pero lalabas pa rin
05:55yung inventory item.
05:57Save and close natin.
05:59Tapos,
05:59balikan natin
06:00yung ating report
06:01at i-refresh.
06:03Yung pinakabagong line natin
06:05na may transaksyon na invoice
06:06bumawas po
06:07sa ating 275
06:08na on hand.
06:09Kaya 275
06:10minus 100
06:11175
06:12yung ending balance natin.
06:15Nakikita nyo yung pattern?
06:16Pareho po
06:17sa stocker na sample natin.
06:19Pinapakita yung
06:19transaction type,
06:21yung date,
06:21yung name na involved,
06:22yung quantity
06:23at yung ending balance
06:24na on hand.
06:26Kaya alam na natin
06:27kung ano yung mangyayari
06:28dito po
06:29sa ating
06:29create sales receipts.
06:32Kunwari,
06:34dito naman is
06:36175
06:38Ang bumili naman,
06:40si Joaquin Customer lang.
06:41Save and close.
06:45Yes lang
06:46para ma-refresh.
06:48Kaya yan,
06:49nakita ninyo.
06:50Gamit ang sales receipts,
06:52bumawas po ito
06:53sa 175
06:53na ending balance natin
06:54nung nag-invoice tayo
06:56kay Randy Ortiz.
06:56Kaya po
06:57175
06:58na ending balance
06:59nung nag-invoice tayo,
07:00nabawasan
07:01ng 175
07:02nung nag-sales receipts
07:03tayo
07:04kay Joaquin Customer.
07:05Kaya po
07:06yung ending balance
07:06ng 175
07:07o yung balance
07:08natin last time,
07:09nabawasan po
07:10nung 175.
07:11Kaya zero na po
07:12yung natira sa atin.
07:14Kaya po
07:14kung magtataka kayo,
07:15bakit zero na lang
07:16yung balance natin
07:17sa ating silvers
07:17na soy sauce,
07:18ito po yung supportings
07:20kung bakit umabo tayo
07:21o humantong tayo
07:22sa zero na balance.
07:24Stock in a bill,
07:25stock in a write check,
07:26return na credit memo,
07:28tapos
07:28stock out na invoice,
07:30tapos
07:30stock out na sales receipts.
07:32Ngayon po
07:33nawala na tayong balance
07:34dito sa QuickBooks
07:35pero meron tayong balance
07:36sa ating bodega,
07:37tapos
07:37pinilit natin
07:38itransact,
07:40gamit.
07:41Ito namang
07:43credit
07:44or return
07:44sa ating vendor,
07:45kunwari kayo
07:46vendor name 2,
07:49soy sauce pa rin,
07:50tapos 100
07:50ang quantity,
07:54save and close natin,
07:58refresh natin
07:59yung ating inventory
08:00valuation detail,
08:01dahil po
08:02dahil po
08:02nakaalaw yung
08:02negative natin,
08:04yung ending balance
08:05natin last time
08:06sa sales receipts
08:07na zero,
08:07nabawasan po
08:08ng credit
08:08or return sa ating
08:10vendor.
08:10Pero hindi po tayo
08:11nakapag-stock in,
08:12pinilit natin
08:13na itransact yung 100
08:14para ma-return
08:15sa ating vendor,
08:16kaya ng negative.
08:18Dahil nakaalaw din po
08:19yung QuickBooks natin
08:20na mag-record
08:20ng negative.
08:21So yung credit,
08:22out din po yan,
08:23kaya pabawas.
08:25Tanggalin na po natin
08:26itong negative,
08:27pinakita ko lang po sa inyo
08:28na pwede po mag-negative
08:29yung ating inventory
08:30valuation detail
08:31or stocker na report.
08:33Yes lang.
08:34So ngayon,
08:35na zero na yung balance natin,
08:36stock in ulit tayo.
08:40Write checks or bill,
08:41pili lang po kayo.
08:42Kunwari,
08:43write checks ulit.
08:48Kunwari,
08:49dinamihin na natin.
08:50Ginawa na natin
08:51300.
08:53Ayan.
08:54Then save and close.
08:58Yes lang.
08:59Kaya ngayon,
09:00kung magtataka kayo,
09:01bakit 300 na naman
09:02yung balance natin
09:03sa ating inventory
09:04sa ating item
09:05na Silver Swan Soy Sauce
09:06na 330.
09:07Nag-purchase pala ulit tayo
09:09gamit ng write check
09:10kasi binayaran natin kaagad
09:11yung ating vendor
09:12na si vendor name 2.
09:13Kaya ngayon,
09:14300 na yung ending balance natin.
09:17Mapapansin po ninyo
09:18dito sa ating quantity,
09:20ito po mga positive,
09:21ito po yung mga stock in
09:22o yung padagdag
09:22sa ating mga inventory balance.
09:24Ito namang mga negative,
09:26ito po yung palabas
09:27or stock out
09:27or pabawas
09:29sa mga inventory balance natin.
09:30Yung mga transactions po
09:32na nakikita natin dito,
09:33controlled po yung paggawa natin.
09:35Kumbaga,
09:35inuna natin yung mga stock in
09:36bago yung mga stock out.
09:37Then stock in ulit.
09:39Pero po sa ating pag-operate,
09:40magsha-shuffle po
09:41yung mga transactions na yan.
09:42Kaya ngayon,
09:43alam nyo na
09:44kung paano gumagana
09:44yung stock card
09:45dito po sa ating QuickBooks.
09:47Malaking tulong po
09:48ang stock card na report
09:49which is inventory valuation detail
09:50dito sa ating QuickBooks
09:51para matrace natin
09:52kung bakit
09:54ganun ang naging
09:54ending balance natin
09:55as of June 22, 2026.
09:58At isang item lang po ito,
09:59kung paano kung maramihan.
10:01Kaya kayang-kaya po
10:02ni QuickBooks
10:03yung mga maramihang items
10:04para ma-monitor sa stock card
10:06o ang tawag natin
10:07inventory valuation detail.
10:08at a be-kayao.
10:09Kaya kayang-kaya po
10:11dito sa stock card
10:12ma-pay-kaya.
10:12Kaya kayang-kaya po
Comments