diff --git a/erpnext/accounts/report/utils.py b/erpnext/accounts/report/utils.py
index ed85ae7..68a4281 100644
--- a/erpnext/accounts/report/utils.py
+++ b/erpnext/accounts/report/utils.py
@@ -379,6 +379,6 @@
 			(gle.account.isin(party_account))
 			& (gle.party == party)
 			& (gle.posting_date < from_date)
-			& (gle.docstatus == 1)
+			& (gle.is_cancelled == 0)
 		)
 	).run(as_dict=True)