US: Updated Excel-Based Translation File

We have updated our CPI/PPI-to-PCE translation Excel file. This is version 4, which can be downloaded here. This version of the file includes several changes; the full list can be found in the “Read Me” tab. The translation of the February PCE reading is little changed (44 bps for core and 43 bps for headline – see Figure 1 below). Our Excel file is a living document and, as such, we will continue to make changes to improve the translation. That said, since its introduction, its performance has been comparable to—and in some cases better than—that of the best alternatives available in the market.

A Note on CPI Legal Issues and the BEA Methodological Changes. As every year, the BEA has revised the PCE source data reported in Table 2.4.4 of the NIPA tables. In our Excel file, the “beasourcefile” tab provides a comparison highlighting all the changes introduced. Most revisions concern the seasonal status of the source series (switching from NSA to SA, or vice versa). In a few cases, however, the changes are more substantial. For example, for PCE Tax preparation and other related services, the BEA has moved from using “CPI Tax preparation and other accounting fees” as the input series to “CPI Tax preparation and other accounting fees & judgmental trend.” A similar change applies to PCE Spectator sports. The introduction of a “judgmental trend” clearly complicates the translation process, as the methodology used to compute such a trend is not publicly specified. A similar issue arises in the case of PCE Legal services, which in January was not translated using “CPI Legal services” as indicated in the official documentation—a circumstance that became widely known through a newspaper article rather than through the official source.

More broadly, we encourage interested readers to consult our comments (column L in the “beasourcefile” tab) to appreciate how many PCE components are translated either through non-automatic procedures or through processes that are not fully transparent. In several cases, the BEA’s procedures are only described at a very high level, making full replication impossible. That said, our CPI/PPI-to-PCE translation has historically proven to be very accurate. We therefore remain confident that we can approximate the published figures with a relatively small margin of error (within approximately 3-4 basis points).

Figure 1. Current February 2026 PCE translation

Contact

Want something more tailored?

We provide tailored consulting on ad-hoc projects.