City Ledger Export

The City Ledger File contains one record per invoice or payment generated on the day affecting Accounts Receivable. Includes Credit Card Transfers (credit card payments configured to be sent to AR).

Amounts can be grouped by ACCOUNT_NO. Bill number and Reservation information are included to ease charge recognition. The sum of the AMOUNT column will match the AR Ledger Report in OPERA Cloud(DEBIT – CREDIT columns).

Table 8-10 City Ledger Export

Element Name	Element Type	Description	Notes
city_ledger	Complex Element	Root element
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_type	Attribute	Type of transaction code
trx_code	Attribute	Transaction code against which this transaction is posted.
bill_no	Element	Bill_no associated with reservation
invoice_no	Element	Invoice number of the reservation .
amount	Element	Amount of the bill
customer_internal_id	Attribute	Internal id for the payee profile
account_name	Element	City_ledger account name
account_number	Element	City_ledger account number
confirmation_no	Element	Confirmation number of the reservation .
arrival_date	Element	Arrival date of the guest
departure_date	Element	Departure date of the guest
guest_name	Element	Name of the guest
credit_card_last_4_digits	Element	Last four digit of the credit card
transaction_type	Element	Type of transaction code
trx_code	Element	Transaction code against which this transaction is posted.
bill_no	Element	Bill_no associated with reservation
invoice_no	Element	Invoice number of the reservation .
amount	Element	Amount of the bill
credit_card_last_4_digits	Element	Last four digit of the credit card
account_info	Complex Element	Account Info
customer_internal_id	Attribute	Internal id for the payee profile
account_name	Element	City_ledger account name
account_number	Element	City_ledger account number
reservation_info	Complex Element	Reservation Info
confirmation_no	Element	Confirmation number of the reservation .
arrival_date	Element	Arrival date of the guest
departure_date	Element	Departure date of the guest
guest_name	Element	Name of the guest

Generated export for Generic XML Back Office - City Ledger

<?xml version="1.0" encoding="UTF-8"?> <?xml version <?xml version="1.0" encoding="UTF-8"?>
<city_ledger hotel_code="DEMOHOTEL" date="2017-02-23">
  <transaction trx_code="9080" transaction_type="INVOICE">
    <bill_no>66</bill_no>
    <invoice_no>44</invoice_no>
    <amount>450.00</amount>
    <account_info customer_internal_id="947959">
      <account_name>Demo Company</account_name>
      <account_number>DEMO00001</account_number>
    </account_info>
    <reservation_info>
      <confirmation_no>1086003</confirmation_no>
      <arrival_date>2017-02-23</arrival_date>
      <departure_date>2017-02-23</departure_date>
      <guest_name>Name, Guest</guest_name>
    </reservation_info>
  </transaction>
  <transaction trx_code="9080" transaction_type="INVOICE">
    <bill_no>68</bill_no>
    <invoice_no>45</invoice_no>
    <amount>750.00</amount>
    <account_info customer_internal_id="947975">
      <account_name>Demo Hospitality</account_name>
      <account_number>DEMO0002</account_number>
    </account_info>
    <reservation_info>
      <confirmation_no>1086062</confirmation_no>
      <arrival_date>2017-02-23</arrival_date>
      <departure_date>2017-02-23</departure_date>
      <guest_name>Name, Guest</guest_name>
    </reservation_info>
  </transaction>
</city_ledger> ="1.0" encoding="UTF-8"?>
<city_ledger hotel_code="DEMOHOTEL" date="2017-02-23">
  <transaction trx_code="9080" transaction_type="INVOICE">
    <bill_no>66</bill_no>
    <invoice_no>44</invoice_no>
    <amount>450.00</amount>
    <account_info customer_internal_id="947959">
      <account_name>Demo Company</account_name>
      <account_number>DEMO00001</account_number>
    </account_info>
    <reservation_info>
      <confirmation_no>1086003</confirmation_no>
      <arrival_date>2017-02-23</arrival_date>
      <departure_date>2017-02-23</departure_date>
      <guest_name>Name, Guest</guest_name>
    </reservation_info>
  </transaction>
  <transaction trx_code="9080" transaction_type="INVOICE">
    <bill_no>68</bill_no>
    <invoice_no>45</invoice_no>
    <amount>750.00</amount>
    <account_info customer_internal_id="947975">
      <account_name>Demo Hospitality</account_name>
      <account_number>DEMO0002</account_number>
    </account_info>
    <reservation_info>
      <confirmation_no>1086062</confirmation_no>
      <arrival_date>2017-02-23</arrival_date>
      <departure_date>2017-02-23</departure_date>
      <guest_name>Name, Guest</guest_name>
    </reservation_info>
  </transaction>
</city_ledger>