Back Office Exports

The Back Office export feature helps you meet your hotel’s data export needs and avoid redundant data entry by providing functions for Accounts Payable, Daily Report, Fixed Assets, Payroll, General Ledger, and Financial Statements. All functions integrate directly to the General Ledger System.

The Back Office export type provides a method of exporting OPERA revenues and statistical figures to a third-party, non-OPERA system. The Back Office interface functionality extracts data from certain OPERA databases and creates ASCII files that can in turn be read by the non-OPERA system.

The Back Office interface can export data for different types of information, such as Revenue Data, City Ledger Checkout Information, Market Segment Statistics, or Daily Hotel statistics. The layout of each ASCII file is user-definable and enables you to select the information types to be transferred to the external system in the required format. You can also define whether the interface program appends records to the ASCII file each day or overwrites/creates a new file with each new export of data.

Back Office Export Workflow

The Back Office export workflow consists of the following steps:
  1. During installation, you assign account numbers from your chart of accounts to every OPERA transaction code.

  2. OPERA posts transaction codes to reservations, folios, groups, companies, travel agents, wholesalers, and so on.

  3. During the End of Day Sequence, OPERA moves transactions into their ledger components, producing daily balanced ledger entries.

  4. With an OPERA-compatible Back Office system, the balanced daily journal entries are exported to a network transfer file. Your Back Office system then imports the transfer file as a journal entry.

  5. Ledger history is stored in OPERA. You can inquire on any ledger account for any past day and view all transactions.

Back Office Features

The Back Office system includes the following features:
  • Revenue Transfer ‒ All room, food and beverage, and package component revenues posted during night audit processing is transferred into the back office accounting system and into guest history files.

  • Market Statistics Transfer ‒ Repeat guest history data is a valuable resource for the sales and marketing department. Data fields such as last date here (from - to), market/group code, postal codes, market IDs, plan codes, room types, special requests, source of business, promotions codes, location codes, VIPs, and user-defined field data provide a wealth of information that helps your marketing department improve guest return rates. This data extraction is also designed for market analysis to see where your business is coming from.

  • Daily Statistics Transfer ‒ General Ledger and Statistic Ledger analysis information. Transactions are captured for revenues, miscellaneous expenses (which can be processed through Paid-Outs), sub-ledgers’ activity and balances, (Guest, Advance Deposits and Accounts Receivable), payments (cash, credit cards, script, and gift certificates), travel agent commissions activity (commissions payable, commission expense, pre-deducted commissions, and checks written).

  • City Ledger Transfer ‒ Accounts receivable (A/R) invoice charges and payment entries, adjustments and void payments transactions, partial payments transactions, direct bill aging information, and company statements transactions.