A crude oil marketing settlement is where measurement data finally turns into money. It pulls together purchased volumes, quality adjustments, contract pricing, carrier charges, and net proceeds, then answers the question every producer and operator cares about: who gets paid what, and why?
That sounds straightforward until you look at the real workflow. A gathering terminal may buy crude from multiple producers, sell into a pipeline or downstream buyer, allocate transportation and loss across several shippers, and reconcile every one of those movements against field tickets and meter data. When that process lives in spreadsheets, marketing settlement becomes the slowest and riskiest part of month-end close.
What a Marketing Settlement Actually Includes
A marketing settlement starts with verified transaction data. That includes run tickets, LACT or truck unload measurements, API gravity, BS&W, and the net standard volume that should flow into accounting. But unlike a basic service-fee invoice, the settlement also needs commercial logic layered on top of those measurements.
For each producer or shipper, the operator may need to apply a contract formula tied to an index price, subtract a basis differential, calculate quality deductions, allocate linehaul or pipeline charges, apply a gathering fee, and then net the result into a final amount due. The settlement statement is the output, but the real work is tying every number back to a trustworthy source record.
That is why marketing settlements sit downstream of reconciliation. If the underlying volume data is wrong, the financial statement will be wrong too, just with more decimal places and a bigger downstream mess.
How Marketing Settlements Differ From Gathering Fee Settlements
Gathering fee settlements are simpler. They answer a service billing question: how many barrels moved through the system, and what fee should be charged per barrel? A marketing settlement answers an ownership and proceeds question: what crude was purchased, how was it sold, which deductions apply, and what is the net amount owed to each counterparty?
That difference matters because the data dependencies multiply fast. A gathering fee error usually affects a service invoice. A marketing settlement error can affect producer payments, revenue recognition, dispute handling, and the trust the operator has built with counterparties over time.
In practice, marketing settlements are where spreadsheet processes start to bend. It is one thing to total barrels by shipper. It is another to do that while also handling index pricing, quality specs, multiple transport legs, and retroactive adjustments without creating hidden formula risk.
Why Spreadsheet Workflows Break Down
Most spreadsheet-driven marketing settlement workflows fail in the same places. First, data entry and import logic are fragile. Ticket exports get copied from one workbook to another, price tabs are updated by hand, and exceptions are tracked in email or side notes instead of inside the settlement system itself.
Second, formula sprawl makes review difficult. A workbook that started as one terminal and two counterparties grows into multiple tabs, dozens of linked formulas, and manual overrides that only one person really understands. When a volume is corrected late in the process, the operator has to trust that every dependent formula updated correctly.
Third, audits are painful. If a producer asks why their net payment changed from the prior month, the team has to reconstruct the answer from exported files, inbox threads, and worksheet versions. That is not a close process. That is a forensic exercise.
What Automation Changes
Automation does not remove judgment from marketing settlements. It removes repetitive risk. The system imports ticket and meter data, validates it against expected operators and facilities, flags exceptions before close, and applies settlement rules consistently across every transaction. Instead of rebuilding the same settlement logic each month, the operator reviews the output and handles true exceptions.
That has three practical effects. First, close cycles shrink because the team is not waiting until month-end to discover missing or mismatched data. Second, dispute response improves because every statement line can be traced back to the source transaction and contract rule that created it. Third, management gets a better operating picture because settlement status is visible in real time rather than trapped inside a workbook on one person's laptop.
For a mid-size terminal, that time savings adds up quickly. If a team spends two to four hours per day on manual settlement cleanup, automating the workflow can return hundreds of hours per year while reducing the payment errors that damage producer relationships.
The Workflow Modern Operators Want
A modern marketing settlement workflow usually looks like this: ingest data from LACT systems, truck ticketing platforms, and back-office sources; validate codes, volumes, and quality values; reconcile receipts against deliveries and allowable loss; apply contract pricing and deductions; generate settlement statements; then export clean outputs for finance and counterparties.
The important part is not just speed. It is confidence. When a settlement is ready, the operator should know that duplicate tickets were caught, unknown codes were surfaced early, pricing inputs were versioned, and every number on the statement can be explained without spelunking through old spreadsheets.
That is the real value of automation in marketing settlements. It turns settlement from a monthly scramble into an auditable operating workflow.
Still closing marketing settlements in spreadsheets?
COYOTE Measurement helps gathering operators connect measurement, reconciliation, and settlement in one workflow, so producer payments and internal close do not depend on manual workbook gymnastics.
Schedule a Demo