Acquisition Data Conversion: How to Read the Seller’s System Before You Close

What the Seller’s Data Actually Contains

An operator buys a field with confidence. The engineering is understood, the reserves are booked, the purchase price is defensible. Then the data room closes and the buyer finds that the well master, the allocation structure and every daily volume for the past several years live in a desktop database on somebody’s laptop. There is no schema documentation, no data dictionary, and the business rules sit inside embedded procedural code written by someone who left the company two years ago.

On a recent onboarding, a seller managed roughly 650 acquired wells this way. The database held the well master, the allocation structure and the daily volumes. It also held a second layer that had never been written down: which producers roll to which collection point, how a well that changed status mid-month is handled, what the period-end macro does on the last day of the month.

That second layer is the valuable part. It does not appear in the purchase and sale agreement, and it does not appear in the engineering report. It exists as system behavior, and behavior has to be observed before it can be reproduced.

The Operating Decisions Hidden Inside the Data

The well master alone forces a decision most acquirers are never asked to make. Of those 650 records, split between active and inactive, which population loads first? The question looks technical. It is an operating decision with reporting consequences, and the buyer’s operations and accounting leaders are the right people to answer it, in writing, before anyone builds a load file.

A review of this kind typically surfaces three or four more of them. Each one is a choice the buyer would otherwise discover during the first close after conversion, when the cost of changing course is highest.

  • How much volume history loads. Full history preserves trend analysis and prior-period comparability. A shorter window loads faster and carries less reconciliation risk. The answer depends on what the buyer intends to report, not on what the database happens to hold.
  • How mid-month status changes are treated. The seller made a choice here and encoded it in a macro. The buyer may reach a different one, and the difference shows up in allocated volumes.
  • Which allocation methodology survives. If the seller’s method differs from the buyer’s standard, someone decides whether historical volumes are restated onto the new basis or preserved as reported.
  • What happens to wells with incomplete records. Every acquired population contains some. The choice is to load them flagged, hold them back for manual review, or exclude them, and each has a different effect on the first close.

Surfacing those four questions early is most of the value on offer. None of them is difficult once asked. All of them are expensive when discovered late

What to Request in the Data Room

Buyers frequently request reports when what they need is the system that produced them. A short addition to the data room request list changes the position materially:

  1. A copy of the operational database itself, not an export. Exports lose the embedded logic, which is the part that cannot be reconstructed from output.
  2. Any documentation that exists, including partial or outdated material. Even a stale data dictionary shortens the read.
  3. One hour with the person who maintains it, if that person is still employed. This is often the single highest-value item on the list and the one most likely to be omitted.
  4. A recent period’s output alongside the inputs that produced it, which allows the observed behavior to be reconciled against the code rather than taken on trust.

Why This Work Became Affordable

Reading an undocumented schema, tracing embedded logic, and reconciling both against observed data used to be expensive because it was slow, not because it was difficult. Tools including Claude and Claude Code compress the timeline. A model can enumerate tables and relationships, summarize what each stored procedure does, flag the places where the code contradicts the data, and produce a first-pass description of the business rules in language a person can argue with.

The specialist does not stop reading the database. The specialist stops spending three of the four weeks on the part of reading it that amounts to transcription. A month of analyst time becomes about a week of expert judgment, which is what moves this inside the diligence window for the first time.

None of it requires an agent, and none of it requires anyone to build a model. It requires access to the file, a person who understands production accounting, and tooling that takes the transcription work out of the opening weeks.

What the Functional Specification Should Contain

The deliverable is a functional specification. On most integrations, that document gets written at the end, as documentation. Produced at the beginning, it becomes a decision instrument, and it should cover four things:

  • The data model. Tables, relationships, and keys, described in operating terms rather than technical ones, so that an accounting lead can read it without a translator.
  • The populated content. What is in the system as opposed to what it was designed to hold, including record counts, date ranges and the fields that are consistently empty.
  • The embedded logic in plain language. Every rule the code enforces, stated as a sentence a business owner can confirm or dispute.
  • The open decisions. The choices the buyer makes, each with its reporting consequence stated, formatted for signature.

That last section is what turns the document from a record into an instrument. It is the artifact operations and accounting leadership review and sign before conversion design starts.

Where This Fits in the Deal Timeline

The read belongs in confirmatory diligence, running alongside the reserve and title work rather than after it. That placement is what makes the output useful, because it feeds the transition services negotiation, and a transition period priced against a scope nobody has measured is priced against a guess.

Everything expensive about an acquisition data conversion is decided in the first three weeks: which records load, how history is treated, and what gets restated later. Making those decisions before signing gives the buyer something to negotiate with, and it produces a signed record of who chose what, which is what auditors ask for and what makes any later restatement defensible. Making them after close means paying for whichever answer the calendar forces.

That framing is usually enough to move the work forward in a deal review, because it changes the category the request sits in. This is not a technology line item competing against other technology line items. It is a diligence line item with a defined output and a week-long duration, and set against the cost of a disputed first close or an extended transition period, a week of specialist time is a rounding error.

The Difference It Makes at the First Close

An operator who buys a field with confidence should be able to close the first month with the same confidence. That is the entire return on this work. The buyers who integrate well are not the ones running the best conversion software. They are the ones who knew what was in the seller’s system before they signed, who put the operating decisions in front of the right people while there was still time to choose between them, and who walked into the first close already knowing what it would show.

That knowledge is now available in days rather than weeks, which for the first time makes it a reasonable thing to ask for while the deal is still being negotiated.

About the Author
Ryan Webernick
Ryan is a Director in Opportune LLP’s Upstream Practice. He is a digital transformation leader with over 20 years of experience delivering technology-enabled business solutions across upstream oil and gas operations. As a trusted advisor to executive and operational stakeholders, Ryan specializes in enterprise system implementations, business process optimization, and emerging artificial intelligence and automation technologies, combining deep technical expertise with strong consulting and client relationship skills to deliver measurable ROI and operational excellence.

Our experts are here for you.

When you choose Opportune, you gain access to seasoned professionals who not only listen to your needs, but who will work hand in hand with you to achieve established goals. With a sense of urgency and a can-do mindset, we focus on taking the steps necessary to create a higher impact and achieve maximum results for your organization.