spark-it solutionsspark-it
Gopi Poha EMS
Desktop

Gopi Poha EMS

Internal employee management system for a manufacturing unit.

Objective

The Goal

Develop a private internal desktop application for managing employee records, attendance, and financial transactions within a poha manufacturing unit, replacing manual spreadsheet-based workflows.

Challenge

The Problem

The system needed to be simple and reliable for daily use by factory staff, while also handling attendance tracking, salary calculations, and employee-level financial transactions like borrow and deductions without introducing complexity.

Solution

How We Solved It

Built a desktop application using Electron with a React + TypeScript + Tailwind UI, backed by Node.js and MongoDB (Atlas) via Mongoose for structured and scalable data management.

What We Built

Key Features

Employee Records

Manage employee profiles with relevant personal and work details.

Attendance Tracking

Daily attendance marking with historical records.

Payroll Management

Salary calculation based on attendance and predefined rates.

Financial Transactions

Track borrow, deductions, and adjustments per employee.

History & Reporting

View detailed logs of attendance and financial activity over time.

Simple UI

Minimal and intuitive interface designed for internal staff usage.

Outcome

Results

Internal toolType
Windows desktopPlatform
Factory staffUsers

Lessons Learned

Designing internal tools requires balancing simplicity with functional depth. Clear workflows for attendance and financial tracking significantly reduce operational friction, while a structured backend ensures long-term maintainability.

Built With

Tech Stack

frontend
Electron.jsReactTypeScriptTailwind
backend
Node.jsMongoDBMongoose
infrastructure
MongoDB AtlasWindows desktop deployment