Our deferred revenue waterfall and the GL balance are out of sync but they should tie out. Waterfall summary does not have a drill down option - how do i resolve?

AI generated answer (using internal Slack threads):

****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ****** If your Deferred Revenue Waterfall and GL balance are out of sync, it could be due to a few reasons. One common reason is the presence of manual journal entries that are not part of the forecast report. Manual journals are usually not included in reports by default and can cause variances. Therefore, it's recommended to avoid posting manual journals into system (AR, AP, Revenue, etc.) accounts that have system-driven details. If you're not using Advanced Revenue Management (ARM), the standard Deferred Revenue Rollforward report might not necessarily tie to the GL. The Deferred Revenue Waterfall report, which does tie to the GL, is only available if you're using ARM. If you're planning on switching to ARM, this report can be helpful. However, if you need to migrate all the data over to Revenue Arrangements instead of Revenue Commitments, there is no easy way to do this. If you're using the Revenue Recognition function and the Deferred Revenue Rollforward Summary/Detailed report doesn't satisfy your needs, you might need to customize the report to only look or Group By specific Deferred Accounts. All native reports are more or less organized by GL account type. So if your transaction fees "items" have a deferred account assigned, the out of the box reports will pull any transaction that has a GL impact in an account type of deferred. Please note that these are general suggestions and the exact solution might vary depending on your specific situation and NetSuite setup.