Today I've updated my eBay Sales Log spreadsheet to version 1.7. Here's what's new...

A "refund" column has been added
A "refund" column has been added where you can specify a full or partial refund you issued to a customer. If you've ever sold an item on eBay, then later had to issue a refund this column may help. All you have to do is enter the amount you refunded your customer in the "Refund" column. If you refund back 100% of your item's price, the spreadsheet will assume you went through the process of getting a FVF credit and will negate both your Final Value Fees and your PayPal fees. If you only issued a partial refund the spreadsheet will assume you clicked the Issue Partial Refund button in PayPal and will credit back some of your PayPal fees. If you didn't issue a refund you can either enter $0, leave it blank or hide this column completely. I've also added a new section to the "Year To Date" worksheet which totals up all your refunds for the year.

The fees and profit for multiple quantity auctions are now calculated more accurately
If you're using an older version of the spreadsheet and noticed your profit amounts weren't looking quite right for multiple-item Fixed Price and Stores items that's been fixed in this version. Multiple quantities are now more accurately calculated in both the monthly tabs and the "Year To Date" worksheet.

Negative Profit and Profit % amounts are now displayed in red
I've also made a slight change so that now both negative profit amounts and negative profit percentages are displayed in red.

If you've already purchased the spreadsheet you can download the new version at:

http://www.rolbe.com/download/

It will say version 1.2 (because that's the version of the main spreadsheet), but if you download it you'll find version 1.7 of the Sales Log included in the ZIP file.

If you haven't purchased the spreadsheet yet you can do so at:

http://www.rolbe.com/2010/03/07/ebay-spreadsheet/

You can also find additional help by reading my User Guide at:

http://www.rolbe.com/guides/ebay_spreadsheet/index.html