Timesheet & Project Management Blog

The goal of this blog is to provide tips and ideas for improving time tracking and project managment for our customers and other interested people.

Simple Timesheet

I have a question about the timesheet you probably get all the time. How do you put notes for the hours that you type into the timesheet?

Yeah, that’s pretty simple. Just find the cell you want to put a note with; for example I’ll do this 2.75 hours, for Mail Handling. You don’t actually have to highlight the number, just be inside of the cell. So I click my cursor inside of the cell, when I do that the next step is to go down to the bottom right corner and click Notes and Detail. When I do that it pulls up a little summary for that increment of time. You’ll see the actual task name is highlighted in blue for Mail Handling. And you can leave that task name in the system as it is or override it if you like. Most people leave that name already in the system alone and then they just type their notes right after that. They would say something to the effect “Mailed 24 overnight packages.” When you’re done hit Save and Close down here at the bottom of the box. And you’re done, those notes are in the system. Once you type time into the timesheet it becomes what we call a time log-a historical record of time. If you click over here to the right of Timesheet and click on the Time Log you’ll see basically the same information from the timesheet but arranged in a different manner. In this case I want to find that increment of time where I typed my notes in so I’m going to go over here to the left hand side where I have Clients, Projects, and Users and so on. I’m going to use this to filter my timesheet, that’s what this menu item is for. So I’m going to open up my list of date ranges and I’m going to say I want to see all of the time for this week. And when I do that it is going to narrow down what I have in my window and right here in the middle you’ll see that increment of time where I put the notes against that time log. When I click on this it pulls up back up again where I can see the original information. And as you can see it’s the exact same thing that was in the timesheet it’s just arranged in a different manner in this window. And you can sort by these headers at the top by actual work, by the project name or whatever you like. And when you’re done you just click this little yellow X, it removes the filter and returns you back to your normal view. And that’s it. You can click back to the Timesheet and I’m ready to track more time.

All right! That was the answer I needed. Thank you.

PTO and Time Off Tracking

 

I see an icon there under the first column under Projects; there’s an airplane icon in Time Off. And I know it applies to the time off tab. But I’d like you to show me how to put in a time off record and get a sense how that feature works.

Yeah, sure. First you click on the plus symbol and it will open up a list of your time off reasons. You get to define how many time off reasons you have and how fast it accrues for each employee. But for me, when I want to put in requests for time off or actually put some time in a day, let’s say Monday, I’m going to take 8 hours of personal time. I’ll just type in 8 hours here. And when I go to tab out of the system it’s going to pull up a little form; it’s basically prepopulated for me. It shows I’m taking personal time, I’m taking 8 hours, it shows the beginning and ending date and all I need to do it hit Save and Close. Now that time has been submitted for my time off request and it will appear in the time off tab up on the right hand side. It’s different because the timesheet, when you put time in against one of these jobs here like Chevron or Dynamics Research. When you put time into your actual work it becomes a time log, shows up in the Time Log tab as a historical record of your work hours.

Yes, its project time or task time, something you did in a task for a project. But either way it shows up in the Time Log as a historical time record. Whereas a time off request for personal time shows up here in the Time Off tab as my request for time off. I’ll go ahead and click on the Time Off tab like I just did and I’m going to click on the Date range and click show me my time off request for this month. And there you see the 8 hours I just put in for time off on Monday.

OK. So then this can track for my accrued hours?

Exactly. So when I put in that little 8 hours for personal time on Monday my manager will get an automatic email notification that says Warren has requested 8 hours of personal time. And once that’s approved, it’s automatically deducted from my available amount of time in my “bank.” All of these times; Comp Time, Jury Duty, Other, Personal and so on every one of them has their own bank of time available. And when I take time away from that, or request time off, it’s automatically deducted from my available time.

That’s what I needed to know, thank you! 

Project Revenue Win-Loss Chart

 

Hey Warren. You had mentioned a chart that I wanted to see project estimates or revenue estimates…

Yes, that’s right under the View menu and then scroll down to Project Revenue. It’ll pull up this little bar chart. You see I have a nice little bell curve and it displays all the estimated revenue for the coming year. And you’ll notice way down here towards the end of the year it’s dropping off a little bit. That’s because our sales team filled up the first ¼ of the year with work because it’s in the near further. And as we work through the 1st quarter they’ll bring on new jobs and more projects and fill up the revenue toward the end of the year. ‘Cause obviously we need to more than $12,000 in December worth of work. So that will happen as the year progresses.

So there won’t be a bell curve at the end of the year; you’ll fill out the rest of the year. I have a question about the Win Status drop down. Could you pop that open and tell me what’s in there?

We’re looking at the Submitted and won status right now, that’s what’s currently being displayed. And if you wanted to you could just say show me all work that has been submitted. In other words sales teams have submitted these jobs and they’re possibly going to land them but not sure yet. And as you go through the process, you want to see everything you’ve won to date, you can look at that. This is all the work that’s guaranteed, signed the contracts and ready to roll. Or you can show the inverse, which is a painful number to look at but important to know how much revenue you’ve lost in the coming year out of expected or possible projects.

OK. Then you have some drop downs at the top with the project and client. I’m guessing that just lets you see one project.

Right. If I want to see just one project I can click on that project and see only that project. Of course the default is to see all the projects. And you can do the same for clients. I won’t jump into all that but you can see a particular client.

How do you get these vertical bars to show up?

Let me show you. You go to the Tools menu. Choose the first item called Projects. Once you select Projects you get the Projects Properties dialog and it shows all the projects in the system on the left hand side. And once I click on a project all the properties now on the right side of this window that pertain to that project. And what you want to make sure you do is select a start date for the project, a finish date for the project. And once you get those two basic date parameters in here then you throw in your estimated revenue; it will spread that revenue evenly over that date range. In addition you also have the option of selecting which stage or what status this project is in. Has it been Submitted, have we Won the project or has it been Lost. If it’s in the submitted stage you can also determine what your win probability is. Do you want to say we’re 75% sure we’ll get this or whatever that number may be.

So that’s the Sales funnel sort of model where you crunch the numbers down and find out what your probable revenue is.

Exactly. It gives you a good estimate what you can expect to land.

Can you pull up that chart again? I just want take one last look. I think I have all my questions answered but want to see it again.

Just go to the View menu, select Project Revenue and there it is!

Project Management

 

Hey, Warren. I have a question about your Standard Time® program. I know you have time management because you have timesheets and expense tracking. I also know you have project management. I’d like to know a little bit about how they tie together.

Sure I can talk about that. What we’re looking at here is a timesheet. And as an administrator you can create projects and tasks for your employees to track time against. And those projects and tasks will appear in the timesheet which I’m looking at right now. We have a number of different projects here 7001SBIR, Chevron, Dynamics Research, and so forth. And down here in Embraer we can type in our hours directly to a task, if we want to. That’s how we track the time inside the timesheet. And this time will relate back to these projects and these tasks so that project managers can look at each project and gage how far they’ve come, what their forecast is, maybe what their baseline is vs their actual. A lot of that can be shown actually in the Project Tasks tab which is just left of the Timesheet tab. So when I move away from the Timesheet and click on the Project Tasks tab, I’m now seeing a dash board view of my projects from a project management prospective. We’re seeing the same projects here that showed on in my timesheet. The difference is I’m seeing the estimated Duration, Actual work and the % complete. And then over here to the far right we have the % status bar. When I open up one of these projects by clicking on the + symbol, I get to see the tasks within that project that are showing up in my timesheet to track time against.

OK. So the actual work column then is the hours that people have typed into the timesheet.

Yes. This column here the actual work is exactly the hours typed from the timesheet. And again this is cumulative total. So their might be 100 people working on this task and as they type their time into the timesheet it all shows up here in one big number.

OK. I see these bars over on the right-hand side, blue and red. What are the red ones?

This is a status bar. It tells you when it’s red that this task has gone over the allotted estimated time. So if I just click on Media Planning. We can see estimated Duration was 30 hours and the Actual was 104. So therefore it’s way over the estimated budget. So when you look at the actual bar and it being red its telling you you’ve gone over the allotted time.

Thank you. No more questions. Just wanted to see how the two tied together.

Pay Periods in Timesheet

 

Question about your timesheet. I see your timesheet is in a weekly view. In other words I see Monday, Tuesday, Wednesday and so on. That’s nice but we like to enter time for a full pay period. Usually pay periods are from the 1st of the month to the 15th then from the 16th to the end of the month. Can you configure the timesheet to do that?

Yeah sure, Ray. You just go right here to the Tools menu scroll down to where we have Approve Time and Expenses. And once you’re in this view you’ll notice there’s a box for Pay Periods, click on it and this is where you create the pay periods. You can create as many as you like. I’m going to create one here from the 1st to the 15th as you said; and I’ll choose Create Pay Period. Now we have one pay period created. Now I’ll go ahead and choose the next one which is the 16th through the end of the month.

I can create these out into the future, really for the whole year then.

Right, a lot of people do that. You can create them 6 months at a time, a year, two years-whatever you like.

I created a few here as an example so I’m going to close this box. And I’m going to get out of this view as well. And then you’re going to notice right here at the top you’re going to see we have a pay period/date range for this timesheet. And you’ll also notice it shows up at the bottom of the timesheet as well. So you get two indicators of the date range for the pay period you’re in.

OK. I also see a bracket there. I guessing that tells me expected number of hours for that pay period.

Exactly. That’s the number of scheduled hours.

I guess the way things work depending on the way weekends end up some pay periods are longer than others and require more hours. Some are 88 hours, some are more or less.

This just gives you a good indication what you should have in your timesheet so when you get ready to submit it you know whether you’re in the ball park or not.

Now the next thing you can do is select this little drop down arrow; right in this little arrow are a bunch of hidden features for the timesheet. For instance you can display hours at the top verses the bottom. In addition to that there is a selection for Time Periods. Right now we’re displaying it one week at a time, well what I want to do is display the full pay periods. So I’m going to hit this little button Pay Period and when I do you’ll notice we have a scroll bar at the bottom of the screen and it allows me to scroll left and right through the full pay period I’m inside of.

So I can enter all the hours for that pay period.

More importantly I think it’s not just entering the hours it gives you a chance to review all of those hours before submitting them. That way you can look at the full pay period before you submit for approval.

Now I’ll just scroll back down here and go back to the weekly mode; most people like to see their time in a weekly mode even if they have different pay periods.

We like to see how many hours we’ve worked in a certain week even if though we enter hours for the pay period we at least like to see the weekly view to see how many hours we did last week.

That’s what I’m trying to get at here. You can toggle back and forth between those views. So the week you’re putting in your time you’re good, and then if you want to review it before you submit it you can also get into that mode to take a look at.

Creating a New Project

 

I know you can create a project by going to Tools, Project but I wondered if you had any other recommended ways of doing it that might be quicker.

One way you could do it is go up here to the help menu, scroll down to Startup Project Wizard and when you do a little box will pop up that will ask if you want to create a project. You say yes by clicking next, and here you can enter the name of your new project. I’m just going to name this something very simple “A New Project.” Then you hit next, enter your tasks in this window. I’ll enter Task a, Task b, Task c. Then hit next once again. Now it’s asking me if I want to bill these hours to a client. If it is billable I check this box; I have two selections to make after I decide its billable 1. I can choose from a list of existing clients from a drop down list. Or if their a brand new client and I’ve never done work for them before I’d chose this middle radial dial and I would type their name right here into this window. So in this case I’m going to say they’re not billable to a client, I’ll just let it go, maybe it’s an internal project. And hit next, and finish. And now I have my new project right here with my tasks a, b, and c.

How would I add a 4th task; let’s say task d?

That’s pretty easy. Go up here to the insert menu, select New Project Task. You’re going to get a little pop-up window; every field in this window now is pertaining to this new task I’m going to create. But really the field you want to populate is the name field. I’m going to call this task d. And in addition to that you’ll want to make sure you assign that task to the project you want it to appear with. And I’m going to say A New Project-there’s our project here. You can also assign it to a client or subsystem or any number of events. But in this case I’ll just sign it to the project and be done with it. And one other item you’ll gonna wanna make sure is checked is found under the extra section here. And that’s this little Quick Task (which was renamed to ‘Timesheet’ in 2015) checkbox. That just forces a task to appear in your timesheet. This is for if you have a task way out in the future and you don’t want it to appear right now in the timesheet. You can have it appear later. In this case I do want it to show up so I’ll make sure that box is selected. Hit save and close. And now I have Task d.

What if I have a project that exists that already have all of these tasks; can I make a copy of that?

Absolutely! Go to the Tools menu, select Projects. Once you do that you get a list of all your projects on the left hand side here. I can select any project; here’s the one I just created “A New Project.” And all I have to do is right click on that and select Duplicate. When that’s selected it will duplicate that thing and what you’ll want to do is rename it here and assign it to a client if it needs to be assigned and you’re done.

 

Graphical Timesheet

 

Hey, Warren. I saw a static photo on Facebook of your graphical timesheet. I went ahead and gave it a try and thought you could take me through it and enhance my understanding of it.

Yeah. That view you’re talking of is found right up here in the top left hand corner of the timesheet is a drop down arrow. Click on that arrow, scroll down to Daily Hours and when you do it shows you the graphical timesheet. You’re seeing these little blocks of time, for instance this indirect 7001SBIR project. It shows 2 hours. It’s the same information in the regular timesheet it’s just displayed a little differently. So when I scroll back to the timesheet again you’re going to see there’s the 2 hours for that 7001SBIR project. And again if you want to click on the time log you will see the same information displayed in a different format. Basically all that information is put into the timesheet simply shows up formatted in different ways on each of those areas.

OK. So the graphical timesheet is just the same as the timesheet it’s not any special data or anything like that. It’s the same information but displayed differently.

Exactly. And in fact you can do the same thing in this graphical view as you can in the regular timesheet. If you want to click on one of these items to change it or add notes to it, you could. So there are just different ways of viewing the information. You’ll notice here for example these are overlapping so we had two tasks going at the same time on Monday. And they overlap one another. Whereas on Tuesday they’re in sequential order. And that’s pretty important to take note of if you’re trying to be DCAA compliant. You’re gonna wanna make sure your time is in sequential order because that’s one of the things the auditors look for.

On Tuesday it looks like you’ve got one document control that starts at 8am, materials starts at 2pm, then in-direct starts at 5pm. So where as Monday you have those overlapping those are both starting at 8am.

Right, that’s exactly correct.

I understand. So in this view you’re actually doing two things at once.

Right, and Standard Time allows for that. To be DCAA compliant it’s a training issue, you’re going to want to make sure your employees know that when they put their time in the system they’re going to want to make sure it’s sequential. It’s not hard to do but you’re going to want to inform your employees and train them do.

So show me how to do that on Monday.

Good idea! So when I clock my time into the timesheet for Monday these hours are real, I’ve worked them. But I’m just going to grab one of these, click and drag it down to 10am to where it falls right below the first item. And then take this document control item that is overlapping the item to the right and I’m going to scroll and drag it down just below the task above it. And when I do that it puts them in sequential order. So it’s real easy to do, it’s not difficult at all and this way you can keep a sequential track of your time.

So when you use the timer I’m guessing then you don’t have this problem because the timer just starts and stops and you get these blocks in sequential order. Right?

Right, if you’re using a timer in Standard Time it will automatically block these things in sequential order for you.

OK. Double click on one of these I just want to take a look...

I’ll click on this in-direct. Double click it pulls up a time log.

Yup, just like before I can enter my notes and detail there.

Yes exactly. And you can save and close any notes you put here and cancel out, you don’t need to make any changes. We’re just viewing it so I’ll cancel.

That gets me started so I’ll mess around with it. I really like it!

Filtering the Timesheet

 

The Standard Time timesheet can be filtered to display different information. Filter the timesheet by project, client or date range to name a few. The timehseet is flexible and allows you to customize what a person can or can not see. Administrators can view other employee's timesheets.

 

 

Changing User Rights

 

User rights define what you get to see inside the Standard Time timesheet. Every user can be different. Standard Time allows you to display many features, or simply allow you to only see the timesheet.

 

Approving Timesheets

Standard Time allows you to review and approve single timesheets, or multiple timesheets in a single view. The timesheet may also be locked after the approvals and timesheets can have as many layers of approvals as you like.

 

FREE TRIAL


Download a fully functional timesheet that will remain active for 30 days.
Company Name
Please enter your company name
Full Name
Please type your full name.
E-mail
Invalid email address.
Number of Employees
How many employees will use this?
Enter the text below
Enter the text below
Please enter the text above