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 | Multi-site Restaurant Dashboards

€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 for 6 years, Python dev for 2 years. I help multi-site SMEs (restaurants, bakeries, franchises) and accounting firms move away from Excel to build modern, reliable, and collaborative management tools.

My value: I speak both languages. 4 years of operational accounting in a holding company with 5 bakeries (e-winfic, Cegid Quadratus), combined with solid Python practice to automate and cross-reference data sources.

My packages:

▸ Standalone HTML management dashboard: readable in 5 seconds by a non-accounting manager, real-time sync, 100% local. Package €1500 + €150/month maintenance.

▸ Consolidated multi-site reporting with real-time sync between manager and accountant. Package €3000 + €200/month.

▸ FEC audit with detailed report (12 rules: supplier duplicates, VAT discrepancies, suspicious labels, wrongly mapped accounts). Package €800, delivered within 4 days.

▸ Uber Eats / Deliveroo split audit: cash recovery often exceeds audit cost. Package €800.

▸ Untangling chaotic Excel (50 sheets, broken formulas): clean redesign + 1h training included. Package €1500.

Concrete case: a chain of 5 bakeries, 2 days/month of Excel reporting replaced by a real-time sync HTML dashboard. 95% time saved, zero version conflicts, monthly figures calculated locally. No data sent to external LLMs: 100% confidentiality.

Stack: Python (openpyxl, pandas), Cegid Quadratus, e-winfic, Advanced Excel, SQL, HTML/CSS/JS for live dashboards.

Live demo of a 5-store dashboard (anonymized data):
Method: free 30 min discovery call via video, quote within 48h, 40% deposit, dated delivery, 1h training included. No hidden fees.

100% remote work. Evenings, weekends, and deliverable packages with dated deadlines.
  • French

    Native or bilingual

  • English

    Fluent

  • Italian

    Conversational

Remote only
Primarily works remotely

Experience

  • Groupe restauration · 5 boulangeries franchisées
    Accountant
    RESTAURANTS AND FOOD SERVICE
    September 2022 - Today (3 years and 9 months)
    La Valette-du-Var, France
    Accounting management for a multi-entity holding company operating 5 franchised bakeries in France. Beyond standard accounting, I progressively built the internal management tools that didn't exist in the standard stack.

    Achievements:

    • Construction of a consolidated multi-site HTML dashboard (Revenue, Gross Margin, Food Cost, Staff Costs, 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, including cash, delivery platforms (Uber Eats, Deliveroo), and suppliers.

    • Preparation of multi-site payroll variables.

    • Internal FEC audit: detection of supplier anomalies (duplicates, invoice/delivery note discrepancies), 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
    Transition to Data and Automation
    CONSULTING AND AUDITS
    March 2021 - March 2022 (1 year)
    La Valette-du-Var, France
    Skill development period in data tools applied to accounting: Advanced Excel, Python (pandas, openpyxl), automation of repetitive tasks.
    Personal projects practicing 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
  • Stores Di Lucca
    Accountant
    RETAIL (SMALL BUSINESS)
    December 2019 - February 2021 (1 year and 2 months)
    La Seyne-sur-Mer, France
    First accounting experience within a company specializing in stores and interior design. Routine accounting for the head office.

    Achievements:

    • Daily accounting entries (purchases, sales, bank, miscellaneous operations).

    • Monthly bank reconciliations.

    • Tracking and reconciliation of supplier and customer accounts.

    • Preparation of elements for VAT declarations.

    • Filing and archiving of accounting documents.

    Tools: Quadratus (Cegid Quadra), Excel.
    Accounting Accounting Entry Bank Reconciliation Microsoft Excel Quadratus

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 (Management and Technology Sciences)
    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