The Trial balance is a report in Mews Operations for your property’s financial staff to validate the correct posting of all charges and payments into Mews accounting and ledgers. It helps you ensure that automated accounting processes work correctly, provides an overview of daily payments and revenue, helps reconcile the data against external POS or accounting systems and determines ledger account balances. This report is essential for financial accuracy and transparency, facilitating financial statement preparation and strategic financial planning. Mews produces the Trial balance report automatically at the end of your defined business day, and it is available for download in PDF and Excel format.

 

Learn more about configuring your business day in our help article How to configure your business day in Mews Operations to include late charges in reports and ledgers. 

 

 

To view the Trial balance in Mews Operations: 

• Go to the main menu > Finance > Ledgers > Trial balance. 

 

In this article, you can learn about: 

• Viewing past Trial balance reports 
• Exporting the Trial balance report 
• Understanding the fields in the report export   

 

 

Viewing past Trial balance reports 

To view past Trial balance reports: 

1. In Mews Operations, go to the main menu  > Finance > Ledgers > Trial balance report. 
2. Click the date picker. 
3. Select a previous date from the calendar. 

This filters the table results to only show reports for the selected date. Click the x in the date picker to clear this date and show the balances for the current date. 
 

 

Exporting the Trial balance report 

To export a daily Trial balance report: 

1. In Mews Operations, go to the main menu  > Finance > Ledgers > Trial balance report. 
2. Use the date filter or manually locate the report you want to export and click Download next to the desired format. 
    
   Note: The Trial balance is exportable in Excel or PDF format. 
    

Understanding the fields in the report export 

The Trial balance export report includes the following fields: 

• Balance brought forward: The starting balance from the previous reporting period. 
• Revenue: The total revenue earned during the current period. 
• Taxes (Non-Revenue): Collected taxes that do not count towards revenue. 
• Payment: The total payments received for the period, including those not yet recognized as revenue. 
• Today or Period total: The total transactions for the specified period. 
• Closing Balance: The outstanding balance at the end of the day. 
• Guest Ledger: Balances related to guest accounts from the previous and current day including net variance. 
• Deposit Ledger: Balances related to deposits from the previous and current day including net variance. Displays whether a deposit is present on the bill. 
• City Ledger: Balances related to all unpaid invoices from the previous and current day including net variance.  
• Ledger balance total: The overall balance for your property, including all ledgers. It is the difference between outstanding assets and liabilities. Note: This balance should match the Closing Balance. 

 

 
 

The export contains detailed data from the Deposit ledger, Guest ledger, and City ledger. If your export is an Excel file, you can find tabs for these ledgers at the bottom of the sheet: 
 

 
You can now download the daily Trial balance export and understand the fields.