I am using the Deferred Revenue Waterfall report that returns all transactions that have posted to our deferred accounts for the past ten years. for the first 7 years we were on Classic Revenue Recognition and we migrated to ARM late 2018. We left open sales orders in NS under the classic rev rec thinking that they would run off, most did but a large portion of them are still showing on the report.
I think one of the issues we are having is regarding the classic month end revenue close process and the Reclassification JE, after ARM we noticed that the Degross JE was inflating our Unbilled and Deferred Other balances but never reversing out. To solve this issue we would just run a saved search to find degross JE and put a reversal the same day so it would have zero affect on the GL Balance, the issue is that I am only seeing the reversal in the report and not the original Degross JE, should I exclude the reversals from my report as the degross JE is correcting the balance of the SO?
From my analysis, under ARM, it appears that Revenue Arrangements are the only type of transaction that should return on the report. I have a lot of Journal Entries, Sales Orders and Return Authorizations that have balances. If I run the report on only Revenue Arrangements, the total of the arrangements are higher than the report and higher than the GL balance. The historical JE, SO and RA's are causing the difference.
The breakdown of other transactions are as follows, Sales Orders and Journal Entries being the largest issue.
Sales Orders- Of all SO is still reflecting a balance, they are from before 2019 and should be totally cleared and reconciled. If revenue has been recognized on a line but not billed it will show up in the Unbilled account, the negatives related to Sales Orders that show up in deferred are instances where a line item was closed but the revenue wasn’t reversed. AR was instructed that when writing off services on Sales Orders with Revenue Commitments that a return authorization had to be done to create a negative to offset the positive revenue already scheduled. There were times this practice was not followed, and it was missed in review.
Journal Entries- Ones made by the system should only adjust the balance to align it with the amounts reported from the Revenue Element, any manual JE needs to be reversing or needs to be closely monitored and reversed at some point in the future. We’ve made a lot of these in the past, not sure how or to unwind.
Return Authorizations- should never show up unless the revenue hasn’t been reversed, I fixed the handful of these situations
With the 2022 year end reconciliation, there should be no open classic revenue transactions prior to 2020, yet there are many transactions still in the report that have earlier dates on them. The issue is when a manual correction (usually a JE) is issued, it does not clear the original transaction. It is true that many of them were manually corrected via JE that should have been handled transactionally, I have found additional items that can be fixed transactionally to clear the balances, but there are other items that have no offset or if it was offset in a JE there is no way to isolate it.