Charge Import

Overview

This file allows the import of charge transactions from a standard Comma Delimited file into the RMS system. Other types of financial transactions can also be imported separately using the following file definitions:

• Receipt Import
• Credit Note Import

You must be able to provide a CSV file in the format as indicated below. It may be necessary to seek technical advice in order to create your file in the format that RMS requires.

Sample File - Pending

Important Information

• Transactions can only be imported after Reservations have been imported or created in RMS.
• The file to be imported must be in a comma delimited CSV format (Field Delimiter).
• If a data field within this file contain 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 or not, thus it is not necessary to strip the header record (field names) prior to the import
• Guest Accounts cannot be imported for RMSCentral databases.
• All Date fields must be supplied in DD-MMM-YYYY format.
• Sundry Charges must be being imported or already exist in RMS.
• Transactions will show as being created by the user 'System Import'.