The Trial balance in Mews Analytics

Mews Business IntelligenceMews AnalyticsReports

Note: Formerly known as Ledger analytics, this feature is now known as the Trial balance in Mews Analytics. The former Guest ledger tab in Ledger Analytics is now available as the Guest ledger standalone report in Mews Analytics. You can learn more about this report here.

 

The Trial balance is a part of Mews Analytics. It provides you with an overview of unsettled balances in your property(s), grouped by accounting category. With this financial report you can see the closing balance of all accounts opened with your business. 

 

You can use the Trial balance to: 

  • Identify errors in your accounting records, and 
  • Monitor and analyze the financial health of your business, so that you can draw insights and make adjustments. 

 

To learn more about your guests’ deposits and payments, received prior to the start of a guest’s reservation, you can use the Deposit ledger in Mews Analytics. For your guests’ deposits and payments received during their stay, you can use the Guest ledger in Mews Analytics. You can learn more about deposits in Mews here.  

 

To access the Trial balance, you need:  

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

Note: If you are an Enterprise client, you can use Mews Analytics only after you enable the integration within each property in your chain.  

 

To access the Trial balance, in Mews Operations,  

  • go to the main menu Screenshot_2.png > Analytics > Trial balance, or 
  • in the top search bar type in the first few letters of the name of the report, for example “trial...” and choose the report from the suggested searches. 

The Trial balance .png  

 This article gives you a detailed description of all the features, filters, and data available in the Trial balance and the best way to use them. 

 

In this article you can learn the following about the Trial balance: 

 

The dashboard data represents all unsettled balances in your property(s), grouped by accounting category. Note: The system refreshes your data twice daily.  

 

The dashboard displays data per registered property in Mews for multi-property enterprises. Note: You can select today's date, or up to 7 previous days. You can also check the final balance of each month, for the previous 3 months. 

 

The system loads data into the dashboard every 12 hours, and the data is usually between 8 - 12 hours old. Updated data is available every day at 9:00 UTC and at 21:00 UTC. Note: The exact time might vary based on the amount of data contained in the update. 

 

Data parameters: 

Trial balance - data parameters.png  

  • Last Refresh: UTC timestamp of the last report refresh.
  • Currency: The local currency, as per the dashboard selection. Note: You can select different currencies. The system recalculates to your selected currency, based on actual exchange rates.
  • UserId: The identity code of the user. 

Note: The dashboard recalculates all figures in the selected currency based on actual exchange rates. 

 

The Trial balance - main data section.png  

In this main data section, you can view the following fields: 

  • Open past revenue: Gross amount of unpaid revenue from consumed items and still on an open bill. 
  • Open prepayments: Amount of all open payments before the date selected. 
  • Unpaid invoices: Gross total amount from unpaid invoice(s).
  • Closed future revenue: Gross amount of all closed future revenue.
  • General ledger: Gross amount of (Open past revenue + Open prepayments + Unpaid invoices) - Closed future revenue.  

 

For the following sections, you can search for and select specific enterprises to filter your data by clicking on individual drop-down menus:   

  • Enterprise: Select one or more enterprise(s) of your choice. 

 

You can learn more about the other available filters and using them in the section below. 

 

In the Trial balance you can view the following metrics that Mews Analytics calculates from data across your property(s). 

 

The Trial balance .png  

Trial balance: Overview of unsettled balances in your property(s), grouped by accounting category. You can see the closing balance of all accounts opened with your business. 

 

You can use the data in the Trial balance to identify errors in your accounting records and monitor and analyze the financial health of your business, so that you can draw insights and adjust accordingly.  

 

You can learn more about refining data using Mews Analytics, and the additional ways of filtering your view here.  


You can apply filters to refine your data in the Trial balance. This is useful to customize your reports to display specific data, to analyze trends, quickly identify anomalies, and more.  

Trial balance - filters .png  

  • Account category: Filter by the accounting category. 
  • Account category code: Filter by the accounting category code. 
  • Date: Filter by date.
  • Currency code: Your preferred currency code. Changing the currency recalculates all metrics, based on current exchange rates
  • Chain name: Filter by chain name. 
  • Enterprise type: Filter by enterprise type.
  • Country: Filter by one or more countries.
  • City: Filter by city. 

 

You can learn more about using Mews Analytics and the other available filters here. 

 

You can export certain datasets from the different sections of the Trial balance to Excel, according to your filter selection. You can learn more about this here.  

You can also print your dashboard view of the data, per tab, in PDF format by clicking Print in the top right corner. 

  

 

You can learn more about the Deposit ledger in Mews Analytics here.  

Was this article helpful?
01



Feedback