Overview

A General Ledger Account Code is a unique identifier assigned to each account within the financial system's chart of accounts. The General Ledger Account Code import offers a streamlined method for transferring all accounting codes into RMS. This article provides details on the requirements for the General Ledger Account Codes Import in RMS.

Import Overview

• The import file must be in a comma-delimited .csv format (Field Delimiter).
• If a data field within this file contains commas, it should be surrounded with "double quotes" (Text Delimiter).
• Microsoft Excel is able to save using a .csv format that should match these requirements.
• RMS is able to determine whether the first record is a header record.

Import File Field Order

Import Validation

To ensure that your data is clean, consistent, and ready for the Live production environment after it has been validated and imported into the Training environment, follow these steps:

1. Navigate to Setup > Accounting > GL Acc Codes for data review.
2. Highlight a General Ledger Account Code and select the 'Edit' icon.

1. Review the General Ledger Account Code.
2. Confirm the Description.
3. Review the Grouping.
4. Verify the 'Include in Accommodation Revenue for Reporting' selection.

Downloadable Import File

The attached import file below contains the required file format for the general ledger account code import. Download the file and review the column headers. Populate the file with the data, ensuring that each field corresponds to the appropriate column.

Next Article: Data Validation & Trial Imports