diff --git a/erpnext/accounts/doctype/bank_reconciliation/bank_reconciliation.py b/erpnext/accounts/doctype/bank_reconciliation/bank_reconciliation.py
index 7ac603b..03acc0a 100644
--- a/erpnext/accounts/doctype/bank_reconciliation/bank_reconciliation.py
+++ b/erpnext/accounts/doctype/bank_reconciliation/bank_reconciliation.py
@@ -43,24 +43,30 @@
 			msgprint("Bank Account, From Date and To Date are Mandatory")
 			return
 	
-		dl = sql("select t1.name, t1.cheque_no, t1.cheque_date, t2.debit, t2.credit, t1.posting_date, t2.against_account from `tabJournal Voucher` t1, `tabJournal Voucher Detail` t2 where t2.parent = t1.name and t2.account = %s and (clearance_date is null or clearance_date = '0000-00-00' or clearance_date = '') and (t1.cheque_no is not null or t1.cheque_no != '') and t1.posting_date >= %s and t1.posting_date <= %s and t1.docstatus=1", (self.doc.bank_account, self.doc.from_date, self.doc.to_date))
+		dl = sql("select t1.name, t1.cheque_no, t1.cheque_date, t2.debit, t2.credit, t1.posting_date, t2.against_account from `tabJournal Voucher` t1, `tabJournal Voucher Detail` t2 where t2.parent = t1.name and t2.account = %s and (clearance_date is null or clearance_date = '0000-00-00' or clearance_date = '') and t1.posting_date >= %s and t1.posting_date <= %s and t1.docstatus=1", (self.doc.bank_account, self.doc.from_date, self.doc.to_date))
 		
 		self.doclist = self.doc.clear_table(self.doclist, 'entries')
 		self.doc.total_amount = 0.0
 
 		for d in dl:
 			nl = addchild(self.doc, 'entries', 'Bank Reconciliation Detail', 1, self.doclist)
-			nl.posting_date = str(d[5])
-			nl.voucher_id = str(d[0])
-			nl.cheque_number = str(d[1])
-			nl.cheque_date = str(d[2])
+			nl.posting_date = cstr(d[5])
+			nl.voucher_id = cstr(d[0])
+			nl.cheque_number = cstr(d[1])
+			nl.cheque_date = cstr(d[2])
 			nl.debit = flt(d[3])
 			nl.credit = flt(d[4])
-			nl.against_account = d[6]
+			nl.against_account = cstr(d[6])
 			self.doc.total_amount += flt(flt(d[4]) - flt(d[3]))
 
 	def update_details(self):
+		vouchers = []
 		for d in getlist(self.doclist, 'entries'):
 			if d.clearance_date:
 				sql("update `tabJournal Voucher` set clearance_date = %s, modified = %s where name=%s", (d.clearance_date, nowdate(), d.voucher_id))
-		msgprint("Updated")
+				vouchers.append(d.voucher_id)
+
+		if vouchers:
+			msgprint("Clearance Date updated in %s" % vouchers)
+		else:
+			msgprint("Clearance Date not mentioned")
\ No newline at end of file