{"id":817,"date":"2023-03-30T12:01:25","date_gmt":"2023-03-30T12:01:25","guid":{"rendered":"https:\/\/www.projectpro365.com\/user-guide\/?p=817"},"modified":"2023-12-14T07:01:57","modified_gmt":"2023-12-14T07:01:57","slug":"progress-billing-with-retention-reduction-job-sub-level-billing","status":"publish","type":"post","link":"http:\/\/stgdyz.stag33.netsmartz.us\/user-guide\/progress-billings\/progress-billing-with-retention-reduction-job-sub-level-billing\/","title":{"rendered":"Progress Billing with Retention Reduction & Job Sub-Level Billing"},"content":{"rendered":"

1. Retention Reduction Over-view with user story<\/strong><\/p>\n

\u2022 On 1st January 2022, Palmer & Sons agreed to start a construction project worth $150,000.
\n\u2022 The construction company decided to break the Project into a Master Job worth $90,000 and a Sub Job worth $60,000.
\n\u2022 On 31st January, The customer authorized to raise a sales invoice of 20% of master job total billing value with 10% retention and the sub job to be billed at 30% value with 12% retention.
\n\u2022 In the month of February a new change order to Master job of $30,000 and a reduction worth ($5,000) to the Sub job.
\n\u2022 For the stored material some additional equipment were purchased and customer agreed to bill them.
\n\u2022 On 28th Feb, the customer agreed to raise a sales invoice for 40% for all the lines.
\n\u2022 On 31st March, another change order to change order Master Job worth ($10,000) was introduced and a change order to Sub job for value $4,000 (Special Scenario).
\n\u2022 On 31st March it was mutually agreed between both the parties to reduce the retention% to 5% for all the contracts and bill 50% for all the lines and adjust all the stored material.
\n\u2022 In March some stored material was utilized and for the new change order $500 worth of stored materials were billed.
\n\u2022 On 30th April, the customer approved 100% billing of all the lines.
\n\u2022 On 31st May, all the retention amount was billed.<\/p>\n

2. Tickets covered<\/strong><\/p>\n\n\n\n\n\n
Issue key<\/th>\nSummary<\/th>\n<\/tr>\n
PRJ-1624<\/td>\nSales Line level Multiple Retainage Calculations with different percentage on a Progress Billing<\/td>\n<\/tr>\n
PE-13<\/td>\nChange order with Job Sub-level inclusion in Progress Billing. This will include sub-level in Master Job.<\/td>\n<\/tr>\n
PE-15<\/td>\nCreation of two invoices i.e. Retention Reduction invoice and Sales Billing Invoice in the Same Progress Bill included for the Stored material and Work Amount combinations<\/td>\n<\/tr>\n<\/table>\n

3. Master Job & Sub-Job Billing with Multiple retention percentage.<\/strong><\/p>\n

Job card it\u2019s mandatory to enter the \u201cContract Date\u201d<\/strong> as it required for running the report \u201cCombined CO AIA G702 and AIA G703\u201d<\/strong>.<\/p>\n

\"\"<\/p>\n

To process the billing, open Progress Billing page. Customer gave approval to raise billing request for Master job and Sub job. User can import planning lines of Master Job and Sub Job in the same progress bill using \u201cGet Billings\u201d function.<\/p>\n

\"\"<\/p>\n

While importing the lines, the system will display a message \u201cShould the Job J04630 card be updated to show that it is part of progress bill J04630?\u201d<\/strong>, for master job and sub-job and user can click on \u201cYes\u201d<\/strong> for both Master Job & Sub-Job.<\/p>\n

Second message shall display \u201cIs job J04630 a change order for Progress bill J04630?\u201d<\/strong> where user opt to click on \u201cNo\u201d<\/strong> as the Master Job and the Sub Job cannot be considered as a Change Order.<\/p>\n

Once lines are imported it will automatically populate the field \u201cContract Forecast Date\u201d<\/strong> as user has mentioned \u201cContract Date\u201d<\/strong> on Job card.<\/p>\n

Note1:<\/strong> It\u2019s Mandatory to enter the Contract Date on the Master Job Card to run the AIA report.
\nNote2:<\/strong> The sublevels (Change Order, Sub Job) contract date can be entered on Progress Billing page before creating the sales invoice and the report will consider the same. <\/p>\n

\"\"<\/p>\n

Since the retention % is different for Master Job (10% Retention)<\/strong> and for Sub Job (12% Retention)<\/strong>, need to enable the Boolean of \u201cMultiple Retention % on Lines\u201d<\/strong>.<\/p>\n

\"\"<\/p>\n

As the customer approved 20% billing of the Master Job and 30% billing of the Sub-Job, we would enter the percentage on the \u201cQuantity\u201d<\/strong> column.<\/p>\n

\"\"<\/p>\n

After getting the lines and enabling the Boolean \u201cMultiple Retention % on Lines\u201d<\/strong>, enter the Work Retention %<\/strong> on both the lines for retention calculation. In this case, the Master Job Retention is 10% and for the Sub-Job it 12%.<\/p>\n

\"\"<\/p>\n

Under the Retention tab, The field \u201cWork Retention Amount\u201d<\/strong> will show the total of Work Retention for all the lines.<\/p>\n

\"\"<\/p>\n

On a sales invoice, the Boolean \u201cMultiple Retention on Lines\u201d<\/strong> will become true. On the sales invoice lines the \u201cRetention %\u201d<\/strong> and \u201cRetention Amount\u201d<\/strong> will flow from the Progress Billing page to the sales invoice page for each line.<\/p>\n

\"\"<\/p>\n

On Retention Tab<\/strong>. In case of Multiple retention % is enabled<\/strong>, there would not be any retention % mentioned on field \u201cRetention Percent\u201d<\/strong>. All the retention amount for each line will be added and be shown in field \u201cRetention Amount\u201d<\/strong>.<\/p>\n

\"\"<\/p>\n

On Progress Bill page, click on Report-> Combined CO AIA G702 and AIA G703<\/strong> to view the report
\nOn heading \u201cOriginal Contract Sum\u201d<\/strong> calculated as $150,000 by combining the value of Master Job which is $90,000 and Sub Job $60,000<\/p>\n

Under the head of \u201cRetainage\u201d, all the Work Amount is added and shown under \u201cAmount of Completed Work\u201d<\/strong><\/p>\n

\"\"<\/p>\n

4. Change Order Inclusion in Master Job and Impact on Combined CO AIA G702 and AIA G703<\/strong><\/p>\n

In February 2022, two new change orders need to be included in the New Requisition.
\nWhen including the change-orders the system displays the message \u201cShould the Job J04630.001.001 card be updated to show that it is part of progress bill J04630?\u201d<\/strong> click on Yes.
\nAnother message will appear \u201cIs job J04630.001.001 a change order for Progress bill J04630?\u201d,<\/strong> the user shall opt to click \u2018Yes\u2019.<\/p>\n

On the change order card, the \u201cContract Date\u201d was not mentioned by the user, that is why the field \u201cContract Forecast Date\u201d<\/strong> is blank. On Progress Bill user can manually enter the \u201cContract Forecast Date\u201d. It\u2019s necessary to enter the date for each line so that the system can show on which Change Orders are current and which ones are the previous on Combined CO AIA G702 and AIA G703.<\/strong><\/p>\n

\"\"<\/p>\n

It was agreed that 40% will be billed for all lines till 28th February except for the change order J04630.001.002<\/strong> in which only $10,000<\/strong> will be billed in form of stored material<\/strong>.<\/p>\n

\"\"<\/p>\n

For the change order in which we are billing the Work Amount we must enter the Work Retention Percent for newly added lines. In our case, we have entered 10% in Work retention Amount. The Change Order in which we are billing the Stored Material user must enter \u201cStored Material Retention Percentage\u201d<\/strong>. In this case user is entering 10% in column \u201cStored Material Retention Percentage\u201d<\/strong> <\/p>\n

\"\"<\/p>\n

After posting the document we can run the report to see the calculated values. To access the report, click on \u201cCombined CO AIA G702 and AIA G703\u201d<\/strong><\/p>\n

\"\"<\/p>\n

In the AIA report under heading of \u201cNet Change by Change Orders\u201d<\/strong> we see the value of $25,000 (Change Order 1: $30,000 and Change Order: ($5,000).<\/p>\n

Under the \u201cChange Order Summary\u201d header, under column \u201cAdditions\u201d<\/strong> we see the Change order with positive value. In our case a Change order J04630.001.002 worth $30,000<\/strong> was shown. Another Change Order \u201cJ04630.001.001\u201d is shown with Negative value of ($5,000)<\/strong> under the column \u201cDeductions\u201d<\/strong>.<\/p>\n

\"\"<\/p>\n

5. Additional Billings, Retention Reduction and Impact on Combined CO AIA G702 and AIA G703<\/strong><\/p>\n

In Month of March it was agreed that Retention % will be 5%<\/strong> and total 50%<\/strong> work amount will be billed for all the lines.
\nIn the \u201cQuantity\u201d<\/strong> column, the user shall enter 50% value quantity column in all lines.<\/p>\n

\"\"<\/p>\n

In column of \u201cWork Retention Percent\u201d we must enter 5% for all the lines. For Change-Order J04630.001.002<\/strong> we have to enter 5%<\/strong> in \u201cStored Material Retention Percentage\u201d<\/strong><\/p>\n

\"\"<\/p>\n

As we are reducing the retention % and doing additional Billing at the same time, user shall enable the Boolean \u201cRetention Reduction & Invoicing\u201d.<\/strong> <\/p>\n

\"\"<\/p>\n

Click on Process -> Create Sales Document. The system will create one \u201cRetention Sales Invoice\u201d<\/strong> and second invoice as a \u201cNormal Sales Invoice\u201d<\/strong> because of additional billings. <\/p>\n

\"\"<\/p>\n

On the retention invoice, the Boolean of \u201cRetention Document\u201d<\/strong> is TRUE.<\/strong><\/p>\n

\"\"<\/p>\n

Retention Sales Invoice with value $3,880 is created.<\/p>\n

\"\"<\/p>\n

Retention Reduction Calculation for reference:<\/p>\n

\"\"<\/p>\n

A sales invoice with value $17,500 is generated because of the additional billing.<\/p>\n

\"\"<\/p>\n

Sales Invoice Calculation<\/p>\n

\"\"<\/p>\n

In the Combined CO AIA G702 and AIA G703<\/strong>, Under the heading of \u201cNet Change by Change Orders\u201d<\/strong> after adjusting the positive and negative values of the change orders we get the value of $19,000.<\/p>\n

The \u201cCurrent Payment Due\u201d<\/strong> field will add the value of sales invoice after deducting the retention $17,500-$875 i.e. $16,625 and the Retention reduction Invoice i.e. $3,880<\/strong>. Therefore, Current Payment Due = $16,625 + $3,880 = $20,505<\/strong><\/p>\n

In Change Order Summary, the values $30,000<\/strong> and ($5,000)<\/strong> were added as change order in the month of February, therefore they will be shown corresponding to \u201cTotal Changes Approved in Previous Month by Owner\u201d<\/strong>. As the $30,000<\/strong> is positive so it will be shown under Additions<\/strong> and ($50,000)<\/strong> is a negative value change order so it will be shown under Deductions.<\/strong> <\/p>\n

A positive change order of value $4,000 and ($10,000) were added in the month of March. Therefore, these values will be shown corresponding to \u201cTotal Approved this Month\u201d<\/strong>, the $4,000 value will be shown under \u201cAdditions\u201d<\/strong> and ($10,000) under \u201cDeductions\u201d<\/strong>.<\/p>\n

\"\"<\/p>\n

6. 100% Billing<\/strong><\/p>\n

On 30th April, the construction company was authorized to bill 100% for all the lines and the construction company utilized all the stored material.
\nOn the Progress Bill we will enter 100 in the Quantity column to bill the full value excluding the retention.
\nIn change order J04630.001.002, we will make Stored Material as $0<\/strong> because the company utilized the whole stored material.<\/p>\n

\"\"<\/p>\n

After entering all the details, the sales invoice can be generated and posted.
\nIn Combined CO AIA G702 & G703 report, there were no change orders introduced in the month of April, the previous two change orders will be shown corresponding to \u201cTotal Changes Approved in Previous months by owner.\u201d<\/strong><\/p>\n

\"\"<\/p>\n

7. Final Retention Billing<\/strong><\/p>\n

On May 31st 2022, Customer approved the whole project so the remaining 5% Retention on all the lines can be billed to the customer.
\nOn Progress Bill we will enter \u20180\u201d in \u201cWork Retention Percent\u201d<\/strong> for all the lines and then create a sales invoice.
\nThe system create a retention document and can be posted.<\/p>\n

\"\"<\/p>\n

On the Combined CO AIA G702 and G703 report, the balance will become $0.<\/p>\n

\"\"<\/p>\n

Feel free to connect for further details at Projectpro@netsmartz.com<\/p>\n","protected":false},"excerpt":{"rendered":"

1. Retention Reduction Over-view with user story \u2022 On 1st January 2022, Palmer & Sons agreed to start a construction project worth $150,000. \u2022 The construction company decided to break the Project into a Master Job worth $90,000 and a Sub Job worth $60,000. \u2022 On 31st January, The customer authorized to raise a sales … <\/p>\n

Continue reading “Progress Billing with Retention Reduction & Job Sub-Level Billing”<\/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":[42],"tags":[],"_links":{"self":[{"href":"http:\/\/stgdyz.stag33.netsmartz.us\/user-guide\/wp-json\/wp\/v2\/posts\/817"}],"collection":[{"href":"http:\/\/stgdyz.stag33.netsmartz.us\/user-guide\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/stgdyz.stag33.netsmartz.us\/user-guide\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/stgdyz.stag33.netsmartz.us\/user-guide\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/stgdyz.stag33.netsmartz.us\/user-guide\/wp-json\/wp\/v2\/comments?post=817"}],"version-history":[{"count":9,"href":"http:\/\/stgdyz.stag33.netsmartz.us\/user-guide\/wp-json\/wp\/v2\/posts\/817\/revisions"}],"predecessor-version":[{"id":828,"href":"http:\/\/stgdyz.stag33.netsmartz.us\/user-guide\/wp-json\/wp\/v2\/posts\/817\/revisions\/828"}],"wp:attachment":[{"href":"http:\/\/stgdyz.stag33.netsmartz.us\/user-guide\/wp-json\/wp\/v2\/media?parent=817"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/stgdyz.stag33.netsmartz.us\/user-guide\/wp-json\/wp\/v2\/categories?post=817"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/stgdyz.stag33.netsmartz.us\/user-guide\/wp-json\/wp\/v2\/tags?post=817"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}