This is the seventh and final post in our series on emissions ETRM best practices.
Over the past six weeks, we have covered position management across the full trade lifecycle, integrated P&L reporting, automated rollover, flexible inventory valuation, trade-level cost capture, and brokerage automation for multi-leg options. Each of these capabilities contributes to a more accurate and more timely picture of where the emissions desk stands. But there is one final step that ties the whole thing together: automated reconciliation.
Capturing costs in the ETRM is necessary but not sufficient. The back office also needs to prove that the costs are correct that what the system has calculated matches what the exchange, the clearing house, and the brokers are charging. Without this proof, the finance team cannot release payments with confidence, and the auditors will have questions.
The manual version of this process is painful. The back office receives an invoice sometimes weeks after the trading period and compares it line by line against their own records. For a high-volume desk, this means matching thousands of individual fee entries across multiple counterparties, fee types, and time periods. Discrepancies are common, and each one requires investigation: was the fee captured incorrectly, was a rebate missed, or is the invoice wrong?
The automated version works differently. The ETRM integrates with the execution platform the system where the trades were originally executed and pulls in the fee and brokerage amounts that the platform has calculated. It then runs a line-by-line comparison against its own internal cost records. Matches are confirmed automatically. Breaks are flagged for review. The back office focuses only on the exceptions, not on the entire population.
This changes the nature of the reconciliation from a multi-day manual exercise to a daily automated check. Discrepancies surface immediately not 20 or 50 days later when the invoice arrives. And when the invoice does arrive, the reconciliation has already been done. The back office can confirm the numbers and authorise payment on the same day.
The cost reporting and cash flow screens support this workflow. A cost report lets the back office select any date range and see every fee type clearing commission, exchange commission, brokerage, sales fees, rebates broken down by counterparty and book, with drill-down to the individual trades. A cash flow screen shows the settlement amounts due per counterparty per period. Together, these give the finance team exactly what they need to match invoices, verify totals, and release payments without chasing the trading desk for explanations.
This is where the whole system comes together. Position management gives the trader visibility. Integrated P&L gives the risk office accuracy. Automated rollover and inventory valuation eliminate manual gaps. Trade-level cost capture and brokerage automation ensure the numbers include all costs from day one. And automated reconciliation proves that those numbers are right.
If your emissions ETRM delivers all seven, you have a desk that can trade with confidence, a back office that can close the books on time, and a finance team that can trust what the system reports.
That wraps up the series. If any of these questions highlighted a gap in your current setup, we would be happy to show you how Igloo handles it in practice. Get in touch for a demo today.