Events
Mar 31, 11 PM - Apr 2, 11 PM
The ultimate Microsoft Fabric, Power BI, SQL, and AI community-led event. March 31 to April 2, 2025.
Register todayThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
The project management and accounting functionality can be used in multiple industries to provide a service, produce a product, or achieve a result.
A project is a group of activities that is designed to provide a service, produce a product, or achieve a result. Projects consume resources and generate financial results in the form of revenues or assets.
The project management and accounting functionality can be used in multiple industries, as shown in the following illustration.
In a call center, a ticket can be used to describe the set of actions that are required to resolve a call. Consulting companies, such as management or technical consulting organizations or advertising agencies, refer to their activities as projects. In marketing, a campaign represents a set of work that must be delivered. In project-based manufacturing, a production order relates the various work that must be done to produce some finished goods. Whatever name is used for them, these projects involve resources, schedules, and costs, and the project management and accounting functionality can help with the planning, execution, and analysis of these projects.
Although the following process flow is aimed toward external projects, or project that are completed for one or more customers, the functionality also applies to internal, cost-only projects.
As shown in the preceding illustration, project management and accounting can be divided into three phases:
During project initiation, several key processes occur. You can use a project quotation to communicate the estimated labor, expenses, and materials to the customer. You can record the billing terms, limits, and agreements in a project contract. You can use a work breakdown structure (WBS) to plan and estimate the work. You can set up forecasts and budgets to guide the project execution. The following illustration shows the structure of a project.
In the initial sales phase of a project, a project quotation lets you provide a customer with a non-binding offer. A quotation can include elements such as the items and services that are quoted, basic contact information, special trade agreements and discounts, and possible taxes and surcharges.
You can also issue a letter of guarantee for a project quotation transaction between your organization and the customer. After the project quotation is created, you can create the letter of guarantees request for the customer and submit it to the bank. After the bank has approved the request, the letter of guarantee is issued to the customer.
For more information, see Project quotations.
When you enter into a contract with a customer or other funding source to complete a project, you must first create a project contract. Then, when you create the project, you must assign it to the corresponding contract. The type of project that you create for a project contract determines the method that is used to invoice the project customers. You can modify a project contract and the related project, but you can’t change the project type. For more information about project types, see the "Creating projects" section.
For more information about project contracts, see Project contracts.
The degree of detail in a WBS depends on the level of accuracy that is required in estimates and the level of tracking that is required against those estimates. Projects that have very low tolerance for slippages in schedule or cost usually require a more detailed WBS, and also require diligent tracking of work progress and cost against the WBS.
For more information, see Work breakdown structures overview.
You can use forecasting if your organization has an operational perspective and focuses on the revenues and costs that are derived from specific transactions. However, if your organization focuses more on financial amounts, you can use budgeting. Each method has its advantages. For more information, see Project forecasts and budgets.
You can create six types of projects in Finance. Each project type is set up differently for costs and revenue recognition. The project type that you choose depends on the purpose of the project. The following table describes the typical use of each project type.
Project type | Description |
Time and material | In Time and material projects, the customer is billed for all costs that are incurred on a project. These costs include costs for hours, expenses, items, and fees. |
Fixed-price | In Fixed-price projects, the invoices consist of on-account transactions. A Fixed-price project is invoiced according to a billing schedule that is based on a project contract. Revenue for a Fixed-price project can be calculated and posted throughout the project by using the completed percentage method. Alternatively, revenue can be calculated and posted when the project is completed, by using the completed contract method. Companies can often benefit from using the value of the work in process (WIP) to calculate the degree of completion of a project or group of projects. |
Investment | Investment projects are projects that don't produce immediate earnings. They are typically used for long-term internal projects where the costs must be capitalized. Only costs for items, hours, and expenses can be recorded for an Investment project. Costs in an Investment project are tracked and controlled by using estimate functionality. Investment projects can be set up with an optional maximum capitalization. As an Investment project progresses, you record its costs in WIP accounts, where the costs are held until the project is completed. When the project is eliminated, you transfer the WIP value to a fixed asset, a ledger account, or a new project. NOTE: Transactions on Investment projects aren't shown on the Post costs, Accrue revenue, or Create invoice proposals page. |
Cost project | Like Investment projects, Cost projects are typically used to track internal projects, and only hours, expenses, and items can be recorded for them. However, Cost projects are usually of shorter duration than Investment projects. Additionally, unlike Investment projects, Cost projects can’t be capitalized to balance sheet accounts. Instead, their project transactions are posted only to profit and loss accounts. NOTE: Transactions on Cost projects aren't reflected on the Post costs, Accrue revenue, or Create invoice proposals page. Because cost projects are typically used to track internal projects, they don't usually have to be associated with a customer account. However, if your setup requires that item requirements be created for purchase orders, you must associate the Cost project with a customer. This association is required, because item requirements are managed as sales order lines, and the system requires that a customer be specified. However, this setup won't cause item requirements to be created automatically from a purchase order. For Cost projects, the Create item requirement setting is ignored. If you need an item requirement in a Cost project, you can create it manually, provided that a customer is associated with the project. |
Internal | Internal projects are used to track costs on a project that is internal to your organization. Internal projects can provide a planning tool to manage resource consumption. NOTE: Transactions on internal projects aren't reflected on the Accrue revenue or Create invoice proposals page. |
Time | Time projects are used to track time that is associated with non-chargeable and non-productive activities, such as a project to track sick time for workers. Transactions in Time projects aren't posted to the ledger. Instead, they are included in worker utilization reports. Only hour transactions can be recorded in Time projects. You use an hour journal or timesheet to register these hours to the project. After the hours are registered, they appear as project transactions but don't have corresponding voucher transactions. NOTE: Transactions on Time projects aren't reflected on the Post costs, Accrue revenue, or Create invoice proposals page. |
You can schedule worker resources based either on the requirements and schedule of a project, or on the skills and availability of workers. By using the resource scheduling capabilities, you can deploy your organization’s workers efficiently and effectively. You can quickly find the most qualified workers who are available to work on your project. You can also easily see how those workers might be used more effectively during the course of the project.
Here are some of the ways that you can use the resource scheduling functionality:
During project execution, team members or managers record work and the expenses that are incurred, by using timesheets, expense reports, and other business documents. Project managers have tools that let them monitor the consumption of budgeted amounts for the project. Project managers can also order, pick, or procure materials for projects by using purchase orders and other business documents. Invoices are prepared and approved, so that customers can be billed for ongoing work. Finally, revenue is recognized during this process to affect the organization's financials.
A WBS is a description of the work that will be completed for a project. A WBS is a hierarchy of tasks. It represents not only the work for each task, but also the size, cost, and duration of the task.
For more information, see Work breakdown structures overview.
There are two ways to manage and control your projects: project forecasts and project budgets. You can use forecasting if your organization has an operational perspective and focuses on the revenues and costs that are derived from specific transactions. However, if your organization focuses more on financial amounts, you can use budgeting.
For more information, see Project forecasts and budgets.
A project-related production order can be linked to a sales order or an item requirement by using either the finished item method or the consumed item method. Additionally, if the production order was created manually, there is no link between the production order and the sales order or item requirement (no link to order). However, if the production order was created automatically to fulfill a sales order or an item requirement, there is a link between the production order and sales order or item requirement (link to order).
Based on the combinations of these factors, use one of the following methods:
The purchase and sale of items are prevalent activities in many project-focused businesses.
The purpose of the purchase order determines when the purchase order is consumed and, therefore, when items are charged on a project.
Method | Purpose | Consumption of items |
---|---|---|
Create a purchase order directly. | Purchase items from an external vendor for consumption on a project. You can create the purchase order in the following ways:
|
Items are consumed when the vendor invoice is updated. |
Create a purchase order from a sales order. | Purchase items when you create a sales order from a project. | Items are consumed when the sales order is invoiced to the customer. |
Create a purchase order from an item requirement. | Purchase items when you create an item requirement from a project. | Items are consumed when the item requirement packing slip is updated. |
In Project management and accounting, you can register the consumption of items in several ways. You can sell items or purchase items from a project, or reserve items for a project.
You can order items from the company’s inventory for consumption on a project. Alternatively, or you can purchase items from an external vendor. Items can be consumed on all types of projects except Time projects.
The way that you order items depends on where you're ordering them from:
Note
The packing slip for a project-related sales order can’t be canceled if the items have already been marked for packing.
The following table lists the methods for ordering items and describes how the items are consumed.
Method | Purpose | Consumption of item transactions |
---|---|---|
Sales order | Enter a transaction directly on a Time and material project. | Item transactions are consumed when the customer invoice is posted. |
Inventory journal | Quickly enter and maintain item records. If, for example, you want to enter an item requirement based on a printed list, the inventory journal can be applied. | Item transactions are consumed when the journal is posted. |
Item requirement | Enter items that won't be consumed immediately. This method lets you track the number of items that have been consumed in a single item requirement record. | Item transactions are consumed when the packing slip is updated. In other words, the item requirement is created when the packing slip is posted. |
Purchase orders | Enter transactions in one of three locations, depending on the purchasing method. | Item transactions are consumed when the packing slip is updated, or when the customer or vendor is invoiced. |
The project type determines which invoicing procedure should be applied. Only the two external project types (Time and material and Fixed-price) can be invoiced. Time and material projects and Fixed-price projects are always attached to a project contract.
Before you create a customer invoice for a project, you can create a preliminary invoice, or invoice proposal. In an invoice proposal, you can select project transactions to include in a project invoice. You can then review the invoice details before you post the project invoice and send it to the customer or other funding source.
For more information about how to process project invoices, see Project invoicing.
When you create an estimate, you can choose the method that is used to calculate the cost to complete the project. You select a method in the Cost to complete method field on the Create estimate page. The method that you choose is applied separately to each cost line in the cost estimate. While a line has a status of Created, you can change the method that is applied to it on the Cost estimate page.
The following table describes the methods for calculating the cost to complete a project.
Method | Description |
---|---|
Total cost – actual | Estimated costs must be entered manually. After the Total cost or Total quantity column on the Cost estimate page is completed, the actual costs are subtracted from the user-entered totals. The result is the cost to complete the project. Typically, the progress of costs isn't tracked based on, for example, the number of hotel stays and meals that are recorded in each period. Instead. Tracking is usually based on a comparison against the total amount of estimated hours. This approach doesn't require a forecast model, and the total cost or total quantity can be changed manually. When a value is entered in the Total cost or Total quantity column, Finance compares this value against the actual transactions that are posted in the period, and then decreases the value in the Quantity to complete or Cost to complete column. |
Total budget – actual | Actual costs are compared against the forecast model that you select to determine the cost. This method uses a total budget model that includes forecasted transactions. To obtain a more accurate view of the project, you can adjust the budget model when the project is in progress. If you must adjust the forecast, follow this general process:
NOTE: When you select this method, use at least two forecast models. One model should contain the original forecast. For the other model, you should copy forecast transactions from another model. This method is valid only for Fixed-prices and Investment projects. |
Remaining budget | This method uses a remaining budget model to calculate the cost to complete the project. When you use this method, the actual costs and the forecasted amounts in the remaining budget model are added together. The result is a total cost. Before you use this method, a remaining budget model must be set up to deduct transactions based on actual transactions that are recorded in the system. On the Forecast models page, make sure that the fields are marked in the Automatic forecast reduction group. Typically, a remaining budget is copied from an original budget. As transactions are entered, the transactions on the remaining budget are decreased. As the project progresses, if you determine that the remaining budget must be adjusted, you charge forecast transactions to the remaining budget. NOTE: This method can be applied only if a forecast model is attached to the estimate. |
As previous estimate | The same estimate method that was used in the previous period is applied. This method requires a forecast model if the previous period required a forecast model. |
Set cost to complete to zero | Typically, this method is used before the estimate project is eliminated. This method matches the total estimates with the actual transactions that were posted and clears the Cost to complete column. The resulting percentage of completion is always 100 percent. The Forecasting field is not selected for each cost line that you create, and the total estimate is copied from the previous cost estimate. The actual consumption for the estimate period is deducted from the cost to complete the project. This method doesn't require a forecast model. |
From cost template | The cost to complete method that is set up in the cost template that is associated with the selected estimate project is applied. |
At its most basic level, a project is used to group transactions that record costs, and then post these costs to the general ledger.
Generally, these transactions are the result of business documents, such as timesheets, expense reports, vendor invoices, or inventory transactions. The life cycle of a project usually starts with estimates, forecasts, and budgets that help plan and anticipate the work and financial impact of the project. As you analyze a project, you can evaluate not only the transactions that occurred during the project, but also the accuracy of your estimates and forecasts, the utilization rates of the project team members, and the overall success of the project.
Use cash flow monitoring to review both the forecasted cash flows and the actual cash flows for a project. You can review cash flows while a project is in progress, or you can view the cash flows of a completed project.
By monitoring cash flows, you can evaluate a single project, use the reports to view multiple projects, and transfer project cash flows to the cash flow forecasts in the general ledger.
Based on your setup, you can forecast the cash inflows for a selected project. For example, if the project date is March 5, 2012, and you invoice on March 31, 2012, here is how you can forecast the due date and the expected sales payment date:
The general buffer days can either replace the individual buffer days or be added to the individual buffer days:
Set up individual buffer days in the project’s contract. The days are calculated based on both the sales invoice due date and your organization’s experience with a customer's payment pattern.
Actual cash inflow resembles forecasting, but you can begin your calculations from the first invoice date. Here is an example:
Based on the days that are defined, the cost payment date can differ from the project date. In this case, the cost payment date is calculated by adding the number of days from the project date to the number of days in the terms of payment.
For example, the project date of the transaction is March 5, 2012, and the following terms of payment are set:
Based on these settings, here is the cost payment date for each transaction type:
Note
The due date for the purchase order is based on the vendor transaction when the project purchase order is created. The due date isn't determined by any default settings.
The cost payment date isn't calculated on buffer days. After a project is completed, when all costing and invoicing is completed, both the cost and the sales are posted to the profit and loss accounts.
When all sales and vendor invoices are completed, you can view the relationship between fields on the Cash flow page and fields on the Project statements page.
You can monitor the costs that your organization incurs during a project on the Cost control page. By comparing the original budgeted costs for the project with the current actual costs and the committed costs, you can determine whether the project is on track, over budget, or under budget.
Note
When you use the Cost control page to view the current status of project costs, use the forecast models that were selected for the original and remaining budget. If you select other forecast models when you calculate costs, the calculation results will not be accurate.
If Remaining budget is selected as the cost control method on the Project management and accounting parameters page, the Cost control page calculates costs that haven't been posted as actual or marked as committed. Specifically, the amounts on the General tab in the lower pane of the Cost control page are calculated in the following ways:
On the Cost control page, on the Deviation tab, you can view a comparison of the total expected cost with the original budget. This comparison shows any differences between these amounts. Therefore, you can see where the data doesn't match. The deviation amounts are calculated in the following ways:
If Total budget is selected as the cost control method on the Project management and accounting parameters page, the Cost control page calculates the actual costs and the total costs of the project to help you detect any difference between the two. Specifically, on the Cost control page, the amounts in the columns in the lower pane on the General tab are calculated in the following ways:
On the Cost control page, on the Deviation tab, you can view the difference between the total budget and the original budget by looking at to the following fields:
The utilization rate is the percentage of time that a worker performs billable or productive work in a specific working period. Billable hours are the worker’s hours that can be charged to a specific customer.
A worker’s utilization rate is calculated by dividing the number of billable hours by the number of working hours in a specific period. For example, if a worker has 30 billable hours in a period, and the number of working hours in the same period is 40, the worker’s utilization rate is 75 percent.
When you calculate the utilization rate for a worker, you can calculate either the billable rate or the efficiency rate:
You calculate the utilization rates on the Hour utilization page. The calculations are based on default preferences. These preferences also specify how hours are calculated by assigning Utilization or Burden to each project type. This applies to billable rate calculations and efficiency rate calculations.
On the Hour utilization page, besides the overall utilization rate percentage for a worker or a project, you can view the number of hours that were used for the utilization rate calculations for each of the following hour types:
When you calculate the utilization rate for a worker, you can use norm hours or included hours. If you use included hours, you must ensure that workers record all their working time for the timesheet periods, because the calculation is expressed as a percentage of hours that are entered. When you calculate the hour utilization rate for a project, project contract, customer record, or category, you must use included hours for your calculation.
You can create a project statement to view a quick snapshot of the progress of a project. When you run a project statement, you can specify the criteria that are used to calculate the statement by making selections on the General tab on the Project statements page. You can select to include or exclude the following information:
After the statement is calculated, you can view the following information on the various tabs on the Project statements page:
Events
Mar 31, 11 PM - Apr 2, 11 PM
The ultimate Microsoft Fabric, Power BI, SQL, and AI community-led event. March 31 to April 2, 2025.
Register today