A guide to generating the Generic Financial Export in RMS.
Overview
The Generic Financial Export is an export of all General Ledger Account Codes and Financial Revenue for the selected date range.
The Generic Financial Export is available to all customers using RMS and includes a number of export and configuration options that can be utilized.
Both Accrual and Cash Accounting properties can use the Generic Financial Export, although mapping and selected export options will vary slightly depending on the Accounting Method of the property.
General Ledger Account Codes in RMS should match the accounting software used.
Descriptions entered will be used in the generated export and should be entered as required by the accounting software used.
Mapping where the Code and Description are identical on multiple entries will be consolidated into a single line.
Report Build Options
The Report Build screen for the Generic Financial Export is split into two panels. The Report Options panel controls the file format and the main content of the export. The More Options panel (toggled via the More Options / Less Options button) contains additional inclusions for Interface Codes, T-Codes, Market Segment Statistics, and file-combining behaviour.
Report Options
| Option | Description |
|---|---|
| Date | The date or date range to include in the export. |
| File Delimitation | The character used to separate fields in the exported file. Options: Comma Delimited (CSV), Tab Delimited (TSV), Pipe Delimited (TXT). |
| Line Endings | The line-ending format used in the exported file. Options: Windows, Linux. |
| Include Column Headers | Adds a header row to the exported file with the name of each column. |
| Accrual Accounting / Cash Accounting | Selects whether the export uses Accrual or Cash Accounting. Mapping and the available export options will vary based on the selected Accounting Method. |
| Include Inactive Category | Includes inactive Categories in the export. |
| Include Charges | Includes charge transactions in the export. |
| Include Receipts | Includes receipt transactions in the export. |
| Include Ledger Movements | Includes ledger movement entries in the export. |
| Include Gross Revenue Column | Adds a Gross Revenue column to the export. |
| Include Nett Revenue Column | Adds a Nett Revenue column to the export. |
| Split Revenue Into Debit And Credit | Splits revenue values across separate debit and credit columns. |
| Include Inclusive Tax Column | Adds an inclusive tax column to the export. |
| Include Inclusive Tax Record (Tax Collected) | Adds an inclusive tax record (Tax Collected) to the export. |
| Include Property Code Column | Adds a Property Code column to the export. |
| Include Property Name Column | Adds a Property Name column to the export. |
| Include Row Count Column | Adds a Row Count column to the export. |
| Include Statistics Records | Includes statistics records in the export. |
| Include Batch No Column (PrefixYYYYMMDD) | Adds a Batch Number column to the export, formatted as the configured prefix followed by the date (YYYYMMDD). |
| Prefix | The prefix applied to the Batch Number column when Include Batch No Column is selected. |
More Options Section
Include Interface Codes and Descriptions
Up to four sets of Additional Interface Codes can be included in the export.
| Option | Description |
|---|---|
| Interface Code 1 to Interface Code 4 | Adds the corresponding Interface Code column to the export. |
| Interface Description 1 to Interface Description 4 | Adds the corresponding Interface Description column to the export. |
Include T-Codes
| Option | Description |
|---|---|
| T-Code T0 to T-Code T9 | Includes the corresponding T-Code (T0 through T9) in the export. |
Other More Options
| Option | Description |
|---|---|
| Include Market Segment Statistics (Operational Revenue) | Includes Market Segment Statistics for Operational Revenue in the export. |
| Combine Multiple Properties in Single File | Outputs a single combined file when exporting for multiple properties, instead of bundling a separate file per property into a .zip. |
| Combine Multiple Dates in Single File | Outputs a single combined file when exporting for multiple dates, instead of bundling a separate file per day into a .zip. |
Guide
In the side menu of RMS, go to Utilities > Generic Financial Export.
- Select the Date Range.
- Select the File Delimitation required.
- Select the Accounting Method.
(Optional) All other selections are optional. - Select 'Export File'.
Example Export File
Comments
0 comments
Please sign in to leave a comment.