How to Reconcile Segment Sales to Consolidated Revenue
Trace ExxonMobil’s segment figures through intercompany eliminations and two income lines to reach the sales number used in a financial model.
In this article
Adding the operating businesses in ExxonMobil’s 2025 segment note gives $452.209 billion of segment revenues and other income. The consolidated income statement shows $323.905 billion of sales and other operating revenue. Both figures are legitimate. A model that tries to reconcile them with a single elimination misses two different decisions about what belongs on the revenue line. ExxonMobil’s 2025 Form 10-K, consolidated income statement and Note 3
Follow a barrel through the segment table
An integrated producer can earn an internal sale when one business transfers production to another. The upstream team can record a sale to the downstream business, and the downstream business can later record an external sale of the finished product. A segment analyst may want both transactions to understand activity and margins inside the businesses. A model of company-wide sales needs to count the outside transaction once.
In the 2025 segment note, the US and non-US Upstream businesses together accounted for $62.406 billion of intersegment revenue, from $25.637 billion and $36.769 billion respectively. The note gives separate intersegment figures for Energy Products, Chemical Products and Specialty Products. Across all the operating businesses they totaled $121.005 billion. This amount is measurable in the filing, so the model can carry it explicitly when its inputs include internal sales. ExxonMobil’s 2025 segment detail
| 2025 bridge, US$ billions | Amount | Running total |
|---|---|---|
| Segment revenues and other income | 452.209 | 452.209 |
| Add other revenues in the issuer’s reconciliation | +1.034 | 453.243 |
| Eliminate intersegment revenues | −121.005 | 332.238 |
| Remove income from equity affiliates | −5.064 | 327.174 |
| Remove other income in the consolidated statement | −3.269 | 323.905 |
The first three rows reproduce the filing’s reconciliation to total revenues and other income. The final two reproduce the narrower consolidated sales and other operating revenue line. They answer different model questions. If the target is the broader total, stop at $332.238 billion. If the target is sales, the remaining $8.333 billion has two named components. Treating it as another intercompany sale would distort any forecast of internal volumes. 2025 Form 10-K, Consolidated Statement of Income and Disclosures about Segments and Related Information
Find the error from the amount left over
A model that starts at $452.209 billion and subtracts only the $121.005 billion elimination lands at $331.204 billion. Against the broad consolidated total it looks $1.034 billion low. That amount matches the separate reconciliation item. Against sales it looks $7.299 billion high. That second residual combines the omitted $1.034 billion with $8.333 billion of income included in the broader measure. A plug for $7.299 billion could make a spreadsheet balance while leaving both mistakes intact.
Before carrying the formula to a peer, read which segment row the source supplies. A table limited to external customers has already omitted internal sales. Applying a full intersegment elimination to that table would subtract internal revenue twice. Use the issuer’s own reconciliation as the control observation, and store the target line’s full name next to the cell that runs the check.
We recommend AllMind Data Rooms when reviewers need to return to the segment note, income statement and prior model together. Ask for the exact names, units and pages for the two endpoint figures and the intervening rows. Keep arithmetic and forecast assumptions in the model so a colleague can recompute the bridge or choose the broader endpoint. For other checks on numbers carried into a spreadsheet, see auditing AI-generated financial models.