Report on Cash Matching

Eagle Accounting provides several query reports you can use for research purposes when you use cash segregation and match cash based on actual cash settlements, along with a report for the cash matching process. You can use the report and these queries when you match actual cash settlements from a bank, custodian, or third party to open receivables and payable created in Eagle's Accounting solution.

List Unsettled Cash

The List Unsettled Cash panel, which supports the Cash Matching workspace, allows you to research Eagle Accounting open receivables/payables. You can view any unmatched open receivables/payables that the system was unable to match during automated cash matching.

To list unsettled cash based on actual cash settlements:

  1. In Accounting Center, in the left navigation pane, click Transactions > Cash > Cash Matching > List Unsettled Cash.
    You see the List Unsettled Cash panel.

  2. Complete the options in the List Unsettled Cash entry panel.

  3. Click Submit.
    You see the total open receivables/payables rolled up within and across entities (Summary) and individual open receivables/payables for one or more entities (Detail) that met your criteria in the Show All tab.

List Unmatched Cash

The List Unmatched Cash panel displays unmatched bank cash. Like the Manual Matching tab pane in the Cash Matching workspace that lists bank settlements, this query allows you to view unmatched cash settlements that the system was unable to match during automated cash matching. However, it provides additional filters that allow you to more narrowly research an exception. The results include unmatched or partially matched bank settlements.

To list unmatched cash based on actual cash settlements:

  1. In Accounting Center, in the left navigation pane, click Transactions > Cash > Cash Matching > List Unmatched Cash.
    You see the List Unmatched Cash panel.

  2. Complete the options in the List Unmatched Cash entry panel.

  3. Click Submit.
    You see the bank settlements that met your criteria in the Show All tab. For partially matched settlements, you can use the values in the Orig Value, Settle Amt S, and Net Amount Local columns to identify the original amount of the bank settlement, the amount previously settled, and the amount available for matching.

List Settled Cash

The List Settled Cash panel displays settled cash activity. Like the Matched & Suspended tab in the Cash Matching workspace, this query allows you to view cash settlements created in Eagle Accounting using the actual cash settlement method. However, it provides additional filters that allow you to more narrowly research an exception. The results include either matched bank settlements or the Eagle Accounting settlements they matched. You can also view unmatched bank settlements that have related Eagle Accounting settlements for transactions that were cancelled in Eagle Accounting and/or placed in suspense.

To list settled cash based on actual cash settlements:

  1. In Accounting Center, in the left navigation pane, click Transactions > Cash > Cash Matching > List Settled Cash.
    You see the List Settled Cash panel.

  2. Complete the options in the List Settle Cash entry panel.

  3. Click Submit.
    You see the bank settlements (Summary) or the Eagle Accounting settlements (Detail) that met your criteria in the Show All tab.

List Match Status Table

The List Match Status Table panel allows you to view Eagle Accounting settlements generated as a result of automated or manual cash matching based on actual cash settlements. This query helps you to audit the conditions under which those settlements were created. For example, you can tell if the settlement was created as a result of a manual match, a sweep, a 1 to 1 automated match, and so on. You can see if the settlement involved a cancellation or suspense processing. The results identify the open receivable/payable (ORP) instance, batch, cash match instance, event, and link event for each settlement.

You can view the user name and date that generated the event that created the settlement, along with the loopback event status of the settlement for troubleshooting purposes, which indicates whether the loopback event is in process (3), failed (1), or completed successfully (2). A loopback is a secondary event created within the STAR engine by an initial event.

To list the Match Status table based on actual cash settlements:

  1. In Accounting Center, in the left navigation pane, click Transactions > Cash > Cash Matching > List Match Status Table.
    You see the List Match Status Table panel.

  2. Complete the options in the List Match Status Table entry panel.

  3. Click Submit.
    You see the Eagle Accounting settlements that met your criteria in the Show All tab.

List Unmatched and Unsettled Cash

The List Unmatched & Unsettled Cash panel displays the open bank cash and any open receivables/payables with the same security alias and cash account number.

To list unmatched and unsettled cash:

  1. In Accounting Center, in the left navigation pane, click Transactions > Cash > Cash Matching > List Unmatched & Unsettled Cash.
    You see the List Unmatched & Unsettled Cash panel.

  2. Complete the fields on the List Unmatched & Unsettled Cash panel.

  3. Click Advanced Report and then click Submit.
    The report appears on your desktop for the view selected. An example follows.

Cash Matching report

List Unmatched & Unsettled Cash Panel Options

A definition of the options on the List Unmatched & Unsettled Cash panel follows.

Option

Tag

Description

Option

Tag

Description

Event Type





Event Type

55

Displays the event type of QRY_UNSETTLED_ACT.

Search Criteria





Begin Date

220

Specifies the start date for your report results.

End Date

221

Specifies the ending date for your report results. The default is today's date.

Selection Criteria





Report Filters



Allows you to show/hide additional report and security filters. The default is No.

Filter Security By

1953

Allows you to show/hide additional report filters. Options include:

  • Security Cross Reference (Default). If you select this option the panel unhides the Xref Type and Xref Security ID fields for data entry.

  • Issue Name. If you select this option, the panel unhides the Issue Name field for data entry.

  • Primary Asset ID. If you select this option, the panel unhides the Primary Asset ID field for data entry.

  • Ticker. If you select this option, the panel unhides the Ticker field for data entry.

Other Filters



You can filter results using other filters. Options include:

  • Cash Account Name

  • Cash Account Number

  • Settlement Currency

  • Investment Type

  • Security Type

  • Processing Security Type

  • Event Type

  • Cash Event Type

  • Cash Category

Â