Andrea Ranelli Mcpherson Email & Phone Number

Dallas, Texas, US

Houston, Texas, US

• Compiles volume data and third-party statements to allocate delivered volumes to producers, bill fees, and accurately recognize revenues each month for the Jewell Gas Plant and Rowdy Gas Gathering System, which.
• Developed and maintain the proprietary accounting system for the Jewell Gas Plant in W Energy (formerly Waterfield Energy)
• Assessed initial operations and measurement design with field engineers upon completion of Jewell Gas Plant as part of the development of Jewell Gas Plant accounting system
• Identify and remedy discrepancies and/or variances within monthly volume data against budgeted projections
• Identify and analyze month-over-month volume trends
• Streamlined company-wide practices/processes to reduce our settlement completion from five days to two days

Denver, CO, US

• Collected condensate volume data in order to allocate delivered volumes to producers, bill fees, and accurately recognize revenues each month for the Ohio Condensate facility, which stabilizes 11,000+ barrels per day
• Analyzed the total production for the Utica and Liberty processing systems to correctly allocate the fuel fee for the Hopedale Fractionator system back to the producers
• Prepared and booked journal entries during monthly close to ensure revenues and expenses are booked in the correct period, and the financial statements are accurate for the Utica and Liberty business units
• Created journal entries to book the gain/loss, and analyze profit trends for the Utica and Liberty systems
• Coordinated with accounts receivable and accounts payable to ensure that payments to and from producers are being paid accurately and in a timely manner

Denver, CO, US

• Collected, organized, and synthesized wellhead export data to successfully reconcile the Petroquest (gas gathering), Centrahoma (gas processing) and Pioneer (gas pipeline) systems
• Imported and settled Petroquest systems in TIPS, and Centrahoma and Pioneer systems using proprietary excel workbooks
• Coordinated with Southwest Business Unit, Treasury, and Accounts Payable divisions to manage outbound payments to producers
• Created, reconciled, and filed regulatory reports and payments to the Oklahoma Tax Commission, Railroad Commission of Texas, Texas Comptroller, and Energy Information Association

Spring, Texas, US

• Assist with accounting close process including data validation and review, accruals, and management reporting
• Prepare and review journal entries as well as maintain reconciliations including gross bookings, accounts receivable and deferred revenue
• Reconcile the general ledger with the sub ledger and domestic and foreign bank accounts
• Supervise the billing of time and materials projects, SaaS, licensing and maintenance for ten products
• Coordinate the on-boarding of new acquisitions onto the Great Plains system
• Track and invoice sponsors and attendees for the annual ASCEND Conference

Master'S In Accountancy, Accounting

B.A., Environmental Studies, Economics

Education record