How to create accounting exports using Sage Simple Accounting integration for Mews Operations

Integrations SetupMews Marketplace

You can create a TXT file directly from Mews Operations using the Sage Simple Accounting integration. Import this TXT file into your Sage Simple Accounting software to gain full visibility of your ledgers from Mews Operations. 

 

You can manually create export reports for any historical time frame as needed. 

 

In this article, you can learn how to export accounting reports using Sage Simple Accounting for Mews Operations: 

 

To ensure the exported TXT file from Mews Operations imports correctly into Sage Simple Accounting, you need to assign a Ledger account code to all accounting categories in Mews Operations. 

 

To check and assign a ledger accounting code to an accounting category: 

  1. In Mews Operations, go to the main menu A black text with a right arrowDescription automatically generated with medium confidence > Settings > Property > Finance > Accounting categories. 

  1. Click the Name of an accounting category. 

  1. Under Ledger accounting code, enter a unique code. Sage Simple Accounting software requires this code during the import process. 

A screenshot of a login formDescription automatically generated 

  1. Click Save. 

 

  1. In Mews Operations, go to the main menu A black text with a right arrowDescription automatically generated with medium confidence> Marketplace. 

  1. Under Categories, click Accounting. 

  1. Locate the Sage Simple Accounting integration, then click Explore. Alternatively, you can search for the integration using the search box. 

  1. Click Connect integration. 

  1. A pop-up displays confirming successful connection of the integration. Click OK. 

 

  1. In Mews Operations, go to the main menu A black text with a right arrowDescription automatically generated with medium confidence> Marketplace > My Subscriptions. 

  1. Locate the Sage Simple Accounting integration, then click Edit to go to the settings.  

  1. Click Configuration at the screens’ top right corner. 

  1. Enter accounting information from your Sage Simple Accounting software for the below. Fields marked with an asterisk are mandatory. 

    • Transfer accounting code*: Enter the transfer accounting code. 

    • Guest ledger account code*: Enter the guest ledger accounting code used to balance your in-house guest ledgers.  

    • Deposit account code*: Enter the accounting code used for pre-stay deposits. 

    • Account receivable account code*: Enter the accounting code used for accounts receivable. 

 

Fallback accounts

If you perform operations in Mews on products or payments not attached to an accounting category, these transactions block the export. The system uses the fallback accounts instead of the missing accounting categories. After importing them into your accounting software, you need to correct the operations concerned and send them to the correct GL accounts. 

 

To avoid this problem, Mews recommends that you check the Require accounting category setup box under Options in the accounting configuration.

 

  • Revenue fallback account code: Enter the accounting code used for any revenue operation not linked to an accounting category.
  • Payments fallback account code: Enter the accounting code used for any payment operation not linked to an accounting category.
  • Outlet bills account code: Enter the accounting code for any outlet bill operation not linked to an accounting category.
  • Other fallback account code: Enter the accounting code used for any operation not linked to an accounting category apart from the three fields above.

 


 
 

  1. Enter the Account code for each of the listed Tax account mappings found in your Sage Simple Accounting software. Note: Your configuration may require multiple account mappings.  

 

 

 

  1. Click Save changes. 
     

  1. In Mews Operations, go to the main menu A black text with a right arrowDescription automatically generated with medium confidence> Marketplace > My subscriptions. 

  1. Locate the Sage Simple Accounting integration, then click Edit to go to the settings. 

  1. Click Configuration at the screens’ top right corner. 

  1. Under Export data, enter details for the following. 

 

    • From: Select the first date to include in the report. 

    • To: Select the last date to include in the report. 

 

  1. Click Export data. A TXT file automatically downloads to your machine. 

Note: If you select multiple dates, for example, one week, the Sage Simple Accounting integration generates just one TXT file containing data for all days. 

 

 

  1. Access the file from the Downloads section on your machine.  

 

This connects and configures the Sage Simple Accounting export integration for Mews Operations. You can now export and import Sage Simple Accounting TXT files into your Sage Simple Accounting software. 

 

You can learn more about creating accounting categories here. 

Was this article helpful?
00



Feedback