Bank Reconciliation Control Report - Daily FDI011 (Output)

The Bank Reconciliation Control Report - Daily FDI011 (Output) includes the count and dollar amounts of benefits paid and rejected on the selected day(s). The report may be used to verify that the End of Day process was run and to cross check with the bank. The report is generated when the OK button is clicked on the Generate Bank Reconciliation Control Report screen.

"FDI011"

"Bank Reconciliation Control Report"

File Input Date

Origin of Data Element

This value is the date being reported. For paid benefits, it comes from the PaidDate column of the FoodInstrument table. For rejected benefits, it comes from the RejectionDate column of the FoodInstrumentRejection table. For paid exceptions, it comes from the PaidDate column of the BankExceptions table. For rejected exceptions, it comes from the RejectionDate column of the BankExceptions table.

Format

This is a date formatted as "MM/DD/CCYY".

Bank Totals - Paid

Origin of Data Element

The # Records value is the sum of the PaidCount column for the selected records (BankPaymentFileSummary table). The Total Costs value is the sum of the PaidTotal column for the selected records (BankPaymentFileSummary table).

Format

The # Records is a six-digit value. The Total Costs is a nine-digit value plus two decimal places.

Bank Totals - Rejects

Origin of Data Element

The # Records value is the sum of the RejectedCount column for the selected records (BankPaymentFileSummary table). The Total Costs value is the sum of the RejectedTotal column for the selected records (BankPaymentFileSummary table).

Format

The # Records is a six-digit value. The Total Costs is a nine-digit value plus two decimal places.

Bank Totals - Totals

Origin of Data Element

The # Records value is the sum of the Bank Totals - Paid plus the Bank Totals - Rejects for the line. The Total Costs value is the sum of the Bank Totals - Paid plus the Bank Totals - Rejects for the line.

Format

The # Records is a six-digit value. The Total Costs is a nine-digit value plus two decimal places.

Reconciliation Processing Totals - Paid

Origin of Data Element

The # Records value is the count of the selected paid records (FoodInstrument table). The Total Costs value is the sum of the PaidAmt column for the selected paid records (FoodInstrument table).

Format

The # Records is a six-digit value. The Total Costs is a nine-digit value plus two decimal places.

Reconciliation Processing Totals - Rejects

Origin of Data Element

The # Records value is the count of the selected rejected records (FoodInstrumentRejection table). The Total Costs value is the sum of the PaidAmt column for the selected rejected records (FoodInstrument table).

Format

The # Records is a six-digit value. The Total Costs is a nine-digit value plus two decimal places.

Reconciliation Processing Totals - Totals

Origin of Data Element

The # Records value is the sum of the Reconciliation Processing Totals - Paid plus the Reconciliation Processing Totals - Rejects for the line. The Total Costs value is the sum of the Reconciliation Processing Totals - Paid plus the Reconciliation Processing Totals - Rejects for the line.

Format

The # Records is a six-digit value. The Total Costs is a nine-digit value plus two decimal places.

Exceptions - Paid

Origin of Data Element

The # Records value is the count of the selected paid records (BankExceptions table). The Total Costs value is the sum of the PresentmentAmount column for the selected paid records (BankExceptions table).

Format

The # Records is a six-digit value. The Total Costs is a nine-digit value plus two decimal places.

Exceptions - Rejects

Origin of Data Element

The # Records value is the count of the selected rejected records (BankExceptions table). The Total Costs value is the sum of the PresentmentAmount column for the selected rejected records (BankExceptions table).

Format

The # Records is a six-digit value. The Total Costs is a nine-digit value plus two decimal places.

Exceptions - Totals

Origin of Data Element

The # Records value is the sum of the Exceptions Totals - Paid plus the Exceptions Totals - Rejects for the line. The Total Costs value is the sum of the Exceptions Totals - Paid plus the Exceptions Totals - Rejects for the line.

Format

The # Records is a six-digit value. The Total Costs is a nine-digit value plus two decimal places.

Filter Criteria

Base of Data

Benefits with a paid or rejected date within the selected date range are included in the report. Benefits must meet one of the following selection criteria.

• Bank Totals - Paid and Rejects

• The PaidDate column of the BankPaymentFileSummary table is within the selected date range, inclusive.

• Reconciliation Processing Totals - Paid

• The PaidDate column of the FoodInstrument table is within the selected date range, inclusive.

• Reconciliation Processing Totals - Rejects

• The RejectionDate column of the FoodInstrumentRejection table is within the selected date range, inclusive.

• Exceptions - Paid

• The PaidDate column of the BankExceptions table is within the selected date range, inclusive, and the PaidInd column equals 'Y'.

• Exceptions - Rejects

• The RejectionDate column of the BankExceptions table is within the selected date range, inclusive, and the PaidInd column equals 'N'.

Sort Order

File Input Date

The report will be sorted first by file input date.

Control Breaks

File Input Date

A page break will occur on the change in file input date.