| Category |
Widgets |
| Accounts Receivable |
|
| Time and Expense |
-
Hours
This dual bar chart represents the project-related billable and non-billable hours entered on a monthly basis for the last 12 months. It shows a comparison of the billable and non-billable hours based on the time entry date within the specified date range and billable status. You can include or exclude the overhead and marketing contracts from the calculations. You can apply date and other filters to it. By clicking one of the legend boxes (Billable or Non-Billable), you can turn that off and see only one type of hours.
Note: This widget does not include hours recorded against vendors in vendor bills.

This widget is especially useful to the billing users, project managers, and timekeepers in the company.
-
Unbilled Services
This bar chart represents the value of total hours logged, but not yet billed for the last 12 months. It displays the unbilled amount based on the time entry date within the specified date range and excludes WUD and taxes. The y-axis of the chart is based on the charge amount, not hours. You can apply date and other filters to it.

This widget is especially useful to the billing users and project managers in the company. Unbilled time hinders cash flow. Excessive unbilled time should prompt an analysis to understand the risk of unbilled work and reasons why it has not been billed.
-
Staff Workload
This horizontal bar chart shows the total allocation of hours for your staff (employees). It displays the assigned hours and used hours (actual hours worked) rolled up at the employee level where the scheduled end date is within the specified date range. Time entries can be approved or unapproved, but the time entry date has to fall between the allocation start and end dates for them to be included here in the Used value. So the allocations without any start and end dates do not show up in this widget.

This widget is especially useful to the project managers and timekeepers in the company.
Note: The widget computes the assigned and used portion of allocations that are based on individual employee-activity combination as well as their groups. It excludes resources of type 'vendor' because tasks cannot be allocated to them.
-
Employee Allocation
You can see what is expected of you even if you do not have access to the Allocation & Forecasting screen. This list widget shows the allocated and used hours of the logged-in user or employees you are managing by project within the specified date range. Time entries can be approved or unapproved, but the time entry date has to fall between the allocation start and end dates for them to be included in the Used amount. So the allocations without any start and end dates do not show up in this widget.

This widget is especially useful to the project managers and timekeepers in the company.
Note: The widget computes the hours allocated and used that are based on individual employee-activity combination as well as their groups. It excludes resources of type 'vendor' because tasks cannot be allocated to them.
-
Time Performance
The Time Performance widget is an important self-evaluating tool for timekeepers. It ensures that you are meeting the expectations of total logged hours and billable to non-billable hour ratio. The donut graph provides a snapshot of the current week’s expected/standard hours as compared to what was logged as billable, non-billable, overhead and PTO hours. These are represented as hour values and percentage of standard hours. The percentages for Paid Time Off, Overhead Hours, Non-Billable Hours, and Billable Hours can be in comparison to the total actual hours logged, standard working hours, or standard working hours (minus deductions), depending on the Utilization Based On field in Settings > Company > Work Time. For details, check the field description in Company. You can apply date and other filters to remove inactive terminated employees from the widget.

Total Hours = Billable Hours + Non-Billable Hours + Overhead Hours + PTO Hours
PTO = Vacation + Sick + Holiday + Comp Hours
Overhead Hours = Hours logged against marketing and overhead projects
This widget is especially useful to the project manager, and time and expense user in the company.
-
Reimbursables
This list widget shows the paid and unpaid amounts of reimbursable expenses for the logged-in user within the specified date range (last 30 days). It lets you know if there are any reimbursable expenses waiting to be paid. You can apply date and other filters to it.

Typically, the reimbursable expenses (system vendor bills) are clubbed together for a month and paid in full (bill payments). The Paid column shows the full Cost Amount of the expense if you do not exclude any of the expenses from the clubbed bill when making the payment for it. However, if you exclude some expenses, then the Pay Amount of the bill is distributed among the component expenses in the Paid column while the due amount of the bill is distributed among them in the Unpaid column.
Unpaid = Expense Entry Cost Amount - Paid Amount
This widget is especially useful to the project managers and timekeepers in the company.
|
| Performance/Analysis |
-
Employee Performance
This bar chart shows the top employees in your company, rated by their billed services (billed time including those marked as billed) year to date including discounts and WUD, but excluding draft invoices. It shows where all the revenue and profit is coming from so that you can treat those employees with the most attention. The revenue is based on invoice date and the cost is based on time entry date. For YTD period, the metric reflects how much profit changed as compared to the previous YTD range (percent change). You can apply date and other filters to it.

Billed Services = (Billed + Billable + Client Hours) x Bill Rate x WUD
This widget is especially useful to the project managers as it tells them who the best performers in their company are.
-
Activity Performance
This bar chart shows the top activities rated by their billed value year to date. This quick snapshot shows where all the revenue and profit is coming from so that you can treat those services with the most attention. The revenue is based on invoice date and the cost is based on time entry date. For YTD period, the metric reflects how much profit changed as compared to the previous YTD range (percent change). You can apply date and other filters to it.

This widget is especially useful to the accountants and project managers in the company. It is useful for managers to know what are the best services in the company.
-
Expense Performance
This bar chart shows the top expenses in your company rated by the billed value year-to-date. This quick snapshot shows where all the revenue and profit is coming from so that you can treat those expenses with the most attention. The revenue is based on invoice date and the cost is based on expense entry date. For YTD period, the metric reflects how much profit changed as compared to the previous YTD range (percent change). You can apply date and other filters to it. It also allows you to drill down to the details.

This widget is especially useful to the accountants and project managers in the company. It can help you in planning and budgeting project expenses.
-
Client Performance
This bar chart shows your top clients ranked (in descending order) on the basis of payments received (invoiced services) through them in the last 12 months (or year to date), excluding retainer, trust fund, write-off, credit and debit type payments. This quick snapshot shows where all the revenue and profit is coming from so that you can treat those clients with the most attention. The revenue is based on invoice date and the cost is based on time and expense date. You can apply date and other filters to it.

This widget is especially useful to the principals, partners and project managers in the company. It is useful for managers to know who their best clients are.
-
Project Performance
This bar chart shows the top projects of your company based on cash payments received toward their invoices (invoiced services), with the pay date or invoice amount within the specified range. The quick snapshot shows where all the revenue and profit is coming from so that you can treat those projects and clients with the most attention. The revenue is based on invoice date and the cost is based on time and expense date. For YTD period, the metric reflects how much profit changed as compared to the previous YTD range (percent change). It rolls up the amounts for all phases and shows them against the parent project, thus allowing you to see both cumulative values as well as the breakdown. You can apply date and other filters to it.

This widget is especially useful to the principals, partners and project managers in the company. It is useful for managers to know who their best projects are.
-
Staff Utilization
This bar chart shows the billability of time entries by employees within the specified date range (this year to date). It shows the utilization percentage of each employee based on the comparison of billable and non-billable hours. In other words, it shows the effectiveness of employees in terms of revenue generated by them. It can be based on the actual hours logged by employees, standard working hours, or standard working hours (minus deductions), depending on the Utilization Based On field in Settings > Company > Work Time. It also shows the overall company-wide utilization of the staff at the top of the widget. You can apply date and other filters to it.
Utilization % = (Billable Hours / Total Hours) x 100
where Billable Hours are actual billable hours (of projects other than marketing and overhead) and Total Hours are determined based on what is selected in the Utilization Based On field in Settings.

This widget is especially useful to billing users and project managers in the company. The utilization rate gives a measure of the usefulness, efficiency and overall performance of your employees, excluding outside consultants and vendors. Typically, an acceptable range for the utilization rate is about 70-90%.
-
Staff Effective Rates
This bar chart shows the total billable hours logged by an employee and those billed to the client within the specified date range (this year to date). Effective bill rates of employees are based on a percentage of standard bill rates that is actually collected, excluding taxes. It reflects agreed-upon discounts from standard rates, write-up/downs (fee reductions taken before sending the invoices) and write-offs (fee reductions after billing). You can apply date and other filters to it.

Some of the calculations involved are:
Effective Bill Rate = Billed Amount / Total Billed Hours
Bill Rate = Employee Bill Rate
Average = Billable Amount / Total Billed Hours
This widget is especially useful to the billing users and project managers in the company.
-
Paid Time Off and Comp Hours
This bar chart shows a summary of hours available and used by the employees against the four activities: sick, vacation, holiday and comp time within the specified date range (as of today). Available column represents the total allocated PTO while the Used column represents the hours used from that allocation. This widget shows the earned and usage data for approved time only. You can apply date and other filters to it.
Paid Time Off = Sick + Vacation + Holiday Hours

This widget is useful to the principals, partners, project managers, and timekeepers in the company. It is especially useful for HR managers who have to run reports to show you assigned, used and remaining hours. HR Admin users can view PTO information of all employees here and not just the logged-in user.
Note: The PTO information here (Available hours) is retrieved from CORE HR (Benefits Usage), if available. Otherwise, it comes from Employees > Permissible Hours. However, the Used hours are retrieved from time entries using the default time off activities set at the Settings > Time & Expenses level.
-
Gross Margin (Billed) by Client
This list widget shows the profitability or margin analysis of clients within the specified date range on accrual or cash basis of accounting. It shows a list of clients with the associated revenue (net billed), cost (total cost of billed services and expenses), gross profit and gross margin (Revenue - Cost). You can apply date and other filters to it.

This widget is especially useful to the principals, partners and project managers in the company. It lets you know the gross margin for each client; typically, these gross margins should be 66% or more.
-
Project Analysis
This line graph shows the progress of the projects you manage (this year to date). It displays the most important metric project managers are concerned about in order to know if their projects are performing as expected. It helps them understand the difference between the value of work performed and its cost. You want to make sure the gap between the Billed Cost and Billable Pre-WUD value is big and that the Billed value is the highest. You can apply date and other filters to it.

It displays three important metrics that help you analyze a project's performance.
-
Cumulative value of billed + unbilled time and expenses includes:
- Billed contracted service and expense amounts, including fixed fees and WUD (excluding tax, discounts, extras, and miscellaneous adjustments) - Unapproved and approved service and expense amounts, including WUD but excluding extras and tax
- Cumulative value of billed time and expenses includes WUD and markups, but excludes taxes, and extra time and expenses. It represents the actual project analysis.
Billed Amount = (Client Hours x Bill Rate x WUD) + (Units x Cost Rate x MU%)
- Cumulative cost value of billed time and expenses is the sum of the cost amount of services and cost amount of expenses, excluding WUD and taxes.
All Cost = (Hours x Cost Rate) + (Units x Cost Rate)
-
Project Status
This list widget provides an overview of the projects and their phases based on the contract amount or budget amount(whichever view you select). The quick snapshot gives a clear picture of how much is billed (billed amount of time and expenses excluding retainer paid), unbilled (billable, but unapproved, unbilled time and expenses, including taxes, WUD and markups) and open A/R (unpaid invoices) per project.
The spent value depends on your selection: Contract Amount or Budget Amount. In case of Contract Amount, spent represents the value of approved as well as unapproved billable and non-billable services and expenses, excluding WUD, markups, and extra time and expenses. In case of Budget Amount, it represents the value of all time and expenses regardless of their approval status, including markups. It rolls up the amounts for all phases and shows them against the parent project, thus allowing you to see both cumulative values as well as the breakdown. You can apply date and other filters to it.

This widget is especially useful to the principals, partners and project managers in the company. It is best viewed in the wide layout.
Note: The widget displays a red icon when either the Spent or Billed amount exceeds the Contract amount. The icon appears to the left of the specific value that is over budget.
-
Project Allocation
This list widget shows the allocated and spent hours for projects within the specified date range. The time entries can be approved or unapproved, but the time entry date has to fall between the allocation start and end dates for them to be included here in the Spent amount. This widget shows rolled-up totals at the parent project level.

This widget is especially useful to the project managers and timekeepers in the company.
Note: The widget computes the hours allocated and amount spent that are based on individual employee-activity combination as well as their groups.
-
Project Allocation by Activity
This list widget shows the allocated and spent hours for projects by activity within the specified date range. So you can see your task allocations for each project and activity along with the start and end dates. The time entries can be approved or unapproved, but the time entry date has to fall between the allocation start and end dates for them to be included here in the Spent amount.

This widget is especially useful to the project managers and timekeepers in the company. It defaults to show the allocations for the logged user only.
Note: The widget computes the hours allocated and amount spent that are based on individual employee-activity combination as well as their groups.
-
Gross Margin(Billed) by Project
This list widget shows the profitability or margin analysis of projects within the specified date range on accrual basis of accounting. It shows a list of projects with the associated revenue (Net Billed), cost (total cost of billed services and expenses) gross profit and gross margin (Revenue - Cost). You can apply date and other filters to it.

This widget is especially useful to the principals, partners and project managers in the company. It lets you know the gross margin for each project. You can click on the report icon to view the related Project Profitability report.
-
Submittals
This is an interactive list widget that displays information about project submittals. You can monitor the date of submittals along with their status. You can apply filters to it and even change the status of submittals.

This widget is especially useful to the principals, partners and project managers in the company for highlighting any submittals that are pending or might need immediate attention. It is best viewed in the wide layout.
-
Requests for Information
This is an interactive list widget that displays information about project deliverable such as Requests for Information (RFI). You can monitor the due date of RFIs along with their status to make sure the requested information is delivered by you or your team. You can apply filters to it and even change the status of these RFIs.

This widget is especially useful to the principals, partners and project managers in the company for highlighting any RFIs that are pending or might need attention. It is best viewed in the wide layout.
|
|
Accounts Payable
|
|
| Productivity |
|
| Financial |
|
| Human Resources |
-
HR Upcoming Reviews
This list widget provides a summary of upcoming performance reviews. It lists the employees, reviewers and dates when the reviews are due. It is a very useful tool to stay on top of your HR responsibilities.

This widget is especially useful to the HR or team managers in the company.
|
| CRM |
-
Follow-Ups
This list widget allows you to view all the upcoming follow-ups related to the logged-in user. It displays all the assigned tasks that you need to follow up. These follow-ups might be related to leads, prospects, campaigns, opportunities, etc. You can apply date and other filters to it.

-
Campaign ROI
This bar chart widget identifies the campaigns that are doing well and those that are not performing as expected based on the return on investment (ROI). It shows the top 15 campaigns by ROI, excluding the campaigns with zero ROI. You can apply date and other filters to it.

-
Current Opportunities
This bar chart widget shows a list of open or current opportunities managed by the logged-in user. It can be used to see a quick snapshot of how much you have in open opportunities broken down by stages, such as ongoing, new, evaluation, on hold and so on. It displays all the opportunities other than those won or lost. As a sales manager, you can see the current opportunities for your sales team. You can apply date and other filters to it.

-
Sales Funnel
This bar chart widget gives you an idea about the sales pipeline in terms of what percentage of leads advanced through each stage of your sales pipeline or cycle. A pipeline reflects what a company (seller) does during the sales process and a funnel measures the conversion rates through the sales process. For example, CORE starts with the least priority stage and figures out what percentage of opportunities moved to the next priority stage, and so on.

A sales funnel report or widget is important for sales managers because it can help them forecast sales based on current lead volume and identify where deals are getting stuck so that they can improve their processes and better coach their teams. You can apply date and other filters to it.
-
Sales Velocity by Owner
This bar chart widget shows the rate of progression by sales reps (owner). As a sales manager, you need the ability to monitor the sales velocity of your team members so that you can focus your energy on those who might need help closing sales. After you look at the overall picture of the sales cycle and performance of your sales team, you can drill deeper into each sales rep’s performance using the Sales Velocity report. The bar chart shows how much time (in days) each sales rep takes on an average for each stage of an opportunity to move a deal from one stage to the next. Each segment of the stacked chart is an average number of days spent in a specific stage. You can apply date and other filters to it.

-
Top Opportunities
This bar chart widget shows the top opportunity types. You can view a list of top opportunities based on already closed amount, ongoing forecast amount and highest probability. You can apply date and other filters to it.

-
Top Prospects
This bar chart widget shows the prospects with the highest expected revenue for ongoing opportunities or the ones with highest closed amounts. You can see a list of top prospects based on the closed (won) amount or expected revenue. You can apply date and other filters to it.

-
Sales Goal Performance
This dual bar chart widget gives you the ability to compare how well your team closes deals against a sales goal. It shows the revenue (actual) from closed deals compared to the sales goals. You can use this information to track the progress of sales by the logged-in user (you) for multiple periods (for instance, if the period is a month, you can see the comparisons per month for you as a sales rep). You can also track the progress of set sales goals for your team or the entire company for a single period (for instance, the period is a month and you can see each sales rep's goal and actuals for that month). You can apply date and other filters to it.

Note: A maximum of four sales goals are displayed at a time on this widget.
|