00:08How do you want to get advanced payments to our customers?
00:13You can do this in QuickBooks at it's very easy.
00:16But before we start, let's do the requirements.
00:21What we need to do is to get a liability account.
00:25Dito po sa homepage, sa section ng company, i-click po natin itong icon ng Chart of Accounts.
00:31Or sa menu bar, by clicking List, tapos Chart of Accounts.
00:37Para po makapag-record ng advance payment ng ating customers, kailangan muna natin gumawa ng liability na account.
00:43Kaya dito po sa Chart of Accounts, i-click natin itong button ng account, tapos New.
00:50Dito po sa add yung account ng window, hanapin po natin dito sa baba, by clicking itong Other Account Types
00:57para ma-activate.
00:59Tapos hanapin natin yung Other Current Liability.
01:03Click natin.
01:06Ayan po.
01:08Then click Continue.
01:09Tapos ang account name na ilalagay natin.
01:12Any name po na ma-identify yung advance payment ng ating customer.
01:18Kunwari, Customer's Advanced Payment.
01:22Tapos, Save and Close.
01:25Pagkatapos po natin gumawa ng Other Liability na account, item naman po.
01:29Kaya i-close natin itong Chart of Accounts.
01:31Tapos dito sa homepage, sa section pa rin ng company, i-click natin itong Items and Services.
01:38Para ma-open yung ating item list.
01:40Na pwede rin po ma-access sa menu bar, by clicking List, tapos Item List.
01:46Click natin.
01:47Dito po sa ating item list na window, gagawa tayo ng item parang pang advance payment ng customer.
01:52Kaya dito po sa item list, i-click natin itong button ng item, tapos New.
01:59Tapos pili lang po kayo.
02:01Service.
02:03Non-inventory part.
02:06At Other Charge.
02:07Basta hindi inventory part.
02:10Ang pipiliin ko po itong non-inventory part.
02:13Tapos lagay ko dito, Customer Advanced Payment.
02:17Dito, in full detail, Customer Advanced Payment.
02:23Wala po itong price dahil, during transaction na po tayo maglalagay ng amount.
02:29Ang account na pipiliin natin, yung account na ginawa natin.
02:32Yung Customer Advanced Payment na ang account type ay Other Current Liability.
02:37Tapos.
02:39Click natin.
02:40Nakapili na po.
02:42Tapos pwede na natin i-click itong OK.
02:45At ayun po.
02:45Meron na tayong item na Customer Advanced Payment na merong account na Other Current Liability.
02:51Na ang pangalan ay Customer Advanced Payment.
02:54Paano natin ito i-process?
02:56Mandali lang po.
02:57Dito po sa homepage, sa section ng customers, i-click natin itong Create Sales Receipts.
03:04Tapos piliin po natin yung customer na magbabayad in advance.
03:07Kunwari, si Company Customer 1.
03:09Ang una natin pipiliin na item,
03:12yung item na ginawa natin na Customer's Advanced Payment.
03:16Ngayon po.
03:17Na merong account na Other Current Liability.
03:21Which is ang pangalan is Advanced Customer Payment pa rin.
03:24Ngayon po, kunwari, ang binahay ng customer ay in advance 2,000.
03:30So, magkakaroon tayo ng benda na 2,000.
03:34Kung matatandaan ninyo sa ating previous lesson,
03:36gumawa po tayo ng item na Payment Type.
03:40Ngayon po, mayroon tayong payment dito na East-West at Metrobank.
03:44Pipiliin ko itong Metrobank.
03:48Click natin.
03:49OK.
03:50Ibig sabihin dito, itong payment na matatanggap natin,
03:54i-de-deposit natin sa ating bank account na Metrobank.
03:57Para ma-review kayo,
03:58tingnan natin sa ating list tapos item list.
04:01Yung payment item natin na Metrobank.
04:05Ayan po.
04:08Right-click ko lang tapos,
04:10Edit Item.
04:12Para ma-refresh kayo.
04:14Bale, ito po ay isang payment sa ating customer na
04:16pag na-receive natin,
04:18marireceive natin in-check,
04:20tapos i-de-deposit ka agad natin sa Metrobank.
04:23Or nakadeposit na kaagad sa Metrobank.
04:26Ganun lang po.
04:27Kaya ang mangyayari ngayon,
04:29yung advance payment ng ating customer
04:31na 2,000,
04:32madideposit po sa ating bank account na Metrobank.
04:39Kaya ngayon,
04:40zero na yung ating sales receipts.
04:42Save in yun natin.
04:44At ayan po.
04:45Ito po yung ating transaction na advance payment.
04:48Itong sale number,
04:49baguhin pala natin to.
04:50ADC for advance payment sa ating customer.
04:52Tapos,
04:53yan po.
04:54Kayo po bahala sa numbering
04:56para ma-identify nyo mabuti.
04:57Then,
04:58save in you.
05:00Yes lang.
05:02At narecord na po natin yung advance payment natin sa ating customer.
05:05Ngayon po,
05:06para makita natin yung report nito,
05:08hindi po natin makikita ito sa report sa ating customers.
05:11Silipin natin.
05:12Puta tayo sa menu bar.
05:13Click natin itong reports.
05:14Tapos,
05:15customers and receivables.
05:17Tapos,
05:17customer balance detail.
05:19So,
05:20balance ito na mga customers.
05:21Kasi nga,
05:22nag-advance payment si customer
05:23or si company customer one.
05:25Si company customer one dito,
05:27makikita natin na wala siyang record
05:29ng advance payment niya.
05:31Makikita lang natin yung advance payment
05:33ng company customer one
05:34kung pupunta po tayo
05:35sa chart of accounts.
05:40Tapos,
05:41hanapin natin yung account na ginawa natin
05:43na customer's advance payment.
05:45At makikita nyo dito,
05:46meron pong 2,000
05:47na nagre-reflect.
05:48At yan po yung advance payment niya.
05:51Kasi nga,
05:52kung i-highlight natin ito,
05:54tapos,
05:54puta tayo ng reports.
05:56Tapos,
05:56quick report.
06:00Makikita natin dito
06:01na merong advance payment
06:02si customer na 2,000.
06:03Pero wala pong assistance
06:04si QuickBooks
06:05na nagmumonitor nito.
06:06Kung baga,
06:07parang reminder na merong
06:08advance payment si customer.
06:09Kaya,
06:10dito natin titignan
06:12sa quick report
06:13ng other current liability
06:15na pinalanganan natin
06:16na customer's advance payment.
06:19Paano natin ito ipoprocess
06:21pag gagamitin na
06:21ni company customer 1?
06:23Simple lang.
06:24Kailangan lang po natin
06:25pumunta sa create invoice
06:27para itransact yung purchase
06:28ang ating customer,
06:30which is,
06:30gusto na po niya gamitin
06:31yung kanyang advance payment.
06:35Piliin natin si company customer 1.
06:37Kunwari,
06:38bibili po siya
06:39ng duck egg tray na large,
06:41kunwari,
06:41200 pieces.
06:43Ayan po.
06:45Kaya 200
06:46times 8 pesos
06:48equals
06:491,600.
06:52Pagkatapos niyan
06:52or yung mga items
06:53na bibili ni customer,
06:54dun na po natin i-apply
06:55yung advance payment niya.
06:57Dito po sa second line
06:58ng kanyang invoice.
07:01Pagkatapos po
07:02ng item natin.
07:03Kaya po,
07:03hahanapin natin dito
07:04yung item na advance payment.
07:06Ayan po.
07:09Customer advance payment.
07:13Ngayon,
07:14pwede natin i-apply
07:15yung buong amount
07:16na binili niya
07:17ng worth 1,600.
07:19Pero dapat,
07:20lagyan niyo ng negative
07:22para maging zero
07:24yung kanyang invoice.
07:27Tapos,
07:27pwede na natin i-save.
07:30At ngayon po,
07:31na-record natin
07:31yung advance payment ni customer
07:32at in-apply natin
07:34sa kanyang invoice.
07:35Meron pong stamp na pay
07:36dahil
07:37zero na po itong invoice.
07:39Ngayon po,
07:40para makita yung report nito,
07:42kailangan
07:42sa chart of accounts
07:43pa rin tayo pupunta
07:44at bisitahin natin
07:45yung account
07:46na other current liability
07:47na ang pangalan po
07:48ay customer advance payment.
07:50Punta tayo sa menu bar,
07:52tapos list,
07:52tapos chart of accounts.
07:55Hanapin natin
07:56yung customer advance payment
07:57na other current liability.
07:59Makikita nyo dito,
08:01from 2,000
08:02naging 400 na lang.
08:05Nakahighlight pa po
08:06itong ating account
08:07na other current liability
08:08na customer advance payment.
08:10Then,
08:10punta tayo sa reports.
08:13Then,
08:14quick report.
08:18Makikita nyo dito,
08:19bumawas po
08:19yung 1,600
08:20sa 2,000
08:21kaya 400 na lang.
08:24Ang downside po nito
08:25o ang problema dito,
08:26manual po natin
08:27itong imomonitor.
08:28Dahil wala pong
08:28assistance si QuickBooks
08:29na magre-remind sa atin
08:31kung magkano na lang
08:32yung advance payment
08:34ng ating customer.
08:35Kaya kailangan natin
08:36silipin lagi
08:36dito sa account
08:38na other current liability
08:39na ang pangalan
08:40ay customer's advance payment.
08:43Medyo technical po
08:44ang procedure na ito.
08:45Napilitin natin gawin ito
08:47dahil
08:47ito pong ginawa natin
08:48ay standard po
08:50sa accounting procedure
08:50dito sa Pilipinas.
08:52Kailangan
08:52gamitan natin
08:53ng other current liability
08:54or liability na account
08:56yung mga advance payment
08:57ng customer.
08:58Kaya po,
08:59ginamitan natin
09:01na account
09:02na other current liability.
09:10Kaya ganun po
09:11ang paraan
09:11para ma-record
09:12yung advance payment
09:12ng ating customer
09:13sa standard accounting
09:15na pamamaraan.
Comments