Overview
The Generic Financial Export is available to all customers using RMS and includes a number of export and configuration options that can be utilised.
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.
Scheduled Financial Export
The Generic Financial Export can be setup as a Scheduled Report in RMS.
When scheduled, the Schedule Name entered will not appear in the Email Subject Line or as the File Name of the export and will only be used to identify the schedule in RMS.
The Scheduled Generic Financial Export will maintain the same file name format as it does when manually run, which is
RMSFinancialExport_{PropertyCode}_yyyyMMdd
When scheduling the Generic Financial Export, the 'Export' option selected in the Schedule section will be ignored and RMS will continue to use the file format selected on the build screen for the Generic Financial Export.
Exporting for Multiple Properties
The Generic Financial Export can be exported manually or on a schedule for multiple properties at a time.
When exporting for multiple properties, RMS will bundle a financial export file for each property into a single .zip file that can be extracted once downloaded.
Available Export Options
Due to the flexibility of design in the Generic Financial Export there are a large number of options available for selection on the build screen.
The following table will provide additional information on each option to assist with selecting the right options for the property's requirements.
Accounting Method |
Export Option |
Information |
Accrual |
Include Charges |
- Selected by default this will include charge transaction totals with a new row per General Ledger Account Code for the date selected.
- These totals are comparable with the Management > Charge Report.
- The exported information for this option varies depending on the selected Accounting Method.
|
Cash |
Include Charges |
- Selected by default this will include the charge transactions with a new row per General Ledger Account Code for the date selected where values will equal receipt amounts that were allocated on that date.
- These totals are comparable with the Management > Cash Report.
- The exported information for this option varies depending on the selected Accounting Method.
|
Accrual |
Include Ledger Movements |
- Selected by default this will include a new row per Ledger Movement GL Account Code mapped in Setup > Accounting > Financial Interface.
- These totals should be comparable to the Ledger Movements on the Night Audit Report for the same date if General Ledger Account Codes are mapped individually.
- This options is available specifically for the Accrual Accounting method.
|
Cash |
Include Suspense Receipt Record (Control Account)
|
- Selected by default this will include a new row with the mapped Control Account General Ledger Account Code & Description.
- This row will display the total value of Suspense Receipts for the date selected.
- This option is available specifically for the Cash Accounting method.
|
Accrual & Cash |
Include Gross Revenue |
- Selected by default this will include the column for Gross Revenue in the exported file per row item.
- Gross Revenue is Total Charges prior to the application or deduction of any taxes.
|
Accrual & Cash |
Include Nett Revenue |
- Will include a new column for Nett Revenue in the exported file per row item.
- Nett Revenue is Total Charges less any taxes.
|
Accrual & Cash |
Split Revenue into Debit and Credit |
- Will separate selected Gross and/or Nett Revenue columns into a Debit and Credit column for each.
|
Accrual & Cash |
Include Inclusive Tax Column |
- Values will only be included where the property has Inclusive Taxes setup.
- Will include a new column with the values of the Inclusive Taxes per row item.
- Column header displays as 'Tax' label setup.
|
Accrual & Cash |
Include Inclusive Tax Record (GST Collected)
|
- Will include a new row with the sum of tax for all charges on the selected date.
|
Accrual & Cash |
Include Property Code Column |
- Adds a new column with the Property Code included in each row item.
|
Accrual & Cash |
Include Property Name Column |
- Adds a new column with the Property Name included in each row item.
|
Accrual & Cash |
Include Statistic Records |
- Adds new rows per Statistics item setup in Setup > Accounting > Financial Interface.
- Includes no financial figures.
|
Accrual & Cash |
Include Batch No. Column |
- Adds a new column to the export file with a unique Batch Number included in each row item.
- Will add the prefix entered on the build screen.
- Follows format of: {Prefix Entered}yyyyMMdd.
|
Accrual & Cash |
Include Interface Code/Description # |
- Adds a new column for each selected Additional Financial Interface Code that has been setup in Setup > Accounting > Financial Interface.
- Applies the code setup to each row item.
|
Accrual & Cash |
Include Market Segment Statistics |
- Operational Revenue
- Adds a new row per Market Segment attached to reservations for the date selected.
- Requires additional setup in T-Codes for Nights & Gross Revenue to be included.
|