How Crude Oil Trading Desks Track Cargoes, Assays, and Real-Time P&L in One System

A crude oil trading desk handles three live data streams every day: the cargoes (vessels, ports, laycans, B/L dates), the assays (API, sulphur, TAN, distillation cut), and the P&L (physical, paper, basis, FX, accruals). Holding all three in one system, in real time, is the difference between a desk that compounds capital and one that surprises its CFO at month-end. This article walks through how a modern crude trading desk runs in 2026: the data model, the reconciliation flows, and the operational practices that let a £100m–£2bn turnover trader run with five rather than fifteen people.

The one-system principle

The historical pattern for crude desks: deal capture in System A, position in System B, vessels in System C, quality in System D, hedges in System E, GL in System F. The integration is email, Excel, and Power BI. The cost is end-of-month reconciliation week, intermittent position errors, and uncertain real-time exposure.

The one-system principle inverts this: all six functions sit on a single data model with a single counterparty record, a single position record, and a single ledger of events. Integrations exist only where genuine specialist capability lives outside (an independent lab management product, an external charter broker's platform, an external sanctions screening provider).

The economic argument is straightforward. A six-person crude desk processing 80 cargoes/year on a fragmented stack typically spends 35–45% of its time on data reconciliation, position chasing, and report production. The same desk on a one-system architecture pushes that to 10–15%. The freed capacity goes into trading.

Cargo tracking: data model

A cargo is the atomic unit of crude oil trading. The data model needs:

Cargo
├── Identity            (cargo ID, deal ID, BL number)
├── Commodity           (grade, blend, origin)
├── Quantity            (gross, net, vacuum-corrected, NSV)
├── Quality             (assay snapshot, surveyor reports)
├── Vessel              (VLCC, Suezmax, Aframax, MR; IMO; charter type)
├── Voyage              (loadport, discharge port(s), laycan, NOR, BL date)
├── Contractual basis   (FOB / CIF / CFR / DES; pricing window)
├── Pricing             (benchmark, differential, fixings; final realised)
├── Hedges              (linked futures, swaps, options)
├── Counterparties      (buyer, seller, charterer, owner, surveyor, agent)
├── Finance             (LC, BG, prepayment, bank assignment)
├── Compliance          (sanctions checks, OFAC attestations, CBAM data)
└── Documents           (BL, COA, COQ, SOF, NOR, manifests)

Every event during the cargo's lifecycle — loading commenced, NOR tendered, demurrage triggered, hedge rolled, LC drawn — attaches as a structured record to the cargo. A modern ETRM stores 60–200 events per cargo over its 3–18 month lifecycle.

Assay tracking: more than a number

A crude assay is a multi-dimensional quality fingerprint. The headline parameters:

• API gravity (degrees API — drives valuation against benchmark)
• Sulphur (wt% — sweet vs sour)
• TAN (total acid number — high TAN crudes are harder to refine)
• Viscosity (kinematic, cSt)
• Pour point
• Distillation curve (TBP cuts: naphtha, kerosene, diesel, VGO, residue)
• Metals (vanadium, nickel — refinery catalyst poison)
• Mercaptans, H2S, salt content

For each cargo, two assays matter: the surveyed assay at loadport (independent inspection) and the surveyed assay at discharge. Differences drive quality disputes. The ETRM must store both as structured records, calculate the contractual quality adjustment, and emit the adjusted invoice.

Modern desks maintain a crude assay library — a reference set of representative assays for each grade traded, sourced from BP Assays, Equinor Assays, Crudemonitor, ENSPM, internal trading-desk samples, and surveyor archives. The library drives the refining-margin model, the assay-based pricing differential, and the blending optimisation.

P&L: real-time, multi-leg, multi-currency

A physical crude P&L has up to seven legs:

1. Physical inventory P&L — mark-to-market on physical position
2. Realised physical P&L — locked in on sales
3. Paper P&L — mark-to-market on futures, swaps, options
4. Basis P&L — the differential between physical and paper benchmarks
5. FX P&L — currency exposure on non-USD legs
6. Demurrage / despatch accrual — accruing voyage-level cost
7. Trade finance P&L — interest on facility utilisation, LC fees

A modern ETRM publishes all seven in real time, aggregated by trader, book, region, grade, and counterparty. Crucially, the basis P&L (which most desks track separately) must be reconcilable to physical and paper aggregates without manual journal entries.

For multi-currency consolidation: each leg booked in its native currency (e.g., physical in USD, paper in EUR for MATIF-related grades, freight sometimes in USD or GBP), with daily FX revaluation to functional currency and disclosed FX exposure to treasury.

Reconciliation: the four monthly cuts

A well-run crude desk runs four reconciliation cuts each month:

1. Position cut. Physical position by grade, region, month, against exchange position reporting and internal trader records.
2. Hedge effectiveness cut. Hedge designation by deal, MTM movement on cash leg vs paper leg, effectiveness ratio, OCI movement, ineffectiveness recognised in P&L.
3. Counterparty exposure cut. Net exposure by counterparty, against credit limit, with stress test on a 10/30/50% price move.
4. Inventory cut. Physical inventory at loadports, discharge ports, in transit, and in storage, valued at the inventory cost convention (FIFO / weighted average / specific identification) and reconciled to physical surveyor records.

If any of the four requires significant manual intervention to close, the desk has a systems gap to fix.

What a 5-person desk processes in a year

For a £200m turnover physical crude desk on a one-system architecture:

• ~100–150 cargoes/year (mix of VLCC, Suezmax, Aframax, MR)
• ~3,000–5,000 paper trades/year (ICE Brent, NYMEX WTI, futures spreads, swaps)
• ~30–80 charter parties/year (voyage charter mainly)
• ~600–1,200 LC / BG / bank events/year
• ~150–300 sanctions / KYC events/year
• 1 monthly close in <5 working days
• 1 annual statutory audit closed in <6 weeks
• Full hedge accounting documentation under IFRS 9 / ASC 815

The unit operation per cargo at this scale is ~3 hours of human time, including trader, ops, and finance. On a fragmented stack, the same operation runs 8–14 hours.

opsPhlo Energy's architectural answer

opsPhlo Energy implements the one-system principle for £5m–£3bn turnover physical crude and products traders:

• One counterparty record across deal, sanctions, credit, finance, and accounting.
• One position record across physical, paper, basis, FX, and inventory.
• One ledger of events from broker confirmation through statutory close.
• Native Dated Brent, WTI, Dubai, and product-benchmark pricing.
• Crude assay library with surveyor report ingest.
• Vessel module with AIS integration, laytime calculator, and demurrage accrual.
• Sanctions screening at deal entry against OFAC, OFSI, EU, UN, and vessel-level dark-fleet flags.
• IFRS 9 / ASC 815 hedge accounting with system-generated effectiveness testing.
• Multi-currency consolidation with daily FX revaluation.
• AI-augmented deal capture from broker confirmation, charter party, SOF, and COA documents.

Deployment runs typically 10–16 weeks to production for a mid-market physical crude desk, often migrating from spreadsheets plus QuickBooks/Xero, or from an older ETRM (legacy Aspect, Inatech, Brady) where the maintenance burden has overtaken the operational value.

Frequently Asked Questions

What is a crude oil assay and why does it matter for trading?

A crude assay is a structured laboratory analysis of a crude oil sample, recording API gravity, sulphur, TAN, viscosity, distillation cut yields, metals content, and other physical and chemical properties. Crude trading uses assays to value cargoes (lighter, sweeter crudes command higher prices), to model refining margins (assay drives product yield), and to settle quality disputes (loadport vs discharge assay differences). A trading system without a structured assay model cannot accurately price cargoes or settle disputes.

How do crude traders calculate real-time P&L?

Real-time P&L combines physical mark-to-market (inventory valued at current market), realised P&L on closed sales, paper mark-to-market on futures and swaps, basis P&L (physical-vs-paper differential), FX P&L, and accruing demurrage. A modern ETRM publishes all components continuously, aggregated by trader, book, region, and counterparty.

What is dated Brent and how is it used in pricing?

Dated Brent is the price for a specific cargo of North Sea Brent crude loading on a defined date 10–25 days forward. Published daily by Platts (and similar services), dated Brent is the most widely used physical crude pricing benchmark globally — roughly 70% of internationally traded crude prices off dated Brent in some form. A cargo priced "Dated Brent plus $0.50, calendar month average over February" uses the average daily Platts Dated Brent assessment across February as its final price reference.

How does AIS data help crude oil trading?

AIS (Automatic Identification System) is the global vessel tracking signal carried by virtually all commercial tankers. AIS data lets a crude trading desk verify vessel location against charter party terms, detect early/late arrivals (laytime implications), confirm B/L date accuracy, flag suspicious behaviour (signal gaps, route deviations consistent with sanctions evasion), and reconcile cargo movements to physical position records. A modern ETRM consumes AIS data continuously.

How does opsPhlo handle sanctions screening for crude oil cargoes?

opsPhlo screens at three levels: counterparty (buyer, seller, charterer, owner, beneficial owner), vessel (IMO number against OFAC SDN, EU sanctions list, UK OFSI, UN), and cargo origin (against Russia-origin price cap rules, Iran / Venezuela embargoes, Syria sanctions). Screening runs at deal capture, at vessel nomination, and on a continuous basis for the duration of the cargo lifecycle. Hits block deal progression and create an audit-trail record.

Does opsPhlo support refining-margin trading?

Yes. opsPhlo Energy supports crack spread (3:2:1, 5:3:2, custom ratios), refining-margin hedges (paper barrel-bbl spreads between crude and products), and forward refining-margin curves for use in deal evaluation. The refining-margin model uses the crude assay library for cut yield estimation against the relevant refinery configuration.