0% found this document useful (0 votes)
60 views72 pages

Reconciling of Account

This document contains a list of account titles and their corresponding totals for a company. There are accounts for assets like cash, receivables, inventories and prepaid expenses. Liability accounts include accounts payable, accrued expenses, taxes payable and customer deposits. Revenue accounts include room sales, rental income and other income. Expense accounts cover employee costs, operating expenses, administrative expenses and depreciation. The document provides a snapshot of the company's financial position by outlining amounts for each of its key accounts.

Uploaded by

Carlo Cariaso
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
60 views72 pages

Reconciling of Account

This document contains a list of account titles and their corresponding totals for a company. There are accounts for assets like cash, receivables, inventories and prepaid expenses. Liability accounts include accounts payable, accrued expenses, taxes payable and customer deposits. Revenue accounts include room sales, rental income and other income. Expense accounts cover employee costs, operating expenses, administrative expenses and depreciation. The document provides a snapshot of the company's financial position by outlining amounts for each of its key accounts.

Uploaded by

Carlo Cariaso
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 72

Acctno Account Title Total

0-0-102- Cash in bank - BDO1 (005-838002847) (894,288.28) (894,288.27)


0-0-102- Cash in Bank-PNB EFPS 567,941.26 567,941.26
0-0-102- Cash in Bank-PNB 205970002924 46,364.29 46,364.32
0-0-102- Cash in Bank-Security Bank Payroll Account 94,568.15 94,568.16
0-0-103- Payroll fund (6,500.00) (6,500.00)
0-0-104- Accounts receivable - Guest Checkin 24,648.77 -
0-0-104- Accounts receivable - Customers (49,427.50) (24,778.75)
0-0-104- Accounts receivable - Credit cards (117,235.00) 11,590.00
0-0-104- Accounts receivable - Employees 2,142.32 2,142.31
0-0-104- Accounts receivable - Affiliates (183,270.89) (183,270.89)
0-0-104- Accounts receivable - Officers 9,345.00 9,345.00
0-0-104- Accounts receivable - Debit cards 128,825.00 -
0-0-105- Advances to officers 600,000.00 600,000.00
0-0-106- Advances to employees 171,269.37 171,269.37
0-0-107- Advances to suppliers (28,087.72) (28,087.72)
0-0-107- Advances to others 2,000.00 2,000.00
0-0-108- Accounts receivable - Others 3,519.19 3,519.16
0-0-109- Prepaid Others 12,500.02 12,500.00
0-0-110- Prepaid Taxes and licenses (20,899.43) (20,899.43)
0-0-110- Prepaid Insurance 38,064.96 38,064.97
0-0-110- Prepaid ads and promotions 4,000.00 4,000.00
0-0-108- Inventories - Supplies 43,741.37 43,741.37
0-0-108- Inventories - Cleaning supplies - -
0-0-113- Accumulated depreciation - Land improvements (171,380.74) (171,380.72)
0-0-114- Accumulated depreciation - Hotel building (89,469.00) (89,469.01)
0-0-114- Accumulated depreciation - Grand Pavillon (104,658.16) (104,658.16)
0-0-115- Accumulated depreciation - Leasehold improvem (102,710.21) (102,710.21)
0-0-116- Equipment 265,807.14 265,807.14
0-0-116- Accumulated depreciation - Equipments (215,500.54) (215,500.53)
0-0-116- Accumulated depreciation - delivery equipments (8,198.94) (8,198.94)
0-0-116- Accumulated depreciation - kitchen and bar equi (29,773.85) (29,773.86)
0-0-116- Accumulated depreciation - sound system & band (20,802.48) (20,802.48)
0-0-118- Accumulated depreciation - Furnitures and fixture (64,634.68) (64,634.69)
0-0-119- Accumulated depreciation - Software and compu (20,364.65) (20,364.65)
0-0-120- Accumulated depreciation - Kitchen utensils (7,930.44) (7,930.44)
0-0-121- Accumulated depreciation - Glasswares and silve (9,470.46) (9,470.46)
0-0-122- Linen and draperies 18,750.00 18,750.00
0-0-122- Accumulated depreciation - Linen and draperies (43,332.25) (43,332.25)
0-0-123- Other fixed assets 7,020.00 7,020.00
0-0-123- Accumulated depreciation - Other fixed assets (55,219.38) (55,219.38)
0-0-111- Input Vat 143,019.33 143,019.35
0-0-201- Accounts payable - Trade 722,120.60 722,120.59
0-0-201- Accounts payable - Non-trade 200,073.82 200,073.81
0-0-201- Accounts payable - Affilates 696,348.27 696,348.27
0-0-202- Accrued expenses payable 288,307.31 288,307.31
0-0-202- Service Charge Payable (198,512.97) (198,512.96)
0-0-203- Withholding tax payable - 1601C (8,254.70) (8,254.70)
0-0-203- Withholding tax payable - 1601E (44,946.58) (44,946.58)
0-0-204- SSS premiums payable (54,172.50) (54,172.50)
0-0-204- HDMF premiums payable (4,100.00) (4,100.00)
0-0-204- PHIC premiums payable (11,898.55) (11,898.55)
0-0-205- HDMF loans payable 2,586.86 2,586.86
0-0-210- Output Vat (515,445.94) (515,445.95)
0-0-211- Customer's deposits 1,490,014.85 1,490,014.85
0-0-302- Retained earnings (54,366.58) (54,366.58)
0-0-402- Room sales (4,129,035.90) (4,129,035.93)
0-0-402- Extra Bed (565,532.04) -
0-0-404- Rental Income (1,843,392.86) -
0-0-402- Extra person (312.50) -
0-0-402- Massage fees (1,874.99) -
0-0-404- Other Income (61,927.73) -
0-0-501- Basic - OE 319,228.27 319,228.28
0-0-501- Overtime - OE 10,810.12 10,810.13
0-0-501- Manpower Services - OE 208,045.78 208,045.81
0-0-501- Service Fees - OE 65,046.00 65,046.00
0-0-502- SSS Premiums contribution 24,882.50 -
0-0-502- Insurance - EB 12,362.69 12,362.69
0-0-502- Employee benefits - OE 37,225.00 37,225.00
0-0-502- HDMF premiums contribution 1,600.00 -
0-0-502- PHIC premiums contribution 3,715.45 -
0-0-502- Allowances - OE 56,092.32 56,092.32
0-0-502- 13th Month pay - OE 26,602.37 26,602.36
0-0-502- Separation and Retirement benefits - OE 78,000.00 78,000.00
0-0-502- Uniform - OE 2,410.00 2,410.00
0-0-502- Incentives - EB 40,000.00 40,000.00
0-0-503- Rental 248,722.72 248,722.70
0-0-503- Water bill 14,897.70 14,897.70
0-0-503- Cable subscription 19,975.00 19,975.00
0-0-503- Communications 80,839.75 80,839.77
0-0-503- Taxes and licenses 113,002.34 113,002.34
0-0-503- Security services 189,661.58 189,661.58
0-0-503- Laundry expenses 171,179.71 171,179.71
0-0-503- Representation 2,000.00 2,000.00
0-0-503- Management fee 198,111.13 198,111.13
0-0-503- Depreciation 943,445.78 943,445.77
0-0-503- Insurance 1,375.00 1,375.00
0-0-503- Supplies 104,863.38 156,830.69
0-0-503- Miscellaneous expenses 200.00 200.00
0-0-503- Advertising and promotions 8,422.00 8,422.00
0-0-503- Repairs and maintenance 29,621.17 29,621.18
0-0-503- Cleaning Supplies 29,163.83 -
0-0-503- Maintenance Supplies 22,514.45 -
0-0-503- Transportation expense 230.00 230.00
0-0-503- Gasoline, oil and lubricants 16,619.40 16,619.38
0-0-503- Light and power 573,920.93 573,920.93
0-5-503- Office Supplies 289.00 -
0-0-501- Basic - AE 183,283.19 183,283.18
0-0-501- Overtime - AE 12,675.03 12,675.04
0-0-501- Service fees - AE 41.06 -
0-0-502- SSS premiums contribution - Admin 15,530.00 -
0-0-502- HDMF premiums contribution - Admin 1,100.00 -
0-0-502- PHIC premiums contribution - Admin 2,505.00 -
0-0-502- Allowances - AE 8,000.00 8,000.00
0-0-502- 13th Month pay - AE 15,273.61 15,273.60
0-0-502- Separation and Retirement benefits - AE 67,500.00 67,500.00
0-0-503- Communication - AE 2,138.57 2,138.57
0-0-503- Insurance - AE 4,942.66 4,942.66
0-0-503- Training & Seminar - AE 2,598.00 2,598.00
0-0-503- Miscellaneous - AE 1,313.06 1,354.13
0-0-503- Employee benefits - AE 1,600.00 1,600.00
0-0-503- Admin share - AE 51,729.89 51,729.89
0-0-503- Head Office Allocation - AE 109,855.47 109,855.47
0-0-503- Office Supplies - AE 998.22 -
0-0-503- Transportation - AE 5,021.00 5,021.00
0-0-404- Interest income (476.82) (476.82)
0-0-404- Miscellaneous income (7,367.61) (7,417.33)
0-0-404- Overages / shortages (49.72) -
0-0-503- Provision For Income Tax (111,383.82) (111,383.82)
0-0-503- Bank charges 20,664.54 20,664.56
0-0-503- Income tax expense 111,383.82 111,383.82
Cash
(0.01) Cash in bank - BDO1 (0 (894,288.27) (894,288.28) 0.01
- Cash in bank - BDO2 (0 - - -
(0.03) Cash in Bank-PNB EFPS 567,941.26 567,941.26 -
(0.01) Cash in Bank-Security Ba 94,568.16 94,568.15 0.01
- Cash in Bank-PNB 2059 46,364.32 46,364.29 0.03
24,648.77 Petty cash fund - - -
(24,648.75) Change fund - - -
(128,825.00) Marketing Fund - - -
0.01 Payroll Fund (6,500.00) (6,500.00) -
- Purchasing Fund - - -
- Emergency Fund - - -
128,825.00 Accounts receivable - TRADE - - -
- Accounts receivable - C (24,778.75) (49,427.50) 24,648.75
(0.00) Accounts receivable - Cr 11,590.00 (117,235.00) 128,825.00
- Accounts receivable - Debit ca - 128,825.00 (128,825.00)
- Accounts receivable - - - -
0.03 Accounts receivable - Off 9,345.00 9,345.00 -
0.02 Accounts receivable - E 2,142.31 2,142.32 (0.01)
- Accounts receivable - Aff (183,270.89) (183,270.89) -
(0.01) Accounts receivable - Others 3,519.16 3,519.19 (0.03)
- Advances - - -
- Advances to Officers 600,000.00 600,000.00 -
- Advances to Employees 171,269.37 171,269.37 0.00
(0.02) Advances to Suppliers (28,087.72) (28,087.72) -
0.01 Advances to Others 2,000.00 2,000.00 -
0.00 Inventories - - -
(0.00) Inventories - Merchandi - - -
- Inventories - Raw Materi - - -
(0.01) Inventories - RM Food - - -
- Inventories - RM Bevera - - -
0.01 Inventories - Supplies 43,741.37 43,741.37 -
- Inventories - Unused sup - - -
0.01 Inventories - Housekeepi - - -
- Inventories - Maintenanc - - -
- Inventories - Cleaning su - - -
- Inventories - Kitchen & D - - -
- Inventories - Office Supp - - -
- Inventories - Promotional ite - - -
- Inventories - Uniform - - -
(0.00) Prepaid expenses - - -
(0.02) Prepaid Insurance 38,064.97 38,064.96 0.01
0.01 Prepaid Taxes and licens (20,899.43) (20,899.43) -
0.01 Prepaid ads and promot 4,000.00 4,000.00 -
0.01 Prepaid Rent - - -
(0.00) Prepaid Others 12,500.00 12,500.02 (0.02)
(0.01) Input Vat 143,019.35 143,019.33 0.02
- Container deposits - - -
0.00 Security deposit - - -
- Property Plant and - - -
- Land improvements - - -
- Accumulated deprecia (171,380.72) (171,380.74) 0.02
0.00 Hotel building - - -
0.02 Accumulated depreciat (89,469.01) (89,469.00) (0.01)
- Grand Pavillon building - - -
- Accumulated depreciat (104,658.16) (104,658.16) (0.00)
0.03 Leasehold improvement - - -
(565,532.04) Accumulated deprecia (102,710.21) (102,710.21) 0.00
(1,843,392.86) Equipment 265,807.14 265,807.14 -
(312.50) Accumulated deprecia (215,500.53) (215,500.54) 0.01
(1,874.99) Delivery equipment - - -
(61,927.73) Accumulated deprecia (8,198.94) (8,198.94) -
(0.00) Office Equipments - - -
(0.01) Accumulated deprecia - - -
(0.03) Kitchen and bar equipm - - -
- Accumulated deprecia (29,773.86) (29,773.85) (0.01)
24,882.50 Sound system & band in - - -
- Accumulated deprecia (20,802.48) (20,802.48) -
- Furnitures and fixtures - - -
1,600.00 Accumulated depreciat (64,634.69) (64,634.68) (0.01)
3,715.45 Software and computer - - -
0.00 Accumulated deprecia (20,364.65) (20,364.65) -
0.01 Kitchen utensils - - -
- Accumulated depreciat (7,930.44) (7,930.44) -
- Glasswares and silverwa - - -
- Accumulated deprecia (9,470.46) (9,470.46) -
0.02 Linen and draperies 18,750.00 18,750.00 -
- Accumulated depreciat (43,332.25) (43,332.25) -
- Motor vehicles - - -
(0.02) Accumulated deprecia - - -
- Other fixed assets 7,020.00 7,020.00 -
- Accumulated depreciation - Other fixed assets (55,219.38) (55,219.38) 0.00
- TOTAL DEPRECIATION - - -
- - - -
- Accounts payable - - -
0.01 Accounts payable - Trad 722,120.59 722,120.60 (0.01)
- Accounts payable - Non-trade 200,073.81 200,073.82 (0.01)
(51,967.31) Accounts payable - Affila 696,348.27 696,348.27 (0.01)
- Withholding tax payable - - -
- Withholding tax payable - 16 (8,254.70) (8,254.70) -
(0.01) Withholding tax payable (44,946.58) (44,946.58) (0.00)
29,163.83 SSS, HDMF & PHIC prem - - -
22,514.45 SSS premiums payable (54,172.50) (54,172.50) -
- HDMF premiums payabl (4,100.00) (4,100.00) -
0.02 PHIC premiums payable (11,898.55) (11,898.55) -
- SSS, HDMF & PHIC loans - - -
289.00 SSS loans payable - - -
0.01 HDMF loans payable 2,586.86 2,586.86 (0.00)
(0.01) PHIC loans payable - - -
41.06 Advances from officers - - -
15,530.00 Accrued expenses payable 288,307.31 288,307.31 0.00
1,100.00 Massage commissions payabl - - -
2,505.00 Output VAT (515,445.95) (515,445.94) (0.02)
- Cash bond payable - - -
0.01 Customer's deposits 1,490,014.85 1,490,014.85 -
- Service charge payable (198,512.96) (198,512.97) 0.01
(0.00) Unearned Income - - -
- Advances Affiliates - - -
- Provision for Income tax (111,383.82) (111,383.82) (0.00)
(41.07) - - -
- Paid-up Capital - - -
- Prior year's adjustments - - -
- Retained earnings (54,366.58) (54,366.58) -
998.22 - - -
- Room sales (4,129,035.93) (4,129,035.90) (0.03)
- Functions - Food - - -
49.72 Functions - Beverages - - -
(49.72) Restaurant Sales - Food - - -
0.00 Restaurant Sales - Bever - - -
(0.02) GnS Main - Food - - -
(0.00) GnS Main - Beverages - - -
GnS Samba - Food - - -
GnS Samba - Beverages - - -
Sales Discount - - -
Others (2,473,040.08) (2,473,040.12) 0.04
- - -
Food - - -
Beverages - - -
- - -
Salaries and Wages - - -
Basic - OE 319,228.28 319,228.27 0.00
Overtime - OE 10,810.13 10,810.12 0.01
Manpower Services - OE 208,045.81 208,045.78 0.03
Service Fees - OE 65,046.00 65,046.00 -
Employee's Benefits - - -
SSS, HDMF, PHIC premiums 30,197.95 30,197.95 -
Employees meal - OE - - -
Incentives - EB 40,000.00 40,000.00 -
Insurance - EB 12,362.69 12,362.69 -
Allowances - OE 56,092.32 56,092.32 (0.00)
13th Month pay - OE 26,602.36 26,602.37 (0.01)
Separation and Retirement 78,000.00 78,000.00 -
Employee benefits - OE 37,225.00 37,225.00 -
Uniform - OE 2,410.00 2,410.00 -
OTH - Employees - OE - - -
Rental 248,722.70 248,722.72 (0.02)
Light and power 573,920.93 573,920.93 -
Water bill 14,897.70 14,897.70 -
Kitchen fuel - - -
Cable subscription 19,975.00 19,975.00 -
Communications 80,839.77 80,839.75 0.02
Taxes and licenses 113,002.34 113,002.34 -
Security services 189,661.58 189,661.58 -
Laundry expenses 171,179.71 171,179.71 -
Donations and contribution - - -
Conference and meetings - - -
Trainings and seminars - - -
Representation 2,000.00 2,000.00 -
Dues and subscription - - -
Party / catering expense - - -
Corporate affairs - - -
Management fee 198,111.13 198,111.13 -
Professional fee - - -
Research and development - - -
Commission - - -
Depreciation 943,445.77 943,445.78 (0.01)
Insurance 1,375.00 1,375.00 -
Spoilage and breakages - - -
Supplies 156,830.69 156,830.66 0.03
Marketing communications - - -
Advertising and promotions 8,422.00 8,422.00 -
Ice expense - - -
Repairs and maintenance 29,621.18 29,621.17 0.01
Health and sanitation - - -
Transportation expense 230.00 230.00 -
Gasoline, oil and lubricants 16,619.38 16,619.40 (0.02)
Pre-Operating Expenses - - -
Miscellaneous expenses 200.00 200.00 -
- - -
Basic - AE 183,283.18 183,283.19 (0.01)
Overtime - AE 12,675.04 12,675.03 0.01
SSS, HDMF, PHIC premiums c 19,135.00 19,135.00 -
Allowances - AE 8,000.00 8,000.00 -
13th Month pay - AE 15,273.60 15,273.61 (0.01)
Separation and Retirement 67,500.00 67,500.00 -
Transportation - AE 5,021.00 5,021.00 -
Communication - AE 2,138.57 2,138.57 0.00
Supplies - AE 998.22 998.22 -
Employee benefits - AE 1,600.00 1,600.00 -
Representation - AE - - -
Training & Seminar - AE 2,598.00 2,598.00 -
Miscellaneous - AE 1,354.13 1,354.12 0.01
Admin share - AE 51,729.89 51,729.89 -
Head Office Allocation - AE 109,855.47 109,855.47 -
Conference and meetings - - - -
Professional fees - AE - - -
Insurance - AE 4,942.66 4,942.66 -
Repair and maintenance - - - -
Gasoline, oil and lubr - - -
- - -
Other Income: - - -
Interest income (476.82) (476.82) -
Miscellaneous incom (7,417.33) (7,417.33) -
Other Expenses: - - -
Bank charges 20,664.56 20,664.54 0.02
Interest expense - - -
Income tax expense 111,383.82 111,383.82 0.00
Acctno Account Title Total
0-0-102- Cash in bank - BDO1 (005-838002847) (32,287.03) (32,287.03)
0-0-102- Cash in Bank-PNB EFPS 173,201.32 173,201.32
0-0-102- Cash in Bank-PNB 205970002924 5,166.17 5,166.17
0-0-102- Cash in Bank-Security Bank Payroll Account 16,759.46 16,759.46
0-0-104- Accounts receivable - Guest Checkin (1,995.00) -
0-0-104- Accounts receivable - Customers 2,231.25 236.25
0-0-104- Accounts receivable - Credit cards 0.00 -
0-0-104- Accounts receivable - Employees (400.00) (400.00)
0-0-104- Accounts receivable - Debit cards - -
0-0-106- Advances to employees 89,986.10 89,986.10
0-0-107- Advances to suppliers 4,776.79 4,776.79
0-0-108- Accounts receivable - Others 1,655.82 1,655.82
0-0-109- Prepaid Others (2,083.33) (2,083.33)
0-0-110- Prepaid Taxes and licenses 20,313.25 20,313.25
0-0-110- Prepaid Insurance (2,689.09) (2,689.09)
0-0-108- Inventories - Supplies (15,316.61) (15,316.61)
0-0-113- Accumulated depreciation - Land improvements (26,030.60) (26,030.60)
0-0-114- Hotel building 53,450.89 53,450.89
0-0-114- Accumulated depreciation - Hotel building (15,744.84) (15,744.84)
0-0-114- Accumulated depreciation - Grand Pavillon (16,899.50) (16,899.50)
0-0-115- Accumulated depreciation - Leasehold improvem (17,118.36) (17,118.37)
0-0-116- Equipment 69,148.21 69,148.21
0-0-116- Accumulated depreciation - Equipments (39,022.31) (39,022.31)
0-0-116- Accumulated depreciation - delivery equipments (1,366.49) (1,366.49)
0-0-116- Accumulated depreciation - kitchen and bar equi (4,868.07) (4,868.07)
0-0-116- Accumulated depreciation - sound system & band (3,467.08) (3,467.08)
0-0-118- Furnitures and fixtures 2,499.00 2,499.00
0-0-118- Accumulated depreciation - Furnitures and fixture (8,797.36) (8,797.36)
0-0-119- Accumulated depreciation - Software and compu (2,955.93) (2,955.93)
0-0-120- Accumulated depreciation - Kitchen utensils (1,321.72) (1,321.72)
0-0-121- Accumulated depreciation - Glasswares and silve (273.49) (273.49)
0-0-122- Accumulated depreciation - Linen and draperies (3,308.82) (3,308.82)
0-0-123- Accumulated depreciation - Other fixed assets (8,014.64) (8,014.64)
0-0-111- Input Vat 54,537.98 54,537.99
0-0-201- Accounts payable - Trade (37,904.73) (37,904.73)
0-0-201- Accounts payable - Non-trade 125,043.19 125,043.19
0-0-201- Accounts payable - Affilates 400,838.97 400,838.97
0-0-202- Accrued expenses payable 5,241.88 5,241.89
0-0-202- Service Charge Payable (72,863.13) (72,863.13)
0-0-203- Withholding tax payable - 1601C (513.20) (513.20)
0-0-203- Withholding tax payable - 1601E (13,741.41) (13,741.41)
0-0-204- SSS premiums payable (14,635.00) (14,635.00)
0-0-204- HDMF premiums payable (1,400.00) (1,400.00)
0-0-204- PHIC premiums payable (3,097.74) (3,097.74)
0-0-205- HDMF loans payable (617.70) (617.70)
0-0-210- Output Vat (190,348.03) (190,348.05)
0-0-211- Customer's deposits 355,324.25 355,324.25
0-0-302- Retained earnings 2,212.32 2,212.32
0-0-402- Room sales (1,038,508.92) (1,038,508.92)
0-0-402- Extra Bed (213,385.72) -
0-0-404- Rental Income (305,000.00) -
0-0-402- Massage fees (357.15) -
0-0-404- Other Income (29,080.14) -
0-0-501- Basic - OE 50,984.82 50,984.82
0-0-501- Overtime - OE 1,443.40 1,443.40
0-0-501- Manpower Services - OE 41,212.74 41,212.74
0-0-501- Service Fees - OE 10,657.50 10,657.50
0-0-502- SSS Premiums contribution 4,385.00 -
0-0-502- Insurance - EB 3,411.43 3,411.43
0-0-502- Employee benefits - OE 6,155.00 6,155.00
0-0-502- HDMF premiums contribution 400.00 -
0-0-502- PHIC premiums contribution 712.52 -
0-0-502- Allowances - OE 1,846.15 1,846.15
0-0-502- 13th Month pay - OE 4,248.74 4,248.74
0-0-502- Incentives - EB 20,000.00 20,000.00
0-0-503- Rental 37,969.78 37,969.78
0-0-503- Water bill 1,912.56 1,912.56
0-0-503- Cable subscription 4,830.00 4,830.00
0-0-503- Communications 10,210.47 10,210.47
0-0-503- Taxes and licenses 13,137.61 13,137.61
0-0-503- Security services 32,428.22 32,428.22
0-0-503- Laundry expenses 40,508.90 40,508.90
0-0-503- Management fee 47,589.96 47,589.96
0-0-503- Depreciation 149,189.21 149,189.21
0-0-503- Insurance 1,375.00 3,659.33
0-0-503- Supplies 24,141.22 36,302.60
0-0-503- Advertising and promotions 5,510.00 5,510.00
0-0-503- Repairs and maintenance 12,850.34 12,850.34
0-0-503- Cleaning Supplies 12,161.38 -
0-0-503- Gasoline, oil and lubricants 3,469.09 3,469.09
0-0-503- Light and power 126,906.55 126,906.55
0-0-501- Basic - AE 34,839.67 34,839.67
0-0-501- Overtime - AE 991.58 991.59
0-0-502- SSS premiums contribution - Admin 3,077.50 -
0-0-502- HDMF premiums contribution - Admin 200.00 -
0-0-502- PHIC premiums contribution - Admin 463.90 -
0-0-502- Allowances - AE 4,500.00 4,500.00
0-0-502- 13th Month pay - AE 2,903.31 2,903.31
0-0-503- Communication - AE 500.00 500.00
0-0-503- Insurance - AE 4,755.66 2,471.33
0-0-503- Miscellaneous - AE 133.93 133.93
0-0-503- Admin share - AE 2,930.51 2,930.51
0-0-503- Head Office Allocation - AE 8,963.94 8,963.94
0-0-503- Office Supplies - AE 283.93 -
0-0-503- Transportation - AE 625.00 625.00
0-0-404- Miscellaneous income (902.50) (903.00)
0-0-404- Overages / shortages (0.50) -
0-0-503- Bank charges 9,112.78 9,112.78
-
-
Cash
- Cash in bank - BDO1 (0 (32,287.03) (32,287.03) -
- Cash in bank - BDO2 (0 - - -
(0.00) Cash in Bank-PNB EFPS 173,201.32 173,201.32 -
- Cash in Bank-Security Ba 16,759.46 16,759.46 -
(1,995.00) Cash in Bank-PNB 2059 5,166.17 5,166.17 0.00
1,995.00 Petty cash fund - - -
0.00 Change fund - - -
- Marketing Fund - - -
- Payroll Fund - - -
0.00 Purchasing Fund - - -
- Emergency Fund - - -
- Accounts receivable - TRADE - - -
0.00 Accounts receivable - C 236.25 2,231.25 (1,995.00)
- Accounts receivable - Cr - 0.00 (0.00)
- Accounts receivable - Debit ca - - -
- Accounts receivable - - - -
0.00 Accounts receivable - Off - - -
- Accounts receivable - E (400.00) (400.00) -
(0.00) Accounts receivable - Aff - - -
0.00 Accounts receivable - Others 1,655.82 1,655.82 -
0.01 Advances - - -
- Advances to Officers - - -
(0.00) Advances to Employees 89,986.10 89,986.10 (0.00)
- Advances to Suppliers 4,776.79 4,776.79 -
0.00 Advances to Others - - -
- Inventories - - -
- Inventories - Merchandi - - -
0.00 Inventories - Raw Materi - - -
- Inventories - RM Food - - -
- Inventories - RM Bevera - - -
- Inventories - Supplies (15,316.61) (15,316.61) -
- Inventories - Unused sup - - -
(0.00) Inventories - Housekeepi - - -
(0.01) Inventories - Maintenanc - - -
0.00 Inventories - Cleaning su - - -
- Inventories - Kitchen & D - - -
- Inventories - Office Supp - - -
(0.01) Inventories - Promotional ite - - -
0.00 Inventories - Uniform - - -
- Prepaid expenses - - -
0.00 Prepaid Insurance (2,689.09) (2,689.09) -
- Prepaid Taxes and licens 20,313.25 20,313.25 -
- Prepaid ads and promot - - -
- Prepaid Rent - - -
0.00 Prepaid Others (2,083.33) (2,083.33) (0.00)
0.01 Input Vat 54,537.99 54,537.98 0.01
- Container deposits - - -
- Security deposit - - -
- Property Plant and - - -
(213,385.72) Land improvements - - -
(305,000.00) Accumulated deprecia (26,030.60) (26,030.60) (0.00)
(357.15) Hotel building 53,450.89 53,450.89 -
(29,080.14) Accumulated depreciat (15,744.84) (15,744.84) 0.00
- Grand Pavillon building - - -
- Accumulated depreciat (16,899.50) (16,899.50) (0.00)
- Leasehold improvement - - -
- Accumulated deprecia (17,118.37) (17,118.36) (0.01)
4,385.00 Equipment 69,148.21 69,148.21 -
- Accumulated deprecia (39,022.31) (39,022.31) 0.00
- Delivery equipment - - -
400.00 Accumulated deprecia (1,366.49) (1,366.49) -
712.52 Office Equipments - - -
0.01 Accumulated deprecia - - -
0.01 Kitchen and bar equipm - - -
- Accumulated deprecia (4,868.07) (4,868.07) (0.00)
- Sound system & band in - - -
- Accumulated deprecia (3,467.08) (3,467.08) -
- Furnitures and fixtures 2,499.00 2,499.00 -
(0.00) Accumulated depreciat (8,797.36) (8,797.36) (0.00)
- Software and computer - - -
- Accumulated deprecia (2,955.93) (2,955.93) -
- Kitchen utensils - - -
- Accumulated depreciat (1,321.72) (1,321.72) -
(0.00) Glasswares and silverwa - - -
(2,284.33) Accumulated deprecia (273.49) (273.49) -
(12,161.38) Linen and draperies - - -
- Accumulated depreciat (3,308.82) (3,308.82) -
(0.00) Motor vehicles - - -
12,161.38 Accumulated deprecia - - -
(0.00) Other fixed assets - - -
- Accumulated depreciation - Other fixed assets (8,014.64) (8,014.64) 0.00
- TOTAL DEPRECIATION - - -
(0.00) - - -
3,077.50 Accounts payable - - -
200.00 Accounts payable - Trad (37,904.73) (37,904.73) (0.00)
463.90 Accounts payable - Non-trade 125,043.19 125,043.19 -
- Accounts payable - Affila 400,838.97 400,838.97 -
0.00 Withholding tax payable - - -
- Withholding tax payable - 16 (513.20) (513.20) -
2,284.33 Withholding tax payable (13,741.41) (13,741.41) (0.00)
- SSS, HDMF & PHIC prem - - -
- SSS premiums payable (14,635.00) (14,635.00) -
- HDMF premiums payabl (1,400.00) (1,400.00) -
283.93 PHIC premiums payable (3,097.74) (3,097.74) -
- SSS, HDMF & PHIC loans - - -
0.50 SSS loans payable - - -
(0.50) HDMF loans payable (617.70) (617.70) (0.00)
- PHIC loans payable - - -
- Advances from officers - - -
- Accrued expenses payable 5,241.89 5,241.88 0.01
- Massage commissions payabl - - -
Output VAT (190,348.05) (190,348.03) (0.01)
Cash bond payable - - -
Customer's deposits 355,324.25 355,324.25 -
Service charge payable (72,863.13) (72,863.13) (0.00)
Unearned Income - - -
Advances Affiliates - - -
Provision for Income tax - - -
- - -
Paid-up Capital - - -
Prior year's adjustments - - -
Retained earnings 2,212.32 2,212.32 -
- - -
Room sales (1,038,508.92) (1,038,508.92) -
Functions - Food - - -
Functions - Beverages - - -
Restaurant Sales - Food - - -
Restaurant Sales - Bever - - -
GnS Main - Food - - -
GnS Main - Beverages - - -
GnS Samba - Food - - -
GnS Samba - Beverages - - -
Sales Discount - - -
Others (547,823.00) (547,823.01) 0.01
- - -
Food - - -
Beverages - - -
- - -
Salaries and Wages - - -
Basic - OE 50,984.82 50,984.82 -
Overtime - OE 1,443.40 1,443.40 -
Manpower Services - OE 41,212.74 41,212.74 -
Service Fees - OE 10,657.50 10,657.50 -
Employee's Benefits - - -
SSS, HDMF, PHIC premiums 5,497.52 5,497.52 -
Employees meal - OE - - -
Incentives - EB 20,000.00 20,000.00 -
Insurance - EB 3,411.43 3,411.43 -
Allowances - OE 1,846.15 1,846.15 (0.01)
13th Month pay - OE 4,248.74 4,248.74 (0.01)
Separation and Retirement - - -
Employee benefits - OE 6,155.00 6,155.00 -
Uniform - OE - - -
OTH - Employees - OE - - -
Rental 37,969.78 37,969.78 -
Light and power 126,906.55 126,906.55 -
Water bill 1,912.56 1,912.56 -
Kitchen fuel - - -
Cable subscription 4,830.00 4,830.00 -
Communications 10,210.47 10,210.47 0.00
Taxes and licenses 13,137.61 13,137.61 -
Security services 32,428.22 32,428.22 -
Laundry expenses 40,508.90 40,508.90 -
Donations and contribution - - -
Conference and meetings - - -
Trainings and seminars - - -
Representation - - -
Dues and subscription - - -
Party / catering expense - - -
Corporate affairs - - -
Management fee 47,589.96 47,589.96 -
Professional fee - - -
Research and development - - -
Commission - - -
Depreciation 149,189.21 149,189.21 0.00
Insurance 3,659.33 1,375.00 2,284.33
Spoilage and breakages - - -
Supplies 36,302.60 36,302.60 (0.00)
Marketing communications - - -
Advertising and promotions 5,510.00 5,510.00 -
Ice expense - - -
Repairs and maintenance 12,850.34 12,850.34 0.00
Health and sanitation - - -
Transportation expense - - -
Gasoline, oil and lubricants 3,469.09 3,469.09 0.00
Pre-Operating Expenses - - -
Miscellaneous expenses - - -
- - -
Basic - AE 34,839.67 34,839.67 -
Overtime - AE 991.59 991.58 0.00
SSS, HDMF, PHIC premiums c 3,741.40 3,741.40 -
Allowances - AE 4,500.00 4,500.00 -
13th Month pay - AE 2,903.31 2,903.31 (0.00)
Separation and Retirement - - -
Transportation - AE 625.00 625.00 -
Communication - AE 500.00 500.00 -
Supplies - AE 283.93 283.93 (0.00)
Employee benefits - AE - - -
Representation - AE - - -
Training & Seminar - AE - - -
Miscellaneous - AE 133.93 133.93 -
Admin share - AE 2,930.51 2,930.51 -
Head Office Allocation - AE 8,963.94 8,963.94 -
Conference and meetings - - - -
Professional fees - AE - - -
Insurance - AE 2,471.33 4,755.66 (2,284.33)
Repair and maintenance - - - -
Gasoline, oil and lubr - - -
- - -
Other Income: - - -
Interest income - - -
Miscellaneous incom (903.00) (903.00) -
Other Expenses: - - -
Bank charges 9112.78 9,112.78 -
Interest expense 0 - -
Income tax expense 0 - -
Acctno Account Title Total
0-0-102- Cash in bank - BDO1 (005-838002847) (323,041.01) (323,041.01)
0-0-102- Cash in Bank-PNB EFPS 158,755.40 158,755.40
0-0-102- Cash in Bank-PNB 205970002924 (188,210.79) (188,210.79)
0-0-102- Cash in Bank-Security Bank Payroll Account 56,738.59 56,738.59
0-0-104- Accounts receivable - Guest Checkin 13,043.77 -
0-0-104- Accounts receivable - Customers 8,111.25 21,155.00
0-0-104- Accounts receivable - Credit cards - -
0-0-104- Accounts receivable - Employees (600.00) (600.00)
0-0-104- Accounts receivable - Affiliates 798.00 798.00
0-0-104- Accounts receivable - Debit cards - -
0-0-105- Advances to officers 550,000.00 550,000.00
0-0-106- Advances to employees 88,373.52 88,373.52
0-0-107- Advances to suppliers 17,312.50 17,312.50
0-0-108- Accounts receivable - Others 1,181.83 1,181.83
0-0-109- Prepaid Others (2,083.33) (2,083.33)
0-0-110- Prepaid Taxes and licenses (12,260.37) (12,260.37)
0-0-110- Prepaid Insurance 9,242.24 9,242.24
0-0-108- Inventories - Supplies 25,278.98 25,278.98
0-0-108- Inventories - Cleaning supplies (3,750.00) (3,750.00)
0-0-113- Accumulated depreciation - Land improvements (27,342.25) (27,342.25)
0-0-114- Accumulated depreciation - Hotel building (14,911.50) (14,911.50)
0-0-114- Accumulated depreciation - Grand Pavillon (16,899.50) (16,899.50)
0-0-115- Accumulated depreciation - Leasehold improvem (17,118.37) (17,118.37)
0-0-116- Equipment 51,800.00 51,800.00
0-0-116- Accumulated depreciation - Equipments (37,870.43) (37,870.43)
0-0-116- Accumulated depreciation - delivery equipments (1,366.49) (1,366.49)
0-0-116- Accumulated depreciation - kitchen and bar equi (4,868.07) (4,868.07)
0-0-116- Accumulated depreciation - sound system & band (3,467.08) (3,467.08)
0-0-118- Accumulated depreciation - Furnitures and fixture (10,191.87) (10,191.87)
0-0-119- Accumulated depreciation - Software and compu (2,955.93) (2,955.93)
0-0-120- Accumulated depreciation - Kitchen utensils (1,321.74) (1,321.74)
0-0-121- Accumulated depreciation - Glasswares and silve (281.61) (281.61)
0-0-122- Accumulated depreciation - Linen and draperies (6,200.01) (6,200.01)
0-0-123- Accumulated depreciation - Other fixed assets (8,600.67) (8,600.67)
0-0-111- Input Vat 33,078.57 33,078.56
0-0-201- Accounts payable - Trade 6,317.69 6,317.69
0-0-201- Accounts payable - Non-trade 130,477.72 130,477.72
0-0-201- Accounts payable - Affilates 350,000.00 350,000.00
0-0-202- Accrued expenses payable (48,601.18) (48,601.18)
0-0-202- Service Charge Payable (74,715.31) (74,715.29)
0-0-203- Withholding tax payable - 1601C (1,429.80) (1,429.80)
0-0-203- Withholding tax payable - 1601E (8,681.79) (8,681.79)
0-0-204- SSS premiums payable (14,355.00) (14,355.00)
0-0-204- HDMF premiums payable (1,200.00) (1,200.00)
0-0-204- PHIC premiums payable (3,237.60) (3,237.60)
0-0-205- HDMF loans payable (617.70) (617.70)
0-0-210- Output Vat (196,231.16) (196,231.16)
0-0-211- Customer's deposits 408,552.58 408,552.58
0-0-402- Room sales (1,080,516.61) (1,080,516.61)
0-0-402- Extra Bed (213,117.85) -
0-0-404- Rental Income (318,392.86) -
0-0-402- Massage fees (357.14) -
0-0-404- Other Income (22,875.22) -
0-0-501- Basic - OE 74,712.42 74,712.42
0-0-501- Overtime - OE 2,242.28 2,242.29
0-0-501- Manpower Services - OE 43,769.46 43,769.47
0-0-501- Service Fees - OE 8,400.00 8,400.00
0-0-502- SSS Premiums contribution 4,830.00 -
0-0-502- Insurance - EB 3,411.43 3,411.43
0-0-502- Employee benefits - OE 6,205.00 6,205.00
0-0-502- HDMF premiums contribution 300.00 -
0-0-502- PHIC premiums contribution 733.80 -
0-0-502- Allowances - OE 2,000.00 2,000.00
0-0-502- 13th Month pay - OE 6,226.03 6,226.03
0-0-502- Incentives - EB 20,000.00 20,000.00
0-0-503- Rental 37,675.22 37,675.22
0-0-503- Water bill 1,331.52 1,331.52
0-0-503- Cable subscription 2,687.50 2,687.50
0-0-503- Communications 10,134.95 10,134.95
0-0-503- Taxes and licenses 14,652.87 14,652.87
0-0-503- Security services 32,428.22 32,428.22
0-0-503- Laundry expenses 42,797.50 42,797.50
0-0-503- Management fee 49,020.17 49,020.17
0-0-503- Depreciation 153,395.52 153,395.52
0-0-503- Insurance 1,375.00 1,375.00
0-0-503- Supplies 20,523.87 28,731.24
0-0-503- Miscellaneous expenses 100.00 100.00
0-0-503- Repairs and maintenance 6,301.01 6,301.00
0-0-503- Cleaning Supplies 8,207.36 -
0-0-503- Transportation expense 30.00 30.00
0-0-503- Gasoline, oil and lubricants 3,403.57 3,403.57
0-0-503- Light and power 137,761.67 137,761.67
0-0-501- Basic - AE 30,106.91 30,106.91
0-0-501- Overtime - AE 720.85 720.86
0-0-501- Service fees - AE 19.64 -
0-0-502- SSS premiums contribution - Admin 2,442.50 -
0-0-502- HDMF premiums contribution - Admin 200.00 -
0-0-502- PHIC premiums contribution - Admin 540.00 -
0-0-502- 13th Month pay - AE 2,508.91 2,508.91
0-0-503- Communication - AE 437.50 437.50
0-0-503- Insurance - AE 2,471.33 2,471.33
0-0-503- Training & Seminar - AE 2,598.00 2,598.00
0-0-503- Employee benefits - AE 1,600.00 1,600.00
0-0-503- Admin share - AE 2,930.51 2,930.51
0-0-503- Head Office Allocation - AE 11,026.08 11,026.08
0-0-503- Office Supplies - AE 317.86 -
0-0-503- Transportation - AE 616.00 616.00
0-0-404- Miscellaneous income (1,086.11) (1,088.11)
0-0-404- Overages / shortages (2.00) -
0-0-503- Bank charges 6,503.25 6,503.25
Cash
- Cash in bank - BDO1 (0 (323,041.01) (323,041.01) -
- Cash in bank - BDO2 (0 - - -
- Cash in Bank-PNB EFPS 158,755.40 158,755.40 -
0.00 Cash in Bank-Security Ba 56,738.59 56,738.59 (0.00)
13,043.77 Cash in Bank-PNB 2059 (188,210.79) (188,210.79) -
(13,043.75) Petty cash fund - - -
- Change fund - - -
- Marketing Fund - - -
- Payroll Fund - - -
- Purchasing Fund - - -
- Emergency Fund - - -
(0.00) Accounts receivable - TRADE - - -
- Accounts receivable - C 21,155.00 8,111.25 13,043.75
- Accounts receivable - Cr - - -
0.00 Accounts receivable - Debit ca - - -
- Accounts receivable - - - -
- Accounts receivable - Off - - -
- Accounts receivable - E (600.00) (600.00) -
- Accounts receivable - Aff 798.00 798.00 -
0.00 Accounts receivable - Others 1,181.83 1,181.83 -
0.00 Advances - - -
0.00 Advances to Officers 550,000.00 550,000.00 -
(0.00) Advances to Employees 88,373.52 88,373.52 0.00
- Advances to Suppliers 17,312.50 17,312.50 -
(0.00) Advances to Others - - -
- Inventories - - -
0.00 Inventories - Merchandi - - -
- Inventories - Raw Materi - - -
0.00 Inventories - RM Food - - -
- Inventories - RM Bevera - - -
- Inventories - Supplies 25,278.98 25,278.98 -
- Inventories - Unused sup - - -
- Inventories - Housekeepi - - -
(0.00) Inventories - Maintenanc - - -
0.00 Inventories - Cleaning su (3,750.00) (3,750.00) -
0.00 Inventories - Kitchen & D - - -
0.00 Inventories - Office Supp - - -
- Inventories - Promotional ite - - -
0.00 Inventories - Uniform - - -
(0.01) Prepaid expenses - - -
- Prepaid Insurance 9,242.24 9,242.24 -
- Prepaid Taxes and licens (12,260.37) (12,260.37) -
- Prepaid ads and promot - - -
- Prepaid Rent - - -
- Prepaid Others (2,083.33) (2,083.33) (0.00)
0.00 Input Vat 33,078.56 33,078.57 (0.00)
(0.00) Container deposits - - -
- Security deposit - - -
(0.01) Property Plant and - - -
(213,117.85) Land improvements - - -
(318,392.86) Accumulated deprecia (27,342.25) (27,342.25) (0.00)
(357.14) Hotel building - - -
(22,875.22) Accumulated depreciat (14,911.50) (14,911.50) (0.00)
0.01 Grand Pavillon building - - -
(0.01) Accumulated depreciat (16,899.50) (16,899.50) (0.00)
(0.01) Leasehold improvement - - -
- Accumulated deprecia (17,118.37) (17,118.37) 0.00
4,830.00 Equipment 51,800.00 51,800.00 -
- Accumulated deprecia (37,870.43) (37,870.43) 0.00
- Delivery equipment - - -
300.00 Accumulated deprecia (1,366.49) (1,366.49) -
733.80 Office Equipments - - -
- Accumulated deprecia - - -
(0.00) Kitchen and bar equipm - - -
- Accumulated deprecia (4,868.07) (4,868.07) (0.00)
- Sound system & band in - - -
- Accumulated deprecia (3,467.08) (3,467.08) -
- Furnitures and fixtures - - -
- Accumulated depreciat (10,191.87) (10,191.87) (0.00)
- Software and computer - - -
- Accumulated deprecia (2,955.93) (2,955.93) -
- Kitchen utensils - - -
- Accumulated depreciat (1,321.74) (1,321.74) -
(0.00) Glasswares and silverwa - - -
- Accumulated deprecia (281.61) (281.61) -
(8,207.37) Linen and draperies - - -
- Accumulated depreciat (6,200.01) (6,200.01) -
0.01 Motor vehicles - - -
8,207.36 Accumulated deprecia - - -
- Other fixed assets - - -
(0.00) Accumulated depreciation - Other fixed assets (8,600.67) (8,600.67) 0.00
- TOTAL DEPRECIATION - - -
0.01 - - -
(0.01) Accounts payable - - -
19.64 Accounts payable - Trad 6,317.69 6,317.69 (0.00)
2,442.50 Accounts payable - Non-trade 130,477.72 130,477.72 (0.00)
200.00 Accounts payable - Affila 350,000.00 350,000.00 -
540.00 Withholding tax payable - - -
0.00 Withholding tax payable - 16 (1,429.80) (1,429.80) -
- Withholding tax payable (8,681.79) (8,681.79) -
- SSS, HDMF & PHIC prem - - -
- SSS premiums payable (14,355.00) (14,355.00) -
- HDMF premiums payabl (1,200.00) (1,200.00) -
- PHIC premiums payable (3,237.60) (3,237.60) -
- SSS, HDMF & PHIC loans - - -
317.86 SSS loans payable - - -
- HDMF loans payable (617.70) (617.70) (0.00)
2.00 PHIC loans payable - - -
(2.00) Advances from officers - - -
- Accrued expenses payable (48,601.18) (48,601.18) (0.00)
- Massage commissions payabl - - -
Output VAT (196,231.16) (196,231.16) 0.00
Cash bond payable - - -
Customer's deposits 408,552.58 408,552.58 -
Service charge payable (74,715.29) (74,715.31) 0.01
Unearned Income - - -
Advances Affiliates - - -
Provision for Income tax - - -
- - -
Paid-up Capital - - -
Prior year's adjustments - - -
Retained earnings - - -
- - -
Room sales (1,080,516.61) (1,080,516.61) 0.01
Functions - Food - - -
Functions - Beverages - - -
Restaurant Sales - Food - - -
Restaurant Sales - Bever - - -
GnS Main - Food - - -
GnS Main - Beverages - - -
GnS Samba - Food - - -
GnS Samba - Beverages - - -
Sales Discount - - -
Others (554,743.07) (554,743.07) 0.00
- - -
Food - - -
Beverages - - -
- - -
Salaries and Wages - - -
Basic - OE 74,712.42 74,712.42 (0.01)
Overtime - OE 2,242.29 2,242.28 0.01
Manpower Services - OE 43,769.47 43,769.46 0.01
Service Fees - OE 8,400.00 8,400.00 -
Employee's Benefits - - -
SSS, HDMF, PHIC premiums 5,863.80 5,863.80 -
Employees meal - OE - - -
Incentives - EB 20,000.00 20,000.00 -
Insurance - EB 3,411.43 3,411.43 -
Allowances - OE 2,000.00 2,000.00 -
13th Month pay - OE 6,226.03 6,226.03 0.00
Separation and Retirement - - -
Employee benefits - OE 6,205.00 6,205.00 -
Uniform - OE - - -
OTH - Employees - OE - - -
Rental 37,675.22 37,675.22 -
Light and power 137,761.67 137,761.67 -
Water bill 1,331.52 1,331.52 -
Kitchen fuel - - -
Cable subscription 2,687.50 2,687.50 -
Communications 10,134.95 10,134.95 -
Taxes and licenses 14,652.87 14,652.87 -
Security services 32,428.22 32,428.22 -
Laundry expenses 42,797.50 42,797.50 -
Donations and contribution - - -
Conference and meetings - - -
Trainings and seminars - - -
Representation - - -
Dues and subscription - - -
Party / catering expense - - -
Corporate affairs - - -
Management fee 49,020.17 49,020.17 -
Professional fee - - -
Research and development - - -
Commission - - -
Depreciation 153,395.52 153,395.52 0.00
Insurance 1,375.00 1,375.00 -
Spoilage and breakages - - -
Supplies 28,731.24 28,731.23 0.01
Marketing communications - - -
Advertising and promotions - - -
Ice expense - - -
Repairs and maintenance 6,301.00 6,301.01 (0.01)
Health and sanitation - - -
Transportation expense 30.00 30.00 -
Gasoline, oil and lubricants 3,403.57 3,403.57 0.00
Pre-Operating Expenses - - -
Miscellaneous expenses 100.00 100.00 -
- - -
Basic - AE 30,106.91 30,106.91 (0.01)
Overtime - AE 720.86 720.85 0.01
SSS, HDMF, PHIC premiums c 3,182.50 3,182.50 -
Allowances - AE - - -
13th Month pay - AE 2,508.91 2,508.91 (0.00)
Separation and Retirement - - -
Transportation - AE 616.00 616.00 -
Communication - AE 437.50 437.50 -
Supplies - AE 317.86 317.86 -
Employee benefits - AE 1,600.00 1,600.00 -
Representation - AE - - -
Training & Seminar - AE 2,598.00 2,598.00 -
Miscellaneous - AE 19.64 19.64 -
Admin share - AE 2,930.51 2,930.51 -
Head Office Allocation - AE 11,026.08 11,026.08 -
Conference and meetings - - - -
Professional fees - AE - - -
Insurance - AE 2,471.33 2,471.33 -
Repair and maintenance - - - -
Gasoline, oil and lubr - - -
- - -
Other Income: - - -
Interest income - - -
Miscellaneous incom (1,088.11) (1,088.11) -
Other Expenses: - - -
Bank charges 6503.25 6,503.25 -
Interest expense 0 - -
Income tax expense 0 - -
Acctno Account Title Total
0-0-102- Cash in bank - BDO1 (005-838002847) (443,513.59) (443,513.59)
0-0-102- Cash in Bank-PNB EFPS 240,630.33 240,630.33
0-0-102- Cash in Bank-PNB 205970002924 194,678.51 194,678.54
0-0-102- Cash in Bank-Security Bank Payroll Account 54,393.38 54,393.38
0-0-104- Accounts receivable - Guest Checkin (2,675.00) -
0-0-104- Accounts receivable - Customers 11,367.50 8,692.50
0-0-104- Accounts receivable - Credit cards (108,835.00) 19,990.00
0-0-104- Accounts receivable - Officers 9,345.00 9,345.00
0-0-104- Accounts receivable - Debit cards 128,825.00 -
0-0-106- Advances to employees 35,161.69 35,161.69
0-0-107- Advances to suppliers 18,312.28 18,312.28
0-0-108- Accounts receivable - Others 1,046.00 1,046.00
0-0-109- Prepaid Others (2,083.33) (2,083.33)
0-0-110- Prepaid Taxes and licenses (12,260.37) (12,260.37)
0-0-110- Prepaid Insurance 1,531.24 1,531.24
0-0-108- Inventories - Supplies 16,300.92 16,300.92
0-0-108- Inventories - Cleaning supplies 3,750.00 3,750.00
0-0-113- Accumulated depreciation - Land improvements (27,881.87) (27,881.87)
0-0-114- Accumulated depreciation - Hotel building (14,911.50) (14,911.50)
0-0-114- Accumulated depreciation - Grand Pavillon (16,899.50) (16,899.50)
0-0-115- Accumulated depreciation - Leasehold improvem (17,118.36) (17,118.37)
0-0-116- Equipment 27,000.00 27,000.00
0-0-116- Accumulated depreciation - Equipments (37,120.51) (37,120.50)
0-0-116- Accumulated depreciation - delivery equipments (1,366.49) (1,366.49)
0-0-116- Accumulated depreciation - kitchen and bar equi (4,868.07) (4,868.07)
0-0-116- Accumulated depreciation - sound system & band (3,467.08) (3,467.08)
0-0-118- Accumulated depreciation - Furnitures and fixture (10,282.95) (10,282.95)
0-0-119- Accumulated depreciation - Software and compu (2,955.93) (2,955.93)
0-0-120- Accumulated depreciation - Kitchen utensils (1,321.74) (1,321.74)
0-0-121- Accumulated depreciation - Glasswares and silve (1,672.53) (1,672.53)
0-0-122- Linen and draperies 18,750.00 18,750.00
0-0-122- Accumulated depreciation - Linen and draperies (6,825.13) (6,825.13)
0-0-123- Accumulated depreciation - Other fixed assets (9,860.68) (9,860.68)
0-0-111- Input Vat 48,104.27 48,104.28
0-0-201- Accounts payable - Trade 246,870.47 246,870.47
0-0-201- Accounts payable - Non-trade (39,791.26) (39,791.27)
0-0-201- Accounts payable - Affilates 395,806.86 395,806.86
0-0-202- Accrued expenses payable (24,031.51) (24,031.51)
0-0-202- Service Charge Payable (43,433.14) (43,433.14)
0-0-203- Withholding tax payable - 1601C (1,833.20) (1,833.20)
0-0-203- Withholding tax payable - 1601E (22,779.95) (22,779.95)
0-0-204- SSS premiums payable (11,495.00) (11,495.00)
0-0-204- HDMF premiums payable (600.00) (600.00)
0-0-204- PHIC premiums payable (2,828.65) (2,828.65)
0-0-205- HDMF loans payable (617.70) (617.70)
0-0-210- Output Vat (183,254.46) (183,254.46)
0-0-211- Customer's deposits 310,355.50 310,355.50
0-0-402- Room sales (1,054,959.16) (1,054,959.17)
0-0-402- Extra Bed (141,696.43) -
0-0-404- Rental Income (305,000.00) -
0-0-402- Massage fees (357.14) -
0-0-404- Other Income (25,107.80) -
0-0-501- Basic - OE 50,691.31 50,691.32
0-0-501- Overtime - OE 3,596.79 3,596.79
0-0-501- Manpower Services - OE 43,790.76 43,790.76
0-0-501- Service Fees - OE 8,190.00 8,190.00
0-0-502- SSS Premiums contribution 2,250.00 -
0-0-502- Insurance - EB 3,411.43 3,411.43
0-0-502- Employee benefits - OE 6,230.00 6,230.00
0-0-502- HDMF premiums contribution 200.00 -
0-0-502- PHIC premiums contribution 359.33 -
0-0-502- Allowances - OE 1,615.39 1,615.39
0-0-502- 13th Month pay - OE 4,224.28 4,224.28
0-0-502- Separation and Retirement benefits - OE 78,000.00 78,000.00
0-0-502- Incentives - EB 20,000.00 20,000.00
0-0-503- Rental 37,765.23 37,765.23
0-0-503- Water bill 3,737.73 3,737.73
0-0-503- Cable subscription 3,457.50 3,457.50
0-0-503- Communications 14,694.17 14,694.17
0-0-503- Taxes and licenses 13,210.55 13,210.55
0-0-503- Security services 31,382.14 31,382.14
0-0-503- Laundry expenses 35,835.70 35,835.70
0-0-503- Management fee 45,886.00 45,886.00
0-0-503- Depreciation 156,552.34 156,552.35
0-0-503- Supplies 22,462.51 39,818.72
0-0-503- Advertising and promotions 8,422.00 8,422.00
0-0-503- Repairs and maintenance 6,632.43 6,632.43
0-0-503- Cleaning Supplies 9,231.21 -
0-0-503- Maintenance Supplies 8,125.00 -
0-0-503- Transportation expense 200.00 200.00
0-0-503- Gasoline, oil and lubricants 5,892.86 5,892.86
0-0-503- Light and power 122,300.38 122,300.38
0-0-501- Basic - AE 32,139.94 32,139.94
0-0-501- Overtime - AE 1,913.82 1,913.82
0-0-501- Service fees - AE 10.71 -
0-0-502- SSS premiums contribution - Admin 3,355.00 -
0-0-502- HDMF premiums contribution - Admin 200.00 -
0-0-502- PHIC premiums contribution - Admin 480.00 -
0-0-502- Allowances - AE 5,500.00 5,500.00
0-0-502- 13th Month pay - AE 2,678.33 2,678.33
0-0-503- Communication - AE 437.50 437.50
0-0-503- Insurance - AE 2,471.33 2,471.33
0-0-503- Miscellaneous - AE 200.00 210.71
0-0-503- Admin share - AE 2,930.51 2,930.51
0-0-503- Head Office Allocation - AE 12,392.31 12,392.31
0-0-503- Office Supplies - AE 275.00 -
0-0-503- Transportation - AE 1,012.00 1,012.00
0-0-404- Miscellaneous income (6.50) (15.00)
0-0-404- Overages / shortages (8.50) -
0-0-503- Bank charges 7,147.57 7,147.57
-
Cash
- Cash in bank - BDO1 (0 (443,513.59) (443,513.59) -
- Cash in bank - BDO2 (0 - - -
(0.03) Cash in Bank-PNB EFPS 240,630.33 240,630.33 -
0.00 Cash in Bank-Security Ba 54,393.38 54,393.38 (0.00)
(2,675.00) Cash in Bank-PNB 2059 194,678.54 194,678.51 0.03
2,675.00 Petty cash fund - - -
(128,825.00) Change fund - - -
- Marketing Fund - - -
128,825.00 Payroll Fund - - -
0.00 Purchasing Fund - - -
- Emergency Fund - - -
- Accounts receivable - TRADE - - -
0.00 Accounts receivable - C 8,692.50 11,367.50 (2,675.00)
- Accounts receivable - Cr 19,990.00 (108,835.00) 128,825.00
- Accounts receivable - Debit ca - 128,825.00 (128,825.00)
- Accounts receivable - - - -
- Accounts receivable - Off 9,345.00 9,345.00 -
(0.00) Accounts receivable - E - - -
0.00 Accounts receivable - Aff - - -
0.00 Accounts receivable - Others 1,046.00 1,046.00 -
0.01 Advances - - -
- Advances to Officers - - -
(0.01) Advances to Employees 35,161.69 35,161.69 (0.00)
- Advances to Suppliers 18,312.28 18,312.28 -
0.00 Advances to Others - - -
- Inventories - - -
0.00 Inventories - Merchandi - - -
- Inventories - Raw Materi - - -
- Inventories - RM Food - - -
- Inventories - RM Bevera - - -
- Inventories - Supplies 16,300.92 16,300.92 -
- Inventories - Unused sup - - -
(0.00) Inventories - Housekeepi - - -
(0.01) Inventories - Maintenanc - - -
0.00 Inventories - Cleaning su 3,750.00 3,750.00 -
0.01 Inventories - Kitchen & D - - -
0.00 Inventories - Office Supp - - -
0.00 Inventories - Promotional ite - - -
0.00 Inventories - Uniform - - -
- Prepaid expenses - - -
(0.00) Prepaid Insurance 1,531.24 1,531.24 -
- Prepaid Taxes and licens (12,260.37) (12,260.37) -
- Prepaid ads and promot - - -
- Prepaid Rent - - -
- Prepaid Others (2,083.33) (2,083.33) (0.00)
0.00 Input Vat 48,104.28 48,104.27 0.01
- Container deposits - - -
0.01 Security deposit - - -
(141,696.43) Property Plant and - - -
(305,000.00) Land improvements - - -
(357.14) Accumulated deprecia (27,881.87) (27,881.87) 0.00
(25,107.80) Hotel building - - -
(0.01) Accumulated depreciat (14,911.50) (14,911.50) (0.00)
(0.00) Grand Pavillon building - - -
- Accumulated depreciat (16,899.50) (16,899.50) (0.00)
- Leasehold improvement - - -
2,250.00 Accumulated deprecia (17,118.37) (17,118.36) (0.01)
- Equipment 27,000.00 27,000.00 -
- Accumulated deprecia (37,120.50) (37,120.51) 0.01
200.00 Delivery equipment - - -
359.33 Accumulated deprecia (1,366.49) (1,366.49) -
0.00 Office Equipments - - -
0.00 Accumulated deprecia - - -
- Kitchen and bar equipm - - -
- Accumulated deprecia (4,868.07) (4,868.07) (0.00)
- Sound system & band in - - -
- Accumulated deprecia (3,467.08) (3,467.08) -
- Furnitures and fixtures - - -
(0.00) Accumulated depreciat (10,282.95) (10,282.95) (0.00)
- Software and computer - - -
- Accumulated deprecia (2,955.93) (2,955.93) -
- Kitchen utensils - - -
- Accumulated depreciat (1,321.74) (1,321.74) -
(0.01) Glasswares and silverwa - - -
(17,356.21) Accumulated deprecia (1,672.53) (1,672.53) -
- Linen and draperies 18,750.00 18,750.00 -
(0.00) Accumulated depreciat (6,825.13) (6,825.13) -
9,231.21 Motor vehicles - - -
8,125.00 Accumulated deprecia - - -
- Other fixed assets - - -
0.00 Accumulated depreciation - Other fixed assets (9,860.68) (9,860.68) 0.00
- TOTAL DEPRECIATION - - -
0.01 - - -
- Accounts payable - - -
10.71 Accounts payable - Trad 246,870.47 246,870.47 (0.00)
3,355.00 Accounts payable - Non-trade (39,791.27) (39,791.26) (0.01)
200.00 Accounts payable - Affila 395,806.86 395,806.86 (0.00)
480.00 Withholding tax payable - - -
- Withholding tax payable - 16 (1,833.20) (1,833.20) -
0.00 Withholding tax payable (22,779.95) (22,779.95) 0.00
- SSS, HDMF & PHIC prem - - -
- SSS premiums payable (11,495.00) (11,495.00) -
(10.71) HDMF premiums payabl (600.00) (600.00) -
- PHIC premiums payable (2,828.65) (2,828.65) -
- SSS, HDMF & PHIC loans - - -
275.00 SSS loans payable - - -
- HDMF loans payable (617.70) (617.70) -
8.50 PHIC loans payable - - -
(8.50) Advances from officers - - -
- Accrued expenses payable (24,031.51) (24,031.51) (0.00)
- Massage commissions payabl - - -
Output VAT (183,254.46) (183,254.46) (0.00)
Cash bond payable - - -
Customer's deposits 310,355.50 310,355.50 -
Service charge payable (43,433.14) (43,433.14) (0.00)
Unearned Income - - -
Advances Affiliates - - -
Provision for Income tax - - -
- - -
Paid-up Capital - - -
Prior year's adjustments - - -
Retained earnings - - -
- - -
Room sales (1,054,959.17) (1,054,959.16) (0.01)
Functions - Food - - -
Functions - Beverages - - -
Restaurant Sales - Food - - -
Restaurant Sales - Bever - - -
GnS Main - Food - - -
GnS Main - Beverages - - -
GnS Samba - Food - - -
GnS Samba - Beverages - - -
Sales Discount - - -
Others (472,161.35) (472,161.37) 0.02
- - -
Food - - -
Beverages - - -
- - -
Salaries and Wages - - -
Basic - OE 50,691.32 50,691.31 0.01
Overtime - OE 3,596.79 3,596.79 0.00
Manpower Services - OE 43,790.76 43,790.76 -
Service Fees - OE 8,190.00 8,190.00 -
Employee's Benefits - - -
SSS, HDMF, PHIC premiums 2,809.33 2,809.33 -
Employees meal - OE - - -
Incentives - EB 20,000.00 20,000.00 -
Insurance - EB 3,411.43 3,411.43 -
Allowances - OE 1,615.39 1,615.39 (0.00)
13th Month pay - OE 4,224.28 4,224.28 (0.00)
Separation and Retirement 78,000.00 78,000.00 -
Employee benefits - OE 6,230.00 6,230.00 -
Uniform - OE - - -
OTH - Employees - OE - - -
Rental 37,765.23 37,765.23 -
Light and power 122,300.38 122,300.38 -
Water bill 3,737.73 3,737.73 -
Kitchen fuel - - -
Cable subscription 3,457.50 3,457.50 -
Communications 14,694.17 14,694.17 0.00
Taxes and licenses 13,210.55 13,210.55 -
Security services 31,382.14 31,382.14 -
Laundry expenses 35,835.70 35,835.70 -
Donations and contribution - - -
Conference and meetings - - -
Trainings and seminars - - -
Representation - - -
Dues and subscription - - -
Party / catering expense - - -
Corporate affairs - - -
Management fee 45,886.00 45,886.00 -
Professional fee - - -
Research and development - - -
Commission - - -
Depreciation 156,552.35 156,552.34 0.01
Insurance - - -
Spoilage and breakages - - -
Supplies 39,818.72 39,818.72 -
Marketing communications - - -
Advertising and promotions 8,422.00 8,422.00 -
Ice expense - - -
Repairs and maintenance 6,632.43 6,632.43 0.00
Health and sanitation - - -
Transportation expense 200.00 200.00 -
Gasoline, oil and lubricants 5,892.86 5,892.86 (0.00)
Pre-Operating Expenses - - -
Miscellaneous expenses - - -
- - -
Basic - AE 32,139.94 32,139.94 (0.01)
Overtime - AE 1,913.82 1,913.82 -
SSS, HDMF, PHIC premiums c 4,035.00 4,035.00 -
Allowances - AE 5,500.00 5,500.00 -
13th Month pay - AE 2,678.33 2,678.33 (0.00)
Separation and Retirement - - -
Transportation - AE 1,012.00 1,012.00 -
Communication - AE 437.50 437.50 -
Supplies - AE 275.00 275.00 -
Employee benefits - AE - - -
Representation - AE - - -
Training & Seminar - AE - - -
Miscellaneous - AE 210.71 210.71 0.00
Admin share - AE 2,930.51 2,930.51 -
Head Office Allocation - AE 12,392.31 12,392.31 -
Conference and meetings - - - -
Professional fees - AE - - -
Insurance - AE 2,471.33 2,471.33 -
Repair and maintenance - - - -
Gasoline, oil and lubr - - -
- - -
Other Income: - - -
Interest income - - -
Miscellaneous incom (15.00) (15.00) -
Other Expenses: - - -
Bank charges 7147.57 7,147.57 -
Interest expense 0 - -
Income tax expense 0 - -
Acctno Account Title Total
0-0-102- Cash in bank - BDO1 (005-838002847) (407,995.62) (407,995.62)
0-0-102- Cash in Bank-PNB EFPS 98,998.59 98,998.59
0-0-102- Cash in Bank-PNB 205970002924 12,013.83 12,013.83
0-0-102- Cash in Bank-Security Bank Payroll Account (32,365.58) (32,365.56)
0-0-104- Accounts receivable - Guest Checkin 14,280.00 -
0-0-104- Accounts receivable - Credit cards (8,400.00) (8,400.00)
0-0-104- Accounts receivable - Employees (5,853.13) (5,853.13)
0-0-104- Accounts receivable - Affiliates 10,935.44 10,935.44
0-0-106- Advances to employees 26,776.20 26,776.20
0-0-107- Advances to suppliers 2,687.50 2,687.50
0-0-107- Advances to others 2,000.00 2,000.00
0-0-108- Accounts receivable - Others 558.92 558.92
0-0-109- Prepaid Others (2,083.33) (2,083.33)
0-0-110- Prepaid Taxes and licenses (12,260.37) (12,260.37)
0-0-110- Prepaid Insurance 17,713.64 17,713.64
0-0-108- Inventories - Supplies (7,986.21) (7,986.21)
0-0-113- Accumulated depreciation - Land improvements (29,020.33) (29,020.33)
0-0-114- Accumulated depreciation - Hotel building (14,911.50) (14,911.50)
0-0-114- Accumulated depreciation - Grand Pavillon (16,964.79) (16,964.79)
0-0-115- Accumulated depreciation - Leasehold improvem (17,118.37) (17,118.37)
0-0-116- Accumulated depreciation - Equipments (37,120.51) (37,120.51)
0-0-116- Accumulated depreciation - delivery equipments (1,366.49) (1,366.49)
0-0-116- Accumulated depreciation - kitchen and bar equi (4,868.07) (4,868.07)
0-0-116- Accumulated depreciation - sound system & band (3,467.08) (3,467.08)
0-0-118- Accumulated depreciation - Furnitures and fixture (10,309.26) (10,309.26)
0-0-119- Accumulated depreciation - Software and compu (2,955.93) (2,955.93)
0-0-120- Accumulated depreciation - Kitchen utensils (1,321.74) (1,321.74)
0-0-121- Accumulated depreciation - Glasswares and silve (1,672.59) (1,672.59)
0-0-122- Accumulated depreciation - Linen and draperies (7,405.42) (7,405.42)
0-0-123- Other fixed assets 7,020.00 7,020.00
0-0-123- Accumulated depreciation - Other fixed assets (8,694.47) (8,694.47)
0-0-111- Input Vat 31,305.92 31,305.92
0-0-201- Accounts payable - Trade 315,259.92 315,259.93
0-0-201- Accounts payable - Non-trade 203,514.29 203,514.30
0-0-202- Accrued expenses payable 89,165.75 89,165.76
0-0-202- Service Charge Payable (39,518.87) (39,518.87)
0-0-203- Withholding tax payable - 1601C (3,452.10) (3,452.10)
0-0-203- Withholding tax payable - 1601E (8,694.54) (8,694.55)
0-0-204- SSS premiums payable (13,212.50) (13,212.50)
0-0-204- HDMF premiums payable (1,100.00) (1,100.00)
0-0-204- PHIC premiums payable (2,653.65) (2,653.65)
0-0-205- HDMF loans payable 159.52 159.52
0-0-210- Output Vat (122,017.48) (122,017.49)
0-0-211- Customer's deposits 355,676.77 355,676.77
0-0-302- Retained earnings (54,366.58) (54,366.58)
0-0-402- Room sales (633,015.51) (633,015.51)
0-0-402- Extra Bed (72,678.56) -
0-0-404- Rental Income (305,000.00) -
0-0-402- Extra person (312.50) -
0-0-402- Massage fees (1,160.71) -
0-0-404- Other Income (4,645.11) -
0-0-501- Basic - OE 73,224.54 73,224.54
0-0-501- Overtime - OE 2,273.35 2,273.35
0-0-501- Manpower Services - OE 33,485.24 33,485.24
0-0-501- Service Fees - OE 5,460.00 5,460.00
0-0-502- SSS Premiums contribution 2,675.00 -
0-0-502- Insurance - EB 3,411.43 3,411.43
0-0-502- Employee benefits - OE 5,960.00 5,960.00
0-0-502- HDMF premiums contribution 200.00 -
0-0-502- PHIC premiums contribution 374.33 -
0-0-502- Allowances - OE 6,576.93 6,576.93
0-0-502- 13th Month pay - OE 6,102.05 6,102.05
0-0-503- Rental 37,969.78 37,969.77
0-0-503- Water bill 2,048.84 2,048.84
0-0-503- Cable subscription 3,457.50 3,457.50
0-0-503- Communications 13,696.93 13,696.94
0-0-503- Taxes and licenses 12,260.37 12,260.37
0-0-503- Security services 31,212.62 31,212.62
0-0-503- Laundry expenses 23,224.10 23,224.10
0-0-503- Management fee 30,504.37 30,504.37
0-0-503- Depreciation 157,196.55 157,196.54
0-0-503- Supplies 11,314.24 21,984.73
0-0-503- Miscellaneous expenses 100.00 100.00
0-0-503- Repairs and maintenance 5,037.03 5,037.03
0-0-503- Cleaning Supplies 6,161.56 -
0-0-503- Maintenance Supplies 4,508.93 -
0-0-503- Gasoline, oil and lubricants 1,092.51 1,092.50
0-0-503- Light and power 83,810.14 83,810.14
0-0-501- Basic - AE 31,911.18 31,911.18
0-0-501- Overtime - AE 6,532.19 6,532.19
0-0-501- Service fees - AE 10.71 -
0-0-502- SSS premiums contribution - Admin 3,460.00 -
0-0-502- HDMF premiums contribution - Admin 200.00 -
0-0-502- PHIC premiums contribution - Admin 480.00 -
0-0-502- Allowances - AE 2,500.00 2,500.00
0-0-502- 13th Month pay - AE 2,659.27 2,659.27
0-0-502- Separation and Retirement benefits - AE 67,500.00 67,500.00
0-0-503- Communication - AE 178.57 178.57
0-0-503- Miscellaneous - AE 408.71 419.42
0-0-503- Admin share - AE 6,637.24 6,637.24
0-0-503- Head Office Allocation - AE 17,787.35 17,787.35
0-0-503- Office Supplies - AE 405.36 -
0-0-503- Transportation - AE 827.00 827.00
0-0-404- Interest income (115.56) (115.56)
0-0-404- Miscellaneous income (25.00) (41.01)
0-0-404- Overages / shortages (16.01) -
0-0-503- Bank charges 3,223.24 3,223.24
Cash
- Cash in bank - BDO1 (0 (407,995.62) (407,995.62) -
- Cash in bank - BDO2 (0 - - -
0.00 Cash in Bank-PNB EFPS 98,998.59 98,998.59 -
(0.02) Cash in Bank-Security Ba (32,365.56) (32,365.58) 0.02
14,280.00 Cash in Bank-PNB 2059 12,013.83 12,013.83 (0.00)
- Petty cash fund - - -
- Change fund - - -
- Marketing Fund - - -
(0.00) Payroll Fund - - -
- Purchasing Fund - - -
- Emergency Fund - - -
- Accounts receivable - TRADE - - -
0.00 Accounts receivable - C 14,280.00 - 14,280.00
- Accounts receivable - Cr (8,400.00) (8,400.00) -
- Accounts receivable - Debit ca - - -
- Accounts receivable - - - -
(0.00) Accounts receivable - Off - - -
0.00 Accounts receivable - E (5,853.13) (5,853.13) -
0.00 Accounts receivable - Aff 10,935.44 10,935.44 -
(0.00) Accounts receivable - Others 558.92 558.92 -
(0.00) Advances - - -
- Advances to Officers - - -
0.00 Advances to Employees 26,776.20 26,776.20 0.00
- Advances to Suppliers 2,687.50 2,687.50 -
0.00 Advances to Others 2,000.00 2,000.00 -
- Inventories - - -
- Inventories - Merchandi - - -
- Inventories - Raw Materi - - -
- Inventories - RM Food - - -
- Inventories - RM Bevera - - -
(0.00) Inventories - Supplies (7,986.21) (7,986.21) -
0.01 Inventories - Unused sup - - -
(0.01) Inventories - Housekeepi - - -
(0.00) Inventories - Maintenanc - - -
(0.01) Inventories - Cleaning su - - -
(0.00) Inventories - Kitchen & D - - -
- Inventories - Office Supp - - -
0.01 Inventories - Promotional ite - - -
- Inventories - Uniform - - -
- Prepaid expenses - - -
- Prepaid Insurance 17,713.64 17,713.64 -
- Prepaid Taxes and licens (12,260.37) (12,260.37) -
0.00 Prepaid ads and promot - - -
- Prepaid Rent - - -
- Prepaid Others (2,083.33) (2,083.33) (0.00)
0.00 Input Vat 31,305.92 31,305.92 (0.01)
(72,678.56) Container deposits - - -
(305,000.00) Security deposit - - -
(312.50) Property Plant and - - -
(1,160.71) Land improvements - - -
(4,645.11) Accumulated deprecia (29,020.33) (29,020.33) 0.00
- Hotel building - - -
- Accumulated depreciat (14,911.50) (14,911.50) (0.00)
- Grand Pavillon building - - -
- Accumulated depreciat (16,964.79) (16,964.79) (0.00)
2,675.00 Leasehold improvement - - -
- Accumulated deprecia (17,118.37) (17,118.37) 0.00
- Equipment - - -
200.00 Accumulated deprecia (37,120.51) (37,120.51) 0.00
374.33 Delivery equipment - - -
- Accumulated deprecia (1,366.49) (1,366.49) -
0.01 Office Equipments - - -
0.01 Accumulated deprecia - - -
- Kitchen and bar equipm - - -
- Accumulated deprecia (4,868.07) (4,868.07) (0.00)
(0.01) Sound system & band in - - -
- Accumulated deprecia (3,467.08) (3,467.08) -
- Furnitures and fixtures - - -
- Accumulated depreciat (10,309.26) (10,309.26) (0.00)
- Software and computer - - -
0.01 Accumulated deprecia (2,955.93) (2,955.93) -
(10,670.49) Kitchen utensils - - -
- Accumulated depreciat (1,321.74) (1,321.74) -
(0.00) Glasswares and silverwa - - -
6,161.56 Accumulated deprecia (1,672.59) (1,672.59) -
4,508.93 Linen and draperies - - -
0.01 Accumulated depreciat (7,405.42) (7,405.42) -
- Motor vehicles - - -
- Accumulated deprecia - - -
- Other fixed assets 7,020.00 7,020.00 -
10.71 Accumulated depreciation - Other fixed assets (8,694.47) (8,694.47) 0.00
3,460.00 TOTAL DEPRECIATION - - -
200.00 - - -
480.00 Accounts payable - - -
- Accounts payable - Trad 315,259.93 315,259.92 0.01
0.01 Accounts payable - Non-trade 203,514.30 203,514.29 0.00
- Accounts payable - Affila - - -
(0.00) Withholding tax payable - - -
(10.71) Withholding tax payable - 16 (3,452.10) (3,452.10) -
- Withholding tax payable (8,694.55) (8,694.54) (0.01)
- SSS, HDMF & PHIC prem - - -
405.36 SSS premiums payable (13,212.50) (13,212.50) -
- HDMF premiums payabl (1,100.00) (1,100.00) -
- PHIC premiums payable (2,653.65) (2,653.65) -
16.01 SSS, HDMF & PHIC loans - - -
(16.01) SSS loans payable - - -
- HDMF loans payable 159.52 159.52 -
PHIC loans payable - - -
Advances from officers - - -
Accrued expenses payable 89,165.76 89,165.75 0.01
Massage commissions payabl - - -
Output VAT (122,017.49) (122,017.48) (0.00)
Cash bond payable - - -
Customer's deposits 355,676.77 355,676.77 -
Service charge payable (39,518.87) (39,518.87) 0.00
Unearned Income - - -
Advances Affiliates - - -
Provision for Income tax - - -
- - -
Paid-up Capital - - -
Prior year's adjustments - - -
Retained earnings (54,366.58) (54,366.58) -
- - -
Room sales (633,015.51) (633,015.51) (0.00)
Functions - Food - - -
Functions - Beverages - - -
Restaurant Sales - Food - - -
Restaurant Sales - Bever - - -
GnS Main - Food - - -
GnS Main - Beverages - - -
GnS Samba - Food - - -
GnS Samba - Beverages - - -
Sales Discount - - -
Others (383,796.87) (383,796.88) 0.01
- - -
Food - - -
Beverages - - -
- - -
Salaries and Wages - - -
Basic - OE 73,224.54 73,224.54 -
Overtime - OE 2,273.35 2,273.35 -
Manpower Services - OE 33,485.24 33,485.24 -
Service Fees - OE 5,460.00 5,460.00 -
Employee's Benefits - - -
SSS, HDMF, PHIC premiums 3,249.33 3,249.33 -
Employees meal - OE - - -
Incentives - EB - - -
Insurance - EB 3,411.43 3,411.43 -
Allowances - OE 6,576.93 6,576.93 -
13th Month pay - OE 6,102.05 6,102.05 (0.01)
Separation and Retirement - - -
Employee benefits - OE 5,960.00 5,960.00 -
Uniform - OE - - -
OTH - Employees - OE - - -
Rental 37,969.77 37,969.78 (0.01)
Light and power 83,810.14 83,810.14 -
Water bill 2,048.84 2,048.84 -
Kitchen fuel - - -
Cable subscription 3,457.50 3,457.50 -
Communications 13,696.94 13,696.93 0.01
Taxes and licenses 12,260.37 12,260.37 -
Security services 31,212.62 31,212.62 -
Laundry expenses 23,224.10 23,224.10 -
Donations and contribution - - -
Conference and meetings - - -
Trainings and seminars - - -
Representation - - -
Dues and subscription - - -
Party / catering expense - - -
Corporate affairs - - -
Management fee 30,504.37 30,504.37 -
Professional fee - - -
Research and development - - -
Commission - - -
Depreciation 157,196.54 157,196.55 (0.01)
Insurance - - -
Spoilage and breakages - - -
Supplies 21,984.73 21,984.73 0.00
Marketing communications - - -
Advertising and promotions - - -
Ice expense - - -
Repairs and maintenance 5,037.03 5,037.03 0.00
Health and sanitation - - -
Transportation expense - - -
Gasoline, oil and lubricants 1,092.50 1,092.51 (0.01)
Pre-Operating Expenses - - -
Miscellaneous expenses 100.00 100.00 -
- - -
Basic - AE 31,911.18 31,911.18 -
Overtime - AE 6,532.19 6,532.19 -
SSS, HDMF, PHIC premiums c 4,140.00 4,140.00 -
Allowances - AE 2,500.00 2,500.00 -
13th Month pay - AE 2,659.27 2,659.27 (0.01)
Separation and Retirement 67,500.00 67,500.00 -
Transportation - AE 827.00 827.00 -
Communication - AE 178.57 178.57 0.00
Supplies - AE 405.36 405.36 -
Employee benefits - AE - - -
Representation - AE - - -
Training & Seminar - AE - - -
Miscellaneous - AE 419.42 419.42 (0.00)
Admin share - AE 6,637.24 6,637.24 -
Head Office Allocation - AE 17,787.35 17,787.35 -
Conference and meetings - - - -
Professional fees - AE - - -
Insurance - AE - - -
Repair and maintenance - - - -
Gasoline, oil and lubr - - -
- - -
Other Income: - - -
Interest income (115.56) (115.56) -
Miscellaneous incom (41.01) (41.01) -
Other Expenses: - - -
Bank charges 3223.24 3,223.24 -
Interest expense 0 - -
Income tax expense 0 - -
Acctno Account Title Total
0-0-102- Cash in bank - BDO1 (005-838002847) (197,744.84) (197,744.85)
0-0-102- Cash in Bank-PNB EFPS 69,556.94 69,556.94
0-0-102- Cash in Bank-PNB 205970002924 (37,009.11) (37,009.10)
0-0-102- Cash in Bank-Security Bank Payroll Account (13,136.49) (13,136.49)
0-0-104- Accounts receivable - Guest Checkin - -
0-0-104- Accounts receivable - Credit cards (0.00) -
0-0-104- Accounts receivable - Employees (3,293.08) (3,293.08)
0-0-104- Accounts receivable - Affiliates 19,190.00 19,190.00
0-0-105- Advances to officers 50,000.00 50,000.00
0-0-106- Advances to employees 40,513.10 40,513.10
0-0-108- Accounts receivable - Others 391.76 391.75
0-0-109- Prepaid Others (2,083.33) (2,083.33)
0-0-110- Prepaid Taxes and licenses 48,001.12 48,001.12
0-0-110- Prepaid Insurance (1,064.20) (1,064.20)
0-0-110- Prepaid ads and promotions 4,000.00 4,000.00
0-0-108- Inventories - Supplies (9,230.45) (9,230.45)
0-0-113- Accumulated depreciation - Land improvements (29,020.33) (29,020.33)
0-0-114- Accumulated depreciation - Hotel building (14,911.50) (14,911.50)
0-0-114- Accumulated depreciation - Grand Pavillon (16,964.79) (16,964.79)
0-0-115- Accumulated depreciation - Leasehold improvem (17,118.37) (17,118.37)
0-0-116- Equipment 120,607.14 120,607.14
0-0-116- Accumulated depreciation - Equipments (31,925.86) (31,925.86)
0-0-116- Accumulated depreciation - delivery equipments (1,366.49) (1,366.49)
0-0-116- Accumulated depreciation - kitchen and bar equi (4,868.07) (4,868.07)
0-0-116- Accumulated depreciation - sound system & band (3,467.08) (3,467.08)
0-0-118- Accumulated depreciation - Furnitures and fixture (10,608.66) (10,608.66)
0-0-119- Accumulated depreciation - Software and compu (2,956.01) (2,956.01)
0-0-120- Accumulated depreciation - Kitchen utensils (1,321.74) (1,321.74)
0-0-121- Accumulated depreciation - Glasswares and silve (1,672.59) (1,672.59)
0-0-122- Accumulated depreciation - Linen and draperies (7,405.49) (7,405.49)
0-0-123- Accumulated depreciation - Other fixed assets (9,063.61) (9,063.61)
0-0-111- Input Vat 19,318.61 19,318.62
0-0-201- Accounts payable - Trade (13,023.98) (13,023.99)
0-0-201- Accounts payable - Non-trade (61,535.47) (61,535.47)
0-0-201- Accounts payable - Affilates (16,178.59) (16,178.59)
0-0-202- Accrued expenses payable 86,319.67 86,319.66
0-0-202- Service Charge Payable (30,710.72) (30,710.72)
0-0-203- Withholding tax payable - 1601C (513.20) (513.20)
0-0-203- Withholding tax payable - 1601E 844.93 844.94
0-0-204- SSS premiums payable (1,320.00) (1,320.00)
0-0-204- HDMF premiums payable - -
0-0-204- PHIC premiums payable (390.00) (390.00)
0-0-205- HDMF loans payable 1,308.34 1,308.34
0-0-210- Output Vat (10,039.91) (10,039.91)
0-0-211- Customer's deposits 335,430.00 335,430.00
0-0-402- Room sales (504,288.11) (504,288.14)
0-0-402- Extra Bed (43,522.31) -
0-0-404- Rental Income (305,000.00) -
0-0-404- Other Income (5,059.52) -
0-0-501- Basic - OE 39,920.00 39,920.00
0-0-501- Overtime - OE 287.54 287.54
0-0-501- Manpower Services - OE 38,979.34 38,979.36
0-0-501- Service Fees - OE 3,360.00 3,360.00
0-0-502- SSS Premiums contribution 5,000.00 -
0-0-502- Insurance - EB 1,064.20 1,064.20
0-0-502- Employee benefits - OE 6,230.00 6,230.00
0-0-502- HDMF premiums contribution 300.00 -
0-0-502- PHIC premiums contribution 749.33 -
0-0-502- Allowances - OE 15,300.00 15,300.00
0-0-502- 13th Month pay - OE 3,326.67 3,326.67
0-0-502- Uniform - OE 2,410.00 2,410.00
0-0-503- Rental 38,014.78 38,014.77
0-0-503- Water bill 375.64 375.64
0-0-503- Cable subscription 3,457.50 3,457.50
0-0-503- Communications 14,190.62 14,190.61
0-0-503- Taxes and licenses 12,260.37 12,260.37
0-0-503- Security services 32,597.74 32,597.74
0-0-503- Laundry expenses 34,876.25 34,876.25
0-0-503- Representation 2,000.00 2,000.00
0-0-503- Management fee 25,749.49 25,749.49
0-0-503- Depreciation 152,670.59 152,670.59
0-0-503- Supplies 15,866.92 26,197.32
0-0-503- Repairs and maintenance 7,484.04 7,484.04
0-0-503- Cleaning Supplies 1,049.15 -
0-0-503- Maintenance Supplies 9,281.24 -
0-0-503- Gasoline, oil and lubricants 1,587.59 1,587.58
0-0-503- Light and power 82,012.98 82,012.98
0-0-501- Basic - AE 30,122.16 30,122.16
0-0-501- Overtime - AE 3,508.17 3,508.17
0-0-502- SSS premiums contribution - Admin 2,802.50 -
0-0-502- HDMF premiums contribution - Admin 200.00 -
0-0-502- PHIC premiums contribution - Admin 465.00 -
0-0-502- 13th Month pay - AE 2,510.18 2,510.18
0-0-503- Communication - AE 437.50 437.50
0-0-503- Miscellaneous - AE 169.64 169.64
0-0-503- Admin share - AE 9,817.59 9,817.59
0-0-503- Head Office Allocation - AE 8,358.12 8,358.12
0-0-503- Transportation - AE 1,444.00 1,444.00
0-0-404- Interest income (197.43) (197.43)
0-0-503- Provision For Income Tax (49,107.53) (49,107.53)
0-0-503- Bank charges 2,292.89 2,292.91
0-0-503- Income tax expense 49,107.53 49,107.53
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
Cash
0.01 Cash in bank - BDO1 (0 (197,744.85) (197,744.84) (0.01)
- Cash in bank - BDO2 (0 - - -
(0.01) Cash in Bank-PNB EFPS 69,556.94 69,556.94 -
- Cash in Bank-Security Ba (13,136.49) (13,136.49) -
- Cash in Bank-PNB 2059 (37,009.10) (37,009.11) 0.01
(0.00) Petty cash fund - - -
- Change fund - - -
- Marketing Fund - - -
- Payroll Fund - - -
0.00 Purchasing Fund - - -
0.01 Emergency Fund - - -
0.00 Accounts receivable - TRADE - - -
- Accounts receivable - C - - -
- Accounts receivable - Cr - (0.00) 0.00
- Accounts receivable - Debit cards - -
- Accounts receivable - - - -
(0.00) Accounts receivable - Off - - -
0.00 Accounts receivable - E (3,293.08) (3,293.08) -
0.00 Accounts receivable - Aff 19,190.00 19,190.00 -
(0.00) Accounts receivable - Others 391.75 391.76 (0.01)
- Advances - - -
0.00 Advances to Officers 50,000.00 50,000.00 -
- Advances to Employees 40,513.10 40,513.10 (0.00)
0.00 Advances to Suppliers - - -
- Advances to Others - -
0.00 Inventories - - -
- Inventories - Merchandi - - -
- Inventories - Raw Materi - - -
- Inventories - RM Food - - -
- Inventories - RM Bevera - - -
(0.00) Inventories - Supplies (9,230.45) (9,230.45) -
(0.01) Inventories - Unused sup - - -
0.01 Inventories - Housekeepi - - -
0.00 Inventories - Maintenanc - - -
- Inventories - Cleaning su - - -
0.01 Inventories - Kitchen & D - - -
(0.01) Inventories - Office Supp - - -
- Inventories - Promotiona - - -
(0.01) Inventories - Uniform - - -
- Prepaid expenses - - -
- Prepaid Insurance (1,064.20) (1,064.20) -
- Prepaid Taxes and licens 48,001.12 48,001.12 -
- Prepaid ads and promot 4,000.00 4,000.00 -
(0.00) Prepaid Rent - - -
- Prepaid Others (2,083.33) (2,083.33) (0.00)
0.03 Input Vat 19,318.62 19,318.61 0.01
(43,522.31) Container deposits - - -
(305,000.00) Security deposit - - -
(5,059.52) Property Plant and Eq - - -
- Land improvements - - -
- Accumulated depreciati (29,020.33) (29,020.33) 0.00
(0.02) Hotel building - - -
- Accumulated depreciation (14,911.50) (14,911.50) (0.00)
5,000.00 Grand Pavillon buildi - - -
- Accumulated depreciatio (16,964.79) (16,964.79) (0.00)
- Leasehold improveme - - -
300.00 Accumulated depreciati (17,118.37) (17,118.37) 0.00
749.33 Equipment 120,607.14 120,607.14 -
- Accumulated depreciati (31,925.86) (31,925.86) (0.00)
0.00 Delivery equipment - - -
- Accumulated depreciatio (1,366.49) (1,366.49) -
0.01 Office Equipments - - -
- Accumulated depreciatio - - -
- Kitchen and bar equi - - -
0.01 Accumulated depreciatio (4,868.07) (4,868.07) (0.00)
- Sound system & band - - -
- Accumulated depreciatio (3,467.08) (3,467.08) -
- Furnitures and fixture - - -
- Accumulated depreciation (10,608.66) (10,608.66) (0.00)
- Software and comput - - -
(0.00) Accumulated depreciati (2,956.01) (2,956.01) -
(10,330.40) Kitchen utensils - - -
(0.00) Accumulated depreciation (1,321.74) (1,321.74) -
1,049.15 Glasswares and silve - - -
9,281.24 Accumulated depreciatio (1,672.59) (1,672.59) -
0.01 Linen and draperies - - -
- Accumulated depreciatio (7,405.49) (7,405.49) -
- Motor vehicles - - -
- Accumulated depreciatio - - -
2,802.50 Other fixed assets - - -
200.00 Accumulated depreciation - Ot (9,063.61) (9,063.61) 0.00
465.00 TOTAL DEPRECIATION - - -
- - - -
- Accounts payable - - -
- Accounts payable - Trad (13,023.99) (13,023.98) (0.01)
- Accounts payable - Non- (61,535.47) (61,535.47) (0.00)
- Accounts payable - Affilates (16,178.59) (16,178.59) -
- Withholding tax payable - - -
- Withholding tax payable (513.20) (513.20) -
(0.00) Withholding tax payable - 16 844.94 844.93 0.01
(0.02) SSS, HDMF & PHIC prem - - -
0.00 SSS premiums payable (1,320.00) (1,320.00) -
- HDMF premiums payabl - - -
- PHIC premiums payable (390.00) (390.00) -
- SSS, HDMF & PHIC loans - - -
- SSS loans payable - - -
- HDMF loans payable 1,308.34 1,308.34 -
- PHIC loans payable - - -
- Advances from officers - - -
- Accrued expenses payable 86,319.66 86,319.67 (0.01)
- Massage commissions payabl - - -
- Output VAT (10,039.91) (10,039.91) 0.00
- Cash bond payable - - -
- Customer's deposits 335,430.00 335,430.00 -
- Service charge payable (30,710.72) (30,710.72) 0.01
- Unearned Income - - -
- Advances Affiliates - - -
- Provision for Income tax (49,107.53) (49,107.53) 0.00
- - - -
- Paid-up Capital - - -
- Prior year's adjustments - - -
- Retained earnings - - -
- - - -
- Room sales (504,288.14) (504,288.11) (0.03)
- Functions - Food - - -
- Functions - Beverages - - -
- Restaurant Sales - Food - - -
Restaurant Sales - Bever - - -
GnS Main - Food - - -
GnS Main - Beverages - - -
GnS Samba - Food - - -
GnS Samba - Beverages - - -
Sales Discount - -
Others (353,581.84) (353,581.83) (0.00)
- - -
Food - - -
Beverages - - -
- - -
Salaries and Wages - - -
Basic - OE 39,920.00 39,920.00 -
Overtime - OE 287.54 287.54 -
Manpower Services - OE 38,979.36 38,979.34 0.02
Service Fees - OE 3,360.00 3,360.00 -
Employee's Benefits - -
SSS, HDMF, PHIC premiums 6,049.33 6,049.33 -
Employees meal - OE - - -
Incentives - EB - - -
Insurance - EB 1,064.20 1,064.20 -
Allowances - OE 15,300.00 15,300.00 -
13th Month pay - OE 3,326.67 3,326.67 (0.00)
Separation and Retirement - - -
Employee benefits - OE 6,230.00 6,230.00 -
Uniform - OE 2,410.00 2,410.00 -
OTH - Employees - OE - - -
Rental 38,014.77 38,014.78 (0.01)
Light and power 82,012.98 82,012.98 -
Water bill 375.64 375.64 -
Kitchen fuel - - -
Cable subscription 3,457.50 3,457.50 -
Communications 14,190.61 14,190.62 (0.01)
Taxes and licenses 12,260.37 12,260.37 -
Security services 32,597.74 32,597.74 -
Laundry expenses 34,876.25 34,876.25 -
Donations and contribution - - -
Conference and meetings - - -
Trainings and seminars - - -
Representation 2,000.00 2,000.00 -
Dues and subscription - - -
Party / catering expense - - -
Corporate affairs - - -
Management fee 25,749.49 25,749.49 -
Professional fee - - -
Research and development - - -
Commission - - -
Depreciation 152,670.59 152,670.59 0.00
Insurance - - -
Spoilage and breakages - -
Supplies 26,197.32 26,197.31 0.01
Marketing communications - - -
Advertising and promotions - - -
Ice expense - - -
Repairs and maintenance 7,484.04 7,484.04 0.00
Health and sanitation - - -
Transportation expense - - -
Gasoline, oil and lubricants 1,587.58 1,587.59 (0.01)
Pre-Operating Expenses - - -
Miscellaneous expenses - - -
- - -
Basic - AE 30,122.16 30,122.16 -
Overtime - AE 3,508.17 3,508.17 -
SSS, HDMF, PHIC premiums c 3,467.50 3,467.50 -
Allowances - AE - - -
13th Month pay - AE 2,510.18 2,510.18 -
Separation and Retirement - - -
Transportation - AE 1,444.00 1,444.00 -
Communication - AE 437.50 437.50 -
Supplies - AE - -
Employee benefits - AE - - -
Representation - AE - - -
Training & Seminar - AE - -
Miscellaneous - AE 169.64 169.64 -
Admin share - AE 9,817.59 9,817.59 -
Head Office Allocation - AE 8,358.12 8,358.12 -
Conference and meetings - - - -
Professional fees - AE - - -
Insurance - AE - - -
Repair and maintenance - - - -
Gasoline, oil and lubricant - AE - - -
- - -
Other Income: - - -
Interest income (197.43) (197.43) -
Miscellaneous income - - -
Other Expenses: - - -
Bank charges 2,292.91 2,292.89 0.02
Interest expense - - -
Income tax expense 49,107.53 49,107.53 (0.00)
Acctno Account Title Total
0-0-102- Cash in bank - BDO1 (005-838002847) (239,399.03) (239,399.03)
0-0-102- Cash in Bank-PNB 205970002924 87,902.34 87,902.34
0-0-102- Cash in Bank-Security Bank Payroll Account 6,114.80 6,114.80
0-0-103- Payroll fund (6,500.00) (6,500.00)
0-0-104- Accounts receivable - Credit cards (0.00) -
0-0-104- Accounts receivable - Employees 11,888.53 11,888.52
0-0-104- Accounts receivable - Affiliates 17,195.00 17,195.00
0-0-106- Advances to employees 10,476.86 10,476.86
0-0-107- Advances to suppliers - -
0-0-108- Accounts receivable - Others 165.28 165.27
0-0-109- Prepaid Others (2,083.33) (2,083.33)
0-0-110- Prepaid Insurance 10,642.04 10,642.05
0-0-108- Inventories - Supplies 24,305.81 24,305.81
0-0-113- Accumulated depreciation - Land improvements (29,057.83) (29,057.83)
0-0-114- Accumulated depreciation - Hotel building (14,911.50) (14,911.50)
0-0-114- Accumulated depreciation - Grand Pavillon (18,464.79) (18,464.79)
0-0-115- Accumulated depreciation - Leasehold improvem (17,118.37) (17,118.37)
0-0-116- Accumulated depreciation - Equipments (34,389.20) (34,389.20)
0-0-116- Accumulated depreciation - delivery equipments (1,366.49) (1,366.49)
0-0-116- Accumulated depreciation - kitchen and bar equi (5,150.76) (5,150.76)
0-0-116- Accumulated depreciation - sound system & band (3,467.08) (3,467.08)
0-0-118- Accumulated depreciation - Furnitures and fixture (11,620.97) (11,620.97)
0-0-119- Accumulated depreciation - Software and compu (4,101.80) (4,101.80)
0-0-120- Accumulated depreciation - Kitchen utensils (1,321.74) (1,321.74)
0-0-121- Accumulated depreciation - Glasswares and silve (1,672.66) (1,672.66)
0-0-122- Accumulated depreciation - Linen and draperies (7,405.49) (7,405.49)
0-0-123- Accumulated depreciation - Other fixed assets (9,499.85) (9,499.85)
0-0-111- Input Vat (629.82) (629.81)
0-0-201- Accounts payable - Trade (67,461.61) (67,461.62)
0-0-201- Accounts payable - Non-trade 122,773.41 122,773.41
0-0-201- Accounts payable - Affilates (6,780.00) (6,780.00)
0-0-202- Accrued expenses payable (48,159.01) (48,159.00)
0-0-202- Service Charge Payable (12,878.40) (12,878.39)
0-0-203- Withholding tax payable - 1601C (513.20) (513.20)
0-0-203- Withholding tax payable - 1601E 4,460.63 4,460.63
0-0-204- SSS premiums payable (335.00) (335.00)
0-0-204- HDMF premiums payable (200.00) (200.00)
0-0-204- PHIC premiums payable - -
0-0-205- HDMF loans payable 2,354.40 2,354.40
0-0-210- Output Vat 16,632.91 16,632.90
0-0-211- Customer's deposits 421,600.00 421,600.00
0-0-402- Room sales (410,949.66) (410,949.66)
0-0-402- Extra Bed (52,004.46) -
0-0-404- Rental Income (305,000.00) -
0-0-501- Basic - OE 39,920.00 39,920.00
0-0-501- Overtime - OE 287.54 287.54
0-0-501- Manpower Services - OE 37,851.27 37,851.27
0-0-501- Service Fees - OE 1,680.00 1,680.00
0-0-502- SSS Premiums contribution 5,000.00 -
0-0-502- Insurance - EB 1,064.20 1,064.20
0-0-502- Employee benefits - OE 6,370.00 6,370.00
0-0-502- HDMF premiums contribution 300.00 -
0-0-502- PHIC premiums contribution 749.33 -
0-0-502- Allowances - OE 15,300.00 15,300.00
0-0-502- 13th Month pay - OE 3,326.67 3,326.67
0-0-503- Rental 37,777.50 37,777.50
0-0-503- Water bill 3,522.72 3,522.72
0-0-503- Cable subscription 3,457.50 3,457.50
0-0-503- Communications 13,792.74 13,792.75
0-0-503- Taxes and licenses 12,260.37 12,260.37
0-0-503- Security services 29,443.12 29,443.12
0-0-503- Laundry expenses 20,185.10 20,185.10
0-0-503- Management fee 23,038.62 23,038.62
0-0-503- Depreciation 159,548.53 159,548.52
0-0-503- Supplies 15,745.25 17,452.62
0-0-503- Repairs and maintenance 2,083.33 2,083.33
0-0-503- Cleaning Supplies 1,546.65 -
0-0-503- Maintenance Supplies 160.71 -
0-0-503- Gasoline, oil and lubricants 1,741.08 1,741.08
0-0-503- Light and power 71,339.92 71,339.92
0-0-501- Basic - AE 28,508.00 28,508.00
0-0-502- SSS premiums contribution - Admin 1,910.00 -
0-0-502- HDMF premiums contribution - Admin 200.00 -
0-0-502- PHIC premiums contribution - Admin 270.00 -
0-0-502- 13th Month pay - AE 2,375.67 2,375.67
0-0-503- Communication - AE 437.50 437.50
0-0-503- Miscellaneous - AE 500.71 500.71
0-0-503- Admin share - AE 14,099.09 14,099.09
0-0-503- Head Office Allocation - AE 25,065.12 25,065.12
0-0-503- Transportation - AE 684.00 684.00
0-0-404- Interest income (91.08) (91.08)
0-0-404- Miscellaneous income (6,250.00) (6,250.00)
0-0-503- Provision For Income Tax (38,404.81) (38,404.81)
0-0-503- Bank charges 728.87 728.88
0-0-503- Income tax expense 38,404.81 38,404.81
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
Cash
0.00 Cash in bank - BDO1 (0 (239,399.03) (239,399.03) (0.00)
- Cash in bank - BDO2 (0 - - -
- Cash in Bank-PNB EFPS - - -
- Cash in Bank-Security Ba 6,114.80 6,114.80 -
(0.00) Cash in Bank-PNB 2059 87,902.34 87,902.34 -
0.01 Petty cash fund - - -
- Change fund - - -
- Marketing Fund - - -
- Payroll Fund (6,500.00) (6,500.00) -
0.01 Purchasing Fund - - -
0.00 Emergency Fund - - -
(0.01) Accounts receivable - TRADE - - -
- Accounts receivable - C - - -
(0.00) Accounts receivable - Cr - (0.00) 0.00
0.00 Accounts receivable - Debit cards - -
0.00 Accounts receivable - - - -
(0.00) Accounts receivable - Off - - -
(0.00) Accounts receivable - E 11,888.52 11,888.53 (0.01)
- Accounts receivable - Aff 17,195.00 17,195.00 -
0.00 Accounts receivable - Others 165.27 165.28 (0.01)
- Advances - - -
(0.00) Advances to Officers - - -
- Advances to Employees 10,476.86 10,476.86 -
- Advances to Suppliers - - -
- Advances to Others - -
- Inventories - - -
(0.00) Inventories - Merchandi - - -
(0.00) Inventories - Raw Materi - - -
0.00 Inventories - RM Food - - -
0.01 Inventories - RM Bevera - - -
- Inventories - Supplies 24,305.81 24,305.81 -
(0.01) Inventories - Unused sup - - -
(0.01) Inventories - Housekeepi - - -
- Inventories - Maintenanc - - -
0.01 Inventories - Cleaning su - - -
- Inventories - Kitchen & D - - -
- Inventories - Office Supp - - -
- Inventories - Promotiona - - -
- Inventories - Uniform - - -
0.01 Prepaid expenses - - -
- Prepaid Insurance 10,642.05 10,642.04 0.01
(0.00) Prepaid Taxes and licens - - -
(52,004.46) Prepaid ads and promotions - -
(305,000.00) Prepaid Rent - - -
- Prepaid Others (2,083.33) (2,083.33) (0.00)
- Input Vat (629.81) (629.82) 0.00
- Container deposits - - -
- Security deposit - - -
5,000.00 Property Plant and Eq - - -
- Land improvements - - -
- Accumulated depreciati (29,057.83) (29,057.83) 0.00
300.00 Hotel building - - -
749.33 Accumulated depreciation (14,911.50) (14,911.50) (0.00)
- Grand Pavillon buildi - - -
0.00 Accumulated depreciatio (18,464.79) (18,464.79) (0.00)
- Leasehold improveme - - -
- Accumulated depreciati (17,118.37) (17,118.37) 0.00
- Equipment - - -
(0.01) Accumulated depreciati (34,389.20) (34,389.20) 0.00
- Delivery equipment - - -
- Accumulated depreciatio (1,366.49) (1,366.49) -
- Office Equipments - - -
- Accumulated depreciatio - - -
0.01 Kitchen and bar equi - - -
(1,707.37) Accumulated depreciatio (5,150.76) (5,150.76) (0.00)
(0.00) Sound system & band - - -
1,546.65 Accumulated depreciatio (3,467.08) (3,467.08) -
160.71 Furnitures and fixture - - -
- Accumulated depreciation (11,620.97) (11,620.97) 0.00
- Software and comput - - -
- Accumulated depreciati (4,101.80) (4,101.80) -
1,910.00 Kitchen utensils - - -
200.00 Accumulated depreciation (1,321.74) (1,321.74) -
270.00 Glasswares and silve - - -
0.00 Accumulated depreciatio (1,672.66) (1,672.66) -
- Linen and draperies - - -
(0.00) Accumulated depreciatio (7,405.49) (7,405.49) -
- Motor vehicles - - -
- Accumulated depreciatio - - -
- Other fixed assets - - -
- Accumulated depreciation - Ot (9,499.85) (9,499.85) 0.00
- TOTAL DEPRECIATION - - -
0.00 - - -
(0.01) Accounts payable - - -
(0.00) Accounts payable - Trad (67,461.62) (67,461.61) (0.00)
- Accounts payable - Non- 122,773.41 122,773.41 (0.01)
- Accounts payable - Affilates (6,780.00) (6,780.00) -
- Withholding tax payable - - -
- Withholding tax payable (513.20) (513.20) -
- Withholding tax payable - 16 4,460.63 4,460.63 (0.01)
- SSS, HDMF & PHIC prem - - -
- SSS premiums payable (335.00) (335.00) -
- HDMF premiums payabl (200.00) (200.00) -
- PHIC premiums payable - - -
- SSS, HDMF & PHIC loans - - -
- SSS loans payable - - -
- HDMF loans payable 2,354.40 2,354.40 -
- PHIC loans payable - - -
- Advances from officers - - -
- Accrued expenses payable (48,159.00) (48,159.01) 0.01
- Massage commissions payabl - - -
- Output VAT 16,632.90 16,632.91 (0.01)
- Cash bond payable - - -
- Customer's deposits 421,600.00 421,600.00 -
- Service charge payable (12,878.39) (12,878.40) 0.01
- Unearned Income - - -
- Advances Affiliates - - -
- Provision for Income tax (38,404.81) (38,404.81) (0.00)
- - - -
- Paid-up Capital - - -
- Prior year's adjustments - - -
- Retained earnings - - -
- - - -
- Room sales (410,949.66) (410,949.66) 0.00
- Functions - Food - - -
- Functions - Beverages - - -
- Restaurant Sales - Food - - -
Restaurant Sales - Bever - - -
GnS Main - Food - - -
GnS Main - Beverages - - -
GnS Samba - Food - - -
GnS Samba - Beverages - - -
Sales Discount - -
Others (357,004.46) (357,004.46) -
- - -
Food - - -
Beverages - - -
- - -
Salaries and Wages - - -
Basic - OE 39,920.00 39,920.00 -
Overtime - OE 287.54 287.54 -
Manpower Services - OE 37,851.27 37,851.27 -
Service Fees - OE 1,680.00 1,680.00 -
Employee's Benefits - -
SSS, HDMF, PHIC premiums 6,049.33 6,049.33 -
Employees meal - OE - - -
Incentives - EB - - -
Insurance - EB 1,064.20 1,064.20 -
Allowances - OE 15,300.00 15,300.00 -
13th Month pay - OE 3,326.67 3,326.67 (0.00)
Separation and Retirement - - -
Employee benefits - OE 6,370.00 6,370.00 -
Uniform - OE - - -
OTH - Employees - OE - - -
Rental 37,777.50 37,777.50 -
Light and power 71,339.92 71,339.92 -
Water bill 3,522.72 3,522.72 -
Kitchen fuel - - -
Cable subscription 3,457.50 3,457.50 -
Communications 13,792.75 13,792.74 0.01
Taxes and licenses 12,260.37 12,260.37 -
Security services 29,443.12 29,443.12 -
Laundry expenses 20,185.10 20,185.10 -
Donations and contribution - - -
Conference and meetings - - -
Trainings and seminars - - -
Representation - - -
Dues and subscription - - -
Party / catering expense - - -
Corporate affairs - - -
Management fee 23,038.62 23,038.62 -
Professional fee - - -
Research and development - - -
Commission - - -
Depreciation 159,548.52 159,548.53 (0.01)
Insurance - - -
Spoilage and breakages - -
Supplies 17,452.62 17,452.61 0.01
Marketing communications - - -
Advertising and promotions - - -
Ice expense - - -
Repairs and maintenance 2,083.33 2,083.33 0.00
Health and sanitation - - -
Transportation expense - - -
Gasoline, oil and lubricants 1,741.08 1,741.08 -
Pre-Operating Expenses - - -
Miscellaneous expenses - - -
- - -
Basic - AE 28,508.00 28,508.00 -
Overtime - AE - - -
SSS, HDMF, PHIC premiums c 2,380.00 2,380.00 -
Allowances - AE - - -
13th Month pay - AE 2,375.67 2,375.67 (0.00)
Separation and Retirement - - -
Transportation - AE 684.00 684.00 -
Communication - AE 437.50 437.50 -
Supplies - AE - -
Employee benefits - AE - - -
Representation - AE - - -
Training & Seminar - AE - -
Miscellaneous - AE 500.71 500.71 0.00
Admin share - AE 14,099.09 14,099.09 -
Head Office Allocation - AE 25,065.12 25,065.12 -
Conference and meetings - - - -
Professional fees - AE - - -
Insurance - AE - - -
Repair and maintenance - - - -
Gasoline, oil and lubricant - AE - - -
- - -
Other Income: - - -
Interest income (91.08) (91.08) -
Miscellaneous income (6,250.00) (6,250.00) -
Other Expenses: - - -
Bank charges 728.88 728.87 0.01
Interest expense - - -
Income tax expense 38,404.81 38,404.81 0.00
Acctno Account Title Total
0-0-102- Cash in bank - BDO1 (005-838002847) 717,405.81 717,405.83
0-0-102- Cash in Bank-PNB 205970002924 (23,010.49) (23,010.49)
0-0-102- Cash in Bank-Security Bank Payroll Account 22,823.45 22,823.45
0-0-104- Accounts receivable - Customers (68,906.25) (68,906.25)
0-0-104- Accounts receivable - Credit cards (0.00) -
0-0-104- Accounts receivable - Affiliates (231,389.33) (231,389.33)
0-0-106- Advances to employees (30,032.00) (30,032.00)
0-0-107- Advances to suppliers (66,400.00) (66,400.00)
0-0-108- Accounts receivable - Others 175.40 175.39
0-0-109- Prepaid Others 22,916.67 22,916.67
0-0-110- Prepaid Taxes and licenses (32,119.44) (32,119.44)
0-0-108- Inventories - Supplies (4,927.68) (4,927.68)
0-0-113- Accumulated depreciation - Land improvements (29,058.13) (29,058.13)
0-0-114- Accumulated depreciation - Hotel building (14,911.50) (14,911.50)
0-0-114- Accumulated depreciation - Grand Pavillon (18,464.79) (18,464.79)
0-0-115- Accumulated depreciation - Leasehold improvem (17,118.37) (17,118.37)
0-0-116- Equipment 66,400.00 66,400.00
0-0-116- Accumulated depreciation - Equipments (37,074.03) (37,074.04)
0-0-116- Accumulated depreciation - delivery equipments (1,366.49) (1,366.49)
0-0-116- Accumulated depreciation - kitchen and bar equi (5,150.81) (5,150.81)
0-0-116- Accumulated depreciation - sound system & band (3,467.08) (3,467.08)
0-0-118- Accumulated depreciation - Furnitures and fixture (11,620.97) (11,620.97)
0-0-119- Accumulated depreciation - Software and compu (4,439.05) (4,439.05)
0-0-120- Accumulated depreciation - Kitchen utensils (1,321.74) (1,321.74)
0-0-121- Accumulated depreciation - Glasswares and silve (2,498.48) (2,498.48)
0-0-122- Accumulated depreciation - Linen and draperies (8,090.71) (8,090.71)
0-0-123- Accumulated depreciation - Other fixed assets (9,500.10) (9,500.10)
0-0-111- Input Vat 11,841.78 11,841.78
0-0-201- Accounts payable - Trade 234,158.11 234,158.11
0-0-201- Accounts payable - Non-trade (155,364.88) (155,364.88)
0-0-201- Accounts payable - Affilates (26,500.00) (26,500.00)
0-0-202- Accrued expenses payable 233,613.59 233,613.59
0-0-202- Service Charge Payable 2,743.46 2,743.45
0-0-203- Withholding tax payable - 1601C (513.20) (513.20)
0-0-203- Withholding tax payable - 1601E (10,095.86) (10,095.86)
0-0-204- SSS premiums payable (13,455.00) (13,455.00)
0-0-204- HDMF premiums payable (1,000.00) (1,000.00)
0-0-204- PHIC premiums payable (2,788.65) (2,788.65)
0-0-205- HDMF loans payable (0.00) -
0-0-210- Output Vat (20,535.83) (20,535.83)
0-0-211- Customer's deposits (341,600.00) (341,600.00)
0-0-402- Room sales (445,306.85) (445,306.85)
0-0-402- Extra Bed (42,512.43) -
0-0-404- Rental Income (305,000.00) -
0-0-404- Other Income (4,240.08) -
0-0-501- Basic - OE 40,760.00 40,760.00
0-0-501- Overtime - OE 2,122.62 2,122.62
0-0-501- Manpower Services - OE 10,169.71 10,169.71
0-0-501- Service Fees - OE 37,956.00 37,956.00
0-0-502- SSS Premiums contribution 5,127.50 -
0-0-502- Employee benefits - OE 6,230.00 6,230.00
0-0-502- HDMF premiums contribution 300.00 -
0-0-502- PHIC premiums contribution 749.33 -
0-0-502- Allowances - OE 15,300.00 15,300.00
0-0-502- 13th Month pay - OE 3,396.67 3,396.67
0-0-503- Rental 59,520.21 59,520.21
0-0-503- Water bill 3,881.25 3,881.25
0-0-503- Cable subscription 3,457.50 3,457.50
0-0-503- Communications 14,330.34 14,330.34
0-0-503- Taxes and licenses 48,357.81 48,357.81
0-0-503- Security services 32,597.74 32,597.74
0-0-503- Laundry expenses 14,261.06 14,261.06
0-0-503- Management fee 23,912.48 23,912.48
0-0-503- Depreciation 164,082.25 164,082.25
0-0-503- Supplies 18,950.59 22,646.06
0-0-503- Repairs and maintenance 2,083.33 2,083.33
0-0-503- Cleaning Supplies 2,967.90 -
0-0-503- Maintenance Supplies 438.57 -
0-0-503- Gasoline, oil and lubricants 2,901.79 2,901.79
0-0-503- Light and power 76,695.84 76,695.84
0-5-503- Office Supplies 289.00 -
0-0-501- Basic - AE 30,495.00 30,495.00
0-0-502- SSS premiums contribution - Admin 1,560.00 -
0-0-502- HDMF premiums contribution - Admin 100.00 -
0-0-502- PHIC premiums contribution - Admin 270.00 -
0-0-502- 13th Month pay - AE 2,541.25 2,541.25
0-0-503- Communication - AE 210.00 210.00
0-0-503- Miscellaneous - AE 34.00 34.00
0-0-503- Admin share - AE 15,314.95 15,314.95
0-0-503- Head Office Allocation - AE 35,226.49 35,226.49
0-0-503- Transportation - AE 438.00 438.00
0-0-404- Interest income (72.75) (72.75)
0-0-404- Overages / shortages (23.21) -
0-0-503- Provision For Income Tax (23,871.48) (23,871.48)
0-0-503- Bank charges 768.72 768.72
0-0-503- Income tax expense 23,871.48 23,871.48
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
Cash
(0.02) Cash in bank - BDO1 (0 717,405.83 717,405.81 0.02
0.00 Cash in bank - BDO2 (0 - - -
- Cash in Bank-PNB EFPS - - -
- Cash in Bank-Security Ba 22,823.45 22,823.45 -
(0.00) Cash in Bank-PNB 2059 (23,010.49) (23,010.49) (0.00)
- Petty cash fund - - -
- Change fund - - -
- Marketing Fund - - -
0.01 Payroll Fund - - -
- Purchasing Fund - - -
- Emergency Fund - - -
- Accounts receivable - TRADE - - -
(0.00) Accounts receivable - C (68,906.25) (68,906.25) -
0.00 Accounts receivable - Cr - (0.00) 0.00
0.00 Accounts receivable - Debit cards - -
(0.00) Accounts receivable - - - -
- Accounts receivable - Off - - -
0.01 Accounts receivable - E - - -
- Accounts receivable - Aff (231,389.33) (231,389.33) -
0.00 Accounts receivable - Others 175.39 175.40 (0.01)
- Advances - - -
(0.00) Advances to Officers - - -
- Advances to Employees (30,032.00) (30,032.00) -
- Advances to Suppliers (66,400.00) (66,400.00) -
- Advances to Others - -
- Inventories - - -
(0.00) Inventories - Merchandi - - -
(0.01) Inventories - Raw Materi - - -
- Inventories - RM Food - - -
(0.00) Inventories - RM Bevera - - -
- Inventories - Supplies (4,927.68) (4,927.68) -
0.00 Inventories - Unused sup - - -
0.01 Inventories - Housekeepi - - -
- Inventories - Maintenanc - - -
(0.00) Inventories - Cleaning su - - -
- Inventories - Kitchen & D - - -
- Inventories - Office Supp - - -
- Inventories - Promotiona - - -
(0.00) Inventories - Uniform - - -
0.00 Prepaid expenses - - -
- Prepaid Insurance - - -
(0.00) Prepaid Taxes and licens (32,119.44) (32,119.44) -
(42,512.43) Prepaid ads and promotions - -
(305,000.00) Prepaid Rent - - -
(4,240.08) Prepaid Others 22,916.67 22,916.67 -
- Input Vat 11,841.78 11,841.78 0.01
- Container deposits - - -
- Security deposit - - -
- Property Plant and Eq - - -
5,127.50 Land improvements - - -
- Accumulated depreciati (29,058.13) (29,058.13) 0.00
300.00 Hotel building - - -
749.33 Accumulated depreciation (14,911.50) (14,911.50) (0.00)
- Grand Pavillon buildi - - -
0.00 Accumulated depreciatio (18,464.79) (18,464.79) (0.00)
- Leasehold improveme - - -
- Accumulated depreciati (17,118.37) (17,118.37) 0.00
- Equipment 66,400.00 66,400.00 -
- Accumulated depreciati (37,074.04) (37,074.03) (0.01)
- Delivery equipment - - -
- Accumulated depreciatio (1,366.49) (1,366.49) -
- Office Equipments - - -
- Accumulated depreciatio - - -
(0.00) Kitchen and bar equi - - -
(3,695.47) Accumulated depreciatio (5,150.81) (5,150.81) (0.00)
- Sound system & band - - -
2,967.90 Accumulated depreciatio (3,467.08) (3,467.08) -
438.57 Furnitures and fixture - - -
0.00 Accumulated depreciation (11,620.97) (11,620.97) 0.00
- Software and comput - - -
289.00 Accumulated depreciati (4,439.05) (4,439.05) -
- Kitchen utensils - - -
1,560.00 Accumulated depreciation (1,321.74) (1,321.74) -
100.00 Glasswares and silve - - -
270.00 Accumulated depreciatio (2,498.48) (2,498.48) -
- Linen and draperies - - -
- Accumulated depreciatio (8,090.71) (8,090.71) -
- Motor vehicles - - -
- Accumulated depreciatio - - -
- Other fixed assets - - -
- Accumulated depreciation - Ot (9,500.10) (9,500.10) 0.00
- TOTAL DEPRECIATION - - -
(23.21) - - -
0.00 Accounts payable - - -
0.00 Accounts payable - Trad 234,158.11 234,158.11 -
(0.00) Accounts payable - Non- (155,364.88) (155,364.88) 0.00
- Accounts payable - Affilates (26,500.00) (26,500.00) -
- Withholding tax payable - - -
- Withholding tax payable (513.20) (513.20) -
- Withholding tax payable - 16 (10,095.86) (10,095.86) 0.00
- SSS, HDMF & PHIC prem - - -
- SSS premiums payable (13,455.00) (13,455.00) -
- HDMF premiums payabl (1,000.00) (1,000.00) -
- PHIC premiums payable (2,788.65) (2,788.65) -
- SSS, HDMF & PHIC loans - - -
- SSS loans payable - - -
- HDMF loans payable - (0.00) 0.00
- PHIC loans payable - - -
- Advances from officers - - -
- Accrued expenses payable 233,613.59 233,613.59 (0.00)
- Massage commissions payabl - - -
- Output VAT (20,535.83) (20,535.83) (0.00)
- Cash bond payable - - -
- Customer's deposits (341,600.00) (341,600.00) -
- Service charge payable 2,743.45 2,743.46 (0.01)
- Unearned Income - - -
- Advances Affiliates - - -
- Provision for Income tax (23,871.48) (23,871.48) (0.00)
- - - -
- Paid-up Capital - - -
- Prior year's adjustments - - -
- Retained earnings - - -
- - - -
- Room sales (445,306.85) (445,306.85) 0.00
- Functions - Food - - -
- Functions - Beverages - - -
- Restaurant Sales - Food - - -
Restaurant Sales - Bever - - -
GnS Main - Food - - -
GnS Main - Beverages - - -
GnS Samba - Food - - -
GnS Samba - Beverages - - -
Sales Discount - -
Others (351,752.49) (351,752.51) 0.01
- - -
Food - - -
Beverages - - -
- - -
Salaries and Wages - - -
Basic - OE 40,760.00 40,760.00 -
Overtime - OE 2,122.62 2,122.62 -
Manpower Services - OE 10,169.71 10,169.71 -
Service Fees - OE 37,956.00 37,956.00 -
Employee's Benefits - -
SSS, HDMF, PHIC premiums 6,176.83 6,176.83 -
Employees meal - OE - - -
Incentives - EB - - -
Insurance - EB - - -
Allowances - OE 15,300.00 15,300.00 -
13th Month pay - OE 3,396.67 3,396.67 (0.00)
Separation and Retirement - - -
Employee benefits - OE 6,230.00 6,230.00 -
Uniform - OE - - -
OTH - Employees - OE - - -
Rental 59,520.21 59,520.21 -
Light and power 76,695.84 76,695.84 -
Water bill 3,881.25 3,881.25 -
Kitchen fuel - - -
Cable subscription 3,457.50 3,457.50 -
Communications 14,330.34 14,330.34 -
Taxes and licenses 48,357.81 48,357.81 -
Security services 32,597.74 32,597.74 -
Laundry expenses 14,261.06 14,261.06 -
Donations and contribution - - -
Conference and meetings - - -
Trainings and seminars - - -
Representation - - -
Dues and subscription - - -
Party / catering expense - - -
Corporate affairs - - -
Management fee 23,912.48 23,912.48 -
Professional fee - - -
Research and development - - -
Commission - - -
Depreciation 164,082.25 164,082.25 0.00
Insurance - - -
Spoilage and breakages - -
Supplies 22,646.06 22,646.06 (0.00)
Marketing communications - - -
Advertising and promotions - - -
Ice expense - - -
Repairs and maintenance 2,083.33 2,083.33 -
Health and sanitation - - -
Transportation expense - - -
Gasoline, oil and lubricants 2,901.79 2,901.79 (0.00)
Pre-Operating Expenses - - -
Miscellaneous expenses - - -
- - -
Basic - AE 30,495.00 30,495.00 -
Overtime - AE - - -
SSS, HDMF, PHIC premiums c 1,930.00 1,930.00 -
Allowances - AE - - -
13th Month pay - AE 2,541.25 2,541.25 -
Separation and Retirement - - -
Transportation - AE 438.00 438.00 -
Communication - AE 210.00 210.00 -
Supplies - AE - -
Employee benefits - AE - - -
Representation - AE - - -
Training & Seminar - AE - -
Miscellaneous - AE 34.00 34.00 -
Admin share - AE 15,314.95 15,314.95 -
Head Office Allocation - AE 35,226.49 35,226.49 -
Conference and meetings - - - -
Professional fees - AE - - -
Insurance - AE - - -
Repair and maintenance - - - -
Gasoline, oil and lubricant - AE - - -
- - -
Other Income: - - -
Interest income (72.75) (72.75) -
Miscellaneous income (23.21) (23.21) -
Other Expenses: - - -
Bank charges 768.72 768.72 (0.00)
Interest expense - - -
Income tax expense 23,871.48 23,871.48 0.00
Acctno Account Title Total
0-0-102-1 Cash in bank - BDO1 (005-838002847) 280,261.94 280,261.95 (0.01)
0-0-102-3 Cash in Bank-PNB EFPS 69,556.94 69,556.94 -
0-0-102-4 Cash in Bank-PNB 205970002924 27,882.74 27,882.75 (0.01)
0-0-102-5 Cash in Bank-Security Bank Payroll Acco 15,801.76 15,801.76 -
0-0-103-6 Payroll fund (6,500.00) (6,500.00) -
0-0-104-0 Accounts receivable - Guest Checkin - - -
0-0-104-1 Accounts receivable - Customers (68,906.25) (68,906.25) -
0-0-104-2 Accounts receivable - Credit cards (0.00) - (0.00)
0-0-104-3 Accounts receivable - Employees 8,595.45 8,595.44 0.01
0-0-104-4 Accounts receivable - Affiliates (195,004.33) (195,004.33) -
0-0-105-0 Advances to officers 50,000.00 50,000.00 -
0-0-106-0 Advances to employees 20,957.96 20,957.96 0.00
0-0-107-0 Advances to suppliers (66,400.00) (66,400.00) -
0-0-108-0 Accounts receivable - Others 732.44 732.41 0.03
0-0-109-0 Prepaid Others 18,750.01 18,750.00 0.01
0-0-110-1 Prepaid Taxes and licenses (32,119.44) (32,119.44) -
0-0-110-2 Prepaid Insurance 9,577.84 9,577.85 (0.01)
0-0-110-4 Prepaid ads and promotions 4,000.00 4,000.00 -
0-0-108-3 Inventories - Supplies 10,147.68 10,147.68 -
0-0-113-0A Accumulated depreciation - Land impro (87,136.29) (87,136.28) (0.01)
0-0-114-1A Accumulated depreciation - Hotel buildi (44,734.50) (44,734.51) 0.01
0-0-114-2A Accumulated depreciation - Grand Pavill (53,894.37) (53,894.37) 0.00
0-0-115-0A Accumulated depreciation - Leasehold (51,355.11) (51,355.10) (0.01)
0-0-116-0 Equipment 187,007.14 187,007.14 -
0-0-116-0A Accumulated depreciation - Equipments (103,389.09) (103,389.10) 0.01
0-0-116-2A Accumulated depreciation - delivery eq (4,099.47) (4,099.47) -
0-0-116-3A Accumulated depreciation - kitchen and (15,169.64) (15,169.64) 0.00
0-0-116-5A Accumulated depreciation - sound syst (10,401.24) (10,401.24) -
0-0-118-0A Accumulated depreciation - Furnitures an (33,850.60) (33,850.60) (0.00)
0-0-119-0A Accumulated depreciation - Software a (11,496.86) (11,496.86) -
0-0-120-0A Accumulated depreciation - Kitchen uten (3,965.22) (3,965.22) -
0-0-121-0A Accumulated depreciation - Glasswares (5,843.73) (5,843.73) -
0-0-122-0A Accumulated depreciation - Linen and dr (22,901.69) (22,901.69) -
0-0-123-0A Accumulated depreciation - Other fixed (28,063.56) (28,063.56) (0.00)
0-0-111-0 Input Vat 30,530.57 30,530.59 (0.02)
0-0-201-1 Accounts payable - Trade 153,672.52 153,672.50 0.01
0-0-201-2 Accounts payable - Non-trade (94,126.93) (94,126.94) 0.00
0-0-201-3 Accounts payable - Affilates (49,458.59) (49,458.59) -
0-0-202-0 Accrued expenses payable 274,579.23 274,579.23 0.00
0-0-202-1 Service Charge Payable (40,845.66) (40,845.66) 0.00
0-0-203-1 Withholding tax payable - 1601C (1,539.60) (1,539.60) -
0-0-203-2 Withholding tax payable - 1601E (4,790.29) (4,790.29) 0.00
0-0-204-1 SSS premiums payable (15,110.00) (15,110.00) -
0-0-204-2 HDMF premiums payable (1,200.00) (1,200.00) -
0-0-204-3 PHIC premiums payable (3,178.65) (3,178.65) -
0-0-205-2 HDMF loans payable 3,662.74 3,662.74 -
0-0-210-0 Output Vat (13,942.83) (13,942.84) 0.01
0-0-211-0 Customer's deposits 415,430.00 415,430.00 -
0-0-402-1 Room sales ### ### 0.02
0-0-402-4 Extra Bed (138,039.20) - (138,039.20)
0-0-404-9 Rental Income (915,000.00) - (915,000.00)
0-0-404-4 Other Income (15,549.60) - (15,549.60)
0-0-501-1 Basic - OE 120,600.00 120,600.00 -
0-0-501-2 Overtime - OE 2,697.70 2,697.70 -
0-0-501-5 Manpower Services - OE 87,000.32 87,000.34 (0.02)
0-0-501-6 Service Fees - OE 42,996.00 42,996.00 -
0-0-502-1 SSS Premiums contribution 15,127.50 - 15,127.50
0-0-502-11 Insurance - EB 2,128.40 2,128.40 -
0-0-502-12 Employee benefits - OE 12,690.00 18,830.00 (6,140.00)
0-0-502-2 HDMF premiums contribution 900.00 - 900.00
0-0-502-3 PHIC premiums contribution 2,247.99 - 2,247.99
0-0-502-4 Allowances - OE 45,900.00 45,900.00 -
0-0-502-5 13th Month pay - OE 10,050.01 10,050.00 0.01
0-0-502-7 Uniform - OE 2,410.00 2,410.00 -
0-0-503-1 Rental 54,337.50 54,337.50 -
0-0-503-10 Water bill 7,779.61 7,779.61 -
0-0-503-12 Cable subscription 10,372.50 10,372.50 -
0-0-503-13 Communications 42,313.70 42,313.70 (0.00)
0-0-503-14 Taxes and licenses 118,074.69 118,074.69 -
0-0-503-15 Security services 94,638.60 94,638.60 -
0-0-503-16 Laundry expenses 69,322.41 69,322.41 -
0-0-503-2 Representation 2,000.00 2,000.00 -
0-0-503-20 Dues and subscription 80,974.99 80,974.98 0.01
0-0-503-23 Management fee 72,700.59 72,700.59 -
0-0-503-27 Depreciation 476,301.37 476,301.36 0.01
0-0-503-3 Supplies 50,562.76 66,296.00 (15,733.24)
0-0-503-5 Repairs and maintenance 11,650.70 11,650.71 (0.01)
0-0-503-50 Cleaning Supplies 5,563.70 - 5,563.70
0-0-503-51 Maintenance Supplies 9,880.52 - 9,880.52
0-0-503-52 Dining Supplies 6,140.00 - 6,140.00
0-0-503-8 Gasoline, oil and lubricants 6,230.46 6,230.45 0.01
0-0-503-9 Light and power 230,048.74 230,048.74 -
0-5-503-47 Office Supplies 289.00 - 289.00
0-0-501-1A Basic - AE 89,125.16 89,125.16 -
0-0-501-2A Overtime - AE 3,508.17 3,508.17 -
0-0-502-1A SSS premiums contribution - Admin 6,272.50 - 6,272.50
0-0-502-2A HDMF premiums contribution - Admin 500.00 - 500.00
0-0-502-3A PHIC premiums contribution - Admin 1,005.00 - 1,005.00
0-0-502-5A 13th Month pay - AE 7,427.10 7,427.10 0.00
0-0-503-13ACommunication - AE 1,085.00 1,085.00 -
0-0-503-30AMiscellaneous - AE 704.35 704.35 (0.00)
0-0-503-32 Admin share - AE 39,231.63 39,231.63 -
0-0-503-33 Head Office Allocation - AE 68,649.73
0-0-503-7A Transportation - AE 2,566.00
0-0-404-2 Interest income (361.26)
0-0-404-5 Overages / shortages (23.21)
0-0-503-46 Bank charges 3,790.48
Cash
Cash in bank - BDO1 (005-838002847) 280,261.95 280,261.94 0.01
Cash in bank - BDO2 (005-830258650) - - -
Cash in Bank-PNB EFPS 69,556.94 69,556.94 -
Cash in Bank-Security Bank Payroll Ac 15,801.76 15,801.76 -
Cash in Bank-PNB 205970002924 27,882.75 27,882.74 0.01
Petty cash fund - - -
Change fund - - -
Marketing Fund - - -
Payroll Fund (6,500.00) (6,500.00) -
Purchasing Fund - - -
Emergency Fund - - -
Accounts receivable - TRADE - - -
Accounts receivable - Customers (68,906.25) (68,906.25) -
Accounts receivable - Credit cards - (0.00) 0.00
Accounts receivable - Debit cards - -
Accounts receivable - NON TRADE - - -
Accounts receivable - Officers - - -
Accounts receivable - Employees 8,595.44 8,595.45 (0.01)
Accounts receivable - Affiliates (195,004.33) (195,004.33) -
Accounts receivable - Others 732.41 732.44 (0.03)
Advances - - -
Advances to Officers 50,000.00 50,000.00 -
Advances to Employees 20,957.96 20,957.96 (0.00)
Advances to Suppliers (66,400.00) (66,400.00) -
Advances to Others - -
Inventories - - -
Inventories - Merchandise - - -
Inventories - Raw Materials - - -
Inventories - RM Food - - -
Inventories - RM Beverage - - -
Inventories - Supplies 10,147.68 10,147.68 -
Inventories - Unused supplies - - -
Inventories - Housekeeping supplies - - -
Inventories - Maintenance supplies - - -
Inventories - Cleaning supplies - - -
Inventories - Kitchen & Dining Supplie - - -
Inventories - Office Supplies - - -
Inventories - Promotional items - - -
Inventories - Uniform - - -
Prepaid expenses - - -
Prepaid Insurance 9,577.85 9,577.84 0.01
Prepaid Taxes and licenses (32,119.44) (32,119.44) -
Prepaid ads and promotions 4,000.00 4,000.00 -
Prepaid Rent - - -
Prepaid Others 18,750.00 18,750.01 (0.01)
Input Vat 30,530.59 30,530.57 0.02
Container deposits - - -
Security deposit - - -
Property Plant and Equipments - - -
Land improvements - - -
Accumulated depreciation - Land imp (87,136.28) (87,136.29) 0.01
Hotel building - - -
Accumulated depreciation - Hotel buil (44,734.51) (44,734.50) (0.01)
Grand Pavillon building - - -
Accumulated depreciation - Grand Pavi (53,894.37) (53,894.37) (0.00)
Leasehold improvements - - -
Accumulated depreciation - Leasehol (51,355.10) (51,355.11) 0.01
Equipment 187,007.14 187,007.14 -
Accumulated depreciation - Equipmen (103,389.10) (103,389.09) (0.01)
Delivery equipment - - -
Accumulated depreciation - delivery (4,099.47) (4,099.47) -
Office Equipments - - -
Accumulated depreciation - office eq - - -
Kitchen and bar equipments - - -
Accumulated depreciation - kitchen a (15,169.64) (15,169.64) (0.00)
Sound system & band instruments - - -
Accumulated depreciation - sound sy (10,401.24) (10,401.24) -
Furnitures and fixtures - - -
Accumulated depreciation - Furnitures (33,850.60) (33,850.60) 0.00
Software and computer developme - - -
Accumulated depreciation - Software (11,496.86) (11,496.86) -
Kitchen utensils - - -
Accumulated depreciation - Kitchen ut (3,965.22) (3,965.22) -
Glasswares and silverwares - - -
Accumulated depreciation - Glassware (5,843.73) (5,843.73) -
Linen and draperies - - -
Accumulated depreciation - Linen and (22,901.69) (22,901.69) -
Motor vehicles - - -
Accumulated depreciation - Motor vehicles - - -
Other fixed assets - - -
Accumulated depreciation - Other fixed ass (28,063.56) (28,063.56) 0.00
TOTAL DEPRECIATION - - -
- - -
Accounts payable - - -
Accounts payable - Trade 153,672.50 153,672.52 (0.01)
Accounts payable - Non-trade (94,126.94) (94,126.93) (0.00)
Accounts payable - Affilates (49,458.59) (49,458.59) -
Withholding tax payable - - -
Withholding tax payable - 1601C (1,539.60) (1,539.60) -
Withholding tax payable - 1601E (4,790.29) (4,790.29) (0.00)
SSS, HDMF & PHIC premiums payable - - -
SSS premiums payable (15,110.00) (15,110.00) -
HDMF premiums payable (1,200.00) (1,200.00) -
PHIC premiums payable (3,178.65) (3,178.65) -
SSS, HDMF & PHIC loans payable - - -
SSS loans payable - - -
HDMF loans payable 3,662.74 3,662.74 -
PHIC loans payable - - -
Advances from officers - - -
Accrued expenses payable 274,579.23 274,579.23 (0.00)
Massage commissions payable - - -
Output VAT (13,942.84) (13,942.83) (0.01)
Cash bond payable - - -
Customer's deposits 415,430.00 415,430.00 -
Service charge payable (40,845.66) (40,845.66) (0.00)
Unearned Income - - -
Advances Affiliates - - -
Provision for Income tax - - -
- - -
Paid-up Capital - - -
Prior year's adjustments - - -
Retained earnings - - -
- - -
Room sales (1,360,544.64) ### (0.02)
Functions - Food - - -
Functions - Beverages - - -
Restaurant Sales - Food - - -
Restaurant Sales - Beverages - - -
GnS Main - Food - - -
GnS Main - Beverages - - -
GnS Samba - Food - - -
GnS Samba - Beverages - - -
Sales Discount - - -
Others (1,062,338.79) - (1,062,338.79)
- - -
Food - - -
Beverages - - -
- - -
Salaries and Wages - - -
Basic - OE 120,600.00 120,600.00 -
Overtime - OE 2,697.70 2,697.70 -
Manpower Services - OE 87,000.34 201,447.04 (114,446.70)
Service Fees - OE 42,996.00 42,996.00 -
Employee's Benefits - - -
SSS, HDMF, PHIC premiums contribution 18,275.49 - 18,275.49
Employees meal - OE - - -
Incentives - EB - - -
Insurance - EB 2,128.40 2,128.40 -
Allowances - OE 45,900.00 45,900.00 -
13th Month pay - OE 10,050.00 10,050.01 (0.01)
Separation and Retirement benefits - OE - - -
Employee benefits - OE 18,830.00 12,690.00 6,140.00
Uniform - OE 2,410.00 2,410.00 -
OTH - Employees - OE - - -
Rental 54,337.50 54,337.50 -
Light and power 230,048.74 230,048.74 -
Water bill 7,779.61 7,779.61 -
Kitchen fuel - - -
Cable subscription 10,372.50 10,372.50 -
Communications 42,313.70 42,313.70 0.00
Taxes and licenses 118,074.69 118,074.69 -
Security services 94,638.60 94,638.60 -
Laundry expenses 69,322.41 69,322.41 -
Donations and contributions - - -
Conference and meetings - - -
Trainings and seminars - - -
Representation 2,000.00 2,000.00 -
Dues and subscription 80,974.98 80,974.99 (0.01)
Party / catering expense - - -
Corporate affairs - - -
Management fee 72,700.59 72,700.59 -
Professional fee - - -
Research and development - - -
Commission - - -
Depreciation 476,301.36 1,106,278.32 (629,976.96)
Insurance - - -
Spoilage and breakages - - -
Supplies 66,296.00 50,562.76 15,733.24
Marketing communications - ASP - - -
Advertising and promotions - - -
Ice expense - - -
Repairs and maintenance 11,650.71 11,650.70 0.01
Health and sanitation - - -
Transportation expense - - -
Gasoline, oil and lubricants 6,230.45 6,230.46 (0.01)
Pre-Operating Expenses - - -
Miscellaneous expenses - - -
- -
Basic - AE 89,125.16 89,125.16 -
Overtime - AE 3,508.17 3,508.17 -
SSS, HDMF, PHIC premiums contribution 7,777.50 - 7,777.50
Allowances - AE - - -
13th Month pay - AE 7,427.10 7,427.10 (0.00)
Separation and Retirement benefits - AE - - -
Transportation - AE 2,566.00 2,566.00 -
Communication - AE 1,085.00 1,085.00 -
Supplies - AE - -
Employee benefits - AE - - -
Representation - AE - - -
Training & Seminar - AE - - -
Miscellaneous - AE 704.35 704.35 0.00
Admin share - AE 39,231.63 39,231.63 -
Head Office Allocation - AE 68,649.73 68,649.73 -
Conference and meetings - AE - - -
Professional fees - AE - - -
Insurance - AE - - -
Repair and maintenance - AE - - -
Gasoline, oil and lubricant - AE - - -
- - -
Other Income: - - -
Interest income (361.26) (361.26) -
Miscellaneous income (6,273.21) - (6,273.21)
Other Expenses: 0
Bank charges 3790.50017
Interest expense 0
Income tax expense 0

You might also like