4 MIS - March 2013
4 MIS - March 2013
TOTAL 1,197,383,546
ASSETS
Non Current Assets
Fixed assets
Tangible Assets 7 220,108,617
Intangible Assets 8,911,445
229,020,062
TOTAL 1,197,383,547
The notes referred to above form an integral part of the Balance Sheet.
Diff 1
As at As at As at As at As at
November 30, 2012 December 31, 2012 January 31, 2013 February 28, 2013 March 31, 2013
Rupees Rupees Rupees Rupees Rupees
Expenses:
Purchase of products 16 863,442,978 989,358,004
Changes in inventory of Stock in Trade 17 (222,091,032) (205,033,059)
Employee Benefits Expenses 18 253,997,202 292,246,001
Depreciation and Amortization 19 30,730,152 36,754,130
Other Expenses 20 948,156,756 1,087,053,898
TOTAL EXPENSES 1,874,236,056 2,200,378,974
Profit Before Exceptional and Extraordinary items and Tax (1,291,662,121) (1,475,717,474)
Tax Expenses
Current Tax -
Deferred Tax - - -
Profit (Loss) for the Period (1,291,662,121) (1,475,717,474)
The Notes referred to above form an integral part of the Statement of Profit and Loss.
Year Ended Year Ended Year Ended Year Ended
December 31, 2012 January 31, 2013 February 28, 2013 March 31, 2013
Rupees Rupees Rupees Rupees
- - -
(1,671,124,188) (1,836,983,497) (2,007,875,255) (2,129,754,254)
- -
(1,671,124,188) (1,836,983,497) (2,007,875,255) (2,129,754,254)
Jade eServices Private Limited
Schedules forming part of Balance Sheet
As at As at As at
October 31, 2012 November 30, 2012 December 31, 2012
Rupees Rupees Rupees
1. Share Capital
Securities premium
Opening Balance - -
Additions during the year 1,327,178,160 1,327,178,160 1,327,178,160
1,327,178,160 1,327,178,160 1,327,178,160
Surplus/ (deficit)
Opening Balance (228,943,028) (228,943,028) (228,943,028)
Profit/ (loss) during the year (1,291,662,121) (1,475,717,474) (1,671,124,188)
(1,520,605,149) (1,704,660,502) (1,900,067,216)
4. Trade Payables
Trade payables 149,572,789 183,208,579 186,976,097
149,572,789 183,208,579 186,976,097
9. Inventory
Stock in trade 413,222,880 396,164,907
Stock in transit - -
413,222,880 396,164,907
-
1,327,178,160 1,781,429,760 1,781,429,760
1,327,178,160 1,781,429,760 1,781,429,760
- - -
- - -
- - -
- - -
6,956,712 5,427,012 4,032,145
1,463,088 1,463,088 4,502,815
1,295,623 1,062,624 934,444
- - -
1,191,085 1,183,585 193,743
10,906,508 9,136,309 9,663,147
7. Fixed Assets
Intangible assets
Software 12,490,624 - 12,490,624 646,349 - 646,349 11,844,275 11,844,275
Trademark 1,787,434 8,198,718 - 9,986,152 37,308 - 37,308 9,948,844 1,750,126
Total 12,490,624 8,198,718 - 20,689,342 646,349 - - 646,349 20,042,993 13,594,401
Previous Year - - - - - - - - - -
Total fixed assets 78,957,721 163,715,785 - 242,673,506 4,342,640 - - 4,342,640 238,330,866 76,365,207
Previous year - - - - - - - - - -
Jade eServices Private Limited
Schedules forming part of Statement of Profit and Loss
Year Ended Year Ended Year Ended
October 31, 2012 November 30, 2012 December 31, 2012
Rupees Rupees Rupees
13500 Investment -
13501 Investments -
13599 Investment, Total -
13600 Deferred Tax (Asset) -
14000 Current Assets , Loans & Adv -
14100 Current Assets -
14200 Interest Accrued on Invest.
14201 Interest Accrued on FDR 4,502,815
14202 Interest Accrued on BG -
14299 Interest Accd on Invest, Total 4,502,815
14300 Inventory
14301 Raw Material -
14302 Finished Goods 426,085,467
14303 Packing Material 2,750,271
14304 Trims -
14305 Labels -
14306 Raw Materials (Interim) -
14307 WIP Account, Finished goods -
14308 Spares -
14309 Spare Interim -
14310 Packing -
14311 Capital Goods -
14312 Invt. lying under consignment 165,021
14399 Inventory, Total 429,000,760
14400 Works-in-Progress -
14401 Works-in-Progress -
14499 Works-in-Progress, Total -
15000 Deposits
15100 Term Deposits -
15102 Bank Guarantee -
15103 FDR-HDFC against BG/ LC 119,364,965
15105 FDR-Axis Bank 100,000
15199 Term Deposits, Totals 119,464,965
20000 LIABILITIES
20100 Share Capital
20101 Authorised Share Capital -
20102 Subscribed Share Capital -
20103 Issued Share Capital (198,036,640)
20104 Share Appl & Allotment Money (1,254,927,200)
20105 Calls in Arrears -
20199 Share Capital, Total (1,452,963,840)
40700 Gratuity - -
45300 Amortisation
45301 Amortisation -
45399 Total Amortisation -
45400 Income Tax & FBT -
45401 Income tax expense -
45402 FBT expense -
45403 Interset on FBT -
45499 Total Income Tax & FBT -
49999 Total Expenditure
0.599970757961273
619306431.386328 693765318.61
70966038 OT Rs. 4000000
2,126,754,257
(2,129,754,254)
(2,999,997) 3,000,000
(1)
(2,999,998)
Amount in Null 1 Rs.
Thousand 1000 Thousand
Lacs 100000 Lacs
Millions 1000000 Millions
Crores 10000000 Crores
Null 1 Rs.
Amount in Rs.
Sales Return % ( Other than Market Place ) -17% -17%
Sales Return % ( Market Place ) 0% 0%
Sales Return % ( Total ) -17% -17%
Gross margin before other direct cost %-Non Mkt place -14% 4%
Gross margin before other direct cost %-Mkt place 0% 0%
Particular April'12 May'12
Sales 61,940,038 98,014,189
Sales return (10,452,857) (16,501,230)
Sales MKTP
Sales return MKTP
ORD/ ORP working 539,954 1,515,771
Sales return reversal - -
* Net Sales 52,027,135 83,028,730
Cost of Goods Sold
Opening inventory 158,688,083 264,299,252
Purchases 164,261,491 227,056,483
Depreciation warehouse
Other depreciation 2,239,599 3,134,050
COGS
Other Direct Cost
Other Income
Salary Cost
Marketing Cost
Other Admin Cost
TOTAL
Net Loss
-18% -19% -19% -23% -21%
0% -1% -6% -23% -19%
-18% -19% -19% -23% -21%
-7% -19% -33% -46% 1%
0% -14% 3% -2% -4%
June'12 July'12 Aug,12 Sept'12 Oct'12
95,106,071 119,446,014 127,201,250 84,394,172 111,079,017
(21,318,040) (33,736,917) (36,445,275) (30,013,243) (26,144,449)
2,884,976 8,082,857 9,763,776 14,223,892
(39,026) (452,843) (2,273,749) (2,640,120)
2,465,396 3,147,687 2,809,420 2,471,224 2,236,833
4,021,154 10,526,914 11,279,750 10,114,232 2,371,364
80,274,581 102,229,648 112,475,159 74,456,413 101,126,537
2% 1% -7% -6% 5%
0% -7% -7% 0% 5%
158,688,083 -
1,607,426,352 -
(24,041,926)
429,000,759 -
1,313,071,750 109,422,646
121,249,268 10,104,106
(41,600,633) (3,466,719)
34,057,629 2,838,136
70,966,038 6,247,170
4,000,000
109,023,667 9,085,306
6,116 510
11,603 12,257
(150,624,300) (12,552,025)
40,808,298 3,400,692
15,575,345 1,297,945
1,449,104,028 120,758,669
467,643,396 38,970,283
7,302,744 608,562
14,534,629 1,211,219
489,480,769 40,790,064
7,930 661
61,725 61,725
1,093,381,690 91,115,141
1,093,381,690 91,115,141
85,758,480 7,146,540
12,284,235 1,023,686
23,549,005 1,962,417
28,805,937 2,400,495
27,935,327 2,327,944
41,225,044 3,435,420
15,992,379 1,332,698
10,278,510 856,543
4,924,182 410,349
5,476,382 456,365
5,729,342 477,445
20,277,935 1,689,828
48,766,975 4,063,915
12,244,490 1,020,374
1,212,731 101,061
39,031,342 3,252,612
3,000,000 250,000
66,158,842 5,513,237
452,651,138 37,720,928
2,035,513,597 169,626,133
(2,129,754,254) (177,479,521)
-3%
1,258,628,369
134,092,016
1,392,720,385
1,313,071,750
121,249,268
1,434,321,017
(54,443,381)
12,842,748
(41,600,633)
-4.33%
9.58%
-2.99%
109,023,667
(150,624,300)
-10.82%
143.43 41%
10.90 3%
-5.64 -2%
48.95 14%
109.34 31%
45.27 13%
352.25 100%
212.98
Remarks
Purchases are considered on the basis of GRN done during the month
Inventory has been calculated on the basis of expected cost. EOSS debit notes
booked in ERP
27.38
2.605137963844
Excess provision of Purchases in earlier months 9200000
Other income has been increased due to Franchise fee billing ( upto Dec12) of Rs
2.54 Crore in March.
Credit Notes of Rs 13.60 Lacs were issued to Bluerock in Feb due to which rent
income was low in Feb
Increased due to jabong annual event expenses (one major bill of Rs 6.88 Lacs )
Rs 12.34 Lacs input credit of Service Tax is taken ( entries passed monthly but
consider in MIS only in March
Bills of "Ikya Human Capital Solution Pvt Ltd" for Rs13.08 Lacs booked in Mar
( bill period was Dec, Jan & Feb) - Vendor is supplying manpower in Delhi &
Mumbai
In Feb - Rates and taxes includes 15 lacs for increase in authorised capital
One time management consultancy bill of Rs. 35 lacs was raised by Rocket
eservices in Aug month
Bills of Rocket eServices received in March
53
(1,392,720,385) (0)
1,337,113,676 270,312,676
429,000,760 (1)
1,313,071,750 0
121,249,268 -
Aug'12 Sep'12 Oct'12
Particulars Amount in Rs. Amount in Rs. Amount in Rs.
Fixed Assets 236,887,185 250,064,528 264,130,166
Accumulated depreciation (23,753,131) (29,253,131) (35,110,104)
Deferred Tax (Asset) - - -
Current Assets - - -
Interest Accrued on Invest. 588,053 588,053 588,053
Inventory 397,419,444 388,056,670 413,222,880
Sundry Debtors 100,785,105 65,890,609 129,276,032
Rates & Duties 18,644,844 19,432,927 24,557,033
Term Deposits 146,374,433 264,070,998 74,965,884
Other Deposits 7,920,000 7,920,000 7,920,000
Cash and bank balances 81,730,217 101,348,001 285,739,019
Loans & Advances 8,348,060 8,932,855 8,774,802
Carried loss 1,171,622,975 1,347,022,133 1,517,115,515
Diff 1 2 (0)
Nov'12 Dec'12 Jan,13 Feb'13 March'13
Amount in Rs. Amount in Rs. Amount in Rs. Amount in Rs. Amount in Rs.
268,548,415 273,018,950 275,067,796 278,580,767 277,717,174
(41,134,082) (47,185,030) (53,947,550) (59,537,259) (69,413,357)
- - - - -
- - - - -
588,053 1,066,763 1,463,088 1,463,088 4,502,815
396,164,907 346,571,687 273,794,925 303,333,140 429,000,760
49,831,416 123,416,408 204,154,126 200,651,078 279,787,020
28,830,477 29,468,929 35,136,954 26,199,610 20,827,819
80,666,357 84,357,264 84,357,264 104,937,499 119,464,965
39,616,741 32,679,141 34,079,141 35,164,141 45,051,770
431,736,147 423,135,485 440,208,335 457,958,895 281,433,341
8,782,071 2,973,984 2,486,708 2,246,209 1,128,187
1,475,717,474 1,671,124,187 1,836,983,497 2,007,875,254 2,129,754,254
225,211,411
71,510,591 36,873,835
-1241980085.27
-225453393
(72,250,000) 113,398,800.00
(875,696,318) (925,325,318) 71,850,000.00
185,248,800.00
-3489635
(38,782,277)
(86,999,492) (66,176,651)
98,077,704 2,273,466 97,217,170 860,534
123,042,548 4,489,054 121,231,721 1,810,828
221,120,252 6,762,520
4,091,158 10,853,678
Code Head a (3,000,000) (2,999,998)
10000 BALANCE SHEET
10001 ASSETS
10002 Fixed Assets
10003 Tangible Fixed Assets
10100 Land
10101 Increases, Land -
10102 Decreases, Land -
10119 Land , Total
10120 Buildings
10121 Increases, Buildings -
10122 Decreases, Buildings -
10139 Buildings, Total
10140 Leaseholds
10141 Increases, Leaseholds 25,991,006
10142 Decreases, Leaseholds -
10159 Leaseholds, Total
10160 Office Equipment
10161 Increases, Office Equipment 21,098,252
10162 Decreases, Office Equipment (8,700)
10179 Office Equipment, Total
10180 Computers & Peripherals
10181 Increases, Computers & Perph. 85,335,265
10182 Decreases, Computers & Perph. (4,536,151)
10199 Computer & Perph., Total
10200 Comp. Soft. & Web Dev.
11121 Increases, Comp.Soft.&WebDev. 39,579,818
11122 Decreases, Comp.Soft.&WebDev. -
10219 Comp. Soft. & Web Dev., Total
10220 Furniture & Fixtures
10221 Increases, Furn & Fix. 6,263,375
10222 Decreases, Furn & Fix. -
10239 Furniture & Fixtures, Total
10240 Vehicles
10241 Increases,Vehicle -
10242 Decreases,Vehicle -
10259 Vehicles, Totals
10260 Plant & machinery
10261 Increases, Plant & machinery 95,795,591
10262 Decreases, Plant & machinery -
10270 Plant & machinery, Totals
10500 Capital Work in Progress -
10999 Tangible Fixed Assets, Total
11000 Intangible Fixed Assets
11100 Patents, Licenses, rights & tr
11101 Increases, Patents, Licences 8,198,718
11102 Decreases, Patents, Licences -
11119 Patents, Licenses, Total
11499 Intangible F.A. , Total
12999 Fixed Assets, Total 277,717,174
13500 Investment -
13501 Investments -
13599 Investment, Total -
13600 Deferred Tax (Asset) -
14000 Current Assets , Loans & Adv -
14100 Current Assets -
14200 Interest Accrued on Invest.
14201 Interest Accrued on FDR 4,502,815
14202 Interest Accrued on BG -
14299 Interest Accd on Invest, Total 4,502,815
14300 Inventory
14301 Raw Material -
14302 Finished Goods 426,085,467
14303 Packing Material 2,750,271
14304 Trims -
14305 Labels -
14306 Raw Materials (Interim) -
14307 WIP Account, Finished goods -
14308 Spares -
14309 Spare Interim -
14310 Packing -
14311 Capital Goods -
14312 Invt. lying under consignment 165,021
14399 Inventory, Total 429,000,760
14400 Works-in-Progress -
14401 Works-in-Progress -
14499 Works-in-Progress, Total -
15000 Deposits
15100 Term Deposits -
15102 Bank Guarantee -
15103 FDR-HDFC against BG/ LC 119,364,965
15105 FDR-Axis Bank 100,000
15199 Term Deposits, Totals 119,464,965
20000 LIABILITIES
20100 Share Capital
20101 Authorised Share Capital -
20102 Subscribed Share Capital -
20103 Issued Share Capital (198,036,640)
20104 Share Appl & Allotment Money (1,254,927,200)
20105 Calls in Arrears -
20199 Share Capital, Total (1,452,963,840)
30200 Sales
30201 Sales-Domestic (1,635,922,432)
30202 Sales-Foreign (2,572,513)
30203 Sales-Trading -
30210 Sales-Consignment (48,884)
30261 SALES-DOMESTIC (MARKETPLACE) (158,589,054)
30262 SALES RETURN-DOMESTIC (MKTPLA) 24,497,039
30204 Sales Return-Domestic 341,654,437
30205 Sales Return-Foreign 437,529
30206 Sales Return-Trading -
30211 SalesReturn-Consignment 17,130
30221 Sales-International business (178,377)
30241 Sales-Marketing -
30260 Sales Others -
30291 Invoice Discount Granted -
30252 Invoice Discount Granted 37,984,741
30292 Marketing Promotions -
30293 Store Credit -
30299 Sales, Total (1,392,720,385)
40100 Purchases -
40101 Purchases-Raw Material -
40102 Purchases-Finished Material 1,366,121,581
40700 Gratuity - -
45300 Amortisation
45301 Amortisation -
45399 Total Amortisation -
45400 Income Tax & FBT -
45401 Income tax expense -
45402 FBT expense -
45403 Interset on FBT -
45499 Total Income Tax & FBT -
49999 Total Expenditure
(3,000,000) (5,999,998)
1
(3,234,393,600)
(1,258,449,992)
(1,417,039,046)
(158,589,054)
737,325,324 599,788,352
82,326,917 (38,922,350)
70,966,038 OT Rs. 4000000
2,126,754,257
(2,129,754,254)
(2,999,997) 3000000
(1)
(2,999,998)
Trial BalanceJADE eServices Pvt. Ltd.-Live 01/31/2024arun.sPage 73
No. Name Net Change - Debit Net Change - Credit Balance at Date - Debit
10000 BALANCE SHEET 0
10001 ASSETS 0
10002 Fixed Assets 0
10003 Tangible Fixed Assets 0
10100 Land 0
10101 Increases, Land 0
10102 Decreases, Land 0
10119 Land , Total 0
10120 Buildings 0
10121 Increases, Buildings 0
10122 Decreases, Buildings 0
10123 Accum. Depreciation, Buildings 0
10139 Buildings, Total 0
10140 Leaseholds 0
10141 Increases, Leaseholds 99,050,250.50 0 118,452,852.50
10142 Decreases, Leaseholds 0
10143 Accum. Depreciation, leasehold 0
10159 Leaseholds, Total 99,050,250.50 0 117,790,065.50
10160 Office Equipment 0
10161 Increases, Office Equipment 14,254,423.76 0 22,021,706.78
10162 Decreases, Office Equipment 8,700
10163 Accum Dep ,Office Eqipment 0
10179 Office Equipment, Total 14,245,723.76 0 21,740,768.80
10180 Computers & Peripherals 0
10181 Increases, Computers & Perph. 37,596,307.60 0 87,639,662.67
10182 Decreases, Computers & Perph. 4,536,150.82
10183 Accum. Depr., Comp. & Perph. 830,962.13 0
10199 Computer & Perph., Total 33,891,118.91 0 80,609,151.98
10220 Furniture & Fixtures 0
10221 Increases, Furn & Fix. 4,392,112.49 0 5,981,277.49
10222 Decreases, Furn & Fix. 0
10223 Accum. Depr. Furniture-Fixture 0
Trial BalanceJADE eServices Pvt. Ltd.-Live 01/31/2024arun.sPage 74
30203 Sales-Trading 0
30204 Sales Return-Domestic 341,654,437.03 0 341,654,437.03
30205 Sales Return-Foreign 437,529 0 437,529
30206 Sales Return-Trading 0
30210 Sales-Consignment 48,883.94
30211 SalesReturn-Consignment 17,129.63 0 17,129.63
30221 Sales-International business 178,377
30241 Sales-Marketing 0
30252 Line Discount Granted 37,984,741.24 0 37,984,741.24
30259 Sales, Total 1,258,628,369.11
30260 Sales Others 0
30261 SALES-DOMESTIC (MARKETPLACE) 71,363,042
30262 SALES RETURN-DOMESTIC (MKTPLA) 8,751,402 0 8,751,402
30291 Invoice Discount Granted 0
30292 Marketing Promotions 0
30293 Store Credit 0
30294 Sales-return provision 0
30299 Sales others, Total 62,611,640
30300 Other Income 0
30301 Unrealized Profit 888,703.77
30302 Income - Ops IT Project 56,574
30311 Freight outward 87,734.25
30399 Other Income, Total 1,033,012.02
30400 Profit on Sales on Fixed Ast 0
30401 Profit on Sale of Land 0
30402 Profit on sale of Building 0
30403 Profit on sale of Vehicle 0
30404 Profit on Sale of Compperf. 1,080,036.31
30405 Profit on Sale of Compsoftw 0
30406 Profit on Sale of Furn& Fix. 0
30407 Profit on Sale on Office Eqp. 0
30499 Profit on Sales on F A,Total 1,080,036.31
30500 Profit on Sales of Invest 0
Trial BalanceJADE eServices Pvt. Ltd.-Live 01/31/2024arun.sPage 83
0 - - - 14200 - -
0 2,105,526 2,397,289 4,502,815 14201 4,502,814.82 -
0 - - - 14202 - -
0 2,105,526 - 2,105,526 14299 - 2,105,526
0 - - - 14300 - -
0 - - - 14301 - -
0 245,352,312 180,733,155 426,085,467 14302 426,085,467.12 -
0 2,750,271 - 2,750,271 14303 2,750,271.35 -
0 - - - 14304 - -
0 - - - 14305 - -
0 - - - 14306 - -
0 - - - 14307 - -
0 - - - 14308 - -
0 - - - 14309 - -
0 - - - 14310 - -
0 - - - 14311 - -
0 165,021 - 165,021 14312 165,021.34 -
0 - - - #N/A #N/A #N/A
0 248,267,604 - 248,267,604 14399 - 248,267,604
0 - - - 14400 - -
0 - - - 14401 - -
0 - - - 14499 - -
0 - - - 14500 - -
0 165,889,537 - 165,889,537 14501 165,889,537.20 -
0 92,766 - 92,766 14502 92,766.07 -
0 119,662 - 119,662 14503 119,662.29 -
0 1,224,949 - 1,224,949 14504 1,224,949.28 -
19,233 (19,233) - (19,233) 14505 (19,233.00) -
0 7,304,518 - 7,304,518 14506 7,304,518.24 -
0 33,694,444 71,480,376 105,174,820 14507 105,174,819.59 -
0 - - - 14580 - -
0 - - - 14581 - -
0 - - - 14582 - -
Trial BalanceJADE eServices Pvt. Ltd.-Live 01/31/2024arun.sPage 94
0 - - - 14589 - -
0 208,306,644 - 208,306,644 14599 - 208,306,644
0 - - - 14600 - -
0 4,032,145 - 4,032,145 14601 4,032,145.00 -
0 4,032,145 - 4,032,145 14699 - 4,032,145
0 - - - 14700 - -
0 - - - 14701 - -
0 - - - 14702 - -
0 2,026,218 - 2,026,218 14703 2,026,217.85 -
0 - - - 14704 - -
0 - - - 14705 - -
0 - - - 14706 - -
0 - - - 14707 - -
0 - - - 14708 - -
0 - - - 14709 - -
0 9,786,744 - 9,786,744 14710 9,786,743.87 -
0 - - - 14711 - -
0 - - - 14712 - -
0 - - - 14715 - -
0 4,982,713 - 4,982,713 14716 4,982,712.53 -
0 16,795,674 - 16,795,674 14799 - 16,795,674
0 - - - 15000 - -
0 - - - 15100 - -
0 199,368,808 (49,000,000) 150,368,808 15101 150,368,808.30 -
0 - - - 15102 - -
0 70,364,965 49,000,000 119,364,965 15103 119,364,964.64 -
0 54,881,862 - 54,881,862 15104 54,881,861.81 -
0 100,000 - 100,000 15105 100,000.00 -
0 8,667,611 - 8,667,611 15106 8,667,610.95 -
0 1,500,000 - 1,500,000 15107 1,500,000.00 -
0 334,883,246 - 334,883,246 15199 - 334,883,246
0 - - - 15200 - -
0 45,051,770 - 45,051,770 15201 45,051,770.00 -
Trial BalanceJADE eServices Pvt. Ltd.-Live 01/31/2024arun.sPage 95
0 - - - 15202 - -
0 - - - 15203 - -
0 45,051,770 - 45,051,770 15299 - 45,051,770
0 379,935,016 - 379,935,016 15399 - 379,935,016
0 - - - 15400 - -
0 - - - 15500 - -
0 140,000 - 140,000 15501 140,000.00 -
0 140,000 - 140,000 15599 - 140,000
0 - - - 15600 - -
0 36,322,686 - 36,322,686 15601 36,322,686.43 -
0 546,504 - 546,504 15602 546,504.06 -
0 13,295,987 - 13,295,987 15603 13,295,987.28 -
0 3,465,239 - 3,465,239 15604 3,465,238.90 -
0 50,000 - 50,000 15605 50,000.00 -
0 694,643 - 694,643 15606 694,643.00 -
0 11,500,000 - 11,500,000 15607 11,500,000.00 -
0 65,875,060 - 65,875,060 15699 - 65,875,060
0 66,015,060 - 66,015,060 15799 - 66,015,060
0 925,457,669 - 925,457,669 15999 - 925,457,669
0 - - - 16000 - -
0 - - - 16100 - -
0 193,743 - 193,743 16101 193,743.00 -
0 193,743 - 193,743 16199 - 193,743
0 - - - 16200 - -
0 317,669 - 317,669 16201 317,669.00 -
0 - - - 16202 - -
0 317,669 - 317,669 16299 - 317,669
0 - - - 16300 - -
0 - - - 16301 - -
0 - - - 16302 - -
0 - - - 16399 - -
0 - - - 16400 - -
0 616,775 - 616,775 16401 616,775.00 -
Trial BalanceJADE eServices Pvt. Ltd.-Live 01/31/2024arun.sPage 96
0 - - - 20802 - -
0.22 (0) - (0) 20803 (0.22) -
0 - - - 20804 - -
0 - - - 20805 - -
0 - - - 20806 - -
0 - - - 20807 - -
0 705,600 - 705,600 20808 705,600.00 -
0 1,838,798 - 1,838,798 20809 1,838,798.35 -
0 7,902,343 - 7,902,343 20810 7,902,342.59 -
136,431,616.10 (136,431,616) - (136,431,616) 20811 (136,431,616.10) -
0 59,569,078 - 59,569,078 20812 59,569,077.82 -
168,054 (168,054) - (168,054) 20813 (168,054.00) -
6,387,009.50 (6,387,010) - (6,387,010) 20814 (6,387,009.50) -
72,970,860.73 (72,970,861) - (72,970,861) 20899 - (72,970,861)
0 - - - 20900 - -
0 - - - 20901 - -
2,182,826 (2,182,826) - (2,182,826) 20902 (2,182,826.00) -
0 - - - 20903 - -
2,201,922 (2,201,922) - (2,201,922) 20904 (2,201,922.00) -
608,470 (608,470) - (608,470) 20905 (608,470.00) -
1,500,883.60 (1,500,884) - (1,500,884) 20906 (1,500,883.60) -
6,679,669 (6,679,669) - (6,679,669) 20907 (6,679,669.00) -
0 - - - 20908 - -
0 - - - 20909 - -
0 - - - 20910 - -
0 - - - 20911 - -
0 - - - 20912 - -
0 - - - 20913 - -
99,439 (99,439) - (99,439) 20914 (99,439.00) -
0 - - - 20915 - -
0 - - - 20916 - -
0 - - - 20917 - -
0 - - - 20918 - -
Trial BalanceJADE eServices Pvt. Ltd.-Live 01/31/2024arun.sPage 98
0 - - - 20919 - -
0 - - - 20920 - -
0 - - - 20921 - -
0 - - - 20922 - -
0 - - - 20923 - -
0 - - - 20924 - -
0 - - - 20925 - -
0 25,000,355 - 25,000,355 20926 25,000,354.61 -
40,799,839.29 (40,799,839) - (40,799,839) 20927 (40,799,839.29) -
148,491.20 (148,491) - (148,491) 20928 (148,491.20) -
13,139.49 (13,139) - (13,139) 20929 (13,139.49) -
0 - - - 20931 - -
0 - - - 20932 - -
0 - - - 20933 - -
0 - - - 20934 - -
0 - - - 20935 - -
0 - - - 20936 - -
0 - - - 20937 - -
0 - - - 20938 - -
0 - - - 20939 - -
0 - - - 20940 - -
3,362,885 (3,362,885) - (3,362,885) 20941 (3,362,885.00) -
0 - - - 20942 - -
32,597,209.97 (32,597,210) - (32,597,210) 20999 - (32,597,210)
0 - - - 21000 - -
5,606 (5,606) - (5,606) 21001 (5,606.00) -
0 - - - 21002 - -
1,258,583.03 (1,258,583) - (1,258,583) 21003 (1,258,583.03) -
553,149 (553,149) (552,587) (1,105,736) 21004 (1,105,736.00) -
2,132 (2,132) - (2,132) 21005 (2,132.00) -
21,290 (21,290) - (21,290) 21006 (21,290.00) -
0 - - - 21007 - -
0 - - - 21008 - -
Trial BalanceJADE eServices Pvt. Ltd.-Live 01/31/2024arun.sPage 99
0 - - - 30203 0 -
0 341,654,437 - 341,654,437 30204 341654437.03 -
0 437,529 - 437,529 30205 437529 -
0 - - - 30206 - -
48,883.94 (48,884) - (48,884) 30210 -48883.94 -
0 17,130 - 17,130 30291 17,129.63 -
178,377 (178,377) - (178,377) 30221 (178,377.00) -
0 - - - 30241 - -
0 37,984,741 - 37,984,741 30252 37984741.24 -
1,258,628,369.11 (1,258,628,369) - (1,258,628,369) #N/A #N/A #N/A
0 - - - 30260 - -
71,363,042 (71,363,042) (87,226,012) (158,589,054) 30261 (158,589,054.22) -
0 8,751,402 15,745,637 24,497,039 30262 24,497,038.51 -
0 - - - 30291 - -
0 - - - 30292 0 -
0 - - - 30293 - -
0 - - - #N/A #N/A #N/A
62,611,640 (62,611,640) - (62,611,640) 30299 - (62,611,640)
0 - - - 30300 - -
888,703.77 (888,704) - (888,704) 30301 (888,703.77) -
56,574 (56,574) - (56,574) 30302 (56,574.00) -
87,734.25 (87,734) - (87,734) 30311 (87,734.25) -
1,033,012.02 (1,033,012) - (1,033,012) 30399 - (1,033,012)
0 - - - 30400 - -
0 - - - 30401 - -
0 - - - 30402 - -
0 - - - 30403 - -
1,080,036.31 (1,080,036) - (1,080,036) 30404 (1,080,036.31) -
0 - - - 30405 - -
0 - - - 30406 - -
0 - - - 30407 - -
1,080,036.31 (1,080,036) - (1,080,036) 30499 - (1,080,036)
0 - - - 30500 - -
Trial BalanceJADE eServices Pvt. Ltd.-Live 01/31/2024arun.sPage 101
0 - - - 30501 - -
0 - - - 30599 - -
0 - - - 30600 - -
10,610,856.12 (10,610,856) (2,397,289) (13,008,145) 30601 (13,008,145.12) -
0 - - - 30602 - -
342,797.93 (342,798) - (342,798) 30603 (342,797.93) -
25,432,041 (25,432,041) - (25,432,041) 30604 (25,432,041.00) -
36,385,695.05 (36,385,695) - (36,385,695) 30699 - (36,385,695)
1,359,738,752.49 (1,359,738,752) - (1,359,738,752) 30999 0 (1,359,738,752)
0 - - - 31100 0 -
0 - - - 31101 - -
0 - - - 31199 - -
0 - - - 31200 - -
15,575,345 (15,575,345) - (15,575,345) 31201 (15,575,345.00) -
1,375,314,097.49 (1,375,314,097) - (1,375,314,097) 39990 - (1,375,314,097)
1,375,314,097.49 (1,375,314,097) - (1,375,314,097) #N/A #N/A #N/A
0 - - - 40110 #N/A #N/A
0 - - - 40100 - -
0 - - - 40101 - -
0 1,323,585,901 42,535,680 1,366,121,581 40102 1,366,121,580.56 -
0 20,282,293 - 20,282,293 40103 20282293.1 -
1,361,179,735.32 (1,361,179,735) - (1,361,179,735) 40104 -1361179735.32 -
0 117,105,281 31,933,282 149,038,562 40105 149038562.2 -
24,328,334.49 (24,328,334) (3,460,960) (27,789,295) 40106 (27,789,294.59) -
0 - - - 40107 - -
0 42,720,510 - 42,720,510 40108 42,720,510.06 -
0 7,500 - 7,500 40134 7,500.00 -
0 1,164,688 - 1,164,688 40110 1,164,688.00 -
0 89,995 - 89,995 40111 89,995.00 -
0 23,234 - 23,234 40112 23,234.00 -
0 29,957 - 29,957 40113 29,957.00 -
0 - - - #N/A #N/A #N/A
0 503,798 - 503,798 40123 503798.4 -
Trial BalanceJADE eServices Pvt. Ltd.-Live 01/31/2024arun.sPage 102
0 - - - 40400 - -
0 5,757,314 552,587 6,309,901 40401 6,309,901.00 -
0 127,710 - 127,710 40402 127,710.00 -
0 97,895 - 97,895 40403 97,895.00 -
0 767,238 - 767,238 40404 767,238.00 -
0 6,750,157 - 6,750,157 40499 - 6,750,157
0 - - - 40500 - -
0 43,576 - 43,576 40501 43,576.00 -
0 - - - 40502 - -
0 12,195,576 725,000 12,920,576 40503 12,920,575.83 -
0 349,485 - 349,485 40504 349,485.00 -
0 1,219,700 - 1,219,700 40505 1,219,700.00 -
0 13,808,337 - 13,808,337 40599 - 13,808,337
0 - - - 40600 - -
0 963,682,771 122,523,831 1,086,206,602 40601 1,086,206,601.94 -
0 5,562,080 - 5,562,080 40602 5,562,079.76 -
0 - - - 40603 - -
0 - - - 40604 - -
0 1,151,060 - 1,151,060 40605 1,151,059.81 -
0 430,317 - 430,317 40606 430,317.00 -
0 31,631 - 31,631 40607 31,631.00 -
0 970,857,859 - 970,857,859 40699 - 970,857,859
0 - - - 40700 - -
0 4,189,431 - 4,189,431 40800 4,189,431.00 -
0 - - - 40900 - -
0 9,692,500 1,070,000 10,762,500 40901 10,762,500.00 -
0 15,275,732 400,000 15,675,732 40902 15,675,732.00 -
0 901,955 22,000 923,955 40903 923,955.00 -
0 1,664,217 120,000 1,784,217 40904 1,784,217.00 -
0 10,541,119 1,450,000 11,991,119 40905 11,991,118.50 -
0 - - - 40906 - -
0 - - - 40907 - -
0 1,443,750 - 1,443,750 40908 1,443,750.00 -
Trial BalanceJADE eServices Pvt. Ltd.-Live 01/31/2024arun.sPage 104
0 - - - 45400 - -
0 - - - 45401 - -
0 - - - 45402 - -
0 - - - 45403 - -
0 - - - 45499 - -
0 3,294,411,359 - 3,294,411,359 49999 - 3,294,411,359
6,405,687,251.01
GL Name Jan'13
43103 Rent others 15,000 103 office parking rent
43103 Rent others 5,000 rent others
43101 office Rent 7,023,948 109 office
22301 Provision for Expneses (7,043,948)
30201 Sales-Domestic
14507 Debtors-Others -
20803 Creditors-Security
15201 Security Deposits -
(398,000)
210,000 Name
125,000 Model Payment
275,000 Rakesh Kumar
(610,000) Manishshankar Mandal
Cab Bill
1,450,000 CCD Bill
(1,450,000) Emp. Mobile Exp.
Holisoil Emp
350,000 Holisoil Bill Amount
140,000 Housekeeping 35000
Stationery Bill Dec
74,000
Month 8900
(564,000)
- Prashum
1
2
128,000,000 3
(128,000,000) 4
5
(53,825,427) 6
(5,154,971) 7
(9,657,372)
(13,000,000)
(81,637,770)
100,000
850,000
1,000,000
(1,950,000)
800,000
(800,000)
800,000
(800,000)
1,800,000
(1,800,000)
25,000
(25,000)
1,124,046
(1,124,046)
453,669
380,000
100,000
(933,669)
437,250
1,120,500
(1,557,750)
25,000
65,000
(90,000)
47,000
225,000
20,974
35,000
60,000
22,000
8,000
(417,974)
4,490,750
(4,490,750)
40,000
32,000
700,000
400,000
6,000
(1,233,000)
(46,963,616)
9,430,694
37,532,922
28,264,892
(28,264,892)
(141,236,806)
141,236,806
261,743,902
(191,131,852)
(70,612,050)
3,000,000
(3,000,000)
-
Purpose Amount
Security Guard (March) 321913 536913
February (Salary for 399 employees) 3850000
Housekeeping (March) 215000
Sewerage Cleaning 20000
Canteen Food Reimbursement 118000
Electrical Bill 70000
Amount
700000
20000 Milk Exp.
5000 Canteen
Bill
400000
45000 Coffee Bill 70000
6000
35 399 434
400000
Airtel Bill 771058.68
Perfect Enterprises (Stationary) 65253.1
Tata Photon 429858
DTDC Couriers 210000
cabs 873680
First Flight Couriers 15000
Printing 20000
Particular April'12 May'12 June'12 July'12
Sales 52,027,135 83,028,730 80,274,581 102,229,648
* Net Sales 52,027,135 83,028,730 80,274,581 102,229,648
BOB data
Sales MRP 165,537,525 222,972,382
Coupon Money 15,253,542 10,724,972
Discount 21,580,657 44,148,532
Net of discount 78 75
Margin to Xerion 21 20
NSP 57 55
Cost net of taxes 70 70
Margin (13) (15)
(23) (27)
Sales 139.27
Average Cost
Average Number of Per Person per
Particulars Cost Employees month
( Rs. In Crores ) Number Rs. )
Salary 48.95 661 92,588
Contract Manpower 7.10 510 17,405
Total 56.04 1171 79,802
aug'12 Sept'12 Oct'12 Nov'12 Dec'12 Jan,13
112,475,159 74,456,413 101,126,537 139,548,905 163,957,511 202,947,266
112,475,159 74,456,413 101,126,537 139,548,905 163,957,511 202,947,266
4 6 7 8 9 7
26 10 10 13 13 26
27 24 24 24 24 24
70 84 83 79 78 67
19 20 20 19 19 16
51 64 63 54 53 46
70 70 70 61 61 50
(19) (6) (7) (7) (8) (4)
(37) (10) (12) (13) (14) (9)
Feb,13 March'13 YTD
175,951,065 171,982,638 1,392,720,385 -1075160291.907
175,951,065 171,982,638 1,392,720,385
as per TB
(175,430,636) (171,278,666) (1,635,922,432) -1635922432.07 0
(520,429) (703,972) (2,572,513) -2572513 0
- - (48,884) -48883.94 0
- - (178,377) (178,377)
37,876,666 35,271,660 341,654,437 341654437.03 0
- 4,574 437,529 437529 0
- - 17,130 17129.63 0
5,735,685 735,220 37,984,741 37984741.24 0
250,131,484 225,382,207
60,031,556 54,091,730
190,099,927 171,290,478
14,148,862
69 #DIV/0! 80
17 #DIV/0! 19.20
47 #DIV/0! 61
50 50 54.72
(3) #DIV/0! 68.00
(6) #DIV/0! (13)
age obtained from BOB
tained from BOB
Particular April'12 May'12 June'12
Sales MKTP
Sales Return
* Net Sales - - -
Purchase MKTP
Purchase Return MKTP
Net Purchases - - -
** Gross margin before other direct cost - - -
Gross Margin %
-179% -11%
33,768,870
46,953,063
12,949,452
3,147,687 2,809,420 2,471,224 2,236,833 2,436,623
10,526,914 11,279,750 10,114,232 2,371,364 -
1,312,356 -
- -
1,312,356 -
158,589,054 -
24,497,039 -
154,038,562 5,000,000
27,789,295 -
5,000,000
october
MKTP GRN DELHI 11865123.43
MUMBAI GRN 2502650.32
TOTAL 14367773.75
22457264.77121 oct