bank Rec Deposit Date, Posting Date

Problem:  Receipt batch with a deposit date in one year and the posting dates of each entry in another year that was reversed

Problem specific Details:

Receipt batch created and posted as deposit date of 01/12/2022 and all entries in the batch with 11/XX/2021 dates

Reversed the 20 receipts in the batch with a 01/12/2022 date

- Confirmed that the GL balance in 11/31/2021 to bank rec gl balance equal each other

- confirmed that the GL balance in 01/31/2022 to bank rec gl balance also equal

- confirmed AR trial balance to GL balance are good in both 11/30/2021 and 01/31/2021 ok

- confirmed that nothing shows up in bank rec to clear as at 11/30/2021

- confirmed that i see a deposit to clear in 01/31/2022 (this i don't understand  it has been reversed)

- confirmed that the GL transaction listing shows  - entries debiting the bank in 11/XX/2021 (original receipt batch) and crediting the bank in 01/31/2022 (reversal entries)

Question

- seems logical to me that I would need to do a  withdrawal bank entry in 11/30/2021  and a deposit entry in 01/31/2022 through a clearing account for my bank to balance?  

- what doesn't seem logical is that I would clear the bank entry withdrawal in 11/30/2021 and then the original deposit entry that is showing up in 01-13-2022

Anyone repaired this type of mistake in reversing and recording a receipt batch.  It wouldn't be as big of a deal except that it is year end.

  • 0

    I have answered my own question by repeating the issue in a test data set.  I will posted it here in case it helps anyone:

    Ultimately the question was how a deposit is handled in bank rec when the receipt posting date is earlier than the deposit date

    - at posting date:  transaction posted in gl so GL changes, Bank Rec GL balance Changes, o/s deposit total changes

    - what doesn't change is that you do not see the receipt on the o/s receipts tab to clear (as it has a future deposit date).  The actual total of the o/s deposits on the summary page will now not equal the listing of o/s deposits.   

    - if you print out the bank rec report the detail of o/s deposits will equal the Bank Rec Summary page o/s deposits

    Conclusion

    - the receipt with a different posting date than deposit date is treated as a o/s deposit to the bank rec but it is not available to clear until the deposit date is within the range of the bank rec.