00:00Let's go.
00:30Makikita po natin yung mga iba't ibang klaseng report dito.
00:34Meron pong sales by customer, by item, by rep, at marami pang iba.
00:39Unahin natin, itong sales by customer summary.
00:43By the way, meron din po itong in summary at in detail.
00:47Dito po sa sales by customer summary, open natin.
00:51Si company customer 1 pa lang, yung transaction natin ngayong May.
00:55At dahil May 10 ngayon, hanggang May 10 lang yung range ng ating report.
01:02Reports ulit tayo, tapos sales.
01:04Ngayon naman, sales by customer detail.
01:09Maximize natin.
01:11Tapos adjust ko lang itong number natin at memo na column at iba pa.
01:17Anggalin natin yung mga magkakapareho.
01:20Yan po ang transaksyon natin kay company customer 1.
01:23Makikita nyo po, meron itong dalawang klaseng transaksyon.
01:26Invoice at sales receipts.
01:28Kasi nga, sa last lesson natin, nagset ako ng example na transaksyon sa ating invoice para ipakita sa inyo yung
01:34sales na utang.
01:35Tapos, sales receipts naman as sales na cash or bayad kagad.
01:41Dito po, sa ating sales report by customer, wala pong pakialam si QuickBooks.
01:47Kung utang ito na benta or cash na benta.
01:51Mapautang or cash na benta, irirecord niya ito.
01:55As overall total sales.
01:58Benta lahat yan, mapapautang man or bayad kagad.
02:02Dito po kasi sa ating QuickBooks, kahit wala po tayo natanggap na pera,
02:06dahil pinautang natin gamit ang create invoice tulad nito, benta na po yan.
02:12Kaya kahit wala po kayo natatanggap sa pautang ninyo na benta,
02:16direcord na po dito as sales or benta na kagad.
02:19Kahit hindi nyo pa nakahawakan, itong $1,050, the transaction natin sa ating invoice.
02:27Ayan po.
02:29The invoice po yan.
02:32Next report tayo.
02:35Reports pa rin, tapos sales pa rin.
02:39Tapos, sales by item detail.
02:42Detail muna tayo sa ating sales.
02:45Ngayon naman po, nakafocus ito sa inventory at hindi sa ating customer.
02:50Kasi nga, itong sales natin sa ating customer detail,
02:54nakafocus po kay company customer one.
02:57Siya po yung naka-outline.
02:59Pero dito po sa ating sales by item detail,
03:02naka-outline po siya per item.
03:10Tapos, nandito siya sa name.
03:15Ganon din po.
03:17Mga pa-invoice
03:18o sales receipts,
03:20wala pong pakialam si QuickBooks kung pa-utang po na benta
03:23o cash na benta.
03:25Dahil kahit pa-utang na benta,
03:27isasama po niya as total sales
03:29na $2,100.
03:31Malaki na yung kita natin pero
03:33hindi po natin nasisingil
03:35yung mga invoices na transaction
03:37o yung mga pa-utang na benta
03:39sa ating mga customers gamit ang invoice.
03:46Reports pa rin tayo, tapos sales.
03:50Tapos sales by item summary.
03:54Ito po,
03:55naka-focus sa item.
03:57Wala si customer dito.
03:58Mayroon po itong mga columns
04:00na hindi pa tayo familiar.
04:02At ituturo ko po yan
04:03sa ating mga next lesson.
04:05Pero makikita natin dito
04:07yung mga familiar natin.
04:09Kunwari, itong quantity
04:11tapos amount.
04:14Then ang the rest,
04:15i-explain ko pa sa inyo.
04:18Pero pwede nyo munang tingnan
04:19dito sa quantity at amount.
04:24Reports and sales pa rin tayo.
04:26Tapos,
04:28mayroon itong report
04:28na sales by rep summary
04:30at sales by rep detail.
04:32At tatalakayan po natin yan
04:34sa ating mga future lessons.
04:35Dahil kung pipili po tayo nito,
04:37kunwari,
04:37sales by rep summary,
04:40nakalagay po,
04:41no sales prep.
04:42Bakit kaya?
04:43Malalaman din natin to.
04:45Para sa ngayon,
04:46focus muna tayo
04:47sa ating report
04:48sa ating sales,
04:51sa customers at items.
04:55Sa ating previous lesson,
04:56tinalakay natin
04:57itong open sales orders
04:58by customer
04:59at open sales orders
05:00by item.
05:01Kasi,
05:02diyan po nakarecord
05:03yung mga transaction natin
05:04gamit po
05:05ang sales orders
05:06sa transaction.
05:07Dahil itong sales orders,
05:08ito po yung purchase orders
05:09sa mga customers natin.
05:11Kung pinanood po ninyo
05:12yung lesson natin
05:13sa ating balance in credits
05:14regarding sa ating mga customers,
05:16pinakita ko po
05:16ang pantransact
05:17ng sales orders.
05:18Dahil kapareho ito
05:20ng purchase orders
05:21sa ating vendor.
05:21Ang purchase orders nga lang
05:23sa ating vendors.
05:24Pero ang sales orders
05:26sa ating customers.
05:29Kaya,
05:30yun po
05:30yung reports natin
05:31sa ating sales o benta.
05:33Ulitin ko po,
05:36kahit anong report po
05:37sa ating sales,
05:38mapautang
05:39o bayad kagad,
05:41lahat po
05:42isasama ni QuickBooks
05:43dito sa ating report.
05:44Mga pa-iteman
05:45or customer.
05:48Kasi nga,
05:49kahit pinautang natin
05:50gamit ng create invoices,
05:52sales pa rin yun.
05:54Tapos,
05:54nagtansact tayo ng cash,
05:56sales din po yun.
05:58Kaya,
05:59ulit-ulitin ko,
06:00kaya po
06:00transaction na benta
06:01na pautang,
06:02create invoice.
06:04Transaction na
06:04cash basis
06:06or bayad kagad,
06:07create sales receipts.
06:09Either way,
06:10pare po silang
06:10sales
06:11or benta.
06:12Kaya lahat,
06:14pinagsasama-sama ni QuickBooks
06:15dito sa ating sales report,
06:17mapautang man
06:18or bayad kagad.
06:22Huwag niyo pong kakalimutan yun.
06:24Ang ating sales
06:25ay isang income account.
06:27Kaya po,
06:28itong mga reports din natin
06:29na nakikita dito
06:30sa ating sales
06:31ay nakabase po
06:32sa ating income account
06:34na sales
06:35na makikita
06:36dito sa homepage
06:37sa section ng company
06:39tapos
06:39chart of accounts.
06:43Hanapin po natin
06:44yung ating income account
06:47at ito po yung sales.
06:49Kaya po,
06:50pag niray-click natin to
06:52tapos
06:53quick report
06:53sales
06:58tapos iset natin yung date
07:01sa May 1
07:02tapos to May 10
07:04which is today
07:07makikita po natin dito
07:08si company customer 1.
07:12Nakabase po
07:13ang reports natin
07:15sa ating sales
07:17sa income account
07:19na ang pangalan
07:19ay sales.
07:26Kung gagawa po tayo
07:27na reports
07:27sa ating sales
07:28para sa ating mga customer
07:30in detail
07:34tapos
07:34dahil May po ngayon
07:36May lang po na transaction
07:37yung nakikita natin dito
07:39kung i-adjust ko po
07:40yung date natin sa from
07:41at i-atras ko to
07:44pambalik
07:44nung January
07:47tapos
07:48i-refresh natin
07:50ito po yung mga
07:51transactions natin
07:51sa ating mga previous lesson
07:53under po
07:53sa balance and credits
07:56dahil sa balance and credits
07:57meron tayong balance
07:59na nangyayari
07:59kapag nagpapautang tayo
08:01sa ating customers
08:01kaya
08:02nagkaroon tayo ng mga
08:04transactions
08:04sa ating mga customers
08:05usually
08:06sa invoice
08:07kasi
08:08invoice po yung
08:09tinalakay natin
08:10dahil
08:10about balance and credits
08:12or balance
08:14netong ko lahat
08:15sa balance and credits
08:18gamit ang invoice
08:19nagkakaroon ng balance
08:20yung ating mga
08:20customers sa atin
08:22kaya maraming invoice
08:23dyan
08:24at bihira lang
08:24ang sales receipts
08:27invoice
08:27at credit memo
08:28kasi yung credit memo
08:29nag-offset
08:30sa balance ng invoice
08:31or ng accounts receivables
08:36kaya yun po
08:37gamit ng credit invoice
08:38at credit sales receipts
08:39involve po
08:40ang income account
08:42kaya po sa paggamit natin
08:43ng credit invoices
08:44at credit sales receipts
08:45nakafocus po tayo ngayon
08:47sa income account
Comments