diff --git a/osgi-bundles/bundles/analytics/src/main/resources/reports/v_revenue_recognition.sql b/osgi-bundles/bundles/analytics/src/main/resources/reports/v_revenue_recognition.sql
index 540388c..9a08646 100644
--- a/osgi-bundles/bundles/analytics/src/main/resources/reports/v_revenue_recognition.sql
+++ b/osgi-bundles/bundles/analytics/src/main/resources/reports/v_revenue_recognition.sql
@@ -10,6 +10,7 @@ select
, sum(recognized_amount) recognized_amount
from recognized_revenue
where effective_date = last_day(effective_date)
+and effective_date < recognized_date
group by 1
;
