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 (DEBIT – CREDIT columns).

Table 7-6 City Ledger Export

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

Generated export for Generic XML Back Office - City Ledger

<?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>