Download PDF

Summary

Expert Accounting Manager with extensive track record in business-to-business (B2B), business-to-consumer (B2C) and business-to-government (B2G) computerized accounting comprehension gives me a unique ability to apply Accounting theories, in all its forms, to any accounting processes. Some of my knowledge includes property finance, cost research, budgeting, budget analysis, accounts receivable/ payable, collections, cost accounting, inventory control, management and various operational processes. I have worked with various mortgage companies, banks, property management companies, legal firms, education/ training schools, and the US Army as a team member as well as a supervisor/ manager. My greatest skill is exceptionally advance knowledge to manipulate Microsoft Excel into custom spreadsheets and expert knowledge of QuickBooks.

Work History

Mar 2010Mar 2016

Property Accountant

Kemp Properties
  • Strong operational knowledge of GAAP
  • Responsible of data entry of Accounts Payable help gain extensive knowledge of cost related auditing for yearly budget cost analysis
  • Helped the property manager quarterly compared estimated costs to actual output cost (Variance vs. Budget)
  • Yearly cost analysis (w/ average of 3 yrs) Variance vs. Budget and Forecast analysis for first run budget preparations for property manager
  • Prepared first run Variance vs. Budget and Forecast analysis budget for property manager to adjust
  • Prepared monthly, quarterly, and year-end closings – monthly distributions
  • Generated full financial package - income statement, balance sheet, and profit and loss statements.
  • Prepared monthly accruals if needed for Profit & Loss and Balance Sheet
  • Responsible for the Profit & Loss to Balance Sheet to General Ledger to cash at the end of months reconciliations
  • Investigated and resolved accounting discrepancies or errors
  • Reconciled up to 20 bank statements & maintain up to date bank balance
  • Worked yearly with the CPA to resolve problems
  • Maintained & processed 1099 tax information on vendors
  • Ran 1096 for controller to review and sign
  • Entered receipts for over 450 customer accounts
  • Prepared customer's monthly statements
  • Resolved accounts receivable issues with customers
  • Investigated and resolved billing and account discrepancies
  • Responsible for scanning all invoices for vendor voucher packages, including filing all non negotiable check copy with the packages for auditing purposes according to established policies
  • Responsible for voiding checks that are improperly generated & ensuring properly filing of voided checks/invoices
  • Created accounting procedures document for controller to use with training and as needed
  • Analyzed and reviewed the packages for accuracy, distributed the packages to appropriate parties
  • Performed a variety of concurrent tasks with ambiguous or little directions
  • Excellent multi-tasking skills that allowed me to prioritize various ongoing projects
  • Created custom Excel spreadsheets to met needs
  • Used QuickBooks , MS Office Suite and a variety of custom Excel spreadsheets
Nov 2004Jun 2008

Accounting Manager

New Horizons Computer Learning Center of Austin

  • Prepared monthly, quarterly, and year-end closings – monthly franchise royalty distributions
  • Generated full financial package - income statement, balance sheet, and profit and loss statements.
  • Prepared monthly accruals-Profit and Loss statement
  • Responsible for the Balance Sheet & general to ledger accounts reconciliations
  • Researched and corrected accounting errors or discrepancies
  • Reconciled 6 bank statements & maintain up to date bank balance
  • Worked closely with the CPA to resolve problems
  • Maintained 1099 tax information on vendors
  • Analyzed and reviewed the packages for accuracy, distributed the packages to appropriate parties
  • Performed a variety of concurrent tasks with ambiguous or little directions
  • Excellent multi-tasking skills that allowed me to prioritize various ongoing projects
  • Created custom Excel spreadsheets to met Corporate Headquarters, Management, and Account Executive needs
  • Used QuickBooks Enterprise, MS Office Suite 2007 and a variety of custom Excel spreadsheets
Jan 2004Nov 2004

Temporary Accountant

Accountemps
  • Tempted with Real Estate companies and Law Firm
  • Used AMSI, QuickBooks , and variety of accounting software
  • The real estate was responsible for 11 properties with on-site computer systems
  • Used a variety of all accounting transactions: accounts receivable, accounts payable, mortgage and insurance payments, tax processing and preparing bank reconciliations
  • Reviewed annual budget and compared actual expense to budget, investigated variance
  • Prepared monthly accruals to the Profit and Loss statement
  • Reconciled the bank security account, general ledger, & Balance Sheet account
  • With all companies I used MS Outlook and a variety of custom Excel spreadsheets
19992000

Property Accountant

Southern Real Estate Management
  • Transferred thousands of rapidly degrading MS DOS records to Yardi, in time to accomplish year-end closing
  • Responsible for monthly, quarterly, and year-end closings
  • Financial package +budget comparison, CAM & CPI reconciliations, and tenant rent roll 7 commercial properties
  • Reconciled 21 bank statements & maintain up to date bank balance.
  • Assisted with annual budget setup and over saw the monthly forecast and compared actual expense to budget
  • Investigated variance &prepared monthly budget reports
  • Analyzed & reviewed the packages for accuracy, distributed the packages to appropriate parties
  • Developed many easy to read Excel spreadsheets for the property managers, owners, and invested partners
  • Worked with Yardi, Lotus Notes, Microsoft 95 & 98, Microsoft Office 2000, MS Word, and Excel
19941997

Owner

The Sherrill Solution
  • Worked with various professional offices: CPA, Banking, Medical, Mortgage, Real Estate, doing a variety of skills
  • Became an expert at analyzing complex problems to find inventive, logical, and effective solutions
  • Expert problem-solver - able to sort through complex issues and conduct a relative review of multiple solutions with little or no direction from clients
  • Worked through very critical issues to draw an accurate conclusion
  • Exposed to various situations, this allowed me to learn incredible assessment
  • Excellent multi-tasking skills due to my being able to prioritize projects
  • Synthesize complex information and meet all my deadlines under an extreme amount of pressure
  • Learned a wide variety of computer software and computer networking
19931994

Accounting Manager

Michael Chrysler Plymouth

·Converted the manual books to computerized software

·Started as Assistant to the Accounting Manager. After proving myself, was promoted to Accounting Manager position when he left his position

·Worked closely with the CPA with the annual budget setup and over saw the monthly forecast

·Compared actual expense to budget and investigated the variance then prepared monthly budget reports to the owners

·Responsible for at the end of month closing and generated a full financial package

·Developed a spreadsheet that helped the owner understand and analyzed the end of month reports

·Responsible for supervising the Accounts Payable and Accounts Receivable department

·Was in charge to research, interview, hire, and trained staff members

Mar 1980May 1988

Bookkeeper

Joel Cruz Resendez Attorney at Law

·Converted the manual books to computerized software

·Started as Assistant to the Accounting Manager. After proving myself, was promoted to Accounting Manager position when he left his position

·Worked closely with the CPA with the annual budget setup and over saw the monthly forecast

·Compared actual expense to budget and investigated the variance then prepared monthly budget reports to the owners

·Responsible for at the end of month closing and generated a full financial package

·Developed a spreadsheet that helped the owner understand and analyzed the end of month reports

·Responsible for supervising the Accounts Payable and Accounts Receivable department

·Was in charge to research, interview, hire, and trained staff members

Education

20002003

Networking Technology Specialization

Del Mar College

Honors Program: 19 September 2002 ID Number: 02G11003

19851987

Accounting / Finance

US Army Academy of Finance