Process Manual Cash Settlements

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 security for which you want to settle cash activity. You can enter the Primary Asset ID, Issue Name, or Symbol 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 box for the row in the Select column.

When you make a selection, the Select settlement record button becomes enabled. To manually settle the selected record, click the Select settlement record button 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.