UNMATCHED CASH RECEIPTS

Use this non-editable subtask to view the cash receipts detail transactions for the G/L account/org(s) linked with this bank abbreviation for all cleared transactions (Code = "CLR") that do not match items from the bank statement. The detail rows in this table window include all unmatched C/R transactions that have not yet been resolved for all prior periods up to and including the fiscal year and period displayed in the screen header.

Row data in the table window is pulled from the Bank Transactions History table.

When you open the Unmatched Cash Receipts subtask, all detail transactions automatically fill the table window. The Count display in the menu bar indicates the total number of detail transactions. You can use the Subquery function from the menu bar to select parameters for viewing a subset of the detail records, if desired.

As an alternative to viewing the information in this subtask, you can print the transactions detail data from the Bank Reconciliation Detail Reports screen.

The detail transactions that display in this screen are drawn from existing data in the Bank Transactions History table. Before you can view data in this screen, you must first run the Create Bank Transactions History process.

You must also have compared G/L transactions to bank transactions by clearing checks in the Accept Bank Transactions screen and/or using the Process Batch Bank Transactions screen.

The detail G/L transactions that were copied from the C/R table to the Bank Transactions History table can be viewed, matched to bank transactions, and cleared or uncleared in the Accept Bank Transactions screen.

Bank Abbr, Currency, Fiscal Year, Pd

These non-editable fields display the bank abbreviation and description, currency, fiscal year, and period that were selected in the main inquiry screen.

G/L Pd Ending Date, Bank Statement Ending Date

The G/L period ending date for the selected accounting period automatically displays in the screen header and cannot be edited.

The bank statement ending date set up in the Maintain Bank Statement Info screen for the fiscal year and period selected in the main inquiry screen automatically displays in the screen header and cannot be edited.

Table Window

The Unmatched Cash Receipts table window displays the following non-editable data columns:

Trans Type ("CR")

Receipt Date

Receipt No

Transaction Description

Deposit Number

Trans Crncy G/L Amount

Func Crncy G/L Amount

Trans Crncy Bank Amount

Trans Crncy Variance Amt

Bank Accpt Date

Bank Accpt FY

Bank Accpt Pd

Bank Accpt Subpd

Cash Account

Cash Organization

Ref 1 (if Ref 1 is used)

Ref 2 (if Ref 2 is used)

Trans Total G/L Amount

This field displays the sum of all values from the Trans Crncy G/L Amount column.

Func Total G/L Amount

This field displays the sum of all values from the Func Crncy G/L Amount column.

Trans Total Bank Amount

This field displays the sum of all values from the Trans Crncy Bank Amount column.

Trans Total Variance Amount

This field displays the sum of all values from the Trans Crncy Variance Amount column.