Amanda Laguna Email & Phone Number

Davis, Ca

-Accounts payables, accounts receivable, federal grant management and payroll administration-Used QuickBooks online and excel spreadsheets to track and monitor over 15 grants, including 5 federal grants-Advised managers and executives on best practices, and retroactively prepared workpapers for all 2018 grants during an audit where the organization had no findings or audit adjustments-Secured highly competitive Paycheck Protection Program loan in the first round of CARES act funding-Monitored unrestricted net assets to ensure available funds-Collaborated with executives and project directors to develop yearly and specific program budgets-Compared performance against budget to ensure that contractual, cost and schedule deliverables are met. -Identified financial or operating risks in any given grant, contract, -Created spreadsheets to track monthly FTE's and expenses-Filed required financial reports with federal entities managing grants-Prepare and review all expense reports for accuracy and proper disclosure-Prepare financial records and schedules as requested by independent auditors/tax preparers-Recommended to executives and implemented the creation of GANTT chart to successfully track grant deliverables, record metrics, and develop milestones-Led an all-staff grant deliverables training with an emphasis on objectives and key results -Created Excel spreadsheets with PIVOT tables to track both large and small donor information-Advised executives on best practices by creating cash flow projections in excel during a time with limited cash flow

-Provided back-office accounting and customer service on behalf of a consulting firm specializing in budget, compliance and fiscal services for charter schools-Coordinated full cycle AP and assisted finance department for 6 charter schools-Worked with finance staff on budgeting, including federal and state funding-Monthly bank and GL reconciliations of more than 10 bank accounts-Posted complex journal entries between a variety of restricted funds and resources-Created workpapers with high-volume data by using PIVOT tables and VLOOKUP features in Excel-Assist in financial forecasting for clients with cash-flow issues by accurately entering data in excel spreadsheets and balancing to accounting software-Coordinated remotely with client staff and vendors regarding payment approvals, purchase orders, receiving and payment status-Completed and filed various compliance reports including Use Tax and Property Tax Exemption reports-Advised clients regarding payables, best practices, policies, and procedures

-Quickly and accurately entered high volumes of transactions in QuickBooks-Monthly balance sheet account reconciliation-Sales tax and use tax returns-High volume 1099 and 571-L preparation and filing-Assisted CPA's in financial statement compilations using ProSystems software-Assisted CPA's by creating spreadsheets during audit preparation, income tax preparation, and in litigation requiring forensic accounting-Operated 10-key calculators to perform calculations and produce documents-Responsible for company A/R including posting daily company deposits and preparing and mailing company's monthly billing invoices and statements using ImagineTime software-Responsible for scanning and saving or filing all company files onto company server or storage database for company's paperless transition-Maintenance of client files, records, and procedures (including confidential personnel and legal records)-Performed general office duties such as filing, answering phones, and e-mail correspondence-Represented firm professionally in telephone, e-mail and in-person client visits and meetings.

-Responsible for training and management of 4 new hires-Fulfilled work orders by troubleshooting and servicing company software and local district applications-Operated as service point-of-contact for help-desk, directed calls to appropriate level of management, created work orders, and eased agitated users-Serviced computer equipment and software with updates as needed-Performed general office duties such as cleaning and maintenance of computer equipment

- Organized all paper accounting files to prepare for an audit and company paperless transition-Worked side by side with the CEO and Director of Members to coordinate promotions and order of service for the chamber's annual formal Gala with over 500 attendees-Used QuickBooks to assist bookkeeper in generation of all financial reports-Used QuickBooks to send out monthly invoices to members-Provided general office and administrative support

Accounting

Associate Of Science (A.S.), Accounting