Project Billing: Progress Billing

For a billing rule defined on the Billing Rules (PM207000) form, you specify the sequence of steps in the left pane and the settings of each step in the right pane, including the billing type, which can be Time and Material or Progress Billing. You specify Progress Billing rules for project tasks, which are then billed by their progress.

The Progress Billing Process

Progress billing is a simple billing workflow for the projects that are gradually billed at a fixed contract amount. Progress billing does not involve project transactions. To bill a project task by its progress, you need to create a billing rule on the Billing Rules (PM207000) form and configure a step of the Progress Billing type in this rule. Then you assign the configured billing rule to project tasks on the Tasks tab of the Projects (PM301000) form.

The progress billing procedure could be initiated for a project that has at least one revenue budget line with billable project revenue, or for a project with pending values of zero if the progress billing step of the billing rule assigned to any project task has the Create Lines with Zero Amount and Quantity check box selected on the Billing Rules form.

Each revenue budget line is billed based on amount or quantity, depending on the option selected in the Progress Billing Base column on the Revenue Budget tab of the Projects form as follows:

  • For a line billed by amount, you need to specify a nonzero amount, which may be a negative amount, in the Pending Invoice Amount column. For these lines, the Pending Invoice Quantity, Draft Invoice Quantity, and Actual Quantity values are always 0.
  • For a line billed by quantity, you need to specify a nonzero quantity in the Pending Invoice Quantity column. In this case, the system will calculate the Pending Invoice Amount of the line as the pending invoice quantity multiplied by the unit rate specified in the line. The system will calculate the percentage of line completion (Completed (%)) based on the specified values.

You can also specify the Completed (%) value on the Revenue Budget tab for the needed revenue budget lines to indicate that the project tasks are being performed. The system will calculate the pending invoice values by using the following formulas:

Pending Invoice Amount = Revised Budgeted Amount * ( Completed (%) / 100 ) - Draft Invoice Amount - Actual Amount

Pending Invoice Quantity = Revised Budgeted Quantity * ( Completed (%) / 100 ) - Draft Invoice Quantity - Actual Quantity

Important: Project-related invoices, debit memos, and credit memos that have been created manually on the Invoices and Memos (AR301000) form are not included in pending invoice quantities and amounts.

When you run the project billing by clicking the Run Project Billing button on the form toolbar of the Projects form, the system prepares a pro forma invoice or an accounts receivable invoice depending on the project workflow, which is defined by the state of the Create Pro Forma Invoice on Billing check box on the Summary tab of the Projects form. The system creates an invoice with the unit prices, amounts, and quantities copied from the Unit Rate, Pending Invoice Amount and Pending Invoice Quantity columns of the Revenue Budget tab of the Projects form for the corresponding revenue budget lines.

Once an invoice is prepared, the Draft Invoice Amount and Draft Invoice Quantity of the revenue budget lines are updated with the amount and quantity for which the invoice has been prepared. The Pending Invoice Amount and Pending Invoice Quantity values become 0.

During the billing process, the system groups the billable amounts into invoices based on the following:
  • The invoice group of the steps of the billing rules to which the project tasks refer
  • The customer
  • The customer location
  • The Bill Separately setting of each project task defined on the Project Tasks (PM302000) form

If the project billing is performed by using the pro forma invoice workflow, the invoice lines that are produced by the progress billing steps are shown in the prepared pro forma invoice on the Progress Billing tab of the Pro Forma Invoices (PM307000) form. If you manually adjust the Amount to Invoice of a pro forma invoice line, the system automatically recalculates the Total Completed (%). This is the percentage of the revised budgeted amount of the revenue budget line of the project that has been invoiced by all the pro forma invoices of the project, including the current one. However, the system does not update the Completed (%) of the corresponding revenue budget line on the Revenue Budget tab of the Projects form accordingly. Also, the system does not update the Completed (%) of the revenue budget line if the related pro forma invoice with the corresponding progress billing line is deleted.