Microsoft Office Project
Resume:
BEVERLY LOTT
*******@*****.***
EDUCATION
AS, Paralegal Studies, EL Centro College
BS, Accounting, Bishop College
Peoplesoft
Yardi
Peachtree
JD Edward
QuickBooks
Skyline
SAP
Quicken
Avatar
Microsoft Office
Insource Tax Calendar
MRI
Rent Roll
Timberline
Vertex
Wolfepak
Oracle
Great Plains
AS400
Procount
Quattro Pro
ADP Reporting Smith
Lawson
Microsoft Office
Internal Audit
Revenue Accountant
Finance Analysts
Project Management
Budget/Forecasting
Joint Interest Billing (JIB)
Payroll Auditor
Investment Fund/Hedge Fund
Sarbanes-Oxley Compliance
Cash Flow Management
AP, AR, Gl, JE, I/C
Organizational Transformation
Accruals/Adjustments
Reconciliation
WORK EXPERIENCE
Dr. Harold D. Wagner Office 08 /16 – 09/17
Sr. Accountant/ Office Manager
Financial analysis of expenses for month end close timely and accurately
Recording revenue and expense in accordance with GAAP
Preparing financial reports as necessary, Operating costs and expenses
Prepare journal entries, GL. AP/AR
Building spreadsheets using Pivot table, VLOOKUP, if/then statements
Identify and explain budget variances
XTO Energy 01 /13 – 03/15
Revenue Accountant
Assist in providing direction as needed to team members.
Allocate oil, gas, and water volumes including fuel, gas lift and flash gas to a property level
Perform monthly revenue analysis, Accrued to actual variance analysis
Prepare and record monthly revenue accruals. Ensure results in revenue transaction systems
Prior Period Adjustment and explanations (PPA)
Inter-Company Journal, Variance Analysis, Prepare GL reconciliations
Review process and perform internal controls to ensure SOX Compliance
Building spreadsheets using Pivot table, VLOOKUP, if/then statements
Record revenue transactions in the Production Accounting System (PAS) to a well or property level
Record revenue deductions preparing the product for market to well or property level.
Work with Regulatory/Severance Tax Accountants to ensure accurate tax and royalty filings
Excel are timely and accurately reconciled with information
Reconciled volumes to the PGAS measurements system or outside pipeline statements
Reconcile accounts and ensure that entries are appropriately classified and in the correct account.
Pursue and resolve AR issues on a timely basis for assigned assets/customer.
Assist AR group in keeping aged receivables at a minimum
Establish and maintain effective relationships with internal departments (Marketing, Operations, Land and Finance) and external
Stakeholders (Landowners and JV Partners)
Journal vouchers for assigned accounts on a monthly basis and adhere to internal controls and SOX compliance in all activities.
Perform variance trending and support Operations in review of property results vs. estimates and budget.
Setup and maintain master files related to fields, wells completions, sales meters and equipment
Processing volumes and contractual allocations
Preparation of state and federal (ORRI/MMS) royalty and, Severance tax
Tracking gas balances, cash settlements between producers
Analyzing variance between the monthly estimate accrual and the actual recorded sales
Cousins Properties, CB Richard Ellis, Cano Petroleum, iServe Servicing, BBVA Compass Bank, Pioneer Natural Resources,
Ensco International, VHA Inc., Riverstone Residential Group, Idearc Media, Balfour Beatty Construction, Clicks Billiards
ReXel, Hudson Advisor, Colemont Insurance, AMPAD, Walden Property Management, Trammel Crow, Hotel.com
Lifenet, TXU Energy, CompUSA, Carlson Worldwide (TGI Friday), Invesco, Jackson Hewitt Tax Service, ING Clarion,
Bowne Inc., Metro PCS, RM Crowe, Henry S. Miller Commercial, Lifenet, Three PDS, Inc., Huitt Zollars, Sears Holdings
FirstPlus Financial, Host Marriott,
(Contract) Sr. Accountant/Special Projects/Auditor/Revenue Accountant/Financial Analysts 02/90 – 12/12
Prepare month end close
Cash FlowAnalysis for the prior YTD
GL, JE, A/R & A/P and severance tax
Reconciling all of the Prior Revenue, Asset, and CIP etc….
Prepare financial statements
Reconcile bank statement and deposits
Prepare check requests, Post Cash receipt
Prepared Variance Analysts
Booked Cash and accruals accounts
Checking monthly and other reports for accuracy
Reviewing the budgeting and forecasting analysis
Prepare Monthly Transfer for payments
SOX Compliance
Prepare special analysis reports
Foot and tie out financial statements
Prepare Documents for 10Q & 10K
Assisting in special projects as assigned
Prepare audit packages
Preparing monthly consolidated financial statements
Providing reconciliations of inter-company accounts in I-Series (AS400)
Prepared Financial schedules utilizing Hyperion Financial Management(HFM)
Supporting cash sweep investments and electronic banking (automated clearing house) payments
Plans, directs and coordinates activities for projects
Interact with client, customers, and suppliers to meet the objectives of the project.
Building Spreadsheet, Import and Export
Knowledge of the project discipline
Project scheduling, quantities, invoicing
Building Spreadsheet, Import and Export for Access
Conversion Peoplesoft to 8.9
Project scheduling, quantities, invoicing
Plans, directs and coordinates activities for projects
Testing & Final Implementation of Peoplesoft
Implement the name change of all bank accounts
Implement the name change with the different states
Plans, directs and coordinates activities for projects
Answer calls from co-workers on how to use the new software version of Peoplesoft 8.9
Advise the CEO on financials
Review state and federal income taxes
Contract fiscal compliance and report
Cross reference payroll deductions
Oversee government grants
Pay leases, licenses, and permit
Review Certificate Holders
Cost and Fixed assets
Mail updated licenses and permits to the stores
Ensure that the information requested for business license renewal is accurate.
Monitor license expiration dates and maintain timely payments to avoid late fees and penalties.
Review all incoming requests for a proof of insurance and understand special insurance requirements.
Ensure timely and accurate property tax payments to avoid late fees and penalties.
Maintain weekly check request list for AP department.
Monthly property tax payment schedules for Cash Department.
Review Assessed Value Notices and work on tax reduction.
Maintain copies of the tax bills and tax payments.
Provide landlords with a proof of real estate tax payment when required.
Work with AON Risk Services setting up a new certificate holder/ or proving existing certificate holder with updated insurance
Certificate (s).
Contact this candidate