What are the responsibilities and job description for the Senior Oil and Gas Revenue Accountant position at Venable Royalty, Ltd?
OVERVIEW: Process large, complex non-operated revenue receipts via electronic uploads, manually modify and rebuild data received with accountability that all is efficiently and accurately processed; assist with various reports and needs of management and tax preparers; other projects as needed. Collaborate with Revenue Specialist to ensure monthly deadlines are achieved. Work with Director of Accounting on various tasks and projects as they arise.
Job Description:
- Upload large (as many as 50,000 lines of data) or complex CDEX revenue files; review edits for deductions and anomalies such as price and decimals paid.
- Parse CDEX files to perform further manipulation via Excel templates to change product codes when multiple decimals are required, calculations (gross up taxes and deducts), remove lines with no value, combine like lines etc.; reconstruct for upload.
- Accurately and timely complete and submit requests for new wells, decimals, operator changes, etc.
- Assist Revenue Specialist as needed with large maintenance requirements including acquisitions and operator changes by preparing and implementing uploads for wells, decks and purchaser masks using Excel templates.
- Prepare revenue data for upload using OGSQL PCX Excel templates when direct CDEX uploads impractical or unavailable.
- Scan checks to Enverus for conversion to CDEX format when data files are otherwise unavailable. Monitor return of processed files, proof for accuracy, and upload to system.
- Monitor revenue email for incoming statements and queries; distribute as needed.
- Perform month-end revenue review to reconcile and verify all receipts have been accounted for; research and correct any anomalies; prepare final report.
- Create monthly cross reference reports in Excel for use during the coming month.
- Prepare the annual 1099 worksheets to record 1099s as received; assist with research, reconciliation and operator follow-up as needed.
- Prepare first quarter accrual reports for tax preparers.
- Create journal entry uploads for annual tax adjustments for multiple companies.
- Assist with reporting needs for management and tax preparers.
Qualifications:
- Bachelor’s degree in accounting; CPA a plus but not required
- 3 years experience in oil and gas revenue processing
- 5 years experience in accounting with solid understanding of oil and gas accounting in general
- Experience with OGSQL accounting software a major plus, including report-writing and editing
- High proficiency using Microsoft Excel is essential
- Experience with EnergyLink and CDEX uploads
- Ability to multitask in a heavily papered, high volume, deadline-driven environment
- Strong written and verbal communication skills; able to effectively communicate with outside purchasers and operators, team members and management
- Excellent organization and time management skills
- Meticulous, detail-oriented nature with desire for accuracy and excellence in completing tasks
- Ability to think critically, research and logically solve problems
- Professional manner
Our business is founded on integrity and operates with a desire for excellence. We seek the same attributes in this Revenue Accountant. In exchange, we offer a peaceful environment within a stable organization, a beautiful brand-new office, a highly accessible location in Preston Center, and an attractive compensation/benefits package, including 100% company-paid health and dental insurance, 401k after one year, and paid holidays and vacation.
Please include a cover letter of introduction with your response, as resumes submitted without such cannot be considered. Thank you in advance for your response.