Pool Base Subtask

Use this subtask to specify the base accounts, debit allocation accounts, and variance accounts/organizations for a given cost pool.

A base account/ organization combination must be attached to an allocation account/ organization combination. The Base account/organization specifies where the specific amount or hours that form the denominator of the pool reside. The allocation account/organization specifies where the allocation amounts that result from the pool calculation reside. The allocation amount that is transferred for each base account/organization combination is calculated as follows:

                              COST ACCOUNT/ORG (AMOUNT)

Rate =  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -   

              BASE ACCOUNTS/ORGS (AMOUNT or HOURS or UNITS)

Rate * INDIVIDUAL BASE ACCOUNT/ORG = ORG ALLOCATION AMOUNT

You can set up variance account/organization combinations at the pool level using the Default Accounts subtask, or you can use this subtask to set them up separately for each allocation account/organization. Variance account/organization combinations specify where the difference between allocation amounts at actual rates versus those at target rates is posted.

Use this subtask when initializing a cost pool or service center. For service centers whose calculation method is manual (rather than automatic), no entry of base accounts is required here (use the Manage Allocation Journals screen instead). After you initialize base accounts, use this screen only to make modifications. You can expedite the setup of your base accounts using the Manage Base Creation Setups screen and the Create Pool Links screen. See the documentation for those screens for more information on these processes.

Warning: Changing the base of an existing cost pool can cause problems with your revenue and/or burden calculations. You may need to make adjusting journal entries or perform other steps to ensure correct calculations. Timing can also be critical when making cost pool modifications. If you need to modify the pool base for an existing (functional) cost pool, first contact Costpoint General Support for assistance.

Contents

Field Description
Group Number

This non-editable field displays the allocation group number from the main screen.

Pool Number

This non-editable field displays the pool number from the main screen. The adjacent field displays the name of the pool.

Fiscal Year

This non-editable field displays the fiscal year from the main screen. You can modify the data (including base/allocation/variance account/organization combinations) for a given cost pool each fiscal year.

Account/Organization Table

Click to populate this table. You can combine multiple select statements by selecting the And/Or options, then clicking Add to update your subquery. To display the number of rows in your new result set, click the Count button. To update the Account/Organization table window, click OK. closes and returns you to the populated Account/Organization table window.

Field Description
Account

This column displays the accounts you selected by clicking . These accounts, in combination with the selected organizations, must be active for the Fiscal Year displayed.

Organization

This column displays organizations you selected by clicking . These organizations, in combination with the selected accounts, must be active for the Fiscal Year displayed.

Account Name

This non-editable column displays the name of the account displayed in the Account column.

Organization Name

This non-editable column displays the name of the organization shown in the Organization column.

Select

To select an account/organization from the table, click the Select button while highlighting the account/organization that you want to add. The account/organization displays in the pool base account/organization table located in the right half of the screen.

Deselect

To remove an account/organization from the pool base account/organization table, click the Deselect button while highlighting the account/organization that you want to delete.

Selected Account/Organization Table

Use the Select and Deselect buttons to populate this table.

Field Description
Base Account

Click the Select button to add accounts to this column. These accounts, with the selected base organizations, form the base portion of the pool displayed, and must be active for the Fiscal Year displayed.

Base Organization

This column displays organizations linked to accounts selected in the Base Account column. These organizations, with the selected base accounts, form the base portion of the pool displayed, and must be active for the Fiscal Year displayed.

Allocation Account

Enter, or click to select, the allocation account. These accounts form the account part of the recipient account/organization combination that receives the allocated amounts for each of their respective base account/organizations. All accounts selected must be active for the Fiscal Year displayed. You cannot include an account that has the Project Required > check box selected on the Manage Accounts screen unless the cost pool is an automatic service center. The default allocation debit account from the Default Accounts subtask initially displays in this screen, where you can modify it.

Allocation Organization

Enter, or click to select, the allocation organization. These organizations form the organization part of the recipient account/organization combination that receives the allocated amounts for each of the respective base account/organizations. All organizations selected must be active for the Fiscal Year displayed. The default allocation debit organization from the Default Accounts subtask initially displays in this screen, where you can modify it.

Base Organization Name

This column displays the name for the base organization.

Base Account Name

This column displays the name for the base account.

Allocation Ref 1

Enter, or click to select, the allocation reference 1. These reference numbers receive the allocation portion for each of the respective base account/organizations. Initialize Reference 1 in this screen only if reference numbers are used in data entry. The default allocation reference 1 account from the Default Accounts subtask initially displays in this screen, where you can modify it.

Allocation Ref 2

Enter, or click to select, the allocation reference 2. These reference numbers receive the allocation portion for each of the respective base account/organizations. Initialize Reference 2 in this screen only if reference numbers are used in data entry. The default allocation reference 2 from the Default Accounts subtask initially displays in this screen, where you can modify it.

Cost Variance Account

Enter, or click to select, the cost variance account. These accounts form the account part of the account/organization combination that is used to post the difference between actual and target rates to the Income Statement for each of the respective base account/organizations. All accounts selected must be active for the Fiscal Year displayed. Cost variance accounts cannot include accounts that have the Project Required check box selected on the Manage Accounts screen. The default cost variance account from the Default Accounts subtask initially displays in this screen, where you can modify it.

Cost Variance Organization

Enter, or click to select, the cost variance organization. These organizations form the organization part of the account/organization combination that is used to post the difference between actual and target rates to the Income Statement for each of the respective base account/organizations. All organizations selected must be active for the Fiscal Year displayed. The default cost variance organization from the Default Accounts subtask initially displays in this screen, where you can modify it.

Cost Variance Ref 1

Enter, or click to select, the cost variance reference 1. These reference numbers receive the cost variance portion for each of the respective base account/organizations. Initialize Reference 1 only if reference numbers are used in data entry. The default cost variance reference 1 from the Default Accounts subtask initially displays in this screen, where you can modify it.

Cost Variance Ref 2

Enter, or click to select, the cost variance reference 2. These reference numbers receive the cost variance portion for each of the respective base account/organizations. Initialize Reference 2 only if reference numbers are used in data entry. The default cost variance reference 2 from the Default Accounts subtask initially displays in this screen, where you can modify it.

Receivable Variance Account

Enter, or click to select, the receivable variance account. These accounts form the account part of the account/organization combination that is used to post the difference between actual and target rates to the Balance Sheet (Unbilled Receivables) for each of the respective base account/organizations. All accounts selected must be active for the Fiscal Year displayed. Receivable variance accounts cannot include accounts that have the Project Required check box selected on the Manage Accounts screen. The default receivables variance account from the Default Accounts subtask initially displays in this screen, where you can modify it.

Receivable Variance Organization

Enter, or click to select, the receivable variance organization. These organizations form the organization part of the account/organization combination that is used to post the difference between actual and target rates to the Balance Sheet (Unbilled Receivables) for each of the respective base account/organizations. All organizations selected must be active for the Fiscal Year displayed. The default receivable variance organization from the Default Accounts subtask initially displays in this screen, where you can modify it.

Receivable Variance Ref 1

Enter, or click to select, the receivable variance reference 1. These reference numbers receive the receivable variance portion for each of the respective base account/organizations. Initialize reference 1 only if reference numbers are used in data entry. The default receivable variance reference 1 from the Default Accounts subtask initially displays in this screen, where you can modify it.

Receivable Variance Ref 2

Enter, or click to select, the receivable variance reference 2. These reference numbers receive the receivable variance portion for each of the respective base account/organizations. Initialize reference 2 only if reference numbers are used in data entry. The default receivable variance reference 2 from the Default Accounts subtask initially displays in this screen, where you can modify it.