Of all your hotel business’s financial accounts in general ledger. Hotel Business Bookkeeping - Demo Version (1.Short, the ‘Chart of Accounts’ or COA is identified as an index Also, you can fill booking and sales data with your own data or play around with dummy data inside. Try demo version below to learn more about its features. Some important financial ratio parameters are included in the dashboard. For example, package with breakfast, package for one person etc.Īnd, there is a Dashboard to analyze your hotel occupancy and revenue projection in chart visualization. It will allow you to set different packages and price to similar room on similar dates. This spreadsheet also has multi packages/pricing feature. So, you don’t have to type similar information twice. In sales worksheet, there is a feature to pick guests booking data by selecting their booking ID.

See and analyze your assets, through asset list and balance sheet.

See and analyze monthly and one year profit and loss.

It has booking calendar capability with automatic room booking calendar

Track booking channel and guests receivable.

With this hotel bookkeeping spreadsheet template you can : Then, if you feel comfortable with default financial category names, you can start typing your financial transactions.ĬHECK THIS TEMPLATE > Employee Payroll Calculator Hotel Bookkeeping Spreadsheet Template Features You can set it to follow your country’s fiscal period, for example USA fiscal period starts from 1st October. To start using this spreadsheet, you need to set its starting date first. This spreadsheet also fits landlords who manage apartments. It has booking calendar module to manage your hotel guests. You can use this hotel bookkeeping template as your daily record book or as a file to put summary of your daily or weekly transactions.

You can still use worksheet bar to go to other worksheet, though. And there is a menu, serves as table of contents, to help you move between worksheets easily. You need to open this template in Microsoft Excel, in Mac or Windows.Īll worksheets in this template link to each other. All financial statements have accounting format with automatic balance calculation without any needs to fill transaction with accounting method. You will see after you are using this spreadsheet template. To get accounting report you need to fill data in accounting way. All reports will follow accounting format.

They will be summarized into profit and loss or income statement, balance sheet, cash flow and equity statement. You don’t have to write your hotel transactions twice and follow double-entry bookkeeping method.Īll financial statements will summarize all transactions automatically. Its transaction module is similar with common sales and cash book. This hotel bookkeeping spreadsheet template doesn’t require its users to understand accounting.

Hotel accounting in excel guide