Using Excel to Keep Sale Portfolios Updated

Keeping a portfolio updated on platforms like Sedo, Afternic, and Dan can be a challenge. With sales and expiries happening on a regular basis, it can be easy to fall behind on updates. It is important to keep these portfolios updated so you don’t accidentally sell a domain name you previously sold or let expire.

I try to keep my portfolio updated in real time. When I sell a name on Dan, for example, I try to immediately delete the listing on Sedo and Afternic. When I let a domain name expire, I remove the listing from all platforms once I receive the final cancelation email. They key word is *try* and names sometimes slip through the cracks. Every once in a while I will do a comparison of my sale portfolios against my inventory list.

I am not a pro at Excel, but I want to share a step by step guide for how I am able to identify the names I previously sold or let expire that I forgot to remove from sales platforms:

  • Step 1: Paste my current inventory list in column A of a new Excel spreadsheet.
  • Step 2: Export data from sale platform. There is a different method for each platform.
  • Step 3: Copy the domain names listed for sale and paste them into column B of the Excel spreadsheet.
  • Step 4: Highlight column A and B.
  • Step 5: On the Home section of the Excel spreadsheet, click “Conditional Formatting.”
  • Step 6: Select “Highlight Cells Rules” from the dropdown menu.
  • Step 7: Click “Duplicate Values.”
  • Step 8: From the dropdown menu, select “Format only unique or duplicate values” formatted with light red fill.
  • Step 9: Compare the sales platform portfolio to inventory.
  • Step 10: If a domain name from the sales platform portfolio does not have red fill (highlight), it means it is not in the inventory list. The means the domain name was sold, expired, or there is a typo on one of the lists.
  • Step 11: Delete any domain names that are no longer in inventory.

When I did this for my Sedo sales portfolio today, I found seven domain names listed for sale that should be deleted. Four had previously expired and three were about to expire. Importantly, this method requires that the inventory list is accurate.

Keeping a sales portfolio updated will help prevent a seller from selling a domain name that he or she no longer owns. There may be other better ways to do this, but this is how I do it.

Elliot Silver
Elliot Silver
About The Author: Elliot Silver is an Internet entrepreneur and publisher of DomainInvesting.com. Elliot is also the founder and President of Top Notch Domains, LLC, a company that has closed eight figures in deals. Please read the DomainInvesting.com Terms of Use page for additional information about the publisher, website comment policy, disclosures, and conflicts of interest. Reach out to Elliot: Twitter | Facebook | LinkedIn

8 COMMENTS

  1. It had been a while since I had used Excel and last week enumerating a part of the domain portfolio went well.
    There was still a lot to do, your post has gone very well.
    Thanks for sharing Elliott!

  2. I just download all the domains from my registrars, delete all the domains in Dan afternic sedo and let it sit empty for 2 days and upload the fresh domains back.
    Easy peasy
    Do that every 2 mths

  3. And I put all my domains at minimum offer at $4999 ,this is to avoid low ballers.
    The default is $20 and you gonna get spams
    I sold so my hand reg domains….

  4. Have you tried Domain.io? It does this for you — it monitors your portfolio by frequently checking the pricing on Dan/Afternic/Sedo and notifying you of any discrepancies. You can manage and adjust your portfolio pricing in one place and then export the individual CSVs to update Dan/Afternic/Sedo.

LEAVE A REPLY

Please enter your comment!
Please enter your name here

Recent Posts

Diamond.com Sold via Saw.com for 7 Figures

1
A little over a week ago, I came across Diamond.com, and I noticed its coming soon page. When I scrolled down, I saw a...

I Would Love to Go Back in Time

1
NameBio does a very good job of tracking down and reporting domain name auction results. Domain investors aren't the only people who use NameBio...

Dynadot Now Allowing Imported Leads

4
Domain investors have another option to transact domain name sales. Dynadot Founder and CEO Todd Han announced that Dynadot customers can now import their...

Challenge of Buying a Domain Name from a Big Company

1
There are many large companies that own domain names that aren't being used. This can be due to corporate acquisitions and mergers, killed products...

Hopeful New US Admin Will be Good for Domain Investments

8
As you know, the United States held its Presidential election yesterday, and Donald Trump won the election. In addition to this win, the Republican...