If you want to use analytics to compare your actual vs budgeted occupancy and revenue, you can use the budget import feature. It allows you to upload projected monthly revenue and occupancy info (sorted by space type and business segment).

Step 1: Download the template

  1. Make sure you're in the property in Mews that you want to import your budget to (and not another property in your chain).
  2. Go to Main menu > Analytics > Manager analytics.
  3. Click the Analytics import icon in the top-right.
  4. Go to the Budgets tab.
  5. Click the Download empty template icon in the top-right.
  6. Once the download is complete, open the Excel file.

Step 2: Fill in the template

How does it work?

The budget import allows you to import monthly budget information (one row for the first day of each month). Each row in the spreadsheet holds the statistics for one month/business segment/space type combination. This means that:

  • If you want to import one year of historical information for 3 space types, you'll need (12*3) rows. You'll have a row for each month of the year, for each space type.
  • If you want to import one year of historical information for 3 space types and 2 business segments, you'll need (2*3*12) rows. You'll have a row for each month of the year, for each space type/segment combination.

What do the fields mean?

In the first four columns, specify which date, segment, and space type the statistics are for.

  • Date: Enter the first day of the month that you're providing statistics for.
  • Service (not required): Leave this blank.
  • Business segment (optional): Specify the business segment you're providing statistics for (enter its Name or Short name).
  • Space type: Specify which space type you're providing statistics for.

In the following columns, add information from your budget for the selected month, segment, and space type.

  • Available spaces: Enter the number of available spaces in the budget for that month.
  • Occupied spaces: Enter the number of occupied spaces in the budget for that month.
  • Space revenue: Enter the revenue (in your default currency) generated by night stays in the budget for that month.
  • Product revenue: Enter the revenue (in your default currency) generated by products in the budget for that month.
  • Additional revenue: Enter the revenue (in your default currency) generated from sources other than stays or products in the budget for that month.

Step 3: Upload the template

  1. Make sure you're in the property in Mews that you want to import your budget to (and not another property in your chain).
  2. Go to Main menu > Analytics > Manager analytics.
  3. Click the Analytics import icon in the top-right.
  4. Go to the Budgets tab.
  5. Click Choose file, then find the completed template.
  6. Click Import.

What next?

Once you've uploaded your budgets, you'll gain access to a new screen through Manager analytics where you can compare your actual revenue to your budget. To access it:

  1. Main menu > Analytics > Manager analytics.
  2. From the Dashboard tab, click YoY comparison.
  3. Click Budgets.
Did this answer your question?