Excel Bonus System for the Jewellery Industry
Author: Grzegorz Ługowski - Founder & Lead Engineer, GL Omniflow.
For a jewelry brand, we streamlined a Microsoft Excel system used to calculate employee bonuses. The solution made bonus calculations and daily operations faster and easier while fully preserving support for complex exceptions.
What problem did the client have?
Bonuses for jewellery store staff were calculated by hand from daily sales reports and working hours. The rules had many exceptions, and online sales had to be separated from in-store sales. It took management a lot of time and risked mistakes.
How does the daily report work?
At the start of the day an employee generates the daily report and enters the start and end time of their shift. They then paste the daily takings from the Jubilabelling system one to one. The program separates online and in-store sales on its own and calculates the bonus from in-store sales for one or more people - depending on who was on shift and when.
How is the monthly summary created?
Every daily report is saved automatically to a Google Drive folder. When the monthly summary is run, the program reads all reports itself and totals hours worked, store and online sales and bonuses for each employee - without errors.
What was the result?
The system saves on average about 50 hours a month of work for managers and senior staff. Bonuses are calculated automatically and without mistakes, and Excel remained the tool the team already knew.
Result: smoother workflows despite complex rules
The system simplified employee bonus calculations and became much easier to work with, even with numerous exceptions.