Made Ayu

12/12/2024 MYOB / Excel 10:50 AM Profit & Loss Statement January 2023 through June 2023 January Income Sales Room Sales Jabu 1 Sales Jabu 2 Sales Jabu 3 Sales Jabu 4 Sales Jabu 5 Sales Jabu 6 Sales Minibar Sales Minibar Jabu 1 Sales Minibar Jabu 2 Sales Minibar Jabu 3 Sales Minibar Jabu 4 Sales Minibar Jabu 5 Sales Minibar Jabu 6 Restaurant Sales Restaurant Sales Beverage Sales Room Breakfast Other Income Late Check Out Laundry Sales Rental Motor Transport Income Spa & Yoga Tour & Travel Comm Sales Other Commision income Guest No Show Currency Gain Loss Currency Gain Loss Currency Gain Loss Total Income Cost Of Sales F&B Cost Of Sales Cost of Food Cost of Beverage Other Income Cost of Sales Cost Of Guest Laundry Cost Of SPA & Yoga Cost Of Transportation & Commi COGS Other Total Cost Of Sales Gross Profit Expenses Wages & Salaries Other Employer Expenses General & Admin Expenses Expenses HK - PAYROLL & RELATED HK - Salaries & Wages HK - BPJS Healty HK - BPJS Pension HK - Casual Worker / Over Time HK - Bonus/THR/ AL HK - Employee Meals HK - Payroll Taxes & Benefits HK - Medical HK - Staff Other Benefit HK - Top Up SVC HK - OTHER EXPENSES HK - Uniforms & Tumbler HK - Telephone & Fax HK - Contract Services HK - Transportation HK - Postage / Express HK - Dues & Subscription HK - Training HK - Printing & Stationary HK - Entertainment HK - Officer Check HK - Photography HK - Travelling Expenses HK - Comp. Room HK - Operating Supplies/equipm February March April May June Total 75,099,562 83,786,376 54,990,321 61,123,392 81,805,358 82,765,901 79,403,514 85,198,255 72,760,518 60,831,302 59,283,211 68,428,800 82,412,353 69,670,672 55,148,544 37,774,598 109,260,517 110,744,407 106,763,392 74,787,356 74,878,303 102,751,098 103,567,251 113,923,814 74,256,078 93,687,600 69,365,642 58,658,396 116,646,282 127,590,492 101,900,215 97,164,470 101,405,310 94,740,282 108,122,065 105,281,781 519,835,114 504,294,729 428,548,638 415,879,069 578,684,684 608,735,195 690,000 1,215,000 240,000 165,000 45,000 400,000 1,550,000 120,000 90,000 360,000 330,000 745,000 395,000 445,000 165,000 120,000 495,000 910,000 255,000 90,000 544,545 1,290,000 45,000 90,000 660,000 90,000 1,045,000 2,620,000 1,010,000 400,000 790,000 135,000 774,380 565,000 3,800,000 3,905,000 2,345,000 1,024,545 2,464,380 5,345,000 46,491,500 - 53,706,000 - 43,931,000 - 59,956,000 - 57,614,466 - 61,292,181 - 322,991,147 - 5,554,545 6,209,835 5,144,500 1,370,000 506,696,290 2,350,000 5,400,000 2,104,546 250,000 18,031,749 510,597,894 488,000 7,700,248 4,860,000 5,705,785 225,000 530,286,124 14,924,793 10,856,942 3,925,620 932,500 670,356,615 8,297,108 8,330,581 1,050,000 1,500,000 621,546,645 238,000 8,476,859 9,090,295 6,086,186 252,500 697,724,525 726,000 47,303,554 44,747,653 24,016,637 4,530,000 18,031,749 3,537,208,094 29,541,049 22,598,764 25,639,713 11,494,129 39,935,341 46,859,084 20,061,385 27,766,296 32,691,314 25,209,086 71,027,910 138,315,710 218,896,711 272,243,069 4,100,000 3,195,000 3,450,000 62,884,813 4,000,000 2,150,000 43,283,842 5,400,000 5,505,000 2,420,000 100,119,425 8,150,000 10,500,000 2,310,000 68,787,681 5,850,000 5,250,000 950,000 69,950,400 8,750,000 218,093,620 36,250,000 26,600,000 9,130,000 563,119,780 443,811,477 467,314,052 430,166,700 601,568,934 551,596,246 479,630,905 2,974,088,313 - - - - - 9,950,000 200,000 415,800 20,000 303,000 - 10,500,000 225,000 415,800 12,200 (303,000) - 11,380,000 225,000 415,800 9,120,000 56,280 - 11,270,000 225,000 415,800 - 11,490,000 225,000 415,800 5,000,000 20,600 - 1,110,000 39,900 4,551,363 5,000 199,950 150,000 1,267,500 109,000 1,638,039 25,500 67,000 1,900,000 1,110,000 24,000 1,956,789 34,400 455,000 1,225,000 70,000 2,248,462 18,100 263,810 1,110,000 104,500 8,567,489 760,050 Page 1 - 1,110,000 201,500 12,726,437 71,000 - 54,590,000 1,100,000 2,079,000 14,120,000 109,080 2,505,000 6,932,500 548,900 31,688,579 48,600 1,396,210 12/12/2024 HK - Linen HK - Room Amenities HK - Glassware & Chinaware HK - Silverware HK - Cleaning Supplies HK - Guest Supplies HK - Paper Supplies HK - Decoration HK - Menus HK - Up Sell HK - Equipment Rental HK - Licenses & Fees HK - Music & Entertainment HK - Laundry Guest HK - Guest Transportation HK - Travel Agency Commission HK - Cable & TV Satelite HK - Breakfast Allocation HK - Internet HK - Comp. Welcome Drink/Canap HK - Comp. Afternoon Tea & B'd HK - Newspaper & Magazine HK - Guest Relocation HK - Other Expenses HK - Laundry Linen HK - Comp. Tour HK - Guest Expense HK - Laundry Uniform F&B - PAYROLL & RELATED F&B - Salaries & Wages F&B - BPJS Healty F&B - BPJS Pension F&B - Casual Worker / Over Tim F&B - Bonus/THR/AL F&B - Employee Meals F&B - Payroll Taxes & Benefits F&B - Medical F&B - Staff Other Benefit F&B - Top Up SVC F&B - OTHER EXPENSES F&B Uniforms & Tumbler F&B Telephone & Fax F&B Contract Services F&B Transportation F&B Postage / Express F&B Dues Subscription F&B Training F&B Printing & Stationary F&B Laundry & Dry Cleaning Uni F&B Entertainment F&B Officer Check F&B Special Promotion F&B Travelling Expenses F&B Spoilage F&B Upsell F&B Linen F&B Chinaware & Glassware F&B Glassware F&B Silverware F&B Cleaning Supplies F&B Guest Supplies F&B Printing & Stationary F&B Decorations F&B Menus F&B Kitchen Bar Utensil F&B Licenses F&B Music & Entertainment F&B Laundry & Dry Cleaning Lin F&B Kitchen Gas F&B Food & Bev Tasting F&B Kitchen Consultant fee F&B Bar Consultant fee F&B Events Expense F&B Working Permit F&B Complimentary F&B Other Expenses F&B Kitchen & Bar Utiliies F&B Maintenance A&G - PAYROLL & RELATED A&G - Salaries & Wages A&G - BPJS Healty A&G - BPJS Pension A&G - Casual Worker / Over Ti A&G - Bonus/THR/AL A&G - Employee Meals MYOB / Excel 10:50 AM 14,640,700 600,000 1,858,500 785,000 3,571,500 1,148,000 7,220,500 - 12,628,400 3,696,712 1,395,000 1,718,000 68,500 140,000 7,864,200 - 720,000 6,059,980 600,000 474,090 1,120,000 1,600,000 1,592,000 2,750,000 25,000 7,474,000 100,000 - 18,393,220 3,034,568 950,000 2,506,500 480,500 9,600,600 - 6,320,340 29,271,374 600,000 1,445,602 750,000 2,132,000 15,000 8,650,700 300,000 39,500 36,791,512 974,576 2,521,441 20,000 42,435 - 37,396,512 1,241,384 2,558,744 12,200 - 38,661,511 1,241,384 2,573,202 16,653,575 56,280 - 39,460,348 1,241,384 2,865,542 10,000,000 - 40,231,511 1,241,384 2,865,542 17,000,000 20,600 - 1,150,000 50,000 61,500 1,665,000 536,000 5,500,000 165,800 19,000 373,000 278,000 4,200,000 325,000 - 75,000 84,500 100,000 190,000 515,711 400,000 1,260,600 23,850 2,152,650 120,000 800,620 505,000 3,950,000 160,000 128,000 303,000 130,000 4,200,000 1,765,500 120,000 373,000 231,800 533,011 260,000 916,600 5,388,500 688,500 - 12,500 140,000 121,200 43,800 340,000 948,485 2,157,800 372,000 423,000 63,500 295,100 146,200 360,000 100,000 2,157,800 1,887,200 950,000 5,175,000 210,000 723,000 1,665,000 1,605,900 5,811,200 1,404,522 19,000 1,863,000 3,503,685 23,850 20,256,750 120,000 5,838,820 1,998,000 17,792,869 1,175,000 3,367,867 4,500,000 2,000,825 17,500,934 1,375,000 3,691,267 12,200 16,413,837 1,550,000 3,336,124 3,775,184 56,280 16,413,837 1,175,000 3,336,125 21,900,000 - 16,413,837 1,175,000 3,336,125 7,000,000 28,600 279,000 84,535,315 6,450,000 17,067,508 37,175,184 2,376,905 Page 2 10,000 7,304,993 600,000 1,494,156 3,380,000 30,000 13,307,770 524,500 - 7,050,340 88,298,667 2,400,000 12,003,628 8,380,000 1,600,000 11,520,000 4,447,000 210,000 54,117,770 924,500 39,500 192,541,394 5,940,112 13,384,471 43,653,575 109,080 42,435 - 12/12/2024 A&G - Payroll Taxes & Benefit A&G - Medical A&G - Staff Other Benefit A&G - Top Up SVC A&G - OTHER EXPENSES A&G - Uniforms & Tumbler A&G - Telephone & Fax A&G - Contract Services (IT) A&G - Transportation A&G - Postage / Express A&G - Dues & Subscription A&G - Training A&G - Printing & Stationary A&G - Laundry & Dry Cleaning A&G - Entertainment A&G - Officer Check A&G - Photography A&G - Travelling Expenses A&G - Systems Support A&G - Other Supplies A&G - Professional Services A&G - Licenses & Fees A&G - IT Exp Software A&G - IT Exp Hardware A&G - Credit Card Commissions A&G - Credit & Collection Exp A&G - Music & Entertainment A&G - Legal Fees A&G - Audit Fees A&G - GM&FC Meeting A&G - Bad Debt A&G - Provision For Bad Debt. A&G - Cashier Over/ Short A&G - Loss & Damages A&G - Insurance A&G - Employee Relations A&G - Difference Exchange Rat A&G - Training Expense A&G - Health & Sanitary A&G - Sport & Social activity A&G - Contract services A&G - Commision Agent A&G - Rental Office Expenses A&G - Bank Charge A&G - Decoration A&G - Other Expenses S&M - PAYROLL & RELATED S&M - Salaries & Wages S&M - BPJS Healty S&M - BPJS Pension S&M - Casual Worker / Over Ti S&M - Bonus/THR/AL S&M - Employee Meals S&M - Payroll Taxes & Benefit S&M - Medical S&M - Staff Other Benefit S&M - Top Up SVC S&M - OTHER EXPENSES S&M - Uniforms & Tumbler S&M - Telephone & Fax S&M - Contract Services S&M - Transportation S&M - Postage / Express S&M - Dues & Subscription S&M - Training S&M - Printing & Stationary S&M - Laundry & Dry Cleaning S&M - Officer Check S&M - Website (SEO, PPC & Go S&M - Media S&M - Brocure Contribution S&M - Sponsorship S&M - Promotion S&M - PR/Rep S&M - Reservation Log & Live S&M - Online Advertising S&M - Trade Show S&M - E-Commerce S&M - Gift and giveaway S&M - Hotel Advertising S&M - Video & Photography S&M - Comp. Room S&M - Collaterals S&M - Local Sales Call S&M - National Sales Call + T MYOB / Excel 53,000 133,500 1,739,226 829,000 12,775,000 2,948,333 433,333 1,926,202 - 10:50 AM 63,000 - 1,540,000 - 603,199 - 45,066 - 5,000 - 2,256,265 - 193,000 93,000 2,449,507 672,110 250,000 10,000,000 2,948,333 433,333 831,902 - 2,640,000 129,000 43,500 1,539,249 150,500 170,000 10,000,000 2,948,333 433,333 1,744,552 - 52,000 84,000 102,650 2,258,283 190,000 14,995,000 2,948,333 433,333 929,704 - 55,000 103,000 66,500 7,739,339 106,000 200,000 14,995,000 2,948,333 433,333 2,459,429 - 508,000 121,500 1,096,056 2,051,625 - 2,695,000 1,038,000 542,000 102,650 15,725,604 3,043,666 170,000 200,000 250,000 62,765,000 14,741,665 2,166,665 9,943,414 - 356,014 - 356,014 - 3,658,435 - 5,000,000 3,673,155 - Page 3 200,000 - - - 3,658,435 200,000 5,000,000 3,673,155 - 12/12/2024 S&M - International Sales Cal S&M - Travel S&M - Working Permit S&M - Education / Training S&M - Entertainment S&M - Other Expenses S&M - Commision Agent S&M - Credit Card Charge HR - PAYROLL & RELATED EXPENSE HR - Salaries & Wages HR - BPJS Healty HR - BPJS Pension HR - Casual Worker / Over Tim HR - Bonus/THR/AL HR - Employee Meals HR - Payroll Taxes & Benefits HR - Medical HR - Staff Other Benefit HR - Top Up SVC HR - OTHER EXPENSES HR - Uniforms & Tumbler HR - Telephone & Fax HR - Contract Services HR - Transportation HR - Postage / Express HR - Dues & Subscription HR - Training HR - Printing & Stationary HR - Laundry & Dry Cleaning U HR - Entertainment HR - Officer Check HR - Photography HR - Travelling Expenses HR - Licenses & Fees HR - Advertising HR - Recruitment HR - Donations HR - Security Other Expenses HR - Cleaning Expenses HR - Ceremonies HR - Health & Sanitary POMEC - PAYROLL & RELATED EXPE POMEG - Salaries & Wages POMEG - BPJS Healty POMEG - BPJS Pension POMEG - Casual Worker / Over POMEG - Bonus/THR/AL POMEG - Employee Meals POMEG - Payroll Taxes & Benef POMEG - Medical POMEG - Staff Other Benefit POMEG - Top Up SVC POMEC - OTHER EXPENSES POMEG - Uniforms & Tumbler POMEG - Telephone and Fax POMEG - Transportation POMEG - Pest control POMEG - Postage/Express POMEG - Due Subcription POMEG - Training POMEG - Printing & Stationary POMEG - Operating Supplies POMEG - Entertainment POMEG - Officer Check POMEG - Photography POMEG - Travelling Expenses POMEG - Cleaning Sup & Expense POMEG - Tools POMEG - Aircon & Ventilation POMEG - Building POMEG - Audio Visual And Sound POMEG - Electrical POMEG - Electric Bulbs POMEG - Internet & Wifi POMEG - Mechanical & equipment POMEG - Furniture POMEG - Grounds & Landscape/ga POMEG - F&B Kithcen & Refrig POMEG - Solar Panel System POMEG - Computer POMEG - Vehicle Maintenance POMEG - Painting & Decoration POMEG - Plumbing & Heating POMEG - Recreation Facilities POMEG - Genset MYOB / Excel 10:50 AM 1,694,300 55,244,415 10,817,915 980,100 52,499,194 10,160,540 638,550 47,598,234 10,080,557 146,410 68,876,125 17,222,552 1,457,751 51,766,865 13,136,543 9,163,837 158,192 597,259 20,000 - 9,103,837 165,000 597,259 12,200 - 9,323,837 165,000 597,259 8,663,837 56,280 - 9,323,837 165,000 597,258 - 10,423,837 165,000 597,258 5,000,000 20,600 - 96,600 37,682,000 2,042,500 1,856,000 - 800,000 300,000 1,040,000 - 10,175,000 100,000 1,565,000 - 1,765,000 1,000,000 - 2,500,000 4,630,000 12,735,000 - 11,700,000 316,384 693,000 20,000 - 11,640,000 533,192 693,000 12,200 - 11,860,000 533,192 693,000 4,875,000 56,280 - 11,750,000 375,000 693,000 - 11,970,000 375,000 693,000 6,000,000 20,600 - 279,000 2,082,449 18,000 781,300 464,000 450,000 17,264,068 680,000 1,665,000 3,010,000 356,000 - 545,000 90,000 2,117,075 577,860 173,300 527,831 17,212,492 680,000 1,665,000 1,792,400 43,698,000 467,000 79,940 940,000 2,117,075 10,000 880,000 294,500 138,000 16,472,228 336,000 1,665,000 5,541,999 7,727,500 608,000 - 113,500 2,117,075 73,500 482,000 2,620,000 91,000 18,353,227 695,000 1,665,000 501,560 3,150,000 113,000 - 95,000 2,117,075 8,500 2,489,000 695,000 565,000 19,833,756 800,000 1,665,000 637,000 4,400,000 577,000 50,000 Page 4 21,108,654 13,250,409 75,000 88,200,000 100,000 1,150,000 255,000 209,500 35,000 75,000 1,068,800 20,237,261 1,496,500 50,000 8,748,000 33,000 - 4,917,111 297,093,487 74,668,514 47,339,186 818,192 2,986,293 13,663,837 109,080 800,000 171,600 138,557,000 8,937,500 19,346,000 58,920,000 2,132,768 3,465,000 10,875,000 109,080 1,485,000 832,500 10,550,749 319,500 5,245,160 4,321,800 2,840,631 109,373,032 4,687,500 8,325,000 8,522,959 70,733,500 2,154,000 129,940 12/12/2024 POMEG - Pool POMEG - Office Equipment POMEG - Removal of Waste Matte POMEG - Life Safety POMEG - Locks & Keys POMEG - Water Treatment POMEG - STP POMEG - Other Expenses POMEG - Consultant & Certifica POMEG - Maintenance POMEG - ENERGY COST Maintenance Electricity Maintenance Diesel Fuel Maintenance Water & Sewage Depreciation - Amortization Rent Land Parking Expenses Rental Land Expenses Depreciation Expenses Pra Oprational Expenses Management - Expenses Management - Accommodation Management - Travel Management - Transport Management - Holystic Management - Pomec Material Management - Pomec Fee Management - Salary Staff Management - Cleaning Exp Management - Event Management - Linen Management - Kitchen Expenses Management - Decoration Management - Legal Fees Management - Laundry Invesment Expanses Common Arrea Invesment Expense Total Expenses Operating Profit Other Income Bank Intrest Other Income Selisih Kurs Rounding Total Other Income Other Expenses Tax Of Intrest PPh Psl 4 Ayat 2 PPh 21 Expenses PPh 23 Expenses PPh 26 Expenses PPN Other Expense Selisih Kurs Loss Expenses Service Charge Total Other Expenses Net Profit / (Loss) MYOB / Excel 4,014,000 2,321,000 987,000 - 4,014,000 2,322,000 2,555,000 4,414,000 873,300 - - 10:50 AM 5,594,000 1,678,000 18,421,160 - 5,094,000 2,765,000 10,172,887 - 1,500,000 1,377,460 2,950,000 - - 338,333 10,791,667 218,676,643 6,621,074 338,333 10,791,667 218,893,310 6,621,074 338,333 10,791,667 219,265,057 6,621,074 338,333 10,791,667 219,969,479 6,621,074 338,333 10,791,667 220,463,725 9,113,574 16,223,400 650,000 200,000 39,000,000 - 530,000 2,164,500 500,000 8,240,000 5,000,000 4,980,000 - 104,878,000 10,636,854 2,089,000 550,000 5,000,000 22,327,000 34,000,000 - 115,007,178 1,100,000 450,000 170,000 5,000,000 11,344,000 1,691,820 - 127,332,690 1,650,000 5,000,000 82,000 12,169,100 3,500,000 300,000 25,000 200,000 25,550 9,900,000 75,000 364,171,268 10,636,854 7,679,050 1,700,000 8,410,000 20,000,000 82,000 50,820,100 86,400,000 1,991,820 100,000 609,941,969 558,338,948 739,318,452 718,802,465 764,462,100 223,257,484 3,614,121,418 (166,130,492) (91,024,896) (309,151,752) (117,233,531) (212,865,854) 256,373,420 52,408 23,670 (168) 75,910 31,152 0 31,152 222,938 186,-,338 6,230 6,230 46,305 20,540,895 7,003,289 27,590,489 35,492 6,050 (46) 41,496 7,098 3,140,633 3,147,731 (169,236,728) 33,266 136,-,908 6,653 2,936,775 2,943,428 (93,798,416) 31,154 8,589 (9) 39,734 7,949 2,932,760 2,940,709 (312,052,726) Page 5 39,466 12,-,137 7,893 7,703,564 3,464,973 11,176,431 (128,357,824) 10,482 3,827,163 3,538,316 7,375,960 (220,165,904) - 24,630,000 10,463,460 35,959,347 256,398,342 1,691,667 53,958,333 1,097,268,215 35,597,872 (640,033,105) (667,213,256) 12/12/2024 MYOB / Excel Page 6 10:50 AM