Revenue Export
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 8-10 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 Cloud codes that identifies the transaction | E.G.: 1000 | 
| description | Element | OPERA Cloud 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 Cloud | 
| 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>
  </transaction_total>
  <transaction_total transaction_type="REVENUE">
    <transaction_code>2000</transaction_code>
    <description>Restaurant Breakfast Food</description>
    <total_amount>934.579439252336</total_amount>
    <total_guest_ledger>1000</total_guest_ledger>
    <total_package_ledger>0</total_package_ledger>
    <total_ar_ledger>0</total_ar_ledger>
    <total_deposit_ledger>0</total_deposit_ledger>
    <transaction_details>
      <transaction>
        <market_code>BUS</market_code>
        <room_class>ALL</room_class>
        <trx_amount>280.37</trx_amount>
        <trx_guest_ledger>300.00</trx_guest_ledger>
      </transaction>
      <transaction>
        <market_code>CRP</market_code>
        <room_class>ALL</room_class>
        <trx_amount>186.92</trx_amount>
        <trx_guest_ledger>200.00</trx_guest_ledger>
      </transaction>
      <transaction>
        <market_code>CRP</market_code>
        <room_class>ALL</room_class>
        <trx_amount>186.92</trx_amount>
        <trx_guest_ledger>200.00</trx_guest_ledger>
      </transaction>
      <transaction>
        <market_code>CRP</market_code>
        <room_class>ALL</room_class>
        <trx_amount>186.92</trx_amount>
        <trx_guest_ledger>200.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_details>
  </transaction_total>
  <transaction_total transaction_type="REVENUE">
    <transaction_code>2010</transaction_code>
    <description>Restaurant Lunch Food</description>
    <total_amount>1400</total_amount>
    <total_guest_ledger>1400</total_guest_ledger>
    <total_package_ledger>0</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>300.00</trx_amount>
        <trx_guest_ledger>300.00</trx_guest_ledger>
      </transaction>
      <transaction>
        <market_code>CRP</market_code>
        <room_class>ALL</room_class>
        <trx_amount>100.00</trx_amount>
        <trx_guest_ledger>100.00</trx_guest_ledger>
      </transaction>
      <transaction>
        <market_code>WIN</market_code>
        <room_class>ALL</room_class>
        <trx_amount>300.00</trx_amount>
        <trx_guest_ledger>300.00</trx_guest_ledger>
      </transaction>
      <transaction>
        <market_code>IND</market_code>
        <room_class>ALL</room_class>
        <trx_amount>200.00</trx_amount>
        <trx_guest_ledger>200.00</trx_guest_ledger>
      </transaction>
      <transaction>
        <market_code>BUS</market_code>
        <room_class>ALL</room_class>
        <trx_amount>500.00</trx_amount>
        <trx_guest_ledger>500.00</trx_guest_ledger>
      </transaction>
    </transaction_details>
  </transaction_total>
  <transaction_total transaction_type="REVENUE">
    <transaction_code>2020</transaction_code>
    <description>Restaurant Dinner Food</description>
    <total_amount>400</total_amount>
    <total_guest_ledger>400</total_guest_ledger>
    <total_package_ledger>0</total_package_ledger>
    <total_ar_ledger>0</total_ar_ledger>
    <total_deposit_ledger>0</total_deposit_ledger>
    <transaction_details>
      <transaction>
        <market_code>BUS</market_code>
        <room_class>ALL</room_class>
        <trx_amount>200.00</trx_amount>
        <trx_guest_ledger>200.00</trx_guest_ledger>
      </transaction>
      <transaction>
        <market_code>BUS</market_code>
        <room_class>ALL</room_class>
        <trx_amount>200.00</trx_amount>
        <trx_guest_ledger>200.00</trx_guest_ledger>
      </transaction>
    </transaction_details>
  </transaction_total>
  <transaction_total transaction_type="REVENUE">
    <transaction_code>2050</transaction_code>
    <description>Room Service Breakfast Food</description>
    <total_amount>10</total_amount>
    <total_guest_ledger>0</total_guest_ledger>
    <total_package_ledger>10</total_package_ledger>
    <total_ar_ledger>0</total_ar_ledger>
    <total_deposit_ledger>0</total_deposit_ledger>
    <transaction_details>
      <transaction>
        <market_code>BUS</market_code>
        <room_class>ALL</room_class>
        <trx_amount>10.00</trx_amount>
        <trx_package_ledger>10.00</trx_package_ledger>
      </transaction>
    </transaction_details>
  </transaction_total>
  <transaction_total transaction_type="REVENUE">
    <transaction_code>2070</transaction_code>
    <description>Room Service Dinner Food</description>
    <total_amount>700</total_amount>
    <total_guest_ledger>700</total_guest_ledger>
    <total_package_ledger>0</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>200.00</trx_amount>
        <trx_guest_ledger>200.00</trx_guest_ledger>
      </transaction>
      <transaction>
        <market_code>IND</market_code>
        <room_class>ALL</room_class>
        <trx_amount>500.00</trx_amount>
        <trx_guest_ledger>500.00</trx_guest_ledger>
      </transaction>
    </transaction_details>
  </transaction_total>
  <transaction_total transaction_type="REVENUE">
    <transaction_code>2100</transaction_code>
    <description>Lobby Bar Breakfast Food</description>
    <total_amount>100</total_amount>
    <total_guest_ledger>100</total_guest_ledger>
    <total_package_ledger>0</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>100.00</trx_amount>
        <trx_guest_ledger>100.00</trx_guest_ledger>
      </transaction>
    </transaction_details>
  </transaction_total>
  <transaction_total transaction_type="REVENUE">
    <transaction_code>2110</transaction_code>
    <description>Lobby Bar Lunch Food</description>
    <total_amount>150</total_amount>
    <total_guest_ledger>150</total_guest_ledger>
    <total_package_ledger>0</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>150.00</trx_amount>
        <trx_guest_ledger>150.00</trx_guest_ledger>
      </transaction>
    </transaction_details>
  </transaction_total>
  <transaction_total transaction_type="REVENUE">
    <transaction_code>2120</transaction_code>
    <description>Lobby Bar Dinner Food</description>
    <total_amount>250</total_amount>
    <total_guest_ledger>250</total_guest_ledger>
    <total_package_ledger>0</total_package_ledger>
    <total_ar_ledger>0</total_ar_ledger>
    <total_deposit_ledger>0</total_deposit_ledger>
    <transaction_details>
      <transaction>
        <market_code>GRP</market_code>
        <room_class>ALL</room_class>
        <trx_amount>250.00</trx_amount>
        <trx_guest_ledger>250.00</trx_guest_ledger>
      </transaction>
    </transaction_details>
  </transaction_total>
  <transaction_total transaction_type="REVENUE">
    <transaction_code>2150</transaction_code>
    <description>Mini Bar Food</description>
    <total_amount>350</total_amount>
    <total_guest_ledger>350</total_guest_ledger>
    <total_package_ledger>0</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>100.00</trx_amount>
        <trx_guest_ledger>100.00</trx_guest_ledger>
      </transaction>
      <transaction>
        <market_code>CRP</market_code>
        <room_class>ALL</room_class>
        <trx_amount>200.00</trx_amount>
        <trx_guest_ledger>200.00</trx_guest_ledger>
      </transaction>
      <transaction>
        <market_code>GRP</market_code>
        <room_class>ALL</room_class>
        <trx_amount>50.00</trx_amount>
        <trx_guest_ledger>50.00</trx_guest_ledger>
      </transaction>
    </transaction_details>
  </transaction_total>
  <transaction_total transaction_type="REVENUE">
    <transaction_code>3010</transaction_code>
    <description>Restaurant Lunch Beverage</description>
    <total_amount>100</total_amount>
    <total_guest_ledger>100</total_guest_ledger>
    <total_package_ledger>0</total_package_ledger>
    <total_ar_ledger>0</total_ar_ledger>
    <total_deposit_ledger>0</total_deposit_ledger>
    <transaction_details>
      <transaction>
        <market_code>IND</market_code>
        <room_class>ALL</room_class>
        <trx_amount>100.00</trx_amount>
        <trx_guest_ledger>100.00</trx_guest_ledger>
      </transaction>
    </transaction_details>
  </transaction_total>
  <transaction_total transaction_type="REVENUE">
    <transaction_code>3020</transaction_code>
    <description>Restaurant Dinner Beverage</description>
    <total_amount>450</total_amount>
    <total_guest_ledger>450</total_guest_ledger>
    <total_package_ledger>0</total_package_ledger>
    <total_ar_ledger>0</total_ar_ledger>
    <total_deposit_ledger>0</total_deposit_ledger>
    <transaction_details>
      <transaction>
        <market_code>BUS</market_code>
        <room_class>ALL</room_class>
        <trx_amount>250.00</trx_amount>
        <trx_guest_ledger>250.00</trx_guest_ledger>
      </transaction>
      <transaction>
        <market_code>WIN</market_code>
        <room_class>ALL</room_class>
        <trx_amount>200.00</trx_amount>
        <trx_guest_ledger>200.00</trx_guest_ledger>
      </transaction>
    </transaction_details>
  </transaction_total>
  <transaction_total transaction_type="REVENUE">
    <transaction_code>3050</transaction_code>
    <description>Room Service Breakfast Beverage</description>
    <total_amount>150</total_amount>
    <total_guest_ledger>150</total_guest_ledger>
    <total_package_ledger>0</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>150.00</trx_amount>
        <trx_guest_ledger>150.00</trx_guest_ledger>
      </transaction>
    </transaction_details>
  </transaction_total>
  <transaction_total transaction_type="REVENUE">
    <transaction_code>3060</transaction_code>
    <description>Room Service Lunch Beverage</description>
    <total_amount>250</total_amount>
    <total_guest_ledger>250</total_guest_ledger>
    <total_package_ledger>0</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>250.00</trx_amount>
        <trx_guest_ledger>250.00</trx_guest_ledger>
      </transaction>
    </transaction_details>
  </transaction_total>
  <transaction_total transaction_type="REVENUE">
    <transaction_code>3070</transaction_code>
    <description>Room Service Dinner Beverage</description>
    <total_amount>350</total_amount>
    <total_guest_ledger>350</total_guest_ledger>
    <total_package_ledger>0</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>350.00</trx_amount>
        <trx_guest_ledger>350.00</trx_guest_ledger>
      </transaction>
    </transaction_details>
  </transaction_total>
  <transaction_total transaction_type="REVENUE">
    <transaction_code>3150</transaction_code>
    <description>Mini Bar Beverage</description>
    <total_amount>250</total_amount>
    <total_guest_ledger>250</total_guest_ledger>
    <total_package_ledger>0</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>150.00</trx_amount>
        <trx_guest_ledger>150.00</trx_guest_ledger>
      </transaction>
      <transaction>
        <market_code>GRP</market_code>
        <room_class>ALL</room_class>
        <trx_amount>100.00</trx_amount>
        <trx_guest_ledger>100.00</trx_guest_ledger>
      </transaction>
    </transaction_details>
  </transaction_total>
  <transaction_total transaction_type="REVENUE">
    <transaction_code>5010</transaction_code>
    <description>Fax Charges</description>
    <total_amount>25</total_amount>
    <total_guest_ledger>25</total_guest_ledger>
    <total_package_ledger>0</total_package_ledger>
    <total_ar_ledger>0</total_ar_ledger>
    <total_deposit_ledger>0</total_deposit_ledger>
    <transaction_details>
      <transaction>
        <market_code>WIN</market_code>
        <room_class>ALL</room_class>
        <trx_amount>25.00</trx_amount>
        <trx_guest_ledger>25.00</trx_guest_ledger>
      </transaction>
    </transaction_details>
  </transaction_total>
  <transaction_total transaction_type="REVENUE">
    <transaction_code>5020</transaction_code>
    <description>Internet Charges</description>
    <total_amount>80</total_amount>
    <total_guest_ledger>80</total_guest_ledger>
    <total_package_ledger>0</total_package_ledger>
    <total_ar_ledger>0</total_ar_ledger>
    <total_deposit_ledger>0</total_deposit_ledger>
    <transaction_details>
      <transaction>
        <market_code>WIN</market_code>
        <room_class>ALL</room_class>
        <trx_amount>20.00</trx_amount>
        <trx_guest_ledger>20.00</trx_guest_ledger>
      </transaction>
      <transaction>
        <market_code>CRP</market_code>
        <room_class>ALL</room_class>
        <trx_amount>40.00</trx_amount>
        <trx_guest_ledger>40.00</trx_guest_ledger>
      </transaction>
      <transaction>
        <market_code>GRP</market_code>
        <room_class>ALL</room_class>
        <trx_amount>20.00</trx_amount>
        <trx_guest_ledger>20.00</trx_guest_ledger>
      </transaction>
    </transaction_details>
  </transaction_total>
  <transaction_total transaction_type="NON REVENUE">
    <transaction_code>8000</transaction_code>
    <description>7% Tax (Tax 1)</description>
    <total_amount>199.382242990652</total_amount>
    <total_guest_ledger>7.7</total_guest_ledger>
    <total_package_ledger>0</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>11.78</trx_amount>
      </transaction>
      <transaction>
        <market_code>BUS</market_code>
        <room_class>ALL</room_class>
        <trx_amount>19.63</trx_amount>
      </transaction>
      <transaction>
        <market_code>CRP</market_code>
        <room_class>ALL</room_class>
        <trx_amount>13.08</trx_amount>
      </transaction>
      <transaction>
        <market_code>CRP</market_code>
        <room_class>ALL</room_class>
        <trx_amount>13.08</trx_amount>
      </transaction>
      <transaction>
        <market_code>CRP</market_code>
        <room_class>ALL</room_class>
        <trx_amount>7.70</trx_amount>
        <trx_guest_ledger>7.70</trx_guest_ledger>
      </transaction>
      <transaction>
        <market_code>CRP</market_code>
        <room_class>ALL</room_class>
        <trx_amount>13.08</trx_amount>
      </transaction>
      <transaction>
        <market_code>CRP</market_code>
        <room_class>ALL</room_class>
        <trx_amount>6.54</trx_amount>
      </transaction>
      <transaction>
        <market_code>CRP</market_code>
        <room_class>ALL</room_class>
        <trx_amount>11.78</trx_amount>
      </transaction>
      <transaction>
        <market_code>CRP</market_code>
        <room_class>ALL</room_class>
        <trx_amount>6.54</trx_amount>
      </transaction>
      <transaction>
        <market_code>CRP</market_code>
        <room_class>ALL</room_class>
        <trx_amount>14.39</trx_amount>
      </transaction>
      <transaction>
        <market_code>BUS</market_code>
        <room_class>ALL</room_class>
        <trx_amount>11.12</trx_amount>
      </transaction>
      <transaction>
        <market_code>CRP</market_code>
        <room_class>ALL</room_class>
        <trx_amount>6.54</trx_amount>
      </transaction>
      <transaction>
        <market_code>BUS</market_code>
        <room_class>ALL</room_class>
        <trx_amount>14.39</trx_amount>
      </transaction>
      <transaction>
        <market_code>BUS</market_code>
        <room_class>ALL</room_class>
        <trx_amount>11.78</trx_amount>
      </transaction>
      <transaction>
        <market_code>WIN</market_code>
        <room_class>ALL</room_class>
        <trx_amount>11.78</trx_amount>
      </transaction>
      <transaction>
        <market_code>IND</market_code>
        <room_class>ALL</room_class>
        <trx_amount>11.78</trx_amount>
      </transaction>
      <transaction>
        <market_code>GRP</market_code>
        <room_class>ALL</room_class>
        <trx_amount>14.39</trx_amount>
      </transaction>
    </transaction_details>
  </transaction_total>
  <transaction_total transaction_type="PAYMENT">
    <transaction_code>9000</transaction_code>
    <description>Cash</description>
    <total_amount>-5662.7</total_amount>
    <total_guest_ledger>-5362.7</total_guest_ledger>
    <total_package_ledger>0</total_package_ledger>
    <total_ar_ledger>0</total_ar_ledger>
    <total_deposit_ledger>-300</total_deposit_ledger>
    <transaction_details>
      <transaction>
        <market_code>CRP</market_code>
        <room_class>ALL</room_class>
        <trx_amount>-180.00</trx_amount>
        <trx_guest_ledger>-180.00</trx_guest_ledger>
      </transaction>
      <transaction>
        <market_code>IND</market_code>
        <room_class>ALL</room_class>
        <trx_amount>-500.00</trx_amount>
        <trx_guest_ledger>-500.00</trx_guest_ledger>
      </transaction>
      <transaction>
        <market_code>GRP</market_code>
        <room_class>ALL</room_class>
        <trx_amount>-300.00</trx_amount>
        <trx_guest_ledger>-300.00</trx_guest_ledger>
      </transaction>
      <transaction>
        <market_code>CRP</market_code>
        <room_class>ALL</room_class>
        <trx_amount>-850.00</trx_amount>
        <trx_guest_ledger>-850.00</trx_guest_ledger>
      </transaction>
      <transaction>
        <market_code>CRP</market_code>
        <room_class>ALL</room_class>
        <trx_amount>-710.00</trx_amount>
        <trx_guest_ledger>-710.00</trx_guest_ledger>
      </transaction>
      <transaction>
        <market_code>CRP</market_code>
        <room_class>ALL</room_class>
        <trx_amount>-417.70</trx_amount>
        <trx_guest_ledger>-417.70</trx_guest_ledger>
      </transaction>
      <transaction>
        <market_code>CRP</market_code>
        <room_class>ALL</room_class>
        <trx_amount>-280.00</trx_amount>
        <trx_guest_ledger>-280.00</trx_guest_ledger>
      </transaction>
      <transaction>
        <market_code>BUS</market_code>
        <room_class>ALL</room_class>
        <trx_amount>-200.00</trx_amount>
        <trx_deposit_ledger>-200.00</trx_deposit_ledger>
      </transaction>
      <transaction>
        <market_code>BUS</market_code>
        <room_class>ALL</room_class>
        <trx_amount>-480.00</trx_amount>
        <trx_guest_ledger>-480.00</trx_guest_ledger>
      </transaction>
      <transaction>
        <market_code>BUS</market_code>
        <room_class>ALL</room_class>
        <trx_amount>-220.00</trx_amount>
        <trx_guest_ledger>-220.00</trx_guest_ledger>
      </transaction>
      <transaction>
        <market_code>WIN</market_code>
        <room_class>ALL</room_class>
        <trx_amount>-345.00</trx_amount>
        <trx_guest_ledger>-345.00</trx_guest_ledger>
      </transaction>
      <transaction>
        <market_code>CRP</market_code>
        <room_class>ALL</room_class>
        <trx_amount>-700.00</trx_amount>
        <trx_guest_ledger>-700.00</trx_guest_ledger>
      </transaction>
      <transaction>
        <market_code>CRP</market_code>
        <room_class>ALL</room_class>
        <trx_amount>-100.00</trx_amount>
        <trx_deposit_ledger>-100.00</trx_deposit_ledger>
      </transaction>
      <transaction>
        <market_code>BUS</market_code>
        <room_class>ALL</room_class>
        <trx_amount>-200.00</trx_amount>
        <trx_guest_ledger>-200.00</trx_guest_ledger>
      </transaction>
      <transaction>
        <market_code>BUS</market_code>
        <room_class>ALL</room_class>
        <trx_amount>-180.00</trx_amount>
        <trx_guest_ledger>-180.00</trx_guest_ledger>
      </transaction>
    </transaction_details>
  </transaction_total>
  <transaction_total transaction_type="PAYMENT">
    <transaction_code>9080</transaction_code>
    <description>Direct Bill</description>
    <total_amount>-1200</total_amount>
    <total_guest_ledger>-1200</total_guest_ledger>
    <total_package_ledger>0</total_package_ledger>
    <total_ar_ledger>1200</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>-450.00</trx_amount>
        <trx_guest_ledger>-450.00</trx_guest_ledger>
        <trx_ar_ledger>450.00</trx_ar_ledger>
      </transaction>
      <transaction>
        <market_code>BUS</market_code>
        <room_class>ALL</room_class>
        <trx_amount>-750.00</trx_amount>
        <trx_guest_ledger>-750.00</trx_guest_ledger>
        <trx_ar_ledger>750.00</trx_ar_ledger>
      </transaction>
    </transaction_details>
  </transaction_total>
  <transaction_total transaction_type="INTERNAL">
    <transaction_code>9150</transaction_code>
    <description>Deposit Transfer</description>
    <total_amount>0</total_amount>
    <total_guest_ledger>-300</total_guest_ledger>
    <total_package_ledger>0</total_package_ledger>
    <total_ar_ledger>0</total_ar_ledger>
    <total_deposit_ledger>300</total_deposit_ledger>
  </transaction_total>
  <transaction_total transaction_type="PACKAGE">
    <transaction_code>9300</transaction_code>
    <description>Packages (Wrapper)</description>
    <total_amount>0</total_amount>
    <total_guest_ledger>180</total_guest_ledger>
    <total_package_ledger>-180</total_package_ledger>
    <total_ar_ledger>0</total_ar_ledger>
    <total_deposit_ledger>0</total_deposit_ledger>
  </transaction_total>
</revenue> <?xml version="1.0" encoding="UTF-8"?> <?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>
</transaction_total>
      </revenue>