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.

Monthly Tabs
2. I've been receiving a number of comments lately from sellers saying they would like to more easily be able to see their totals for the month and the year so I've decided to make a change. Now, instead of one sales log spreadsheet, you have 12, one for each month of the year. Each month is now on it's own tab. To enter your sales for January just click on the "Jan" tab, to enter your sales for February, just click on the "Feb" tab and so on.

Because each month is on it's own tab it's now really easy to see your averages and totals for just that month.

Year To Date Overview
3. I've also added a brand new tab to the spreadsheet called "YTD" which stands for "Year To Date". By clicking on the "Year To Date" tab you can see all of your total income and expenses (including all of your eBay and PayPal fees) for each individual month and for the year in total. Nothing on this tab has to be entered manaully. All of the numbers you see are automatically calculated for you.

I've also included a field for "Misc. Expenses". If you have any miscellaneous monthly expenses (such as the eBay Stores monthly fee), you can enter it here to account for it in your net profit amounts.

Your total Net Profit for the month and the year will be calculated, and your percentage Net Profit for the month and year will be calculated as well.

Below that I've also added a nice color-coded chart showing your total income, your total expense, and your total profit for each month of the year. The chart automatically updates itself. All you have to do is enter your sales in the monthly sales sheets and the chart will automatically be updated.

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.5 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/

Version History

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 new "Help" tab where I provide answers to the most common questions I've been
getting about the spreadsheet

• Added a new concept called "defaults" into the spreadsheet. So, for example, rather than having to type in "Qty 1" over and over again for each and every item you sell (specifying that you're selling a quantity of 1) you can simply set a default quantity of 1. That way, if you leave the Qty field blank (or hide it completely) it will assume a quantity of 1 for each item sold. I've added defaults for "Category", "Listing Format", "PayPal Payment Type", and "Quantity".

To use the new "defaults" feature:

1. Click on the Format Menu, then click Sheet, then click Show...
2. Choose the Edit Fee Rates worksheet and click OK
3. Look in the top right corner for these new options...

Default Category
Here is where you can choose a default category for your items. If you only sell in one category you would just choose that category here and then hide the Category column in the main spreadsheet

Default Format
Here is where you can choose a default listing format for you items. If you only sell in one listing format (for instance, "Auction Style") you can just choose that format here and then hide the Format column in the main spreadsheet.

Default PP Type
Here is where you can choose a default PayPal Payment Type (either Domestic or Cross-Border). If you only receive Domestic payments you can just set this to Domestic and then hide the Payment Type field in the main spreadsheet.

Default Quantity
Here is where you can enter a default quantity to use if you leave the Qty field blank in the main spreadsheet.

If you click on the names of any of these options in the spreadsheet a little note bubble should pop up explaining it in more detail. You can also find note bubbles by clicking on any of the column names in the main spreadsheet.

In the "Edit Fee Rates" worksheet you can also set your PayPal Monthly Sales Volume (which affects your PayPal fees) and your Powerseller DSR (if you want to apply a Powerseller discount).

Once you're done making your changes, click on Format --> Sheet --> Hide to hide the "Edit Fee Rates" worksheet so it doesn't show up when printing.

Version 1.3 (November 27, 2009)

• A Quantity field was added for Stores and Fixed Price Listings. This calculates your PayPal fees on the total amount received (for instance, $5 per item x 3 items = one $15 payment) and calculates your Final Value Fees for each item sold ($0.60 FVF per item x 3 items = $1.80 Total FVF)

• New fields were added for your buyer's shipping address

• A new field for "Percentage Profit" was added
(It's auto-calculated and shows up next to your Profit)

• If "Payment Type" is left blank, the spreadsheet will now assume it's a Domestic payment (If you only receive Domestic payments, you can completely hide this column to save space)

Version 1.2 (November 14, 2009)

• Commission (%) and Commission ($) were added where you can enter optional consignment fees

• "Number of Items Sold" and "Sell-Through Rate" were added (which update automatically as you add items)

• 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
(It's now easier to customzie the spreadsheet by hiding and showing only the colums you want)

• Moved Averages and Totals to the top

• Implemented "Auto Filter" functionality. If you click on the "Auto Filter" button in OpenOffice.org you can now filter your transactions to only show records which meet certain criteria (for example, all items with a selling price of greater than $10, or all items which didn't sell). You do this by pressing the little down arrow next to the column name you want to filter on.

Version 1.0 (October 4, 2009):

• Initial release