ECM 9.2: Book To Bank Reconciliation Out of Balance For Negative Deposit With Positive And Negative Direct Journal Payment. (Doc ID 3026371.1)

Last updated on JUNE 05, 2024

Applies to:

Symptoms

Book to Bank Reconciliation is out of balance when processing a negative Deposit that is comprised of two Direct Journal Payments where one of the payments is a negative amount and the other payment is a positive amount. Since the Bank Statement transaction is associated to Statement Code 566, which is specified as DB (Debit), once the Bank Statement is reconciled to the negative Deposit, Book to Bank is negating both Payments under the Unbooked Payments page, resulting in a reconciliation difference. 

1.  Navigate to Accounts Receivable > Payments > Online Payments > Regular Deposit
2.  Create a new Regular Deposit under Deposit Unit xxxxx, Bank Code/Account xyxyx / yzyz where the Control Total Amount is -1,000.00 with the following 2 Payment transactions:
      a.  Amount = 1,500.00 with the Journal Directly box checked
      b.  Amount = -2,500.00 with the Journal Directly box checked
3.  Navigate to Accounts Receivable > Payments > Direct Journal Payments > Direct Journal Acctg Entries
4.  On the Create Accounting Entries / Find an Existing Value page, search for the 1st Payment (the positive amount) from Step 2
5.  On the Accounting Entries page, enter the 1st Distribution Line for -1,500.00
6.  Click on the lightning bolt icon to generate the balancing line.
7.  Check the Complete box.
8.  Save the page.
9.  On the Create Accounting Entries / Find an Existing Value page, search for the 2nd Payment (the negative amount) from Step 2
10.  On the Accounting Entries page, enter the 1st Distribution Line for 2,500.00
11.  Click on the lightning bolt icon to generate the balancing line.
12.  Check the Complete box.
13.  Save the page.
14.  Navigate to General Ledger > Journals > Subsystem Journals > Generate Jrnl from Subsystem.
15.  Check the Edit and Post boxes checked and generate the GL Journals for Business Unit xxxxx and Accounting Entry Definition = ARDIRJRNL.
16.  Navigate to Banking > Bank Statements > Enter Bank Statements
17.  Add a Bank Statement for with all the Dates set to the month prior to the month of the Deposit, Statement Code = 566, Transaction Amount = -1,000.00, Trans Code = Automated Clearing House.
18.  Navigate to Banking > Reconcile Statements > Semi-Manual Reconciliation.
19.  Reconcile the Bank Transaction to the negative Deposit amount from Step 2.
20.  Navigate to Banking > Reconcile Statements > Select Book To Bank Statements.
21.  Enter the Bank details and the Dates for the month of the Bank Statement, and Select and Calculate the Bank Statement.
22.  Navigate to Banking > Reconcile Statements > Book To Bank Reconciliation.
23.  Enter the Bank details and click the Details icon for the Bank statement.
24.  On the Book to Bank Reconciliation Details page, click the Unbooked Payments icon.
25.  Both the AR Payments from the Deposit are negative amounts, which is incorrect  -- Instead of Bank Amount = -1,500.00, it should be 1,500.00.

Cause

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