In-depth practical guides

Compare and convert public amounts

Retain currency, scale, period, price basis and method when comparing budgets, grants or procurement amounts.

Updated :

Statistical analysis workstation with illustrative charts.

AI-generated illustration

Are these amounts actually comparable?

Awarded, committed, paid and capped amounts describe different stages. Currency conversion does not correct those differences or price changes. ECB reference rates are informational, not transaction rates.

  1. Define the amount

    Record currency, unit, scale, taxes, period and whether it is a flow, stock, commitment or payment.

  2. Select a rate

    Specify rate date or period, source and quotation. Period-end rates and period averages answer different questions; document non-publication days.

  3. Write the formula

    If T is currency units per euro, amount M becomes M/T euros. Keep input and unrounded output; round presentation only.

  4. Separate exchange and prices

    For time comparisons state current or constant prices and justify the relevant index. Consumer price indices do not automatically suit every contract.

Situations and decisions

Typical situations for preparing a check. They do not describe completed assignments or actual observations.

Inverse quotation

With currency units per euro, multiplying rather than dividing reverses conversion. Write units in the formula.

Budget versus payment

An authorised budget and an executed payment remain different objects after conversion to one currency.

A conversion whose units cancel

Fictional example, not a market rate: with 132 USD and 1.10 USD per EUR, compute 132 USD / (1.10 USD/EUR) = 120 EUR. USD cancels. Multiplication gives 145.20 with incompatible units. Record the quotation, selected date and formula, not only the final number.

Nominal growth disappears at constant prices

Worked example: an amount rises from 100 to 110 while a suitable price index rises from 100 to 110. The later amount is 110 × 100/110 = 100 in base-period prices. Nominal growth of 10% becomes zero in this example. Justify the index for the expenditure studied.

Worked exercise

Annual and monthly amounts may be equivalent

Fictional example: the values and documents teach the method and do not describe a real organisation.

Both records describe the same budget scope, year and twelve full months. Compare their values before adding them.

If the table exceeds the screen, scroll horizontally; arrow keys work when the region is focused.

Starting information
BudgetAmountReference period
Annual24 000 EUROne year
Monthly2 000 EUROne month

Your checks

  1. Read period, currency and amount type.
  2. Convert the period with an explicit formula.
  3. Check these are not two amounts to add.
Read the answer

Answer and decision

2,000 × 12 = EUR 24,000 annually. Under these assumptions the values are equivalent; summing doubles one budget. Equivalent frequency does not turn a budget into an actual payment.

If the case changes

For only ten covered months, the corresponding total is EUR 20,000; disclose any annualised projection.

Record to retain

Keep amount, time unit, covered months, type and conversion formula.

Record to retain

  • Original amount, currency, scale and nature.
  • Period, taxes and price basis.
  • Rate, quotation, producer and extraction.
  • Formula, missing-day rule and rounding.
  • Calculation with units, unrounded amount and reconciliation of item sums with the total.

Official references

Related source profiles

Related protocols

Checks before reaching a conclusion

  • Do amount types match?
  • Are quotation and units explicit?
  • Can rate selection be reproduced?
  • Is price basis stated?

Frequently asked questions

Is the latest rate always suitable?

Not automatically for past operations or yearly flows. Choose a rule for the question and retain the series.

Does currency conversion adjust inflation?

No. Exchange and price changes require separate dates, sources and methods.

Can items be converted after adding them?

Yes when currency, scale, nature and rate rule are identical. Convert items with different dates or currencies according to the chosen rule before aggregating. Check that subtotals and the grand total are not added together.

TOOLS / REGISTERS

Information to record

For time comparisons state current or constant prices and justify the relevant index. Consumer price indices do not automatically suit every contract.

  • Access date and time zone
  • Exact URL
  • Exact column name
  • Observed passage / value
  • Unit / calculation basis
  • Reference period
  • Version / revision
  • Method / definition
  • Observed status
  • Limit / uncertainty
  • Decision / next action
  • Review owner
  • Next review

DOCUMENTED REFERENCE

ECB: nine historical rates to check a conversion

These nine observations cover three selected dates in 2025 and three currencies. Extracted on 22 October 2026, this sample is fixed: it is neither a current quote, an annual average nor every day of 2025.

Rates are currency units per euro. Divide a foreign-currency amount by the rate to obtain euros; multiply in the other direction. This calculation does not adjust inflation or include exchange fees or margins.

Fixed extract, consulted on .

Rate table · currency units per EUR 1
Observation dateUSD/EURGBP/EURJPY/EUR
1.03210.83118162.04
1.14190.8434162.98
1.1750.8726184.09

Method: M in currency ÷ T in currency/EUR = M/T in EUR. Reverse: M in EUR × T = M×T in currency.

Use a dot or comma as the decimal separator and spaces for thousands. Negative amounts are accepted to examine a correction.

1 000.00 USD gives 968.90 EUR. Observation on 2025-01-02: 1 EUR = 1.0321 USD.

Arithmetic illustration: the entered amount is an exercise, not observed expenditure. Results use two decimal places; calculations use the stored rate. The ECB publishes reference rates for information and discourages their use for transactions.

Series keys and extraction method

Frequency D: daily. Three separate dates, no interpolation of missing days. Quote is currency per EUR, with unit multiplier 0 in the responses. All nine values retain source precision; derived calculations are not additional official rates.

  • EXR.D.GBP.EUR.SP00.A
  • EXR.D.JPY.EUR.SP00.A
  • EXR.D.USD.EUR.SP00.A

Source: European Central Bank. Nine observations reproduced unchanged; conversions and presentation calculated by this site. The data are also freely available from the ECB.

Open ECB source · ECB reuse conditions

DEEPER READING / PRACTICE

Documenting the nature of the amount before conversion

Two public amounts are expressed in different currencies, dates or conventions. The conversion must specify what is measured and the rule selected to bring the values closer.

Updated on .

Priority checks

Identify currency, date, unit, amount status and conversion base. Distinguish nominal value, estimate, commitment and expenditure when the sources allow it.

Interpretation pitfalls

Converting the currency does not make amounts of different nature comparable. An annual value and a multiannual value do not answer the same question.

Working record to retain

The table retains original amounts, rule, conversion reference and result. The comparisons specify the hypotheses and the limits of reading.

PRACTICAL CASE / WORKED EXAMPLE

Converted amounts do not describe the same transaction

The pedagogical example concerns the preparation or interpretation of data. It shows why a technically possible calculation should remain linked to verified definitions, versions and transformation rules.

Example context

Two values are returned to the same currency. One is a multiannual estimate, the other a amount observed for a shorter period.

Suggested approach

Qualify the amounts, their dates and their periods. Document the conversion reference and keep the initial values. Examine the possibility of comparison regardless of the final monetary unit.

Conclusion and next step

The presentation distinguishes conversion and comparability. The values remain separate when their nature or coverage does not allow a common conclusion.

Questions for deeper practice

Which conversion reference to choose?

The rule depends on the question and the relevant dates. Indicating the source, period and method selected allows you to understand the result and to examine the effect of another choice.

DETAILED WORKSHOP / APPLICATION

Separate the conversion rule from the amount’s economic meaning

  1. 01 / Prepare the necessary information

    Prepare the original amount, currency, date, period and status. Assemble the selected conversion reference and definitions associated with compared values.

  2. 02 / Carry out the approach

    Apply the rule by keeping the entries and results. Then examine estimation, commitment or other documented nature. Check the periods before an aggregation or comparison.

  3. 03 / Examine an alternative situation

    If the amounts are convertible but of a different nature, present them separately. The same exit currency does not create a common measure of expenditure or activity.

  4. 04 / Decide on the next step

    The conversion is reproducible when source, date and method are indicated. The conclusion explains the permitted comparisons and those that remain out of scope.

  5. 05 / Hand over the verification records

    Transmit the original table, rule, result and reserve. Readers can distinguish a monetary reference change from a new information on the amounts themselves.

ANNOTATED WORKING DOCUMENT / REVIEW GRID

A table that keeps the original amounts and their nature

The table indicates value, currency, period, status and conversion reference. It distinguishes monetary approximation and comparability from the transactions described by the sources.

On a small screen, scroll the grid horizontally to read all three columns.

Example situations to assess
ObservationSupported interpretationNext step
The conversion and its parameters are documented.The result is reproducible according to the rule.Keep source and date and then examine the nature of the amounts.
An estimate is compared to an observed expenditure.Converted values do not necessarily describe the same reality.Qualify the amounts and reduce the scope of the comparison.
Annual and multiannual periods are mixed.Aggression or classification can be misleading.Align the periods when the data allow it.

Reviewing the working document

The final verification examines the definitions before the converted number. A common final unit should not hide the differences in period, status or coverage that influence interpretation.

REPORTING / EXAMPLE WORDING

Presentation of results: Documenting the nature of the amount before conversion

Point to clarify

A monetary conversion does not make the values of a different nature identical.

Before handing over

Keep initial values, amount status and conversion assumptions.

Example of a qualified conclusion

The amounts are converted according to the reference and date selected. Comparisons remain limited to operations and sufficiently compatible periods.