ECM: Book To Bank Reconciliation Is Not Balanced When A Deposit Is Deleted (Doc ID 2902723.1)

Last updated on OCTOBER 14, 2022

Applies to:

Symptoms

Book To Bank reconciliation is not balanced when a deposit is deleted.

When a posted and journal generated AR deposit is unposted in a future accounting period and subsequently deleted, the result is that the original accounting period becomes out of balance in BTB because the deleted deposit is no longer accounted for in Deposits In Transit. had a deposit that was posted and journal generated in January 2022. Book to Bank reconciled. The deposit was unposted and deleted in July 2022. The book to bank for February - June are out of balance because the original GL entries have not yet been reversed and the deleted deposit no longer shows as a Deposit In Transit because it has been deleted from the system.

STEPS
-----------------------
1. Create an online pending item and post it (Accounts Receivable – Pending Items – Online Items – Online Group Entry)
2. Verify the accounting entries on the accounting entry defintion record ITEM_DIST_CC_VW
3. Run the journal generator to create journal for the posted entries (General Ledger – Journals – Subsystem Journals – Generate Jrnl from Subsytem)
4. Verify the accounting entries have journal id populated on the accounting entry defintion record ITEM_DIST_CC_VW
5. Create a deposit for the above item, apply the payment, build the worksheet and post the worksheet (Accounts Receivable – Payments – Online Payments – Regular Deposits)
6. Verify the accounting entries on the accounting entry defintion record ITEM_DIST_CC_VW
7. Run the journal generator to create journal for the posted entries (General Ledger – Journals – Subsystem Journals – Generate Jrnl from Subsytem)
8. Verify the accounting entries have journal id populated on the accounting entry defintion record ITEM_DIST_CC_VW
9. Create a bank statement for the same bank / and in same accounting period but with a different deposit transaction  (Banking – Bank Statements – Enter Bank Statements)
10.Select and calculate the above statement under book to bank (Banking – Reconcile Statements – Select Book to Bank Statements)
11.Verify the data on the book to bank reconciliation (Banking – Reconcile Statements – Book to Bank Reconciliation)
12.Make sure that the book to bank shows deposit under "Deposits in Transit" and the payment is in "Ledger Balance"
13.Close the accounting period for AR and GL (SetUp Financials/ Supply Chain – Business Unit Related – General Ledger – Open Periods – Open Period Update)
14.Unpost the above paid deposit payment group (Accounts Receivable – Receivables Update – Unpost Group – Payment Group). Provide a reason and change the accounting date to a date in the open period. Run post to unpost the group
15.Verify the accounting entries on the accounting entry defintion record ITEM_DIST_CC_VW
16. Run the journal generator to create journal for the posted entries (General Ledger – Journals – Subsystem Journals – Generate Jrnl from Subsytem)
17. Verify the accounting entries have journal id populated on the accounting entry defintion record ITEM_DIST_CC_VW
18.Delete the deposit (Accounts Receivable – Payments – Online Payments – Regular Deposit). Change the accounting date to a date in the open period.
19.Select and calculate the above statement under book to bank for the closed accounting period (Banking – Reconcile Statements – Select Book to Bank Statements)
20.Verify the data on the book to bank reconciliation (Banking – Reconcile Statements – Book to Bank Reconciliation)
21.The deposit no more exists under "Deposits in Transit"
22.The ledger balance is not reduced for the deposit amount

Changes

Cause

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