A domain portfolio report is a list of your domains with the details a particular reader needs, and the right columns depend on who is reading it. At a minimum, include the domain, registrar, expiry date and auto-renew status. Add renewal costs and a 12-month budget for whoever pays the bills, purchase price, value and return on investment for investors, and hosting, DNS and SSL details for clients or technical staff. Send it as a PDF when people need to read it and as Excel or CSV when they need to sort and total it.
A good report answers one question quickly, such as "what renews this quarter and what will it cost?" A bad one dumps every field for every domain and leaves the reader to work it out. Below are the report types worth having, what goes in each, and how to produce them.
Five reports most portfolios need
| Report | Who it is for | Key columns | How often |
|---|---|---|---|
| Expiring soon | Whoever renews domains | Domain, expiry date, auto-renew, registrar, renewal cost | Monthly |
| Renewal budget | Owner, finance, manager | Month, domains renewing, total cost | Quarterly or yearly |
| Investment summary | Domain investors | Purchase price, renewals paid, offers, sale price, profit, ROI | Quarterly or yearly |
| Client report | Agency clients | Domains, expiry, hosting, SSL expiry, nameservers | Quarterly |
| DNS and nameservers | Technical staff, auditors | Domain, nameservers, key DNS records | Before changes, yearly |
Expiring soon report
This is the report that prevents outages. Filter to domains, and SSL certificates if you track them, expiring in the next 30, 60 or 90 days, sorted by expiry date. Include auto-renew status, and highlight anything with auto-renew off. Add the registrar so the reader knows where to go to renew.
Keep it short. If the report runs to several pages, narrow the window. A one-page list that is read is worth more than a complete list that is not. For the alerting side of this, see how to set up domain expiration alerts.
Renewal budget report
A month-by-month table of renewal costs for the next 12 months. The total for the year matters, but the monthly breakdown matters more for cash flow, because renewals tend to bunch up in the months when most domains were originally registered. Include a note of any known price increases. Our domain renewal budget guide covers how to build one.
Investment summary report
For investors, the report that matters is return per domain and per portfolio. Include:
- Purchase price and date
- Total renewals paid so far
- Any offers received and parking income
- Sale price for sold names
- Profit and return on investment
- For-sale status and asking price
Sort by ROI or by holding cost to see which names carry the portfolio and which only cost money. Our guide on calculating domain investment ROI explains the formulas. Export this one to Excel so you can sort and total it yourself, or hand it to an accountant.
Client report
Agencies and freelancers who manage domains for clients benefit from sending a short, branded report each quarter. It shows the client what you are looking after, flags anything they need to approve, such as a renewal or an expiring certificate, and reminds them who to call if something breaks. Include:
- The client's domains, one per row.
- Expiry dates and auto-renew status.
- Where each domain's website and email are hosted.
- SSL certificate expiry for each site.
- Any action needed, with a date.
Send it as a PDF with your logo. Leave out internal notes, account names and costs unless the client pays for domains directly. For more on running client domains, see how agencies can manage client domains.
DNS and nameservers report
A record of each domain's nameservers and main DNS records. It is not exciting reading, but it is exactly what you need before moving a website to a new host, during an audit, or when something changes unexpectedly and you need to know what it used to be. Save a copy each time you produce it, so you build up a history.
Choosing the right format
| Format | Best for |
|---|---|
| Clients, managers, anyone who will read but not edit | |
| Excel (XLSX) | Investors, finance, anyone who will sort, filter or total |
| CSV | Importing into other tools or databases |
| Word (DOCX) | Reports you want to add commentary to before sending |
| HTML or text | Pasting into an email or keeping a plain archive |
| Meetings, filing, or a paper copy for audits |
Tips for reports people actually read
- Put the answer first. Sort by the column that matters, usually expiry date or ROI.
- Cut columns. Five or six well-chosen columns beat twenty.
- Highlight exceptions, such as auto-renew off, an unlocked domain or an expired certificate.
- Date the report, so nobody acts on stale information.
- Keep the same layout each time, so readers know where to look.
A simple monthly routine
- Refresh expiry dates and statuses for every domain, so the report reflects today.
- Produce the expiring soon report for the next 90 days and act on anything with auto-renew off.
- Check the renewal budget for the coming month, so the payment card has room.
- Once a quarter, add the client reports and the investment summary.
- Once a year, produce the full portfolio and DNS reports as part of your audit, and file them.
Building reports from a spreadsheet versus a domain manager
You can build all of these reports in a spreadsheet, but only if the data in it is current, and keeping expiry dates, statuses and nameservers up to date by hand is the hard part. Names Organizer, a domain manager for Windows, fills in that data from WHOIS and RDAP and keeps it current with a refresh. It includes ready-made reports for expiring soon, full portfolio, renewal budget, investment summary, client report, availability results and DNS and nameservers. You can also choose the domains, all, filtered or hand-picked, and the columns yourself. Every report can be printed or saved as PDF, Word, Excel, CSV, HTML or text, and you can save report layouts for next time. For client reports, Names Organizer adds your own logo, so the PDF is ready to send.
Frequently asked questions
What should a domain portfolio report include?
Domain, registrar, expiry date and auto-renew status as a minimum, plus costs and value for investors or hosting, DNS and SSL details for clients.
What format should I send a domain report in?
PDF is best for clients and managers, while Excel or CSV suits investors and accountants who want to sort and total figures.
How often should I produce a domain report?
Monthly for expiring domains, quarterly for clients and yearly for a full portfolio and investment review.
