Overview
Projects (also called as engagements, jobs, or matters) are the backbone of any business. There are metrics that a project manager or owner should check regularly to ensure that everything is on track. If you have to calculate everything on your own, staying on top of it can be hard. Even some of the most sophisticated project management software do not make it easy to track progress on your projects.
The Projects screen in BQE CORE is organized to display the most important and useful information front and center on its Project Center > Overview tab. It is a one-stop shop for all your insights on a project. It gives a cumulative and comprehensive overview of your active projects as well as their overall finances in terms of what’s ready to bill, your work-in-hand, and what’s overdue. The widgets on the Overview tab offer a one-click drill-down to the source data and related reports. There are additional security permissions to give access to relevant employees to various areas of the screen. This way more employees can be granted access to the project data because the CORE admin/owner has better control of what each user can see. It also offers better visibility across teams and their workload. Click to watch this video on Project Center in CORE.
How To
Field Descriptions
| Field Name | Field Description |
| Projects > Project Center > Overview | |
| Unbilled Time |
Displays a color-coded pie chart that represents time entries of selected project and its phases (cumulative) based on their status. It also shows the total value of unbilled billable and non-billable hours. You can toggle between viewing All Entries (default) and Billable Entries Only. When set to Billable Entries Only, the chart, totals, and linked screens such as Time & Expense Reviewer, Time Entries, and relevant reports reflect only billable data. Make sure the security permission, Show Billing and Contract Amounts is checked in Access & Permissions > Security Permissions.
Time entries with a billed status are not included in the chart. The center of the chart displays the sum of hours (Total) that are not billed while the legend provides the details such as the number of time entries and the number of hours as per the status. You can also check the relevant reports filtered for the selected project from the ... menu. If you have access to the Time & Expense Reviewer screen, a clickable link to this screen appears. If you don't have access to it, a link to the Time Entries screen appears. CORE automatically applies filters to these screens (Time & Expense Reviewer or Time Entries) to filter out the entries to match the chart. |
| Unbilled Expenses |
You can toggle between viewing All Entries (default) and Billable Entries Only. When set to Billable Entries Only, the chart, totals, and linked screens such as Time & Expense Reviewer, Time Entries, and relevant reports reflect only billable data. Additionally, the chart includes expense entries with a zero value cost rate and a specified charge amount. Displays a color-coded pie chart that represents expense entries of selected projects and their phases (cumulative) based on their status.
Expense entries with a billed status are not included in the chart. The center of the chart displays the sum of the expense amount (Total) and the legend displays the total amount as per the status. You can also check the relevant reports filtered for the selected project from the … menu. If you have access to the Time & Expense Reviewer screen, a clickable link to this screen appears. If you do not have access to it, a link to the Expense Entries screen appears. CORE automatically applies filters to these screens (Time & Expense Reviewer or Time Entries) to filter out the entries to match the chart. |
| Invoices |
Displays up to 30 invoices associated with the selected project or its phases, offering a comprehensive view of invoice-related information. Each invoice is represented by a tile and is color-coded to indicate its status such as draft, billed, overdue, and paid. Clicking on any invoice bar redirects you to the Invoice Summary screen. Hovering over the invoice bar provides key details such as the invoice date, billed amount, status, due date, paid date, etc. In addition, it also includes a discount bar that shows cumulative discounts for the project and its phases in the company currency, along with a hyperlink to view filtered invoices. You can access the Invoices screen and related reports from this widget using the ... menu. |
| Timeline |
Displays a Gantt-style chart with a 12–14-month period beginning two months before the current month and extending 10-12 months into the future. The phases (up to 25) are represented as bars on a timeline. If each bar is positioned based on its start and due date, highlighting phase status, name, start date, and due date. A color-coded thick line at the top of each bar reflects the budget usage for that phase with red indicating over-budget and light blue representing under-budget phases. If no budget is assigned, no line appears. Note that the Timeline is hidden if there are no child phases. However, you can add phases from the Phases widget. Hovering over the bars displays additional details such as name, status, contract type, % complete, contract spent, contract amount, budget amount, start date, and due date. A dark blue line marks the current date across all bars. You can expand the timeline to view more phases. You can access relevant reports from the … menu. Additionally, a shortcut to the Budgets screen is also available at the bottom-right corner of the chart. Do note that if phases and sub-phases are of type Main, then the Contract Spent/Total and Budget amounts for these phases are excluded from the cumulative values on the timeline. If phases and subphases are of type Standard, then the Contract Spent/Contract Total and Budget amounts for these phases will reflect cumulative values on the timeline. |
| Analysis |
There are four sections available to analyze the progress, profitability, billability, and retainers of the selected project and its phases. Each section contains key metrics, also referred to as KPIs, followed by one or more charts. By default, you will see the Analysis section open on the screen; however, CORE remembers your selection and opens the selected section next time you visit this screen. The … menu hosts relevant reports based on the selected section. |
|
Contract: Billed + Unbilled |
Displays the sum of:
|
| Remaining |
Amount of the contract not yet used. This factors in both billed and unbilled services and expenses, excluding extra time and expenses. The Contract Remaining calculations subtract billed (and unbilled) portions of contract from the portions of services and expenses. These amounts include WUD but do not include taxes or discounts applied to the invoices. It is calculated as: Contract Amount - Billed Contract - Unbilled Contract |
| Billed |
Amount of contract services and expenses that are flagged as billable and have been billed, including WUD and markup. It is calculated as: Billed Expenses Contract + Billed Services Contract |
| Unbilled |
Amount of contract services and expenses that are flagged as billable and have been entered but not yet billed, including WUD and markup. It is calculated as: Unbilled Expenses Contract + Unbilled Services Contract |
| Billable/Billed/All Cost | Displays three important metrics that help you analyze the financial health of your project. The Billed value is represented by a green line, the Billable value with a blue line, and the All Cost is represented with an orange line. If the Show Cost Amounts security permission is unchecked, the cost-related KPI, will not be displayed on the Contract widget. |
| Contract |
The graph in this widget draws up a comparison between the contracted amount (limit), the used amount (billed), and the remaining amount (work-in-hand) for the selected project. It gives you a good idea as to whether the project has exceeded the agreed contract amount. The graph shows a breakdown of values in terms of services, expenses and total. The negative amounts are highlighted in red, thus warning you. Remaining Amount = Limit - Used Services = Total service amount used from the contract amount on the project. It is equal to the value of billed services including WUD, but excluding taxes, extra services, and fixed fee billed Expenses = Total expense amount used from the contract amount on the project. It is equal to the value of billed expenses including markups and taxes, but excluding extra expenses billed. Used = (Units x Cost Rate) x (1+ Taxes / 100) Note that only immediate child phases of the selected project are shown. All values, except those marked with an asterisk (*), are cumulative of all child phases. |
| Budget |
It provides a quick snapshot of a project's finances. You can see if the project is over budget or approaching budget. This widget compares the contract amount with the spent amount. The chart displays a comparison of the budget total, spent amount, and remaining budget. This comparison is further classified by service and expense budget comparison. A percentage is also displayed to represent the used %. Balance = Limit - Used where Services–Limit = Total service amount in the budget Expenses–Limit = Total expense amount in the budget Services = Total service amount used from the budget on the project. It is equal to the value of billed services including WUD and taxes, but excluding extra services and fixed fee billed. Expenses = Total expense amount used from the budget on the project. It is equal to the value of billed expenses including markups and taxes, but excluding extra expenses billed. |
|
Profitability:
Net Margin - Billed |
You can toggle between three profitability views: Billed, Billed All Cost and Billed + Unbilled. Each mode offers different insights into project profitability based on different criteria. You can switch between the views from the ... menu. Displays the net margin earned from billed services and expenses, after subtracting the associated costs (both billed and unbilled non-billable costs). Net Billed includes billed amounts after deducting discounts and miscellaneous adjustments, excluding taxes. The net margin is calculated as: Net Margin = Net Billed - Billed Cost - Unbilled Non-Billable Cost The percentage is calculated as: Net Margin Percentage = (Net Billed - Billed Cost - Unbilled Non-Billable Cost) / Net Billed × 100. |
| Net Billed |
Amount of services and expenses that are flagged as billable and have been billed, after deducting discounts and miscellaneous adjustments. This amount excludes taxes and retainer applied. It is calculated as: Gross Billed - (Discount + Miscellaneous Adjustment) |
| Billed + Non-Billable Cost |
The total cost of all services and expenses that have been billed, and includes the cost of unbilled non-billable services and expenses. It is calculated as: Billed + Non-Billable Cost = Billed Cost + Non-Billable Cost |
| Billed WUD |
Total write-up or write-down amount on billable time entries. Expense markup is not included here. A negative WUD (write-down) is displayed in parenthesis and indicates that your employees are spending way too much time on a project than what you can bill. Billed WUD = Billed Amount - Billable Amount |
| Contract/Extra | Displays the sum of time and expenses (extra and regular) along with the net billed, billed cost, margin and margin %. |
|
Profitability: Net Margin - Billed All Cost |
Profit margin of a project/phase. It excludes discounts and miscellaneous adjustments on invoices. This margin represents the profitability of the amount that has been billed versus all the services and expenses entered. It is calculated as: [Profit (Billed All Cost) / Gross Billed] x 100 |
| Net Billed |
Amount of services and expenses that are flagged as billable and have been billed, after deducting discounts and miscellaneous adjustments. This amount excludes taxes and retainer applied. It is calculated as: Gross Billed - (Discount + Miscellaneous Adjustment) |
| All Cost |
Total cost of all services and expenses. It excludes WUD, taxes, and markups. Cost Amount = Total Services Cost + Total Expenses Cost For time entries, Cost = (Hours x Cost Rate) For expense entries, Cost = (Units x Cost Rate) All Costs = (Hours x Cost Rate) + (Units x Cost Rate) |
| Billed WUD |
Total write-up or write-down amount on billed time entries. Expense markup is not included here. A negative WUD (write-down) is displayed in parenthesis and indicates that your employees are spending way too much time on a project than what you can bill. WUD = Billed Amount - Billable Amount |
| Contract/Extra | Displays the sum of time and expenses (extra and regular) along with the net billed, cost of billed, margin and margin%. |
|
Profitability: Net Margin - Billed + Unbilled |
The net margin earned from both billed and unbilled services and expenses, after deducting all associated costs. It is calculated as:
|
| Net Billed + Unbilled |
The net margin earned from both billed and unbilled services and expenses, after subtracting all associated costs. It is calculated as: Net Billed + Unbilled - Total Cost The percentage is calculated as: (Net Billed + Unbilled - All Cost) / (Net Billed + Unbilled) × 100 Net Billed includes invoiced amounts, after deducting discounts and miscellaneous adjustments, excluding taxes. |
| All Cost |
Total cost of all services and expenses. It excludes WUD, taxes, and markups. Cost Amount = Total Services Cost + Total Expenses Cost For time entries, Cost = (Hours x Cost Rate) For expense entries, Cost = (Units x Cost Rate) All Costs = (Hours x Cost Rate) + (Units x Cost Rate) |
| Billed + Unbilled WUD | Total write-up or write-down on billed and unbilled time entries. |
|
Billability: Unbilled |
Displays the value of all services and expenses (including extra) that are flagged as billable but not yet billed, including WUD, markup and excluding taxes. |
| Net Billed |
Amount of services and expenses that are flagged as billable and have been billed, after deducting discounts and miscellaneous adjustments. This amount excludes taxes and retainer applied. It is calculated as: Gross Billed - (Discount + Misc. Adjustment) |
| Non-Billable | Represents the total value of time and expenses categorized as non-billable. |
| Utilized |
This is the billability of the time spent on a project, irrespective of the billed status. Its calculations include extra time and regular time with WUD. Ideally, utilization percentage should be as close as possible to 100%. The calculations involved are: Billable % = Billable Hours / Total Hours x 100 where Billable Hours are billable client hours and Total Hours = Billable Hours + Non-Billable Hours + Overhead Hours + PTO Hours |
| Billable |
Actual hours entered that are flagged as Billable. These are hours logged by employees that can be billed to the client. The status of time entries is billable and contract type of the projects is not Overhead or Marketing. It excludes WUD and non-billable hours. This billable time is not necessarily indicative of the service revenue. It is calculated as: Billable = Client Hours x Bill Rate |
| Non-Billable |
Amount of non-billable time and expense entries that are billed. It is calculated as: (Client Hours x Bill Rate) + (Units x Cost Rate) |
| Client Hours | Hours logged by employees that are billable to the client. These are used by the billing system in CORE to calculate the value of services toward a project being charged to the client. By default, client hours are the same as actual hours worked, but can be changed, if needed. |
| Line Chart/Legend | This widget displays a line chart indicating Billable ( Billed + Unbilled) and Non-Billable amounts and a legend depicting the color indicators along with the values. |
|
Retainers: Total Retainer Available |
Displays all the information about the retainers associated with the project and related client in a bar graph. You can see the retainers received, used, and remaining. Total Retainer Available = Total Client Retainer received + Total Project Retainer received - Total Client Retainer Used - Total Project Retainer Used |
| Project Retainer Available |
Project Retainer Available = Project Retainer Received - Project Retainer Used Project Retainer Available % = Project Retainer Used / Project Retainer Received |
| Client Retainer Available |
Client Retainer Available = Client Retainer Received - Client Retainer Used Client Retainer Available % = Client Retainer Used / Client Retainer Received |
|
General Information: Contract Type |
This widget contains an edit
|
| Phases |
Displays up to ten phases, both active and child phases, of the selected project. This widget displays the Spent % of the phase along with a small pie chart reflecting the percentage. By hovering over the phase name, you can easily open the Overview screen for the corresponding phase with a simple click. Note: Click All Phases if you want to check all phases related to the selected project. |
| Team | This widget displays the list of team members assigned to the project. You will see Project Manager first in the list, followed by Principal and Originator. The profile picture along with the name is also displayed. You can assign a new team member by clicking the + icon, it opens the Add Team Member dialog. Additionally, there is a link to the Resource Allocation screen. |
|
Client
|
Displays the name of the project's client along with the address. It also displays the primary contact details such as email address and phone number. |
| Assets | This list widget displays the project's to-dos, notes, documents, RFIs, submittals, and drawings along with the number of records associated with them. Each of these assets is clickable and opens the list view of the respective screens. |
| Links | Allows you to access key project-related screens in CORE, including Resource Allocation, Invoices, Payments, Vendor Bills, etc. Each of these screens is pre-filtered to correspond with the selected project. By having all relevant information pre-filtered, you can quickly manage and review project-specific data without the need to manually set filters each time. |
| Update Now | Allows you to refresh project data, load the most up-to-date values, and ensure you are viewing real-time information. It also displays a timestamp showing the last time the project data was updated. If the Refresh button is clicked more than twice within 10 minutes, CORE displays a prompt indicating the metrics could not be updated and directs you to contact customer support. |
Overview Widgets
In the Projects screen list view, when you click on a project record on the grid, CORE takes you to the detail view, known as Project Center. The first Overview tab shows you everything you need to know about the overall status of your project. It displays various widgets with essential project-related metrics.
-
Unbilled Time and Unbilled Expenses
This covers the work-in-progress (WIP) for your projects. It not only tells project managers how far along work is, but it gives a clear indication of upcoming cashflow.
-
This widget displays up to 30 most recent invoices associated with the selected project, offering a comprehensive view of billing information.
-
A Gantt chart-style Timeline displays a 12–14-month period beginning two months before the current month and extending 10-12 months into the future. You can hover on each phase and see some details or dig deeper into a report. Only immediate phases of the selected project are shown, excluding sub-phases or deeper levels.
-
This widget serves as a critical tool for assessing project performance, displaying key indicators related to the project's progress and valuable insights into the financial health of the project. This data is available on separate tabs.
-
Progress: This tab provides additional insight into how things are faring against the contract amount. Besides displaying information about billed amount, work-in-hand and cost amount, you get a comparison of the contracted amount, spent amount, and remaining balances. This comparison is further refined by service and expense contract amounts. This way, you will understand ahead of time whether or not your project will exceed your contract amount.
Similarly, the budget analysis shows a breakdown of your services and expenses in terms of what has been used and what is the budgeted amount. You will get a quick picture of whether your project is over budget or approaching budget.
-
Profitability: This widget helps in assessing the profitability of a project. It gives you a breakdown of your services and expenses in terms of billable, billed, unbilled, and non-billable amounts. This is a great tool to assess how costs are faring against the billable time and expenses. You can also check write-up/write-down on your billable time entries. This is helpful because you might want to bill the client more or less than the actual billable amount to manage your project budget.
-
Billability: This tab displays the billability of the time spent on a project, irrespective of the project status. You can easily see how much of the total time turns out to be billable. You can see it both in terms of hours as well as amounts. This metric is crucial if you are billing hourly or hourly-not-to-exceed projects. It is useful even if you are working on a fixed-fee project. You will gain a clear picture of your project’s efficiency in terms of billable versus non-billable hours.
-
Retainers: This tab shows you all the information about retainers associated with a project and client. You can instantly view what you have received versus what has been used and what is left. CORE allows you to see the 10 most recent retainer requests, retainers received and retainers used.
-
Progress: This tab provides additional insight into how things are faring against the contract amount. Besides displaying information about billed amount, work-in-hand and cost amount, you get a comparison of the contracted amount, spent amount, and remaining balances. This comparison is further refined by service and expense contract amounts. This way, you will understand ahead of time whether or not your project will exceed your contract amount.
-
This widget aims to provide a quick overview of basic and general details of a project, such as contract, budget, duration, etc.
-
This widget displays up to 10 child phases of the selected project. It also shows the Spent % of the phases along with a small pie chart reflecting the percentage. You can add new phases by clicking + on the widget.
-
This widget displays the list of team members assigned to the project. You can add team members by clicking + on the widget.
-
It displays the name of the client associated with the project along with the address. It also displays the primary contact details such as email address and phone number.
-
This list widget displays the project's to-dos, notes, documents, RFIs, submittals, and drawings along with the number of records associated with them. Each of these assets is clickable and opens the list view of the respective screens. You can click + to add new items or records.
When you use CORE, these metrics are calculated in real-time per project, as a whole, and phase-by-phase. These indicators—if checked throughout the life of your project—will help ensure that projects are completed on time and within budget.
View Project Overview
The Overview tab is organized in such a way so as to display important and useful project information front and center. It is a one-stop shop for all your insights on a project. This screen gives you a cumulative, brief and clean overview of your current projects as well as their overall finances in terms of what’s ready to bill, your work in hand, and what’s overdue. It comes with a one-click drill-down to the source data, related reports, and enhanced security permissions on confidential information.
To check the project overview, watch this video or follow these steps:
- Open the Projects screen from the side menu > Projects.
- In the list view, click
on a project row and select View Details.
- This takes you to the Project Center and displays the Overview tab, by default.
- At the top of Project Center, it displays the root parent project and phase name. You can also access the project hierarchy drop-down to switch between the phases of that project.
- On the Overview tab, important project metrics that help assess the overall status and progress of the project are displayed in the form of widgets. From these widgets, you can access various screens and reports as well. Check Field Descriptions above for details.
- Unbilled Time
- A Gantt Chart-style Timeline is available to show progress of project and its phases. You can hover on each phase and see some details or dig deeper into a report. Most of the metrics are clickable and open up relevant filtered reports. Check Field Descriptions above for details.
- The Analysis section gives you insight into the overall financial status of the project in terms of its contract, profitability, billability and retainers. Most of the metrics are clickable and open up relevant filtered reports. Check Field Descriptions above for details.
- The next sections display the general information about the project. Click + to add items or create new profiles. Check Field Descriptions above for details.
- Phases
- Team
- Client
- Assets: To-Dos, Notes, Documents, RFIs, Submittals, and Drawings