E-Ksiegowa Telegram bot: work time tracking and Excel

Task: > Create an autonomous system for staffing agencies and workers that replaces manual shift accounting and fully automates the calculation of complex salaries.

What has been implemented:
A multilingual Telegram bot (PL, UA, RU) has been developed with flexible individual settings for each employee.

Key functionality:
Smart input parsing: The bot understands data from simple text (route, working hours, type of shift) and instantly calculates earnings (Brutto/Netto).
Custom financial settings: Accounting for base rate, travel expenses, additional payments for driving, night shifts (+20%), and tax coefficient.
Generation of professional reports: Upon request, the bot generates a detailed .xlsx file (Pandas). The report includes color coding for the convenience of accounting (sick leave L4 — red, vacations — yellow).
Reliable architecture: Intelligent duplicate protection system when recording shifts (based on SQLite).

Technology stack: #Python, Telegram Bot API, #SQLite (database), #pandas (working with Excel), deployment on server.

#pythonbot #Telegram-developer #pyTelegramBotAPI #databases #DataProcessing