My Oracle Support Banner

R11i/R12: CE: How to Reconcile or Autoreconcile Statement Lines to Statement Lines in the Same or a Different Bank Statement (Doc ID 944431.1)

Last updated on JUNE 11, 2024

Applies to:

Oracle Cash Management - Version to 12.1.3 [Release 11.5 to 12.1]
Information in this document applies to any platform.


NOTE:  In the data below and/or the attached document, account information/ user details / company name / address / email / telephone number represent a fictitious sample (based upon made up data used in the Oracle Demo Vision instance).
Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.



The misc. receipt & misc. payment statement lines are trx_type of 'MISC_DEBIT' or 'MISC_CREDIT'.  But when this is displayed, it is displayed as 'Stmt-Payment' and 'Stmt-Receipt'.


How To Manually Reconcile Statement Lines In Different Bank Statements To Transaction?

 Q1: It seems that issue you may have is similar to:
"Currently you load daily bank statements and occasionally there will be errors on the bank side requiring the bank to send through correction payments/receipt adjustments. These misc receipts reconcile with the earlier payment. If the payment and adjusting misc receipt come through on the same bank statement, it is not an issue. The auto reconciliation program will auto reconcile the two transactions together. However, if the adjusting receipt comes through on a different bank statement (perhaps the next day), they will not auto reconcile. These misc receipt will have to be manually reconciled."

Q2: Following Scenario and questions need to be addressed: 
(1). Using ADJ./REVERSAL: 1ST Bank Statement:
Scenario Bank statement processed however there are few statement lines which are not fully Reconciled (Partially Reconciled) but due to Tolerance setup it is showing as RECONCILED.

2nd Bank Statement:

This statement contains : Adjustment and Reversal statement line against the same Number.

(2). Using: Misc. Receipt / Payment Creation:

From 2nd Statement: Create Misc. Payments/Receipts as per the setups in Bank Transaction codes setup, however this expect that only statement lines with null NUMBER will be considered?

(3). Even if customer tries to manually Unreconcile and try to Re-reconcile it will not be possible as the Statement lines are in different bank statements.

Questions - Adjustment and Reversal :

1. Will the autoreconciliation try to Autoreconciliation these statements across the bank statements?
2. If yes, How?
3. If no, then what is the course of action customer has to Reconcile these bank errors?

Questions - Using: Misc. Receipt/Payment Creation:

1. Does this only serves for Misc. type statement lines; which can be attributed to specific payment or receipt?
2. If the Number is available in the statement line then creation of the Misc. Payment / Receipt will fail and that will result in manually creating these?
3. Is there any other way this can be resolved?

<Note:757206.1> - Unable To Autoreconcile Misc Receipt With Payments On Separate Bank Statement

Q3: Scenario: Over night deposits: Bank each night takes the Bank account Balance amount and puts in over night deposit and in the morning it is deposited back same amount to same bank account.

Bank sends customer two bank statement: One when they take the balance out from the bank account and second when they deposit back to the bank account.

Question now is: how to insure autoreconciliation of such bank statements when they exist in two different bank statement and with two different type of statement lines:

1). Misc. Payment

2). Misc. Receipt


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.