Overview
Note: Help content (except videos) has been updated to reflect the UI/UX changes in BQE CORE.
BQE CORE is a project-centric system that supports an unlimited number of projects. Project-centric means that a project is the core element of a relationship between a company and its client. It defines the scope of work done for a client: how it should be processed and how it should be billed. Thus, every client must have at least one project because that is the foundation for all the time tracking, billing, and accounting done in CORE.
A project can link to other projects to form a hierarchy (parent-child relationship). In CORE, projects can be broken down into phases. It supports up to four levels of hierarchy. You can treat each phase as a separate entity and bill it separately. Each part can be treated as one of many parts that make up the whole. In this case, you can bill all the phases together on a joint invoice. Throughout CORE, if you select a parent project, it auto-selects all its phases on lists that show project hierarchy. CORE displays the breadcrumb trail to enhance accessibility and improve the visibility of phases within the project hierarchy.
The Projects screen is used to create projects and manage project-related information. You can see their settings, progress, and transactions as well (with ability to drill-down into the details). Click to watch this video on creating projects in CORE.
Project managers are typically responsible for creating project profiles. It is important for them to understand the contract types and their effect on the billing process. Though you can change it any time, it is best to choose the right contract type while setting up your projects. Besides managing projects, CORE allows you to do project-level accounting as projects are considered profit centers. CORE also gives project managers the ability to monitor the project progress using Project Snapshot by quickly reviewing important KPIs for each in the list view without having to navigate to project details or run reports.
Contract Type |
Situation |
Fixed-Type Fixed Hourly Not to Exceed Percentage Recurring With Cap |
These contract types are used when you want to bill:
|
Hourly-Type Hourly Cost + Percentage Cost + Fixed Fee |
These contract types are used when you want to bill:
|
Recurring-Type Recurring Recurring + Expense Recurring + Hourly |
These contract types are used when you want to bill:
|
Non-Billable Type Marketing Overhead |
These contract types are used when you want to record:
|
Note: You can get a visual overview of this feature in CORE from the Project Management flowchart.
How To
Create Projects from Templates
Add Billing Schedules to Projects
Assign Team Members to Projects
Field Descriptions
Field Name | Field Description |
Projects > List View > | |
Ready to Bill |
This is unbilled, approved time and expenses including taxes, WUD and markups. It is approved WIP and includes extra time and expenses. It includes the values of active projects only. It is calculated as: [(Bill Rate x Client Hours) + (WUD + Tax1/2/3)] + [(Cost Rate x Units) + (Markup + Tax 1/2/3)] |
Work in Progress (WIP) |
The value of billable, but unbilled time and expenses associated with all projects. It includes values in draft invoices, WUD, markups, and extra time and expenses, but excludes taxes. It includes the values of active projects only. WIP = (Unbilled Hours x Bill Rate) x (1 + WUD%) + (Units x Cost Rate) x (1 + Markup%) |
Overdue Invoices | It is the total value of outstanding or unpaid invoices that have exceeded the payment due date. It includes the values of active projects only. |
Projects > List View > Project Snapshot | |
% Complete |
Displays the percentage of project completion based on the usage of the contract amount. It is applicable to only those projects with a contract amount. Projects without any contract amount display 0% here. It is calculated as: % Complete = (Total Spent Amount / Contract Amount) x 100 |
Profitability |
Displays the profit potential (billable margin) of a project for the company. It is not affected by the billable status of time and expense entries. Profitability calculations exclude retainers, draft invoices, discounts and taxes, but include WUD, markups, extra services and extra expenses. The calculations involved are: Profit % = Total Profit / Total Billed Amount x 100 Profit = Billed Amount - Cost of Billed where Billed Amount = Total Services Billed + Total Expenses Billed and Cost of Billed = Total Services Cost + Total Expenses Cost. |
Billable Utilization |
This is the billability of the time spent on a project, irrespective of the project status. Utilization calculations include extra time and regular time irrespective of billed status, 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 |
Contract |
Key metrics related to a project's billing and contract amount usage:
It is possible to go over the contract amount. If the project is over the contract amount, it displays a red icon and highlights those values. Note: Click Contract if you want to check the Contract Analysis report filtered for the selected project. |
Budget |
A quick look at a project's budget usage:
If the project is over the budget amount, it displays a red icon and highlights those values. Note: Click Budget if you want to check the Budget Comparison report filtered for the selected project. |
Earned Value |
Earned value represents the value of time and expenses on projects. In other words, it is the 'used' contract amount. It displays three important metrics that help you analyze a project's performance.
Billed Amount = Total Services Billed + Total Expenses Billed Billed Amount = (Client Hours x Bill Rate x WUD) + (Units x Cost Rate x MU%)
Billable = Total Billable Services + Total Billable Expenses Billable = (Client Hours x Bill Rate) + (Units x Cost Rate)
Cost = (Hours x Cost Rate) + (Units x Cost Rate) |
To-Dos | This list widget displays all the open to-do tasks for the project along with their priority, due date and status. The project manager might want to know about project-related to-dos that are pending. You can view and update them from the To-Dos tab in the detail view as well as the Dashboard widget. |
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 seamlessly monitor amounts alongside hours. 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 |
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. 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 sub-phases 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 tabs available to analyze the progress, profitability, billability, and retainers of the selected project and its phases. Each tab contains key metrics, also referred to as KPIs, followed by one or more charts. By default, you will see the Progress tab open on the screen; however, CORE remembers your selection and opens the selected tab next time you visit this screen. The … menu hosts relevant reports based on the selected tab. |
Progress: Contract Billed |
Represents the actual value of billed time and expenses on projects. Contract Billed % = (Contract Billed / Contract Amount) x 100 |
Work-in-Hand |
Work-in-Hand is the contract earned from a client. If the contract amount is zero, work-in-hand is also zero. It represents the value of the contract yet to be billed. Work-in-Hand = Contract Amount – Total Value of Billed Time - Total Value of Billed Expenses that are part of the contract |
Cost to Date |
Total cost of time and expense entries for a project. Cost = Hours x Cost Rate Cost = Units x Cost Rate |
Billable/Billed/Cost of Billed |
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 cost of billed is represented with an orange line. If the Show Cost Amounts security permission is unchecked, the cost-related KPIs, Cost to Date and Cost of Billed will not be displayed on the Progress 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–Used = 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–Used = 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–Used = 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–Used = 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:
Billable Profit |
You can toggle between two profitability views: Billable and Billed. Each mode offers different insights into project profitability based on different criteria. You can switch between the views from the ... menu. Displays the profit potential (billable margin) of a project for the company. It is not affected by the billable status of time and expense entries. Profitability calculations exclude taxes but include WUD, markups, extra services, and extra expenses. The calculations involved are: Billable Profit = Billable Amount – Costs where Billable Amount = Total Amount of Billable Services + Total Amount of Billable Expenses (excluding taxes and including WUD and markup) and Costs = (Hours x Cost Rate) + (Units x Cost Rate) |
Billable |
Total billable amount of all services and expenses marked billable. It excludes taxes, but includes WUD on services and markup on expenses. |
Cost |
Total cost of time and expense entries. 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) Costs = (Hours x Cost Rate) + (Units x Cost Rate) |
Write Up/Down |
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. WUD = Billed Amount - Billable Amount |
Services/Expenses |
Displays the sum of time and expenses (extra and regular) along with the billable amount, cost, and profit. |
Profitability: Billed Profit |
Displays the actual profit (billed margin) of a project for the company. It is affected by the billed status of time and expense entries. Billed Profitability calculations exclude taxes but include WUD, markups, extra services, and extra expenses. The calculations involved are: Billed Profit = Billed Amount – Cost of Billed where Billed Amount = Total amount billed and Cost of Billed = (Hours x Cost Rate) + (Units x Cost Rate |
Billed |
Total amount billed for the project. It excludes taxes and discounts, but includes WUD on services and markup on expenses. |
Cost of Billed |
Total cost of time and expense entries billed. 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) Costs = (Hours x Cost Rate) + (Units x Cost Rate) |
Write Up/Down |
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 bil WUD = Billed Amount - Billable Amount |
Services/Expenses |
Displays the sum of time and expenses (extra and regular) along with the billed amount, cost of billed, and profit. |
Billability: Utilized |
This is the billability of the time spent on a project, irrespective of the project 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 |
Total value of billable time. It excludes WUD and item taxes. Billable = Client Hours x Bill Rate |
Non-Billable |
Total value of non-billable time. Non-Billable Amount = (Client Hours x Bill Rate) |
Client Hours | Total client hours (billable) associated with a project. |
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 icon, which redirects you to the Settings tab.
|
Phases |
Displays up to ten phases, both active and child phases, of the selected project. This widget displays the approved 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. |
Projects > Project Center > Structure | |
% of Project | Percentage of parent project's contract amount to be used as the contract amount for a phase. It is a calculated field based on the contract amount and can be less than 100% in total. It can be 0% for hourly projects, but not for fixed projects. |
Amount |
In case of Contract, this is the total consideration for the project (billable and non-billable Service Amount + non-billable Expense Amount). Although contract amount is required for fixed-type contracts, it is a good practice to set it for hourly projects as well. Contract amount for a parent project can be allocated to its child projects using the % of Project value. This field is editable here. In case of Budget, this is the proposed budget amount. This field is not editable here. |
Balance | The selected option in the Comparison drop-down controls the calculation of the Balance amount. It can accordingly be the contract amount balance or the budget amount balance. |
% Spent |
Percentage of the contract amount or budget amount spent on a project (depending on your selection). It does not include WUD. % Spent = (Spent / Contract Amount) x 100 |
Spent |
Total amount spent on a project. It is equal to the value of approved billable and non-billable time and expenses. It includes taxes (Tax 1/2/3) and markups for billable time and expenses, but excludes them for non-billable entries. It also excludes WUD, extra time and extra expenses. Expenses have to be a part of the contract. Spent = Billable Time + Billable Expenses + Non-Billable Time + Non-Billable Expenses Spent = [(Client Hours x Bill Rate) x (1 + Taxes/100)] + [(Units x Cost Rate x Markup%) x (1 + Taxes/100)] + (Client Hours x Bill Rate) + (Units x Cost Rate) |
Extra Billed | This is the amount charged to the client on top of the contract amount from the time and expense entries that are marked as 'extra'. It includes taxes (Tax 1/2/3) based on the option selected in Settings > Projects > General > Contract Includes. |
% Complete | Typically, a project manager enters or updates this value indicating the percentage of completion of a project or its phase. When you do percent complete billing, this value carries to the Invoices screen (and vice versa). CORE uses it to compute the bill amount and earned value for the project. This column is available only when you select Comparison: Contract in the drop-down. |
Projects > Project Center > Budget | |
Include Phases | You can check this option if you want to view and manage a cumulative budget for your project and its related phases. This allows you to view the cumulative (total) data of a parent project along with its phases in the grid as well as KPIs. In case of 'Main' parent projects, CORE automatically shows cumulative data. In case of 'Standard' parent projects, you can choose to view the cumulative data or just that of the selected project/phase. |
Projects > Budget > Details > | |
Fee Schedule | You can assign fee schedule rates to a budget by using the detail line items of an existing fee schedule to reproduce the budget details. |
Miscellaneous Amount | It represents an additional amount or any buffer amount on top of the budgeted services and expenses for any unplanned contingencies that might occur. |
Budget and Cost Amounts Total | These are calculated as the sum of Activity + Expense + Miscellaneous amounts. |
Projects > Budget > Services > | |
Resource | Resource could be an employee, an outside consultant or a contract employee. |
Hours | Hours budgeted for the selected activity-resource combination. By default, the Budget Hours are the same as the Cost Hours. It provides managers with a powerful tool to keep their projects within budgeted hours. |
Cost Rate | Cost Rate of a service or activity item. It is the per hour cost of service provided without any taxes. The cost rate is brought forward from Activity Items or can be entered here manually. Typically, this rate is used if you want to base your budget on the cost to the company and not the billable value. |
Cost Amount | Cost amount of the service item. It is calculated as (Hours x Cost Rate). |
Bill Rate | Per hour bill rate assigned to a service item. The bill rate is brought forward from Activity Items or can be entered here manually. |
Spent Hours / Spent Amount |
Total hours or amount used on a project. It is equal to the value of approved billable and non-billable time. It includes taxes (Tax 1/2/3) for billable time, but excludes them for non-billable entries. It also excludes WUD and extra time. Spent = Billable Time + Non-Billable Time |
Charge Amount |
Total service charge amount being budgeted. It is automatically calculated as: [Hours x Bill Rate] x (1 + Tax 1 + Tax 2 + Tax 3) It can be matched to the contract amount of the associated project. |
% Complete | Percentage of the budget used up or completed for the service item. When you create an invoice using this budget, it uses this percentage to calculate the total amount. You can enter a decimal value as well. |
Tax 1/2/3 | Up to three taxes can be assigned per service line item. They are summed and used to calculate the bill amount for the activity. Example: If activity GEN:TECH has a Tax 1 value of 5% and Tax 2 is 10%, when a time entry is made for GEN:TECH, 15% is added to the service amount billed. |
Start Date | This is the start date attribute for the service line item of the budget. When importing budget into task allocation, this date becomes the allocation Start Date. The start and end dates of the budgets are also used as filters for reporting purposes. |
End Date | This is the end date attribute for the service line item of the budget. When importing budget into task allocation, this date becomes the allocation End Date. The start and end dates of the budgets are also used as filters for reporting purposes. |
Projects > Budget > Expenses > | |
Resource | Resource could be an employee, an outside consultant or a contract employee. |
Units | Quantity budgeted for the selected expense-resource combination. By default, the Budget Units are the same as the Cost Units. It provides managers with a powerful tool to keep their projects within budgeted values. |
Cost Rate | This is the default per unit cost of the expense item without any markups and taxes for proper expense tracking. If the cost of an expense varies, this can be left blank. Then, when you log expenses, you can enter the actual cost there. It passes on to the Budget Cost Rate. |
Spent Units / Spent Amount |
Total expense units or amount used on a project. It is equal to the value of approved billable and non-billable expenses. It includes taxes (Tax 1/2/3) and markups for billable expenses, but excludes them for non-billable entries. It also excludes extra expenses. Expenses have to be a part of the contract. Spent = Billable Expenses + Non-Billable Expenses |
Cost Amount | Cost amount of the expense line item before markup and taxes. The per unit cost is multiplied by the units to compute this value. Amount = Units x Cost Rate |
Markup % | Percentage increase or decrease in the cost of an expense to determine the charge amount. If the markup percentage varies for an expense, leave this field blank and enter it when you log expenses. Do not enter the percentage as a decimal. Example: To increase the cost rate by 10.5%, enter 10.5, not 0.105. |
Charge Amount |
Total charge amount for the expense item. It is calculated as [Units x Cost Rate x (1 + MU %)] x (1 + Tax 1 + Tax 2 + Tax 3)]. |
% Complete | Percentage of the budget being used up or completed for the expense item. When you create an invoice using this budget, it uses this percentage to calculate the total amount to be charged. You can enter a decimal value as well. |
Tax 1/2/3 | Up to three taxes can be assigned per expense line item. They are summed and used to calculate the bill amount for the expense. Example: If expense A has a Tax 1 value of 5% and Tax 2 is 10%, when an expense entry is made for A, 15% is added to the expense amount billed. |
Start Date | This is the start date attribute for the expense line item of the budget. When importing budget into task allocation, this date becomes the allocation Start Date. The start and end dates of the budgets are also used as filters for reporting purposes. |
End Date | This is the end date attribute for the expense line item of the budget. When importing budget into task allocation, this date becomes the allocation End Date. The start and end dates of the budgets are also used as filters for reporting purposes. |
Projects > Project Center > Transactions > | |
Show: Retainers & Trust Funds |
Displays all the retainer-related transactions of the project. It also includes funds received and used under Trust Fund accounts. |
Projects > Project Center > Settings > Details > |
|
Project ID |
Projects are created with unique IDs, and should be simple and short. The ID appears on screens, in drop-down lists and in various reports. The ID field can save up to 65 characters. CORE supports both numeric and alphanumeric IDs. If you prefer, you can set the Project ID format at the global level from the Settings screen. There, you can specify a prefix, ID number and suffix for your project (you should add space or hyphen to separate them). The middle number is automatically incremented by one unit from the value entered. CORE then automatically pre-fills those IDs when you create new projects from this screen. You can also choose in Settings how the project name displays on screen and in various drop-downs.
|
Project Name |
This is the descriptive name of the project. It can be long and detailed. |
Status |
You can assign any of these status to a project. Please note that when there is none selected, you can view all the projects in the list view irrespective of the status. You are notified via email or in-app message when the project status changes, say from Active to Hold (if you are a project manager, principal, originator, or team member with view or edit permissions for projects and have set up notifications in User Settings > Notifications). When you update the status for the parent project, CORE prompts you to implement the changes to its phases as well.
|
Type |
CORE offer two types of project set-up: main and standard. It is recommended to use the Main type for parent projects when you don’t plan to record and bill time and expenses against that parent project. Else, you should use the regular Standard type for all projects as such.
|
Contract Type |
It determines the billing arrangement for a project. Whether a project is billed per hour, lump sum, or not billed at all, it is a best practice to record time and expenses against it to take advantage of the project management features in CORE.
You can set a default invoice and statement template for each type of contract in the Settings screen. |
Contract Amount |
This is the total consideration for the project (billable and non-billable Service Amount + non-billable Expense Amount). You can include or exclude billable expenses and taxes in this amount, depending on how you bill. Although a contract amount is required for fixed-type contracts, it is a good practice to set it for hourly projects as well. This field exhibits a label showing the available amount and the total parent contract amount. Available Contract Amount: Contract amount of root parent (Main) - Sum of contract amount of all its phases Please note that this label is only visible if the root (Main) project is in the hierarchy and that the project has a contract amount specified.
The original contract value is saved for reference till you apply a new calculated contract amount. If the contract amount is changed after creating invoices, past invoices continue to use the original contract amount. Contract amount for a parent project can be allocated to its child projects using the % of Project value. Example: If the contract amount of a main or parent project, NET-001, is $100,000 and Phase A is 60% of the total project, then CORE assigns $60,000 to NET-001:A. |
Contract Service Amount |
Amount spent on the labor or service part of the contract. When you enter the contract amount, this field gets pre-filled by that entire amount. It accounts for the amount spent on the services provided by employees (Client Hours x Bill Rate). You can change this amount, the balance of which goes into the expense amount. = Contract Amount - Contract Expense Amount |
Contract Expense Amount |
Amount spent on the expense part of the contract amount. When you enter the service amount of the contract, this field gets pre-filled with the balance, if any. It accounts for the billable expenses incurred by the employees (Cost Amount = Units x Cost Rate), excluding extra expenses. You can change this amount, with adjustments made to the service amount automatically. = Contract Amount - Contract Service Amount |
Project PO # |
Allows you to record the purchase order number associated with the project. |
% of Project | Percentage of the parent project's contract amount that should be apportioned to the selected phase (child project). For contract types like Fixed, HNTE, and Cost + Fixed Fee, the total % of the project cannot exceed 100%. If it does, CORE prompts you to revise it. Alternatively, you can change the contract type of a phase, which then allows you to enter any value in this field. |
% Complete | Typically, a project manager enters or updates this value indicating the percentage of completion of a project. When you do percent complete billing, this value carries to the Invoices screen (and vice versa). CORE uses it to compute the bill amount and earned value for the project. |
Completed On | This is the date when a project is completed in the ISO 8601 date-time format, such as YYYY-MM-DDThh:mm:ss. You can select this date when the project has finished and you are changing the status of the project to Completed. This field is available only when the project Status is marked as Completed and is useful for reporting purposes. |
Manager | Person who manages the project. You can assign employees as well as vendors (contract employees and outside consultants) as project managers. CORE auto-fills the project manager with the same ID as the client manager, if you leave it blank. |
Principal | Principal usually refers to the owner or partner of a company. It can also refer to the employee who owns and leads the project. |
Originator | This is the creator of a project (person who sets up the project) and is automatically filled by CORE. |
Memo | You can add a memo to the project and format the text using the toolbar, if needed. It also gives you the option to clear any formatting while copy-pasting. |
Projects > Project Center > Settings > Billing Options | |
Reflect Root Project Settings | Allows you to copy the top-level or root project's (parent) billing-related settings to the child project (phase). This option is visible for project phases only. |
Fee Schedule | Allows you to override the default employee (or vendor) bill and cost rates for matching combinations with special rates when time and expenses are logged to a project. |
Estimate | Allows you to select an estimate for the project. This is the estimate that is usually sent to the client for approval and then the budget is based on the approved estimate. |
Budget |
Allows you to assign an existing budget template or create a new project-specific budget from scratch. You can create a unique budget for the project and its phases directly on the Projects > Budget tab. |
Message on Invoice |
Enter a standard message to print on all invoices of the project. This message displays above the footer of the invoice. You can also define a standard invoice message for all the projects of a client on the Clients screen or globally for all client and projects from Settings. If a message is defined, it shows up automatically on invoices. |
Invoice Number |
Allows you to customize the invoice number format for a project. It takes precedence over the invoice numbering set in Settings. CORE supports both numeric and alphanumeric invoice numbers in a prefix-last number-suffix format. Both prefix and suffix strings remain static. You can see the preview of the numbering when this option is enabled. Example: For the ease of remembering, you should keep the prefix as something that relates to the project like Project ID or year, say, ABC or 2024. Last invoice number can be something like 0000 so the new invoice number would be 0001. The suffix comes last and can be, say, LA for a project located in Los Angeles. The resulting invoice number will be '20240001LA'. Reversing an invoice with a custom number resets the last invoice number here. Also, if you generate an invoice (or a draft) and delete it, CORE re-uses that number so that there is no gap in the sequence. |
Automatic Billing: |
Allows you to set up a project for automatic billing at a specified frequency. It knows when is the start date of the first billing or when the last invoice went out for a project, how much approved work-in-progress it has, and when the next invoice is due. |
Start Date |
Represents the start date of the first billing cycle of the automatic billing schedule. It is the first day you want CORE to automatically process an invoice for you. Depending on the billing frequency set, CORE triggers the processing of the first automatic invoice on this date and includes the approved time and expense entries for the project covering that period. Then the next billing will occur exactly after the selected period (frequency) of the current billing and so on. Example: If you set the Start Date as April 15th of this year and your billing frequency is Monthly, the first billing will occur on April 15th for the approved time and expenses of the entire calendar month from April 1st to April 30th. The second billing will occur after 30 days on May 15th covering the month of May (30 days). Then the third billing will occur again after 30 days on June 14th covering the month of June (31 days), and so on. |
Frequency |
This represents the frequency at which the automatic billing will occur. In other words, it determines how often or at what interval the billing cycle gets repeated, say weekly, monthly, etc. It generates the next bill date accordingly and determines the Billing From-To period on invoices. The billing continues till the End Date or indefinitely, as per your selection. Example: If you set the Start Date as April 15th of this year and your billing frequency is Monthly, the first billing will occur on April 15th for the approved time and expenses of the entire calendar month from April 1st to April 30th. The second billing will occur after 30 days on May 15th covering the month of May (30 days). Then the third billing will occur again after 30 days on June 14th covering the month of June (31 days), and so on. |
Process Mode |
Determines how the invoices are processed after being generated automatically.
|
Main Service Tax % | Tax applied to the labor or service amount on invoices. It takes into account the taxes (namely Tax 1/2/3) associated with the activity items. |
Main Expense Tax % | Tax applied to the expense amount on invoices. It takes into account the taxes (namely Tax 1/2/3) associated with the expense items. |
Minimum Retainer | CORE allows you to set a minimum retainer amount for a project and then monitors it for you. The minimum retainer set here acts as a threshold and triggers an automatic retainer invoice as soon as the available retainer drops below it. When a draft invoice results in pushing the available retainer below this minimum, then also it generates a reminder. |
Retainage % | Percentage of the invoice amount that a client holds back against the verification and quality of work completed on the project. The accumulated retainage is typically paid after the verification is done. CORE computes the invoice amount as:
Amount Due = Services Billed + Expenses Billed + Taxes – Applied Retainer – Discount – Retainage Example: If the total bill amount = $1000 and calculated Retainage = $50, the invoice sent to the client displays the bill amount prior to applying the retainage (say $1000) and then the Amount Due after retainage (say $1000 - $50 = $950). |
Maximum Retainage | You can see this option when the 'No limit' option is unchecked. It represents the maximum amount that a client can retain on a given project. Example: If you set a retainage of 5% and maximum retainage amount is $2000 on a project, CORE calculates this 5% on every invoice (billable amount) until the accumulated retainage reaches $2000. After it reaches this maximum limit, full invoice amount is due from the client. |
Accounts & Class |
You can override the global-level default accounts with those set at the project level here. These accounts take precedence over the global-level accounts. However, they can be further overwritten at the item level.
|
Class | You can select a project-level class here to be used for time and expense entries logged against it. The relationship between a class and a project is one-to-one (a project can be assigned to one class only). You need to assign a class to items before creating invoices and prior to synchronization with your accounting software. Else, your class fields will remain blank there and not display in reports. |
Terms | Determines the number of days after which the project invoice is due. A blank payment term means the invoice is due upon receipt. The payment term for a project overrides the default term set for the client. |
Billing Contact | If needed, you can assign a different contact to a project other than the default client contact. If you select 'Send Invoice to Contact', then CORE sends the project invoices and statements to this contact instead of the default client contact. In addition, the address of this contact overrides the client address and prints on invoices and statements. To see these contact details in other screens such as Invoice Collections, you must have set this option here. |
Online Payment Account |
CORE allows your clients to make online payments using the ePayments feature. It is inherited from the client record, but you can select another online payment service account here for the project from the drop-down. You can also set it up at the global level for all clients and projects in the Settings screen. CORE allows you to select multiple online payment accounts. However, you cannot choose two payment services with the same payment method. |
Split Billing |
You can enable or disable the split billing option for your project (matter) or phase here. This feature is commonly used in the legal industry wherein the invoice is split into various parts to divide work among clients, firms or payers. Example: You might want to split the invoice between a primary matter and a secondary matter in a proportion of, say, 20% and 80%. All the time and expense entries are logged to the primary matter, but the billing is split among the clients of the secondary matters.
|
Projects > Project Center > Settings > Assignment | |
Add Rule |
You can set these rules for the selected project as well as its phases:
|
Add: Add to... |
Allows you to apply current assignments to the selected project or to the project and all its phases (if parent project is selected). This is helpful in easily adding or removing assignments to phases when doing so for the parent project as you do not have to repeat these steps for each individual phase. If this Add to Project and Phases option is not used, then assignments added or removed only apply to the currently selected project. Note: This option is to be used independently for each type of assignment (say rules, contacts, activities, etc.); in other words, if used for one assignment type, it is not applied for all the other types. |
Apply changes to all phases |
This option allows you to apply any assignment changes (deletions or edits) of the parent project to all phases automatically. This is helpful in easily adding or removing assignments to phases when doing so for the parent project as you do not have to repeat these steps for each individual phase. For example, if we update the billable flag of an activity, it also updates for the phases, and deleting an assignment deletes it from the phases that have it. |
Classification |
Job title or classification of a team member or employee. It allows you to set up a different title other than the default one. This gets reflected in the time entries, invoices, and reports of a project. Example: Allen Marcello is the Senior Engineer as per the Employees screen; however, you can classify him as the General Manager for a specific project. |
Type |
Type of team member assigned to a project, such as employee or vendor. It can be a group or an individual. |
Projects > Project Center > Settings > Monitoring | |
Project Notifications |
You have the option to be notified through alerts when specific project milestones are achieved. CORE allows you to set up these alerts here as well as in the Project Templates screen. These settings are then inherited into the project while creating a project from the template. You can control when and how these alerts should be sent out. You can also enable or disable each project notification at any time.
|
Enabled/Disabled |
The toggle button allows you to enable or disable the project notifications. |
Send notifications by... |
You can choose whether you want to receive these notifications as an email or in-app or both. You can make your selection by checking the relevant options. |
When Approved Spend reaches...of contract/budget |
This value sets the threshold at which CORE issues notifications. For instance, if you want to receive notifications only when the approved project spending reaches 75% of the contract or budget amount, you should specify the value as 75%. |
...send to... |
You can manage the recipients for each notification using the send to drop-down list. CORE allows you to pick as many recipients as needed. You can send this notification to the Project Manager, Principal, Project Originator, Team assigned to this project, or any employee or employee group. Note: Please note that the notification is sent to the selected recipients only once for each threshold. |
Additional Threshold |
You may want to receive notifications at various thresholds, such as 25%, 45%, 75%, 80%, and so on. You can set up as many notifications for additional thresholds as you need using this option. |
Projects > Import Projects from CSV > | |
CSV (UTF-8) | UTF stands for Unicode Transformation Format. It is a character encoding format that can be as compact as ASCII (if the file is plain English text), but can contain unicode characters as well. It uses 8-bit blocks to represent each character that is encoded. UTF supports many languages and can accommodate pages and forms in any of those languages. |
Create Projects from Scratch
You can create a new project profile either from scratch or from an existing project template.
To create a project from scratch, watch this video or follow these steps:
- Open the Projects screen from the side menu > Projects.
- Click Create Project and select From Scratch.
- On the Create Project screen, enter the required information. Check Field Descriptions above for details.
- Project ID: CORE supports both numeric and alphanumeric IDs.
- Project Name
- Client
- Manager: CORE auto-fills the project manager with the same ID as the client manager, if you leave it blank.
- Contract Type
- Contract Amount: Although contract amount is required for fixed-type contracts, it is a good practice to set it for hourly projects as well.
- Recurring Amount
- Fixed Fee Amount: Fixed fee contracts involve billing direct costs (time and expenses) plus a fixed fee (profit) to the client. Check Field Descriptions above for details.
- Click Split Amount: You can manually split the Contract Amount into:
- Contract Service Amount
- Contract Expense Amount
- Status: All new projects and phases are assigned this Draft status by default.
- Click Calculate Contract Amount: CORE provides options to calculate the contract amount on a percentage of construction cost basis or unit cost basis. Check out this video on how to calculate contract amount in CORE.
- Enter other information about the project, if needed. Check Field Descriptions above for details.
- Click Save & Done or Save & Add Another.
Create Projects from Templates
You can create a new project profile either from scratch or from an existing project template. When creating a new project structure based on a project template with a hierarchy (including parent project and phases), the project information is pre-filled from the template, but can be overwritten. The new project and phases inherit the name and description of the template's underlying parent project and phases to preserve the original structure, but these can be overwritten as well.
To create a project from a template, watch this video or follow these steps:
- Open the Projects screen from the side menu > Projects.
- Click Create Project and select From Template
- On the Choose a Template dialog, select a template from the list. You can view its structure on the right.
- Click Continue.
- On the Create New From Template screen, enter or edit details about your new project. Check Field Descriptions above for details.
- Project ID: CORE supports both numeric and alphanumeric IDs.
- Project Name: By default, CORE pre-fills it with the project template name, but you can overwrite it with a new project name.
- Client
- Manager
- Select the attributes of the template project that you want to copy to the new project such as project rules, groups, class, contacts, custom fields, to-dos, project monitoring, etc.
- Click Create Project.
A new project is created. You can view its details and edit them as needed.
Note: Typically, for project to-dos, you require a Start Date and End Date besides the Assigned To, but for project template to-dos, CORE does not require them. Instead, you need to specify the Duration in days in which the to-do task will get completed. If you create a project from a template with to-dos, the start date of the new project to-do will be the project template start date and the end date will be calculated based on that duration (Start Date + Duration). If there are multiple template to-dos, the next to-do start date will be the previous to-do's end date. If you save a project with to-dos as a template, then the Duration (Days) field for the template to-do will be calculated based on the difference between the Start Date and End Date.
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 :
- 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 progress, 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
Add Project Phases
You can add phases to projects by drag-and-drop action as well as by using the standard Add action. In general, when a parent project is selected, CORE treats all the project phases as selected too. When you create a phase for a project, it automatically inherits some of the parent project attributes (such as project manager, budget, groups, rules, contacts, terms, etc.) and allows you to choose which ones to inherit.
To add a phase to a parent project, watch this video or follow these steps:
- Open the Projects screen from the side menu > Projects.
- In the list view, select a project on the grid that you want to make the parent and click to select View Details.
- In the Project Center view, click to select Add Phase or go to the Structure tab and select a project on the grid.
- Click Add Phase.
- On the Add New Phase screen, enter the required information. Check Field Descriptions above for details.
- Phase ID: When you enter the phase ID, it also pre-fills the Phase Name and Phase Description with the same ID. You can edit those, if needed.
- Phase Name: When you enter the phase ID, it also pre-fills the Phase Name and Phase Description with the same ID. You can edit those, if needed.
- Contract Type
- Split Amount/Enter as Sum: As a project manager, you can enter or calculate the contract amount for the project.
-
Contract Amount: Although contract amount is required for fixed-type contracts, it is a good practice to set it for hourly projects as well.
- Click Split Amount if you want to split the Contract Amount into:
- Contract Service Amount
- Contract Expense Amount: Check Field Descriptions above for details.
- Click Calculate Contract Amount if you want CORE to calculate the contract amount for the phase on a percentage of construction cost basis or unit cost basis.
- You can also select the parent project attributes that should be inherited by the new phase. Then click Save & Done or Save & Add Another.
The newly added phase is displayed on the grid under the parent project. You can see the project hierarchy regardless of which level you are on; the current level is highlighted to indicate where you are in the entire hierarchy.
Manage Project Structure
CORE allows you to not only add phases to projects, but also reorder these phases in the project hierarchy or move any project to the parent project level, in case something changes. In the Projects detail view, you have a drop-down at the top that allows you to access any project or phase in the hierarchy and view its information. You can see the project hierarchy regardless of which level you are on; the current level is highlighted to indicate where you are in the entire hierarchy.
On the Structure tab, you can view the entire project hierarchy as well as details of each phase in a grid. Project managers can make informed decisions about things like percent complete or contract amount. They can also delete or merge multiple projects and phases.
Note: In case of a 'Main' project, it displays totals and the values are calculated based on the values of all phases.
To manage a project hierarchy, watch this video or follow these steps:
- Open the Projects screen from the side menu > Projects.
- In the list view, click on a parent project row and select View Details.
- In the Project Center view, go to the Structure tab.
- Select your Comparison view from the drop-down: Contract or Budget.
- Review the project information in the grid and edit some of the values, if needed. Check Field Descriptions above for details.
- % of Project
- Amount
- PM % Complete: percentage of completion of a project or its phase. This column is available only when you select Comparison: Contract in the drop-down.
- Select a project or phase on the grid and then click Add Phase if you want to add a new phase to it. Select the attributes of the parent project that you want to copy to the new phase such as assignments, taxes, budget, class, etc.
- Hover over the project hierarchy in the grid and click on the row to drag it up or down to reorder it. This affects how the project structure is displayed on reports and invoices, or while entering time against the project.
- You can select multiple rows and then click Actions > to either delete those projects (or phases) or merge them into one.
- You can also click More > View Reports to run some comparison and analysis reports on the projects.
Add Budgets
CORE allows you to assign an existing budget template to your projects and phases or create a project-specific budget from scratch. Budget templates created in the Budget Templates screen are standalone and can be assigned to multiple projects. The unique, project-specific budgets can be created for your projects and their phases from the Projects screen itself.
To add a budget to a project:
- Open the Projects screen from the side menu > Projects.
- In the list view, click on a project row and select View Details.
- In the Project Center view, go to the Settings > Billing Options tab. In case of a phased project, make sure you have the right project selected in the list view: parent project, phase or sub-phase.
- Select one of the Budget options:
- From Scratch: If you want to create a project-specific budget here on the Budget tab
- From Template: If you want to use an existing budget template from the drop-down; CORE then adds the template details on the Budget tab here.
- Go to the Budget > Details tab and edit the budget details here in case you added the budget from an existing template. Else, enter relevant details in case you are adding a new budget. Check Include Phases if you want to add or view budget details for the project and all its phases. Check Field Descriptions above for details.
- Fee Schedule
- Miscellaneous Amount
- On the Budget > Services tab, click Add and enter information in the top row of the grid. In case of phased projects, you must expand the hierarchy first. Check Field Descriptions above for details.
- Resource: an employee, an outside consultant or a contract employee
- Activity
- Hours
- Cost Rate
- Bill Rate
- % Complete
- Tax 1/2/3
- Start Date
- End Date: Check Field Descriptions above for details.
- Click Done to save the item. You can add more service line items here.
- Similarly, go to the Expenses tab and click Add to enter information in the top row of the grid. In case of phased projects, you must expand the hierarchy first. Check Field Descriptions above for details.
- Resource: an employee, an outside consultant or a contract employee
- Expense: It is referred to as Cost in the legal industry.
- Units:
- Cost Rate
- Markup%
- % Complete
- Tax 1/2/3
- Start Date
- End Date: Check Field Descriptions above for details.
- Click Done to save the item. You can add more expense line items here.
You can check the total budget and cost amounts back on the Budget > Details tab.
Export Budget Line Items
In CORE, you can export budget services and expenses to the Comma Separated Values file format. CORE exports data from all available columns and not just the columns visible in the grid.
To export budget services and expenses to a .CSV file, 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.
-
In the Project Center view, go to the Budget > Services/Expense tab and click More > Export as CSV.
- A .csv export file is created and saved on your system at the default download location, say your desktop. Click to open the spreadsheet.
You can also check the detailed video on exporting data in CORE.
Create Invoices from Budgets
You can create invoices based on the budget data as well as the billing arrangement of the project.
To create an invoice from a budget:
- Open the Projects screen from the side menu > Projects.
- In the list view, click on a project row and select View Details.
- In the Project Center view, go to the Budget tab and click More > Create Invoice.
- On the Create Invoice dialog, click Continue.
- You are taken to the Create Invoice screen with the budget data pre-filled.
- Add more items or memo, if required.
- Click Process and select Draft or Final.
Your invoice is created from the budget.
Convert Budgets to Estimates
Typically, budgets are used for internal purposes and estimates are created for the clients.
To convert a budget into an estimate:
- Open the Projects screen from the side menu > Projects.
- In the list view, click on a project row and select View Details.
- In the Project Center view, go to the Budget tab and click More > Convert to Estimate.
- On the Convert to Estimate dialog, enter the required information for the new estimate. Check Field Descriptions above for details.
- ID
- Description
- Service Markup:
- Expense Markup:
-
Click Save.
Email Budgets
You might want to share the budget with your managers, employees or clients via email.
To email a budget:
- Open the Projects screen from the side menu > Projects.
- In the list view, click on a project row and select View Details.
- In the Project Center view, go to the Budget tab and click More > Email Budget.
- On the Compose Email dialog, enter the required information. Check Field Descriptions above for details.
- To
- Subject
-
Message
- Each selected budget is attached as a separate file to this email. Click Add Attachments at the bottom to attach any document to the email. You can also drag-and-drop any file into the Compose Email window from your desktop or email program.
- Click Send Message.
If the email is sent to an address that is no longer working, there is a bounce-back email sent to let you know about this. You can also check the detailed video on emailing in CORE.
Note: You cannot remove the default or system attachments. Only user-defined attachments can be added or removed. CORE restricts the file size of the attachments to 10 MB and sends the attachments as a single zipped file.
Download Budgets
You can download the details of the budget as a PDF file directly from the Budget tab.
To download a budget:
- Open the Projects screen from the side menu > Projects.
- In the list view, click on a project row and select View Details.
- In the Project Center view, go to the Budget tab and click More > Download Budget as PDF.
- It prompts you to save the PDF at the relevant location, say your Desktop. Click Save.
Preview Project Transactions
CORE allows you to preview project-related transactions such as invoices, retainers, and vendor bills directly from the Projects screen. This is useful for project managers who need to drill-down into the details of some transactions.
To preview a project transaction:
- Open the Projects screen from the side menu > Projects.
- In the list view, click on a project row and select View Details.
- In the Project Center view, go to the Transactions tab and select the relevant Show option. Check Field Descriptions above for details.
- Click on a transaction row and select Preview. It opens in the viewer.
- Preview the transaction and then choose to print or export it, if required.
Add Documents
You can view all documents of the project and its phases, if any, on this screen. You can also view all the documents present in CORE from More menu >View All Documents.
To add a document to a project record:
- Open the Projects screen from the side menu > Projects.
- In the list view, click on a project row and select View Details.
- In the Project Center view, go to the Documents tab and click Add.
- On the Add Documents dialog, select the relevant tab, depending on the type of attachment.
- Computer: To attach files stored on your computer, enter its Description and drag your file or click to browse to that location.
- Hyperlink: To attach an external link, enter its Description and then insert the hyperlink.
- Dropbox: To link files stored in your Dropbox account, enter its Description and then browse for it.
- Google Drive: To link files stored in your Google Drive account, enter its Description and then browse for it.
- OneDrive: To link files stored in your Microsoft OneDrive account, enter its Description and then browse for it.
- Box: To link files stored in your Box account, enter its Description and then browse for it.
- Resource Library: To link company resources, select the resource from the library. This option is available only with CORE CRM.
-
Click Add.
CORE pre-fills some of the information about the attached documents in the grid. You can send the documents to your clients, employees or other contacts for getting their digital or electronic signatures (eSignature via DocuSign) using the eSign option from the row-action menu. CORE automatically adds the signed documents to the Documents folder of the entity (record) as separate attachments. You can also check the detailed video on managing documents in CORE.
Add To-Dos
You can view all the to-dos of the project and its phases, if any, on this screen. To add a new to-do task for a project, 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.
- In the Project Center view, go to the To-Dos tab and click Add.
- Enter the required information in the top row of the grid. Check Field Descriptions above for details.
- Description
- Start/End Date
- Assigned To
- Priority: level ranging from low to high
- % Complete
- Click Done.
You can also check the detailed video on managing to-dos in CORE.
Add Notes
You can view all the notes of the project and its phases, if any, on this screen. Project category notes created in the Invoices or Invoice Collections screen also show up here.
To add a new note for a project:
- Open the Projects screen from the side menu > Projects.
- In the list view, click on a project row and select View Details.
- In the Project Center view, go to the Notes tab and click Add.
- Enter the required information in the top row of the grid:
- Category
- Description
- Date
- Status
- Click Done.
You can also check the detailed video on managing notes in CORE.
Assign Groups
You can quickly assign a project to a group or view whether the selected project is a member of any existing group.
To assign a project to a group:
- Open the Projects screen from the side menu > Projects.
- In the list view, click on a project row and select View Details.
-
In the Project Center view, go to the Settings > Details tab and click Assign Groups.
- On the Assign Groups dialog, select the desired group for the project. By default, the All group is assigned and set as the default group for all projects.
Note: The default group is useful for reports. If there is a budget for a project P1, which is a member of both groups A and B but its default group is A, then P1 is listed against A on the budget reports. - Click Update.
You can also check the detailed video about creating and managing groups in CORE.
Group Projects
You can group projects based on shared or common attributes such as type, industry, location, etc. This is useful for filtering records in the lists and reports. In addition, groups save time and effort when setting up fee schedules and budgets. For example, you can group projects by category (say 1040 Tax Prep, Network Installation, Computer Drafting, etc.) for easier comparison of performance, write-up/downs, and so on. A project can have more than one group and among these groups, one group is set as the default one (usually, the default group is All Projects).
To group various projects:
- Open the Projects screen from the side menu > Projects.
- In the list view, click on a project row and select View Details.
-
In the Project Center view, go to the Settings > Details tab and click Assign Groups.
- On the Assign Groups dialog, click Manage Groups.
- On the Groups screen, click Create New. (You can also go directly to this screen via side menu > Settings > Groups.)
- On the Create Project Group screen, enter the required information:
- Name
- escription
- Select the relevant options:
- Add new projects automatically: Automatically adds all new projects to the new group as they are created.
- Include all project in new group: Includes all existing projects in the new group.
- Click Save.
You can also check the detailed video about creating and managing groups in CORE.
Assign Invoice Templates
You can assign a different invoice template to a project instead of the default set at the global level in the Settings screen. Depending on the status of an invoice, you can also change its template from the Invoices screen, wherein you can then reflect that change in the related project.
To set an invoice template at the project level, 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.
- In the Project Center view, go to the Settings > Billing Options tab and click Choose Template for any of the invoice templates:
- Standard Invoice
- Joint Invoice
- Manual Invoice
- On the Choose Template dialog, pick a new template for the project after selecting the Show option.
- You can preview the sample template in the viewer. Click Done.
- The selected invoice template is assigned to the project. Click Save.
Set Automatic Billing
For hourly or fixed fee projects, instead of running billing reports and checking the billing records every now and then, you can use the automatic billing feature in CORE. You can set up auto-billing for your projects. Based on their contract type, billing schedules, and billable time and expenses, they will be billed at the specified frequency. In case of fixed-type projects, you can create a billing schedule and set the 'reminder date' to coincide with the automatic billing 'start date'. We recommend setting up the Auto Approve rules for time and expenses for the projects that you want to auto bill so that the process is completely automated. That way you do not have to manually approve entries for billing.
The automatic billing feature differs from the recurring invoices in many ways. First, auto-bill is set at the project level while the latter is set at the invoice level. Unlike recurring invoices, automatic billing is dynamic because of the changing bill amount as you do not have a pre-defined fixed amount being billed to the client. When we set a schedule for a project and the schedule is due, then all the bills (approved time and expense entries, billing schedule, recurring bills, etc.) that can be processed for the project for the current billing period are processed as invoices. If there is nothing to be processed, no invoice is created. So, CORE bills the client according to the billing arrangement and rules set for the project with the automatic schedule.
To set up automatic billing for a project, 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.
- In the Project Center view, go to the Settings > Billing Options tab and enable the Bill Automatically option.
- Enter the required information. Check Field Descriptions above for details.
-
Start Date
-
Frequency
-
End Date
-
Assigned Biller
-
You can choose to process the invoice manually in the Invoices screen (by the assigned biller) or completely automate it.
-
Click Save & Done.
You can see all your automatic billings on the Recurring Invoices screen. You can edit the recurring schedule there as well.
Set Up Split Billing
You can enable or disable the split billing option for your projects (matters) and phases. This feature is commonly used in the legal industry wherein a single invoice is split among various parties (clients) and payment collected from them individually. It allows CORE to distribute services and expenses logged against that matter to one or more matters/clients based on a percentage/amount or remainder rules. For example, you might want to split the invoice between a primary matter (root project in CORE) and a secondary matter in a proportion of, say, 20% and 80%. All the time and expense entries are logged to the primary matter, but the billing is split among the clients of the other matters. The line item taxes and main taxes are included in the split billing percentage set at the matter level. You cannot do progress billing in case of split invoices wherein the time and expense entries are released after billing and then linked to existing invoices.
To set up split billing for a matter, watch this video or follow these steps:
- Open the Projects screen from the side menu > Project (Matters in case of legal company database).
- In the list view, click on a matter row and select View Details.
-
In the Project Center view, go to the Settings > Billing Options tab and enable the Split Billing option at the bottom.
- Enter the required information. Check Field Descriptions above for details.
- Project: You can choose other matters or phases that are to be included in the split billing.
- Service %
- Expense %
-
Click Done. Keep adding more matters, as needed. The percentage values are balanced proportionately.
-
When you have finished, click Save & Done.
After you set up your split billing, it is recommended to set the Joint Invoice template to Split Invoice on the Billing Options tab. That way your split invoices are presented in the right layout. When billing this matter from the Invoices screen, CORE splits the invoice amount among multiple clients.
Add Billing Schedules to Projects
You can create and add billing schedules to your projects. This allows you to plan your billing in advance and get reminded about the scheduled billing. This feature is very useful if you prefer milestone billing. You can set the milestones in the billing schedule by adding line items accordingly.
To add a billing schedule to a project, 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.
- In the Project Center view, go to the Settings > Billing Schedule tab and click Add.
- Enter the required information in the top row of the grid.
- Click Done. Check Billing Schedules for details.
Assign Rules to Projects
Rules control how projects behave or get billed in CORE. Some of the rules are set up at the global level and pass on to all the projects. You can override those rules at the project level. In case of phased projects, you should set the rules at the parent project level so that they are pushed to all the phases too. You can then edit those rules at the phase level, if needed.
To set rules for a project:
- Open the Projects screen from the side menu > Projects.
- In the list view, click on a project row and select View Details.
- In the Project Center view, go to the Settings > Assignment tab and select Show: Rules from the drop-down.
- Click Add Rule.
- On the Add Rule dialog, select all the rules you want to apply to the project. Check Field Descriptions above for details.
- After selecting the rules in the grid, click Add and select the relevant option. Check Field Descriptions above for details.
-
Add to Project
-
Add to Project and Phases
-
You have successfully added the relevant rules to the selected project.
Assign Contacts to Projects
Project contacts can be the contacts of the clients, employees or vendors associated with a project. When adding a contact, you are presented with a list of people not yet assigned to the project.
To add a contact to a project:
- Open the Projects screen from the side menu > Projects.
- In the list view, click on a project row and select View Details.
- In the Project Center view, go to the Settings > Assignment tab and select Show: Contacts from the drop-down.
- Click Add Contact.
- On the Add Contact dialog, select the relevant contacts for the project.
- After selecting the contacts, click Add and select the relevant option. Check Field Descriptions above for details.
-
Add to Project
-
Add to Project and Phases
-
You have successfully added the relevant contacts to the selected project.
Assign Team Members to Projects
Team members of a project can be the employees and vendors who can log their time and expenses against it. When adding a team member, you are presented with a list of people not yet assigned to the project. You can copy the assignments from associated budgets also.
To assign a team member to a project, 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.
- In the Project Center view, go to the Settings > Assignment tab and select Show: Team Members from the drop-down.
-
Note: Parent projects with the Main status appear grayed out in the drop-down list.
- Click Add Team Member.
- On the Add Team Member dialog, select the relevant information:
- Type: Individuals or Groups
- Employee or Vendor
- Select the team members on the grid and click Add to select the relevant option. Check Field Descriptions above for details.
- Add to Project
- Add to Project and Phases
-
You can enter a classification for each member on the grid. After selecting the team member, click Add and select the relevant option. Check Field Descriptions above for details.
-
Add to Project
-
Add to Project and Phases
-
Note: You can also use the Copy from Budget option from the More menu to copy the assignments from the associated budget, if any. You are prompted to replace the existing assignments when copying.
You have successfully added the relevant team members or employees to the selected project. Now only these assigned team members will appear in the drop-down lists of the time and expense entry screens and can log time against the project.
Assign Activities to Projects
When adding an activity, you are presented with a list of activities not yet assigned to the project. You can copy the assignments from associated budgets also.
To assign an activity item to a project, 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.
- In the Project Center view, go to the Settings > Assignment tab and select Show: Activity Items from the drop-down.
-
Note: Parent projects with the Main status appear grayed out in the drop-down list.
- Click Add Activity Item.
- On the Add Activity Item dialog, select the relevant information: Show: Individuals or Groups.
- Select the activities on the grid and click Add to select the relevant option. Check Field Descriptions above for details.
-
Add to Project
-
Add to Project and Project Phases
-
You can change the Billable status for each activity item on the grid, if needed. Click Done.
Note: You can also use the Copy from Budget option from the More menu to copy the assignments from the associated budget, if any. You are prompted to replace the existing assignments when copying.
You have successfully added the relevant activities to the selected project. Now only these assigned items will appear in the drop-down lists of the time entry screens for the project.
Assign Expenses to Projects
When adding an expense, you are presented with a list of expenses not yet assigned to the project. You can copy the assignments from associated budgets also.
To assign an expense item to a project, 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.
- In the Project Center view, go to the Settings> Assignment tab and select Show: Expense Items from the drop-down.
Note: Parent projects with the Main status appear grayed out in the drop-down list.
- Click Add Expense Item.
- On the Add Expense Item dialog, select the relevant information:
- Show: Individuals or Groups
- Select the expense items on the grid and click Add to select the relevant option. Check Field Descriptions above for details.
-
Add to Project
-
Add to Project and Project Phases
-
You can change the Billable status for each item on the grid, if needed. Click Done.
Note: You can also use the Copy from Budget option from the More menu to copy the assignments from the associated budget, if any. You are prompted to replace the existing assignments when copying.
You have successfully added the relevant expenses to the selected project. Now only these assigned items will appear in the drop-down list of the Expense Entries screen for the project.
Add Custom Fields
Using custom fields, you can track extra characteristics and attributes of your projects. You can even customize these fields in the Custom Labels screen. For example, if you want to add the name of your company’s principal or in-charge in the Projects screen, you can easily do that by changing the field label to Principal or creating a new custom label.
To add a custom field, 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.
- In the Project Center view, go to the Settings > Custom Fields tab click Add Custom Field.
- Select the type of field you want depending on the purpose, say Text Box.
- On the Add Text Box dialog, enter the required information:
- Name
- Type
- # of Characters
- Check Show in List View if you want this field to appear under the Show/Hide Columns list and show up on the grid. Click Save.
Note: You can display a maximum of three custom fields on the list view per screen.
You can also check the detailed video on managing custom fields in CORE.
Monitor Projects
Monitoring projects allows you to trigger alerts or notifications when specific milestones are achieved. CORE allows you to set up these alerts here as well as in the Project Templates screen. These settings are then inherited into the project (Main or Standard type with phases and sub-phases) while creating a project from the template. You can control when and how these alerts should be sent out. You can also enable or disable each project notification at any time.
To set up project notifications:
- Open the Projects screen from the side menu > Projects.
- In the list view, click on a project row and select View Details.
-
In the Project Center view, go to the Settings > Monitoring tab.
- To start receiving notifications upon reaching a milestone on the project, you must enable this option by turning on Enabled. Check Field Descriptions above for details.
- You can choose whether you want to receive these notifications as an email or in-app or both by checking the relevant options.
- Enter a value and set the threshold at which CORE sends you notifications when specific milestones are achieved.
- You can manage the recipients for each notification using the send to drop-down.
- Click Additional Threshold to set notifications for additional milestones.
- Click Save.
Send Projects
In CORE, you can send project records to your accounting program, such as QuickBooks Online, MYOB AccountRight and Xero.
To send a project record to your accounting program, 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.
- In the Project Center view, click to select Send To on the top-right.
- Select the relevant option from the drop-down, say QuickBooks. Your data is sent.
CORE allows you to send projects to QuickBooks using the Send to QuickBooks option from the row-action menu in the list view. You can send a maximum of 25 records from the projects list to QuickBooks without having to drill down into the detail view. CORE displays a progress bar when sending these records to QuickBooks.
Note: You can click More > Show/Hide Columns to display QB Linked column to check the sync status of the records before sending them to QuickBooks.
Save Project Templates
When you are creating a new project, you can base it on an existing template. You can save an existing project as a template. Be sure to give a special ID and name to each project template.
To save a project as a template, watch this video or follow these steps:
- Open the Projects screen from the side menu > Projects.
- In the list view, click on a project that you want to use as a template and select View Details.
- In the Project Center view, click to select Save as Template on the top-right.
- On the Save Template dialog, enter the required information:
- Name
- Description
- Click Save.
This template is now available in the list when you create projects from a template. You cannot delete project templates that have phases; you must delete the phases first.
Enter Opening Balance
This option allows you to specify an opening balance for an existing or older project. It is an alternative to creating historical manual invoices for projects migrated from another system to CORE. Older balances can be brought forward and you can enter historical data here. All your income is sent to the default income account. However, if you want to specify details and accounts for different items, you should then use the Invoices screen.
You need the following information before entering the opening balances in CORE:
- Start date and other figures from the trial balance, balance sheet and income statement
- Most recent bank statement
- Check and deposits outstanding on or before your start date (not cleared)
- Unpaid bills (vendor bills), open invoices and value of inventory
To enter or edit opening balance for a project, 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.
- In the Project Center view, click to select Opening Balance on the top-right.
- On the Opening Balance dialog, enter the required information:
- Balance As Of date: This is the 'up to' date of the historical data that is being entered here. It represents the date of the opening balance.
- Services Billed
- Expenses Billed: Expenses are referred to as costs in the legal industry.
- Payments, Discounts and Retainers
- Click Create. The opening balance is added to the project accounts.
Note: You cannot update the opening balance that has payment associated with it.
View Project Snapshot
CORE allows project managers to quickly scan and review key performance indicators for projects without having to navigate to the project details or run reports with the help of Project Snapshot. This snapshot displays all the important performance metrics and aims to reduce context switching, thus saving you time and effort. So, project KPIs can be accessed directly from the Projects list view. This feature is available to all users who have permission to view project data.
To view a project's snapshot:
- Open the Projects screen from the side menu > Projects.
- In the list view, hover over any project or phase and click Open. It displays Project Snapshot on the right.
- At the top of the snapshot, it displays the root project and phase name. This is clickable and takes you to the project details (Settings > Details).
- The top row of the snapshot displays totals of important project metrics that help assess the overall status and progress of the project. Check Field Descriptions above for details.
- % Complete
- The second section with the pie chart is color-coded and gives you insight into the overall financial status of the project in terms of its contract amount, spent amount and remaining balances, etc. Most of the metrics are clickable and open up relevant filtered reports. Check Field Descriptions above for details.
- Contract: Click Contract if you want to check the Contract Analysis report filtered for the selected project.
- Contract > Billing: The outer green ring on the pie chart shows the part of the contract amount already billed on invoices of the project. Click Billing if you want to check the Project Account Details report filtered for the selected project.
- Contract > Usage: The inner orange ring on the pie chart shows how much of the contract amount is used or spent on a project.
- Similarly, the other section with the pie chart is color-coded and gives you insight into the overall financial status of the project in terms of its budget, spent amount and remaining balances, etc. Most of the metrics are clickable and open up relevant filtered reports. Check Field Descriptions above for details.
- Budget: Click Budget if you want to check the Budget Comparison report filtered for the selected project.
- Budget > Services: The outer blue ring on the pie chart shows the total number of budgeted service hours used. Click Services if you want to check the Time Details report filtered for the selected project.
- Budget > Expenses: The inner purple ring on the pie chart shows the total number of budgeted expense hours used. Click Expenses if you want to check the Expense Details report filtered for the selected project.
- The next sections display the Earned Value and open To-Dos widgets. Check Field Descriptions above for details.
Clone Projects
You can clone or duplicate projects to save time in creating new ones, whether they are single projects or parent projects with phases. For example, as an accounting firm, you may deliver tax preparation services to hundreds or thousands of clients every year. If you want to save time in creating similar projects in CORE, use its Clone feature. For the accounting firm, this means cloning ‘1040-2024’ project to all tax preparation clients in one go! You can create standard project templates, say for residential projects, and then clone them whenever a new job comes up. The variations can be fine-tuned later.
While cloning phases, the phase ID, name and description of the source project hierarchy passes on to the cloned hierarchy. You can change some of the attributes of the new project, while the rest of the data and settings are inherited from the source projects. CORE adjusts the start and end dates of task allocations of the new projects based on their start date. CORE creates a copy of the budget or estimate when cloning projects with an assigned budget or estimate. The new budget or estimate is automatically assigned to the new project and given the same name as that of the new project.
To clone a project record, watch this video or follow these steps:
- Open the Projects screen from the side menu > Projects.
- In the list view, select a project on the grid that you want to clone and click to select Clone.
- On the Project Clone dialog, select the Project Type: Parent or Phased. Check Field Descriptions above for details.
- Enter the required information. Check Field Descriptions above for details.
- Project ID/Phase ID (if you have set up auto-increment for project IDs, then this is pre-filled based on that)
- Project Name/Phase Name
- Client: You can select multiple clients when cloning a project.
- Select attributes of the existing project that you want to copy to the new project such as project rules, groups, classes, memos, custom fields, project monitoring, etc.
- Click Clone.
The new, cloned project displays in the grid. Start date of the cloned project is always the current date by default. You can also check the detailed video on cloning records in CORE.
Merge Projects
In certain situations, you might want to combine multiple projects into a single project. Sometimes, two people may have created the same project and later realized the mistake. Or you might have similar projects in different locations and at some point want to combine them into one. CORE allows you to do that by moving all the time and expenses, invoices, payments, accounts, and any transactions linked with the project to the destination project. Attachments, notes or any other data linked with the source project are moved to the destination project. This merge feature also handles joint invoices.
Example: When you merge two projects (say P1 with a bill value of $100 and P2 with a bill value of $200) having a joint invoice associated with them (Invoice # 1001 = $300), a merged project is created (P1), while separating the joint invoice into two invoices (Invoice # 1001 = $100 and Invoice # 1001-2 = $200).
Note: You cannot merge projects that are included in split billing.
To merge projects, watch this video or follow these steps:
- Open the Projects screen from the side menu > Projects.
- Select the project on the grid that you want to merge with another and click on that row to select Merge. You can also access it via the Actions menu.
- On the Merge Projects dialog, choose whether you want to merge the selected projects into an existing project or a new project.
- If you select Existing Project, choose a project from the drop-down into which you want to merge the selected projects. The destination project will have its settings retained, such as project manager and contract type.
- If you select New Project, select the Project Type:
- Parent Project
- Phased Project
- Enter the required information:
- Project ID/Phase ID
- Project Name/Phase Name
- Client
- Manager
- Click Merge. Confirm this action and click Submit.
The merged project displays on the grid. You can also check the detailed video on merging data in CORE.
Batch Update Projects
You can update projects individually or in a batch. Making batch changes to the project records is a non-reversible process. When you update parent projects for settings such as status, contract amount, fee schedule, manager, taxes, etc., CORE prompts you to implement the changes to their phases as well. Batch update also allows you to reset the values to none if the field is not required.
To batch change any project information, watch this video or follow these steps:
- Open the Projects screen from the side menu > Projects.
- Select the project records on the grid that you want to delete and click Actions > Delete to delete them. In case of phased projects, CORE deletes the phases first and then the parent projects. You cannot delete projects that are in use; if no longer needed, make them inactive instead.
- Otherwise, click Actions > Batch Update to make batch changes to the selected projects. Using the menu, you can select the total number of records without scrolling all the way to the end of the list, total number of records in view or none of the records.
- On the Batch Update screen, select the relevant fields and enter new values for them.
Note: If needed. enter a similar memo for multiple projects in one go. You are given an option to either add the new memo to the start of the existing memo (Append Top), end of the existing memo (Append Bottom) or just replace the existing memo (Overwrite). - Check the disclaimer at the bottom and click Update.
- To edit a single project, click on a row and select View Details.
- In the detail view, enter more details or make your changes.
- Click Save.
You can also check the detailed video on batch updating records in CORE.
Limitations of Batch Update: There are certain limitations to batch updating field values. For example:
- Batch updating the accounts here does not update the existing transactions of projects. It affects only the new ones.
- Batch updating the Class field here does not update accounting with the new values.
- You cannot associate a new client to project phases; you can change the client for the top-level parent project.
Specify Online Payments
CORE allows your clients to pay their invoices electronically using the ePayments method from anywhere in the world. You get to choose whether to enable ePayments at the global level for all clients (Settings) or selectively enable that at the client, project and invoice level. Check out ePayments for details.
To specify or change the online payment account for a project:
- Open the Projects screen from the side menu > Projects.
- In the list view, select the projects on the grid whose payment option you want to change.
- Click Actions > Online Payments.
- On the Change Online Payment Account dialog, select the Account that you want to associate with the selected projects for the online payments. You can also remove any associated accounts by selecting None from the drop-down.
- Click Update.
- Alternatively, select a project on the grid for whom you want to enable ePayments and click to select View Details.
- On the Settings > Billing Options tab, select the Online Payment Account from the drop-down and click Save & Done. Check Field Descriptions above for details.
Show/Hide Columns in Grid
You can configure the fields or columns that appear on the grid in the list view. You can hide or show columns, and sort the order of columns according to your requirements.
To do so, watch this video or follow these steps:
- Open the Projects screen from the side menu > Projects.
- In the list view, click More > Show/Hide Columns on the action bar.
- Select or un-select the column names in the drop-down list, say Start Date.
- Next, click the column name you want to sort the data by, say Client.
- Click once for ascending order (A-Z) and twice for descending order (Z-A).
Note: You can resize the column widths on the grid and then reset them, if needed (More > Reset Column Widths).
You can also check the detailed video on navigation and customizing grids in CORE.
Expand/Collapse Hierarchy
CORE allows you to indicate if you want to see the project list view expanded to reveal the hierarchical phases of the parent projects or as collapsed. This preference is remembered for the logged in user.
To expand or collapse the project hierarchy:
- Open the Projects screen from the side menu > Projects.
- In the list view, click More > Expand Hierarchy or Collapse Hierarchy, as needed.
The list view grid will display the projects and their phases accordingly.
Export Projects
In CORE, you can export projects to the Comma Separated Values file format. CORE exports data from all available columns and not just the columns visible in the grid.
To export the project records to a .CSV file, watch this video or follow these steps:
- Open the Projects screen from the side menu > Projects.
- In the list view, click More > Export as CSV.
- A .csv export file is created and saved on your system at the default download location, say your desktop. Click to open the spreadsheet.
You can also check the detailed video on exporting data in CORE.
Import Projects as CSV
In CORE, you can import up to 5000 projects directly from a Comma Separated Values (.csv) file format. CORE does not create new items or resources if there are no matches. You can map the relevant fields between CORE and the CSV file and save those mappings for the future.
Note: You can download a sample import file to see how your import file should be and what kind of data it should include.
To import projects from a .CSV file:
- Open the Projects screen from the side menu > Projects.
- In the list view, click More > Import from CSV.
- On the Import Projects from CSV dialog, choose the CSV file to be imported. Check Field Descriptions above for details.
- You can drag and drop the file or click to browse to its location. Click Upload.
- On the Map Your Project Fields dialog, you can match the relevant CORE Fields with CSV Headers for each project. Each record requires a project name, project ID, client, manager, and contract amount to be mapped.
- You can select Saved Mappings from the drop-down if you have one from a previous import.
- Click Continue. The imported records pre-fill the grid.
- On the Review Mapping dialog, review the selected records and their mappings. Un-check the records that you do not want to import. CORE performs validation of records, including formatting and data validation before you can proceed.
- Click the relevant Import option:
- Import
- Import & Save As New Mapping: Imports the entries and also saves the mapping for the future.
- Import and Update Mapping: Updates the saved mapping. This option is only visible if you have saved mapping from the previous import.
The projects are imported. You can check the imported data and make changes, as needed. Note that when creating new projects from a CSV import, the project status defaults to Draft unless you specify a different status during the process. You can also check the detailed video on importing data into CORE.
View Reports
To view a report:
- Open the Projects screen from the side menu > Projects.
- In the list view, click More > View Reports.
- Select a report from the Report List dialog. It opens in the viewer.
- Preview the report and then choose to export or print it.
You can also check the detailed video on running and managing reports in CORE.
Manage Project Templates
You can view and manage all your available project templates from a single screen in CORE.
To manage your project templates, watch this video or follow these steps:
- Open the Projects screen from the side menu > Projects.
- In the list view, click More > Project Templates on the action bar. Alternatively, you can go to Settings > Projects > Project Templates.
- On the Project Templates screen, you can view all the templates and take the relevant action. You can select various attributes of the existing project that you want to copy to the new project such as project rules, groups, classes, memos, custom fields, project monitoring, etc. Check Project Templates for details.
Apply Filters
When using the filter search or applying filters, CORE intelligently updates the info bars to reflect the values of the filtered list. Besides filtering data using the standard fields on a screen, you can also use the custom fields for that, if you have set them up. If you use a different combination of filters for different scenarios, CORE allows you to save these filter combinations as your favorite. You can use and reapply these saved filters anytime, without having to remember the combinations.
To view selective data on the grid, watch this video or follow these steps:
- Open the Projects screen from the side menu > Projects.
- In the list view, click on the right.
- On the Filters panel, select a filter from the drop-down and specify individual records or range.
- Click Add Filters to specify more filters.
- When you have finished, click Apply Filter. You can see selective data now.
- Next, to save the applied filters as your favorite, click Save Filters.
- It opens the Save Filter dialog, where you can select a name for your filter combination and then click Save.
- In the list view, you can remove the individual filters by clicking on each. To use your favorite filter or disable applied filters temporarily or remove all filters, click next to the Filters icon and select Disable Filters or Clear All, respectively.
You can also check the detailed video on applying filters in CORE.
Mark Screen as Favorite
You can mark or flag the most-often used and important screens in CORE as your favorites up to a maximum of ten. These favorite screens then display separately on the side menu under the Favorites list. You can manage all your favorite screens in CORE from User Settings.
To mark this screen as your favorite, watch this video or follow these steps:
- Open the Projects screen from the side menu > Projects.
- In the list view, click on the top-right.
- You can access this screen from the side menu under Favorites.
You can also check the detailed video on marking screens as favorite in CORE.