{"id":582,"date":"2010-04-14T10:37:32","date_gmt":"2010-04-14T18:37:32","guid":{"rendered":"http:\/\/www.projectp.com\/weblog\/?p=582"},"modified":"2022-11-23T11:21:25","modified_gmt":"2022-11-23T19:21:25","slug":"construction-contract-billing","status":"publish","type":"post","link":"https:\/\/www.projectp.com\/ppblog\/2010\/04\/14\/construction-contract-billing\/","title":{"rendered":"Construction Contract Billing"},"content":{"rendered":"<p>By John May<\/p>\n<p>In 1992, the American Institute of Architects\u00ae formalized a standardized \u201cpercentage of completion\u201d contract billing methodology. The forms developed are known by their numerical assignments:\u00a0 G702 and G703. The purpose was to allow contractors, owners, architects, and construction managers a familiar way of communicating and authorizing payments during the life of a construction contract. <!--more--><\/p>\n<p>Users of Oracle E-Business Suite Projects applications have always had a sophisticated billing system but generally required an off-system solution for invoice presentation. As a result, users have created custom reports, offline invoicing tools, and other custom solutions.<\/p>\n<p>While there are non-integrated invoicing solutions for AIA-compliant billing on the market, Project Partners has developed a fully integrated solution using Microsoft Excel-based worksheets to control completely, process, and print invoices in these standard formats.<\/p>\n<p>The solution, however, goes way beyond mere invoice printing to reduce invoicing labor by 65%. Using the easy Microsoft\u00ae Excel interface of Project Partners Construction Contract Billing\u2122, Project Managers and financial administrators can perform the following functions within Oracle Projects:<\/p>\n<ul>\n<li>Maintain contract billing information<\/li>\n<li>Enter and maintain change orders<\/li>\n<li>Maintain Billing Tasks<\/li>\n<li>Update and baseline revenue budgets<\/li>\n<li>Manage Billing Retention Rules<\/li>\n<li>Generate Draft Invoices<\/li>\n<li>Review and Print AIA formatted Application for Payment invoices<\/li>\n<\/ul>\n<p><strong><span style=\"color: #3366ff;\">Business Process Flow for Project Partners Construction Contract Billing<\/span><\/strong><\/p>\n<p>The following business process flow shows how Project Partners Construction Contract Billing is used to manage your project contract tracking and billing flow.<\/p>\n<div id=\"attachment_595\" style=\"width: 610px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.projectp.com\/ppblog\/wp-content\/uploads\/2010\/04\/CCB_ProcessFlow_jpg21.jpg\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-595\" class=\"size-full wp-image-595\" title=\"CCB_ProcessFlow_jpg2\" src=\"https:\/\/www.projectp.com\/ppblog\/wp-content\/uploads\/2010\/04\/CCB_ProcessFlow_jpg21.jpg\" alt=\"Process Flow for Project Partners Construction Contract Billing\" width=\"600\" height=\"365\" srcset=\"https:\/\/www.projectp.com\/ppblog\/wp-content\/uploads\/2010\/04\/CCB_ProcessFlow_jpg21.jpg 600w, https:\/\/www.projectp.com\/ppblog\/wp-content\/uploads\/2010\/04\/CCB_ProcessFlow_jpg21-300x182.jpg 300w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/a><p id=\"caption-attachment-595\" class=\"wp-caption-text\">Process Flow for Project Partners Construction Contract Billing<\/p><\/div>\n<p>The Billing Schedule of Values and Application for Payment worksheets, delivered with Project Partners Construction Contract Billing (Construction Contract Billing), are configured to integrate Oracle E-Business Suite Project Billing data to manage revenue budgets, billing tasks, retention rules, and processing project invoices in Oracle.<\/p>\n<p><strong><span style=\"color: #3366ff;\">Billing Schedule of Values Worksheet<\/span><\/strong><\/p>\n<p>The Billing Schedule of Values worksheet manages your contract budgeting data. All relevant data is shown on one convenient worksheet, eliminating the need to navigate various forms to enter and maintain your data.<\/p>\n<p style=\"text-align: center;\">\n<p style=\"text-align: center;\">\n<div id=\"attachment_584\" style=\"width: 471px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.projectp.com\/ppblog\/wp-content\/uploads\/2010\/04\/SOV-Spreadsheet-Sample.jpg\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-584\" class=\"size-full wp-image-584  \" title=\"SOV Spreadsheet Sample\" src=\"https:\/\/www.projectp.com\/ppblog\/wp-content\/uploads\/2010\/04\/SOV-Spreadsheet-Sample.jpg\" alt=\"Schedule of Values Worksheet in Project Partners Construction Contract Billing\" width=\"461\" height=\"288\" srcset=\"https:\/\/www.projectp.com\/ppblog\/wp-content\/uploads\/2010\/04\/SOV-Spreadsheet-Sample.jpg 1280w, https:\/\/www.projectp.com\/ppblog\/wp-content\/uploads\/2010\/04\/SOV-Spreadsheet-Sample-300x187.jpg 300w, https:\/\/www.projectp.com\/ppblog\/wp-content\/uploads\/2010\/04\/SOV-Spreadsheet-Sample-1024x640.jpg 1024w\" sizes=\"auto, (max-width: 461px) 100vw, 461px\" \/><\/a><p id=\"caption-attachment-584\" class=\"wp-caption-text\">Schedule of Values Worksheet<\/p><\/div>\n<p><strong>\u00a0<\/strong><\/p>\n<p><strong>Agreement and Contract Header Data<\/strong><\/p>\n<p>All the contract header information is entered into the worksheet. First, the user enters the required agreement header data to create and update Oracle Project Billing\u2019s agreement. Next, the actual contract header information used to develop the AIA-compliant invoice format is entered, including the name, description, and original contract approval date. Also, the client\u2019s architect information is included and maintained in this worksheet.<\/p>\n<p>The revenue budget version header is finally entered to create the project\u2019s revenue budget amounts. This data is used to create both the original budget version and subsequent budget versions and relate those versions to the contract change orders.<\/p>\n<p><strong>Schedule of Value Line Items<\/strong><\/p>\n<p>Schedule of Values [SOV] contract line items are created and maintained in the SOV Line item section. The worksheet automatically creates and integrates these line items as billing tasks into Oracle Projects. In addition, a convenient CSI coding field is included for optional use to categorize SOV line items.<\/p>\n<p><strong>Contract Values<\/strong><\/p>\n<p>Original contract values are entered on each line item and uploaded into the current working budget version. As revisions are authorized, a new version is entered into the worksheet and baselined into the Approved Revenue Budget.<\/p>\n<p><strong>Retention Rules<\/strong><\/p>\n<p>With the same Billing SOV worksheet, standard Oracle Project Billing Retention Rules are entered and maintained in the Retention Rules columns of the SOV Line items section. In addition, separate rules for Completed Work and Stored Materials are available for users as needed. These rules are used to estimate the withheld retention amounts within the Application for Payment worksheet and by Oracle Project Billing to calculate the retention amounts for invoice generation.<\/p>\n<div id=\"attachment_585\" style=\"width: 310px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.projectp.com\/ppblog\/wp-content\/uploads\/2010\/04\/SOV_Lines_jpg.jpg\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-585\" class=\"size-medium wp-image-585\" title=\"SOV_Lines_jpg\" src=\"https:\/\/www.projectp.com\/ppblog\/wp-content\/uploads\/2010\/04\/SOV_Lines_jpg-300x90.jpg\" alt=\"Schedule of Values Lines\" width=\"300\" height=\"90\" srcset=\"https:\/\/www.projectp.com\/ppblog\/wp-content\/uploads\/2010\/04\/SOV_Lines_jpg-300x90.jpg 300w, https:\/\/www.projectp.com\/ppblog\/wp-content\/uploads\/2010\/04\/SOV_Lines_jpg.jpg 695w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><p id=\"caption-attachment-585\" class=\"wp-caption-text\">Enter Schedule of Values Lines<\/p><\/div>\n<p><strong>Baselining Budget<\/strong><\/p>\n<p>Once the original contract amounts have been entered and saved to Oracle Projects, the user can submit the new budget version for baselining. Construction Contract Billing can automatically submit and baseline the current working version in Oracle. Optionally, if the user implements the budget approval workflow, then the Submit for Baseline action will trigger the workflow and follow standard Oracle workflow processes and procedures.<\/p>\n<p><strong>Contract Revisions<\/strong><\/p>\n<p>Maintaining correct change order information is vital for accurate processing and reporting in the G702\/3 billing forms. Therefore, users can track change orders by entering the change order header and amounts after processing the original baseline budget. Change order information is stored in conjunction with the standard budget version data.<\/p>\n<p>Users do not have to use Oracle Project Management\u2019s Control functionality. For example, tracking and maintaining change orders is independent of the standard change order process.<\/p>\n<p><strong><span style=\"color: #3366ff;\">Application for Payment<\/span><\/strong><\/p>\n<p>Project Partners Construction Contract Billing generates invoices using the Application for Payment worksheet. This worksheet integrates the latest baselined contract amounts and current billing data and allows the user to create an invoice directly from the worksheet in Oracle Projects.<\/p>\n<p style=\"text-align: center;\">\n<div id=\"attachment_586\" style=\"width: 624px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.projectp.com\/ppblog\/wp-content\/uploads\/2010\/04\/AFP-Spreadsheet-Sample.jpg\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-586\" class=\"size-large wp-image-586 \" title=\"AFP Spreadsheet Sample\" src=\"https:\/\/www.projectp.com\/ppblog\/wp-content\/uploads\/2010\/04\/AFP-Spreadsheet-Sample-1024x640.jpg\" alt=\"Application for Payment Spreadsheet in Project Partners Construction Contract Billing\" width=\"614\" height=\"384\" srcset=\"https:\/\/www.projectp.com\/ppblog\/wp-content\/uploads\/2010\/04\/AFP-Spreadsheet-Sample-1024x640.jpg 1024w, https:\/\/www.projectp.com\/ppblog\/wp-content\/uploads\/2010\/04\/AFP-Spreadsheet-Sample-300x187.jpg 300w, https:\/\/www.projectp.com\/ppblog\/wp-content\/uploads\/2010\/04\/AFP-Spreadsheet-Sample.jpg 1280w\" sizes=\"auto, (max-width: 614px) 100vw, 614px\" \/><\/a><p id=\"caption-attachment-586\" class=\"wp-caption-text\">Application for Payment Spreadsheet<\/p><\/div>\n<p><strong>\u00a0<\/strong><\/p>\n<p><strong>Application for Payment Billing Header Data<\/strong><\/p>\n<p>Users start creating an Application for Payment (AFP) invoice by entering the billing header data to ensure the correct invoice information is made. This includes the AFP sequence number, bill through date, and, optionally, the AR invoice number.<\/p>\n<p><strong>Get Contract Data<\/strong><\/p>\n<p>Once the header information is entered, the user retrieves the current contract and historical billing amounts from Oracle Projects. This is performed by clicking on a button within the worksheet. To ensure that you have the most current values in your spreadsheet, you refresh your data using the \u201cGet Current Values\u201d button. This will re-populate all the fields with the most recent data. Next, contract data is coordinated by entering the correct bill through a date to ensure the contract version is used to generate billing amounts.<\/p>\n<p><strong>Enter Current Period Percent Complete or To-Date Billing Amounts<\/strong><\/p>\n<p>Users can enter the current period billing amounts by entering a percent complete value on the SOV line item or manually enter the To Date Completed Work amount for each item. The worksheet automatically calculates the summary and current billing values, and amounts are entered. Additionally, the user can save their data anytime in the Oracle database.<\/p>\n<p><strong>Enter Stored Material Amounts<\/strong><\/p>\n<p>Many contracts have provisions for the contractor to bill for Materials bought and stored either on-site or in a secure location but have not been used in the completed work calculations. Different amounts can be entered to bill for unconsumed materials.<\/p>\n<p><strong>Generate Draft Invoice<\/strong><\/p>\n<p>To generate an invoice, all the user has to do is click a button within the worksheet. The standard Generate Draft invoice process is used in conjunction with Project Partner\u2019s Invoice application to generate and optionally print the G702\/3 invoice.<\/p>\n<p>Users can optionally approve and release invoices within the AFP worksheet, assuming the correct responsibility functions. Otherwise, standard approval and release functions can be performed within Oracle Project Billing.<\/p>\n<p><strong>Review Historical Invoices<\/strong><\/p>\n<p>With the AFP worksheet, users are also able to review historical invoices which have been previously released. Both the worksheet calculation amounts are displayed, and the ability to review the Pro-forma invoice.<\/p>\n<p>Project Partners Construction Contract Billing fully integrates Oracle Project Billing and Oracle Receivables and leverages the technology of Project Partners Invoicing to create a complete invoicing solution for the Engineering &amp; Construction Industry.<\/p>\n<p><strong>For more information<\/strong> about Project Partners Construction Contract Billing and to see the online demonstration and webinar: <a href=\"http:\/\/www.projectp.com\/products\/cc_billing.php\">http:\/\/www.projectp.com\/products\/cc_billing.php<\/a>.<\/p>\n<p><span style=\"color: #888888;\">All trademarks are the property of their respective owners.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>In 1992, the American Institute of Architects\u00ae formalized a standardized \u201cpercentage of completion\u201d contract billing methodology. The forms developed are known by their numerical assignments:\u00a0 G702 and G703. The purpose was to allow managers a familiar way of communicating and authorizing payments during the life of a construction contract.<\/p>\n","protected":false},"author":79,"featured_media":3666,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[15,266],"tags":[],"class_list":["post-582","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-industry-trends-standards","category-ui-apps"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.projectp.com\/ppblog\/wp-json\/wp\/v2\/posts\/582","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.projectp.com\/ppblog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.projectp.com\/ppblog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.projectp.com\/ppblog\/wp-json\/wp\/v2\/users\/79"}],"replies":[{"embeddable":true,"href":"https:\/\/www.projectp.com\/ppblog\/wp-json\/wp\/v2\/comments?post=582"}],"version-history":[{"count":0,"href":"https:\/\/www.projectp.com\/ppblog\/wp-json\/wp\/v2\/posts\/582\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.projectp.com\/ppblog\/wp-json\/wp\/v2\/media\/3666"}],"wp:attachment":[{"href":"https:\/\/www.projectp.com\/ppblog\/wp-json\/wp\/v2\/media?parent=582"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.projectp.com\/ppblog\/wp-json\/wp\/v2\/categories?post=582"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.projectp.com\/ppblog\/wp-json\/wp\/v2\/tags?post=582"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}