Track your revenue with the Accounting report export

Mews Business IntelligenceReports
 

The Accounting report export overviews all revenue posted in Mews Operations according to the filters selected in the Accounting report. 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 report: 

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

  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 report, Mews exports the report in the following ways: 

 

 
The Items tab displays the following columns in this order: 

 

  1. Code: The code corresponding to tax type. 

  1. Accounting category: The accounting category type. 

  1. Cost center code: The code of cost center. 

  1. External code: The code of the category in external systems. 

  1. Ledger account code: The code of the ledger account, double entry accounting. 

  1. Posting account code: The code of the posting account, double entry accounting. 

  1. Type: The revenue type of the item. 

  1. Service: The service type offered by your enterprise. 

  1. Item: The name of the item. 

  1. Creator: The user who created the order item. 

  1. Created: The creation date and time of the item. 

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

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

  1. Bill: The bill name and number. 

  1. Bill type code: The bill type code you set when creating a counter, if necessary for your accounting exports. 

  1. Bill counter: The bill counter name. 

  1. Owner: The name of the bill owner. Either a customer or a company. 

  1. Owner tax ID: The tax identifier of the bill owner. 

  1. Associated profile: The name of the profile associated with the bill. Either a customer or a company. 

  1. Associated tax ID: The tax identifier of the profile associated with the bill. 

  1. Status: The bill state. 

  1. VAT rate: The tax rate applied to the item. 

  1. Net: The total, excluding tax. 

  1. VAT: The value-added tax, excluding the price of the taxed item. 

  1. Amount: The total value of the item, i.e., Net + VAT. 

 

 

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

 

 
The Items tab displays the following columns in this order: 

 

  1. Code: The code corresponding to tax type. 

  1. Accounting category: The accounting category type. 

  1. Cost center code: The code of cost center. 

  1. External code: The code of the category in external systems. 

  1. Ledger account code: The code of the ledger account, double entry accounting. 

  1. Posting account code: The code of the posting account, double entry accounting. 

  1. Type: The revenue type of the item. 

  1. Item: The name of the item. 

  1. Count: The number of payments per service. 

  1. VAT rate: The tax rate applied to the item. 

  1. Net: The total, excluding tax. 

  1. VAT: The value-added tax, excluding the price of the taxed item. 

  1. Amount: The total value of the item, i.e., Net + VAT. 

 

 

You can learn more about the Accounting report here. 

Was this article helpful?
01



Feedback