scndcorp
Available
Work
Personal projectDeveloper (solo)

Automated accountant dashboard: from raw file to financial statements

Personal project, turns a raw accounting file into structured financial statements (PCG, SIG, balance sheet, cash flow) and exports them to Excel, 100% automatic.

Personal project

Challenge

An accountant needed, as part of a Master's thesis in accounting, a tool capable of turning a raw accounting file (trial balance or general ledger) into usable financial statements according to French accounting rules, with no manual entry at all. Doing the work by hand (mapping accounts to the PCG, computing the SIG, the balance sheet, the cash flow, Excel formatting) is long, repetitive and error-prone.

Impact

  • Fully automated pipeline: from raw file to financial statements, with no manual entry
  • Automatic detection of the format (trial balance / general ledger) and columns, even when poorly named
  • Application of French accounting rules (PCG, SIG, balance sheet, cash flow, ratios)
  • Structured multi-sheet Excel export, directly usable
  • Business rules provided and validated by an accountant

Context

A personal project born from a concrete need, as part of a Master's thesis in accounting. A clear split: the accountant provided and validated the business rules, and I designed and coded the entire application.

The challenge: automating everything, from the raw file to the final Excel

The difficulty was not the accounting calculations themselves, but producing them from real files that are rarely clean: the app had to stay reliable whatever the shape of the file dropped in, and faithfully translate into code the French accounting rules provided by the accountant, without ever distorting the domain.

What was delivered

A Next.js application that runs in the browser (Next server):

  • Drag-and-drop of a raw accounting file
  • Automatic detection of the mode (trial balance vs general ledger) and columns, with tolerance for malformed or poorly named columns
  • Automatic mapping of accounts to the Plan Comptable Général
  • Computation of the balance sheet, the SIG cascade, financial ratios and cash flow
  • Structured Excel export, multi-sheet, ready to use

Stack

Next.js / TypeScript. The value of the project: turning a demanding business domain (French accounting) into a fully automated pipeline that is tolerant of real-world data.

Stack

The technologies used on this mission.

  • Next.js (App Router)
  • TypeScript
  • Drag-and-drop import
  • Excel file generation

A similar project in mind?

Let's talk through your challenges and see how to turn your vision into maintainable, tested technical reality.