CALCULATE BILLINGS

Use this screen to calculate your Costpoint billings, based on information you have set up in the Project Billing Info screen (Projects » Billing » Billing Master or Projects » Project Setup » Revenue Setup). Once you have calculated billings, you can review them in the screens on the Edit Billings menu.

Refer to Billing Special Topic BL-3, "Calculate Billings," for more information.

Calculate billings after all transactions for the period to be billed have been posted. If you are using cash basis billing, be sure to run the Update Cash Basis Information screen (Projects » Billing » Prepare Billings) before you calculate billings. For system-calculated bills, you must calculate billings before you can edit, print, and post your bills.

Costpoint 6 now has four new tables to improve the processing performance of the Compute Revenue (Projects » Cost and Revenue Processing » Revenue Processing) and Calculate Billings (Projects » Billing » Calculate Billings) applications.  

Costpoint 6 now has four new tables to improve the processing performance of the Compute Revenue (Projects » Cost and Revenue Processing » Revenue Processing) and Calculate Billings (Projects » Billing » Calculate Billings) applications. You must run the Synchronize Project Performance Tables utility (Projects » Cost and Revenue Processing » Utilities) when you upgrade from Costpoint 5.x to version 6 to add existing project data to the four new tables. If you already run version 6, you must run this utility when you receive the service pack that adds the new performance tables. If you upload data using scripts, you also need to run this utility. If you frequently use scripts to upload data, you may need to run this utility at month end, before calculating revenue or standard bills, to ensure that the performance tables are in synch. You can schedule this utility on the process server. Please see the documentation for the Synchronize Project Performance Tables utility for more information.
The new tables are: Project Hierarchy (PROJ_HIERARCHY), Source Project Mapping (PROJ_SRCE_PROJ), Invoice Level Mapping (PROJ_INVC_PROJ), and Revenue Level Mapping (PROJ_REV_PROJ).

Select Subperiod

In this group box, select the fiscal year, period, and subperiod for which you would like to calculate billings. All records up to and including the fiscal year, period and subperiod entered here will be included in the process.

Fiscal Year

Enter, or use the drop-down list to select, the fiscal year for which you want to calculate billings.

Period

Enter, or use the drop-down list to select, the accounting period for which you want to calculate billings.

Subperiod

Enter, or use the drop-down list to select, the subperiod for which you want to calculate billings. Costs posted to the general ledger up through the selected subperiod will be included in the billing calculations. Once you have made your selections, the field to the right will display the date for the selected subperiod

Select Bill Group

Use this group box to select the billing user groups to be included in the billing calculations. Billings will be calculated only for projects that have been assigned one of the selected billing user groups in the Project Billing Info screen (Projects » Billing » Billing Master or Projects » Project Setup » Revenue Setup). This group box is disabled if the Assign Bills to User Groups check box in the Billing Settings screen (Projects » Billing » Controls) is not selected.

Range Option

Use this drop-down list to select the range of billing user groups to be included in the billing calculations. Valid options are:

The default for this field is All.

From

Enter, or use to select, the starting billing user group code for the billing user groups to be included in the billing calculations. If you select All or From Beginning in the Range Option field, this field will be inactive.

To

Enter, or use to select, the ending billing user group code for the billing user groups to be included in the billing calculations. If you select All, One, or To End in the Range Option field, this field will be inactive.

Select Project

Billings will be calculated only for the range of projects you specify in this group box.

Range Option

Use this drop-down list to select the range of projects to be included in the billing calculations. Valid options are:

The default for this field is All.

From

Enter, or use to select, the starting project to be included in the billing calculations. If you select All or From Beginning in the Range Option field, this field will be inactive.

To

Enter, or use to select, the ending project to be included in the billing calculations. If you select All, One, or To End in the Range Option field, this field will be inactive.

Select Billing Cycle

Use this group box to select the billing cycle to be included in the billing calculations. Billings will be calculated only for projects that have been assigned one of the selected billing cycles in the Project Billing Info screen (Projects » Billing » Billing Master or Projects » Project Setup » Revenue Setup). This group box is disabled if the Use Billing Cycles check box in the Billing Settings screen (Projects » Billing » Controls) is not selected.

Range Option

Use this drop-down list to select the range of billing cycles to be included in the billing calculations. Valid options are:

The default for this field is All.

From

Enter, or use to select, the starting billing cycle code for the billing cycles to be included in the billing calculations. If you select All or From Beginning in the Range Option field, this field will be inactive.

To

Enter, or use to select, the ending billing cycle code for the billing cycles to be included in the billing calculations. If you select All, One, or To End in the Range Option field, this field will be inactive.

Invoice Date

Enter an invoice date, or use the system date as the default. This date will display in the Invoice Date field of the Edit Standard Bills screen, where it can be edited. This date will also display in the header of the bill when it is printed.

Calculate Billings

Click this option to calculate invoices. All options on the screen will be available when you click this option. Calculated invoices will be available in the Edit Standard Bills screen (Projects » Billing » Edit Billings) after you run this process.

Calculate Billable Value on Open Transactions

Select this option to calculate the billable value of transactions in Open Billing Detail.  This enables you to analyze the amount that will be billable without regard to ceilings, retainages, sales taxes, scheduled items, or other charges. Only items that reside in Open Billing Detail will be considered when you use this option.  No invoices will be produced. When you select this option, the Include in Process and Include group boxes are unavailable.

The system will create a report table named Z_BLPUBILL_RPT when you run this process. No standard report is available, so you will need a report writer to access the information in this table.  

Calculate Billable value on Unbilled Transactions

This option is available only when the Use Goal Multipliers for Billable Value Calculations check box is selected in the Project Settings screen (Projects » Project Setup » Controls). Select this option to compute the billable value of items in Open Billing Detail using multipliers. When you select this option, the Include in Process and Include group boxes are unavailable.

This process creates a report table called PROJ_GOAL_UNBILL.  No standard report is available when you select this option, so you will need a report writer to access the information in this table. 

Include in Process

Use this group box to select additional processes to be computed during the Calculate Billings process (Projects » Billing » Calculate Billings).

Auto-release on-hold items

Select this check box to release all items on hold for the selected bills. To release only selected items, use the Adjustments in Open Billing Detail screen (Projects » Billing » Prepare Billings).

Create zero retainage and over ceiling rows

Select this checkbox to print retainage or over ceiling lines on your bills, even if the lines do not have any current amounts to bill for these items. Retainage or over ceiling lines with amounts other than zero always print on the bill if they have been formatted to do so. This option allows you to print the lines on the bill even if they are zero. This allows you to edit the over-ceiling and retainage amounts for the current billing amount. Over ceiling rows include over fee ceiling, over cost ceiling, and over total ceiling. You will typically use this option for billing over ceiling amounts after you have received additional funding, or during contract closeout for billing retainage.

Create zero fee rows

Select this check box to print fee lines on your bills, even if the fee lines do not have a current amount to bill. Fee lines with amounts other than zero always print on the bill if they have been formatted to do so. This option allows you to print the fee lines on the bill even if they are zero. This allows you to edit the fee amounts for the current billing amount. Note that there must be a previously billed fee amount in order to create a zero fee row. A zero fee row cannot be created if there has been no fee recognized on a previous bill. You can use this option if you have an award fee billing.

Create zero discount rows

Select this checkbox to print labor and non-labor discount lines on your bills, even if the discount lines do not have a current amount to bill.  When calculating bills, the system creates zero discount rows so that, if the user edits the discount amounts on the bill, the detail bills will equal the total invoice amount due.

The system creates new rows only for projects that have a Discount Method selected in the Project Billing Info screen (Projects » Billing » Billing Master or Projects » Project Setup » Revenue Setup).

Include

Use this group box to customize the data that is calculated on your billings.

Current Activity Only

Select this check box to calculate only those bills that have current activity. If this check box is selected, only those bills that have transactions in the Maintain Open Billing Detail screen (Projects » Billing » Prepare Billings) will be calculated. This will save processing time because Costpoint will not calculate bills for which there is no current activity. Note that if a project ceiling level has been increased, the bill should be calculated even though there have not been any new transactions posted to the project. This will ensure that any "amounts in excess" from previous bills will be billed, up to the new ceiling.

Transactions with zero bill rate

Select this check box to include T&M transactions with a zero billing rate. This can be helpful in identifying missing billing rates.

Transactions with zero cost amount

Select this check box to include transactions with a zero cost amount.

Transactions with zero units quantity

Select this check box to include transactions with a zero unit quantity amount.

Calculate

After you have selected your parameters for billings to be calculated, click to start the billing calculation process.

If you are using discount functionality, the system follows these general rules when calculating bills:

  1. Burdens apply to the amount BEFORE discount.

  2. Discounts apply to the direct cost amounts (or direct cost amounts including burden on the w/burden discount methods).

  3. Fee applies to the total AFTER discount.

  4. Sales Tax applies to the amount AFTER discount.

  5. Retainage applies AFTER discount.

Ceilings:

  1. Account Ceilings are enforced BEFORE discounts are applied.

  2. Project Total Ceilings are enforced AFTER discounts are applied.

Table Information

Source Tables

OPEN_BILLING_DETL

PROJ_BILL_INFO

ACCT_DISC

CUST_VOLUME_DISC

PROJ_VOLUME_DISC

PROJ_INVC_PROJ

PROJ_HIERARCHY

Table Information

Changes to this screen update the following tables:

BILL_EDIT_DETL

BILL_EDIT_INVC_HDR

PROJ_GOAL_UNBILLED