Controller for 22+ Family Law firm. Used QuickBooks Online, Clio, Slack, and Quip. Prepared payroll, all Accounts Payable, reconstructed Chart of Accounts, corrected thousands of QBO transactions. Built an ADMIN set of directories & files in Google FileStream. Supervised 2.

QuickBooks file cleanup. Payroll for 22, light supervision of 2 with Billing & Collections. Advanced excel budgeting & forecasting spreadsheets. Prepared Financial Statements for CPA, reviewed & corrected tax returns corporate and personal. Cleaned up and Organized Directories & Files in Abacus Cloud environment.

Hourly projects: Freelance, several CPA’s and temp agencies. Wide variety of projects including write-up of new clients, book clean-up with QuickBooks Desktop, tutoring client bookkeepers; Job Costing for construction firms; deep analyses of ERP software systems for manufacturers with Overhead Set-up and Bid Process correction; large Fixed Asset software conversion; tax return preparation for individuals, partnerships, corporations and non-profits.

I did all the trade and royalty activities’ Balancing of Inventories, Purchases, Sales, and transfers of crude oil in huge linked spreadsheets, controlling revenues and expenses of $ 180 MM per month. Supervised Billings, Royalties, Contract Administration, gross margin forecasting on new deals. Worked very closely with traders, marketers, schedulers, department heads, customers, and transporters for trucking and pipeline. Resolved payment and volume disputes. Prepared Journal Entries for Cost of Sales, Trade Payables and Receivables, Severance Taxes, Accruals for AP and AR, garage repair facilities. Coordinated the Accounts Payable and Receivable process for physical commodity Purchases, Sales, and volume transfers. Performed monthly General Ledger major account reconciliations and variance analyses for Revenues, Oil Inventories, Cost of Sales, Gross Margins, Net Income and other accounts with explanations detailing reasons for fluctuations. Assisted with litigation support and responses to audit requests. Maintained controls and documentation evidencing performance of controls.Go-To Guy for all Excel complex reconciliations, actively mentoring coworkers, helping build or analyze spreadsheets for allocations, Division of Interest, Severance Taxes, Risk Analysis. Developed advanced linked Excel worksheets for Gross Margins, Cost of Sales, Purchases and Sales, Price/Volume Changes in Inventory, and Summary Data of all types – Sales by Crude Type, State, etc. Creation of spreadsheets included Array Functions, IF Statements, VLOOKUP/MATCH, Pivot Tables, and Macros with error checking formulas throughout. Most spreadsheets used by operations were my builds.Recovered $ 42 MM in Royalty overbillings from ExxonMobil and prevented losses due to accounting errors of $ 58 MM at the wire transfers. Negotiated and confirmed Settlements of $ 1.5 B per year.