/eu-financial-transparency

name: eu-financial-transparency
description: "Find out which EU grants and directly-managed EU funding an organisation has received - for free, keyless - using the official EU Financial Transparency System (FTS). See EU funding recipients: who received EU money, how much (committed amount / EU contribution), under which programme and budget line, in which year, and for what action. This is an EU-funding-recipient due-diligence + grant-recipient lead-gen lane, NOT a company registry. Trigger on: 'EU funding recipients', 'EU grants', 'FTS', 'Financial Transparency System', 'who received EU money', 'did this org get an EU grant', 'EU grant recipient check', 'EU direct funding', 'beneficiaries of EU funds', 'EU budget beneficiaries', 'which EU programmes funded this organisation'. FTS is a bulk annual download (one .xlsx per year) plus a live search export - download the year file(s), then filter and match locally by name, country, and programme."
metadata:
  version: 1.0.0
  author: regdata
  tags:
    - free-api
    - due-diligence
    - lead-gen
    - eu
    - funding
    - grants
    - fts
  triggers:
    - "which EU grants has this organisation received"
    - "EU funding recipient check"
    - "Financial Transparency System lookup"
    - "who received EU money"
    - "beneficiaries of EU direct funding"
    - "which EU programmes funded this org"
    - "EU grant recipient due diligence"
    - "grant-recipient lead generation"
    - "did this company get EU funding"

eu-financial-transparency

Find out which EU grants and directly-managed EU funding an organisation has received - free, keyless, no login. The EU Financial Transparency System (FTS) is the European Commission's public list of recipients of funds the Commission manages **directly** (grants, procurement contracts) and **indirectly**, plus the European Development Fund. This is an **EU-funding-recipient due-diligence + grant-recipient lead-gen** lane: it answers *which EU money has this organisation received, how much, under which programme, in which year, and for what action* - it is not a company registry and does not confirm a company exists or trades.

FTS is published as **bulk annual datasets**, not a per-name query API. The skill is the same pattern as `eu-transparency-register`: download the year file(s) once, cache them, then filter and match locally by name, country, and programme.

Persona

You are a due-diligence analyst and lead-gen researcher working the public-money angle. You read FTS to answer two questions: *has this counterparty received EU grants or direct EU funding, how much, and under which programme* (a credibility and public-exposure signal), and *which organisations are being funded in a programme or country* (a warm grant-recipient list - recipients of EU money are an ICP that has already cleared a Commission funding process).

What this gives you (for free)

• **Every recipient of directly / indirectly managed EU funds** - beneficiaries of

Commission-managed grants and procurement, plus the European Development Fund: companies, NGOs, universities, research bodies, public authorities, and consortia.

• **The amounts** - the committed amount and the EU contribution for each recipient,

per action / year.

• **The funding context** - the programme name, the budget line, the subject / action

or project, the funding type and contract type, and the responsible Commission department.

• **Recipient identity** - beneficiary name, VAT number, beneficiary type,

country and city, and the coordinator / consortium role where the action is a multi-partner project.

• **Project metadata** - the reporting year and the project status.

Licence: EU open reuse under Commission Decision 2011/833/EU - commercial and non-commercial reuse permitted. Read-only.

Data source (no key)

There is **no public REST / JSON API**. Two tracks, both free and keyless:

| Track | What | Where | |---|---|---| | Live search + export | HTML search on the FTS Analysis portal with an **Export -> Excel** button | `https://ec.europa.eu/budget/financial-transparency-system/analysis.html` | | Annual bulk datasets | One `.xlsx` per year (2007-2025), mirrored on the open-data portal | `https://data.europa.eu/data/datasets/fts` |

FTS portal base: `https://ec.europa.eu/budget/financial-transparency-system/`

The skill shape is: download the year file(s) you need from the open-data portal, then filter locally by beneficiary name, country, and programme - exactly the download-and-match pattern of `eu-transparency-register`. Use the live search + Excel export when you want a pre-filtered slice of a single year instead of the whole file.

# Grab a year's bulk dataset from the open-data catalogue page, then query locally.
# (The catalogue page lists one .xlsx download per year, 2007-2025.)
#   https://data.europa.eu/data/datasets/fts

Fields in the dataset

Per recipient / action the FTS data carries: beneficiary **name**, **VAT number**, **beneficiary type**, **country** / **city**, the **committed amount** and the **EU contribution** (amount), the **budget line**, the **programme name**, the **year**, the **subject / action**, the **funding type**, the **contract type**, the **responsible department**, the **project status**, and the **coordinator / consortium role**. Field labels vary slightly across year files - confirm the header row of the specific year's `.xlsx` rather than assuming a fixed schema.

Workflow: which EU funding has this organisation received

1. Pick the years
   -> FTS is one .xlsx per year (2007-2025); download the years in scope
   -> data for year N is published end-June of N+1 (~12-month lag - the latest
      full year may not be available yet)

2. Download + cache the year file(s) from the open-data portal
   -> or run the live search on the Analysis portal and use Export -> Excel
      when you only need a filtered slice of one year

3. Match the target against the benefi