Ledgers in Mews Operations FAQs

You can use the accounting ledgers in Mews Operations to manage and monitor your property's financial activity across guest and operational accounts. You can use them to track deposits for future stays, oversee balances during a guest's stay, and view overall financial performance. You can complete these actions during your daily finance or front office operations, especially when handling check-ins, billing, or closing your accounting period.

 

To access all ledgers:

In Mews Operations, go to the main menu  > Finance > Ledgers.

 

In this article, you can find answers to the following frequently asked questions:

• Where has the accounting report gone?
• Why do I see differences between the Accounting report and the Ledger activity Report?
• Why do I see differences between the new accounting ledgers/ Ledger activity report and the values in my accounting system?
• The accounting ledger looks different. Can I access the previous accounting ledger?
• Where has the linking of payments to reservations feature gone?
• Do I still need to perform a night audit?
• Can I edit a past ledger entry?
• How do I investigate a posting?
• Can I access past Trial balance reports?
• Why is some of my past data missing from the ledgers?
• Why can I not see future dates?
• Why do I see the error "Deleted bills cannot be opened" in the Guest ledger?
• Why do I see closed bills in the Deposit ledger or Guest ledger?
• How do I understand what the non-revenue ledger represents, and how is it different from tax?
• Why do I see rebated bills in the Deposit ledger or Guest ledger when they balance the original bill?

 

Where has the Accounting report gone?

You can still access the Accounting report, but it now has a new name. To better reflect its purpose, Mews renamed it to the Order item report.

 

Why do I see differences between the Accounting report (Order item report) and the Ledger activity report?

Mews does not match the reports, and it is expected behaviour. The Ledger activity report is a new report built on a new reporting framework. The data is immutable, and the system handles corrections through dual-entry accounting principles. Mews designed the new Ledger activity report to address some of the limitations of the existing reporting. Some of the key differences include:

• the reporting of corrections.
• posting of nights when the system checks in reservations. The Accounting report allows changes within the Editable History Window, so any updates made during that window can create discrepancies between the two reports.

Learn more in our help article The Ledger activity report in Mews Operations.

 

Why do I see differences between the new accounting ledgers/ Ledger activity report and the values in my accounting system?

Mews originally designed the accounting integrations to utilize data from the Accounting report. This meant you could amend the data within the editable history window, and it is not immutable.

If you use an accounting integration, update it to use the new endpoint to see the same immutable data in your accounting system. If you use Omniboost for M3, QuickBooks, or Xero, these integrations have been updated and are available using our new accounting dataset. Omniboost continues to work on updating remaining integrations. Note: If your accounting integration is not managed by Omniboost, contact your integration partner to discuss updating the integration.

Once updated, you can enable the updated integration in the Mews Marketplace.

If you need help with enabling or updating your integration:

• Contact your integration partner directly.
• If you experience technical issues, submit a support ticket through the Mews Digital Assistant.

 

The accounting ledger looks different. Can I access the previous accounting ledger?

Based on user feedback, Mews has updated the accounting ledgers, and they are now available as standalone ledgers, rather than a single combined view. You can still access the original Accounting ledger through the link on the Ledgers screen if you need to view historic data. If you are accessing the old ledger to view live data, Mews would like to understand why the new ledgers do not fulfil your needs. Please submit the feedback through the form provided at the end of this help article.

 

Where has the linking of payments to reservations feature gone?

This feature was originally released to help Mews identify which payment a reservation was related to. Having consulted with users, Mews recognizes that the payment is related to the reservation(s) in the same bill, and therefore this linkage is not required and can be inferred from the context within the bill.

When the system processes a payment automatically, Mews still links it to the reservation if applicable. This helps you see,

• why your property took the payment
• which bill it applies to

Note: There is no requirement to manually link payments to reservations in Mews.

 

Do I still need to perform a night audit?

No manual night audit is required. Mews automatically closes the day based on your business day configuration.

 

Can I edit a past ledger entry?

No. All ledger entries are immutable. The system creates corrections by posting a new offsetting entry.

 

How do I investigate a posting?

Use the Ledger activity report to filter and view detailed entries by ledger, profile, date, or transaction type.

 

Can I access past Trial balance reports?

Yes. Use the date picker to view and download the Trial balance for any previous business day from the date of the new ledgers release.

 

Why is some of my past data missing from the ledgers?

You can only view past data in the new ledgers from the date of release.

 

Why can I not see future dates?

Accounting data reflects the moment when an event occurs and the system posts it to accounting. You can use the Order item report for forecasting and future data.

 

Why do I see the error "Deleted bills cannot be opened" in the Guest ledger?

You see this error because the bill no longer exists in the system, even though it appears in a ledger snapshot.

 

This situation occurs when:

• The bill contains items at the time of the ledger snapshot
• You move the items from the bill after the snapshot
• You delete the bill after the items are moved
• You try to open the bill from the ledger snapshot

 

Since the system deletes the bill, you cannot access its details.

 

For example,

• You create a bill and add items
• The system captures a ledger snapshot
• You move the items to another bill
• You delete the original bill
• You open the ledger snapshot and select the deleted bill
• The error message appears

Note: Ledger snapshots show historical data. If you delete a bill after the snapshot, you cannot open it from the snapshot view.

 

Why do I see closed bills in the Deposit ledger or Guest ledger?

You see closed bills in the Deposit ledger or Guest ledger because ledger reporting follows accrual accounting. This means the system recognizes revenue when services are delivered, not when the bill is closed or paid.

A bill remains visible on the ledger until all items on the bill are consumed and posted.

For example, if you close a bill before a guest’s stay or during check-in, the bill still appears on the ledger until the check-out date, when the last night is posted.

• The ledger shows all bill items that are consumed

• A closed or paid bill can still include future items

• The bill disappears from the ledger only after all items are posted, and the customer pays the bill

Note: A closed bill does not mean all services are delivered. The ledger reflects when services are consumed, not when the bill is paid.

This behavior ensures that your financial data stays accurate and aligned with accounting principles.

 

How do I understand what the non-revenue ledger represents, and how is it different from tax?

The non-revenue ledger represents liabilities, not revenue. It shows amounts that you collect but do not recognize as earned income.

• It includes taxes applied to revenue, such as value-added tax or state tax. The system shows the tax amount, and the accounting category links to the item to which the tax applies.

• It includes city taxes, whether you add them as a product or through a product rule.

For example, when you post a product with tax, the revenue goes to a revenue ledger, while the tax amount appears in the non-revenue ledger as a liability.

Note: If you change the city tax classification on a product, the change applies only to newly created products.

 

Why do I see rebated bills in the Deposit ledger or Guest ledger when they balance the original bill?

You see rebated bills in the Deposit ledger or Guest ledger because the system records each accounting event separately. A rebate does not remove the original bill from the ledger.

The ledger follows accrual accounting. This means you recognize revenue when services are delivered, not when a bill is paid or rebated.

For example, if you create a bill and then apply a full rebate, the system shows:

• The original bill as the recorded revenue

• The rebated bill as the reversal of that revenue

Both entries remain visible to ensure accurate financial reporting.

• The ledger shows a complete audit trail of all transactions

• The original and rebated bills represent two separate accounting events

• Bills stay visible until all items on the bill are consumed and posted

• Items move out of the Deposit ledger after the stay begins and consumption starts

Note: A rebated bill does not remove the original transaction from the ledger. The system keeps both entries visible until all related services are consumed to ensure accurate reporting and traceability.