Construction Reports: Time and Material Amounts in AIA Reports

In the construction industry, billing is typically based on the percentage of work completed during the billing period. However, project manager[1]janice.paganiniinsert2025/02/1411:49:39-05:00s may decide to prepare the [2]janice.paganiniinsert2025/02/1413:12:48-05:00[3]janice.paganiniBy the way, I added this to other topics in the ditamap that were not spelling it out anywhere in the topic (per our abbreviation guidelines).2025/02/1413:14:55-05:00American Institute of Architects (AIA[4]janice.paganiniinsert2025/02/1413:12:51-05:00) report[5]janice.paganiniinsert2025/02/1413:12:54-05:00s based on the [6]janice.paganiniIs there a different way we typically say this, such as "project transactions based on costs"? I found only two uses of the phrase in the entire doc.2025/02/1412:18:15-05:00cost project transactions. The following sections describe the process for including time and material lines in AIA reports and the recommended project settings.

Project Configuration

Before creating AIA reports based on time and material lines, you need to ensure that the following project settings are configured[7]janice.paganiniconfigured2025/02/1412:43:43-05:00[8]janice.paganiniinsert2025/02/1412:43:43-05:00specified on the Projects (PM301000) form:

  • On the Tasks tab, a combined billing rule is assigned to [9]janice.paganiniinsert2025/02/1412:43:54-05:00the needed project tasks. The billing rule should include a progress billing step along with the time and material billing steps for all needed account groups. For more information, see Billing Rules: General Information.
  • On the Revenue Budget tab, each progress billing line to which you plan to include time and material amounts should has[10]janice.paganinihas2025/02/1412:44:29-05:00[11]janice.paganiniinsert2025/02/1412:44:29-05:00have Amount specified in the Progress Billing Basis column.
  • On the Cost Budget tab, each cost budget line that you plan to include in [12]janice.paganiniinsert2025/02/1412:44:38-05:00an AIA report is associated with a revenue budget line. That is, the task of the Cost and Revenue Task type or Revenue Task type is specified in the Revenue Task column of the line.

AIA Reports with Time and Material Amounts

To prepare [13]janice.paganiniinsert2025/02/1413:15:42-05:00an AIA report with time and material amounts[14]janice.paganiniinsert2025/02/1413:16:07-05:00 for a project, you perform the following general steps:

  1. On the Projects (PM301000) form or Run Project Billing (PM503000) form, you run project billing for a[15]janice.paganinia2025/02/1413:16:15-05:00[16]janice.paganiniinsert2025/02/1413:16:15-05:00the project to prepare a pro forma invoice.
  2. In the prepared pro forma invoice on the Pro Forma Invoices (PM307000) form, on the Time and Material tab, you make sure that each line that you need to add to [17]janice.paganiniinsert2025/02/1413:16:29-05:00the AIA report has the[18]janice.paganinithe2025/02/1413:16:33-05:00[19]janice.paganiniinsert2025/02/1413:16:33-05:00a revenue task specified in the Revenue Task column. In the lines with empty[20]janice.paganiniempty2025/02/1413:16:47-05:00[21]janice.paganiniinsert2025/02/1413:16:47-05:00no revenue task[22]janice.paganiniinsert2025/02/1413:16:54-05:00 specifieds[23]janice.paganinis2025/02/1413:16:54-05:00, you either specify them manually or click Update Empty Revenue Tasks on the More menu to initiate [24]janice.paganiniSee mass processing in the UD for the pattern. We would say "mass-assign" as the compounf verb but "mass assignment" as the noun phrase (it's just "mass" modifying "assignment").2025/02/1413:19:26-05:00mass[25]janice.paganiniinsert2025/02/1413:17:17-05:00 -[26]janice.paganini-2025/02/1413:17:20-05:00assignment of the applicable tasks in the column.
  3. On table toolbar of the Progress Billing tab, you add [27]janice.paganiniinsert2025/02/1413:20:09-05:00the needed progress billing lines, if the lines were not added automatically during the billing procedure.

    As an alternative to manually entering progress billing lines, you can load all applicable lines automatically by clicking Load Lines on the table toolbar of the Progress Billing tab. The system loads the lines from the[28]janice.paganiniinsert2025/02/1413:22:37-05:00 project’s revenue budget of the project[29]janice.paganini of the project2025/02/1413:22:42-05:00 in[30]janice.paganiniin2025/02/1413:22:29-05:00[31]janice.paganiniinsert2025/02/1413:22:29-05:00for which an active or completed project task of the <i>Revenue Task</i> or <i>Cost and Revenue Task</i> type is specified and the billing rule assigned to the project task includes the progress billing step. [32]janice.paganinian active or completed project task of the <i>Rev.. 2025/02/1413:21:21-05:00[33]janice.paganiniinsert2025/02/1413:21:31-05:00the following conditions are met:[34]janice.paganinisplit2025/02/1413:21:11-05:00

    [35]janice.paganiniinsert2025/02/1413:21:44-05:00
    • An active or completed project task of the Revenue Task or Cost and Revenue Task type is specified.
    • The billing rule assigned to the project task includes the progress billing step.
    [36]janice.paganinisplit2025/02/1413:21:11-05:00

    If a line with the particular project budget key already exists in the pro forma invoice, the system will skip adding it.

  4. On the Time and Material tab, you transfer the time and material amounts to the respective progress billing lines by doing either of the following:
    • Selecting the Include in Progress Billing check box for the particular lines to be included in progress billing [37]janice.paganiniWith this usage (unlike, say, when it's at the beginning of a sentence or after a semicolon and used to mean "therefore"), "thus" does not need to be set off by commas.2025/02/1414:04:13-05:00and,[38]janice.paganini,2025/02/1414:02:49-05:00 thus,[39]janice.paganini,2025/02/1414:02:51-05:00 in the AIA report
    • Clicking the Include in Progress Billing button on the table toolbar to include all lines in progress billing and in the AIA report

    The amount of each time and material line that you has[40]janice.paganinihas2025/02/1414:14:04-05:00[41]janice.paganiniinsert2025/02/1414:14:04-05:00have included in progress billing is added to the Time and Material Amount column of the respective line on the Progress Billing tab. On the Time and Material tab, the Amount to Invoice in the line becomes zero[42]janice.paganinizero2025/02/1414:22:44-05:00[43]janice.paganiniinsert2025/02/1414:22:47-05:000.

    Tip: To remove previously added time and material lines from the AIA report, you either clear the Include in Progress Billing check box for particular lines or click the Remove from Progress Billing button on the table toolbar of the Time and Material tab. The system will move the [44]janice.paganiniThis turn of phrase is odd, and in this sentence, it makes it sound like it's moving the amounts to an invoice. Do we mean "amounts to be billed"? We don't use "invoice" as a verb so if this is the intended meaning, the word won't work here.2025/02/1414:24:54-05:00amounts to [45]janice.paganiniinsert2025/02/1414:30:37-05:00be billedinvoice[46]janice.paganiniinvoice2025/02/1414:30:36-05:00 back to the lines of the Time and Material tab.
  5. You click AIA Report on the form toolbar to prepare the AIA report for the pro forma invoice. The resulting report includes the amounts of the time and material lines that you have included in progress billing.

Limitations

The following limitations currently apply to the functionality:

  • Time and material lines cannot be included to[47]janice.paganinito2025/02/1414:42:40-05:00[48]janice.paganiniinsert2025/02/1414:42:40-05:00in the progress billing lines that are billed by quantity.
  • Time and material lines with the Hold Remainder or Write Off status cannot be included to[49]janice.paganinito2025/02/1414:42:58-05:00[50]janice.paganiniinsert2025/02/1414:42:58-05:00in the progress billing.
  • Time and material lines with negative amounts cannot be included to[51]janice.paganinito2025/02/1414:43:04-05:00[52]janice.paganiniinsert2025/02/1414:43:04-05:00in the progress billing.
  • Time and material lines that are based on project transactions that are subject to reversal by any allocation rule cannot be included to[53]janice.paganinito2025/02/1414:43:17-05:00[54]janice.paganiniinsert2025/02/1414:43:17-05:00in the progress billing.