00:00Let's go to our vendor center.
00:31Let's go to our vendor center.
00:35Marami na tayo mga data na nakikita.
00:38Bago tayo mag-umpisa, gusto ko malaman ninyo na meron po itong dalawang tab.
00:43Vendors tab at transactions tab.
00:46Dito muna tayo sa vendors tab.
00:48Kikita ninyo, nakahighlight po sa vendor name 1.
00:52At yun po ang nakikita nating data dito.
00:55Sa transaction na tab.
00:57Dahil dito sa vendor information, meron po itong limang tab.
01:01Transaction, contacts, to-dos, notes, sent email.
01:07Pero dito muna tayo sa transaction na tab.
01:10Base po sa kanyang title na transactions,
01:13pag pinili natin yung ating vendors dito,
01:15sa ating left side,
01:16ipapakita po sa transaction na tab,
01:19yung mga transaction na ginawa
01:20ng ating mga vendor.
01:22Equivalent po yan sa ating report.
01:24Sa ating reports,
01:26vendors and payables,
01:29tapos,
01:30transaction list by vendor.
01:39Meron po itong mga filter na show,
01:42filtered by,
01:43saka date.
01:47Dito po sa ating show na filter,
01:50pwede nyo pong i-filter
01:51kung anong transaction lang.
01:53Ang lalabas, kunwari,
01:54puro bills lang.
02:00Bills lang po,
02:01with total.
02:08Purchase orders lang.
02:11Kunwari,
02:12ang pipiliin natin.
02:16Pio lang,
02:16lalabas.
02:21Yung susunod na filter,
02:23filtered by,
02:25all about purchase orders.
02:28Bale,
02:30ang filtered by,
02:31ay mag-a-adjust,
02:32depende sa pinili natin,
02:34dito sa issue show natin,
02:35na transaction.
02:37Kung about bills,
02:40all about bills,
02:41ang filter niya.
02:45Kaya,
02:46depende po sa transaction
02:47na gusto nyo ma-filter dito,
02:49mag-a-adjust po,
02:50ang filter by,
02:52sa transaction na napili ninyo.
02:54Ang susunod naman,
02:55itong date.
02:56Itong date na makikita natin dito,
02:58hindi po ito pare sa date
02:59sa ating reports na,
03:01from at saka to.
03:02Medyo complicated ng konti.
03:06Dahil either,
03:08today,
03:10this week,
03:12this month,
03:13puro this,
03:15hanggang,
03:17yesterday,
03:17pabalik naman tayo,
03:19at last week,
03:20ayan po.
03:21At sa future next,
03:23naka-ranging lang po ito,
03:27days,
03:27weeks,
03:29month,
03:30at saka year.
03:32Wala pong specific date
03:33na pwede natin maset.
03:35Kaya po,
03:36basis sa transaction
03:36na lumalabas dito sa ating tab,
03:39yun po,
03:40yung total natin
03:41sa ating balance total
03:42na kolom dito.
03:43Di ba pareho?
03:46Check nyo dyan sa inyo
03:47kung gumagawa din kayo.
03:49Pareho ba yung balance
03:50sa ating vendor
03:50sa transaction na tab
03:52na pinapakita ni QuickBooks?
04:00Pag naka-all transactions po,
04:02wala po tayong total
04:03na makikita
04:03sa transaction na tab.
04:06Dito din sa ating vendor center
04:07dahil meron na tayong data,
04:10meron din po itong Excel
04:12or Export to Excel na button.
04:16Pwede natin i-export
04:17yung ating list
04:18ng ating mga vendor,
04:19yung mga transaction,
04:21at meron din po itong option
04:22sa Import from Excel,
04:23at Paste from Excel,
04:25which is tatalakay natin
04:26sa ating future lessons.
04:28Pero for the meantime,
04:29ito po munang dalawa.
04:31Subukan natin itong
04:32Export Vendor List.
04:34Para nag-export din po tayo
04:35ng report,
04:36at ito po yung mga option natin.
04:41Click natin itong
04:41Create New Worksheet,
04:43tapos Export button.
04:45Pag may nag-blink na po
04:46sa inyong taskbar,
04:47pakiclick lang po.
04:50At ayan po.
04:52Ganun lang.
04:55Pag marami kayong vendors,
04:56marami pong i-export dito.
05:00Ito namang Export Transactions.
05:03Kayo, Vendor Name 2.
05:07Create New Worksheet pa rin tayo na option.
05:09Export.
05:13Ayan po.
05:18Parang Transaction List by Vendor.
05:23Kaya po dito sa ating Vendor Center,
05:24meron po tayong
05:25dashboard
05:26para po makita natin
05:27yung mga activity
05:28ng ating mga vendors.
05:30Mas better po,
05:31mas malaki yung side
05:32ng vendor information.
05:35From Vendor's na tab,
05:36dito naman tayo
05:36sa Transactions na tab.
05:39Dito naman po
05:40sa Transaction na tab,
05:41opposite naman po.
05:43Imbis na vendors
05:43yung nakadisplay,
05:44mga Transaction po.
05:45Bale,
05:46kung pipili tayo ng Transaction,
05:47kung nari bills,
05:51lahat po ng vendors
05:52na nag-transact sa bills,
05:53makikita po natin dito.
06:00Lahat ng pay bills,
06:01ayan po.
06:03Makikita nyo rin,
06:04ito po yung mga Transaction
06:05na ginamit natin
06:06o yung mga
06:06ginagamit
06:07sa ating vendors.
06:09Ang credit na Transaction,
06:10kasama na po
06:11dito sa bills.
06:12Kaya kung makikita ninyo,
06:13may credit po tayo
06:14ng reflect dito.
06:19Itong credit card activities,
06:20hindi po natin ito na-take up
06:21dahil hindi naman po
06:22masyadong common
06:22yung credit card
06:23sa pag-process natin
06:24kasi medyo complicated po
06:26sa QuickBooks
06:26kung gagawin natin
06:27yung credit card.
06:29Pero meron po tayong
06:30workaround
06:30para ma-process
06:31yung mga credit card
06:32sa ating mga future lessons.
06:34Kaya ito po yung mga
06:35possible
06:36na ginagamit natin
06:37sa ating mga vendor
06:38na Transaction.
06:42Balik tayo sa vendors
06:43sa tab.
06:44Sa vendors sa tab,
06:45all about vendors
06:46tapos dito yung
06:47transaction nila.
06:49Pag-transactions
06:50naman tayo na tab.
06:52All about transactions
06:54at dito naman
06:55yung mga vendors natin.
06:57Opposite naman.
06:59Vice versa.
07:01Kung gusto nyo pong
07:02silipin yung vendor center
07:03ninyo,
07:04i-explore nyo po
07:04yung dalawang tab na ito
07:06na by vendors
07:07at by transactions.
07:09Dahil
07:11makikita nyo
07:12yung mga transaction
07:13na ginawa natin
07:13sa mga vendors
07:14at yung mga transaction
07:15na involved
07:16yung ating mga vendors.
07:18Medyo struggling
07:19ang konti sa date.
07:21Kasi ranging lang po ito
07:23by day,
07:24week,
07:24month,
07:25year.
Comments