Extract detailed accounting data from My eBay, or do it automatically with eBay's Selling Manager.
Sellers pay the bills at eBay. Fees are assessed for listings and upgrades (see [Hack #36]), and eBay gets a percentage of the final value of each successfully completed auction.
Any eBay user can check his or her account by going to My eBay Accounts Account Status. The fees are broken down individually and cross-referenced by item number. So to see exactly how much a particular auction cost you, just search for the item number, add up the corresponding amounts shown in the Debit column, and subtract any corresponding entries in the Credit column.
A more convenient approach is to use a spreadsheet to organize the data. First, go back and turn off Pagination and choose the appropriate date range. Click Submit and save the resulting page to an HTML file (File Save As in your browser).
Open the page in a web-capable spreadsheet like Microsoft Excel. Highlight all the rows above the table (about 30 rows), and remove them (Edit Delete). Do the same for all cells below the table. Finally, sort the listing by item number. Select the entire sheet (Ctrl-A), go to Data Sort, choose "Item" in the first box, and then click OK.
It's not pretty, but it does the job in less than two minutes, and it's free.
For a monthly fee, you can have access to eBay's Selling Manager tool. Among other things, Selling Manager keeps an archive of past sales for up to four months, allowing you to download a sales history in a more convenient CSV (comma-separated value) format than the spreadsheet hack discussed earlier. CSV files can be easily imported into any spreadsheet, database, or accounting program.
Selling Manager simply appears as a tab in My eBay, replacing the Selling tab discussed in [Hack #65]. See Figure 7-5.
You can subscribe to Selling Manager by going to pages.ebay.com/selling_manager. eBay offers a free 30-day trial, and is even kind enough to remind you a few days before the trial period ends. Selling Manager can also be used for more general-purpose auction management, as discussed in [Hack #74].
If you prefer to do your accounting and reporting off-eBay, you can use Andale Reports (www.andale.com) or Auctiva eBud (www.auctiva.com), both of which offer some additional functionality at some additional cost.