All Collections
Omniboost Accounting Integrations
Connecting RoomRaccoon PMS to SAGE 50 accounting UK
Connecting RoomRaccoon PMS to SAGE 50 accounting UK

Connecting RoomRaccoon PMS to SAGE 50 Accounting UK

Vincent Verschueren avatar
Written by Vincent Verschueren
Updated over a week ago

Note: All Room Raccoon –Omniboost integrations only support a closed flow. Daily financial information for all integrations is posted in the form of a financial journal, unless otherwise specified.

1.New connection request

A new connection request is submitted by the Room Raccoon team on your behalf. To help Omniboost start preparing your profile and reach out to you, Room Raccoon will share your property name, contact details as well as the Hotel ID and API key.

2. Accounting system configuration

Before starting the onboarding processes, you must have your chart of accounts finalized in your Sage 50 environment. During the accounting mapping, you will be specifying which of your Sage 50 accounts Room Raccoon revenue and payment information must be posted to.

While changes to the mapping are supported throughout the lifetime of the integration, all clients that make the required COA changes prior to the setup ensure they have a smoother testing and go-live experience.

3. Room Raccoon configuration

The accounting mapping of your revenue and payment ledgers is done in your Room Raccoon environment. For assistance, please contact your Room Raccoon representative.

Revenue ledger mapping

Revenue mapping can be accessed from main menu on the left-hand side of your Room Raccoon profile.

  1. Click on the Property Setup icon.

2. On the next screen, click the Ledgers tab.

3. Here you will be able to see and manage the full list of all of your existing ledgers as well as add a new one via the +NEW LEDGER button in the top right corner.

All of your Room Raccoon ledgers MUST have the correct account code, VAT percentage and VAT code (if applicable) assigned before you will be able to continue with the onboarding process.

If any of this information is missing (such as the Ledger for Breakfast in screenshot below), the integration will error out when attempting to post any revenue related to that ledger.

Payment ledger mapping

To ensure the integration functions correctly, your Room Raccoon payment ledgers (example below) must be configured as well. To complete this step, please contact the Room Raccoon team to assist you.

4. Integration configuration

In addition to the revenue and payment mapping in your RR environment, the integration with Sage 50 may require additional information such as:
1. Guest ledger account code and description

2. VAT mapping (typically done to tax codes but not per each ledger but for overall VAT level)

3. Fallback account codes (Revenue and payment)

4. End of day: when the automated schedule should run

The Omniboost team will provide you with a list during your onboarding.

5. Accounting system authentication

The integration with Sage 50 is an export-type connection. This means that the integration will generate import files in the exact Sage 50 format required for you to upload it. No authentication is required for this connection.

6. Testing

As outlined in step 5, Sage 50 is an export-type connection. During the testing, a test import file will be sent directly to your email. You will upload the file into your accounting software and review the journal and reconcile it as outlined below.

7. Reconciliation

You will be reconciling your Sage 50 journals with your Room Raccoon financial report. To access this report, please click on the Reports icon on your RR main menu. On the following screen, click on the Finance tab at the top.

Here you will be able to see a full breakdown of your revenue generated for each one of your ledgers, totals as well as VAT information. The report displays monthly totals. To see a daily breakdown, please download the report.

8. Historical data fetch

After you've reviewed the test information and confirmed you've mapped everything correctly, the next step will be to start importing any historical data into your Sage 50 environment.

If you have historical data in your Room Raccoon environment that has not been transferred to Sage 50, you can request the Omniboost team generate the files for this period.

9. Go-live/automation

The final step in the onboarding is to set the integration live by automating the transfer of the financial data. You will be asked to confirm at which time should the integration run each day.

We always recommend that you consider your daily operations when deciding. Keep in mind the latest possible time for you to close the figures of the previous day and how much additional time your team may need for any modifications. Any correction after the data has been posted will not be picked up by the connection and you will have a difficult time reconciling.

10. Omniboost support

The Omniboost support team will be there to assist you throughout the lifetime of your integration. For any issues that you experience or any changes that you need to make, please reach out to us via support@omniboost.io.

Did this answer your question?