KT Sparks

Italy · regional government acting as managing authority for EU structural funds

UiPath Checks EU Training Grant Expenses for an Italian Region

When a region reimburses an EU-funded training project, every line needs checking: attendance registers against the hours declared, trainer CVs against their roles, each invoice against the expense report. By hand, that check is slow and depends on who does it, and if EU auditors later find something it missed, the region takes the hit. Today a robot assembles each project's control file, and controllers review the evidence rather than retyping it.

UiPath Checks EU Training Grant Expenses for an Italian Region
Industry
Public Sector
Function
Finance & Accounting
Region
Italy

Results

3
evidence sources checked for each project
Registers, trainer CVs and invoices, each compared with the expense report. A scope figure, not a saving.
4
stages the robot runs on each project
Control sheets, hours versus plan, trainer CVs, invoices. A scope figure, not a saving.
1
standard control workbook for every project
The same structure each time, signed off by the controller. A scope figure, not a saving.

01

The challenge

The client is a regional government in Italy that acts as managing authority for EU structural funds across its territory. That includes the European Social Fund, which pays for training for companies and their workers. The region must verify each beneficiary's expense report before it reimburses a training project.

For each project, a controller opened the expense model exported from the regional system, then each attendance register, each trainer's CV and each invoice, and compared them all with one another by hand. Nothing in the process was automated.

Where the time and risk went

  • Many projects per call. One funding call spans a large number of projects, and each brings registers, CVs and invoices that all need checking.
  • Typing instead of judging. Controllers spent their hours copying names, hours, amounts and invoice numbers into control sheets rather than assessing them.
  • No consistency. Each controller ran the same check their own way, and there was no standard control file.
  • Exposure to audit. If an expense is reimbursed by mistake, it becomes an irregularity in EU funds, and the region answers for it.
  • Grants paid late. Each week spent checking by hand is another week the company waits for its grant.

02

What we did

We built a UiPath robot that runs on the region's own infrastructure. It picks up each funded project, collects the evidence and produces a standard control workbook that the controller reviews and signs off. We owned the whole delivery: analysis together with the region, architecture, development and testing.

Each project is its own work item

The robot reads the list of projects due for control and queues one item per project in UiPath Orchestrator. Every project is then processed, retried and reported independently.

Four stages for every project

  1. A control sheet for each register. The robot adds one sheet to the project's control workbook for every attendance register in the project, and re-runs create no duplicates.
  2. Hours compared with the plan. From every register it reads the titles of the activity and the edition, the trainers with their hours, and the planned and actual attendance hours of each trainee. It then matches the edition to the trainee list in the expense model and writes everything into the control sheet.
  3. Trainer eligibility from CVs. It compiles the trainer list from all registers, locates each CV, reads the PDF and pulls out roles and date ranges using pattern matching. The controller uses this record to confirm whether each trainer is eligible.
  4. Invoices compared with the expense report. For each expense line declared as an invoice, it locates the PDF with the same document number and reads the invoice date, supplier, tax code, taxable amount, VAT and total. Declared and actual values sit next to each other, with matches flagged.

UiPath best practice throughout

Built on the UiPath Robotic Enterprise Framework: a config file, Orchestrator queues, business-rule exceptions separated from system exceptions, retries, screenshots on exception and a test harness.

The decision belongs to the controller

The robot gets the evidence ready. The regional controller takes the decision and signs it.

Compliance built in

EU cohesion rules require the managing authority to confirm that co-financed spending is real, eligible and documented before any payment. For every project the robot delivers a consistent control file that can be reviewed, leaves the controller's signature as the point of decision, and logs an exception whenever it cannot finish a project.

The stack

LayerTools
AutomationUiPath Robotic Enterprise Framework (REFramework), UiPath Studio
OrchestrationQueues in UiPath Orchestrator
SpreadsheetsBalaReva Excel activities, UiPath Excel activities
DocumentsUI automation of Adobe Acrobat Reader, UiPath PDF activities for text extraction
Extraction rulesVB.NET, regular expressions
QualityAutomated test harness
InfrastructureClient-provided Windows infrastructure

03

The outcome

We did not measure time or cost savings on this project, so we describe the result as a change in how the work is done.

ManualAutomated
How verification runsEntirely by handAutomated, the controller reviews and signs off
Gathering evidenceCopied manually into control sheetsThe robot reads and writes it
The control fileVaried from controller to controllerA single standard control workbook for each project
Registers, CVs and invoicesChecked against each other manuallyReconciled with the declared expense report automatically
A document nobody expectedThe controller is held upOne project stops with a logged exception, the run continues
  • Verification moved from fully manual to automated.
  • Each project goes through the same control, ending in the same workbook structure.
  • Controllers check evidence that is already prepared, rather than typing it in.
  • Attendance registers, trainer CVs and invoices, three evidence sources, all reconciled automatically with the declared expense report.
  • Delivered within a regional government on infrastructure it owns, with us leading from analysis through to testing.

Why grant robots break

Grant evidence never arrives in one shape. Every call, beneficiary and year brings registers with slightly different layouts, CVs in all kinds of formats and invoices that are scans instead of digital files. A robot designed around one sample fails on the next call. In this build each project is a separate work item. Business-rule exceptions, such as missing or mismatched evidence, go to the controller. System exceptions retry. They are handled apart, and the controller keeps the decision. A surprise document halts one project, not the whole run, and can never become a reimbursement nobody checked.

More work on controlling EU funds: an AI internal audit assistant that runs on-premise, designed for a public agency that administers EU funding.