Update the Cash Balance Accrual Position

In the Interest on Cash Balances - Update Accrual Position panel, you can manually open and update the cash balance position in the Cost object that is used for daily accruals. This panel allows you to accumulate cash balances in the Settled Cash Balance table by entity and cash account, and creates a cash balance accrual position in the Cost object with one open lot. The position has quantity but zero cost, and is not priced.

After you perform the setup for cash balance accruals, you can open and update the cash balance position in the Cost object that is used for daily accruals. The first time you use this option, you establish the cash balance accrual position. After the position is established in the Cost object, you use this option to insert an adjustment row in the Cost object to adjust the position up or down when the settled cash balance changes. This provides a history of the daily adjustments to the cash balance position. You can schedule this process to run on a regular basis.

To update cash balance accrual positions manually:

  1. In Accounting Center, in the left navigation pane, click Processing and Exceptions > Global Processes > Earnings > Interest on Cash Balances - Update Accrual Position.

    You see the Interest on Cash Balances - Update Accrual Position panel.

  2. Complete the options on the Interest on Cash Balances - Update Accrual Position panel.

  3. Click Submit.

The first day you use this option, the system establishes the cash balance accrual position. When you use Position Viewer to view the Cost position for your cash balance accrual security, note that it has a value for Units, but no cost values, and the Open Lots tab shows a single open transaction. On each ensuing day after you use the Cash Balances - Update Accrual Position option, when you use the Position Viewer tool to view the Cost position for your cash balance accrual security, the position Units have increased by the amount of the settled cash, and the Open Adjustments tab shows an adjustment for the amount of the settled cash. For more information, see View Cash Balance Accrual Positions.

Interest on Cash Balances - Update Accrual Position Panel Options

In the global Interest on Cash Balances - Update Accrual Position panel, you can update cash balance positions manually. The options may vary according to your selections.

Option

Tag

Description

Option

Tag

Description

Update Cash Balance/Position

 

 

Select Query Option

2283

This option determines how to apply the position update, as follows:

  • One Entity/One Cash Account

  • One Entity/All Cash Accounts

  • All Entities/One Cash Account

  • All Entities/All Cash Accounts

Entity Information

 

 

Entity ID

1163

Specifies the identifier of the entity. It appears when you select One Entity/One Cash Account or One Entity/All Cash Accounts in the Select Query Option field.

Entity Name

1164

Specifies the name of the entity. It appears when you select One Entity/One Cash Account or One Entity/All Cash Accounts in the Select Query Option field.

Cash Account Information

 

 

Cash Account Name

11696

Specifies the name of the cash account for the custodian. It appears when you select One Entity/One Cash Account or All Entities/One Cash Account in the Select Query Option field.

Cash Account Number

11697

Specifies the account number of the cash account for the custodian. It appears when you select One Entity/One Cash Account or All Entities/One Cash Account in the Select Query Option field.

Settlement Currency

63

 Displays the currency for the specified cash account.

Process Center

 

 

Process Center

4896

This option specifies the entity's process center. It appears when you select All Entities/One Cash Account or All Entities/All Cash Accounts in the Select Query Option field.

Entity Attributes

 

 

Partition 

95

This option specifies the entity partition code. It appears when you select All Entities/One Cash Account or All Entities/All Cash Accounts in the Select Query Option field.

Â