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.