Skip to main content
Sign in Submit a Ticket

How can we help?

Generic Financial Export File

Overview

The Generic Financial Export is available to all RMS customers and offers a range of export formats and configuration options to suit different accounting needs.

It supports both Accrual and Cash Accounting methods. However, the mapping setup and export options may vary slightly depending on the property's chosen accounting method.

✎ Please Note: Some Users may not see or have access to the functions mentioned in this article. CLICK HERE to find out more.

 

Scheduled Financial Export

The Generic Financial Export can be configured as a Scheduled Report in RMS, allowing for automated delivery at regular intervals.

When scheduling the export:

  • The Schedule Name entered is used only for identification within RMS.

  • It will not appear in the email subject line or be used as the file name of the export.

The exported file will retain the same file name format as when the report is run manually, which is:

RMSFinancialExport_{PropertyCode}_yyyyMMdd
⚠ Important: When scheduling the Generic Financial Export, the 'Export' option selected in the Schedule section will be ignored. RMS will continue to use the file format specified on the Generic Financial Export build screen.

 

Exporting for Multiple Properties

The Generic Financial Export can be run manually or scheduled to include multiple properties in a single export process.

When exporting for more than one property, RMS will generate an individual financial export file for each property. These files are then bundled into a single .zip file that can be downloaded and extracted for review.

 

Available Export Options

The Generic Financial Export is highly flexible, offering a wide range of configuration options on the build screen.

The table below provides detailed information about each available option to help you select the most appropriate settings based on your property's accounting and reporting 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

 

Was this article helpful?

We're sorry to hear this article was not helpful, please let us know why here, so we can make it better.

Thanks for the positive feedback! We'd love to hear more, let us know here.

Return to top

Related articles

Comments

0 comments

Please sign in to leave a comment.

Contact us