You're seeing this page as if you were . The main menu is still yours, though. Exit from immersion
Frank L.FL

Frank L.

Accountant + Dev | Dashboards & Financial Analysis

€550/day
La Valette-du-Var, FR
3-7 years

Average response time: 1 hour

Freelancer profile translated to English.
Back to original language

About Frank

Accountant since 2019 (multi-site restaurant holding, 5 establishments) and developer, I combine two rarely complementary professions: accounting and coding. The result: management tools and financial analyses that leaders actually use.

Three areas of intervention:

1. MANAGEMENT: Multi-site dashboards (Revenue, margins, payroll, losses, automatic alerts), outsourced management control, budget vs. actual. Achievement: consolidated dashboard for a group of 5 bakeries, monthly reporting reduced from 2 days to 2 hours. Standalone file, readable on mobile, no data sent to an external service.

2. FINANCIAL ANALYSIS: One-off high-value diagnostics, delivered in 48-72 hours with a sourced recommendation note. Examples: analysis of equity and eligibility for public aid (EU definition of company in difficulty, BPI grant applications), forecasts and business plans, investor reporting for startups, electronic invoicing compliance (flow analysis, choice of approved platform, configuration, training: deadline September 1, 2026).

3. AUTOMATION: Allocation of supplier invoices, customer reminders, consistency checks on accounting exports (FEC), automated reporting. Python + Excel/Power Query. Noted gain: from 45 minutes to 5 minutes per invoice processed.

My method: your accounting firm handles the production of accounts and tax returns; I handle everything around it: data, tools, analyses, processes. Fixed-price quotes with dated deliverables and deadlines.

Stack: Advanced Excel, Python, SQL, HTML/CSS/JS, Cegid/Quadra, e-winfic, REST API.

Response on the same day.
  • French

    Native or bilingual

  • English

    Fluent

  • Italian

    Conversational

Remote only
Primarily works remotely

Experience

  • Lopiccolo Consulting
    Financial Management & Automation Consultant
    April 2026 - Today (4 months)
    Independent consulting activity in financial management and automation for multi-site SMEs and startups.

    Achievements:

    - Consolidated multi-site management dashboard (anonymized public demo available): Revenue, margins, food cost, payroll, automatic alerts, real-time multi-user synchronization.

    - Public aid eligibility diagnostic tool: analysis of equity and "company in difficulty" status according to EU Regulation 651/2014 (access condition for Bpifrance grants), costing of recapitalization options, sourced recommendation note (EUR-Lex, Bpifrance, CJEU).

    - Accounting automation pipelines: allocation of supplier invoices into budget categories (from 45 min to 5 min per invoice), consistency checks on FEC, automatic report generation.

    Tools: Python, Advanced Excel, SQL, HTML/JS, REST API.
    Financial Analysis Dashboard and Reporting Automation Python Contôle de gestion
  • Groupe restauration · 5 boulangeries franchisées
    Accountant
    RESTAURANTS AND FOOD SERVICE
    September 2022 - Today (3 years and 11 months)
    La Valette-du-Var, France
    Accounting management for a multi-entity holding company operating 5 franchised bakeries in France. Beyond traditional accounting, I progressively built the internal management tools that were not present in the standard stack.

    Achievements:

    • Construction of a consolidated multi-site HTML dashboard (Revenue, gross margin, food cost, personal expenses, prime cost, revenue loss), real-time sync via Dropbox API, anomaly alerts vs. French targets, PDF export, full-screen TV mode. Used daily by the manager and the accounting firm.

    • Automated allocation of supplier invoices into budget categories, with specific rules per store.

    • Monthly multi-entity accounting keeping, including cash register, delivery platforms (Uber Eats, Deliveroo), and suppliers.

    • Preparation of multi-site payroll variables.

    • Internal FEC audit: detection of supplier anomalies (duplicates, discrepancies between delivery note/invoice), corrections delivered in 490 cells + 45 formulas.

    Tools: e-winfic, Advanced Excel, Python (pandas, openpyxl), Dropbox API, HTML/JS.
    Accounting Advanced Excel Financial Reporting Python Automation Management Accounting
  • Activité Personnelle
    Career change towards data and automation
    CONSULTING AND AUDITS
    March 2021 - March 2022 (1 year)
    La Valette-du-Var, France
    Skill development period focusing on data tools applied to accounting: Advanced Excel, Python (pandas, openpyxl), automation of repetitive tasks.
    Personal practice projects on real-world cases (invoice allocation, multi-site dashboards).
    This transition laid the foundation for my current approach, combining field accounting with the industrialization of internal tools.
    Python Microsoft Excel Data Analysis Pandas Automation

Recommendations

Be the first to recommend Frank

Help this freelancer shine by sharing your experience working together.

These freelancer profiles also match your criteria

AgathaA

Agatha Frydrych

Backend Java Software Engineer

4.7

(3)

2

BaptisteB

Baptiste Duhen

Fullstack developer

4.6

(4)

5

AmedA

Amed Hamou

Senior Lead Developer

4

(2)

7

AudreyA

Audrey Champion

Web developer

4.3

(3)

4

Education

  • Baccalauréat STG (Science and Technology Management)
    Lycée Dumont D'Urville
    2011
  • Continuous training in Python / Data / Automated Accounting
    Self-taught (Claude Code, OpenClassrooms, official documentation)
    2024
    Acquisition Python (openpyxl, pandas), SQL, Power BI, automatisation pipelines comptables.

Certifications

  • Pennylane Academy
    Pennylane
    Electronic Invoicing Pennylane Cloud Accounting

Skill set

Categories