-- MySQL dump 10.13  Distrib 5.5.62, for linux-glibc2.12 (x86_64)
--
-- Host: localhost    Database: waqfmaha
-- ------------------------------------------------------
-- Server version	5.5.62

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `wmr_income_expenditure_statement`
--

DROP TABLE IF EXISTS `wmr_income_expenditure_statement`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wmr_income_expenditure_statement` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `months` varchar(33) NOT NULL,
  `year` varchar(33) NOT NULL,
  `date` varchar(33) NOT NULL,
  `code` varchar(33) NOT NULL,
  `account_head` varchar(33) NOT NULL,
  `monthly_income` varchar(33) NOT NULL,
  `monthly_expenditure` varchar(33) NOT NULL,
  `bl_forwarded` varchar(33) NOT NULL,
  `monthly_savings` varchar(33) NOT NULL,
  `total_bl` varchar(33) NOT NULL,
  `session_username` varchar(33) NOT NULL,
  `timestamp` varchar(33) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=84 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `wmr_income_expenditure_statement`
--

LOCK TABLES `wmr_income_expenditure_statement` WRITE;
/*!40000 ALTER TABLE `wmr_income_expenditure_statement` DISABLE KEYS */;
INSERT INTO `wmr_income_expenditure_statement` VALUES (4,'August','1','01-09-2018','SB A/c No.520101264878694','Waqf Fund','12184994','37999995','63357286.59','4608039.59','32934246','majaleel','1536229456'),(5,'August','1','01-09-2018','22','Institutions A/c','20433367','13248332','92202040.04','7185035','99387075.04','akheelpasha','1536300372'),(6,'September','1','01-10-2018','22','Institutions A/c','4784751','44998023','99387075','2845728','102232803','akheelpasha','1538974336'),(7,'September','1','01-10-2018','SB A/c No.520101264878694','Waqf Fund A/c','210551040','41356288','37542285.59','4193739','202543298.59','majaleel','1541591566'),(8,'October','1','01-11-2018','22','Institutions A/c','7240871','11433013','102232803.04','2845728','98040661.04','akheelpasha','1541651299'),(9,'October','1','01-11-2018','SB A/c No.520101264878694','Waqf Fund A/c','14620076','102745092','206737037.59','7225626.59','111386395','majaleel','1541739865'),(10,'November','1','01-12-2018','22','Institutions A/c','10077649','7100586','98035661.04','2977063','101012724.04','akheelpasha','1544081471'),(11,'November','1','01-12-2018','520101264878694','Waqf fund','21192305','23603299','118612021.59','5077646.59','111123381','majaleel','1545222931'),(12,'December','1','01-01-2019','22','Institutions A/c','4997248','8458928','101012724.04','3461680','97551044.04','akheelpasha','1547616974'),(13,'January','1','01-02-2019','22','Institutions A/c','5353928.60','6297238','97551044.04','943309.04','96607734.64','akheelpasha','1549434583'),(14,'February','1','01-02-2019','22','Institutions A/c','8981734','11105849','96607734','-2124115','94483619','akheelpasha','1625466845'),(15,'March','1','01-03-2019','22','Institutions A/c','23964066','47061250','94483619','-23097184','71386435','akheelpasha','1625467045'),(16,'April','1','01-04-2019','22','Institutions A/c','30014717','3262460','71386435','26752257','98173421','akheelpasha','1625468504'),(17,'May','1','01-05-2019','22','Institutions A/c','4041567','9428629','98173421','-5387061','92786319','akheelpasha','1625468721'),(18,'June','1','01-07-2019','22','Institutions A/c','3567770','4074408','92786319','-506638','92279721','akheelpasha','1625468801'),(19,'July','1','01-07-2019','22','Institutions A/c','29852773','19434964','92279721','10417809','102697530','akheelpasha','1625468949'),(20,'August','1','01-07-2019','22','Institutions A/c','10785050','7037304','102697530','3747746','106445276','akheelpasha','1625469062'),(21,'September','1','01-07-2019','22','Institutions A/c','25283085','9605056','106445276','15678029','122123305','akheelpasha','1625469197'),(22,'October','1','01-10-2019','22','Institutions A/c','4850798','26190914','122123305','-21340116','100783189','akheelpasha','1625469310'),(23,'November','1','01-11-2019','22','Institutions A/c','28670600','4987725','100783189','23682875','124466064','akheelpasha','1625469407'),(24,'December','1','02-12-2019','22','Institutions A/c','32588047','60908201','124466064','-28320154','96145910','akheelpasha','1625469529'),(25,'January','1','01-01-2020','22','Institutions A/c','32888528','15195069','96145910','17693459','113839369','akheelpasha','1625469687'),(26,'February','1','01-02-2020','22','Institutions A/c','5785990','8016207','113839369','-2230217','111609152','akheelpasha','1625469822'),(27,'March','1','02-03-2020','22','Institutions A/c','5392405','7688977','111609152','-2296572','109312580','akheelpasha','1625469940'),(28,'April','1','01-04-2020','22','Institutions A/c','906091','9169538','109312580','-8263447','101049133','akheelpasha','1625470067'),(29,'May','1','01-05-2020','22','Institutions A/c','1713724','3694028','101049133','-1980304','99068829','akheelpasha','1625470149'),(30,'June','1','01-06-2020','22','Institutions A/c','6239145','4191291','99068829','2047854','101116691','akheelpasha','1625470245'),(31,'July','1','01-07-2020','22','Institutions A/c','11258095','16828319','101116691','-5570224','95546467','akheelpasha','1625470340'),(32,'August','1','01-08-2020','22','Institutions A/c','47116844','3371550','95546467','43745294','139291761','akheelpasha','1625470467'),(33,'September','1','01-09-2020','22','Institutions A/c','44008819','15965280','139291761','28043539','167341532','akheelpasha','1625470637'),(34,'October','1','01-10-2020','22','Institutions A/c','12907132','7878516','167341532','5028616','172486514','akheelpasha','1625470745'),(35,'November','1','02-11-2020','22','Institutions A/c','43706456','13053778','172486514','30652678','203107217','akheelpasha','1625470843'),(36,'December','1','01-12-2020','22','Institutions A/c','7113401','18057008','203107217','-10943607','192163610','akheelpasha','1625470937'),(37,'January','1','01-01-2021','22','Institutions A/c','5676604','7626859','192163610','-1950255','190213355','akheelpasha','1625471024'),(38,'February','1','01-02-2021','22','Institutions A/c','9561703','45901788','190213355','-36340085','153873270','akheelpasha','1625471116'),(39,'March','1','01-03-2021','22','Institutions A/c','15670600','21422108','153873270','-5751508','148121762','akheelpasha','1625471203'),(40,'April','1','01-04-2021','22','Institutions A/c','6810143','5911344','147920762','898799','148819561','akheelpasha','1625471311'),(41,'May','1','01-05-2021','22','Institutions A/c','53910114','9223697','148819561','44686417','193505978','akheelpasha','1625471421'),(42,'June','1','01-06-2021','22','Institutions A/c','9791417','9653326','193505978','138091','193644069','akheelpasha','1625479502'),(43,'July','1','01-07-2021','22','Institutions A/c','10498040','62203249','19356035','-51705209','141938860','akheelpasha','1630497249'),(44,'April','1','01-05-2020','00','520101264878694','19,81,234','5,59,08,447','10,81,26,767.77','00','5,41,99,554.77','majaleel','1630497955'),(45,'May','1','01-06-2020','00','520101264878694','36,94,638','92,48,172','5,41,99,554.77','00','4,86,46,020.77','majaleel','1630498051'),(46,'June','1','01-07-2020','00','520101264878694','64,47,966','49,47,998','4,86,46,020.77','00','5,01,45,988.77','majaleel','1630498145'),(47,'July','1','03-08-2020','00','520101264878694','24,66,166','1,29,74,460','5,01,45,988.77','00','3,96,37,694.77','majaleel','1630498232'),(48,'August','1','01-09-2020','00','520101264878694','51,32,363','19,85,576','3,96,37,694.77','00','4,27,84,481.77','majaleel','1630498411'),(49,'September','1','01-10-2020','00','520101264878694','34,36,113','91,01,484','4,27,84,481.77','00','3,71,19,110.77','majaleel','1630498520'),(50,'October','1','02-11-2020','00','520101264878694','55,78,475','73,31,705','3,71,19,110.77','00','3,53,65,880.77','majaleel','1630498606'),(51,'November','1','02-12-2020','00','520101264878694','93,54,794','1,27,08,061','3,53,65,880.77','00','3,20,12,613.77','majaleel','1630498702'),(52,'December','1','02-01-2021','00','520101264878694','1,79,67,791','98,70,483','3,20,12,613.77','00','4,01,09,921.77','majaleel','1630498774'),(53,'January','1','01-02-2021','00','520101264878694','29,08,469.67','88,54,042','4,01,09,921.77','00','3,41,64,349.44','majaleel','1630498870'),(54,'February','1','01-03-2021','00','520101264878694','77,42,358','1,14,65,436','3,41,64,349.44','00','3,04,41,271.44','majaleel','1630498945'),(55,'March','1','01-04-2021','00','520101264878694','1,98,70,663','1,20,55,073','3,04,41,271.44','00','3,82,56,861.44','majaleel','1630499087'),(56,'August','1','02-08-2021','22','Institutions A/c','43524923','13254129','141938860','30270794','172209654','akheelpasha','1632487657'),(59,'September','1','01-09-2021','22','Institutions A/c','22342572','17496631','172209654.92','4845941','177055595.92','akheelpasha','1635774356'),(61,'October','1','01-10-2021','22','Institutions A/c','16032408','31722180','177055595.92','-15689772','161365823.92','akheelpasha','1635774945'),(62,'April','1','01-05-2021','00','520101264878694 (Waqf Fund A/c)','16,90,831','72,64,332','3,81,68,157.44','00','3,25,94,656.44','majaleel','1635830532'),(63,'May','1','01-06-2021','00','520101264878694 (Waqf Fund A/c)','10,49,006','74,53,504','3,25,94,656.44','00','2,61,90,158.44','majaleel','1635830647'),(64,'June','1','01-07-2021','00','520101264878694 (Waqf Fund A/c)','67,97,852','70,15,021','2,61,90,158.44','00','2,59,72,989.44','majaleel','1635830886'),(65,'July','1','03-08-2021','00','520101264878694 (Waqf Fund A/c)','65,61,398','1,15,67,078','2,59,72,989.44','00','2,09,67,309.44','majaleel','1635831022'),(66,'August','1','01-09-2021','00','520101264878694 (Waqf Fund A/c)','65,05,540','70,60,745','2,09,67,309.44','00','2,04,12,104.44','majaleel','1635831127'),(67,'September','1','01-10-2021','00','520101264878694 (Waqf Fund A/c)','80,70,627','74,40,746','2,04,12,104.44','00','2,10,41,985.44','majaleel','1635831224'),(68,'October','1','01-11-2021','00','520101264878694 (Waqf Fund A/c)','2,13,37,298','71,23,398','2,10,41,985.44','00','3,52,55,885.44','majaleel','1635831294'),(69,'November','1','30-11-2021','22','Institutions A/c','11140507','11069878','161365823.92','70629','161436452.92','akheelpasha','1638283219'),(70,'November','1','01-12-2021','00','520101264878694 (Waqf Fund A/c)','25,95,865','1,14,21,516','3,52,55,885.44','00','2,64,30,234.44','majaleel','1640916503'),(71,'December','1','31-12-2021','22','Institutions A/c','7828353','13175495','161436452.92','-5347142','156089310.92','akheelpasha','1641287417'),(72,'January','1','03-01-2022','22','Institutions A/c','37549811','18203604','156089310.92','19346207','175435517.92','akheelpasha','1646222093'),(73,'February','1','02-03-2022','22','Institutions A/c','14549634','16828694','175435517','-2279060','173156457.92','akheelpasha','1646222181'),(74,'March','1','01-04-2022','22','Institutions A/c','10373656','21765226','173156457','-11391570','161764887.92','akheelpasha','1649223715'),(75,'April','1','02-05-2022','22','Institutions A/c','12599251','6878606','161764887.92','5720645','167485532.92','akheelpasha','1653714836'),(76,'May','1','08-06-2022','22','Institutions A/c','8206821','6708978','167485532.92','1497843','168983375.92','akheelpasha','1654675754'),(77,'June','1','01-07-2022','22','institution A/c','13362410','14716241','168983375.92','-1353831','167629544.92','akheelpasha','1657597542'),(79,'July','1','01-08-2022','22','Institution A/c','8395022','21804135.20','167629544.92','-13409113.20','154220431.72','akheelpasha','1669701333'),(80,'August','1','01-09-2022','22','Institution A/c','6121282.28','11704359','154220431.72','-5583076.72','148637355','akheelpasha','1669701413'),(81,'September','1','01-10-2022','22','Institution A/c','11439352.63','14520475.30','148637355','-3081122.67','145556232.33','akheelpasha','1669701529'),(82,'October','1','01-11-2022','22','Institution A/c','12046386','12007181.30','145556232.33','39204.70','145595437.03','akheelpasha','1669701614'),(83,'November','1','01-12-2022','22','Institution A/c','7198166.68','7623016.70','145595437.03','-424850.02','145170587.01','akheelpasha','1670047465');
/*!40000 ALTER TABLE `wmr_income_expenditure_statement` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2026-08-06 22:00:29
