Volume Contract Account Production report

When you negotiate a yearly rate agreement, the company generally promises a certain amount of guestrooms. The more they promise, the lower your rate for them. To make sure they're keeping their end of the bargain, enter actual consumption numbers in your volume contracts, and then run this report. Typically this report is used quarterly to review each account's actual vs. forecast numbers, and rates are reviewed or renegotiated with the accounts that aren't producing.

How can I tweak the report data?

The Report Options you select determine what is displayed in the report data. Here are a few tips to help you get started.

Report Options Tips
Consumption Start and End Period Enter a date range to include accounts that have guestrooms during that time (usually year-to-date). The range can't exceed one year.
Property Currency If you have access to multiple properties, and some of the properties have different currencies, select the currency for the properties that you want to report on. The Properties list is then updated to include only properties with that currency.
Properties If you sell multiple properties, you can include them in the report. Only those properties you have access to are shown.
Market Segment Type If you group the report by market segment, or if you select only certain market segments to be included, select if you want the market segment on the contract, account, or either to be used. If either is selected, we first pull based on the contract segment, and then pull based on the associated account's market segment.
Market Segments By default, all market segments will be included in the report. If needed, select only those segments you want to report on.
Account Owners By default, contracts from all Sales Managers will be included in the report (including those who are inactive). If needed, select only those users whose accounts you want to include.
Contract Owners By default, contracts from all Sales Managers will be included in the report (including those who are inactive). If needed, select only those users whose contracts you want to include.
Status Select the statuses you want to include - Prospect, Bid, or Contracted.
Display Volume Contracts without Account If you select Yes, all contracts without an associated account will be grouped into a "None" section for Account Owner and Account respectively.
Group By Do you want subtotals by Account Owner or Market Segment?

Account Status

Choose whether or not to include inactive accounts. If you do include inactive accounts, they are preceded by an asterisk (*) in the report results.

This filter was added in version R38 (March 2020). If you run the report on a version lower than R38, the Active column will display in the results with all accounts showing as active regardless of their real status. To schedule your complimentary update to the most current version, contact Support.

How do I run the report?

Click View Report. Here are a few additional things you can then do:

What does it all mean?

You'll probably want to change the zoom to 200%. Each account with a volume contract in the date range is listed. As you scroll to the right, the total changes to rooms and revenue for the report's date range is displayed, followed by the monthly totals for Actual Rooms and Revenue, and the Variance to the forecasted amount.

The data in the report can be delayed by up to 15 minutes. If the data doesn't match what you expect to see, run the report again.