Home | Products | Support | Subscriptions | About | Contact

HOW IT WORKS
Team TimeSheet for Outlook and SharePoint makes working on project activities very easy by seamlessly integrating the access to projects, deployment, tracking and reporting of timesheets all inside Microsoft Outlook.

 

Team TimeSheet for Outlook & SharePoint is a groupware solution consisting of two portions – managerial and client install.
 

bullet

The managerial install is for project managers and administrators who would setup and configure projects and activities, and maintain drop down lists, templates, reporting settings etc. in a dedicated SharePoint list, which is accessible to all members of the team.
 

bullet

The client install is for individual team member that provides an add-in interface in Outlook to allow preparing their timesheets in appointment or task items, and then publishing to the company’s SharePoint repository.

 


 

Step 1: Administrator configures a SharePoint site

The first step is for the administrator to install the Team TimeSheet Manager add-in and then configure a new SharePoint list to be used as a project data source. The project data source is nothing but a simple SharePoint list (with the name ‘TeamTimeSheetSettings’) that will be created automatically under the selected SharePoint site, to store project related data and other global settings.


The second step is to compile drop down lists for projects, activities and other custom fields, specify reporting workflow, assigns managers to projects, set email notifications, billing and cost calculation choice etc. from the Team TimeSheet managerial menu in Outlook.  With these global settings, administrator can streamline the behavior on how all members work, track and publish their timesheets from Outlook to SharePoint
.

The second step is to compile drop down lists for projects, activities and other custom fields, specify reporting workflow, assigns managers to projects, set email notifications, billing and cost calculation choice etc. from the Team TimeSheet managerial menu in Outlook. 


The third step is to define SharePoint lists where team members can submit their timesheets from their Outlook. As an administrator, you can choose which Outlook fields and other custom fields get published on the SharePoint list. All you need to do is map the Outlook fields with a relevant field of the SharePoint list.

With these global settings, administrator can streamline the behavior on how all members work, track and publish their timesheets from Outlook to this database.


 

Step 2: Team member installs client tool and choose their own projects

Team members who need to submit and report their timesheets to SharePoint must install the Team TimeSheet Client tool. Once installed, the user will be prompted to specify the 'TeamTimeSheetSettings' SharePoint list, that was configured previously by your administrator under the 'My Project Data Source' settings..
 


 

(Note: managers and administrators need to install the client tool if they need to prepare and publish their timesheets to SharePoint)

 

After a connection to the project data source is established successfully, individual member can choose and retrieve their own relevant projects, activities and other global settings.
 



The projects choice and settings data are then saved in the local cache, to enable member to work on projects even in offline mode. Synching the projects and other settings data can done manually in a click of button, or automatically at Outlook startup.

 

 

Step 3: Team member prepares timesheets in Outlook

When user navigate to a calendar or task folder, the timesheet toolbar will show up in the Outlook ribbon UI and timesheet form will be available at the sidebar location. The timesheet form contains the project, activity drop downs from which you can choose a project or activity and tag or assign it to the selected appointment or task item. If your administrator had deployed additional fields, they will appear in the form too.
 

 

 

To tag the same project or activity to multiple selected appointment or task items in Outlook, select multiple items and from the timesheet toolbar ribbon, click 'Group Tagging'.

 

This will prompt you with a new dialog box that contains the timesheet project fields. You can then choose the particular project or activity that you want to tag and assign to the selected multiple appointment or task items.
 

 

 

Step 4: Publishing timesheets from Outlook to SharePoint
After finishing tagging project related data on the Outlook appointment or task item, your timesheet is ready for publishing to database. Click the 'Publish' button either in the toolbar UI, or in the timesheet form to report and publish the selected appointment to SharePoint repository.
 


If the publishing was successful, the timesheet ID that was generated in SharePoint will be assigned to the particular Outlook item for reference.



If you change the Outlook views to list view, you will notice that the Outlook item is being tagged with the ‘Report ID’ of the corresponding published timesheet ID in SharePoint.



Depending on the administrative settings, member can also make revision update or withdraw the published timesheet directly from the corresponding Outlook item.

 

This is how the published timesheet #15 looks like in SharePoint. Notice that Outlook predefined fields, as well as project fields are included in the timesheet. The total cost of the timesheet is also automatically calculated during the reporting process.
 

 

 

Step 5: Managers/supervisors review and audit reported timesheets

After a time sheet is submitted by an employee, a notification email gets send to the concerned project manager or supervisor, eliminating delays in the approval process. With Audit Manager, supervisor can review the submitted timesheet, and edit or adjust it if required (for example, switching the project, activity or the cost), and then approve it to be used for payroll and accounting purposes. The timesheet can also be declined and sent back to the employee for revision. Approval or decline of a timesheet automatically sends an email notification to the particular employee to keep up to date.
 

 

Step 6: Managers generate summary reports

With the summary reports tool, administrators and managers can get an overview on submitted timesheets over a period of time. Generate summarized reports on published timesheets based on different time interval - today, yesterday, this week, this month, last month, this year, last year or own date range. Any fields can be selected for inclusion into the reports which can then be exported to PDF, Word, Excel, Text, XML or HTML web page or printed for sharing and easy distribution.

 

Reports summary reports play a vital role in keeping administrators informed about submitted deliverables, timesheets and aggregate hours and expenses for the selected period. Managers would find it handy to keep track of current budget deficit and work done, and plan and forecast requirements for resources and man power for remaining part of the projects etc.


 

Step 7: Managers use OLAP statistics for advanced analysis and reporting
With the integrated Online Line Analytical Processing (OLAP) tool, managers analyze submitted timesheets and other project deliverables in multidimensional view in grid and charts to extract critical information and intelligence that will enable better decision in business. Additionally, managers can create reports destined for different management levels is a simple task - and thus eliminate the dependence on IT personnel. Reports can be exported to Adobe PDF, Excel, XML, HTML pages, images and more..

 


OLAP Grid analysis of published timesheets from the database with great level of summarization

 

OLAP Chart analysis of published timesheets from the database with great level of summarization


 

Distributed Reporting & Offline Mode
In leveraging the Microsoft Outlook and your network database server for time and expense reporting, Team TimeSheet offers an ideal billing solution for distributed organizations - companies with multiple locations or employees who travel on a regular basis. Through their Outlook client, team members can work on the timesheets and other deliverables of the projects in Outlook in offline mode wherever they are located. And report their timesheets when they are connected to the company's network. Managers can relax knowing their employees are reporting through a regimented system that promotes accurate, consistent project time reporting, while executives can enjoy accurate, up-to-date budget and billing reports.

 

The functionality of Team TimeSheet is quickly available and blends in seamlessly within Microsoft Outlook®, securing and enhancing the organization's existing investments on the infrastructure and technology already in place. The end result is reduced administration costs and needing less or no specialized skills and user training. Your team members are productive within minutes after installing and setting up the application in their Outlook.

 
 
Copyright © 2018 AssistMyTeam. All rights reserved.
ENTERPRISE LICENSING | SERVICES | KNOWLEDGE BASE | BLOG | FREE LICENSE | ABOUT
 
 
 

New! Take a video tour

Quickly learn how to install, configure and work with Team TimeSheet and how to get the most out of your support team!