Creating Timesheets with monday.com

Hi Everyone,

My name is Rachel Leigh and I am a Senior, Enterprise Customer Success Manager at monday.com. I work with large accounts, helping them to become more efficient in their day to day work lives. I wanted to share with you a topic that comes up regularly- Timesheet Reporting

Many of you are already using monday to track tasks, so why not utilise the tool further to track how much time is spent on these tasks and is this time being spent wisely?

This can help you to identify:

  • Which tasks take longer or shorter than expected.
  • Do you need to allocate more or less resources in these areas due to the time spent?
  • Are you spending too much time on a particular area and not enough in areas that can help grow your business further?
  • Are some employees working more than others?
  • Are you billing your customers correctly, in accordance to time spent on their account?

I’ve made this short video which explains how to set up boards and some suggestions on the types of insights you can get from your board(s):

To summarize how I set up the board

I added columns to capture the data points I wanted to review:

  • Number column for time spent
  • Person column- who spent this time
  • Status column to track area/customer/project being worked on
  • Numbers for billable or non billable time
  • Formula to calculate into hours or days

And for any other data point that is important to you, add a column to reflect this information.

Other suggestions:

You can have a board per person, or you can have everyone work off of the same board depending on your needs.

To take this a step further, you may want to link to other project boards so on the timesheet board users can reference other boards and where they have spent their time- this can also be pulled into nice reports as to which board and which item have they dedicated their time to.

Once you have this data within the board(s) you can add some amazing charts with the chart view, to visualise where the teams’ time is being spent. You can then make data driven decisions off of this data such as reallocating resources, dedicating more time to certain areas that need further attention etc.

I hope you find this useful!

7 Likes

Thanks for this @Rachelleigh

I’ve be interested in seeing how to power these dashboards using the Time Tracking column with tasks sourced from project boards. Team Members rarely allocate tasks to themselves - this would normally be done by a project manager from a project board. Team Members are also unlikely to get involved in deciding what’s billable, so this would normally be determined by the project manager on task creation.

2 Likes

@stuttters you said what I thought.
@Rachelleigh the Monday company needs to understand that the reallity of who uses the system, is exacly what @stuttters said. We need to use Timetracking Column. I had to develop other system, to read this contents because Monday doesn’t have the feature to understand and centralize in one report of different boards.
Please hear us.

1 Like

@robertogentile @stutters you are absolutely correct. This board is based off of something I built with a customer who wanted their team to update if it was billable or not as they were responsible for this. The video is a loose suggestion of how it monday can be used for timet racking, but it is up to your and your internal processes to determine what columns you have and who will be responsible for updating them.

You can of course adjust this board to suit your specific needs- that’s the beauty on monday.com after all.
You can add a time tracking column and create reports from this if you prefer- I wanted to show this use case in a simple form to accommodate for all types of users. We love to hear that users like yourselves are using monday is a more advanced way and developing tool to sit on top of monday.com.

2 Likes

Thank you for this. If you see, it’s the most important for who control our team using timetracking.
Please, put on top, it’s important :smiling_face_with_three_hearts:

1 Like