Ukuhlaziya iiRekhodi zakho ngePallaPal kunye ne-Excel

Yenza ukugcinwa kwe-eBay ukugcinwa kwe-snap usebenzisa iimpawu ze-PayPal

Ukuba ungumthengisi we- eBay nanoma yiliphi ixesha elisazi ukuba i- PayPal yindlela enhle yokwamkela iintlawulo kwi-intanethi-iyashesha, kulula, kwaye i-PayPal igcina iirekhodi ezicwangcisekileyo zentengiselwano ezigqitywe ngale ndlela. Enyanisweni, unako ukufikelela kule ntsebenzo kwifom efanelekileyo, ifomathi ekulungele ukusabalalisa ukuziphatha kwakho -kuba ngaba ungumthengi, umthengisi, okanye zombini, akufanele usebenzise iwebhusayithi yePayPal ngqo ukufikelela irekhodi yonke intengiso.

Ukudibanisa neprogram yepredishithi njenge-Excel, le nxalenye ye-PayPal inokwenza ukugcinwa kweencwadi kubathengi abancinci nabangaphakathi-mali kunye nabathengisi isahluko sekhekhe-ingakumbi ukuba uqaphele ukusebenzisa i-PayPal ubuninzi bemisebenzi yakho.

Ukusebenzisa i-Excel ukufikelela kwiiRekodi zePayPal

I-PayPal yenza i-database yayo yokuthengiselana kwakho ifumaneke kuwe kwifomathi ebizwa ngokuba ngu-CSV, okanye "amaxabiso ahlukeneyo ngama-comma." Izicelo ezininzi ze-spreadsheet ezifana ne-Excel, i-Quattro Pro, okanye i-OpenOffice.org Calc-ezifanayo ukuba ungasebenzisa ukulinganisela i-checkbook yakho okanye wenze iirhafu-zikwazi ukufunda nokuthumela ifayile egcinwe kule fomethi.

Ngenxa yokuba i-PayPal inokudala iifayile ze-CSV ngokusekelwe kumanqanaba omhla, ungasebenzisa i-PayPal ukuvelisa ulwazi oluchanekileyo, oluchanekileyo, olupheleleyo nolwazi olupheleleyo (kubandakanya iifayili ze-PayPal , ukuthunyelwa kunye nokuphatha amanani kunye nezinye iinkcukacha) malunga nokuthengiswa kwe-eBay ongayigcina kwikhompyutheni yakho kwaye usebenze kwisicelo sespredishithi, umzekelo, ukuhlenga uhlobo lokuthengisela okanye ufumane iitatisti ezikhawulezayo ngenjongo yentlawulo.

Ukudala ifayile ye-CSV usebenzisa i-PayPal

Ukwenza ifayile ye-CSV yeentlawulo zakho ze-PayPal, ungene kwiwebsite ye-PayPal njengoko uza kubeka i-akhawunti yakho ngokuqhelekileyo. Emva kokuba ungene ngemvume kwaye ukhangele i-Akhawunti "yam Akhawunti," landela amanyathelo:

1. Cofa "Imbali." Cofa kwikhonkco ebomvu nelomhlophe "Yembali" kufuphi nomgangatho ophezulu wephepha. (Isicatshulwa: sisekunene kwekhonkco elithi "Phuma".)

1. Khetha uhla lwexesha. Sebenzisa izixhobo kwindawo ephezulu yekhasi ukukhetha uluhlu lwexesha lokuthengiselana ukubonisa. Unokukhetha izicelo eziqhelekileyo njenge "Iveki yokugqibela" (kuzo zonke iintengiso kwiintsuku ezisixhenxe ezedlulileyo) okanye "Inyanga yokugqibela" (kuyo yonke into eyenziweyo kwiintsuku ezingama-30 zokugqibela), okanye ukhetha ukubonisa uluhlu oluthile lomhla.
2. Cofa iqhosha "CSV". Cofa iqhosha le "CSV" ukuya ngasekunene kwegama elithi "Landa:" kwindawo ekunene yendawo yokubonisa. I-popup iya kubonakala ikucela ukuba ukhethe ifomathi yokulanda.
3. Cofa iqhosha elithi "Landa". Ngaphandle kokutshintsha uhlobo lwefayile kwi "CSV," cofa iqhosha elithi "Landa" iqhosha. I-PayPal iya kumisa ixesha elifutshane ukufikelela kwisiseko sayo sedatha phambi kokuba uthumele isiphequluli sakho sewebhu ifayile ebizwa ngokuthi i-Downoad.csv. Gcina oku kwidesktop yakho ukufikelela lula.

Abasebenzisi abaphambili befunda kunye nale nqaku banokukwazi ukuba yintoni kanye abafuna ukuyenza kunye nedatha kweli nqanaba-ukuba ngaba nguwe, zikhululeke ukukhuphela kwamanye amafomathi (afana neFomen Quick or Quickbooks formats) okanye uphambuke kule ilandelayo inkqubo.

Ukungenisa iifayile ze-CSV kwi-Excel

Ngoku ukuba ulayishe ifayile ye-CSV equkethe ukuthengiswa kokukhetha kwakho kunye nefayile igcinwe kwideskithophu yakho, landela le nyathelo ukulayisha ifayile kwi-Excel.

1. Qalisa i-Excel. Ukuba ifayile ye-CSV kwi desktop yakho ibonakala ifana nefayile ye-Excel (oko kukuthi i icon emele i fayile ibonakala ifana neefayile ozibona ngokuqhelekileyo kwiifayile ze-Excel), unokwesibini ucofa kwifayile ukuyivula kunye ne-vóila- uyenziwe! Abasebenzisi abaninzi baya kufumana, nangona kunjalo, ukuba ifayile ye-CSV ayiyi kuvula ngokuzenzekelayo kwi-Excel xa i-icon ibinqakraza kabini. Ukuba nguwe, sebenzisa imenyu yakho yokuqalisa ukuqalisa isicelo se-Excel.

1. Khetha i "Fayile" kwimenyu, bese ukhetha "Vula." Emva kokuba isicelo se-Excel sivulekile, nqakraza kwimenyu ethi "Ifayile" kwindawo ephezulu engasese ewindow uze ukhethe okukhethwa kukho "Vula" kwiluhlu lokukhetha. Kufuneka ubingelelwe ngefestile encinci yefayile yencoko ebhalwe ngokuthi "Vula" ebonisa iifayile kwikhompyuter yakho.
2. Khetha ideskithophu yakho. Kwiinguqulelo zakutshanje ze-Excel, oku kuya kwenziwa ngokuchofoza kwi-"Deskripthi" icon kwicala lasekhohlo "Incoko". Kwiinguqu ezidala ze-Excel, nqakraza kuluhlu lokuhlahla indawo kwindawo ephezulu yefestile uze ukhethe "Idesktop" ukusuka kwiluhlu olude lweendawo ezibonakalayo.
3. Setha uhlobo lwefayile kwi "Zonke iifayile." Chofoza kwi-"Uhlu lweloluhlu" lwezantsi lwefestile uze utshintshe uhlobo lwefayile kwi "Excel files" ukuya "Zonke iifayile." Oku kuya kwenza ukuba incoko ye "Vula" ibonise nayiphi na ifayile ye-CSV kwikhompyutha yakho.
4. Chofoza kabini kwifayile ethi "Layisha". Fumana ifayile ye-CSV (ebizwa ngokuthi "Landa" okanye "Landa i-Vs.csv" kuxhomekeke kwinguqulo yakho yeWindows-unokufuna uphendule uluhlu lwazo zonke iifayile kwikhompyutha yakho) kwiluhlu lweefayile eziboniswe kwingxoxo ethi "Vula" kwaye nqakraza kabini kuyo.

Kukho konke okukho kuyo! Kufuneka uqale ubone uludwe oluhlelekile nolulungelelanisiweyo lwazo zonke iintlawulo zakho ze-PayPal zakutshanje kwi-Excel. Ukuba uqhelane ne-Excel sele sele ufanele ukwazi ukubeka le ngcaciso kusetyenziswe kwiirekhodi zakho zezimali ngokukhawuleza ukucwangcisa, ukucoca, ukulungiselela, ukukhangela, okanye ukutshintsha iirekhodi zakho ze-PayPal.

Qaphela kwakhona, njengoko kukhankanywe ekuqaleni kweli nqaku amanyathelo afanayo anokulandelwa ukuba afake iirekhodi zakho ze-PayPal kwi-OpenOffice.org okanye kwi-Quattro Pro. Sine-importsheet yokungenisa isicelo sakho okanye uvule "i-CSV" okanye "iifayile ezihlukeneyo zeefayile".

Njengengxelo yokugqibela, khumbula ukuba ukuba ufuna ukuqhubeka usebenzisa le ngcaciso, kufuneka ukuba uyilondoloze kwakhona kwifom ejwayelekile ye-Excel (okanye nayiphi na ifomathi esemgangathweni ifayili yakho isebenzisa) ngokulula. Ukwenza oku, nqakraza kwimenyu ethi "Ifayile" kwiphepha eliphezulu elingasese kwikhompyutha ye-Excel kwaye ukhethe inketho ethi "Gcina njenge". Emva koko, khetha "iMicrosoft Excel Workbook" kwi-"Save as type" uluhlu lokuhlalisa phansi ngaphantsi kwebhokisi ethi "Gcina njenge" ebonakalayo.

Ukugcinwa kwencwadi!