{"id":999,"date":"2023-10-31T10:22:51","date_gmt":"2023-10-31T10:22:51","guid":{"rendered":"https:\/\/www.projectpro365.com\/user-guide\/?p=999"},"modified":"2025-04-14T07:30:28","modified_gmt":"2025-04-14T07:30:28","slug":"progress-billing-process","status":"publish","type":"post","link":"https:\/\/www.projectpro365.com\/user-guide\/standard\/progress-billing\/progress-billing-process\/","title":{"rendered":"Ch 01 – Progress Billing Process"},"content":{"rendered":"

Contents<\/b><\/p>\n\n\n\n<\/tr>\n\n\n\n\n\n\n\n\n
INTRODUCTION<\/a><\/td>\n<\/tr>\n
PROGRESS BILLING<\/a><\/td>\n<\/tr>\n
Get Billings Function<\/a><\/td>\n<\/tr>\n
New Version Function<\/a><\/td>\n<\/tr>\n
Make Sales Document Function<\/a><\/td>\n<\/tr>\n
New Requisition Function \u2013 Creating A Subsequent Requisition<\/a><\/td>\n<\/tr>\n
100% Billing<\/a><\/td>\n<\/tr>\n
Final Retention Billing<\/a><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

INTRODUCTION<\/b><\/p>\n

A progress billing is an invoice that is intended to obtain payment from a customer for that portion of a project that has been completed to date. These billings are commonly issued when a project has a long duration, so that the contractor can obtain sufficient funding to support its operations. Before starting a progress billing, user must check that the Project has been set up with the appropriate Planning Lines.<\/p>\n

<\/a>PROGRESS BILLING<\/b><\/p>\n

To create a progress billing, you must have a project with \u201cBillable\u201d or \u201cBoth Budget and Billable\u201d planning lines. You must also indicate the Progress Billing Method as Unit Billing, Percentage Billing, and Lump Sum Billing (Unit, %, and L\/S).<\/p>\n

Note:<\/u><\/b> If you are using either Percentage or Lump Sum Billing methods the quantity is always \u201c1\u201d. Variable quantities can only be used when you are using Unit Billing Methods.<\/p>\n

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

You can also define the Revenue Category for the planning lines, if required.<\/p>\n

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

If retention is applicable to your Project, enter it on the project card in the \u201cDefault Project Retention\u201d field. Make sure you have entered the \u201cContract Date\u201d for this project as well, see below screenshot.<\/p>\n

Note:<\/u><\/b> The Contract Date is mandatory and used to indicate whether this Project card and billing items represent a current month change order or a previous month\u2019s billing item on the AIA G702. The Contract Date should always be prior to your first Progress Billings Requisition Date. <\/p>\n

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

Create a progress billing by clicking on Process → Progress Billings.<\/p>\n

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

For first requisition, click on \u201cNew\u201d from the Project Progress Billing List page.<\/p>\n

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

Depending on your Projects Setup, you may find that once created, ProjectPro will automatically assign a No. to your Progress Bill. In most cases this No. will match your Project No. However, depending on your setup, you may be required to enter a No. in this field. <\/p>\n

In this example, the No. has been filled in to match the Project No. You will also see that Requisition No. has automatically been filled in as \u201c1\u201d since this is first billing.<\/p>\n

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

General Fast Tab<\/b><\/p>\n

To complete the General tab of the Progress Billings you will need to fill in each of the fields detailed below.<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
FIELDS<\/b><\/strong><\/td>\nDESCRIPTION<\/b><\/strong><\/td>\n<\/tr>\n
No.<\/b><\/strong><\/td>\nEnter a progress billing number or enter the Project number as a reference.<\/p>\n

To auto-populate the Progress Billing no. as the Project No., turn ON the option \u201cFirst No. for project to default as Project No.\u201d on the Progress Billing fast tab of the Projects Setup.<\/td>\n<\/tr>\n

Requisition No.<\/b><\/strong><\/td>\nThe requisition number automatically becomes \u20181\u2019 for the first requisition billing and will increase by one with each new requisition.<\/td>\n<\/tr>\n
Version No.<\/b><\/strong><\/td>\nThe version number starts as \u20180\u2019 for the first version. The purpose of the version number is to track changes that have been made because of the project owner, architect, or engineers\u2019 requirements prior to acceptance.<\/td>\n<\/tr>\n
Project No.<\/b><\/strong><\/td>\nThe Project No. will automatically fill in from the Project Card.<\/td>\n<\/tr>\n
Project Name<\/b><\/strong><\/td>\nThe Project Name will automatically fill in from the Project Card from the \u201cDescription\u201d field.<\/td>\n<\/tr>\n
Draw No.<\/b><\/strong><\/td>\nThe \u201cPay when Paid\u201d number that gets assigned to the Customer Sales Invoice and Vendor Purchase Invoice. If you are not using Draw No., you can leave this field blank.<\/td>\n<\/tr>\n
Customer No.<\/b><\/strong><\/td>\nThe Customer No. will automatically fill in from the Project Card.<\/td>\n<\/tr>\n
Customer Name<\/b><\/strong><\/td>\nThe Customer Name. will automatically fill in from the Project Card.<\/td>\n<\/tr>\n
Manager<\/b><\/strong><\/td>\nThe Manager ID No. will automatically fill in from the Project Card.<\/td>\n<\/tr>\n
Manager Name<\/b><\/strong><\/td>\nThe Manager Name will automatically fill in from the Project Card.<\/td>\n<\/tr>\n
Person Responsible<\/b><\/strong><\/td>\nThe Person Responsible ID No. will automatically fill in from the Project Card.<\/td>\n<\/tr>\n
Person Responsible Name<\/b><\/strong><\/td>\nThe Person Responsible Name will automatically fill in from the Project Card.<\/td>\n<\/tr>\n
Round Amounts<\/b><\/strong><\/td>\nToggling this ON will result in billing values being rounded to the neared whole dollar.<\/td>\n<\/tr>\n
Final<\/b><\/strong><\/td>\nThis can be used to indicate that the requisition has been accepted by the Project owner or representative. Once a progress billing is set as Final, you cannot create anymore Revisions of that requisition.<\/td>\n<\/tr>\n
Multiple Retention % on Lines<\/b><\/strong><\/td>\nIf this is True then, it will allow you to put in different Retention % or values at the Progress Billing Line level.<\/td>\n<\/tr>\n
Owner Contact<\/b><\/strong><\/td>\nIf you have indicated an Owner Contact for Billings, their name will appear here.<\/td>\n<\/tr>\n
Owner Contact Code<\/b><\/strong><\/td>\nOwner Contact ID will automatically fill in.<\/td>\n<\/tr>\n
Arch\/Eng. Contact<\/b><\/strong><\/td>\nIf you have indicated an Architect or Engineering Contact, their name will appear here.<\/td>\n<\/tr>\n
Arch\/Eng. Contact Code<\/b><\/strong><\/td>\nArchitect or Engineer Contact ID will automatically fill in.<\/td>\n<\/tr>\n
Status<\/b><\/strong><\/td>\nEach requisition has a status which indicates whether the billing is \u2018Open, Invoiced, Accepted, Paid, or Void.\u2019<\/p>\n

Status is automatically updated to invoiced when sales invoice is created or if a new version is created it automatically voids.<\/td>\n<\/tr>\n

Document No.<\/b><\/strong><\/td>\nOnce the progress billing is invoiced through a Sales invoice, the document number will indicate the Sales Invoice or Sales Order No. created.<\/td>\n<\/tr>\n
Posted Sales Invoice No.<\/b><\/strong><\/td>\nSpecifies the posted document no. of the invoice posted against the requisition.<\/td>\n<\/tr>\n
Requisition Date<\/b><\/strong><\/td>\nThis field is for the date this requisition is being prepared.<\/td>\n<\/tr>\n
Period To<\/b><\/strong><\/td>\nThis field is for the date in which is to indicate the work through period. Such as, work performed through the period ending 6\/30\/21.<\/td>\n<\/tr>\n
Retention Reduction and Invoicing<\/b><\/strong><\/td>\nEnable this Boolean if the Retention% is reduced and further billing is to be done on same requisition.<\/td>\n<\/tr>\n
Invoiced Currency Code<\/b><\/strong><\/td>\nThis field presents the FCY Currency Code from the Project card\u2019s \u201cInvoiced Currency Code\u201d. This will create your sales invoice in FCY.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Get Billings Function<\/b><\/p>\n

Once you have filled in the necessary fields above, the next step is to pull in your billing lines from the Project Planning Lines via \u201cGet Billings\u201d function.<\/p>\n

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

The \u201cGet Contract for Progress Bill\u201d window will pop up, as below where the project no. gets pre-populated, and you just need to click on OK to bring in the billing lines.<\/p>\n

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

This will update the progress billing sub form with the billable (including Both Budget and Billable) planning lines available for a project.<\/p>\n

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

Here, you can enter the percentage of each line you would like to bill for this requisition under \u201cQuantity\u201d column which will auto calculate billable amount under \u201cWork amount\u201d column.<\/p>\n

Since this is the first requisition, there will be no value in \u201cWork Previous Billing\u201d column.<\/p>\n

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

Note:<\/u><\/b> If you are billing in units, you will enter the number of units to be billed in the Quantity column. <\/p>\n

If you have identified a retention percentage for your project on the Project card, you will see that each line automatically reflects the percentage that has been entered and the appropriate retention has been calculated. <\/p>\n

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

Alternatively, if you did not enter retention on the Project Card, you can enter the percentage in the \u201cRetention\u201d fast tab located below the Progress Billing Sub form, or you can enter the percentage for each line individually, if it varies.<\/p>\n

Retention Fast Tab<\/b><\/p>\n

The fields under this fast tab are used for entering the percentage of retention for both \u201cWork Retention\u201d and \u201cStored Materials Retention\u201d. If the Default Retention % is defined on the Project card, then these fields will get updated automatically.<\/p>\n

If you wish to apply retention percentages for each line item individually, then leave the Retention Fast Tab fields blank and apply percentages on each billing line item.<\/p>\n

Note:<\/u><\/b> The individual retention percentage does not apply if you are using \u201cTaxable\u201d progress billings. In that case, only one retention percentage can be applied.<\/p>\n

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

If you are satisfied with your progress billing at this point, you can create your Sales Invoice (We will explain this process below).<\/p>\n

New Version Function<\/b><\/p>\n

Many a time, companies create their progress billings and submit them to the owner or general contractor for review before invoicing. This is commonly known as \u201cpencil copies\u201d. If your company is also following this method and you receive requests for changes before you can submit your final invoice, then you perform this in progress billings via \u201cNew Version\u201d function for that requisition. <\/p>\n

From the Progress Billing Ribbon, click on Process → New Version.<\/p>\n

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

The purpose of creating a new version is to maintain an audit trail of the changes you have made to progress billing. <\/p>\n

Once you select \u201cNew Version\u201d you will receive a message stating \u201ca new version has been created. The status of your original version has also been marked Void\u201d.<\/p>\n

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

Now you will see you are working on Requisition 1, Version 1.<\/p>\n

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

Initially the Progress Billing Subform remains unchanged. The billing percentages entered on Version 0 get carried over where you can make any necessary adjustments that are required. As an example, Line 1 billing has been reduced from 10% to 5% and Line 2 remains unchanged.<\/p>\n

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

Once the required fields on Progress Billing have been entered, you can proceed to create a sales document.<\/p>\n

Make Sales Document Function<\/b><\/p>\n

For creating Sales Invoice, Click on Process → \u201cMake Sales Document\u201d.<\/p>\n

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

Select \u201cYes\u201d when prompted for confirmation of document creation. <\/p>\n

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

You will receive confirmation of the Sales documentation being created, and the assigned sales invoice number. <\/p>\n

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

The Status of this progress billing will now get changed to \u201cInvoiced\u201d and you will notice the Sales Invoice number that was assigned above has now been filled in as Document No.<\/p>\n

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

Depending upon your internal process, you can continue to post your Sales Invoice from the progress bill, or you can visit the Sales Invoice page and post from there.<\/p>\n

To post from the Progress Billings page, click on Process → \u201cView Sales Document\u201d.<\/p>\n

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

You will be taken to the Sales Invoice. <\/p>\n

Note:<\/u><\/b> Before posting the sales invoice, verify if the correct information has been updated from the requisition. <\/p>\n

On the General fast tab, you will see Posting Date has automatically been marked with the \u201cRequisition Date\u201d. This can be modified if you do not want to keep the posting date same as requisition date.<\/p>\n

On the Lines fast tab, you will see each of your billable lines from the Progress Billing Subform and the corresponding total for each.<\/p>\n

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

On the Retention fast tab, you will see 10% has been calculated and the retention due date is automatically filled in according to Projects Setup for retention. <\/p>\n

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

Post the invoice using the appropriate option under the Posting section of the ribbon. <\/p>\n

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

Once the sales invoice is posted, you can go back to the progress billing requisition and run different reports and AIA documents.<\/p>\n

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

Note:<\/u><\/b> To use AIA documents, you need to fill in your AIA Form Code and Expiration date on the Projects Setup page. <\/p>\n

Two of the sample reports are shown as below:<\/p>\n

1. Progress Invoice Report<\/b><\/p>\n

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

2. AIA G702 Report<\/b><\/p>\n

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

3. AIA G703 Report<\/b><\/p>\n

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

New Requisition Function\u2013 Creating A Subsequent Requisition<\/b><\/p>\n

The next requisition can be created from the last requisition that you have created. The Progress Billings List page shows all the prior requisitions, including any voided versions.<\/p>\n

Open your last invoiced requisition from the list. Here, the last requisition is Requisition 1, Version 1. <\/p>\n

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

From the Progress Billing ribbon click on Process → New Requisition.<\/p>\n

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

The \u201cRequisition No.\u201d will get increased to 2 where Version No. is 0. You are now working on Requisition 2.0 <\/p>\n

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

Enter the new Requisition and Period to Dates. Notice your Progress Billing Subform reflects your invoiced amounts from Requisition 1 in the \u201cWork Previous Billings\u201d column.<\/p>\n

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

Enter the percentages that you would like to bill for this Requisition in the Quantity column. The \u201cTotal\u201d column will now reflect the total amount to be billed to date on this project (Work Previous Billings + Work Amount = Total)<\/b>.<\/p>\n

From here you will follow the same process as above to create and post your Sales Invoice.<\/p>\n

100% Billing<\/b><\/p>\n

On completion of the contract including utilization of Store Materials (if any, the complete concept explained in next chapter), you need to bill 100% on all the lines.<\/p>\n

On the last requisition, enter 100 in the Quantity column to bill the full value excluding the retention. Also, if stored materials are included then you need to change the \u201cStored Materials Amount\u201d to 0 since the complete utilization has been done, see example below.<\/p>\n

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

Once the details are entered, the sales invoice can be generated and posted.<\/p>\n

Final Retention Billing<\/b><\/p>\n

Once the whole project is approved the remaining Retention% on all the lines can be billed to the customer.<\/p>\n

From the last requisition where everything is billed to complete 100%, create a New Requisition. Remove the value from \u201cWork Retention Percent\u201d field on the Retention fast tab or if multiple retention is used then remove the same from for all the lines and then create a sales invoice.<\/p>\n

The system creates a sales invoice marked as \u201cRetention Document\u201d.<\/p>\n

\"null\"<\/p>\n","protected":false},"excerpt":{"rendered":"

Contents INTRODUCTION PROGRESS BILLING Get Billings Function New Version Function Make Sales Document Function New Requisition Function \u2013 Creating A Subsequent Requisition 100% Billing Final Retention Billing INTRODUCTION A progress billing is an invoice that is intended to obtain payment from a customer for that portion of a project that has been completed to date. … <\/p>\n

Continue reading “Ch 01 – Progress Billing Process”<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7,36,39],"tags":[],"class_list":["post-999","post","type-post","status-publish","format-standard","hentry","category-progress-billing","category-progress-billing-2","category-progress-billing-3","entry"],"_links":{"self":[{"href":"https:\/\/www.projectpro365.com\/user-guide\/wp-json\/wp\/v2\/posts\/999","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.projectpro365.com\/user-guide\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.projectpro365.com\/user-guide\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.projectpro365.com\/user-guide\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.projectpro365.com\/user-guide\/wp-json\/wp\/v2\/comments?post=999"}],"version-history":[{"count":10,"href":"https:\/\/www.projectpro365.com\/user-guide\/wp-json\/wp\/v2\/posts\/999\/revisions"}],"predecessor-version":[{"id":1458,"href":"https:\/\/www.projectpro365.com\/user-guide\/wp-json\/wp\/v2\/posts\/999\/revisions\/1458"}],"wp:attachment":[{"href":"https:\/\/www.projectpro365.com\/user-guide\/wp-json\/wp\/v2\/media?parent=999"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.projectpro365.com\/user-guide\/wp-json\/wp\/v2\/categories?post=999"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.projectpro365.com\/user-guide\/wp-json\/wp\/v2\/tags?post=999"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}