Reporting on time tracking

Modified on Thu, 4 Jul at 1:46 PM

This tutorial will help you gain more powerful reporting and analytics on where time is being spent on your business and with your clients

Below you see the Task Billing Rate Breakdown Report. It gives you a breakdown of the billable and non-billable time spent in your company.

To access this report navigate to Analytics -> Reporting -> Tasks -> Task Billing Rate Breakdown

Follow these steps:

1. Start by creating a billing item type that will be used to track time spent per task. For this example, we'll call the item type "Project Manager" and the external name "Project Management".

***Note*** With item types you can create multiple variations of one billing name, which will help dive into more detail when reporting. I.e You could have an Project Manager that bills at 100 per hour and an Project Manager Intern that you also bill out at 100 per hour. When sending the client and a CE you wouldn't want them to see "Junior Project Manager" or "Project Manager Intern", you'd prefer them to see just "Project Manager". You can do this by setting the External Name on the item type as Project Manager and the Name as Junior or Intern.

2. Once you've created your item types move over to your company settings and in the groupings setting check the box "Task Billing Rate Required" and hit save.

***Note*** Checking this box means that when anyone creates a task they will be forced to choose a billing rate associated with that task. This will help to ensure all work tracked in Magnetic is linked to a specific billing type. These billing types can be set as billable / non-billable by default when creating the item type above.

3. Next, it's important to identify who in your company are time tracking users. We know everyone hates to track time, so Magnetic reminds you when you log in the next day if you forgot to track time the previous day. Go to the "Manager Users" settings, edit each user that needs to be a time tracking user, set a number of hours they must track per day and check the box "Receive Reminders to Track Time".

4. While you're in the user setting, you can also set a cost to company rate per user. This rate is their actual cost to company per hour and will be used in various recon reports to determine the true profit / loss on work done.

***Note*** Users with this feature activated will receive a notification at the top of their screen when logging in. If they haven't tracked enough time, it will tell them how much time needs to be tracked. I.e if a user is set to 8 hours of capacity per day and they only tracked 5 hours yesterday, then today they will be reminded to track the remaining 3 hours for yesterday's work.

5. For drastic measures when users just refuse or are struggling to remember to track time, you can force them to the timesheet if they didn't track time the previous day. The system will lock them out of doing anything except tracking time. Once the correct amount of time is tracked they will have full access to Magnetic again.

6. Now that you're all setup, your team can go ahead and track time to tasks. When you're ready, you can pull a "Task Billing Rate Breakdown" Report which will give a clear indication of time being spent internally and externally.

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article