Share
Report
5Does anyone have an easy way to identify sales transactions that were billed to a deferred revenue (balance sheet) account that doesn't have a deferral profile associated with the transaction?
While we were auditing our deferred revenue accounts, we identified some sales transactions that didn't have a deferral associated with it. Normally, these sales transactions would move into the balance sheet account, and would move out into the income statement revenue accounts over the course of the contract/agreement (usually 3, 6 or 12 months). In these cases, the revenue moves onto the balance sheet and never moves off to the income statement.
I'm thinking a SQL view/SmartList that would identify sales transactions based on GL account (00-12345-00) where there isn't a deferral associated with it, but I'm not finding how to identify the what deferral is/is not associated with the transactions. Any suggestions (or examples of a similar use case) would be helpful. It will help us unwind what is already there and then get added to our monthly audits.
You’re offline. This is a read only version of the page.
All responses (
Answers (
