Process Manual Cash Settlements

In the Run Multiple Settlements panel, you can manually settle cash activity, reverse a settled cash transaction, and make adjustments to the actual settlement date and the amount to be settled. You can query by date range for one entity as well as select a specific security.

The Settle Trade Indicator field on the Add Cash Contribution, Add Cash Withdrawal, Add Misc. Income, and Add Misc. Expense panels determines whether the system settles the cash activity automatically or manually. To settle cash activity manually, set the Settle Trade Indicator field to No.

Settle Cash Manually

To manually settle cash activity:

1. In Accounting Center, in the left navigation pane, click Transactions > Cash > Settlements > Run Multiple Settlements. 
   You see the Run Multiple Settlements panel.
2. Complete the options on the Run Multiple Settlements panel.
3. Click Submit.
   In the Show All tab, you see a list of unsettled transactions that meet your selection criteria.
4. Select the transactions you want to settle.
   Ensure a check mark appears in the check box in the left column for each row you select.
5. Click Select settlement record.
   In the Select settlement record tab, the system displays one row of settlement receipt information for each selected transaction.
6. Optionally, change the values of the Settlement Date and Local Settlement Amount fields for the displayed transactions.
   If you change the value of the Settlement Amount field, you can also optionally change the value of the Write off remaining amount field. By default, this field writes off the remaining unsettled amount from the transaction. To leave the remainder in receivable/payable status, select the No leave difference in payable status option.
7. Click Submit.

Example - Manual Cash Settlement

The Run Multiple Settlements panel allows you to query by a date range for one entity. You can also enter a specific security.

Enter the following information:

• Entity ID or Entity Name. Select the specific entity for which you want to settle cash activity. 
• Security. You can enter the Cross Reference Type, Cross Reference ID, or Issue Name to query for a security.
• Investment Type. Query only for unsettled cash activities by specific investment type.
• Target Event ID. Query specifically for a single cash item if the unsettled cash was processed with a specific system event identifier.
• Event Type. Query based on the specific event type (Buy, Sell, Spot, Coupon, Cash Div).
• Category. Query based on the activity category (Trade Only, Income Only, Trade and Income).
• Broker Name / Broker Code. Query based on a specific Broker.
• Trade Ticket Number. Query specifically for a single cash item if the unsettled cash was processed with a specific trade ticket number/identifier.
• Date Range. Default for the Beginning Settle Date field is January 1 of the current fiscal year and default for the Ending Settle Date field is the current system date. These dates can be overridden.

Click Submit to execute the query for all unsettled cash records based on the entered parameters. In the Show All tab, you see the cash activity items.

You can select only the specific cash activity items that you want to settle. To select a record to be settled, click the check box for the row.

When you make a selection, the Select settlement record button becomes available. To manually settle the selected record, click Select settlement record to continue.

The panel refreshes and displays the individual items that you selected in the previous tab. On this tab, you can change the amount settled or accounting date.

In the prior example, you could modify the Local Settlement Amount field value to 100.00. The Write off remaining amount field on this panel asks if you wish to write-off the remaining unsettled amount from the item, or leave the remainder in receivable/payable status.

To complete the settlement of the items, click Submit.

You can view the settled activity from the Cash Journal by changing the Report View field value (from the query selection) to SETTLED, which then displays the 111.00 MISCINC that was settled.

You can also view the results of the cash settlement in Position Viewer for the cash position in the Disbursements tab.

Settle Cash Manually for an Entity that Uses Cash Segregation

If you use the Run Multiple Settlements panel, and you select an entity that uses cash segregation, you can limit settlement processing to transactions associated with a single custodian.

The following fields in the Run Multiple Settlements panel allow you to specify a custodian:

• View by Custody Location (tag 990). Indicates whether to list unsettled transactions for all custodians. Options include Yes and No. If you select Yes, you limit your results to a single custody location. A custody location is a custodian bank with a custodian bank account number. If you select No, your results include all custody locations for the entity. This field appears if you select an entity that uses cash segregation.
• Custodian Bank (tag 1146). Specifies a custodian bank with a bank account relationship defined for the entity or the entity's reporting composite. If multiple custodians have bank account relationships with the entity, you can select one custodian. This field appears if you set the View by Custody Location field to a value of Yes.

If you leave the entity fields blank to include all entities in the query, the system can retrieve unsettled transactions for the custody basis as well as for the primary accounting basis.