Technical FAQs#

Which transaction types are used in summary tables?

  • Spend data is the sum of expenditure and disbursments. If these are not published, outgoing commitments will be used.

  • Total commitment is the sum of outgoing commitments. If these are not published, expenditure and disbursments will be used.

  • Budget is the sum of budgets. If these are not published, planned disbursements will be used.

How is the data cleaned?

TO BE UPDATED following release of the data policy.

How is data assigned to a specific year?

  • For transactions, using the value or transaction date.

  • For budgets, using the end date.

How are exchange rates calculated?

  • Default USD: The value date is used as the exchange date.

  • Other currencies: The USD value is converted using today’s exchange rate.

  • Foward looking budgets: Using the latest exchange rates nightly. There is a full re-import once a week.

Why is my organisation’s data missing from a recipient countries chart/table/map?

  • Charts need a transaction with a transaction date in the relevant year, with a valid recipient country code or sector code.

  • Tables need a transaction with a transaction date in the relevant year, with a valid recipient country code or sector code.

  • Maps need transactions with a valid location tag and recipient country code.

Why are graphs missing from my activity?

Graphs are only shown for an activity if all transactions are in the same currency.

What is the source of country codes and descriptions?

The ISO 3166-2 Wikipedia page.

Where is the additional data used in d-portal stored?

In github. This includes:

  • List of Reporting Organisation IDs

  • Currencies

  • Exchange rates

  • Sector codes

Why are sectors aggregated using DAC 3 Digit codes?

Some organisations only publish data with DAC 3 Digit codes. DAC 5 Digit codes are converted to 3 digits for d-portal visualisations.