# Division Order Tracking Spreadsheet

**URL:** https://www.mineralrightsforum.com/t/division-order-tracking-spreadsheet/89631
**Category:** General Mineral Rights Discussion
**Created:** [October 6, 2026, 10:50pm UTC](https://www.mineralrightsforum.com/t/division-order-tracking-spreadsheet/89631 "2026-10-06T22:50:10Z")
**Posts on this page:** 8
**Page:** 1

<div class="post-metadata">

### Author: ![CSR30srlty](https://www.mineralrightsforum.com/letter_avatar_proxy/v4/letter/c/db5fbb/32.png) [@CSR30srlty](https://www.mineralrightsforum.com/u/CSR30srlty)
#### Post date: [October 6, 2026, 10:50pm UTC](https://www.mineralrightsforum.com/t/division-order-tracking-spreadsheet/89631/1 "2026-10-06T22:50:10Z")

</div>

I’ve recently uncovered and begun receiving Division Orders from three TX O&G operators coming from an inherited undivided nonparticipating royalty interest from my great grandfather. There are more to come as ownership is found and claimed. At this point, I really don’t know what I’m doing, but realize I quickly need to set up some kind of a spreadsheet to track the Division Orders as they are received. Is there an established template to use rather than creating one myself as I blindly stumble along, not really knowing what it needs to track at this beginning point? Or perhaps one you’ve created for yourself and would be willing to share to get me started? Thank you for any information that will point me in the right direction as I struggle through inputting data into Excel.

---

<div class="post-metadata">

### Author: ![M\_Barnes](https://www.mineralrightsforum.com/user_avatar/www.mineralrightsforum.com/m_barnes/32/10942_2.png) [@M\_Barnes](https://www.mineralrightsforum.com/u/M_Barnes)
#### Post date: [October 7, 2026, 12:41pm UTC](https://www.mineralrightsforum.com/t/division-order-tracking-spreadsheet/89631/2 "2026-10-07T12:41:09Z")

</div>

Here is a Division Order template with an example filled in. It is set up for OK, but you can expand Col K and add in Block, Abstract name and number and section for TX. I am also attaching a well list template and a master tract template. These will help you get started. As you find your ownership, collect your probate document, copies of leases, descriptions of the acreage, etc.

[\_Composite Division Order template.xlsx](https://www.mineralrightsforum.com/uploads/short-url/pWqbGSwitwE5VEMA5PA3SSVGT43.xlsx) (10.2 KB)

[\_Composite Master Tract list template.xlsx](https://www.mineralrightsforum.com/uploads/short-url/hNpNqYYUUYkVTLkgmB86TxfHWBe.xlsx) (57.2 KB)

[\_Composite Well List template.xlsx](https://www.mineralrightsforum.com/uploads/short-url/oRTfljvurkDMGNneVP5zxcwBCMk.xlsx) (10.2 KB)

---

<div class="post-metadata">

### Author: ![CSR30srlty](https://www.mineralrightsforum.com/letter_avatar_proxy/v4/letter/c/db5fbb/32.png) [@CSR30srlty](https://www.mineralrightsforum.com/u/CSR30srlty)
#### Post date: [October 7, 2026, 5:29pm UTC](https://www.mineralrightsforum.com/t/division-order-tracking-spreadsheet/89631/3 "2026-10-07T17:29:03Z")

</div>

Thank you so much - this will definitely get me started.

---

<div class="post-metadata">

### Author: ![MineralResearcher26](https://www.mineralrightsforum.com/letter_avatar_proxy/v4/letter/m/bc79bd/32.png) [@MineralResearcher26](https://www.mineralrightsforum.com/u/MineralResearcher26)
#### Post date: [October 9, 2026, 4:56pm UTC](https://www.mineralrightsforum.com/t/division-order-tracking-spreadsheet/89631/4 "2026-10-09T16:56:40Z")

</div>

The templates already shared look like a helpful starting point.

One additional consideration would be maintaining a reference to the underlying ownership documents supporting each interest, alongside the division order details.

Having the operator, well, legal description, decimal interest, effective date, and supporting documentation connected in one place may make future discrepancies much easier to investigate.

As additional interests are discovered, separating confirmed ownership information from items still requiring verification could also be valuable.

It’s often not just about tracking the information, but understanding how the pieces fit together.

---

<div class="post-metadata">

### Author: ![M\_Barnes](https://www.mineralrightsforum.com/user_avatar/www.mineralrightsforum.com/m_barnes/32/10942_2.png) [@M\_Barnes](https://www.mineralrightsforum.com/u/M_Barnes)
#### Post date: [October 9, 2026, 5:51pm UTC](https://www.mineralrightsforum.com/t/division-order-tracking-spreadsheet/89631/5 "2026-10-09T17:51:56Z")

</div>

I also have a running contact list of operators, their websites, phone numbers contact persons, issues being worked on, status, dates, etc.

---

<div class="post-metadata">

### Author: ![CSR30srlty](https://www.mineralrightsforum.com/letter_avatar_proxy/v4/letter/c/db5fbb/32.png) [@CSR30srlty](https://www.mineralrightsforum.com/u/CSR30srlty)
#### Post date: [October 9, 2026, 6:56pm UTC](https://www.mineralrightsforum.com/t/division-order-tracking-spreadsheet/89631/6 "2026-10-09T18:56:42Z")

</div>

Thank you! I spent yesterday trying to complete the templates with what little information I have at this point. Unfortunately, I only received 2 Division Orders with the legal description detail I need (out of their 11 DO’s) and I don’t understand what goes where so I have a lot to learn to fit the pieces together! I started out with the smallest operator thinking I’d learn from that one and could then move on to the larger ones, and I did reference the underlying ownership documents as well as keeping a running contact information list. I’m contacting Owner Relations today to request the detail on their other 11 DO’s.

I’m thinking that these templates might be more involved than what I actually need for my inheritance of _“undivided non-participating Royalty interest under one or more tracts described in the Ratification Exhibit enclosed (Chase Bank as Trustee of the Red Crest Trust, Lessor, and Whitmire Land Services Co., Lessee)”_. There’s more money to be found so I need to figure out what to do with it once I find it. Tax Day is looming!

---

<div class="post-metadata">

### Author: ![M\_Barnes](https://www.mineralrightsforum.com/user_avatar/www.mineralrightsforum.com/m_barnes/32/10942_2.png) [@M\_Barnes](https://www.mineralrightsforum.com/u/M_Barnes)
#### Post date: [October 10, 2026, 1:02pm UTC](https://www.mineralrightsforum.com/t/division-order-tracking-spreadsheet/89631/7 "2026-10-10T13:02:05Z")

</div>

You can change the templates to meet your needs. For Tax day, look for your 1099s for 2025.

---

<div class="post-metadata">

### Author: ![MineralResearcher26](https://www.mineralrightsforum.com/letter_avatar_proxy/v4/letter/m/bc79bd/32.png) [@MineralResearcher26](https://www.mineralrightsforum.com/u/MineralResearcher26)
#### Post date: [October 10, 2026, 4:40pm UTC](https://www.mineralrightsforum.com/t/division-order-tracking-spreadsheet/89631/8 "2026-10-10T16:40:49Z")

</div>

It sounds like you’ve put quite a bit of work into organizing everything, especially with multiple operators and incomplete documentation.

I’m curious — has the biggest challenge been locating the missing records, understanding how the different documents relate to your ownership, or simply keeping everything organized?

It seems like these situations can become complicated quickly, particularly when inherited mineral interests are involved.
