Contents of the Configure Billing Settings Screen

Use the fields and options to configure the Configure Billing Settings screen.

Options

Evaluate the items in this group box when initializing Costpoint. The selections you make here affect what is included on the bill when it is calculated. Modifying these selections after the bill is calculated may require some time-consuming steps to produce an accurate bill.

Field Description
Last Company Wide Invoice No

Enter the last invoice number used. This field defines the starting point for Costpoint-generated bill numbers. Costpoint uses this field to automatically number all invoices. All Costpoint invoices must have a unique invoice number, which is used by Costpoint to keep track of all the detail related to an invoice.

You can use a combination of alphabetic characters and numbers for the invoice numbers, but Costpoint increments only the right-most numeric value. The numeric value to be incremented cannot be followed by any other characters. Keep in mind the number of invoices your company generates when determining how many zeros to include after the alphabetic characters. For example, you may want to have each fiscal year's invoices start with a new number; that is, fiscal year 2001 starts with "FY01-000000" and changes to "FY02-000000" at the start of fiscal year 2002 billings. This allows you to have 999,000 invoices during each fiscal year.

Warning: SQL databases cannot process numbers greater than 2147483647 (2,147,483,647) and therefore cannot use all 15 alphanumeric characters.
Last Usage Document No

Enter the starting point for Costpoint-generated usage document numbers. Costpoint uses this field to automatically number all usage documents entered into Costpoint. All usage documents must have a unique document number, which is used by Costpoint to keep track of all the detail related to a usage document.

You can use a combination of alphabetic characters and numbers, but Costpoint increments only the right-most numeric value. As with the company-wide invoice numbers, the numeric value to be incremented cannot be followed by any other characters. Please keep in mind the number of usage documents your company generates when determining how many zeros to include after the alphabetic characters. (See the numbering example in the documentation for the Last Company Wide Invoice No field.)

Note:

A "usage document" is a basic data entry device, similar to a timesheet, that is used to record the usage of units (for example, hours of computer time or numbers of copies used by a particular project). You create a usage document in Costpoint each time you use the Manage Unit Usage screen to add new "units used" information. This information is then posted to projects, to Costpoint Fixed Assets, and/or to service centers. The unit usage feature works with Costpoint Product Definition, where you can set up items and pricing catalogs for those items. An item is defined as a product, good, or service. For more information on using units in Costpoint, see the "Units" topic.

Enable Project Specific Bill Numbering

Select this check box to have two identifiers for each project invoice, Costpoint-generated company-wide invoice number described previously, and the project-specific bill number. The most common use for this is with government contract billings where the agency requires that bill numbers start with one (1) for each project. Select this check box to enable use of project-specific bill numbers.

You must understand the difference between the terms "invoice number" and "bill number" as they are defined in Costpoint. "Invoice number" refers to the unique system-generated number used by Costpoint for internal tracking. All bills in Costpoint have an "invoice number," and no two invoice numbers are the same. "Bill number" refers to a number assigned to the document sent to the customer.

Include AP Discounts on Invoice

Select this check box to post all discounts taken to the Open Billing Detail file (in Costpoint Billing) during the cash disbursement posting process. This enables you to pass along discounts received from vendors to your customers. This feature is relevant only if you are using the Gross method of posting AP discounts. With this method, the discount is taken when the checks are produced and is posted to Open Billing Detail when the cash disbursement is posted, if the check box is selected. If you do not select this check box, the discount is not posted to Open Billing Detail. If you use the Net method of posting AP discounts, the discount is posted when the voucher is posted. This check box is not relevant when using the Net method.

Suppress Detail History

Select this check box to suppress previously billed amount information found on the Detail subtask of the Manage Standard Bills screen. If this check box is not selected, the Detail subtask contains information rows for both current and previously billed amounts. If you select this check box, the previously billed amount rows are suppressed and you can review only the rows for current amounts to bill on the Detail subtask. Selecting this check box generally results in faster access times to the Detail subtask. Note that the Inception-to-Date (ITD) columns on the main screen of Manage Standard Bills are not affected by this option.

Assign Bills to User Groups

Select this check box to assign users to a billing group on the Manage Billing User Groups screen. This check box is selected by default. If you do not select this check box, Costpoint deletes any data already entered in the Billing User Group field on the Manage Project Billing Information screen. If you leave this check box selected, the Billing User Group field is required on the Manage Project Billing Information screen. If you select this check box after setting up some of the Project Billing Information screens without the user group information, you must enter the correct billing groups for all records previously entered. 

Edit PLC in Open Billing Detail

Select this check box to enable editing of the PLC field on the Labor tab of the Manage Open Billing Detail screen. The PLC is posted to Open Billing Detail when the original journal is posted in Labor, Accounts Payable, or Journal entries. The General Ledger and all other related tables store the PLC as it exists on the original posting. If you allow the PLC field to be edited, you get inconsistencies in the database tables. Give careful consideration to this issue before you enable this functionality. 

Recalculate Detail Rows

If you select this check box, Costpoint recalculates all detail rows so they "foot" for the current billed amount displayed on the summary invoice. The default for this check box is cleared. Selected, it becomes non-editable.

The recalculation occurs only if the following conditions are met:

  • The project must have a Loaded Labor Rate billing formula.
  • The Show Billing Rates and the Show Current Period Hours Billable check boxes must be selected for the project on the Hours tab of the Manage Generic Billing Formats screen. This causes the invoice to display billing rates and current period hours. Projects that have the Govt 1035 Billing Format and the Print Using T&M Format options selected on the Manage Project Billing Information screen are also included.
  • The invoice must be computed using the Calculate Standard Bills screen.

No recalculation takes place for billing rate types of A (Actual). The Rate Type is determined on the Link Project Labor Category Rates to Projects screen.

No modifications are made to amounts that were previously billed. Therefore, the previously billed hours times the billing rate may not "foot."

This recalculation is performed for the current amount to bill only. If cumulative amounts display on an invoice, they are the sum of the previous amounts billed plus the current amount to bill and are not recalculated.  

During the recalculation process, adjustments may be made to the detail lines. Because of this, any detail invoices or supporting schedules used as backup for the invoice may have lines that do not "foot" across but in total agree with the invoice they support.  

Example

If you do not select the Recalculate Detail Rows check box, Costpoint computes invoices based on the sum of the detail lines. If you format the summary invoice so that the detail lines do not display (for example, the timesheet date does not display) and the hours and billing rates display, the resulting hours times the billing rate may not equal the amount to bill. This is illustrated as follows:

You enter five transactions for a PLC rate of 37.27 per hour. One transaction does not have a timesheet date because it was entered through Accounts Payable.

Timesheet Date Project Employee Hours Rate Billed Amount
02/01/2007 RNDG.01 Asaka 28.81 37.27 1,073.75
02/05/2007 RNDG.02 Beemer 29.39 37.27 1,095.37
RNDG.02 ABC 30.23 37.27 1,126.67
02/10/2007 RNDG.01 Asaka 24.91 37.27 928.40
02/10/2007 RNDG.02 Beemer 26.32 37.27 980.95
139.66 5,205.14

If you format the summary invoice to display only the billing rate and the hours billed, the result is as follows:

Hours Rate Billed Amount
139.66 37.27 5,205.14

The invoice displays the amount billed as the sum of the billed transactions. However, the invoice does not "foot" across (139.66 * 37.27 = 5,205.13). This causes an issue for customers who refuse to pay an invoice that does not appear to be computed correctly.  

If you select the Recalculate Detail Rows check box, Costpoint multiplies the sum of the Hours (139.66) by the rate (37.27) to obtain a billed amount of 5,205.13.

If detail lines are recalculated, detail invoices and supporting schedules may no longer "foot" across, but the detail invoices and supporting schedules in total agree with the summary invoice. It is important to note that no modifications are made to amounts that were previously billed. Therefore, previously billed hours times the billing rate may not "foot."

Allow Cash Receipt Creation in Reverse Previous Bills

Select this check box to allow the creation of net-zero cash receipts on the Reverse Previous Bills screen. For example, net-zero cash receipts can be created for Intercompany Work Order bills.

Note: The value in this check box is not copied when you set up a new company through the Set Up Company screen. Newly set up companies will have a default value of N or have this check box clear or unselected.
Validate Same Invoice ID in Closed Periods/IWO Project in Reverse Previous Bills

This check box is selected by default. Keep it selected to enforce validation when reversing same invoices in closed periods or for inter-company work order (IWO) projects on the Reverse Previous Bills screen.

If you clear this check box, Costpoint displays the following message: "When this validation is removed, reversing using the same invoice number removes all history of the original bill from the billing tables regardless of the period in which it was originally posted."

Billing Cycles

Billing cycles group bills according to the time that they are billed. Cycle codes are generally monthly, quarterly, bi-monthly, and so forth. After you set up the billing cycles, you can calculate, print, and post bills by billing cycle. Billing cycles can facilitate the billing process if a large number of bills from multiple cycles are being processed at the same time. If you select the Use Billing Cycles check box, the Billing Cycles field on the Manage Project Billing Information screen is required. If you select the Use Billing Cycles check box after setting up some of the Project Billing Information screens, you need to enter the correct billing cycles for all records previously entered. 

Field Description
Use Billing Cycles

If you select this check box, you can assign billing cycle codes to each project on the Manage Project Billing Information screen. Projects that have billing cycle codes can then be selected and calculated based upon their billing cycles. You must first set up billing cycles on the Manage Billing Cycles screen before you can enter them on the Manage Project Billing Information screen.

Default

Use the drop-down list to select the default billing cycle for project billings. If the majority of your customers or projects are billed on the same cycle, you can select that cycle as the default. If your projects are billed using many different cycles, you may not want to enter a default. The default cycle you choose must first be set up on the Manage Billing Cycles screen.

Billing Defaults

Your selections in this group box are used as defaults (which can be overridden) when you enter records on the Manage Project Billing Information screen. Using these defaults to populate the Manage Project Billing Information screen can greatly expedite the billing setup process. These defaults are not required in the Billing Settings screen.

Field Description
Remittance

Use the drop-down list to select the default remittance address to which customer payments are sent. You can set up remittance IDs on the Manage Remittance Addresses screen. Remittance addresses are required on the Manage Project Billing Information screen. If you do not select a default, you must enter remittance addresses individually on each Manage Project Billing Information record.

Billing Format

Use the drop-down list to select the default billing format that your projects use. If you have many different formats, you may want to leave this field blank so that you do not accidentally print the wrong format on a given bill. You can set up billing formats on the Manage Generic Billing Formats screen. 

Payment Terms

If you want to assign default payment terms to your projects, enter, or use the drop-down list to select, the default terms code here. You can set up terms on the Manage Customer Terms screen.

Sales Tax Code

Enter, or use the drop-down list to select, the default sales tax code that you want to apply to your billings. You can set up sales tax codes on the Manage Sales or Value Added Taxes screen.

Shipping Method

Enter, or use the drop-down list to select, the default shipping method you want to use when entering sales order entries. This field does not apply unless you have the optional module, Costpoint Sales Order Entry, located in the Materials folder.

1443 Postings

Use this group box to control how invoice postings are handled. This group box applies to projects that bill using government form 1443, Contractor's Request for Progress Payment.

Field Description
Delivery Invoices at Net Amount

Select this check box if the 1443 Delivery Invoice posting method is Net (instead of Gross). If you bill using progress payments, you can submit interim bills to recover a percentage of your incurred costs, even if deliveries have not been made. When you ship a finished good to the customer, the bill is a "Delivery" invoice. This invoice shows the value of the shipment, but you must reduce, or "liquidate," an amount for the progress bills that have already been paid. Therefore, the invoice amount that is paid is always the net amount.

If you select this check box, Costpoint posts the general ledger and accounts receivable reports with the net amount. This means a receivable is created for the net amount and the liability reduced for the liquidation amount when the bill is posted. When the customer pays the bill, the cash receipt credits the receivable for the net amount.

If this check box is not selected, Costpoint posts the general ledger and accounts receivable reports with the gross amount. This means a receivable is created for the gross amount of the shipment. When the customer pays the bill, the cash receipt credits the receivable for the gross amount and reduces the liability by the liquidation amount.

In summary, this check box controls the presentation of billed accounts receivable and liquidated progress payments for delivery invoices that have not been paid.

For more information, see the "Progress Payment Bills" topic.

Progress Bills to GL When Billed

Select this check box to treat progress payment bills like non-progress payment bills. Progress payment bills are interim bills that allow you to recover a percentage of your incurred costs, even if deliveries have not been made. As such, these bills generate a receivable for the amount of the bill, but they also generate a liability, because you are billing for amounts that have not been delivered.

When you post the bill, not only are the accounts receivable and project billing history files updated, but the general ledger files are also updated. The A/R progress payments account is debited and, instead of using unbilled A/R as the other side of the entry, Costpoint credits the unliquidated progress payments account to create the liability. When the customer pays the bill, cash is debited and the A/R progress payments account is credited. Using this method means that your financial statements show an A/R progress payments receivable balance for any unpaid progress payment bills. It also shows the unliquidated liability when the bill is posted.

If you do not select this check box, the accounts receivable and project billing history files are still updated when the bill is posted, but no entry is made to the general ledger; consequently, outstanding progress payment accounts receivable are not displayed on your financial statements. When the customer pays the bill and you post the cash receipt, the entry debits cash and credit the unliquidated progress account. With this option, the A/R progress payments account is not used, and the liability is not displayed on your financial statements until you post the cash receipt. You can suppress progress payment bills when printing the Accounts Receivable Aging Report. This enables you to reconcile the aging report to the general ledger if you do not select this check box.

Cost of Sales Accrual

Use this group box to determine the cost of sales accrual method for units. You can retain the cost of the units on your balance sheet, as a capitalized or inventoried cost, and can recognize a portion of that cost as the units are billed (when the bill is posted) or as they are "incurred" (when the unit usage is posted). Using either method, a transfer is made during the posting to move the unit cost of sales from the balance sheet to the income statement. Note that a warranty expense accrual can be optionally posted as part of this entry.

Field Description
Billed

Select this option to recognize unit cost of sales when the bill is posted.

Incurred

Select this option to recognize unit cost of sales when the unit usage is posted.

Units Usage User Defined Field Labels

These labels are used as column headings on the Manage Unit Usage screen. Next to each data type, enter a label that is appropriate for that data type. For example, for one of the numeric labels, you could enter "Units Remaining." You can enter labels for two numeric fields, one text field, and one date field.

ACRN Options

Use this group box to set up options for ACRN bills.

Field Description
Enable ACRN Billing

Select this check box to allow processing of ACRN bills and access to the applicable ACRN Bill tables. Selecting this check box enables the following screens:

  • The Manage ACRN Bills screen, where you can establish the ACRN billing information.
  • The Calculate ACRN Bills screen, where you calculate ACRN billing amounts based upon the ACRN billing information established on the Manage ACRN Bills screen and invoice amounts calculated by the Calculate Standard Bills screen.
  • The Print ACRN Billing Edit Report screen, where you review initialized and/or calculated project ACRN allocation amounts.
ACRN Warnings With Modifications Changes

Select this check box to show ACRN warning messages on the Manage Modifications screen and on the Mods subtask of the Manage Project User Flow screen when you enter new funding modifications or change existing funding modifications. This option is enabled if you select the Enable ACRN Billing check box.

Track ACRN Change History

Select this check box to track the changes made to ACRN billing details. This option is enabled if you select the Enable ACRN Billing check box.

iRAPT Options

Use this group box to choose the default output path for your iRAPT files. If you plan to use project product bills (rather than standard bills) as your source for iRAPT files, you can also use this group box to enable iRAPT entry on the Manage Project Product Bills screen.

For more information, see the "Invoicing, Receipt, Acceptance and Property Transfer" topic. 

Field Description
Default Output Location

Enter, or click to select, a default output path for your Invoice, Receipt, Acceptance and Property Transfer (iRAPT) files. This path is used as the default on the Create iRAPT Billing Files screen.

Enable Project Product Bills for iRAPT

If you plan to use project product bills (rather than standard bills) as your source for iRAPT files, select this check box to make certain fields and subtasks available for iRAPT entry on the Manage Project Product Bills screen. If you do not select this check box, these fields and subtasks are hidden. See the documentation for the Manage Project Product Bills screen for more information. This check box defaults as cleared.

Consolidated Standard/Retro Billing Options

Field Description
Allow Consolidated Standard/Retroactive Bills

Select this check box to allow consolidated standard and retroactive bills. If you do not select this check box for the company in which the Calculate Standard Bills application is being run, then the new options to calculate retroactive bills with the standard bills will not be enabled and will not show on the Calculate Standard Bills screen.

Note: If this check box was previously selected, and you clear it after combination bills have been created and/or posted, no new consolidated standard and retroactive bills will be calculated.

Labels for Print Standard Bills

Use this group box to specify the labels for retroactive and current bills that will print on the invoice. This group box is enabled only if you select the Allow Consolidated Standard/Retroactive Bills check box.

Field Description
Text for Current FY True-Up

Enter the text that will print on the invoice for the current fiscal year true-up.

Position of Fiscal Year Code

Use this drop-down list to select the position of the fiscal year code relative to the text you specified in Text for Current FY True-Up. Valid options are First and Last.

Text for Prior FY True-Up

Enter the text that will print on the invoice for the prior fiscal year true-up.

Position of Fiscal Year Code

Use this drop-down list to select the position of the fiscal year code relative to the text you specified in Text for Prior FY True-Up. Valid options are First and Last.

Milestone/Percent Complete Bills

Field Description
Allow Percent Complete to Exceed 100% on Individual Lines

Select this check box to allow percent complete values exceeding 100% on the Manage Milestone Percent Complete Bills screen.

Subtask

Subtask Description
Selected Billing Formulas Click this link to open a subtask where you can select the billing formulas you would like to use for your company.