Does anyone use an Access database or another application to track information on their properties, leases, production income, etc?
All of the applications I found are high end apps for oil companies. I need to manage the data for several, but not near enough to justify big dollars.
I am working with a friend who is a programmer/software engineer and we're talking about developing a program like you describe. The idea would be to make it low cost for individuals to purchase (with various data services and add-ons availalbe). Do you have any thoughts as to what you would look for in something like this? The application is just in the idea stage right now, and if we decide to proceed it would be a few months out.
IHS Energy is another source of well information, permits, drilling information, completion reports and monthly production volumes. Their site is set up to allow you to purchase as little as one specific bit of information on one well or all information available for the entire country. It’s searchable by many variables.
Sorry for the late reply. I was thinking about building something in access but it would be limited in some features. I was kind of hoping there was something already out there. My overall knowledge of this business is still somewhat limited so it would be a work in progress for some time.
Maybe a relational database with multiple tables.
Something showing ownership, legal description w/ sec, tier, range. Acres, Surface, mineral, depth. Purchase or acquisition info. Each parcel would need a unique id. Link to a documentation folder. ( I always resist storing the document directly in the DB.)
Bumped against a lease info table. Company name, Dates, options, price multiple parcel id to cross against, maybe an offer field to allow offers to show against a parcel and then change the status once exercised.
A production tying the above along with working and royalty interest info
Next a payments table would be needed both against the Lease and production (or parcel sales)
Reports showing what is not leased, expiring, etc.
Ability to export to quicken would be great.