The Ledger activity report in Mews Operations shows individual ledger entries across all ledgers at your property. It provides a complete view of every transaction posted in the system to aid with reconciliation and financial validation. 

 

Each transaction in Mews creates a double-entry posting, meaning it records both credits and debits. Additionally, Mews API exposes this data for integration with external accounting systems. Users cannot edit past entries in the report - any corrections appear as new entries in the current period.

 

The system groups ledger entries by the item they were posted for, such as an order item, payment, or invoice, then split by accounted day and tax rate. This makes it easier to see which movements belong to the same underlying posting.

 

Self-balancing movements

When two movements on the same item cancel each other out completely on the same calendar day, for example, when you move an item from one bill to another on the same day it was posted, those movements net to zero and are hidden from the report by default. This keeps the report free of administrative entries that have no real accounting effect.

 

The filtering works on a per-day basis, not across the full date range you select:

• If you view a single day, the system hides only the movements posted and offset on that same day.

• If you view a date range spanning multiple days, all underlying movements appear, including any reversal and repost pair from a later day. This is because those movements fall on different days and do not net to zero within a single calendar day.

Note: The report total always reconciles to the same figure regardless of whether self-balancing movements are hidden. Only movements that net to exactly zero on a single calendar day are suppressed. Genuine corrections and cancellations that span different days remain visible.

 

Zero-rate VAT postings

Items taxed at 0% VAT now produce a tax-ledger entry even though the monetary value of that entry is zero. This entry records the applicable tax rate code and taxable base, so your audit trail is complete. The displayed tax totals in the report are unchanged, for example, a 0% rate still shows as zero, but the entry now exists in the ledger so you can verify which tax rate applied to each posting.

 

To view the Ledger activity report: 

• In Mews Operations, go to the Main menu > Finance > Ledger activity report. 

   

 

At the top of the report, Mews displays the following two summary sections:

1. Ledger summary

This section shows the total value of postings for each ledger group for the selected reporting dates:

• Total revenue 

• Total non revenue 

• Payments 

• Outlets

2. Balance summary

This section helps you confirm that all ledger postings are accurate and balanced. You see the following highlights:

• Deposit ledger: Shows the total value of all postings to the Deposit ledger for the selected time period.

• Guest ledger: Shows the total value of all postings to the Guest ledger for the selected time period.

• City ledger: Shows the total value of all postings to the City ledger for the selected time period.

• Net balance: Uses the following formula to show whether all postings are balanced:

  Revenue + Non-revenue + Payments − Guest ledger − City ledger + Deposit ledger

  A value of zero means the ledger postings are correct and balanced.

Note: If the net balance is not zero, it usually indicates a posting issue. You may see a positive or negative amount, which means the system has not balanced the ledger activity.

 

For example, if a technical issue causes a posting to skip a ledger, the net balance highlights the discrepancy immediately.

 

Using the Ledger activity report

The Ledger activity report provides a comprehensive overview of individual transactions. Use it to verify your property’s accounting flows across different ledgers and reports.

 

You can use filters and accounting categories to investigate and validate accounting activity.

 

For example, use the Ledger activity report to:

• Compare totals

  • Compare ledger totals from the Trial Balance with the summarized view in the Ledger activity report.

  • Review detailed transactions to identify differences.

• Reconcile ledger movements

  • Review daily movements on the Deposit, Guest, or City ledgers.

  • Confirm that balances match your expected accounting results.

• Identify discrepancies

  • Spot unusual or incorrect transactions.

  • Investigate differences between reports or ledgers.

• Review audit trail

  • Track all postings recorded in the system.

  • Follow transaction history for verification and control.

• Check corrections

  • Review adjustments and corrections made to transactions.

  • Confirm that updates reflect the correct accounting outcome.

 

 

In this article you can learn about:

 

• Ledgers available in the report
• Setting the filters in the report
• Understanding the fields in the report
• How to store the report link
• Exporting the Ledger activity report

Ledgers available in the report

The Ledger activity report displays individual posting entries for the following ledgers in one table and gives you full control over how you work with columns, filters, and groupings: 

• Revenue ledger: Revenue-generating transactions and their amounts. 

• Non revenue ledger: Non revenue-generating transactions, such as VAT taxes, city taxes, tax adjustments, taxes on prepayments, or other local taxes.  

• Payments ledger: Payments to your property. 

• Outlets ledger: Outlets transactions. 

• Deposit ledger: Transactions posted to the Deposit ledger. This ledger records received deposits as credits and consumed deposits as debits. 

• Guest ledger: Transactions posted to the Guest ledger. This ledger records due guest charges as debits and records balancing transactions such as payments or invoices as credits. 

• City ledger: Transactions posted to the City ledger. This ledger records issued invoices as debits and invoice payments as credits. 

 

Setting the filters in the report

You can refine data in this report with the following filters:

• Period:

  • Select the start date to define the first day included in the report.

  • Select the end date to define the last day included in the report.

Note:

• The system calculates the available date range dynamically based on the volume of data in your property.

• To export larger data sets, you can export the report to Excel to access a larger date range than the one available in the report view.

 

 

 

• Group by: Choose how to group your data and create multiple levels of grouping. You can add more groupings, such as Accounting category or Owner, and rearrange them to suit your needs. Note: By default, the report groups data by ledger type.

To add grouping:

1. Click Group by.

2. Select one or more options from the list.

For example, select Accounting category or Owner to organize your data into specific groups.

 

To add grouping from a column:

1. Click the three dots on the column name.

2. Select Group by this column.

Note: When you group data from a column, the system adds this column to the Group by list.

 

To rearrange grouping levels:

1. Click and drag a group.

2. Move it to the desired position.

To remove grouping:

1. Click the X next to the group name.

 

• Column settings: Customise which columns you see in the report. You can show, hide, or reorder any of the following columns:

  • Group: Shows the selected grouping criteria. Note: You can expand or collapse all groups from the column header.

  • Type: Specific type of the ledger entry.

  • Accounting category: Accounting category assigned to the transaction.

  • Item: Name of the product or service included in the transaction.

  • Bill: Bill associated with the transaction. Note: This field is empty for unpaid items.

  • Owner: Profile of the person or company responsible for the transaction.

  • Accounted date: The date on which a posting was recorded into your accounting ledgers, typically the date the associated bill was closed, not the date a guest consumed the item. The accounted date therefore reflects when the transaction actually entered the ledgers, rather than when a guest stayed or dined at your property. For example, a guest stays on the night of 10 June, but their bill is closed on 12 June at checkout. The accounted date for that stay charge shows as 12 June, not 10 June, because that is when the posting entered the accounting records.

  • Count: Quantity of the item or service.

  • Tax rate: Tax rate applied to the transaction.

  • Net: Net value of the transaction before tax.

  • Amount: Total value of the transaction, including tax.

  • Ledger account code: Accounting code assigned to the transaction based on your configuration.

  • Creator: Name of the user who created the transaction.

  • Created: Date and time the transaction was created.

  • Consumption date: Date the guest consumed the service or item.

  • Cost center code: Internal code used to assign the transaction to a specific cost center.

  • Tax code: Code representing the type of tax applied.

  • Tax name: Name of the tax applied to the transaction.

  • Service: Type of service included in the transaction.

  • Status: Status of the transaction.

  • Rebate: Indicates whether the transaction is a rebate.

To add a column to the report: Check the box next to the column name.

To remove a column from the report: Uncheck the box next to the column name.

To reorder the columns in the report: In the main table view, click and drag the column heading left or right.

 

• Filter by search: You can use the quick filter field to search across all visible columns at once.

Quick search:

1. Enter a keyword in the search field.

2. View matching records in the report.

For example, type “garage” to find all related entries, or type a guest or owner name to focus on specific transactions. Note: Quick search works for text-based columns only. It does not apply to numbers or dates.

 

Filter by a specific column:

1. Click the three lines on the column header.

2. Select a filter option.

3. Choose a condition, such as starts with or equals.

4. Enter your search value.

Sorting:

1. Click the column header.

2. Sort data in ascending or descending order.

Note:

• A blue dot appears on the column header when you apply a column filter.

• Use these columns to display the exact information you need. For example, show Creator and Created to support audits, or show Status and Rebate to identify corrections and adjustments easily.

• By default, the report displays the data for the last closed business day.

• You cannot view data prior to the release of the ledgers or for future dates

• If you want to see data for only one day, set the Period Start date and Period End date as the same date.

  • The system calculates the available date range dynamically based on the volume of data in your property. The available range can vary from a few weeks to several months.

  • To export larger data sets, you can export the report to Excel to access a larger date range than the one available in the report view.

 

Understanding the fields in the report

Depending on the Column settings you select, the Ledger activity report displays the following fields:

• Group: Ledger group of the transaction.

• Type: Specific type of the ledger entry.

• Accounting category: Accounting category assigned to the transaction.

• Item: Name of the product or service included in the transaction.

• Bill: Bill associated with the transaction, if one exists.

• Owner: Profile of the person or company responsible for the transaction.

• Accounted date: The date on which a posting was recorded into your accounting ledgers, typically the date the associated bill was closed, not the date a guest consumed the item. The accounted date therefore reflects when the transaction actually entered the ledgers, rather than when a guest stayed or dined at your property. For example, a guest stays on the night of 10 June, but their bill is closed on 12 June at checkout. The accounted date for that stay charge shows as 12 June, not 10 June, because that is when the posting entered the accounting records.

• Count: Quantity of the item or service.

• Tax rate: Tax rate applied to the transaction.

• Net: Net value of the transaction before tax.

• Amount: Total value of the transaction, including tax.

• Ledger account code: Accounting code assigned to the transaction based on your configuration.

• Creator: Name of the user who created the transaction.

• Created: Date and time the transaction was created.

• Consumption date: Date the guest consumed the service or item.

• Cost center code: Internal code used to assign the transaction to a specific cost center.

• Tax code: Code representing the type of tax applied.

• Tax name: Name of the tax applied to the transaction.

• Service: Type of service included in the transaction.

• Status: Status of the transaction.

• Rebate: Indicates whether the transaction is a rebate.

You can filter by any column in the main table view. To do so,

• Click the Filter icon next to the column name.

  • You can then use the Filter by search field or check the boxes next to the filtering options to filter the column.

How to store the report link

After adjusting the filters, groupings, and columns to your preference,

• copy the page URL from your browser.

• save the URL in your bookmarks.

For example, if you group by ledger type, filter for revenue, and add columns for consumption date and status, save the resulting URL to quickly access that custom view again. To run the report for a different period, update only the date filter.

 

Note: Mews does not currently support saving report views within the system, so saving the URL externally is the best way to revisit a specific view.

Exporting the Ledger activity report

To export the Ledger activity report:

1. In Mews Operations, go to the main menu > Finance > Ledger activity report.

2. Set the desired filters or manually locate the report you want to export and click Download.

Note:

• You can export the Ledger activity report in Excel or CSV format.

  • The export includes additional columns that are not visible in the system.

  • The export contains raw data with individual postings.

  • The export does not include any grouping or filtering applied in the report view.

 

  

You can now use the Ledger activity report to track financial transactions across multiple accounting ledgers.