Alma Ramirez Sherrill

• Journal Entries for prepaid expense, deferred revenue and payroll cash accounts
• Receive and deposit all organizational revenue.
• Execute monthly payroll activities using a 3rd party payroll service provider.
• Prepare monthly and quarterly financial reports, including standard financial reports, budget vs. actual reports and grant-specific financial reports.
• Ensure the billing is in compliance with all internal policies, controls and relevant regulations and ensure filings are completed in a timely manner.
• Prepare billing and bill various government agencies.
• Assist Program Managers in the financial reporting and other administrative requirements of their grants/contracts, state Memorandum of Agreements.
• Report and track actual expenditures and variations from the budget
• Monitoring/tracking the status of each program through its program life cycle
• Manage time tracking process for employees with hours billable to grants, payroll entries for financial and grant reporting.
• Work closely with Controller to execute month-end closing procedures and postings.
• Coordinate with Controller and Auditors in preparation of year-end audit.
• Support Program Managers in development and analysis of annual organization budget.
• Produce reports as needed by program staff

• Solid 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 financial packages for accuracy and distributed the packages to appropriate parties
• 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

• 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 financial packages for accuracy and 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

• Tempted with Real Estate companies,oil and gas industry, 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

• 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 and 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 and reviewed the financial packages for accuracy and 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

• 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

I was the specialist in charge of a 90-person company with a staff of five. It was my responsibility to oversee the delegation of duties of training, housing, and other administrative duties for the 90 personnel were to Army standards. I was responsible for a payroll of 15,000 soldiers with the operating budget of $1.5 million. I earned a reputation as a shrewd analyst after meticulously paying attention to details of research data by identifying over $400,000.00 in dollars that was incorrectly disbursed in entitlements and travel payments due to computer glitch. I developed and implemented a soldier training program related to entitlements and travel allowance. I earned a Department of the Treasury award for the training program. I was trained to work with variety of software. As the Finance Specialist I worked with all aspects of accounting.

GPA: 3.5

GPA: 3.7

Honors Program: 19 September 2002 ID Number: 02G11003

Earned certificate equivalent to Bachelor's degree