User Guide for Easy Auctions Tracker: The Ultimate eBay Spreadsheet!

You must FIRST complete the steps located on the Setup & Instructions tab of your spreadsheet to ensure it is properly setup (to enable macros, create your authentication token, etc.). The information below will NOT work if your spreadsheet is not properly setup first.

You will be pulling all of your transaction data into the eBay Spreadsheet tab. This will be the tab that you use most often.

Select the "eBay Spreadsheet" tab near the bottom of your screen. All of the controls to import your transaction information are located on this tab.

The two methods of importing your data are described below:

 

 

      1.    To import your transaction information for an entire month, select the Month, Year and User for which you want to retrieve your sold & unsold items. (This was the month the listing was last modified, such as shipped or feedback left/received for the item.)

     

      Then click on the "Get All Items" button. Please note: sold items which have been marked as shipped in your eBay account and unsold items will be pulled into the spreadsheet.

 

 OR  

2. To retrieve just a single item, select the Month, Year and User for which you want to retrieve your sold items. Then click on the "Get Item" button. Note: Unsold items are only retrieved when the "Get All Items" button is used (as shown in step 1 above).

Finally, verify the retrieved information against eBay's records in My eBay, Selling Manager, etc.

Be sure 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).

eBay stores your transaction information on its servers for 3 months, with the exception of the buyer’s e-mail address. eBay only provides the buyer’s e-mail address for 2 weeks after the date the item is sold. All requests made after that time will show as “Invalid Request” in your spreadsheet.

You can pull your transactions into the spreadsheet as often as you'd like, even daily or a few times per day. When the application is running, it checks to see which transactions are already there, so that you don't get duplicates.  Just remember that when you click on the "Get All Items" button, only sold items which have been marked as shipped in your eBay account and unsold items will be pulled into the spreadsheet. Items that have not yet shipped will not be pulled into the spreadsheet until they are marked as shipped.

All of your transaction data will automatically be pulled into each monthly tab (Jan. ’09) as well as the 2009 Summary, the Profit Chart tab, and the Donations tab (if you did any charity listings through MissionFish).  Do not manually add any info. into these tabs as they are pivot tables and automatically pull the info. from your eBay Spreadsheet tab for you.

---

How to Manually Add Items to Easy Auctions Tracker

If you sell on other sites or even on Craigslist, you may want to keep all of your transaction data together by manually adding that transaction info into the spreadsheet. Additionally, the only two items our spreadsheet does not take into account are the eBay store monthly fee (if you have an eBay store) and PowerSeller discounts. You can add these manually by following these steps:

-go to your eBay Spreadsheet tab
-go to a blank row
-right-click and choose "EasyAuctionsTracker" then "Manually Add Item"
-fill in the title (such as January Powerseller discount or January eBay Store Fee)
 -fill in the amount of the Refund (for PowerSeller discount) or Additional Payment for eBay store -fee (put an additional payment/eBay store fee in as a negative number)
- fill in the date for the Date Sold
-click on "Add Item" at the bottom

The information you just added will go to the bottom of the list of transactions on the eBay Spreadsheet tab. The next time you retrieve your transactions (by clicking on the "Get All Items" button), this manually added item will be sorted by the date in the "Date Sold" column.

---

Important Note: **Easy Auctions Tracker is not web-based, nor is your information saved anywhere outside of your computer. We highly recommend that you back up your file monthly (or more often if you choose) on an external hard drive (such as a thumb drive, etc.) to avoid data loss. We will not be able to be recreate your data.**

 For information on how Trading Assistants can use Easy Auctions Tracker, please visit our Trading Assistants page at http://www.EasyAuctionsTracker.com/TA.html

  

 Download Your Trial & Get Started Today!

Advantages of Using EasyAuctionsTracker:

Our spreadsheet application has been Tested & Certified by eBay!
 

 

Save Time with Automated Data Collection!

Avoid Manual Data Entry Errors!

Keep Your Records Organized!

Quick Invoicing for Trading Assistants!

Download Your Trial & Get Started Today!

 

Listen to our interview with Danna Crawford from PowerSellingMom.com!