| 1888 Articles Home | Business Articles | Business RSS |  |
||
Streamline Your Records with PayPal and Excel |
||||
|
This article describes to streamline the record using paypal and exceld with enhanced features. |
||||||||||||
| Author: Murray |
|
|||||||||||
If you’ve been an eBay seller for any amount of time you already know that PayPal is a great way to accept payments online—it’s fast, it’s easy, and PayPal keeps meticulous records of transactions completed this way. In fact, you can access these transactions in a convenient, spreadsheet-ready format to streamline your accounting practices—whether you are a buyer, a seller, or both, you don’t have to use the PayPal website directly to access the record for every transaction. In combination with a spreadsheet program like Excel, this PayPal feature can make bookkeeping for small and medium-volume buyers and sellers a piece of cake—especially if you are careful to use PayPal for the majority of your transactions.
Using Excel to Access PayPal Records
PayPal makes its database of your transactions accessible to you in a format called CSV, or “comma-separated values.” Most spreadsheet applications like Excel, Quattro Pro, or OpenOffice.org Calc—the same ones that you may use to balance your checkbook or do your taxes—are capable of reading and importing files stored in this format.
Because PayPal can create CSV files for you based on the date ranges, you can use PayPal to generate quick, accurate, complete accounting information about your eBay transactions that you can then store on your own computer and manipulate in a spreadsheet application, for example, to sort by transaction type or get quick totals for tax purposes.
Creating a CSV File Using PayPal
To create a CSV file of your PayPal transactions, log into the PayPal website just as you would to view your account normally. Once logged in and viewing the default “My Account” page, follow these steps:
1) Click “History.” Click on the blue and white “History” link near upper center of the page. (Hint: it’s located between the “Withdraw” and “Resolution Center” links.)
2) Click “Download My History.” On the history page, click the “Download My History” link at the upper left of the page. Alternatively, you can simply visit the PayPal “Download My History” page directly.
3) Enter your desired dates. Fill out the form by selecting the “Custom Date Range” option, then entering beginning and ending dates for the transactions you want records for. Once you begin the download, PayPal uses these dates to determine which records to include—the file PayPal makes and sends to you will list all transactions you carried out between these dates.
4) Select “Comma Delimited — All Activity” as the file type. In the “File Types for Download” drop-down list, select the type of file you want to download. There are a number of options, including options for Quicken and Quickbooks files, but for our purposes in this article (interoperability with Excel), just select the first option, “Comma Delimited – All Activity.”
5) Click “Download History.” After you click on the “Download History” button near the bottom of the page, PayPal will pause for a few moments to access its database before sending your web browser a file called Downoad.csv. Save this to your desktop for easy access.
Source: Ebay
About Author
Hi, We deals in ebay and paypal business work and provides you with latest updates happening in online trading.
Article Source:
http://www.1888articles.com/author-murray-2672.html
Other Related Articles The facts that you should care about while taking cheap car loans by Joanne Clive Very Bad Credit Loans for people with damaged credit history by AntonGabriel Asset Business Finance for buying assets while you save cash by Richie Morgan Streamline Your Records with PayPal and Excel by Murray Take proper care of granite countertops by Agnesuma |
