eBay Sales Log Spreadsheet v1.5 Update
Posted January 11th, 2010 by Ryan Olbe Spreadsheet Updates Add commentsToday 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
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
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
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/2010/03/07/ebay-spreadsheet/
So much more elegant and functional than my own home-brewed Excel spreadsheet. Mine does the job, but I've been waiting for someone to do the heavy lifting. Looks like just what I hoped to find.
I do collect (and remit...) sales tax, but it does not apply to all sales. The monthly breakout feature is really important (thanks)--is there a column I can use for tax? Not to complicate things too much, there is a strong possibility I will need more than one tax column in the future. Right now, just one and you will have a very happy new customer.
Can I track a single sku as 1 item with multiple fees and eBay item numbers (from re-listing with different associated fees rather than running good til cancelled)?
TIA
In version 1.6 of the Sales Log I've added a new field for sales tax and provide monthly/yearly tax totals in the YTD worksheet. You can read more about the changes I've made in 1.6 here:
http://www.rolbe.com/2010/01/20/ebay-sales-log-spreadsheet-1-6/
As for keeping track of unsold items, right now you can either enter the item's Ending Price as $0 or set it's Qty to 0 to specify that it didn't sell. In the future I could add a SKU field. Do you just want the SKU field by itself or should it connect to something like an Inventory worksheet that records how many times each item was listed/sold?
Hello,
I've just come across your site and am just beginning selling on ebay. I've got about 1500 items to sell, about 400 unique items. I've gotten Auctiva and am using that service - I'm wondering if you have any functions that I can use to import my ebay/auctiva data into your spreadsheets for tracking, etc. If you have any suggestions of what I might use instead of Auctiva, I'd greatly appreciate that information as well. I'm most likely going to buy your spreadsheet anyways, but was wondering about that potential feature as Auctiva offers an export of .csv. Thank you!
Hi Emily,
I don't use Auctiva myself so you would have to e-mail me a sample CSV file of theirs so I can study their format in order to import it correctly. Importing data directly from eBay/PayPal is going to be the next big feature I add into the spreadsheet because A LOT of people have been asking me for it. I'm planning to release that in version 2.0. It's going to be an automated process, you click a button and your sales get filled in. For all the people who purchase the spreadsheet now it's going to be a free upgrade. For all new customers I'm going to be increasing the price of the spreadsheet because it's a complex feature to program. For now you can download your sales manually for eBay here:
http://cgi3.ebay.com/ws/eBayISAPI.dll?DownloadInvoice&invoiceMonthYear=&requestType=AccountStatus&StartDate=&EndDate=&cid=001
and manually for PayPal here:
https://history.paypal.com/us/cgi-bin/webscr?cmd=_history-download&nav=0.3.2
Both of which require you to log in first. The eBay download will include all the items you've sold on eBay. The PayPal download will include all the items you've sold on eBay plus any other miscellaneous PayPal payments you may have received.
Your calculators are AWESOME! Thanks so much. I cannot wait to see a Google Checkout one.
Thank you for the absolutely wonderful site. I am slowly delving into the online auction world. With the many types of fees associated along with different types of posting options; you have definitely took a lot of the work and confusion out of it for the intimidated and clueless-like me
I am somewhat OCD so not tracking sales, profit margins, ect. is not an option. Sadly enough the only auction experience I have had was on World of Warcraft. LOL Thanks again 