How to Download eBay Transaction Information from PayPal - dummies

How to Download eBay Transaction Information from PayPal

By Marsha Collier

PayPal makes recordkeeping for your eBay auction business a snap. A brilliant feature of PayPal is that you can download your sales and deposit history to your computer. Although PayPal also offers files that integrate with QuickBooks, the standard downloads are rich in features. Rather than importing just sales figures, you see each and every detail of your transaction — dates, names, addresses, phone numbers, amounts, and more. Even fees and taxes (if you charge sales tax) are broken down separately. The download imports into Microsoft Works and Excel.

Downloading your history can help you calculate income taxes and sales taxes, reconcile your accounts, predict sales trends, calculate total revenues, and perform other financial reporting tasks. It will also give you an excellent customer database. The deposits download gives you detailed information for all the deposits that you receive: payments, PayPal transaction and deposit fees, refunds, rebates, and any adjustments made to your account.

Follow these steps to download your sales and deposit histories:

  1. On your PayPal Account Overview page, hover the mouse pointer over the History tab.

  2. From the drop-down menu that appears, click the Download History link.

  3. Enter the time span and the file format for the information you want to view.

  4. Click the Download History button.

    The information appears on the screen. Or if the servers are busy, you’ll receive an e-mail (usually in a minute or two) when the reports are ready.

  5. Save the file in a directory that you can access conveniently for bookkeeping.

You can just double-click the file to open it in Excel or Microsoft Works. You now have all the information you could possibly need to apply to your bookkeeping program.

This information is excellent backup in case of a tax audit. Download this data every quarter and once on December 31 to be sure you always have up-to-date information.