Progress Billing: General Information

With progress billing in MYOB Acumatica, you run project billing to automatically generate project invoices based on the progress recorded for the project.

Learning Objectives

In this chapter, you will learn how to do the following:

• Run project billing for a project
• Process the documents that have been generated during the project billing
• Review how the project’s actual amounts are updated with the billed amounts

Applicable Scenarios

You run project billing to prepare an invoice for the customer. You can bill the customer based on the current progress of the project. The timing of project billing depends on the project billing period defined for the project.

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 0 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

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.

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 (%) in this line. 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.

When you release a pro forma invoice and the system creates the corresponding accounts receivable invoice, the system copies the values in the Amount to Invoice column from the Progress Billing tab of the Pro Forma Invoices form to the corresponding lines of the accounts receivable invoice on the Details tab of the Invoices and Memos (AR301000) form.