Consolidated Reporting for Mineral Assets

Why the portfolio system chokes

Modern family office reporting stacks assume custodied assets: a feed delivers positions and prices, the system reconciles, the book closes. Minerals have no custodian and no feed — the "positions" are decimals recorded in county courthouses, the "prices" are valuation judgments, and the income detail lives on check stubs the system never sees. Offices respond by entering minerals as a single alternative-asset line with a stale value and lumping receipts into other income — which produces a book that balances and a family that cannot answer what its minerals earned, by entity, last year.

The data model that works

Reportable minerals start with a property-level master: every interest, its legal description and decimal, the owning entity, the operator(s) paying on it, and the lease behind it. Monthly income then posts per property, per entity — gross, severance taxes, deductions, net — captured from the stubs at receipt. From that grain, everything the office needs is a rollup: income by entity for the accountants, by family branch for governance, by property for the inevitable "what is the ranch actually earning" question. Without the grain, every question is a research project; with it, every question is a filter.

The entity rollup problem

Family mineral ownership is rarely one owner — it is the FLP, two trusts, an LLC from the 2010 restructuring, and grandmother's estate, each receiving its own checks from overlapping operators. Consolidated reporting has to hold both truths: the legal separateness the CPAs and entity administration require, and the economic whole the family actually thinks in. The master inventory carries the entity dimension on every interest, so the same data answers the K-1 preparer at entity level and the principal at family level without either view being hand-built.

Valuation marks the system can defend

The minerals line needs a number, and "whatever it said last year" is not a methodology. Producing interests mark on income approaches — verified trailing revenue times a stated multiple reflecting decline and product mix; non-producing acreage marks on lease and sale comparables for the area. The standards are the same ones fiduciaries use (our valuation guide covers them in detail): stated method, stated date, consistent application, refreshed annually and on material events. A defensible mark turns the minerals line from an embarrassment into a position.

Surviving January: K-1s, 1099s, and the reconciliation

Year-end is where unmanaged minerals hurt most: 1099s arrive reporting royalties gross while the books hold net receipts, entities issue K-1s that depend on getting each entity's mineral income right, and the reconciliation between stubs, deposits, and tax forms consumes the controller's January. The fix is structural, not seasonal — when stub detail is captured monthly at the property-entity grain, the gross-to-net bridge already exists, each entity's totals are a report rather than a project, and the CPA receives a package instead of a shoebox. The operator's side of the same mechanics is covered in our 1099 reporting guide.

Build the feed, or buy it

An office can build this internally — a property master, monthly stub capture, entity rollups, valuation memos — and some do, at the cost of a person who could be doing something else. The alternative is engaging it as a service: Valor maintains the inventory, captures and verifies every stub, recovers what verification surfaces, marks the portfolio on a stated cycle, and delivers the data at whatever grain the office's systems consume — property, entity, or family rollup — through mineral.tech® and standard exports. The controller gets a feed where there was a drawer.