BookingCenter is an ODBC-compliant database system that offers a complete range of built-in Reports. Literally hundreds of reports can be run, saved to file (for importing or using into another application), printed, emailed, or faxed. We have provided example below of some of the most commonly-used management reports - they are hyper-linked in blue below. Among the reports found in BookingCenter:

If additional reports are needed for a business, BookingCenter can provide customized reports or you can use one of the two solutions described below.

Occupancy can be viewed daily, weekly, monthly, or by Room or Room Types, as shown below:

BookingCenter mixes the Room occupancy, Guest Occupancy and ADR on a single report, providing all the data a business manager needs on a single Occupancy report. The ADR is created by taking booking costs that fall across the beginning or end of the accounting dates and splitting it pro rata. Where the booking encompasses more than one season - and the change in seasonal price is extreme, as with Christmas/New Year - this strategy can create a variance in ADR reporting, as the word average daily rate implies. An example looks like:

The Financial Reports issued by BookingCenter are split into two main sections: Revenue and Financial, with the ability to sort and subtotal the reports by a variety of metrics.

Financial reports show the financial details that an accountant needs to view to issue P & L, Balance Sheet totals, and recognize receivables. An example:

All BookingCenter Pro customer can opt to enable an internal Report Writer called the AdHoc Report Generator. For users who understand SQL databases and how to write reports, the Ad Hoc generator will allow you to query the BookingCenter database and save reports on the Mac or Windows OS that can be reused at any time. A sample of the AdHoc Report Writer can be seen here.

Keep in mind, BookingCenter Support policies DO NOT support the use of the Ad Hoc Report Writer. This is undocumented feature that any BookingCenter Pro customer can use.

Only BookingCenter Pro customers who use Windows can take advantage of third-party report-writing tools (easily). The Mac does have ODBC connection tools,especially with OS X, but BookingCenter doesn't support these at this time. If you are a Mac user, please see the Ad Hoc solution above or email us at support@bookingcenter.com and tell what product you want to use and why. There are Mac ODBC drivers available, but they cost a few hundred dollars.

Windows users need to install ODBC drivers onto your computer for the OMNIS engine used by BookingCenter to use your Report Writing tool with BookingCenter. Here's how you do it:

1. Install the ODBC drivers and follow the instructions in the read me file that comes with the download - click here to download.
   
2. Go to the ODBC 'data sources manager' on your computer (in control panels in Win 95/98/ME)
3. Choose System DSN from the tab pane.
4. Click on add
5. Choose the Omnis driver. If you get an error go back and copy the ODBC dll from step (1) into the system32, system and windows directories and do this step again.
6. Give the DSN an easy to use name and set up the other parameters
7. In the Datafile section Click on "Select" and select your BookingCenter datafile (usually called a .df1).
8. Launch BookingCenter and go to Parameters -> Utilities (password is 'precious')
9. Click on "Enable ODBC Access"
10. Connect up and report away!

**If the installation causes an ODBC error in XP, but the OMNIS ODBC does appear in the list of valid data sources when viewing datasource, then you need to copy the dll to the C:\win\system dir as well as C:\win\system32. On some computers this is necessary.**

Have questions about BookingCenter’s reports? Please email support@bookingcenter.com with your needs and we'll show explain how BookingCenter will provide the solution.