How to create accounting exports using Acomba integration for Mews Operations

You can create an ADX file directly from Mews Operations using the Acomba integration. Import this ADX file into your Acomba 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 Acomba for Mews Operations:

 

• Step 1: Assign ledger accounting codes to accounting categories
• Step 2: Connect the Acomba export integration
• Step 3: Configure the integration
• Step 4: Generate an export file

 

Step 1: Assign ledger accounting codes to accounting categories

To ensure the exported ADX file from Mews Operations imports correctly into Acomba, you need to assign a Ledger accounting 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  > Settings > Property > Finance > Accounting categories.
2. Click the Name of an accounting category.
3. Under Ledger accounting code, enter a unique code. Acomba software requires this code during the import process.

 

4. Click Save.

 

Step 2: Connect the Acomba accounting export integration

1. In Mews Operations, go to the main menu > Marketplace.
2. Under Categories, click Accounting.
3. Locate the Acomba integration, then click Explore. Alternatively, you can search for the integration using the search box.
4. Click Connect integration.
5. A pop-up displays confirming successful connection of the integration. Click OK.

 

Step 3: Configure the integration

1. In Mews Operations, go to the main menu > Marketplace > My subscriptions.
2. Locate the Acomba integration, then click Edit to go to the settings.
3. Click Configuration at the screens’ top right corner.
4. Enter accounting information from your Acomba accounting software for the below.

• Transfer account code: Enter the transfer account code.
• Guest ledger account code: Enter the guest ledger accounting code used to balance your in-house guest ledger.
• Deposit account code: Enter the guest ledger accounting code used for pre-stay deposits.
• Account receivable account code: Enter the guest ledger 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.

 

6. Enter the Account code for each of the listed Tax account mappings found in your Acomba accounting software. Note: Your configuration may require multiple account mappings.

 

 

7. Click Save changes.
   
   

Step 4: Generate an export file

1. In Mews Operations, go to the main menu > Marketplace > My subscriptions.
2. Locate the Acomba integration, then click Edit to go to the settings.
3. Click Configuration at the screens’ top right corner.
4. 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.

 

6. Click Export data. An ADX file automatically downloads to your machine.

Note: If you select multiple dates, for example, one week, the Acomba integration generates just one ADX file containing data for all days.

 

 

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

This connects and configures the Acomba accounting export integration for Mews Operations. You can now export and import Acomba ADX files into your Acomba software.

You can learn more about creating accounting categories here.