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 »

This spreadsheet helps you calculate how much it would cost to sell on PriceGrabber Storefronts. You simply enter the price of your item and you can see what your fees and profit would be in a Holiday or Non-Holiday period. For advanced users, there is a way for you to reverse calculate your fees to determine what amount to charge (or what to charge for S&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. You can also reverse calculate price or S&H for a large number of items at once using bonus "Markup" worksheet. If PriceGrabber 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 »