Sign in

Accounting Manager Real Estate

Santa Ana, California, United States
September 11, 2018

Contact this candidate


Vince Esquibel


Reconcile and negotiate CAM, R.E. Taxes, HVAC, Utilities and Insurance costs

Install computerized General Ledger setups according to entities needs.

Reconcile system implementation of software and related applications in property management, banking, medical, insurance and manufacturing reporting systems.

Design and reconcile college financial budgets for undergraduate, graduate and PhD programs.

Reconcile all balance sheet accounts, download all online banking and credit card activity and record.

Implement month end close, financial reporting, budgeting, and forecasting models.

Prepare individual small business, corporate, s-corp., LLC, partnerships, trusts and TIC’s tax returns.

Create, summarize, and review residential and commercial properties lease abstracts

Work Experience

Temp Contractor:

Loan Depot. Mar 2018 – July 2018

Responsible for wire and operating cash accounts, receivable and other liabilities reconciliations, follow through from original source, to GL and actual cash in bank postings. Email source to ownership of entry and see to completion.

Advantage Solutions Dec 2017 to Feb 2018

oReconcile multiple balance sheet accounts; determine and email original individual to see that journal entry allocations are fixed, adjusted or outsourced to correct person to be completed.

oResponsible for completing bank, security deposits, property tax true-ups, all balance sheet reconciliations, created working folders, input journal entries and assist in other month end reporting functions.

Wage Works Dec 2014 – March 2017

Treasury Fiduciary Accountant

oReconcile checking and sub-ledger accounts for Cobra & FSA with high volume and complex transactions using pivot tables, lookups and macros.

oResearch and resolve discrepancies between bank activity and platform (book) activity.

oAnalyze, true-up and reconcile individual customer accounts. Assist in period ending reporting and analysis.

Alcon Len Sx- Novartis Nov 2012 – July 2014

Financial Analyst

Subsidiary of Novartis (pharmaceutical) specializing in total eye care software and hardware.

oEOM Financial Reporting programming systems liaison utilizing multiple GL software’s to generate final consolidated financial month end results. Submit inventory activity reports to corporate office.

oWrite-up general ledger procedures manual. Review GL for fixed asset activity, document, create package, obtain

omultiple approvals, compare amounts against purchase orders, input in SAGE software, create depreciate summary, input data into GL, and update management exception lists.

oCreate and distribute Regional & Service monthly cost center financial actual vs budget reporting packages to all managers. Review, analyze, and create various data management reporting master lists.

oReconcile all balance sheet accounts w/5000-10000 transactions with pivot tables and lookups to analyze data. Post journal entries. Upload, download, reconcile and record all activity into GL from on-line banking and online credit card websites. Receive A/R checks, identify invoice, post to GL and mail to bank. Review AP check runs for accuracy, obtain mgmt. approval, upload to Bank website, post JE and reconcile to GL.

Independent Contractor

National Community Renaissance July 2012 – Oct 2012

oReview accounts payable, cash receipts, and general ledger activity.

oReconcile intercompany and bank checking accounts, create month end financials.

oReconcile and negotiate third party expense reimbursement and residual receipts requests.

Carl Karcher Enterprises - Volt October 2011 – March 2012

oConsistently saved an average of $5,000-$10,000 in annual CAM adjustments with landlords.

oReconcile and negotiate annual CAM reconciliations for all locations. Averaged cost savings of $100k annually

University of New Mexico – College of Nursing January 2011 - June 2011

Accounting Analyst

Create budget template for undergraduate, graduate, PHD programs for administrative monetary reviews so that request for additional state funding could be submitted.

Independent Contractor January 2007 – October 2010

oImplement Yardi property management property system from previous third party property management.

oContracted with and reconciled medical center billing computer conversions.

oAssist in government non-profit monthly and year of end close. Assist in preparing future fiscal year budget.

oPrepare corporate, s-corp., LLC, partnership, fiduciary and TIC’s income tax returns and Sec 1031 exchanges

General Growth Properties January 2004 – January 2007

Senior Mall Accountant, Riverside, California

General Growth Properties are a publicly traded Real Estate Investment Trust (“REIT”)

oCreate and reconcile Cam, Real Estate Taxes, HVAC, Marketing and Electricity settlements...

oCreate lease abstracts and post recurring billings for both permanent & temporary tenants.

oInput, review, analyze and reconcile balance sheet accounts. Volume exceeds 5000 transactions a month

oProduce monthly financial statements, eighteen month forecast and five-year capital expenditure forecast

oCreate CPI escalations; rent step increases, GLA, GLOA and occupancy maps.

oReview and record GAAP straight line rent accruals per FASB 13.

oReconcile cash collections, A/R, A/P, security deposits and specialty leasing income.

oPrepare annual sales tax returns.

Vision Sports January 2001 – January 2004

Accounting Manager, Costa Mesa, California

A $25 million international company that specializes in skateboard and related sports apparel

oCustomer Service and collections of Outstanding Int’l Accounts Receivable. Collected $400k in two months.

oReconstruct and closed two years financial statements from G/L through F/S.

oManage the general accounting, A/R, A/P, payroll and inventory functions.

oCompile sales tax, bank int’l letters of credit.

oVerify that inventory physical counts and pricing are completed accurately.

oAnalyze, evaluate and resolve purchase and shipping costs with Int'l entities.

oReconcile daily cash and credit card receipts to bank statements and balance sheets.

Meruelo Enterprises January 1998 – January 2001

Accounting Manager, Downey, California

Meruelo Enterprises is a publicly traded Real Estate Investment Trust ("REIT")

oInitially create financials for 18 residential, 24 commercial rental and 6 marketable security entities

oAssist and create lead sheets for refinancing of properties to acquire additional equity for investments.

oCreate and reconcile CAM and negotiate settlements. Verify GLA, GLOA occupancy maps.

oDesign, organize and implement an initial internal financial statement reporting package.

oCreate lease abstracts, review tenant move-in lists, review receivables, create 3-day or quit forms.

J. F. Shea Co., Inc. September 1993 – December 1997

Senior Accountant, Walnut, California

J.F.Shea is a privately held holding company, which includes Mega Real Estate developer Shea Homes.

oDownload daily stock broker portfolios into Access database and process and record all daily activity. Volume exceeds 2500 transactions a week

oReconcile Intercompany loan, post journal entries, record daily cash receipts and disbursements.

oDesign MS Access database for stock portfolio reporting.

oReview, analyze and reconcile trial balance.

oReview for actual, budget and forecast cash needs for foundations, corporate and owner’s interests.

Education and Credentials Accounting – BBA, University of New Mexico, Albuquerque, NM

Principles in Real Estate Courses - Cal State Long Beach, CA

Exec-U-Train Certification Courses in Excel, Access & Management Quality Control

Computer & Special Skills

JD Edwards; AMG, Great Plains: QAD; One World; Showcase; Siebel; Yardi Voyager; MAS 90; SLIM; JDA; AS400; Bonner; Facets; Harrington; Trizetto; Spyglass; Microsoft Dynamics ; B1 reporting; FASB 13 Reporting; AMT Lease Database; Dyna Forecast Module; A Plus Tax System; OMS Prop Mgmt System;

Quick Books Pro; Peachtree; Quantra Mortgage Systems; CCH Pro Systems FX; CCH & SAGE Fixed Assets Systems; IBM-PC; Google, MS Windows; Access, Excel, Pivot Tables & Lookups, Word and Outlook.

Contact this candidate