Filetype Excel XLSX | Posted on 10 Aug 2022 | 4 years ago
Authentication
digital resources
302x Filetype XLSX File size 0.31 MB Source: www.smartsheet.com
Sheet 1: EXAMPLE - Profit and Loss
| HOTEL PROFIT AND LOSS STATEMENT TEMPLATE | ||||||||||
| PROFIT & LOSS STATEMENT | ||||||||||
| ––––– TIME PERIOD REPRESENTED ––––– | ||||||||||
| HOTEL NAME | START DATE | END DATE | ||||||||
| 00/00/0000 | 00/00/0000 | |||||||||
| PREPARED BY | DATE | VERIFIED BY | DATE | |||||||
| 00/00/0000 | 00/00/0000 | |||||||||
| Complete non-shaded fields, only. | ||||||||||
| INCOME | ||||||||||
| REFERENCE ID. | DESCRIPTION | AMOUNT | ||||||||
| A1111-4267 | Guest Reservations | $650,000 | ||||||||
| A1111-4268 | Food Purchases | $95,000 | ||||||||
| A1111-4269 | Events | $151,000 | ||||||||
| A1111-4270 | Other | $48,750 | ||||||||
| INCOME TOTAL | $944,750 | |||||||||
| LESS SALES RETURNS / ALLOWANCES ( enter "-" negative amount ) | $(7,562) | |||||||||
| TOTAL REVENUE | $937,188 | |||||||||
| EXPENSES | ||||||||||
| REFERENCE ID. | DESCRIPTION | AMOUNT | ||||||||
| R4444-5345 | Utilities | $21,500 | ||||||||
| R4444-5346 | Maintenance | $17,640 | ||||||||
| R4444-5347 | Depreciation | $29,500 | ||||||||
| R4444-5348 | Staff Wages | $250,400 | ||||||||
| R4444-5349 | Insurance | $16,500 | ||||||||
| R4444-5350 | Legal Fees | $7,800 | ||||||||
| R4444-5351 | Advertising | $18,500 | ||||||||
| R4444-5352 | Supplies | $4,750 | ||||||||
| R4444-5353 | Other | $8,500 | ||||||||
| EXPENSE TOTAL | $375,090 | |||||||||
| NET INCOME BEFORE TAXES | $569,660 | |||||||||
| TAX RATE ( enter % ) | 9.53% | |||||||||
| INCOME TAX EXPENSE | $54,289 | |||||||||
| NET INCOME | $515,371 | |||||||||
| CLICK HERE TO CREATE IN SMARTSHEET | ||||||||||
| HOTEL PROFIT AND LOSS STATEMENT TEMPLATE | |||||
| PROFIT & LOSS STATEMENT | |||||
| ––––– TIME PERIOD REPRESENTED ––––– | |||||
| HOTEL NAME | START DATE | END DATE | |||
| 00/00/0000 | 00/00/0000 | ||||
| PREPARED BY | DATE | VERIFIED BY | DATE | ||
| 00/00/0000 | 00/00/0000 | ||||
| Complete non-shaded fields, only. | |||||
| INCOME | |||||
| REFERENCE ID. | DESCRIPTION | AMOUNT | |||
| INCOME TOTAL | $- | ||||
| LESS SALES RETURNS / ALLOWANCES ( enter "-" negative amount ) | $- | ||||
| TOTAL REVENUE | $- | ||||
| EXPENSES | |||||
| REFERENCE ID. | DESCRIPTION | AMOUNT | |||
| Utilities | |||||
| Maintenance | |||||
| Depreciation | |||||
| Staff Wages | |||||
| Insurance | |||||
| Legal Fees | |||||
| Advertising | |||||
| Supplies | |||||
| Other | |||||
| EXPENSE TOTAL | $- | ||||
| NET INCOME BEFORE TAXES | $- | ||||
| TAX RATE ( enter % ) | 0.00% | ||||
| INCOME TAX EXPENSE | $- | ||||
| NET INCOME | $- | ||||
no reviews yet
Please Login to review.
