How are companies doing monthly reporting for VAT on their deferred revenue?

Summary:

In our EMEA entities it is required to report the full deferred amount with VAT in the month billed, and then the actual revenue must be excluded monthly as the revenue is recognized. We are having to manually book entries to include/exclude this from reporting. We tried to resolve this via SLA, but have not been able to come up with an clean answer. Has anyone been able to automate this solution, or have any suggestions?

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):