Problem Statement: The Client wanted to streamline the expense approval process which was done by different teams in the company in a different ways.
Magikos Solution: A Google sheets based expense tracker with approval mechanism. Employees can add/request their expenses and authorized personnel can grant these expenses for the projects. Along with this book-keeping, a dashboard was also implemented. This dashboard gets updated in real-time as new expenses are logged by the users.
google spreadsheet, google apps script, data studio