This spreadsheet helps you calculate how much it would cost to sell on eBay Australia. You simply enter the price of your item and you can see what your fees and profit would be in any of eBay's listing formats including Auction/Fixed Price, eBay Stores, Classified Ad, and Vehicles/Real Estate. For advanced users, there is a way for you to reverse calculate your fees to determine what amount to charge for your item (or what to charge for P&H) to receive the amount you want after fees. You can keep a record of your sales using the included Sales Log worksheet or print out a chart showing what your fees would be for common amounts using the included Fees Chart worksheet. You can also reverse calculate price or P&H for a large number of items at once using bonus "Markup" worksheet. If eBay ever changes their fees in the future (or you want to calculate the fees for another service) you can edit all of the fee rates used by the spreadsheet using the included "Edit Fee Rates" worksheet.
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 »