Moving average rate procedure

The moving average rate procedure[1] is a proven procedure within development cooperation to convert locally used currency of the projects (voucher currency) to the currency used at the head office (company currency). This procedure prevents any profits or losses resulting from fluctuating exchange rates. It allows to fully translate the countervalue of all funds given to the project to costs.

Background

edit

The moving average rate procedure has been developed in the 80s on behalf of the German Federal Ministry of Economic Cooperation and Development (BMZ) to properly account for the funds made available to the public implementing agency GIZ.

By and by, the procedure has been adopted by other aid agencies, and is meanwhile a widespread instrument for exchange rates conversions. Many other donors such as the German Federal Foreign Office, the Worlds Food Programme or the Humanitarian Aid and Civil Protection department of the European Commission (ECHO) also accept the procedure in accounting for their funds.

Calculation

edit

The calculation is based on the total balances in company and voucher currency and the newly received funds. The following formula is used:

 

Example with EUR as company currency:

Voucher currency Value in (EUR) Average rate
1. Supply of funds 100.000,00 50.000,00 0,5
Costs 80.000,00 40.000,00 0,5
Total balance 20.000,00 10.000,00 0,5
2. Supply of funds 80.000,00 50.000,00 0,625
Total balance 100.000,00 60.000,00 0,6
Costs 70.000,00 42.000,00 0,6

Application

edit

WINPACCS has the moving average rate procedure inbuilt. Many aid agencies still do this calculation using a spreadsheet.

Sources

edit
  1. ^ White Paper Average Rate Procedure - Retrieved 30. August 2023 (PDF; 678 kB).