Accounts Receivable

The Excalibur Accounts Receivable system is a comprehensive customer analysis, cash receipts and cash management system. It provides you with complete control over the application of cash receipts and performs numerous industry-specific functions such as revenue receivables reconciliation and managing JIB prepayments from partners.

Data Entry Features

Full display of customer current open items when posting cash receipts
Flexible application of cash receipts from customers including:
- Automatic application to the oldest open items
- Selective application to specified invoices
- Optional selective application to specific properties
- Types of expenditures such as IDC and LOE
- Automatic generation and tracking of unapplied credits
Optional posting of revenue receipts by property
Miscellaneous cash receipts posting directly to user-specified General Ledger accounts
Application of cash to open invoices created by affiliated companies
Flexible handling of billing prepayments including:
- The option to establish prepayment as a receivable or when you actually receive cash
- The option to establish (and apply subsequent JIB costs) at the property level or at a more detailed type of expenditure level such as IDC, ICC or TDC
Creates and prints a manual invoice and credit memo
Invoice adjustment entry and posting features including full adjustment on an invoice basis and partial adjustments by property and type of expenditure to a specific invoice

Accounting Controls and Features

Calculates service (interest) charges on user-specified delinquent customer accounts
Creates and posts intercompany receivable and payable entries for cash received on behalf of affiliated companies
Ability to net all open items for a customer against that customers share of revenues to be distributed through the Excalibur Revenue system
Revenue receivables subsystem that:
- Reconciles amounts recorded in Accounts Receivable as revenue cash receipts with:
  - Amounts booked and disbursed through Revenue
  - Adjustments to data input errors such as applying cash to the wrong sale date
- Writes off small balances
Interface with Revenue gross sales data entry to verify that the cash receipt for a gross sale has been recorded in Accounts Receivable

Reporting

Customer invoicing including manual invoices and credit memos, lease rental invoices (with all pertinent lease and rental information) and service (interest) charges invoices
Extensive cash receipts reports
Comprehensive account, aging and customer detail reports including:
- Open items
- Aged trial balances
- Prepayment trial balances
Customer statements such as:
- Balance forward (as of period end) format
- All open items within a date range
- Aging analysis by invoice or due date
- Customer history
- Past due notices
- Online display of customer open items and history
Comprehensive revenue receivables reports including:
- Activity by payor, well and product
- Open items by payor or well
- Aging analysis by payor and well
- Discrepancy reports for cash clearing and unmatched deposits/sales