We keep track of completed services in ClickUp. From there, it is possible to import into Excel or csv. Based on data about how many videos we have edited, how many scripts we have written, which employee, what payment they receive for it, and so on. We need to consolidate the data.
For example:
- Calculate each person's salary for the period from the 1st to the 15th and from the 16th to the 31st for specific tasks and for which project.
- See how many videos are paid for (based on our data, which is updated), how many are completed for each project, and how many are still remaining.
- View the salary fund, how much money should be frozen from all incoming payments.
- Determine the company's profit.
- Create a general Dashboard with company metrics.
*It seems important to me to have skills in working with dates (they will be provided from our side based on the database, but on their basis, it should be properly consolidated weekly, monthly, etc., so that different periods can be selected for analysis).
How can I send this to you personally so as not to share data with everyone?
It would be more convenient for me to explain what is needed in a short call or via voice messages in Telegram as an option. Is there a way to switch to that?