Over the last few weeks I've been making numerous upgrades and improvements to my eBay spreadsheet and today I'm glad to finally announce the release of version 1.5. Here's what's new in this version.

Support for older versions of Excel
Prior to version 1.5 I had an OpenOffice.org version and an Excel 2007 version. That means the spreadsheet could be opened in either OpenOffice.org (any platform) or Excel 2007 (PC) or Excel 2008 (Mac). However, I received numerous e-mails from sellers who told me they couldn't open the spreadsheet because they were still using Excel 97-2003. These older versions of Excel have technical limitations and couldn't understand my long advanced formulas. In version 1.5, I re-wrote a lot of the formulas using a different method and now the spreadsheet will work perfectly in any version of Excel. It will also now work on any spreadsheet program on any type of computer that can open an .XLS file (for instance, Numbers for the Mac). When you download the spreadsheet you will now be given 3 versions:

	OpenOffice.org Version (.ODS)
	Excel 2007 Version (.XLSX)
	Excel 97-2003 Version (.XLS)

You can choose to use whichever version you feel most comfortable with and delete the other two.
Read the rest of this entry »

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.

Read the rest of this entry »

Today I've updated my eBay Markup spreadsheet to version 1.3. The purpose of the markup spreadsheet is to tell you what to charge for your items (or what to charge for S&H) to receive the amount you want after fees for a large number of items at once. Here's what's new in version 1.3. (See Screenshot).

Added option for PowerSeller Discount
With this version you now have the option of including a PowerSeller Discount (which provides a 5% to 20% discount off your Final Value Fees). All you have to do is select your PowerSeller Discount level from a list and the correct Final Value Fee discount will be applied.

Read the rest of this entry »

Today I've updated my eBay Sales Log spreadsheet to version 1.6. Here's what's been added.

New field for Sales Tax
I've added a new option for Sales Tax. If you charge sales tax on eBay you can now enter the tax percentage you charge in the Tax % column. The yellow column is where you enter your tax rate (for example 6%) and the red column is where you'll see the calculated tax amount show up. Since tax laws vary by state you are given the option of choosing whether to tax just the item price or the item price plus the S&H charge. If you don't charge tax you can either type 0% or leave this field blank.

Read the rest of this entry »

Today I've updated my eBay Sales Log spreadsheet to version 1.5. Here's what's been added.

New fields for Tracking Number and Shipping Method
1. I've added new fields for Tracking Number and Shipping Method. Now you can store which shipping method you used to ship your item (for example, USPS Priority Mail) and the tracking number of your package (if you have one). Both of these fields are completely optional. These new fields are right next to the fields for your buyer's name, address and eBay ID.

Read the rest of this entry »