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:
In Accounting Center, in the left navigation pane, click Transactions > Cash > Cash Matching > List Unmatched Cash.
You see the List Unmatched Cash panel.Complete the options in the List Unmatched Cash entry panel.
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:
In Accounting Center, in the left navigation pane, click Transactions > Cash > Cash Matching > List Settled Cash.
You see the List Settled Cash panel.Complete the options in the List Settle Cash entry panel.
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:
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.Complete the options in the List Match Status Table entry panel.
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:
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.Complete the fields on the List Unmatched & Unsettled Cash panel.
Click Advanced Report and then click Submit.
The report appears on your desktop for the view selected. An example follows.
List Unmatched & Unsettled Cash Panel Options
A definition of the options on the List Unmatched & Unsettled Cash panel follows.
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:
|
Other Filters | You can filter results using other filters. Options include:
|
Add Comment