Search for Settled Cash Activity

In the Cash Matching workspace's Matched & Suspended tab, you can search for cash settlements, and customize the search criteria and the search options. The results can show matched bank settlements and the corresponding STAR accounting settlements they matched. You can also view unmatched bank settlements and related STAR accounting settlements for transactions that were cancelled in STAR accounting and/or placed in suspense. 

To search for settlements:

1. In Accounting Center, in the left navigation pane, click Transactions > Cash > Cash Matching.
   You see the Cash Matching workspace. The Manual Matching tab is active by default.

2. Select the Matched & Suspended tab.
   You see STAR accounting settlements in the center grid.

3. Click Search and select New Search, Last Search, or any saved search. Or, click the Search chevron at the top of the tab to expand the Search Details pane.
   You see the Search Details pane. The Report Date Type field has a default value of Settlement Date.

4. Specify the report date type, report date range, and accounting basis.
   By default you search based on settlement date for the current month for the CUST accounting basis.

5. If you want to limit the search results to bank settlements within a range of original wire amount values, enter a value for the Bank Wire Amount From and Bank Wire Amount To fields. 
   You can specify one or both values.

6. Click the Report Type field and indicate the type of results you want to view.
   Options include:
   –  All. Default. Includes both bank settlements (Summary) and related STAR accounting settlements (Detail).
   –  Detail. Includes only STAR accounting settlements.
   –  Summary. Includes only bank settlements.

7. In the Cash Match Instance field, you can specify a value to limit the results to a specific cash match.
   The system uses the cash match instance to link together the incoming bank settlement with the resulting STAR cash settlement created in the accounting system.

8. Click the Cancel field and indicate whether to include settlement transactions cancelled in STAR accounting.
   Options include:
   –  Exclude. Default. The results do not include cancelled settled transactions in STAR accounting.
   –  Include. The results include cancelled settled transactions in STAR accounting.
   –  Only. The results include only cancelled settled transactions in STAR accounting.

9. Click the Cash Suspense field and indicate whether to include bank settlements associated with suspense activity in STAR accounting.
   Options include:
   –  Exclude. Default. The results do not include settled transactions in suspense in STAR accounting.
   –  Include. The results include settled transactions in suspense in STAR accounting.
   –  Only. The results include only settled transactions in suspense in STAR accounting.

10. In the Xref Type field and Xref ID field, you can identify a specific cross reference security type and cross reference security identifier to filter the results by security.
    By default the cross reference security type is CMM.

11. You can also set the Private Placement, 114A Eligible, and/or Private Registration fields to Yes or No to filter the results by these security criteria. 

12. Click the Search button in the Search Detail pane.
    You see the search results based on the criteria you selected. If you selected a report type of All or Summary, you see a list of matched bank settlements. If you selected a report type of Detail, you see a list of STAR settlements.

13. If you selected a report type of Summary, you can click the arrow to the left of each bank settlement row to expand or collapse that row. When you expand the Summary row for a bank settlement, you see the Detail rows of STAR accounting settlements related to that bank settlement. Each Summary level bank settlement row can include multiple STAR accounting settlement rows that share the same or different entities.

    You can manage how data displays for bank settlements and STAR accounting settlements using the options in the Grid tab. For example, you can use the Group by option to group bank settlements by security and transaction code.

You can unmatch or research the bank settlements and/or STAR settlements in the search results.