BILLING INFO

Use this tab to specify the project billing formula and billing format. Set up project billing information for the following:

• Any project that has billings calculated for it.

• Any project that requires supporting schedules based on units, cost, or hours transactions.

• Any project for which the bills are manually entered through the Manage Project Product Bills, Manage Milestone Percent Complete Bills, Manage Customer Product Bills, or Manage Manual Bills screens.

All transaction journal posting programs check for the existence of the project in this table and for a billing formula that is based on transactions. If the project is found in this table with a transaction-based billing formula, the posting program selects it and all of its lower levels for posting to the Open Billing Detail table. All transaction-based bills use information in the Open Billing Detail table to calculate bills.

Generic Billing Format

Enter, or click to select, the billing format code for this quick project.

Billing formats contain customized formatting for your transaction-based billings. You set them up on the Manage Generic Billing Formats screen.

Billing Formula

Enter, or click to select, the billing formula for this quick project. This billing formula is used to calculate the bill for the project.

After you enter a billing formula ID, its description populates the field to the right.

Also, depending on the billing formula you enter, additional billing calculation fields, such as Fee Percent, Labor Fee Percent, or Non-Labor Fee Percent display in this screen and require entry.

There are two types of billings, transaction-based and manual.

• A transaction-based billing formula is generally based on the transactions that have been charged to the project. The Open Billing Detail table stores the transactional data that is used in the computation of the invoice. This data remains in the Open Billing Detail table until you post the bill.

• A manual billing is one that does not rely on transactions that have been posted to the project. Manual bills are entered on the Manage Manual Bills, Manage Milestone/Percent Complete Bills, Manage Project Product Bills, and Manage Customer Product Bills screens. You must enter a billing formula of Enter Bill Manually if you want to use any of these formulas.

The following is a list of the available billing formulas:

• Cost Incurred Plus Fee On Cost — This is a transaction-based formula that summarizes the costs incurred by a project and applies burden and fee to those costs. Costpoint uses the transactions in the Open Billing Detail table to calculate the invoice. Costpoint calculates the burden using the provisional rates on the Pool Rates subtask of the Manage Cost Pools screen. The fee is calculated by applying the fee percent entered in this screen to the total of the costs and burden.

• Cost Incurred Plus Fee On Hours — This is a transaction-based formula that summarizes the costs incurred by a project and applies burden and fee to those costs. When you calculate bills, Costpoint uses the transactions in the Open Billing Detail table to calculate the invoice. The burden is calculated using the provisional rates on the Pool Rates subtask of the Manage Cost Pools screen. Costpoint calculates the fee by summarizing the hours incurred on the Manage Open Billing Detail screen and applying the fee per hour entered in this screen.

• Enter Bill Manually — Use this formula if you use the Manage Project Product Bills, Manage Manual Bills, or Manage Milestone/Percent Complete Bills screens to enter your billings. You must set up a record in this screen so that Costpoint recognizes the project as billable. Costpoint cannot calculate the invoice automatically if you use this formula. If you use the Pay When Paid functionality, select the Manual Bills with Unbilled Detail formula.

• LLR W/Fee Plus Non-Labor W/Burden W/Fee — Use this formula to bill hours incurred times a billable rate with a fee on that amount plus non-labor costs and fee on non-labor costs. This is a transaction-based formula. The hours incurred, associated billing rates, and non-labor costs are taken from the Open Billing Detail table. You must run the Load Labor Rates utility before the bill calculates properly. The burden is calculated using the provisional rates from the Pool Rates subtask of the Manage Cost Pools screen. The fee percent is taken from the Labor Fee Percent and Non-Labor Fee Percent fields in this screen. (These fields appear below the Formula drop-down list when you select this billing formula.)

• Labor Cost Times Multiplier Plus Non-Labor Times Multiplier (Cost) — Use this formula to bill costs incurred times a multiplier. This is a transaction-based formula. The Labor and Non-labor cost amounts are taken from the Open Billing Detail table. The cost amounts are multiplied by the Labor Multiplier and Non-Labor Multiplier entered in this screen. (These fields appear below the Formula drop-down list when you select this billing formula.)

• Labor Cost times Multiplier Plus Non-Labor times Multiplier (Hours) — Use this formula to have a multiplier-based billing computed at actual labor rates. This is a transaction-based billing. It is different from the Labor Cost Times Multiplier Plus Non-Labor Times Multiplier (Cost) formula because it computes using actual hourly rates. Costpoint calculates the actual hourly rate by dividing the labor cost by the hours incurred. Costpoint inserts this rate into Open Billing Detail when you run the Load Labor Rates utility. This rate is then multiplied by the multiplier in this screen and then by the number of hours in Open Billing Detail. The purpose of this formula is to show a multiplier billing with an hours-based format.

• Loaded Labor Plus Non-labor Plus Burden On Non-labor — Use this formula to bill hours incurred multiplied by a billable rate and burdened non-labor costs. This is a transaction-based billing. The hours incurred, non-labor costs, and the billing rate are stored in the Open Billing Detail table. The provisional burden rate is stored on the Pool Rates subtask of the Manage Cost Pools screen.

• Loaded Labor Plus Non-labor W/Burden W/Fee — Use this formula to bill hours incurred times a billable rate and burdened non-labor costs with a fixed fee. This is a transaction-based billing. The hours incurred, non-labor costs, and the billing rate are stored in the Open Billing Detail table. The provisional burden rate is stored on the Pool Rates subtask of the Manage Cost Pools screen. You enter the fee that is applied to the non-labor costs in this screen.

• Loaded Labor Rate — Use this formula to bill hours incurred times a billable rate. This is a transaction-based billing. The hours incurred and the billing rate are stored in the Open Billing Detail table. No non-labor costs are billed and no fee or burden is applied when you use this formula.

• Loaded Labor Rate Plus Cost Incurred On Non-labor (T&M) — Use this formula to bill hours incurred multiplied by a billable rate and non-labor costs at actual. This is a transaction-based billing. The hours incurred, non-labor costs, and the billing rate used in the calculation are stored in the Open Billing Detail table. This formula is a standard Time and Materials billing.

• Loaded Labor w/Burden w/Fee Plus Non-labor w/Burden W/Fee — Use this formula to bill hours incurred multiplied by a billable rate with fee and burden, and non-labor costs with fee and burden. This is a transaction-based billing. The hours incurred, non-labor costs, and the billing rate used in the calculation are stored in the Open Billing Detail table. The provisional burden rate is stored on the Pool Rates subtask of the Manage Cost Pools screen. You enter the fee used in the calculation in this screen.

• Manual Bills with Unbilled Detail — Use this formula if you are entering bills on the Manage Project Product Bills, Manage Manual Bills, or Manage Milestone/Percent Complete Bills screens but wish to use the Pay When Paid functionality. The Pay When Paid functionality restricts payment to subcontractors or consultants until you bill your customer and are paid by your customer. The Pay When Paid functionality does not work for fixed-price billings unless you select this formula. If you use this formula, Costpoint populates the Open Billing Detail table when you post transactions. After the bill is posted, the transactions are moved to a transaction history table where they can be flagged as paid or unpaid. No automatic billing calculations are available with this formula.

• Progress Payment — Use this formula to bill using Government Form 1443. If you select this formula, the calculated bill is on the Manage Progress Payment Bills screen and you can print the bill from the Print Progress Payment Bills screen. This is a transaction-based bill. It uses data from the Manage Open Billing Detail screen.

• Rate Schedule Times Multiplier Plus Non-Labor Cost Times Multiplier — Use this formula to bill hours using a variety of billing rates types. With this formula, you must use PLCs with all labor transactions. This is a transaction-based formula. You can set up each PLC to use any of the rate types. This formula effectively allows the labor portion of the billing to be calculated according to who or what group of employees is charging it. Select the Include Labor Multiplier in Billing Rate check box on the Setup Information tab of the Manage Project Billing Information screen to have the labor multiplier calculated in addition to the billing rate. The non-labor section is always computed using a multiplier.

• Unit Price Transactions Only — Use this billing formula to bill only unit transactions.  Selecting this formula prevents transactions that are posted from Accounts Payable, Journal Entries, and Labor Distribution from populating the Open Billing Detail table. If you select this formula, Open Billing Detail is populated only if you select the Post to Billings check box on the Manage Unit Usage screen. You can also use this formula to produce only scheduled bills.

• Table Information

  Changes to this screen update the QPROJ (Quick Project Setup) table.

• FAQs

  At what level of the project should I place my billing formula?

  Evaluate ceilings, billing formula types, customers, and project tasks when choosing a billing level for the project.

  If your project requires billing ceilings based on the contract or funded value of a specific branch of the project tree, you must place the billing formula at the highest level of the project tree where the values exist. For example, if funding is issued by the customer for multiple phases of the project, you must place the ceilings in the project tree at or above the level where the funding for that phase was entered. In this case, the project tree is set up by project phase.

  You must evaluate the need for multiple billing formulas before structuring your project and choosing a billing level. If multiple billing formulas are needed for the project, you must enter the billing formula at level two or below in order for the bills to compute properly.

  If you have multiple customers on this project you may need to enter the billing formulas at level two or below. Costpoint can bill multiple customers without the need for separate tasks. However, the billing requirements for the customers must be identical for this to work properly. If the billing requirements by customer differ, use separate tasks to accommodate the needs of each customer. In this case, you must set up the billing level at level two or below.

  If the project has none of the requirements above, set up the billing at the top level of the project. This is the easiest way to bill.

  What steps should I take if I have posted transactions to this project before l set up a billing formula?

  If you have posted transactions to your project before you established your billing formula in this screen, you must follow some additional steps to bill the project. Use the following steps to enable project billing for this project:

  Evaluate the Manage Open Billing Detail screen for this project. If any transactions exist in this screen for the project in question, you must take them into consideration when you complete the steps noted here. You may want to delete any transactions found on the Manage Open Billing Detail screen so that there is no possibility of duplicate billing

  Set up a transaction-based billing formula on the Manage Project Billing Information screen. A transaction-based billing formula includes all formulas available in this screen except Enter Bill Manually and Unit Price Transactions Only.

  Use the Update Open Billing Detail Records screen to populate the Manage Open Billing Detail screen with transactions for this project. We recommend that you run this utility for only one project at a time. The utility does not evaluate the presence of transactions on the Manage Open Billing Detail screen. It uses the General Ledger Detail table to populate the Manage Open Billing Detail screen. For more information on this utility, see the screen documentation for the Update Open Billing Detail Records screen.

  Can I set up several billing formulas for a single project?

  Multiple billing formulas can be set up within a single project as long as the project is structured so that billing formulas are not stacked. You cannot enter a higher level billing formula if Costpoint finds another billing formula at a lower level of the project tree.

  Structure the project so that the billing formulas can be entered at level two or below and all the tasks below the billing level fall below the desired billing formula type in the project structure.

  What is a transaction-based billing formula?

  A transaction-based billing formula is billed according to the transactions that were charged to the project. The transactions-based billing formulas include all the formulas in this screen except Enter Bill Manually and Unit Price Transactions Only.

  What other options are available for billing projects?

  You can enter manual bills on the Manage Project Product Bills, Manage Manual Bills, or Manage Milestone Percent Complete Bills screens. You must, however, establish a billing record on this screen before you can create manual bills in those screens.

  The Manage Progress Payment Bills screen exists for projects that are billed using Government form 1443.

  Select the Progress Payment formula if you need to produce Government Form 1443.

  Is it necessary to set up a billing record in this screen if I am using one of the manual billing processes?

  You must set up a billing formula for your project in this screen if you intend to bill the project using any of the manual billing processes. Use the Enter Bill Manually formula in most cases.

  If you need to use the Pay When Paid feature, select the Manual Bills with Unbilled Detail formula. This billing formula allows you to use one of the manual billing screens and it populates the Manage Open Billing Detail screen. The data on the Open Billing Detail screen is used to evaluate the "pay when paid" status of individual transactions.