Job Billing - Invoice Report Layouts

A master list of Job Billing invoice formats can be found here. The XLSX file can be searched for available columns in each invoice format and contains sample invoices to preview.

Progress Billing type U_10

This format has the standard columns and headings and reports as a standard progress billing type invoice.

Progress Billing type U_11

This layout has a modified Schedule of Values section with three columns reporting original budget amount, plus/minus change orders and current billing budget.

Progress Billing type U_12

The U12 layout has the columns of the U_10 with an added column called Total Taxes To Date. Where all other G703 reports will not include taxes the U_12 will calculate taxes in all columns including the original value and will report these totals on the G702.

Progress Billing type U_13

This layout is unique in how it handles materials stored. If the JB control is set to materials stored included in billing amount the materials stored figure will not be brought forward into the From Previous Billing/Application column.

The U_10, U_11 and U_12 will bring the materials stored figure forward to the From Previous Billing/Application column. If the JB Control checkbox is not used the U_13 will not show the materials stored on the U_13 at all nor will it be brought forward to the G702 to be included in the total completed and stored to date amount. The U_10, U_11 and U_12 will include the materials stored in the total completed and stored to date on the G702, however, the U_12 will not calculate the tax on the materials stored.

Progress Billing type U_14

The U14 layout has the function of the U_13 but is unique in the added columns and headers. Column C has two added columns with a header of Subcontractor Detail with column headings of Name and Buyout. The Buyout Amount column will show the total of the committed costs if the ‘SPW’ (self performed work) checkbox is off on the contract or it will show the scheduled value if the ‘SPW’ checkbox is on. Column H is called Balance to Finish vs. Buyout amount. The calculation for column H is Buyout Amount minus Total Completed and Stored to Date.

The rules for the U_14 are:

• If the bill line is marked as self-performed work (SPW) there will be no vendor name and the buyout amount will be equal to the budget amount.

• If the bill line is not marked as self-performed work (SPW) and there are no committed costs the vendor name will be TBD and the buyout amount will be equal to the budget amount.

• If the bill line is not marked as self-performed work (SPW) and there are committed costs then the total buyout amount is shown on the billing line along with vendors (SC and PO) listed below the total buyout with the business partner name and amount. When there is a single vendor there will not be a listing below the BP name and the buy amount will appear on the billing line.

Progress Billing type U_15

Has the same function as the U_10. The U_15 will show the original contract amount and changes the same as the U_11. The difference is that the U_15 has separate columns - column C original SOV, column D SOV changes and column E scheduled value. U_10 does not show changes, whereas U_11 has this information broken down in sections under one column.

Progress Billing type U_16

This layout is similar to the original U_10, however includes on the detail pages an additional column representing the current period retainage amount. (Positive or negative depending on new retainage or released retainage.)

Progress Billing type U_17

This layout is similar to the original U_14, however includes on the detail pages an additional column representing the current period retainage amount. (Positive or negative depending on new retainage or released retainage.) See the details of the U_14 layout for particulars on other columns.

Progress Billing type U_19

This layout is a simplified version of the detail pages from an AIA invoice. This layout will not use more than one group – it only includes detail rows for the group specified in invoice format group summary 1. The U_19 is not to be used with show bill codes and does not offer any grouping options (besides that defined as the single group on which details are shown).

This format will automatically break all sub-jobs out, reporting each job and sub-job individually showing the job code and name as a header, and a footer showing the subtotal amount for the job/sub-job.

Progress Billing type JBSSTMT

This layout has a schedule of values like the U_11 showing the original contract, change order plus or minus but instead of the third column reading current the JBSSTMT column reads adjusted contract. The JBSSTMT follows the U_13 rules in how it handles materials stored. The JBSSTMT is more closely related to the U_14 following the billing rules for self-performed (SPW) and subcontractor (committed cost) entries. The difference is with the self-performed (SPW) work the description will appear in the Subcontractor Name column, the description coming from the Job Billing Control – self performed work description. Other differences for the JBSSTMT are a sworn statement on the last page of the AIA invoice, a summary at the bottom of the G703, a group total at the top of the group or if groups are not being used a total line at the top of the AIA report. The percent complete column has been moved to show beside the Schedule of Values column.

Columns unique to the JBSSTMNT are Previous Billing (Net), Current Net Due, and Remaining to Bill.

Progress Billing type C_10

The C_10 is a Canadian invoice with similar detail pages as the U_10 but then calculates and reports Canadian tax GST. This layout prints certain pages in landscape and others in portrait orientations.