Getting connected to eBay
Once you download and open the eBay spreadsheet and display the Setup & Instructions tab. Follow the step-by-step instructions on this tab to link your account to eBay. (If you don’t see the tab, click on the left arrow located at bottom left corner of the spreadsheet. The Setup & Instructions tab is the first tab on the left.)
The security warning may not be displayed as shown on the Setup & Instructions tab, depending on the version of Excel you are using. The eBay spreadsheet uses macros to download your eBay data, and they have to be enabled.
If the “Create Token” window is displayed when you click on the button to create your Authentication Token in step 2, your macros are running and you can continue through the setup process. If it does not, macros are most likely disabled if the “Create Token” window is not displayed. Please visit this Microsoft page to get the instructions to enable macros for your version of Excel:
Important: Be sure that you don’t click on anything or change tabs while data is being retrieved and entered. When the spreadsheet is finished pulling your items from eBay, the system messages box will read:
“Select Jan/Apr/Jul/Oct, 2021 & User. Click on ‘Get All Items’ for the first few weeks of that month’s items OR insert Item No. and click on ‘Get Item’ for a single item.”
After you have downloaded the data for your transactions, you will just need to put in your cost into the “My Cost” column as a negative number as well as the Actual Shipping Cost (also as a negative number).
When you purchase the Full Version: You will be emailed your Unlock Key. In Step 7, you will need to enter this Unlock Key, which will fully unlock your spreadsheet for use throughout 2021.
Easy Auctions Tracker – eBay Spreadsheet Users
I just purchased the Easy Auctions Tracker eBay spreadsheet. What can I say but THANK YOU! I used to do my accounting manually and it just chewed up the clock and was aggravating. I tried another eBay spreadsheet program but ran into problems with it. So, I gave this product a try. Oh my God….it has so many features that it will take me a lifetime to know how to use everything they created here. The support is fantastic and I am looking forward to learning more about all this software can do. Now, I think, with all of the time I will be saving I will take a much-needed vacation! Thank you again!
Easy Auctions Tracker is so easy to use, accurate & a huge time saver. My accountant was also thrilled with it. The support team is fabulous! Jen & Josh are quick to respond and help with any questions or concerns. I would highly recommend Easy Auctions Tracker to any and all Ebay sellers. Words could not express how thankful I am.
I am so pleased with every aspect of the Easy Auctions Tracker Spreadsheet! It is so incredibly easy to use, yet keeps track of all aspects of my eBay business. Providing my accountant with my end-of-the year information is not at all stressful because it is all right there! I am particularly impressed with the technical support that I have received. Whenever I have a problem, it has been resolved quickly and professionally. The Easy Auctions Tracker is a wonderful product at a very reasonable price.
I have been using the easyauctiontracker for two years and could not live without it. It has made my bookkeeping for our eBay business so easy. Jen in support is amazing. She is always quick to respond to my inquiries. My PC crashed and she worked with me to retrieve my worksheet I could not have asked for a more patient and knowledgable support person. Thank you Jen!!
Easy Auctions Tracker is an eBay seller’s accounting dream! With a few clicks you can be looking at all your eBay sales data, costs and even keep track of your commissions.
When I started selling on eBay full-time, I analyzed several different tracking systems, as well as using Quick Books or similar software.
Many were too complex and had too many options for a basic “one venue” eBay seller. This spreadsheet by far, will provide everything needed for an eBay seller to keep up with all sales details. My end of month is now a breeze compared to what it could be!!
Thank you Easy Auctions Tracker for this wonderful service to the eBay community!!
This has got to be the BEST eBay accounting tool ever! I’m not the most computer literate guy around so I had several questions during my learning curve. Every question I sent in was answered quickly and in terms even I could understand and follow!
The consignment feature of the program is worth twice the price by itself!
Before discovering Easy Auctions Tracker, I went through 4 or 5 steps for each listing figuring expenses, profit margins, consignment fees, etc. Now it’s just download, enter cost and shipping (or consignor info) and “PRESTO” it’s done!
I don’t know enough adjectives to describe how happy I am with Easy Auctions Tracker! THANK YOU!
“I’ve been searching for a user friendly, FAST and ACCURATE way to do month end figures. Most importantly, something I can share with my subscribers that I personally love to use. This is not only perfect for the fellow eBayer, it’s perfect for Trading Assistants as well.
Easy Auctions Tracker has by far outweighed any spreadsheet I’ve purchased or created in the past. I’m totally hooked. I LOVE IT
It will make your life so much easier. Thanks for your hard work!”