Any ideas on how to generate an actual revenue by subscription plan report?

you need to create rev rec journal entries for that. Transactions > Financial > Schedule Revenue Recognition Journal Entries > Run Now. Once this is done do Reclassification journal in the same manner (Transactions > Financial > Schedule Reclassification Journal Entries > Run Now)

@Karina Thank you, I'll give that a try!