Guide

The Midstream Operator's Complete Guide to Crude Oil Accounting and Settlement

March 20, 2026 · 15 min read

Crude oil accounting and settlement is the financial backbone of every midstream gathering operation. It's the process that turns raw measurement data — meter readings, run tickets, quality samples, and flow computer files — into the payments that keep crude moving from wellhead to market.

For mid-size gathering operators running 10 to 200 LACT units, this process is often the single largest operational bottleneck. Settlement teams spend days each month reconciling volumes, chasing variances, and manually calculating what each producer, transporter, and marketer is owed. When the process breaks down, the consequences are immediate: delayed payments, disputed volumes, and strained relationships with the producers you depend on.

This guide walks through every stage of crude oil accounting and settlement — from the gathering value chain to software evaluation — so you can identify where your operation is losing time and money, and what to do about it.

1. The Crude Oil Gathering Value Chain

Before diving into accounting mechanics, it helps to understand the physical system that generates the data. A typical crude oil gathering operation involves four stages:

Production and Receipt

Crude oil is produced at well sites and delivered to gathering facilities via pipeline, truck, or rail. At each receipt point, a LACT (Lease Automatic Custody Transfer) unit measures the incoming volume, temperature, pressure, API gravity, and BS&W (basic sediment and water) content. This data is captured by flow computers — often as TransLog or Microload files — and becomes the official record of what the producer delivered.

Gathering and Transport

Once received, crude moves through the gathering system — a network of pipelines connecting lease sites to central facilities, storage tanks, or delivery points. During transport, small volume losses occur due to evaporation, meter tolerances, temperature changes, and BS&W settling. These losses are tracked as pipeline loss allowance (PLA) and must be accounted for in settlement.

Delivery and Custody Transfer

At delivery points — pipeline interconnects, truck loading racks, or rail terminals — the crude is measured again as it leaves the gathering system. This outbound measurement establishes what the gathering operator delivered to the downstream buyer or marketer. The difference between receipt volumes and delivery volumes, adjusted for PLA, tank inventory changes, and quality corrections, must reconcile within acceptable tolerances.

Marketing and Settlement

After volumes are reconciled, the settlement process begins. Each party in the system — producers, the gathering operator, transporters, and marketers — receives a settlement statement showing volumes, rates, quality adjustments, deductions, and the net amount owed. This is where accounting meets the physical world, and where errors in measurement or reconciliation become financial disputes.

2. Key Roles in Crude Oil Accounting

Crude oil accounting isn't one person's job. It spans the field, the back office, and often the executive suite. Understanding who does what — and where handoffs create friction — is essential to improving the process.

Measurement Technician

Works in the field. Calibrates meters, collects samples, pulls flow computer data, and generates run tickets. The measurement tech is responsible for the accuracy of the raw data that feeds the entire settlement process.

Measurement Analyst

Works in the office. Validates incoming measurement data, identifies anomalies (duplicate tickets, quality outliers, missing readings), and reconciles volumes across the system. This is the most time-intensive role in the settlement process — and the one most affected by manual workflows.

Settlement Analyst

Calculates what each party is owed based on reconciled volumes, contract terms, quality adjustments, and applicable deductions. Generates settlement statements and manages the month-end close process.

Operations Manager

Oversees gathering system performance, manages producer relationships, and resolves disputes. Needs visibility into volumes, variances, and settlement timelines without digging through spreadsheets.

Accounting / Revenue Team

Processes invoices, manages accounts payable and receivable, and ensures settlement figures flow correctly into the general ledger. Depends on accurate, timely data from the measurement and settlement teams.

In smaller operations, one person might wear several of these hats. In larger ones, each role may be a team. Either way, the handoffs between roles — field to office, measurement to settlement, settlement to accounting — are where errors and delays accumulate.

3. Measurement Data: The Foundation of Every Settlement

Every dollar in a crude oil settlement traces back to a measurement. If the measurement data is wrong — or incomplete, or late — the settlement will be wrong. Understanding what data is collected and how it flows through the system is fundamental to understanding where things go wrong.

What Gets Measured

At each custody transfer point, instruments capture several data points that together describe the volume and quality of crude oil changing hands:

  • Gross observed volume (GOV): The raw meter reading at actual conditions — before any corrections for temperature, pressure, or sediment.
  • Temperature and pressure: Used to correct the observed volume to standard conditions (60°F, atmospheric pressure) using API MPMS tables.
  • API gravity: A measure of crude density that affects volume correction factors and is used for quality-based pricing adjustments.
  • BS&W (basic sediment and water): The percentage of non-crude content in the stream. Deducted from gross volume to calculate net volume. Higher BS&W means the producer delivered less actual crude.
  • GSV (gross standard volume): Volume corrected to standard conditions but before BS&W deduction.
  • NSV (net standard volume): GSV minus BS&W — the marketable crude volume that producers are paid on and settlements are calculated from.

How Data Gets Into the System

Measurement data arrives through several channels, each with its own format and reliability characteristics:

  • Flow computer files: TransLog and Microload files are the most common formats. These are exported from flow computers at LACT units and contain detailed transaction records.
  • Run tickets: Paper or digital records generated at each custody transfer event. Contain volume, temperature, gravity, and BS&W data. Often the official record of a transaction.
  • SCADA systems: Provide real-time meter readings but typically at lower resolution than flow computer files. Good for monitoring, less reliable for settlement-grade accounting.
  • Manual entry: Truck tickets, tank gauging records, and meter readings from sites without electronic data capture. The most error-prone data source.

The challenge isn't just collecting this data — it's normalizing it. A single gathering system might ingest TransLog files from one LACT, Microload files from another, manual truck tickets from a third, and SCADA readings from storage tanks. All of this must be converted into a common format before reconciliation can begin.

4. Volume Reconciliation: Matching What Went In to What Came Out

Volume reconciliation is the process of comparing measured inflows against measured outflows across the gathering system and accounting for every barrel. It's the most labor-intensive step in the accounting cycle and where most operators lose the most time.

The Reconciliation Equation

At its simplest, the equation is:

ReceiptsDeliveriesInventory ChangePLA = Imbalance

When the imbalance is zero (or within acceptable tolerances, typically 0.25–0.50%), the system balances and settlement can proceed. When it doesn't, the measurement team has to investigate.

Common Reconciliation Problems

Every gathering operator deals with the same recurring reconciliation challenges:

  • Duplicate tickets: The same run ticket entered twice — through a flow computer file and manual entry, or from overlapping data exports. Duplicates inflate receipt volumes and create phantom imbalances.
  • Missing data: A meter was offline, a flow computer file wasn't exported, or a manual ticket wasn't entered. Missing data creates gaps that prevent the system from balancing.
  • Quality anomalies: BS&W or gravity readings outside expected ranges. Could indicate a sampling error, a meter calibration issue, or an actual quality problem that affects net volume calculations.
  • Timing mismatches: A delivery measured at 11:58 PM on the last day of the month might appear in either month's data depending on which system recorded it. These create month-to-month imbalances that chase the settlement team.
  • Shorts and longs: Volume variances between receipt and delivery points that exceed PLA. Could indicate a leak, a meter calibration drift, or a data entry error. Each one must be investigated before settlement can close.

In a manual environment, investigating each of these issues means opening spreadsheets, cross-referencing tickets, calling field technicians, and sometimes driving to the site. For a gathering system with 50+ meters, month-end reconciliation can consume the entire measurement team for three to five days.

5. Settlement Types and How They Work

Once volumes are reconciled, the settlement process calculates what each party is owed. The specific structure depends on contracts, but most gathering operations deal with three categories of settlement:

Producer Settlements

The most common settlement type. Producers deliver crude to the gathering system and are paid based on net standard volume, adjusted for quality (API gravity and BS&W), minus gathering fees, transportation deductions, and any applicable taxes or levies. Producer settlements are typically monthly, and late or inaccurate payments directly damage the operator-producer relationship.

Marketing Settlements

The gathering operator sells crude to downstream marketers or refiners at delivery points. Marketing settlements calculate the revenue from these sales based on delivered volumes, contract pricing (which may reference an index like WTI plus or minus a basis differential), and quality adjustments. The difference between what the operator pays producers and what it receives from marketers — minus gathering and transport costs — is the operator's margin.

Transporter Settlements

When third-party pipelines or trucking companies move crude between points in the system, they charge per-barrel transport fees. These settlements are based on measured volumes at loading and unloading points, with PLA applied to account for transit losses. Disputes here often center on whose meter reading governs — the loader's or the receiver's.

The Contract Layer

Each settlement is governed by a contract that specifies rates, volume thresholds, quality adjustment formulas, PLA percentages, payment terms, and dispute resolution procedures. A mid-size gathering operation might have 50 to 200 active contracts, each with slightly different terms. Managing this contract complexity — ensuring the right rate applies to the right volume at the right meter — is one of the hardest parts of settlement, and one of the biggest sources of errors in spreadsheet-based workflows.

6. The Spreadsheet Problem

Most mid-size gathering operators run their entire accounting and settlement process in spreadsheets. It's understandable — the operation started small, someone built a workbook, and it grew. But spreadsheet-based settlement has predictable failure modes that get worse as operations scale:

Single points of failure

The settlement spreadsheet is usually maintained by one person. When that person is out — sick, on vacation, or leaves the company — no one else can run the process. The workbook has grown into a custom application that only its creator understands.

No audit trail

Spreadsheets don't track who changed what, when, or why. When a producer disputes a settlement figure, you can't prove how the number was calculated or whether it was modified after the fact. This erodes trust and makes dispute resolution adversarial.

Formula errors compound silently

A broken formula in row 47 of a 5,000-row workbook won't announce itself. It will quietly produce wrong numbers that flow into settlements, payments, and financial statements. Research estimates that 88% of complex spreadsheets contain errors.

Manual data entry

Flow computer files, run tickets, and meter readings are manually entered or copy-pasted into spreadsheets. Every manual touch point is an opportunity for error — transposed digits, wrong columns, missed entries.

Doesn't scale

A spreadsheet that works for 10 LACT units becomes unmanageable at 50 and impossible at 100. But operations grow incrementally, so the spreadsheet is never replaced — just patched, extended, and made more fragile.

The real cost of manual settlement isn't just the hours spent — it's the errors that go undetected, the disputes that could have been prevented, the producers who switch to a competing gatherer because they don't trust your numbers, and the month-end close that takes five days instead of one.

7. Evaluating Settlement Software

If your operation has outgrown spreadsheets — or you're planning to — here's a framework for evaluating crude oil settlement software. For a more detailed evaluation, see our Buyer's Guide for Mid-Size Gathering Operators.

Data Ingestion

The software needs to accept data from your actual sources — TransLog files, Microload exports, SCADA feeds, manual entry for truck tickets, and whatever else your system produces. If it can't ingest your data natively, you'll end up building and maintaining custom integrations, which defeats the purpose.

Automated Reconciliation

The software should automatically match receipt volumes to delivery volumes, apply PLA, account for inventory changes, and flag variances that exceed configurable thresholds. The goal is to reduce reconciliation from days of manual work to a review-and-approve workflow where the system does the matching and the analyst handles exceptions.

Contract Management

Can the software model your actual contract structures? This includes per-barrel gathering fees, tiered rates, quality adjustment formulas (gravity and BS&W schedules), minimum volume commitments, seasonal pricing, and retroactive rate changes. If the software can't handle your contracts, you'll end up doing manual overrides — which is just a spreadsheet with extra steps.

Audit Trail

Every data point, calculation, adjustment, and approval should be logged with who, what, when, and why. When a producer questions a settlement figure, you should be able to trace it from the final statement back to the original meter reading in clicks, not hours.

Reporting and Visibility

Settlement statements, variance reports, system balance dashboards, trending analysis, and ad-hoc queries. Different stakeholders need different views — the operations manager wants a system overview, the settlement analyst wants transaction detail, and the accounting team wants numbers that match the GL.

Deployment and Time to Value

Enterprise ERP systems (SAP, Oracle) can handle crude oil accounting, but implementations take 12–18 months and cost hundreds of thousands of dollars. Purpose-built cloud platforms designed for mid-market operators can be deployed in weeks. The right choice depends on your scale, budget, and timeline.

8. Getting Started

If you've read this far, you probably recognize some of these pain points in your own operation. Here's how to start making progress:

  1. Map your current process. Document every step from data collection to settlement statement. Identify where time is spent, where errors occur, and where handoffs create delays. You can't improve what you can't see.
  2. Quantify the cost. How many hours does your team spend on monthly settlement? What's your average days-to-close? How many disputes do you handle per month, and how long do they take to resolve? These numbers make the business case for change.
  3. Start with data ingestion. The highest-ROI first step is usually automating data ingestion — getting flow computer files, meter readings, and tickets into a system without manual entry. This alone can eliminate an entire category of errors.
  4. Evaluate purpose-built tools. Look at software designed specifically for midstream measurement and settlement, not general-purpose ERP or accounting systems. The domain specificity — understanding LACT data, custody transfer, PLA, quality adjustments — is what separates a tool that helps from a tool that creates new problems.

See It in Action

COYOTE Measurement automates the entire crude oil accounting and settlement workflow — from data ingestion and reconciliation to settlement generation and reporting. Built specifically for mid-size gathering operators who've outgrown spreadsheets.

Schedule a Demo