JS122-FNA-XL ◉ HOTEL BUSINESS BOOKKEEPING

Description

Hotel Business Bookkeeping for Non Accountant is an Excel spreadsheet for non accounting people to record financial transactions and generate financial reports for hotel business or short term room rental business.

You can start using this template by set its starting fiscal period. Then, record guest reservation in booking menu. This reservation will be used as reference in sales module. When, guests are checking out, you can easily pick respective guest reservation data and add with non room transactions.

It is designed for non accountant. Every hotel owners can use it.

How can this spreadsheet accommodate hotel business financial transactions?

It can record your daily, weekly or monthly transactions or combination of those. There are simple transaction worksheets where you can entry your data easily.

All recorded transactions will be mapped in financial statements with standard Accounting format automatically. Fits to any small business owners and employees who don’t have time to learn accounting but want to generate professional report like Accounting people do.

No need to calculate depreciation manually.

No need to set the report.

Just type transactions and financial reports are ready for further analysis.

What you can do with this spreadsheet?

1. Record guest’ reservations
2. Record hotel transactions
3. Print invoices and cash receipts on any transactions
4. Track account receivable and payable
5. Generate financial report with standard accounting format automatically
6. View company financial status in Dashboard visualization

Hotel Business Bookkeeping Spreadsheet prices are based on number of rooms with Single and Multi User License. There are 4 available room categories now. Those are : 50, 100, 150 and 200 rooms models.

List of Modules

Front Menu

Setup

1. Company Info
2. Supplier List
3. Receipt Number List
4. Asset List
5. Service Product List
6. Channel List
7. Prepaid Revenue | Expenses
8. Financial Report

Room Management

1. Room List
2. Room Price List
3. Booking Calendar

Transaction

1. Booking | Deposit
2. Sales
3. Purchase
4. Other Income | Expenses
5. Internal Bank/Cash Account Transfer/Mutation
6. Depreciation

Receipt

1. Invoice
2. Cash Receipt
3. Purchase Order

Account Payable/Receivable

1. Receivable Customer List
2. Account Receivable | Customer
3. Account Receivable | Channel
4. Account Payable

Report

1. Inventory
2. Profit & Loss | Room
3. Profit & Loss | Product
4. Profit & Loss | Monthly
5. Profit & Loss
6. Balance Sheet
7. Cash Flow
8. Equity
9. Assets
10. Cash Accounts
11. Dashboard