Dashboards

This bar chart represents the cash being generated in the company on a monthly basis for the last 12 months. It shows all cash payments received including retainer payments, but broken into defined periods within the specified date range. Cash flow looks at all deposits made, not just the payments on invoices and excludes write-offs, debit and credit type payments. You can apply date and other filters to it.

This widget is especially useful to the principals, partners and accountants in the company.

This bar chart represents total billed amount (excluding discounts and draft invoices) on a monthly basis for the last 12 months. It shows all the billing done by the company without considering the retainer amount used, broken into defined periods within the specified date range. You can apply date and other filters to it.

This widget is especially useful to the principals, partners and accountants in the company. It is a good practice to compare billings with A/R balances.

This bar chart represents month-to-month A/R balances of the company for the last 12 months. It shows the unpaid invoices broken into defined periods based on invoice date or due date within the specified date range. You can apply date and other filters to it.

This widget is especially useful to the principals, partners, accountants and billing users in the company. These balances should be compared and evaluated against your monthly billings. A good rule of thumb is 8-18% of billings, but anything more should prompt increased collection efforts and evaluation of your investment in individual clients.

This donut graph represents the monthly income of the company (last 30 days). It shows the company's income broken down into various accounts within the specified date range. You can apply date and other filters to it.

This widget is especially useful to the principals, partners and accountants in the company.

A list of clients and the money owed by them as of today. It shows a summary of all the open invoice balances of each client as of a certain date along with the aging of the oldest invoice. You can apply other filters to it.

This widget is especially useful to the principals, partners, accountants, billing users and project managers in the company. It can help you in tracking A/R, prioritizing collection calls and determining whether to extend further credit to clients.

This list widget shows the clients that have some retainer balances as of a certain date (say today). It displays the summarized information about the retainer received, used and remaining for each client. The Used column also shows refunded retainers. You can apply date and other filters to it.

In the standard view, this widget excludes clients that have zero retainer balances even if they paid retainers in the past. However, you can apply filters to include clients with zero retainer balances.

This widget is especially useful to the principals, partners, accountants, billing users, and project managers in the company.

The donut graph shows the overdue invoices or outstanding amount per aging period (last 30, 60, 90 and 120 days) as of today. It shows a summary of the open invoice balances broken into four aging periods based on invoice due date. You can apply date and other filters to it.

This widget is especially useful to the principals, partners, accountants, billing users, and project managers in the company. This important information can assist you in prioritizing collection calls and determining whether to extend further credit to clients.

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.

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 work-in-progress should prompt an analysis to understand the risk of unbilled work and reasons why it has not been billed.

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.

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.

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.

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.

This bar chart shows the top employees in your company, rated by their invoiced 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.

Invoiced Services = 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.

This bar chart shows the top activities rated by their invoiced 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.

This bar chart shows the top expenses in your company rated by the invoiced 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. 

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.

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.

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%.

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.

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.

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 (billed amount), cost (total cost of billed services and expenses) and gross margin (Revenue - Cost). You can apply date and other filters to it.

Gross Margin % = (Margin / Revenue) x 100

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.

This line graph shows the earned value 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 Cost and Billable value is big and that the Billed value is the highest. You can apply date and other filters to it.

• Cost is the cumulative cost of work done to-date; in other words, the cost of billed time and expenses. It is the sum of the cost amount of services (Hours x Cost Rate) and cost amount of expenses (Units x Cost Rate).
• Billable is the cumulative billable value of billed time and expenses and represents the earned value. It is the sum of Total Billable Services (Client Hours x Bill Rate) + Total Billable Expenses (Units x Cost Rate).
• Billed is the cumulative value of billed time and expenses, and represents the actual earned value. It excludes retainers, taxes, discounts and draft invoices, but includes WUD and extra services and expenses. It is the sum of Total Services Billed (Client Hours x Bill Rate) + Total Expenses Billed (Units x Cost Rate).

This widget is especially useful to the principals, partners and project managers in the company.

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), work-in-progress (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 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.

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.

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.

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 (billed amount), cost (total cost of billed services and expenses) and gross margin (Revenue - Cost). You can apply date and other filters to it.

Gross Margin % = (Margin / Revenue) x 100

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.

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.

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.

This dual bar chart shows the company's income, expenses and profit within the specified date range (year to date). It provides a quick snapshot of your income and expenses in terms of billing, cash flow, aging and income on a monthly basis. It helps you make sure you are not spending more money than you are putting in the bank, thus spotting potential issues before they get out of control. You can also compare the current and previous year's monthly profits to put things into perspective. This KPI allows you to glance quickly at the key balances to ensure none of them is getting out of hand. You can apply date and other filters to it.

This widget is especially useful to the principals, partners and accountants in the company. It reflects the data based on the Accrual or Cash accounting as set in Settings. However, it also allows you to toggle views between the accrual and cash basis of accounting.

This donut graph shows the company's overall expenses broken down into various accounts within the specified date range (last 30 days). It allows you to understand your expenses better in terms of costing, budgeting and spending on a monthly basis. You can apply date and other filters to it.

This widget is especially useful to the principals, partners and accountants in the company. It reflects the data based on the accrual or cash accounting as set in Settings. However, it also allows you to toggle views between the accrual and cash basis of accounting.

This bar chart displays projects with their start and due date schedules in a mini Gantt Chart view. This widget focuses on the project's start and due dates and displays them in a timeline, with today as a dotted vertical line for your reference. You can view the schedule on a monthly or yearly (default) basis, and also apply date and other filters to it. Multi-phase projects are expandable and project names are clickable to direct you to the project's details. 

Each bar is colored according to the status of the project, which is based on its end date or due date: Completed, In progress, or Delayed. If the project's end date passed and its status is not complete, CORE displays the bar in red. If the project's end date passed and its status is complete, CORE displays the bar in green. It uses blue for the rest of the scenarios. If a project does not have a due date, CORE uses the due date of its phases, if any. If the phases also do not have any due dates, then CORE displays the bar with a broken line on the right side. Similarly, if a project does not have a start date but has a due date, CORE displays it with a broken line on the left side. If a project has neither a start date nor an end date, then it does not show up on the widget. Projects are sorted in the list based on the start date.

This bar chart displays projects in a mini Gantt Chart view based on their task allocations. This widget focuses on the allocations at the project level instead of the project's start and due dates. You can view the schedule on a monthly or yearly basis, and also apply date and other filters to it. Multi-phase projects are expandable and project names are clickable to direct you to the project's details.