DEV Community

Cover image for 🚀 Extension Project III: from spreadsheet chaos to a web app
Delean Mafra
Delean Mafra

Posted on

🚀 Extension Project III: from spreadsheet chaos to a web app

So here’s the deal: this semester I jumped into a real-world challenge with a partner company. Their entire financial and inventory management was stuck in spreadsheets. Manual entries, repetitive calculations, errors everywhere, zero visibility for decision-making. Basically… a nightmare.

And I thought: seriously, in 2025 we’re still doing this?
Time to fix it.

What I built
A Python + Flask web app that merges finance and inventory in one place.
No more copy-pasting numbers. Everything’s automated, reliable, and visualized in dashboards that actually make sense.

Key features
Simple interface for income and expense entries

Customizable categories and payment methods

Automatic integration: purchases → expenses, sales → income

Dashboards with 5 core visualizations

Lightweight JSON persistence + client-validated prototypes

Real impact
Hours saved from manual data entry

Fewer errors, more trust in the numbers

Instant visibility of cash flow and spending patterns

Direct support for day-to-day decisions

Tech stack
Python, Flask, Jinja2, Bootstrap, Chart.js..
Nothing fancy — just tools that work.

đź“‚ Repo: https://github.com/Delean-Mafra/pex3
đź“„ Full report: https://delean-mafra.github.io/pex3

🎯 The takeaway
This wasn’t just about coding. It was about proving that tech can turn clunky processes into something agile and strategic.
Spreadsheets are fine… until they’re not.

Top comments (0)