Emilien Deschodt

The company faced a highly fragmented and extremely time-consuming construction site management. Field monitoring of operational activities lacked fluidity, imposing a heavy burden of manual administrative work on management. The company also urgently needed to integrate a fully custom invoicing tool, as standard software providers were not customizable enough. Finally, a major technical and legal constraint was added: all invoices had to be routed through the secure European Peppol network.

Architectural design of a unified ERP system precisely covering the entire lifecycle of construction sites (measurement generation, order management, logistics tracking, and installation validation).

Creation of connected data flows natively integrating the European invoicing network Peppol, through precise technical synchronization between the AppSheet platform and the Falco management system.

Advanced integration of the OpenAI Artificial Intelligence API. The objective is to read, analyze, and extract key data from incoming invoices in a fully automated manner.

Deployment of an interactive financial dashboard and granular role management securing data access for various field users.

The development of this infrastructure resulted in complete operational fluidity in the field, coupled with structural cost savings and a measured reduction of 3 hours of daily administrative management for the leadership.

The company suffered from administrative overhead that severely impacted the profitability of all its projects. The complex invoicing cycle and daily time tracking required too much manual data entry. Budget management became too time-consuming: project-based budgeting and the lack of expense tracking led to significant cost overruns. It was essential to structure a database linking each contract to a specific project, track team hours, and ensure Peppol compliance by connecting Falco to a custom AppSheet interface.

Creation of an interface centralizing all contracts and deliverables. Cross-tracking to compare initial quotes with actual expenses per project phase.

Time tracking system for employees to easily log their hours on the AppSheet mobile app. These hours are allocated to the project's cost of goods sold.

Automation of document generation (invoices, credit notes, quotes) and automated integration of flows onto the secure European network by connecting AppSheet with Falco and Peppol via API.

The synchronization of worked hours with invoicing immediately eliminated errors and accelerated payments. The AppSheet system massively reduced administrative work hours for the teams, freeing up valuable time for production. The company drastically reduced additional costs per project: thanks to rigorous structuring of quotes by phase and real-time expense tracking, budget leaks are finally plugged. Net margins optimized and legal compliance guaranteed.

In a context of inflation, management struggled to maintain pricing agility. The establishment suffered from strong operational rigidity. With every fluctuation in supplier prices, the cost of goods for the entire menu had to be manually recalculated. The goal was to replace static spreadsheets with an interactive tool connected to purchasing, ensuring precise profitability, by creating a custom interface via the AppSheet platform.

Development of a technical sheet creation module dynamically linked to ingredient purchase prices, automatically recalculating production costs and gross margins for all dishes.

Raw material database with precise tracking of inventory levels and supplier price variations, preventing stockouts or shortages.

Analysis interface allowing management to visualize the impact of a price increase on a global recipe, enabling near-instantaneous adjustment of selling prices on-site.

The definitive end of time-consuming administrative calculations. Instant visibility into profitability allowed for optimization of all margins in real-time, transforming menu operational management into a strategic tool. Continuous monitoring of perishable goods inventory led to a significant reduction in waste and shortages, considerably increasing the restaurant's overall net profit margin. This digital transformation allowed the manager to focus fully on their core business with data visualization tools.