Spreadsheet help

Does anyone have a spreadsheet to keep track of mineral rights? We own in several counties and am wondering what is the best way to keep track and organize companies, wells, leases and royalties digitally. Is there anything else we should keep track of? Thanks in advance for anyone sharing and helping.

I use Excel. I have found it useful to use different spreadsheets for different purposes. Here is a Composite list of tracts example and a Master Wells list example.

Composite Master Tract list template.xlsx (56.7 KB) Master Wells List Template.xlsx (16.9 KB)

3 Likes

You’ve several options, but it seems the right ™ approach is to view the parcels on a map. I Found https://www.earthpoint.us/TownshipsSearchByDescription.aspx useful for that.

https://www.energylink.com/ (now enverus.com?) is being used by lots of oil producers to record/handle payments. See if your companies use them. If so, then their partners(?) https://www.mineraliq.com/ has a free level of access that can map & (pretend) to show you your ‘valuation’. Its a nice start.

  • another newbie…

I have used a spreadsheet in Numbers for Macintosh for many years. Have found it is best to attach well name to company name since there is a great deal of company shuffling. This spreadsheet makes it much easier to use for my tax accountant.

This topic was automatically closed after 90 days. New replies are no longer allowed.