Ita eBay rekodi yekuchengetedza fodya uchishandisa PayPal zvinhu
Kana iwe wakanga uri mukutengesa eBay chero nguva yakawanda yaunenge uchiziva kuti PayPal inzira yakanaka yekugamuchira mari dzekutengesa-zvirikurumidza, zviri nyore, uye PayPal inochengetedza zvinyorwa zvekutengesa zvakapedzwa nenzira iyi. Ichokwadi, iwe unogona kuwana izvi kutengeserana mune faira, shanduro-yakagadzirirwa mafaira kuti uone kuverenga maitiro ako -kana iwe uri muchengeti, mutengesi, kana zvose zviri zviviri, haufaniri kushandisa pepa rePayPal zvakananga kuti uwane rekodi ye mutengesi wese.
Mukubatana nepurogiramu yepasheetti yakafanana neExcel, iyi yePayPal inogona kugadzirisa mabhuku kune vashoma uye midzi-volume-vatengi vatengi uye vatengesi chikamu chekeke-kunyanya kana iwe wakangwarira kushandisa PayPal nokuda kwezvizhinji zvekutengesa kwako.
Kushandisa Excel kusvika Access PayPal Records
PayPal inoita kuti database yekutengeserana kwako iwanikwe kwauri mune zvinyorwa zvinonzi CSV, kana kuti "maitiro akaparadzaniswa nemavara." Shanduro dzakawanda dzinoshandiswa seAexcel, Quattro Pro, kana OpenOffice.org Calc-izvochete zvaungashandisa kuenzanisa mabhuku enyu kana kuti mitero yako-inokwanisa kuverenga uye kutumira mafaira akachengetwa mumutauro uyu.
Nokuti PayPal inogona kuumba mafaira eCVV iwe kubva pamatunhu ezuva, unogona kushandisa PayPal kuti iite nokukurumidza, yakarurama, yakazara yekugadzirisa mashoko (kusanganisira PayPal mari , kutumira uye kugadzirisa mari, nezvimwe zvinhu) maererano nekutengeswa kweBay kwaunogona kuisa ipapo pakombiyuta yako uye shandisa pane shanduro yepa spreadsheet, somuenzaniso, kuronga nemhando yekutengeserana kana kuwana matanho okukurumidza kumitero.
Kugadzira CSV Faira Kushandisa PayPal
Kuti ugadzire faira CSV yemari yako yePayPal, pinda muIndaneti yePayPal sezvaunoda kutarisa compte yako kazhinji. Kana uchinge wapinda mukati uye uchitarisa chinyorwa che "My Account" peji, tevera matanho aya:
- Dzvanya "Nhoroondo." Dzvanya pamusana pebhuruu uye chichena "History" link pedyo nepamusoro pepakati peji. (Hint: inowanikwa kurudyi rwe "Bvisa" link.)
- Sarudza musi wezuva. Shandisa zvishandiso panzvimbo yepamusoro peji kuitira kuti usarudze mararamiro ezuva rekutengesa kuratidza. Unogona kusarudza zviyero zvinowanzoitwa se "Last Week" (nokuda kwekutengeserana kwemazuva manomwe akapfuura) kana "Mwedzi Wakapera" (nokuda kwekutengeserana kwemazuva makumi matatu apfuura), kana kuti iwe unosarudza kuratidza musi wezuva.
- Dzvanya chikwata che "CSV". Dzvanya ki "CSV" chibatanisi kurudyi kwezwi rokuti "Dharira:" kumusoro kwekunzvimbo kworatidzwa. A popup ichaoneka ichikukumbira kuti usarudze mhando yekudzivirira.
- Dzvanya bhora re "Download". Pasina kuchinja faira yefaira kubva "CSV," chengetedza bhii "Kutsva" bhodhi. PayPal inomira kwenguva shomanana kuti iwane database yayo isati yatumira web browser yako faira inonzi Downoad.csv. Chengetai izvi kudesktop yako kuitira kuti uwane nyore.
Vashandisi vakagadziridzwa kuverenga pamwechete neshoko iri vangave vatoziva kuti chii chaizvo chavanoda kuita nedhase iri padanho rino-kana iwe ndiwe, usununguka kutora kune mamwe maitiro (kufanana ne Quicken kana Quickbooks mafomu) kana kuti urege kubva pane zvinotevera nzira.
Kuisa Files CSV KuExcel
Iye zvino zvawakadhinda faira re CSV rine zvinyorwa zvekusarudza kwako uye faira yakachengetedzwa pane desktop yako, tevera matanho aya kutakura faira muExpcel.
- Kutanga Excel. Kana iyo CSV yefaira pakombiyuta yako ikozvino inenge yakafanana neExcel file (kureva iyo icon inomiririra faira inotarisa zvakafanana nemifananidzo yaunowanzoona yeExcel mafaira), unogona kungowedzera kaviri pafaira kuti uzarure uye vóila- waita! Vazhinji vashandisi vangawana, zvisinei, kuti CSV file haina kuzarura muExcel apo icon yacho inowanikwa kaviri. Kana uyu ndiwe, shandisa yako yekutanga menyu kuti utange Excel yekushanda.
- Sarudza "Firimu" menyu, uye sarudza "Vhura." Kana imwe nguva Excel yekushanda yakazaruka, chovha pane "Firipi" menyu kumusoro-kuruboshwe kwewindo uye sarudza "Vhura" sarudzo kubva pane zvakasarudzwa. Iwe unofanirwa kukwaziswa nediki duku rewindo remavheti rakanzi "Vhura" iro rinoratidza mafaira pane kombiyuta yako.
- Sarudza Desktop yako. Mumazuva ekupedzisira eEexcel, izvi zvinogona kuitwa kuburikidza ne "Desktop" icon kuruboshwe rwe "Open" dialog. Pakukura kwekare kweExcel, chengeta paIndaneti yekunyorera pasi pedyo nepamusoro kwewindo uye sarudza "Desktop" kubva kune yakareba mazita anzvimbo anowanikwa.
- Gadzira faira yepepa kune "Mafaira ose." Dzvanya pa "Files of type" pasi-pasi pasi pane pasi pehwindo uye shandura faira yefaira kubva "Excel files" kusvika "Mafaira ose." Izvi zvichaita kuti "Open" dialog iratidze chero mafayela CSV pakombiyuta yako.
- Dhinda kaviri pane "Download" file. Tsvaga iyo CSV file (inonzi "Download" kana "Download.csv" zvichienderana neshanduro yako yeWindows-unogona kutsvaga nepeji yefaira dzose padeskoni yako) pane urongwa hwemafayela akaratidzwa mu "Open" dialog uye kaviri-kanda pairi.
Ndizvo zvose zviripo kune iyo! Iwe zvino unofanirwa kuona sarudzo yakarongeka, yakarongeka yezvinhu zvako zvose zvePayPal zvabuda zvekare munguva ye Excel. Kana iwe uchiziva neExcel ikozvino, iwe unogona kukwanisa kuisa ruzivo urwu mumashandisi ako emari pakarepo kugadzirisa, kufuta, kuronga, kutsvaga, kana kuti zvimwe kushandisa MaPalPal marekhodi ako.
Cherechedza, zvakare, sezvakataurwa panotangira nenyaya ino matanho akafanana anogona kuteverwa kutumira mabhuku ako epa PayPal muOverOffice.org kana Quattro Pro. Ingova nekutumira kwekushanda kwespredishiti yako kana kuzarura "CSV" kana kuti "faira akaparadzanisa" faira.
Semashoko ekupedzisira, ramba uchiyeuka kuti kana iwe uchida kuramba uchishandisa ruzivo urwu, unofanira kunge uchirichengetedza zvakare kuExcel's standard format (kana chero chero yakasarudzika yako fashsheet inoshandisa) kuti zvive nyore. Kuti uite izvi, chengetedza pane "Firipi" menyu pane yepamusoro-kuruboshwe yeWebel yewindo uye sarudza "Save As" sarudzo. Zvadaro, sarudza "Microsoft Excel Workbook" kubva pane "Ratidza sewero" rondedzero rezasi-pasi pasi pezasi ye "Bhokisi reSearch" riri kuoneka.
Kufara mabhuku!