This article explains how to import your budgets into Mews Analytics using the budget import feature. Revenue managers can access your budget comparison via the Dashboard tab in Manager analytics. You can learn more about using Manager analytics here. 

Importing budgets is useful to: 

• Compare your actual to budgeted occupancy and revenue for improved forecasting. 
• Identify where to allocate resources for improved efficiency year-on-year. 
• Strategically make adjustment in pricing strategies and services based on data analysis. 
• Automate financial budget data analysis. 
• Gain a clear overview of financial performance for better cost control and revenue enhancement. 

To access Mews Analytics, you need:   

• an Enterprise subscription to Mews OR    
• to purchase Mews Analytics as an add-on OR  
• a Mews Multi-Property subscription AND  
• to be either an Admin in your Mews account or have the Access sensitive reports permission.  

Note: Enterprise clients need to enable Mews Analytics integration for each property in their chain to gain access to it.     

In this article you can learn how to import budgets in the following steps: 

• Step 1: Download the template 
• Step 2: Fill in the template
  • Fields in the template
• Step 3: Upload the template
• Step 4: Access your budgets YoY comparison 

Step 1: Download the template 

Before downloading the template, first make sure you're in that property in Mews in which you want to import your budget. 

To download the template: 

1. In Mews Operations, go to the Main menu > Analytics > Manager analytics.
2. Click Analytics import as below: 

3. Go to the Budgets tab: 

4. Click Download empty template in the top-right: 

5. Once the download is complete, open the Excel file. 

Step 2: Fill in the template 

The budget import feature means you can import monthly budget information, or your projected monthly revenue and occupancy information, sorted by space type and business segment. 

You need to organize your data in the template so that each row in the spreadsheet contains the statistics for one month/ business segment/ space type combination. Begin each row with the first day of each month. 

For example: 

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

Fields in the template 

In the first four columns, you need to 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 generated by night stays in the budget for that month. Note: In your default currency. 
• Product revenue: Enter the revenue generated by products in the budget for that month. Note: In your default currency. 
• Additional revenue: Enter the revenue generated from sources other than stays or products in the budget for that month. Note: In your default currency. 

Step 3: Upload the template 

Before uploading the template, make sure you're in the property in Mews that you want to import your budget to. 

To upload the template: 

6. Go to the Main menu > Analytics > Manager analytics.
7. Click  Analytics import in the top-right: 

8. Go to the Budgets tab: 

9. Click to search for your completed template or drag it into the area allocated.
10. Click Import. 

Step 4: Access your budgets YoY comparison 

Once the budget upload is complete, you gain access to a new screen through Manager analytics, where you can compare your actual revenue to your budget.  

To access your budget YOY comparison: 

11. Go to the Main menu > Analytics > Manager analytics. 

12. From the Dashboard tab, click YoY comparison as below: 

13. Click Budgets as below. This screen shows your uploaded budgets.  

This imports your budget into Mews Analytics. You can now compare it with your actual revenue.  

You can learn more about Mews Analytics here