Excel applications

Excel & VBA — Invoicing management

Invoicing workbook with quotations, orders, deliveries, invoices and a dashboard, documented by the report and VBA code.

Academic team project

All projects
Excel & VBA — Invoicing management
Project type
Academic
Documented period
2025
Team
Team of 3

Overview

Excel application from a three-person academic team assignment documented in 2025. The workbook organizes commercial documents and invoicing tracking.

Contribution and project context

Academic team project. The documents do not identify individual task allocation.

Approach

  • Workbook inspection

    Read-only inspection of eight worksheets, formulas, tables and VBA modules without executing macros.

  • Document automation

    Analysis of document creation, cancellation, printing and recording procedures.

Work and deliverables

  • Commercial workflow

    Quotations, orders, deliveries and invoices; pre-tax, VAT and total calculations and invoice archiving.

  • Dashboard

    Revenue, paid/unpaid invoices, time trends and payment breakdown.

Findings and recommendations

The workbook illustrates how structured inputs support monitoring indicators, using VLOOKUP, IFERROR and VAT calculations.

Tools and skills

Excel · VBA · RECHERCHEV / VLOOKUP · Tableaux croisés dynamiques

Visual evidence from source materials

Scope and limitations

Academic workbook inspected read-only. Macro execution in Excel has not been tested. Client data and the raw workbook are not published.

Verified sources

APP Gestion de la Facturation F.xlsm

Rapport-G3-KANTANA-KANTANA-LAKHAL.pdf

Explore my skills and background

More to explore

Python — Invoicing application
Python applications

Python — Invoicing application

Tkinter application with clients, products, invoices, SQLite, Excel import and Matplotlib reports.

PythonTkinterSQLite

Academic application — individual role not identified in the sources