Sign in

Real Estate Customer Service

Santa Ana, California, United States
January 22, 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:

Advantage Solutions - Senior Accountant Nov 2017 to Present

Temporary staff accountant responsible for balance sheet reconciliations and journal entry allocations.

Steadfast Companies - Senior Property Accountant Aug 2017 – Sept 2017

Temporary full cycle property accountant using Yardi software covering for a medical leave of absence. Responsible for bank reconciliations, security deposit, property tax true-ups, all balance sheet reconciliations and month end reporting.

Beacon Hill – Wage Works - Treasury Fiduciary Accountant Dec 2014 – March 2017

Checking and sub-ledger account reconciliations for Cobra & FSA with high volume and complex transactions using pivot tables, lookups and macros. Research and resolve discrepancies between bank activity and platform (book) activity. Analyze and reconcile customer account activities. Assist in period ending reporting and analysis.

Alcon Len Sx- Novartis – Financial Analyst Nov 2012 – July 2014

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

EOM 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.

Write-up general ledger procedures manual. Review GL for fixed asset activity, document, create package, obtain multiple approvals, compare amounts against purchase orders, input in SAGE software, create depreciate summary, input data into GL, and update management exception lists.

Create 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.

Reconcile 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.

National Community Renaissance – Staff Accountant July 2012 – Oct 2012

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

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

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

Carl Karcher Enterprises - Volt - Property Management Assistant October 2011 – March 2012

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

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

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

Create budget template for undergraduate, graduate, PHD programs for administrative monetary review requests

M T Business Solutions January 2007 – October 2010

Contract Accountant, Long Beach, California

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

Contracted with and reconciled medical center billing computer conversions.

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

Prepare 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”)

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

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

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

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

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

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

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

Prepare 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

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

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

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

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

Verify that inventory physical counts and pricing are completed accurately.

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

Reconcile 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")

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

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

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

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

Create 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.

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

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

Design MS Access database for stock portfolio reporting.

Review, analyze and reconcile trial balance.

Review 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; 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