The Revenue File contains one record per transaction code with the total of the transaction code for the day, as well as a transaction level detail of each posting generated for that transaction code, this is in case the property wants to have Market Code and/or Room Class information as a breakdown of the revenue instead of just one single total per transaction.
You may choose to work on a transaction summary basis (columns stating with “TOTAL_” or if you wish to obtain Market Code and/or Room Class breakdown, you can use the transaction level amounts (columns starting with “TRX_”).
The sum of the TOTAL_AMOUNT and TRX_AMOUNT columns matches the “Transaction Total Today” line of the Trial Balance. All LEDGER (GUEST, AR, DEPOSIT, PACKAGE) columns match the corresponding Ledger of the Trial Balance (Today Balance – Yesterday Balance)
Table 7-5 Revenue Export
| Element Name | Element Type | Description | Notes |
|---|---|---|---|
|
revenue |
Complex Element |
Root element |
NA |
|
hotel_code |
Attribute |
Identifies the property exporting data |
Only one property is exported per file |
|
date |
Attribute |
Identifies the date of the export |
Only one day is exported per file |
|
transaction_total |
Complex Element |
Repeats for each distinct transaction code |
NA |
|
transaction_type |
Attribute |
Identifies the type of transaction: revenue, non revenue, payment, paid out, package (wrapper transactions that used to post to guest account but don't affect the revenue/non revenue figures) |
NA |
|
transaction_code |
Element |
Opera codes that identifies the transaction |
E.G.: 1000 |
|
description |
Element |
Opera description of the transaction |
E.G.: Room revenue |
|
total_amount |
Element |
Sum of the transaction for the date exported |
Same amount that you see in trial balance for that transaction |
|
total_guest_ledger |
Element |
Sum of the transaction for the date exported affecting the guest ledger |
NA |
|
total_package_ledger |
Element |
Sum of the transaction for the date exported affecting the package ledger (ultimately part of the guest ledger) |
NA |
|
total_ar_ledger |
Element |
Sum of the transaction for the date exported affecting the accounts receivable ledger |
NA |
|
total_deposit_ledger |
Element |
Sum of the transaction for the date exported affecting the deposit ledger |
NA |
|
transaction_details |
Complex Element |
List of transactions that make up the sum |
NA |
|
transaction |
Complex Element |
|
NA |
|
market_code |
Element |
Market code associated with the transaction |
NA |
|
room_class |
Element |
Room class (a grouping of type of room) associated with the transaction |
Dependent on having the room class function active in opera |
|
trx_amount |
Element |
Amount of the transaction |
For revenue transactions this is net amount (without tax) |
|
trx_guest_ledger |
Element |
Amount of the transaction affecting the guest ledger |
Transactions posted to a guest folio |
|
trx_package_ledger |
Element |
Amount of the transaction affecting the package ledger |
Wrapper transaction posted to a guest folio, offsetted by internal revenue/non revenue transactions that make the package rate |
|
trx_ar_ledger |
Element |
Amount of the transaction affecting the accounts receivable ledger |
Direct bill/city ledger transaction used to settle guest folios or any movement in the ar ledger (eg: payments received). Also credit card transactions if configured with an ar account |
|
trx_deposit_ledger |
Element |
Amount of the transaction affecting the deposit ledger |
Payments taken on reservations prior to check in. Also deposit transfer at checkin lowers the ledger upon guest check in |
<?xml version="1.0" encoding="UTF-8"?>
<revenue hotel_code="DEMOHOTEL" date="2017-02-23">
<transaction_total transaction_type="REVENUE">
<transaction_code>1000</transaction_code>
<description>Room Revenue</description>
<total_amount>1913.738317757012</total_amount>
<total_guest_ledger>1870</total_guest_ledger>
<total_package_ledger>170</total_package_ledger>
<total_ar_ledger>0</total_ar_ledger>
<total_deposit_ledger>0</total_deposit_ledger>
<transaction_details>
<transaction>
<market_code>CRP</market_code>
<room_class>ALL</room_class>
<trx_amount>168.22</trx_amount>
<trx_guest_ledger>180.00</trx_guest_ledger>
</transaction>
<transaction>
<market_code>CRP</market_code>
<room_class>ALL</room_class>
<trx_amount>110.00</trx_amount>
<trx_guest_ledger>110.00</trx_guest_ledger>
</transaction>
<transaction>
<market_code>CRP</market_code>
<room_class>ALL</room_class>
<trx_amount>93.46</trx_amount>
<trx_guest_ledger>100.00</trx_guest_ledger>
</transaction>
<transaction>
<market_code>CRP</market_code>
<room_class>ALL</room_class>
<trx_amount>168.22</trx_amount>
<trx_guest_ledger>180.00</trx_guest_ledger>
</transaction>
<transaction>
<market_code>CRP</market_code>
<room_class>ALL</room_class>
<trx_amount>93.46</trx_amount>
<trx_guest_ledger>100.00</trx_guest_ledger>
</transaction>
<transaction>
<market_code>CRP</market_code>
<room_class>ALL</room_class>
<trx_amount>205.61</trx_amount>
<trx_guest_ledger>220.00</trx_guest_ledger>
</transaction>
<transaction>
<market_code>BUS</market_code>
<room_class>ALL</room_class>
<trx_amount>158.88</trx_amount>
<trx_package_ledger>170.00</trx_package_ledger>
</transaction>
<transaction>
<market_code>BUS</market_code>
<room_class>ALL</room_class>
<trx_amount>205.61</trx_amount>
<trx_guest_ledger>220.00</trx_guest_ledger>
</transaction>
<transaction>
<market_code>BUS</market_code>
<room_class>ALL</room_class>
<trx_amount>168.22</trx_amount>
<trx_guest_ledger>180.00</trx_guest_ledger>
</transaction>
<transaction>
<market_code>WIN</market_code>
<room_class>ALL</room_class>
<trx_amount>168.22</trx_amount>
<trx_guest_ledger>180.00</trx_guest_ledger>
</transaction>
<transaction>
<market_code>IND</market_code>
<room_class>ALL</room_class>
<trx_amount>168.22</trx_amount>
<trx_guest_ledger>180.00</trx_guest_ledger>
</transaction>
<transaction>
<market_code>GRP</market_code>
<room_class>ALL</room_class>
<trx_amount>205.61</trx_amount>
<trx_guest_ledger>220.00</trx_guest_ledger>
</transaction>
</transaction_details>
</revenue>Parent topic: Generic XML Back Office Export-Specifications