The Trial balance is a report in Mews Operations that gives your financial staff an aggregated view of revenue, taxes, and payments totals by accounting category for any selected time period. Use it to review period totals, reconcile figures internally, and cross-check data against external systems such as your accounting software or POS. Start your revenue reconciliation in Mews with this report.

 

To access the Trial balance, go to Finance > Ledgers > Trial balance.

 

In this article, you can learn about:

• Viewing the Trial balance
• Selecting a period
• Exporting the Trial balance
• Understanding the fields in the report export

 

Viewing the Trial balance

When you open the Trial balance, the report loads for the last closed business day. The report displays four summary cards:

• Opening balance: The outstanding balance at the start of the selected period, representing the cumulative difference between revenue and taxes posted and payments received up to that point.
• Closing balance: The outstanding balance at the end of the selected period, after accounting for the period's activity. This becomes the opening balance for the next period.
• Activity: The net change in outstanding balances for the period, calculated as revenue plus taxes minus payments.
• Net balance: A control total confirming that all debits and credits across the ledger are equal. A green Balanced indicator confirms the ledger is in balance; a warning indicator flags a discrepancy.

 

The Period activity summary shows revenue, non-revenue taxes, and payments posted during the selected period, along with opening and closing balances per group. The total activity figure is the net of revenue and taxes posted minus payments received.

 

The Ledgers balances summary explains the opening and closing balances from the period activity summary by showing what is outstanding across the Deposit, Guest, and City ledgers. This is why the opening balance, closing balance, and activity totals match between the two sections.

 

Selecting a period

The report defaults to the last closed business day. To select a different period:

1. In the Trial balance, click the date selector.
2. Select your start date and end date.
3. The report updates automatically to show data for the selected period.

Note:

• The earliest selectable date is your ledger effective date. For financial reporting before this date, use your previous legacy reports.
• The latest selectable date is the last closed business day. The current day is not selectable.

 

Exporting the Trial balance

To export the Trial balance:

1. In Mews Operations, go to the main menu > Finance > Ledgers > Trial balance.
2. Select the period you want to export.
3. Click   Export.
4. In the export dialog, select a Format: Excel, CSV, JSON, or PDF.
5. Confirm the Period start and Period end dates.
6. Click Export.

 

Mews queues the export and processes it in the background. To download the file:

1. Go to Exports > All exports.
2. Find your export. The status shows Pending while it processes and Success when it is ready.
3. Click the file name to download it.

Note:

• Excel exports download as .xlsx, CSV as .zip, JSON as .json, and PDF as .pdf.
• You must have the Trial balance: Export permission to export the report.

 

Understanding the fields in the report export

The Trial balance export includes the following fields:

• Opening balance: The outstanding balance at the start of the selected period, representing the cumulative difference between revenue and taxes posted and payments received up to that point.
• Revenue: The total revenue earned during the selected period.
• Taxes (Non-Revenue): The total non-revenue/ taxes posted in that period.
• Payment: The total payments received for the period, including those not yet recognized as revenue.
• Activity: The net change in outstanding balances for the period, calculated as revenue plus taxes minus payments.
• Closing balance: The outstanding balance at the end of the selected period, after accounting for the period's activity. This becomes the opening balance for the next period.
• Deposit ledger: Balances related to deposits/prepayments made towards a future stay.
• Guest ledger: Balances owed by checked-in guests.
• City ledger: Balances related to issued invoices.
• Ledger balance total: The overall balance for your property, including all ledgers. Note: This balance should match the Closing balance.