Select for Progress Billing fields

How Do I...

Below is a list of all fields on the Select for Progress Billing window. All columns can be moved and sized by dragging and dropping.

Note: Negative percentages and amounts will display in red text for enabled fields.

Header Fields

Invoice Date: This will be the date of the invoices that are generated through this routine. The default value is the As of date selected in the Select for Progress Billing - Filter Selection window.

Note: Changing this date does not affect the data in the grid.

Line Items Grid

Warning! The data on the grid for all tabs is date sensitive and the information in the fields will vary depending on the As of date selected during the filter selection routine. Data for billings that occurred on a date AFTER the As of date will not appear in the grid.

Percent of Contract/Completion tab

Note: Some of the fields on this grid may be viewed by using the scroll bar at the bottom of the grid.

Invoice: Check the box if you want to create an invoice for this line item or add the line item to an invoice.
Customer: Identifies the customer selected for the job on the Maintain Jobs window.
Job: Identifies the job.
Phase: Identifies the phase of the job.
Cost Code: Identifies the cost code of the job.
Bill %: Enter a percent of the estimated revenue to bill. The default value will be determined by the billing method for the job. For Percent of Contract, the default will be 0.00; for Percent of Completion, it will be Total % - Prev Billed %. For Percent of Contract billing, this is the field that you should update to determine how much you will bill for this line item. This field will be updated if you use the Select Percentage to Bill window. Changing this field will recalculate the Total % and Amount fields. Tell me more about billing methods and how they calculate.
Total %: Enter the total percent of the estimated revenue that has been completed. The default value depends on the billing method for the job. For Percent of Contract billing, the default will be the percentage of the job that has been previously billed. For Percent of Completion billing, the default will be the value of: (Actual Expenses / Estimated Expenses) * 100. For Percent of Completion billing, this field will show you how much you should bill, based on completion percentage. Changing this field will recalculate the Bill % and Amount fields. Tell me more about billing methods and how they calculate.
Amount: Enter the amount to invoice for the job/phase/cost code. The default value depends on the billing method for the job. For Percent of Contract, the default will be 0.00. For Percent of Completion, the default will be equal to: (Estimated Revenue * [Actual Expenses/Estimated Expenses]) - Amount Previously Billed. Changing this field will recalculate the Bill % and Total % and update Retainage amounts based on the Retainage %. Tell me more about billing methods and how they calculate.
Retainage %: Enter a percent of retainage for this job. The default value will be the Retainage % for the job as entered on the Maintain Jobs window. Changing the value will automatically adjust the Retainage Amt.
Retainage Amt: Enter the retainage amount for this job. The default value is Retainage % * Amount to Bill. Changing either value will automatically adjust the Retainage %.
Balance to Finish: Displays the amount that has yet to be billed for this job/phase. It is calculated by subtracting the Amount billed to date from the Estimated Revenue for the job.
Tax: Allows you to select the item tax type.
% Previously Billed: Displays the percent of the estimated revenue that has already been billed.
Estimated Revenue: Displays the Estimated Revenue for the job/phase as specified in the job file.
Amt Previously Billed: Displays the amount previously invoiced for the job.
Estimated Expenses: Displays the Estimated Expenses for the job.
Actual Expenses: Displays the Actual Expense for the job as of the As of date on the Select for Progress Billing - Filter Selection window.

Percent of Proposal tab

This tab will be available if you selected Percent of Proposal and you have accepted, open proposals in your system. From this tab, you can select which proposals you will bill and the amounts to bill. Billed proposals will be editable as sales invoices in the Sales Invoicing window and line items will appear on the Apply to Proposals tab.

One invoice will be created per proposal.

Invoice: Check the box if you want to create an invoice for this line item or add the line item to an invoice.
Proposal No: Displays the proposal number for this line.
Customer: Identifies the customer selected for the proposal.
Item: Displays the Item ID for the line.
Description: Displays the description for this line item.
Proposal Amt: Displays the amount for this proposal.
Prev Billed Amt: Displays the amount previously invoiced for this line as of the As of date.
Qty: Allows you to enter the quantity to bill for this line.
Billed %: Allows you to enter a % of the proposal amount to bill. The default value is 0.00. This field will be updated if you use the Select Percentage to Bill window accessed by clicking the Bill button. Changing this value will recalculate the Amount and Total % fields. Tell me more about billing methods and how they calculate.
Total %: Allows you to enter the total percent of the proposal amount to be billed, including the previously billed %. The default value is Prev Billed Amt/Proposal Amt*100. In other words, it is the percentage of the line that has been billed previously. Changing the value of this field will recalculate the Bill % and Amount fields. Tell me more about billing methods and how they calculate.
Amount: Allows you to enter the amount that you would like to bill for the line. The default value is 0.00. Tell me more about billing methods and how they calculate.
Retainage Amt: Allows you to enter the amount of retainage for a job.
Retainage %: Allows you to enter the percentage of retainage for a job: The default value will come from the job record for the job selected, if any.
Unit Price: Allows you to enter the unit price for the line. This field will default from the proposal.
Tax: Select the item tax type for the line. It will default from the proposal.
Job: Identifies the job.
Phase: Identifies the phase.
Cost Code: Identifies the cost code.

Release Retainage tab

This tab will be available if you have selected the Release Retainage check box on the Progress Billing for Jobs - Filter Selection window and if there are existing jobs with positive amounts of retainage withheld. It will display one row per job.

Retainage amounts released on this window will be editable as sales invoices on the Sales Invoicing window and released amounts will appear on the Apply to Sales tab. Sales tax will not be calculated on released retainage.

Note: This tab is not available if you are using the Cash Basis accounting method.

Invoice: Check the box if you want to create an invoice for the retainage.
Customer ID: Displays the customer selected for the job.
Job ID: Displays the job.
Withheld: Displays the amount of retainage that has been withheld for the job.
% to Release: Enter the percentage of withheld retainage to release and invoice. The default value is 100.00.
Use this field to release partial amounts of retainage if you release retainage when a phase is completed rather than when the entire job is completed.
Amount: Enter the amount of withheld retainage to release and invoice. The default is the entire amount. This value will change automatically when the % to Release is changed.

Lower Fields

Create one Invoice: From the drop-down list, select the consolidation value for the generated invoices. You can choose either Per Customer or Per Job.

Note: Released Retainage is invoiced separately.

Total Amount: Displays the total dollar amount of all checked line items. This value is equivalent to the total Amount to Bill values minus Retainage Amts plus Amount values on the Release Retainage tab plus sales tax for all checked items.
Number of Invoices: Displays the number of potential invoices. This value depends on your selection for the Create one Invoice field.