Track your unpaid/ unsettled balances with the Accounting ledger report export

Mews Business IntelligenceReports

Note: This article relates to a prior ledger solution in Mews Operations. If your property is using the new Ledgers feature,

 

The Accounting ledger report export overviews all guest profiles with unpaid/ unsettled balances on their accounts in Mews Operations according to the filters selected in the Accounting ledger. Property owners, managers, accountants, financial analysts, and teams responsible for data migration and integration can export the report to Excel with the flexibility to manipulate the data as needed, perform various financial analyses, and integrate it with their external financial systems. 

 

To export the Accounting ledger: 

  1. In Mews Operations, go to the main menu Screenshot_2.png > Finance > Accounting ledger. 

  1. Refine the data in the report using the filters. 

  1. Click Export. 

  1. Click on Export to Excel to export to an Excel sheet. 

 

 

In this article you can learn about: 

 
 

 

If you set the Mode filter to Detailed in the Accounting ledger, Mews exports the report in the following ways: 

 
Data tab 

 

The Data tab displays the following columns in this order:  

 

  1. Item: The name of the item.

  2. Consumed: The date and time of the item consumption.

  3. Closed: The date and time of the item bill closure. 

  4. Accounting category: The accounting category type.

  5. Code: The code corresponding to tax type.

  6. Tax rate: The tax rate value.

  7. Open past revenue: The amount for items consumed but still listed on an open bill.

  8. Unpaid invoices: The amount for items on issued invoices that remain unsettled.

  9. Open prepayments: The amount of prepayments posted to bills that still need to be closed. 

  10. Closed future revenue: The amount for items not yet consumed but already paid for and closed on the bill before arrival.

  11. Deposit ledger: The amount of prepayments, i.e., deposits, have no consumed revenue posted against them.

  12. Guest ledger: The amount of consumed revenue not paid for or on a bill that must be closed.

  13. General ledger: The total sum of the Deposit ledger and the Guest ledger. Positive values represent the total amount of revenue due to the property. Negative values represent any amount due to the customer.

  14. Profile type: The type of profile, Customer or Company.  

   

 
 

 

If you set the Mode filter to Grouped in the Accounting ledger, Mews exports the report in the following ways: 

 

 

The Data tab displays the following columns in this order: 
 
 

  1. Item: The name of the item.

  2. Consumed: The date and time of the item consumption.

  3. Closed: The date and time of the item bill closure.

  4. Accounting category: The accounting category type.

  5. Code: The code corresponding to tax type.

  6. Tax rate: The tax rate value.

  7. Open past revenue: The amount for items consumed but still listed on an open bill.

  8. Unpaid invoices: The amount for items on issued invoices that remain unsettled.

  9. Open prepayments: The amount of prepayments posted to bills that still need to be closed. 

  10. Closed future revenue: The amount for items not yet consumed but already paid for and closed on the bill before arrival.

  11. Deposit ledger: The amount of prepayments, i.e., deposits, have no consumed revenue posted against them.

  12. Guest ledger: The amount of consumed revenue not paid for or on a bill that must be closed.

  13. General ledger: The total sum of the Deposit ledger and the Guest ledger. Positive values represent the total amount of revenue due to the property. Negative values represent any amount due to the customer.

  14. Profile type: The type of profile, Customer or Company. 

 

 

 

You can learn more about the Accounting ledger here. 

 

Was this article helpful?
00



Feedback