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/2009/10/04/ebay-fee-calculator-spreadsheet/

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

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

Version History

Version 1.7 (February 04, 2010)

• A "refund" column has been added where you can specify a full or partial refund
• The fees and profit for multiple quantity auctions are now more accurately calculated
• Negative Profit and Profit % amounts are now displayed in red

Version 1.6 (January 20, 2010)

• Added new field for Sales Tax %
• Added new option for "Default Starting Price"
• Added new option for "Default Commission" and "Default Commission %"
• Added new option for "Default Sales Tax %"
• Added option to choose whether to tax the item price or the item price plus the S&H charge
• You can now set End Price to $0.00 or Qty to 0 to specify that an item didn't sell
• Fixed bug that was causing "Start Price" and "Reserve Price" to appear grey/disabled when "Auction Format" was selected

Version 1.5 (January 11, 2010)

• Added separate monthly sales sheets and a new "Year to Date" overview
• Added new fields for Shipping Method and Tracking Number

Version 1.4 (December 09, 2009)

• Added a "Help" tab where I provide answers to the most frequently asked questions
• Added a new concept called "defaults" into the spreadsheet

Version 1.3 (November 27, 2009)

• A Quantity field was added for Stores and Fixed Price Listings
• New fields were added for your buyer's shipping address
• A new field for "percentage profit" was added
• If "Payment Type" is left blank, the spreadsheet will now assume it's a Domestic payment

Version 1.2 (November 14, 2009)

• Commission fields were added where you can enter optional consignment fees
• "Number of Items Sold" and "Sell-Through Rate" were added
• The "Edit Fee Rates" worksheet was re-designed to be easier to edit
• An Excel 2007 version of the spreadsheet was made

Version 1.1 (October 20, 2009)

• 3 sheets worth of data entry were converted into 1
• Moved Averages and Totals to the top
• Implemented "Auto Filter" functionality

Version 1.0 (October 4, 2009):

• Initial release