[Sheet1]
Jul 31, 20 | Aug 31, 20 | Sep 30, 20 | Oct 31, 20 | Nov 30, 20 | Dec 31, 20 | Jan 31, 21 | Feb 28, 21 | Mar 31, 21 | Apr 30, 21 | May 31, 21 | Jun 30, 21 | Jul 31, 21
ASSETS
Current Assets
Other Current Assets
Advances, Deposits & Prepayment
280_Security Deposit-House Rent | 80,000.00 | 80,000.00 | 80,000.00 | 80,000.00 | 80,000.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00
Advance Server Rental Fee | 5,646.00 | 0.00 | 24,218.33 | 19,374.66 | 14,530.99 | 9,687.32 | 4,843.65 | 35,572.98 | 32,608.98 | 29,644.98 | 26,680.98 | 23,716.98 | 20,752.98
Total Advances, Deposits & Prepayment | 85,646.00 | 80,000.00 | 104,218.33 | 99,374.66 | 94,530.99 | 9,687.32 | 4,843.65 | 35,572.98 | 32,608.98 | 29,644.98 | 26,680.98 | 23,716.98 | 20,752.98
Cash and Cash Equivalents
100_Cash in Hand | 599,101.00 | 723,243.00 | 689,278.00 | 689,278.00 | 689,278.00 | 748,092.00 | 748,092.00 | 716,334.00 | 714,894.00 | 714,894.00 | 714,894.00 | 714,894.00 | 714,894.00
111_Cash at Bank | 1,204,584.25 | 1,635,081.25 | 1,596,301.90 | 1,570,416.90 | 1,470,043.75 | 1,463,837.75 | 1,450,403.75 | 1,262,071.75 | 1,419,628.75 | 1,272,383.75 | 1,246,467.45 | 1,206,099.65 | 1,160,913.65
Total Cash and Cash Equivalents | 1,803,685.25 | 2,358,324.25 | 2,285,579.90 | 2,259,694.90 | 2,159,321.75 | 2,211,929.75 | 2,198,495.75 | 1,978,405.75 | 2,134,522.75 | 1,987,277.75 | 1,961,361.45 | 1,920,993.65 | 1,875,807.65
Trade & Other Receivables
Trade Receivable
135_2_A/R- Colgis Inc. | 1,237,320.10 | 822,234.10 | 742,526.10 | 773,840.10 | 942,629.10 | 1,087,474.10 | 887,216.10 | 1,089,100.00 | 760,250.00 | 763,860.00 | 905,421.30 | 1,237,828.30 | 1,012,180.30
Total Trade Receivable | 1,237,320.10 | 822,234.10 | 742,526.10 | 773,840.10 | 942,629.10 | 1,087,474.10 | 887,216.10 | 1,089,100.00 | 760,250.00 | 763,860.00 | 905,421.30 | 1,237,828.30 | 1,012,180.30
Total Trade & Other Receivables | 1,237,320.10 | 822,234.10 | 742,526.10 | 773,840.10 | 942,629.10 | 1,087,474.10 | 887,216.10 | 1,089,100.00 | 760,250.00 | 763,860.00 | 905,421.30 | 1,237,828.30 | 1,012,180.30
Total Other Current Assets | 3,126,651.35 | 3,260,558.35 | 3,132,324.33 | 3,132,909.66 | 3,196,481.84 | 3,309,091.17 | 3,090,555.50 | 3,103,078.73 | 2,927,381.73 | 2,780,782.73 | 2,893,463.73 | 3,182,538.93 | 2,908,740.93
Total Current Assets | 3,126,651.35 | 3,260,558.35 | 3,132,324.33 | 3,132,909.66 | 3,196,481.84 | 3,309,091.17 | 3,090,555.50 | 3,103,078.73 | 2,927,381.73 | 2,780,782.73 | 2,893,463.73 | 3,182,538.93 | 2,908,740.93
Fixed Assets
Intangible Assets
291_Preliminary Expenses
Amortization of Pre. Expenses | -2,069,447.00 | -2,152,225.00 | -2,235,003.00 | -2,317,781.00 | -2,400,559.00 | -2,483,337.00 | -2,566,115.00 | -2,648,893.00 | -2,731,671.00 | -2,814,449.00 | -2,897,227.00 | -2,980,000.00 | -2,980,000.00
291_Preliminary Expenses - Other | 2,980,000.00 | 2,980,000.00 | 2,980,000.00 | 2,980,000.00 | 2,980,000.00 | 2,980,000.00 | 2,980,000.00 | 2,980,000.00 | 2,980,000.00 | 2,980,000.00 | 2,980,000.00 | 2,980,000.00 | 2,980,000.00
Total 291_Preliminary Expenses | 910,553.00 | 827,775.00 | 744,997.00 | 662,219.00 | 579,441.00 | 496,663.00 | 413,885.00 | 331,107.00 | 248,329.00 | 165,551.00 | 82,773.00 | 0.00 | 0.00
Total Intangible Assets | 910,553.00 | 827,775.00 | 744,997.00 | 662,219.00 | 579,441.00 | 496,663.00 | 413,885.00 | 331,107.00 | 248,329.00 | 165,551.00 | 82,773.00 | 0.00 | 0.00
Tangible Assets
Computer Equipments
Acc. Dep.- Computer Equipments | -286,193.00 | -299,734.00 | -315,090.00 | -330,061.00 | -344,658.00 | -358,890.00 | -372,766.00 | -386,295.00 | -399,487.00 | -412,349.00 | -424,888.30 | -437,114.30 | -449,034.40
TDS on Computer Equipments | 16,042.00 | 16,042.00 | 17,644.00 | 17,644.00 | 17,644.00 | 17,644.00 | 17,644.00 | 17,644.00 | 17,644.00 | 17,644.00 | 17,644.00 | 17,644.00 | 17,644.00
VDS on Computer Equipments | 41,828.00 | 41,828.00 | 47,836.00 | 47,836.00 | 47,836.00 | 47,836.00 | 47,836.00 | 47,836.00 | 47,836.00 | 47,836.00 | 47,836.00 | 47,836.00 | 47,836.00
Computer Equipments - Other | 769,941.00 | 769,941.00 | 848,441.00 | 848,441.00 | 848,441.00 | 848,441.00 | 848,441.00 | 848,441.00 | 848,441.00 | 848,441.00 | 848,441.00 | 848,441.00 | 848,441.00
Total Computer Equipments | 541,618.00 | 528,077.00 | 598,831.00 | 583,860.00 | 569,263.00 | 555,031.00 | 541,155.00 | 527,626.00 | 514,434.00 | 501,572.00 | 489,032.70 | 476,806.70 | 464,886.60
Furniture & Fittings
Acc. Dep.- Furniture & Fittings | -103,701.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00
TDS on Furniture & Fittings | 28,382.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00
VDS on Furniture & Fittings | 15,919.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00
Furniture & Fittings - Other | 493,638.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00
Total Furniture & Fittings | 434,238.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00
Office Equipments
Acc. Dep.- Office Equipments | -110,621.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00
TDS on Office Equipments | 15,941.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00
VDS on Office Equipments | 31,026.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00
Office Equipments - Other | 579,877.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00
Total Office Equipments | 516,223.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00
Total Tangible Assets | 1,492,079.00 | 528,077.00 | 598,831.00 | 583,860.00 | 569,263.00 | 555,031.00 | 541,155.00 | 527,626.00 | 514,434.00 | 501,572.00 | 489,032.70 | 476,806.70 | 464,886.60
Total Fixed Assets | 2,402,632.00 | 1,355,852.00 | 1,343,828.00 | 1,246,079.00 | 1,148,704.00 | 1,051,694.00 | 955,040.00 | 858,733.00 | 762,763.00 | 667,123.00 | 571,805.70 | 476,806.70 | 464,886.60
TOTAL ASSETS | 5,529,283.35 | 4,616,410.35 | 4,476,152.33 | 4,378,988.66 | 4,345,185.84 | 4,360,785.17 | 4,045,595.50 | 3,961,811.73 | 3,690,144.73 | 3,447,905.73 | 3,465,269.43 | 3,659,345.63 | 3,373,627.53
LIABILITIES & EQUITY
Liabilities
Current Liabilities
Other Current Liabilities
316_Provi. for Salary & Allowa
316_Provi. for Bonus | 58,200.00 | 116,400.00 | 174,600.00 | 232,800.00 | 291,000.00 | 349,200.00 | 66,300.00 | 132,600.00 | 198,900.00 | 265,200.00 | 331,500.00 | 397,800.00 | 78,100.00
316_Provi.Salary & Allow-Shafiq | 28,000.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00
316_Provi. for Salary & Allowa - Other | 635,000.00 | 590,419.00 | 603,786.00 | 507,339.00 | 522,573.00 | 558,919.00 | 572,919.00 | 556,919.00 | 556,919.00 | 563,148.00 | 645,019.00 | 693,495.00 | 714,000.00
Total 316_Provi. for Salary & Allowa | 721,200.00 | 706,819.00 | 778,386.00 | 740,139.00 | 813,573.00 | 908,119.00 | 639,219.00 | 689,519.00 | 755,819.00 | 828,348.00 | 976,519.00 | 1,091,295.00 | 792,100.00
Advisory & Cons. Fee Payable | 281,750.00 | 307,683.00 | 260,589.00 | 309,350.00 | 465,865.00 | 227,700.00 | 356,986.00 | 227,700.00 | 227,700.00 | 103,500.00 | 141,761.00 | 138,000.00 | 138,000.00
Liabilities For Expenses
331_1_TDS Payable | 11,334.00 | 21,709.00 | 23,311.00 | 23,311.00 | 0.00 | 0.00 | 0.00 | 3,388.00 | 3,388.00 | 3,388.00 | 3,388.00 | 379.00 | 379.00
331_2_VDS Payable | 18,034.00 | 32,093.00 | 38,101.00 | 38,101.00 | 0.00 | 0.00 | 0.00 | 1,694.00 | 1,694.00 | 1,694.00 | 1,694.00 | 1,422.00 | 1,422.00
331_3_TDS on Salary & Allowance | 26,310.00 | 28,846.00 | 31,382.00 | 33,918.00 | 2,536.00 | 5,072.00 | 7,608.00 | 10,144.00 | 12,680.00 | 15,216.00 | 17,752.00 | 5,072.00 | 5,072.00
Total Liabilities For Expenses | 55,678.00 | 82,648.00 | 92,794.00 | 95,330.00 | 2,536.00 | 5,072.00 | 7,608.00 | 15,226.00 | 17,762.00 | 20,298.00 | 22,834.00 | 6,873.00 | 6,873.00
Other Payable
305_Payable to JABA IT | 6,000.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00
315_Payable to Mr. Mizoguchi | 3,995,196.00 | 4,000,213.00 | 4,000,213.00 | 4,000,213.00 | 4,000,213.00 | 4,000,213.00 | 4,000,213.00 | 4,000,213.00 | 4,000,213.00 | 4,000,213.00 | 4,000,213.00 | 4,000,213.00 | 4,000,213.00
Audit Fee Payable | 185,840.00 | 185,840.00 | 185,840.00 | 185,840.00 | 185,840.00 | 185,840.00 | 185,840.00 | 0.00 | 0.00 | 0.00 | 0.00 | 185,840.00 | 185,840.00
Colgis Inc. | 40,520.00 | 40,065.00 | 40,065.00 | 119,065.00 | 116,105.00 | 182,705.00 | 182,705.00 | 182,705.00 | 182,705.00 | 182,705.00 | 182,705.00 | 182,705.00 | 182,705.00
Internet Expense Payable | 12,000.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00
Other Expenses | 0.00 | 110,950.00 | 110,950.00 | 110,950.00 | 110,950.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00
Total Other Payable | 4,239,556.00 | 4,337,068.00 | 4,337,068.00 | 4,416,068.00 | 4,413,108.00 | 4,368,758.00 | 4,368,758.00 | 4,182,918.00 | 4,182,918.00 | 4,182,918.00 | 4,182,918.00 | 4,368,758.00 | 4,368,758.00
Total Other Current Liabilities | 5,298,184.00 | 5,434,218.00 | 5,468,837.00 | 5,560,887.00 | 5,695,082.00 | 5,509,649.00 | 5,372,571.00 | 5,115,363.00 | 5,184,199.00 | 5,135,064.00 | 5,324,032.00 | 5,604,926.00 | 5,305,731.00
Total Current Liabilities | 5,298,184.00 | 5,434,218.00 | 5,468,837.00 | 5,560,887.00 | 5,695,082.00 | 5,509,649.00 | 5,372,571.00 | 5,115,363.00 | 5,184,199.00 | 5,135,064.00 | 5,324,032.00 | 5,604,926.00 | 5,305,731.00
Total Liabilities | 5,298,184.00 | 5,434,218.00 | 5,468,837.00 | 5,560,887.00 | 5,695,082.00 | 5,509,649.00 | 5,372,571.00 | 5,115,363.00 | 5,184,199.00 | 5,135,064.00 | 5,324,032.00 | 5,604,926.00 | 5,305,731.00
Equity
400_Share Capital
406_Share Money Deposit | 461,500.00 | 461,500.00 | 461,500.00 | 461,500.00 | 461,500.00 | 461,500.00 | 461,500.00 | 461,500.00 | 461,500.00 | 461,500.00 | 461,500.00 | 461,500.00 | 461,500.00
400_Share Capital - Other | 5,000,000.00 | 5,000,000.00 | 5,000,000.00 | 5,000,000.00 | 5,000,000.00 | 5,000,000.00 | 5,000,000.00 | 5,000,000.00 | 5,000,000.00 | 5,000,000.00 | 5,000,000.00 | 5,000,000.00 | 5,000,000.00
Total 400_Share Capital | 5,461,500.00 | 5,461,500.00 | 5,461,500.00 | 5,461,500.00 | 5,461,500.00 | 5,461,500.00 | 5,461,500.00 | 5,461,500.00 | 5,461,500.00 | 5,461,500.00 | 5,461,500.00 | 5,461,500.00 | 5,461,500.00
430_Retained Earnings | -3,074,607.10 | -3,074,607.10 | -3,074,607.10 | -3,074,607.10 | -3,074,607.10 | -3,074,607.10 | -6,610,363.83 | -6,610,363.83 | -6,610,363.83 | -6,610,363.83 | -6,610,363.83 | -6,610,363.83 | -6,610,363.83
Net Income | -2,155,793.55 | -3,204,700.55 | -3,379,577.57 | -3,568,791.24 | -3,736,789.06 | -3,535,756.73 | -178,111.67 | -4,687.44 | -345,190.44 | -538,294.44 | -709,898.74 | -796,716.54 | -783,239.64
Total Equity | 231,099.35 | -817,807.65 | -992,684.67 | -1,181,898.34 | -1,349,896.16 | -1,148,863.83 | -1,326,975.50 | -1,153,551.27 | -1,494,054.27 | -1,687,158.27 | -1,858,762.57 | -1,945,580.37 | -1,932,103.47
TOTAL LIABILITIES & EQUITY | 5,529,283.35 | 4,616,410.35 | 4,476,152.33 | 4,378,988.66 | 4,345,185.84 | 4,360,785.17 | 4,045,595.50 | 3,961,811.73 | 3,690,144.73 | 3,447,905.73 | 3,465,269.43 | 3,659,345.63 | 3,373,627.53