I will commission the preparation of a financial management system based on Microsoft Excel.
A spreadsheet for analyzing financial data - company budget statement of costs, revenues, margin calculations, production costs, controlling working hours, salaries, vacations, marketing data, roas, KPIs, forecasts, goals and their implementation.
Tasks to be performed and Functions:
Needs analysis, pricing and system design
Preparation of the backend of the system
Preparation of the display of reports in an accessible form
Preparation of data presentation in powerBI (not mandatory)
Integration with invoicing program after API
Integration with PostgreSQL sales and production system database
Integration with RCP system (work time recorder)
Due to the rather complex nature of the business - complex production, a large number of products and variables, marketing, sales. Experience in financial data analysis is welcome.