Guadalupe C. Mercer
Brownsville, Texas 78521
***********@*****.***
EXPERIENCE:
LRM Truck Leasing (Remote)
Pompano Beach FL 11/18/2021 to Present
(Senior Accountant)
Reconciled Bank Accounts and Account Receivables.
Assisting the accountants and auditors to prepare monthly reports and perform auditing respectively.
Assist Controller with end of the month Journal Entries.
Reconciled Prepaid Insurance monthly and post any amortization for the current period.
Record all the cash, ACH and checks received on a daily basis.
Reconciled monthly Credit Card Receivables and investigates discrepancies when found.
Reconciled balance sheet accounts. (Prepaid, Liabilities, Assets)
Review and record truck leases contract and prepare payments schedules.
Broward Health
Fort Lauderdale, FL 06/01/2017 to 11/18/2021
Senior Accountant)
Reconciled Bank Accounts and Account Receivables.
Assisting the accountants and auditors to prepare monthly reports and perform auditing respectively
Assist Controller with end of the month Journal Entries.
Reconciled Prepaid Insurance monthly and post any amortization for the current period.
Record all the cash received from Insurance Payments, cash, and credit cards.
Reconciled monthly Credit Card Receivables and investigate discrepancies when found.
Reconciled Accounts Payables, Accounts Receivables, Intercompany Payables and Accrued Liabilities.
Prepare Sales taxes for cafeteria and Pharmacy sales.
Review cash reports from Physicians Hospitals and Hospitals.
Download daily cash report for transactions received by Hospitals, Clinics, Physicians’ Offices.
Submit check cancellations as requested.
Prepare daily cash report for Upper Management for payments received from different sources (Grants, Rebates, Donations,
Insurance Adjustments, Vendor Reimbursement)
Keep track of change orders for Cafeterias at each Hospital.
Make desktop check deposits received from employees, vendors and rent payments
Kaiser University,
Fort Lauderdale, FL 12/1/2014-06/20/2017
Senior Accountant)
Reconciled bank accounts with foreign currencies.
Prepared monthly Journal entries for payments received from students.
Organize monthly virtual meetings with the Staff abroad.
Recorded invoices paid with local currency in Great Plains
Reviewed income reports from Language Institutes and Summer Program held at the organization.
Assisted controller with Month End entries. Research discrepancies found on Assets Accounts.
Provide reports to auditor when requested at the end of the fiscal Year.
EXPERIENCE:
SNI Companies, Miami, FL
Pritikin Longevity Company 4/2014- 11/07/14
Senior Accountant (temporary)
Reconciled Bank Accounts, Intercompany Payables/Receivable.
Responsible for the allocation of Prepaid Health to the different departments.
Calculate payroll accrual at the end of the month for the parent companies and subsidiaries.
Invoices Royalties to India Franchise in U.S. Dollars currently.
Reconcile tips and gratuities for employees.
Responsible for the monthly close as well as maintenance of all accounting ledgers including monthly review of all account reconciliations and journal entries.
Provide timely explanations of variances between actual results and forecasts/budgets; provide corrective action recommendations to management, where necessary.
Oversee the General Accounting processes of Inter-company, Fixed assets and Accounting and financial reporting of all entities.
Work with internal and external auditors during reviews and audits to ensure full cooperation from accounting staff and compliance with all qualified requests.
Ensure completion and review of all balance sheet reconciliations and identify and communicate findings.
Special projects as needed.
Assist control on preparation of all financial reports, including Profit and Loss Statement, Balance Sheet and Statement of Cash Flows, as well as the year-end financial reports.
Hands-on experience in billing subsidiaries, monthly partner payroll and sales use tax filling for Missouri, Florida and Arkansas.
G/L coding and check printing.
Ensures all inter-company transactions are in balance. Analyze and clear variances prior to financial reporting close.
Balance fixed asset accounts, computes and records depreciation expense.
Prepared Daily Flash Report for upper management and Controller.
Roth Staffing, Miami, FL
Barton G Restaurant 12/2013 - 04/2014
Accountant (temporary)
Reconciled Bank Accounts and Line of Credit on a monthly basis.
Keep track of the daily transactions for the three restaurants Barton G, The Villa and The Versace Mansion.
Assisting the accountants and auditors to prepare monthly reports and perform auditing respectively
Assist Controller with end of the month Journal Entries.
Reconciled Prepaid Insurance monthly and post any amortization for the current period.
Calculated monthly payroll accrual and entered into QuickBooks.
Reconciled monthly Credit Card Receivables and investigate discrepancies when found.
Posted all vendors invoices for the three restaurants.
Reconciled Accounts Payables, Accounts Receivables, Intercompany Payables and Accrued Liabilities on a monthly basis.
Review daily sales and journalize them into Q/B.
Assisted with the conversion from Great Plains Software to QuickBooks Enterprise.
Retrieve Data and analyze sales from the three different restaurant Software (ALOHA, MICROS9000).
Ready Windows & Doors, Miami, FL (Part-Time), Miami, FL 8/2012 - 06/2021
Corporate Accountant
Perform/review bank account and credit card reconciliations and assist with corporate balance sheet reconciliations and other corporate monthly internal management reports
Assist Controller with the elaboration and analysis preparation of Schedule of Values
Invoice general contracting fees and allocate payroll to projects
Responsible for Construction accounts receivable tracking, management, and reporting
Assist in the development enhancement of project reporting
Assist with Construction project analysis reporting
Responsible for processing accounts receivable, billing, collections, accounts payable, payroll, job costing and general ledger postings
Prepare deposits and weekly cash flow forecasts
Elaborate Pay Applications and Schedule of Values for constructions projects
Work in Progress Schedule for job costing
Process accounts payable from invoice to payment, beginning with coding invoices to the appropriate job number, cost code, GL account number and distributing invoices to Project Managers for approval
Reconciliation of Vendor statements and Customer payments
Job cost tracking, analysis and reporting
Interface with Project Managers and senior management on all aspects of construction accounting
Community Development Corp., Miami, FL 2/2013 – 11/2013
Staff Accountant
Develop and maintain relationships with banking, insurance and non-organizational accounting personnel in order to facilitate financial activities
Monitor financial activities and details such as reserve levels to ensure that all legal and regulatory requirements are met
Accounts receivables and payables reconciliation
Update General Ledger Information
Perform accounting functions for the Agency, including General Ledger, A/P, Fixed Assets, Tax Compliance, A/R, budgeting (including short- and long-term forecasts) and investment analysis (incl. Expansion and acquisition)
Harlingen Housing Authority, Harlingen, TX 7/2010 – 6/2012
Accountant
Sales tax preparation, journal entries, investment report, inventory, and Payroll Review
Compiled and analyzed financial information to prepare entries to accounts
Develop internal control policies, guidelines and procedures for activities such as budget administration, cash and credit management
Prepare financial statements, business activity reports, financial position forecasts, annual budgets, and reports required by regulatory agencies
Advise management on short-term and long-term financial objectives, policies, and actions
Delegate authority for the receipt, disbursement, banking, protection and custody of funds, securities, and financial instruments
Evaluate needs for procurement of funds and investment of surpluses and make appropriate recommendations
Lead staff training and development in budgeting and financial management areas
Maintain current knowledge of organizational policies and procedures, federal and state policies
Supervise employees performing financial reporting, accounting, billing, collections, payroll, and budgeting duties
Conduct or coordinate audits of company accounts and financial transactions to ensure compliance with state and federal requirements and statutes
Develop and maintain relationships with banking, insurance, and non-organizational accounting personnel in order to facilitate financial activities
Monitor financial activities and details such as reserve levels to ensure that all legal and regulatory requirements are met
Accounts receivables and payables reconciliation
Perform accounting functions for the Agency, including General Ledger, A/P, Fixed Assets, Tax Compliance, A/R, budgeting (including short- and long-term forecasts) and investment analysis
(incl. Expansion and acquisition)
Acetylene Oxygen Company, Harlingen, TX 1/2009 – 7/2010
Staff Accountant
Sales tax preparation, journal entry, investment report, inventory, and Payroll Review
Compiled and analyzed financial information to prepare entries to accounts
Accounts receivables and payables reconciliation
Preparation of 941's and Unemployment Tax Reports
Reconcile Credit Card Sales on a monthly basis
Monitor banking activities on a daily basis to ensure deposits were made on a timely matter
Collaborate with the Controller to prepare Form 1120 U.S. Corporation Tax Return
Doctor's Choice Home Health, Brownsville, TX 6/2006 – 12/2008
Accountant (Part-Time Job held with Concurrent Full-Time)
Applied principles of accounting to analyze financial information and prepare financial reports
Compiled and analyzed financial information to prepare entries to accounts
Maintained Accounts Receivables, Payables, Payroll, Medical Billing and Inventory records
Produced reports for CPA firm for Annual Cost Report, Journal Entries and Bookkeeping
City Hall Port Isabel, Port Isabel, TX 3/2008 – 9/2008
Staff Accountant
Prepared federal, state and local tax returns of individual, business establishment and other organizations
Examined accounts and records
Sales tax preparation, journal entry, investment report, inventory, Payroll Review and Data entry
Assumed temporary responsibilities of the Finance Officer position
EDUCATION:
University of San Francisco MPA 12/2015
Bachelor of Business in Accounting, University of Texas 05/2007
Certified Notary Public: Commission expires 07/2014
SKILLS:
Project Based Management, QuickBooks, Excel including PivotTables and Macros, Strong in Access,
SQL, Peachtree, Elite, Sage, Lindsey, and Fund-EZ, Room Master, MACROS EZ
LANGUAGES:
Fluent in Spanish