Sage Intacct is a cloud-based accounting and financial management platform that seamlessly integrates with RMS.

Overview

Sage Intacct is a cloud-based accounting and financial management platform that can be integrated with RMS to streamline financial reporting and data flow between systems.

This financial interface is available for both Cash and Accrual Accounting properties and includes comprehensive General Ledger Account Code (GL Acc Code) mapping, allowing Receipts and Ledger Movements in RMS to be accurately allocated within Sage Intacct’s general ledger.

What Are General Ledger Account Codes?

General Ledger Account Codes are unique identifiers assigned to accounts within a financial system’s chart of accounts. These codes are used to organize, track, and report financial transactions.

To ensure accurate financial reporting, it is recommended that GL Acc Codes in RMS match those used in your financial system. These mappings determine how Financial & Operational Revenue is categorized and reported for all transactions.

A GL Acc Code is mandatory when setting up:

• Categories

• Sundry Charges

• Exclusive Taxes

• Late Fees

It is optional but available for:

• Areas

• Rate Types

• Discounts

The financial system in use will dictate the format and structure of the GL codes and the breakdown of the chart of accounts.

Consolidating Transactions

You can map multiple line items in RMS to the same GL Acc Code to consolidate related transactions into a single record within Sage Intacct’s general journal - simplifying reconciliation and reporting.

Guide

In the side menu of RMS, go to Setup > Accounting > Financial Interface.

1. Navigate to the Mapping tab.
   

Accrual Accounting

1. Enter the GL Acc Codes and Descriptions in the Advances Ledger section.
   
    
2. Enter the GL Acc Codes and Descriptions in the Guest Ledger section.
   
    
3. Enter the GL Acc Codes and Descriptions in the City Ledger section.
   
    
4. Tax Inclusive: Enter the GL Acc Code and Description in the Tax section.
   
    

Cash Accounting

1. Enter the GL Acc Code and Description in the Control Account section.
   
    
2. Tax Inclusive: In the Tax section, enter the GL Acc Code and Description.
   
    
3. Navigate to the Receipts tab.
4. Enter the GL Acc Codes and Descriptions for each Receipt Type, then click Save.
   
    
5. Navigate to the Credit Cards tab.
6. Enter the GL Acc Codes and Descriptions for each Card Type.
   
    
7. Navigate to the Additional Interface Codes tab.
8. Enter the Location ID and Description as Code 1.
9. Enter the Journal Reference and Description for Revenue under Code 2.
   (Optional) Enter the Journal Reference for Statistics and Description as Code 3.
   (Optional) Enter the Code and Description for Additional Interface 5.
   (Optional) Enter the Code and Description for Additional Interface 6.
   (Optional) Navigate to the 'Statistics' tab, enter the GL Account Codes and their corresponding Descriptions.
   (Completing this step will include statistics in the journal export).
10. Select Save.
    
     

Optional Setup

Export via API

To complete this step you must log into Intacct and complete the Intacct 'Add Web Services Authorisations' Setup for 'RMSMPP'.

In the side menu of RMS, go to Setup > Accounting > Financial Interface.

1. Navigate to the Interface Credentials tab.
2. Enter the Company ID.
3. Enter the Intacct Username.
4. Enter the Intacct Password.
5. Select Save/Exit.
   
    

Department IDs and General Ledger Classifications

In the side menu of RMS, go to Setup > Lookup Tables > T-Codes.

1. Select G/L Acc Code.
2. Enter the Department ID for each GL Acc Code in T0.
   T1 shows the 'Tax Detail ID'.
3. Select Save/Exit.
   

Financial Export

Financial exports can now be generated in the required Intacct format or delivered via API, if configured.

In the side menu of RMS, go to Utilities > Financial Interface.