MMS-2014 Reporting

Excalibur's MMS-2014 Reporting system is the most comprehensive MMS royalty system available. The system automatically calculates actual take, modified take and entitlement basis royalties for both federal and Indian agencies. The MMS-2014 system provides online payment inquiries and a complete suite of historical and analytical reports. This system fully integrates with other Excalibur systems including Revenue, Production, Land Division Orders and Land Lease Records.

Data Entry Features

Copy feature for facilitating adjustments by automatically bringing selected historical MMS-2014 detail line items into the current month's activity
Reversal feature for automatically reversing historical MMS-2014 detail line items
MMS-2014 detail line item maintenance capabilities include:
- Manually entering supplemental report lines
- Modifying report lines that the system automatically calculated
Electronic spreadsheet interface for automatically creating detail report lines from spreadsheet data generated offline

Accounting Controls and Features

Royalty calculations performed for lease types including federal, Indian allotted and Indian Tribal
Actual take and modified take basis royalty calculations based on Revenue system activity and on burden relationships as defined in the Land Division Orders system
Entitlement basis royalty calculations based on Production system sales activity and on burden relationships as defined in the Land Division Orders system
Pricing options (controlled at the product/selling arrangement level) include actual price received, manually-entered price, and table-driven price
Substitute pricing used when actual price is not available for pricing production volumes for entitlement basis royalty calculations
Multiple royalty rates allowed by product
Automated net transportation, gross transportation and processing allowances with limitation analysis
Automated prior period adjustment
Estimated payment balance tracking
Minimum royalty and advance rental tracking
Recoupment balance tracking

Reporting

Complete MMS-2014 electronic reporting
Comprehensive audit report of payment detail for selected report months, sales months and MMS lease numbers
Comprehensive monthly analysis reports including:
- Estimated payment adjustment recommendation
- Minimum royalty and advance rental due
- No sales analysis
- Recoupment recommendation
Comprehensive on-line inquiry of current and historical detail line items
Calculation trace-back feature that displays specified calculation details online, starting at a single report line and then working back to the revenue or production source transaction