← Back to blog

AI

Beyond the Spreadsheet: Real-Time Risk Management for Commodity Traders

9 November 2026

This post was first published in September 2025. A year on, the problem it describes has not gone away, but the way to solve it has evolved, as AI has changed what real-time risk management can look like in practice. We have updated the post to reflect that.

Timing has always been an important factor in commodity trading success, and in the current risk environment, moving fast is more critical than ever. But many risk managers still find themselves waiting. Waiting for spreadsheets to be updated, waiting for end-of-day reports, and waiting for the full picture to emerge before they can act.

Even with a CTRM system in place, many firms still rely on spreadsheets to fill in functionality gaps. Spreadsheets can be a useful reporting and analytics tool, and are flexible and familiar, leading to the temptation to use them for managing CTRM work-arounds and trading processes. But using spreadsheets operationally can lead to many issues. They are prone to human error, lack audit trails and proper risk controls, and live outside the core system. The result is a fragmented view of risk, delayed insights, and time lost to administration such as copying information between systems and tracing and correcting errors.

We find that many trading companies assume that spreadsheets are a necessary add-on to any CTRM, but this does not have to be the case. Particularly for organisations that have moved on from CTRM to full Commodity Management Systems, where deal capture, contracts, pricing & invoicing, and physical logistics all take place within the same system as risk management.

The Cost of Delayed Risk Visibility

When risk data is only available at the end of the day, risk managers struggle to react to today’s problems, let alone respond to new risks in real-time. That delay can have real consequences:

  • Missed opportunities to adjust positions in line with market moves and shocks.
  • Increased exposure to market, FX and credit risk, as well as losses from not moving fast enough.
  • Unnecessary operational risk with compounded errors from manual data entry, version control issues, and poor visibility over whether processes have been followed. These can create real costs due to penalties or operational delays and demurrage charges.
  • Reduced confidence in the accuracy and timeliness of reports, leading to even more lost time reconciling different systems and reports, and more decisions based on “gut feeling” rather than being data-driven.

With commodity markets moving faster than ever and a constantly evolving risk landscape, these inefficiencies leave commodity traders exposed and vulnerable.

Moving beyond CTRM and moving beyond spreadsheets

We are not advocating for trading companies to remove every spreadsheet from their organisation; these versatile tools certainly have their place, and Gen10’s CommOS can export data directly into management spreadsheets to provide the latest information from across the business. But calculating valuations, running MtM, or managing shipments in spreadsheets, creates risks that can no longer be ignored. Especially when there are Commodity Management Systems out there that make these CTRM limitations a thing of the past.

As opposed to traditional CTRM systems, which were created to report on trading activities that had already taken place, Commodity Management Systems are designed to bring all your business processes into one place where you actively manage them. They integrate data from across the business; trading, logistics and finance teams all use the CMS to carry out their actual roles, generating the data that other teams and risk managers need.

This provides a truly live picture of the real-world environment and gives risk managers a real-time view of risk throughout the day, with no need to wait for end of day reports or chase down traders to furnish an update. And with a well-integrated Commodity Management System like Gen10’s CommOS, you also avoid delays in translating data between systems, as integrations automatically update data between systems, too. That means no more manual reconciliation either.

Ask Instead of Wait

A Commodity Management System removes the wait for data. The next step is removing the wait for the report. NaNi, the conversational AI interface in CommOS, reads data straight from the CTRM, so a risk manager can ask for physical exposure against hedges, unrealised and realised P&L, credit exposure by counterparty, or how much volume is still unpriced, and get the answer in plain language or an instant chart. And because NaNi works from the same CommOS data as the rest of the business, every answer can be traced back to the one live system of record.

Risk managers gain time back from building and chasing reports, so more goes on what matters. It also makes it easier to set things like pre-approval limits in advance, so traders only need to ask the risk team the complex questions.

We also treat AI as a risk to be managed in its own right. Conductor.AI, our governance layer, orchestrates the agents behind NaNi with role-based permissions, guardrails and a full audit trail. To see how we approach this in more detail, read our whitepaper, Charting a Safer Course at Full Speed.

Proactive Risk Management with NaNi

CommOS already runs on automated workflows with built-in approval processes and controls. Anything done through NaNi follows the same workflows, with the same permissions as the user. For risk management, that means:

  • Automated risk limits. CommOS allows you to set risk limits per counterparty, which can be narrowed by country, crop or commodity, and checks the buyer’s credit limit automatically. These checks sit within the contract and shipment workflows, flagging potential risks before the activity progresses.
  • Counterparty controls. New counterparties go through an approval workflow, and only approved companies can be selected when a deal is created. That remains the case whether NaNi or a person drafts the contract.
  • Logistics workflows. Shipments and shipping costs move through defined workflow stages so steps are not missed and nothing can be progressed if it is missing an approval. NaNi can also automatically check everything in the shipment workflow against the Letter of Credit and flag any mismatches.
  • Active audit trails. Audit-ready evidence is generated by doing the work, so the audit trail builds itself without anyone having to maintain it.
  • Document controls and checks. Contract Compare is an AI tool that checks a received document against your usual terms, or the contract you are drafting against the latest one with that counterparty and highlights any mismatches or omissions for traders then and there.

The controls are built into how work gets done, so risk managers can spend their time on the decisions that matter rather than checking that the process was followed.

A New Way Forward

If you’re a risk manager who’s frustrated by slow, error-prone reporting, it is time to rethink what your systems should be doing for you. Delayed manual reporting carries risks you no longer have to accept. Gen10’s CommOS reduces spreadsheet reliance and delivers truly live risk reporting, and with NaNi your team spend less time chasing reports and more time acting on them, with the controls that protect the business built in. If your current setup leaves you reacting to yesterday’s data, it is time to see what real-time, AI-assisted risk management could do for your team. Book a demo to see it for yourself.