PROJECT SETUP TIPS - Special Topic PJ-3

Although setting up a project can be tedious and time-consuming, knowing which pieces of information have to be entered immediately in order to make the system function properly, and which ones are optional, can lighten the load tremendously. This discussion is intended to provide the correct sequence for setting up information in Costpoint Project Setup, and also to show which information is required and which information is optional.

Before entering any data in Costpoint Project Setup, enter your complete Chart of Accounts, including all organizations and reference numbers, in Costpoint General Ledger. You do NOT need to set up indirect cost pools before entering data in Costpoint Project Setup.

You can set up a project in either the Maintain Project Master screen (Projects » Project Setup » Project Master) or the Basic Info screen (Projects » Project Setup » Project Master). The Maintain Project Master screen contains subtask links to other project setup functions such as project revenue, billing, project labor, etc. In the Basic Info screen, you can only set up the project.

1.  Set up Screens in the Controls Menu

Pay special attention to the Project Settings screen (Projects » Project Setup » Controls), the Project Account Groups screen (Projects » Project Setup » Controls), and the Maintain Project Types screen (Projects » Project Setup » Controls).

Use the Project Settings screen to control such things as:

Any account groups that you set up here will appear as selections when you set up projects in the Maintain Project Master screen (Projects » Project Setup » Project Master) or the Basic Info screen (Projects » Project Setup » Project Master), and the accounts you include in each account group will be the ONLY accounts you can charge on a project.

You must set up at least one account group before you enter a project in the Maintain Project Master screen (Projects » Project Setup » Project Master) or the Basic Info screen (Projects » Project Setup » Project Master) because the project account group is a required field in these screens.

Use the Maintain Project Types screen to identify a project type that will be associated with each project in the Maintain Project Master screen (Projects » Project Setup » Project Master) or the Basic Info screen (Projects » Project Setup » Project Master). Project Types are user defined; some examples are Cost Reimbursable, Time & Materials, Fixed Price, Level of Effort, etc. The system will use the type when printing various reports such as A/R Aging. When you print the A/R Aging report (Print Accounts Receivable Aging Report screen (Accounting » Accounts Receivable » Reports)), you can sort on the project type.

Use the Project User-Defined Labels screen (Projects » Project Setup » Controls) to furnish labels for each user-defined field in the User-Defined Info screen (Projects » Project Setup » Project Master). The use of user-defined fields is optional, and you can use them to track information about a project that is not already tracked by the system.

Use the Maintain Project/Account Validation screen (Projects » Project Setup » Controls) and the Maintain Project/Organization Validation screen (Projects » Project Setup » Controls) to establish your charging criteria. These screens are necessary only if you have selected the Limit Orgs or the Limit Accounts check boxes in the Maintain Project Master screen (Projects » Project Setup » Project Master) or the Basic Info screen (Projects » Project Setup » Project Master).

2.  Set Up All Applicable Project Master Screens

At a minimum, you should enter data in the Maintain Project Master screen (Projects » Project Setup » Project Master) or the Basic Info screen (Projects » Project Setup » Project Master), including any needed charging criteria screens, the Modifications screen (Projects » Project Setup » Controls), and the Government Contract Info screen (Projects » Project Setup » Project Master).  The charging criteria screens include Maintain Valid Project/Account/Orgs (Projects » Project Setup » Project Master), Maintain Project/Account Validation (Projects » Project Setup » Controls), and Maintain Project/Organization Validation (Projects » Project Setup » Controls).  These screens are needed depending on your selections in the Charging Criteria group box in the Maintain Project Master screen (Projects » Project Setup » Project Master).

In the Maintain Project Master or Basic Info screens, enter projects from the top down. This means that, if you have a project with two levels (a summary level and a detail or cost-collection level), you must enter the summary level before the detail level.

When you enter the summary, or top, level, in the Project Levels Setup subtask, you must enter all the information that describes the number of levels that the project will have, and the length and description of each level. Remember that the Length of the top level is fixed at the number of digits that you entered in the Project Settings screen. The length of any other levels (level 2 and below) can vary from project to project.

An example of what might go in the level table for a two-level project is as follows:

Level

Length

Description

1

4

Project

2

3

Task

For a four-level project, the table might look like the following:

Level

Length

Description

1

4

Project

2

2

Task

3

3

Location

4

3

Work Order

 

Other information that is required for project setup:

3.  Assign Accounts Subtask

Use this subtask to control the creation of valid project/account/organization combinations for charging purposes. It is required only if you have selected the Limit which Orgs can charge specific Accts check box or the Limit Account to P/O/A check box. You will need to use this subtask only when setting up a project node that is chargeable or will have revenue or billing postings. 

Although the posting of billings does not depend upon the existence of a BILLED A/R account at the project level, in order to enter a cash receipt against the BILLED A/R account, you must assign the account to the project at the level at which the billing/cash receipt will be posted. In addition, if you are using a Revenue Formula of Equal to Project Ledger Sales, you should assign revenue accounts to the project.

You need to assign accounts to projects only if they will be entered on a maintenance screen, which for the Revenue, Billed, or Unbilled accounts might include Cash Receipts, Journal Entries, etc.; however, you do not need to assign them to post bills or revenue. You must always assign cost accounts to projects at the level at which charging will occur.

Additionally, for each summary level of the project at which you would like to have charging occur, you should also select charge accounts from the account group. A summary level of a project can have revenue and/or billing postings, and direct labor and ODC postings. You can post to any level of a project where valid project/account/org combinations exist. Keep in mind that only charges at or below the revenue and billing level will be included in revenue or billing calculations.

4. Set Up the Modifications Screen

Use this screen in Costpoint Project Setup to enter the signed Value of the contract (Value Modifications group box), the amount of funding for the contract (Funding Modifications group box), and the Period of Performance. Enter the initial signed value, funded value, and period of performance as Modification 0000. Enter all subsequent modifications with the Modification Number received by the client. The information entered on this screen will default onto the Basic Info screen (Projects » Project Setup » Project Master), the Basic Revenue Info screen (Projects » Project Setup » Revenue Setup), and the Project Billing Info screen (Projects » Billing » Billing Master or Projects » Project Setup » Revenue Setup).

Additionally, you can use the signed and funded values as a ceiling for revenue and billing calculations. The Period of Performance is used as a soft edit for timesheet entry. If you do not want the Period of Performance to be used as a soft edit, you can turn off this feature in the Project Settings screen.

If you do not enter any modifications, no ceilings will exist for revenue or billings, and no value will be printed on reports (Project Status Reports, Contract Revenue/Cost Summaries, etc.).

5. Set Up the Government Contract Info Screen

Nothing on this screen is required unless you selected the Require Incurred Cost Submission Code for all Projects check box in the Project Settings screen (Projects » Project Setup » Controls) (Step 1). If you selected this check box, you must select an Incurred Cost Submission Code for every single project you set up, regardless of type (even indirect projects).

If you did not want an incurred cost submission prepared, you should still indicate whether to apply cost of money rates to the project, whether to use project labor categories for wage determination rates, and also whether you have a DPAS rating.

If you plan to use project or customer volume discounts, you must also select the Include in Aggregate Volume check box.

6. Set Up Other Applicable Screens

This includes:

7. Set Up Labor Categories for Time and Materials Projects and Level of Effort Projects

This step is not required unless the categories that you use for tracking and billing costs on a project are different than the general labor categories you assigned each employee in the Employee Master file. If you do need to track employee charges in different categories, you must set up those project labor categories in the following order:

8. Set Up Revenue Information

You must select a Revenue Formula in the Basic Revenue Info screen (Projects » Project Setup » Revenue Setup) if you want the system to calculate revenue for the project. You must also identify any additional information required for that formula (fee percents, fee amounts, fixed or backlog amounts, discount method, etc.), and determine whether revenue is allowed to exceed the signed value and be posted as at-risk revenue. Additionally, you must set up accounts with a function code of REVENUE and UNBILLED-GENERL (Step 3) to allow for the posting of revenue. Other information required for successful revenue setup includes:

9.  Set Up Discounts

There are seven discount methods that can be set up in the Basic Revenue Info screen (Projects » Project Setup » Revenue Setup). They include PLC discounts, account discounts, account discounts w/burden, aggregate volume by customer, aggregate volume by customer w/burden, aggregate volume by project, and aggregate volume by project w/burden. Each has additional setups that must occur to ensure calculation.

Discount Defaults - If you elect to use PLC discounts, certain discount default fields become available in the Other Info subtask of the Project Billing Info screen (Projects » Billing » Billing Master or Projects » Project Setup » Revenue Setup).  Using these fields, you can link a T&M project that has been established in the Project PLC Rates screen to the project you are setting up.  When you save the record, the system copies the Assign PLC to Projects screen and the Project PLC Rates using the T&M Project and discount percentage entered.  

If you use this method, the system sums the total funded value for all projects where the Include in Aggregate Volume check box is selected and that have the same customer in the Customer field of the Maintain Project Master screen (Projects » Project Setup » Project Master). The resulting funded value is compared to the rows in the Maintain Customer Volume Discounts screen (Projects » Billing » Billing Master) to find the row where the resultant value is between the starting and ending sales volume. The discount percentage on that row is applied to accounts in the Accounts subtask.

The calculation for this discount method is identical to the Aggregate Volume by Customer method except the discounts are held by project, rather than by customer.  This allows you to aggregate the sales volume by customer but give specific discounts by project.  You can enter aggregate project volume discounts at multiple levels of the project. However, the discount record that resides closest to the transaction level project is used, if possible.  If there are transaction accounts within the invoice that are not included in the Accounts subtask at this level, the system checks for discount records at each level of the project (up to the invoice level project) until a record is found that contains the account.  If no record is found, no discount is applied to the account.

10. Set Up Cost of Goods Sold (if applicable)

If the Project Classification that you selected in Step 2 was WIP or INVENTORY, you should select a method of COGS calculation in the Cost of Goods Sold screen (Projects » Project Setup » Revenue Setup) and provide any additional information required by the formula that you selected. For example, if you selected a "Fixed Monthly Amount" as the Calculation Method, you must provide the Fixed Monthly Amount. Additionally, you must set up accounts that have a function code of COST OF GOODS SOLD or WIP TRANSFER (Step 3). This will allow for the calculation and posting of COGS.

11. Set Up Cost and Hours Ceilings

If the project has ceilings on hours, cost, or indirect rates, for either billing or revenue calculation purposes, you must next set up those ceilings. For labor hour ceilings, enter the ceiling by either labor category or by employee or vendor within a labor category.

12. Set Up Prior Fiscal Year History

Several screens contain prior fiscal year history:

You may need to set up pool names and numbers in the Cost Pools screen (Projects » Cost and Revenue Processing » Cost Pool Setup) before entering data on this screen - you can select only valid pool numbers.

13. Set Up Billings

This process will be described in more detail in the Special Topics for Costpoint Billing. At the very least, it will involve setting up the Project Billing Info screen (Projects » Billing » Billing Master or Projects » Project Setup » Revenue Setup).

All of these screens are used to control processing within Costpoint Cost and Revenue Processing, Inquiry and Reporting, and the Billing. You can enter optional data at any time, and you can even enter required data in a leisurely fashion, depending upon which processes you want to use. For example, if you do not need to calculate billings right away, you can delay setup of the Project Billing Info screen, or if you do not have hours ceilings and do not require contract-to-date totals on your Project Status Reports, you can delay entering Labor History. However, in the long run, the more complete your setup is, the more accurate all of the processes and reports will be.