{"id":864,"date":"2023-08-31T10:10:35","date_gmt":"2023-08-31T10:10:35","guid":{"rendered":"https:\/\/www.projectpro365.com\/user-guide\/?p=864"},"modified":"2025-04-14T07:58:18","modified_gmt":"2025-04-14T07:58:18","slug":"time-and-material","status":"publish","type":"post","link":"https:\/\/www.projectpro365.com\/user-guide\/standard\/projectpro-basic\/time-and-material\/","title":{"rendered":"Ch 10 – Time and Material"},"content":{"rendered":"

Contents<\/b><\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
TIME AND MATERIAL<\/a><\/td>\n<\/tr>\n
1. Defining the Project<\/a><\/td>\n<\/tr>\n
2. Defining the Project Task Lines<\/a><\/td>\n<\/tr>\n
3. Defining Prices<\/a><\/td>\n<\/tr>\n
a) Project Cost Category Prices<\/a><\/td>\n<\/tr>\n
b) Project Resource Cost\/Prices<\/a><\/td>\n<\/tr>\n
c) Project G\/L Account Cost\/Prices<\/a><\/td>\n<\/tr>\n
4. Creating Purchase Order<\/a><\/td>\n<\/tr>\n
5. Posting Labor to Project Journal<\/a><\/td>\n<\/tr>\n
a) Manual Entries<\/a><\/td>\n<\/tr>\n
b) Time Sheet Entries<\/a><\/td>\n<\/tr>\n
6. Creating Sales Invoice<\/a><\/td>\n<\/tr>\n
7. Additional Time & Material Project Methods<\/a><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

TIME AND MATERIAL<\/b><\/p>\n

Time and Material (T&M) are a contract in which the project owner agrees to pay the contractor based upon the time spent by the contractor’s employees and subcontractors to perform the work, and for materials used in the construction (plus the contractor’s mark up on costs incurred), no matter how much work is required to complete construction. Time and Material is generally used in projects in which it is not possible to accurately estimate the size of the project, or when it is expected that the project requirements would most likely change.\n<\/p>\n

1. Defining the Project<\/b><\/p>\n

Setting up a T&M project is like setting up a fixed price project in ProjectPro. Many of the fields are the same, however, there are some fields that differ.<\/p>\n

When you have a T&M project, a few fields you will need to focus on are:<\/p>\n

    \n
  • Contract Date<\/u> \u2013 Always populate the contract date of the Project.<\/li>\n
  • Contract Type<\/u> \u2013 Choose the contract type as \u201cTime and Material\u201d for a T&M project.<\/li>\n
  • Gen. Business Posting Group<\/u> \u2013 Define the general business posting group to which the postings should be directed to for a particular project. This is particularly important for purchase Type of \u201cG\/L Account\u201d to pass along the \u201cRevenue Account\u201d from the Gen. Business Posting Group<\/li>\n<\/ul>\n

    \"null\"<\/p>\n

    Continue filling in the rest of the Project Info section as you normally would for any project.<\/p>\n

    Next, under the Constants\/Manager fast tab of the project card.<\/p>\n

      \n
    • Status <\/u>\u2013 Status of the project should be set to Open.<\/li>\n
    • Time and Material<\/u> \u2013 Time and material option should be toggled \u201cON\u201d.<\/li>\n<\/ul>\n

      Once you select \u201cTime and Material\u201d, ProjectPro will automatically turn on \u201cAllow Budget\/Billable Lines\u201d \u201cApply Usage link\u201d and set the Line Type to \u201cBoth Budget and Billable\u201d. This will create the \u201cProject Planning Lines\u201d for both the Budgets and Billable with the \u201cBudgeted Costs\u201d matching each \u201cActual Project Cost\u201d entry. And the \u201cBillable\u201d values will be created as well for future project sales invoicing.<\/p>\n

      \"null\"<\/p>\n

      2. Defining the Project Task Lines<\/b><\/p>\n

      Once you have completed the Project Card setup, make sure to add the Project Task Lines that will be used on this project. If you have assigned default Project Tasks, you will see they have automatically populated with the new Project Card creation.<\/p>\n

      \"null\"<\/p>\n

      \"null\"<\/p>\n

      3. Defining Prices<\/b><\/p>\n

      To define the markup to be used or the fixed cost\/price to use when posting transactions, we use the Prices option from the project card ribbon.<\/p>\n

      \"null\"<\/p>\n

      Depending on your business process, you may choose to assign a markup based on cost categories, or Resources\/Items. If using special labor rates, then select \u201cResources\u201d and add \u201cResource Group\u201d with rates per hour.<\/p>\n

      Note<\/u><\/i>: Usually a company will use \u201cResource\u201d for Labor and use \u201cCost Category\u201d markup % for Materials, Subcontractors, Equipment and Others.<\/i><\/p>\n

      a) Project Cost Category Prices<\/b><\/p>\n

      To use markups by Cost Categories, select the Cost Category option from the Prices & Discounts section.<\/p>\n

      From here, you will select each of the cost categories you will be utilizing on the project and assign the appropriate markup for each. As an example, below, there are several different categories with markups assigned for each.<\/p>\n

      \"null\"<\/p>\n

      Once completed, any cost postings to those cost categories will automatically result in a billable line reflecting the corresponding markup.<\/p>\n

      If you are using the Resources\/Items option, you will set each up separately.<\/p>\n

      b) Project Resource Cost\/Prices<\/b><\/p>\n

      To set up your resources, select the Resources<\/b> option from the Prices & Discounts section. Since it is uncommon to know the exact resources of who will be working on the project at the time of set up, it is a good practice to set up your resource cost and markup using Resource Groups.<\/p>\n

      Note<\/u><\/i>: You will need to ensure each of your resources are assigned to a resource group on the resource card. <\/i><\/p>\n

      On this screen you will set up the following:<\/p>\n

        \n
      1. Project Task No.<\/u> \u2013 Only fill this in if your entries are task no. specific. Otherwise, not necessary.<\/li>\n
      2. Skill Class Code<\/u> \u2013 If applicable<\/li>\n
      3. Code<\/u> \u2013 This is the Resource Group that you are defining.<\/li>\n
      4. Unit of Measure Code<\/u> \u2013 Select the appropriate UOM.<\/li>\n
      5. Work Type Code<\/u> \u2013 Specify if you are charging different rates based on different employee shifts.<\/li>\n
      6. Unit Cost<\/u> \u2013 Enter the cost to be charged for this resource group.<\/li>\n
      7. Markup%<\/u> \u2013 Enter the Markup you are charging for this resource group.<\/li>\n
      8. Unit Price<\/u> \u2013 This will be automatically updated after your cost and mark-up are entered.<\/li>\n
      9. Cost Type<\/u> \u2013 Specifies the cost type as Fixed or % Extra or LCY Extra.<\/li>\n
      10. Line Discount %<\/u> – Define the line discount percentage, if any.<\/li>\n
      11. Description<\/u> \u2013 This is automatically entered based on your Code.<\/li>\n<\/ol>\n

        If you use resource Type \u201cALL\u201d, also populate the \u201cWork Type Code\u201d. Employees belonging to this Work Type Code will use employee default Cost.<\/p>\n

        c) Project G\/L Account Cost\/Prices<\/b><\/p>\n

        To set up Cost\/Price for G\/L Accounts, enter Project Task No., G\/L Account\/s and the Markup %. In the below example, G\/L Account 4020 (Cost of Materials) has a 20% Markup, which when entered it the field got zeroed out and transferred to \u201cUnit Cost Factor\u201d field.<\/p>\n

        \"null\"<\/p>\n

        4. Creating Purchase Order<\/b><\/p>\n

        The next step is to create a Purchase Order using G\/L and Project Cost Category and Post. Make sure you have the Project Price fields showing in the Purchase Order Lines. This reflects the Markups that have been set in the Cost\/Price Tables.<\/p>\n

        Note<\/u><\/i>: Because this is a Time and Material Project, the Line Type will automatically be \u201cBoth Budget and Billable\u201d.<\/i><\/p>\n

        \"null\"<\/p>\n

        After posting the Purchase Order, review the Planning Lines. The Budget and Billable lines have been split to reflect the Costs and Prices of your Purchase Order.<\/p>\n

        \"null\"<\/p>\n

        5. Posting Labor to Project Journal<\/b>
        \na) Manual Entries<\/b><\/p>\n

        For T&M project, the project journal entries must be created with Line Type selected as \u201cBoth Budget and Billable\u201d, as below.<\/p>\n

        \"null\"<\/p>\n

        Once the journal is posted, the entries are updated as the Project Planning Lines on the Project, see below.<\/p>\n

        \"null\"<\/p>\n

        b) Time Sheet Entries<\/b><\/p>\n

        You can also post the labor hours and rates through time sheet functionality:<\/p>\n

          \n
        • Create Multiple Project based time sheets.<\/li>\n
        • Submit the time sheet.<\/li>\n
        • Approval authority can approve the time sheets.<\/li>\n
        • From project journal suggest the time sheets for the given period and project.<\/li>\n
        • Post the Project Journal and revisit the Project planning lines to check the impact.\n

          \"null\"<\/p>\n<\/li>\n

        • Click on the Create Time Sheets<\/b> button from ribbon, to create the time sheet and fill in the relevant details required for filling in the timesheet.\n

          \"null\"<\/p>\n<\/li>\n

        • Select the Starting Date, No. of Weeks and then select the Resource No. filter and the Type of the Resource to generate the time sheet.\n

          \"null\"<\/p>\n<\/li>\n

        • Select the Type as Project, and then click on Activity Details to enter any required information.\n

          \"null\"<\/p>\n<\/li>\n

        • Select Project No, Project Task No, Description and Work Type Code.<\/li>\n
        • Select the Skill Class for time sheet entry.\n

          \"null\"<\/p>\n<\/li>\n

        • Enter respective hours that you want to log in for respective days for a respective resource.<\/li>\n
        • Click on Process \uf0e0<\/span> Submit, to submit your timesheet.<\/li>\n
        • Search for \u201cManager Time Sheets\u201d using search option, to approve the time sheets submitted by the resource. The approval manager can be defined on the resource card.\n

          \"null\"<\/p>\n<\/li>\n

        • Click on Edit Time Sheet<\/b> option from ribbon and edit the time sheet that are pending for approval from Manager Time Sheet. Once the time sheet has been entered, manager can either Approve\/Reject\/Reopen the time sheet.\n

          \"null\"<\/p>\n<\/li>\n

        • All approved time sheets can be suggested while in the project journal for final posting of a project. Search for Project journal or can select the same from Role Center.\n

          \"null\"<\/p>\n<\/li>\n

        • On Project Journals, click on Actions \uf0e0<\/span> Functions \uf0e0<\/span> Suggest Lines from Time Sheets. Using this option, pull in all the approved time sheets to project journal lines.\n

          \"null\"<\/p>\n<\/li>\n

        • Click on OK to populate lines on Project Journal. Check all the journal lines and Post from Post\/Print section from the ribbon.\n

          \"null\"<\/p>\n<\/li>\n

        • Once the Project Journal is posted, check the impact on the related project\u2019s Project Planning Lines.\n

          \"null\"<\/p>\n<\/li>\n<\/ul>\n

          Work Order Report<\/b><\/p>\n

          The main report for T&M project process is the Work Order report, which can be printed from the project card as below.<\/p>\n

          \"null\"<\/p>\n

          \"null\"<\/p>\n

          6. Creating Sales Invoice<\/b><\/p>\n

          Create Sales Invoice from Projects List Page. To review, edit and post, Go to Sales Invoice List Page.<\/p>\n

          \"null\"<\/p>\n

          Note<\/u><\/i>: Always enter Project No. when creating Sales Invoice from the Projects List page, else it will create Sales Invoices for all of your projects.<\/i><\/p>\n

          \"null\"<\/p>\n

          \"null\"<\/p>\n

          7. Additional Time & Material Project Methods<\/b><\/p>\n

          When setting up a T&M Project that has an established \u201cCost Budget\u201d, the Project Planning Lines will be \u201cBudget\u201d only while the Line Type on the Project card will be set to \u201cBillable\u201d to create only the Billable project planning lines for future Project Sales Invoice.<\/p>\n