Motivated and dedicated Staff Accountant with over three years of experience in month-end closings, bank reconciliations, and balance sheet account reconciliations; A proven ability to create Microsoft Excel macros through Visual Basic for Applications (VBA) to automate routine tasks, and a strong background in property management accounting and wholesale petroleum distribution accounting
Staff AccountantOct 2018 – Present Western National Property Management
Managing a portfolio of around thirty apartment communities and being responsible for cash management, review of vacancy loss, delinquencies and prepaid rent applications, resident refund and bank reconciliation, and monthly financial statement preparation (trend operating reports, budget variance reports, and balance sheets) for these sites
Accounts Payable AssociateJun 2018 – Oct 2018 International Education Corporation
Processed an average of 800 invoices to ensure that the accounts payable aging balance stayed at around $3 – $4 million every month, performed weekly check runs, and reviewed monthly vendor statements to investigate and resolve unknown invoices
General Ledger AssociateMar 2017 – Jun 2018 IPC (USA), Inc.
Prepared month-end closing journal entries (accrual, reclassification, payroll, depreciation, amortization, and other adjusting entries), reconciled key balance sheet accounts to their supporting schedules, and recorded miscellaneous cash receipts
Doctor of Business AdministrationMar 2018 – Apr 2021 (Anticipated) Westcliff University
Master of Science in AccountancyJanuary 14 – Dec 2016 California State University, Fullerton
Bachelor’s Degree in Business AdministrationSep 2009 – Jun 2013 University of Economics, Ho Chi Minh City
Western National Property Management
Streamlined month-end closing processes by making Excel macro-enabled workbooks to post miscellaneous cash receipts and disbursements to Yardi Voyager
IPC (USA), Inc.
Reduced the amount of manual data entry substantially by building a standard procedure for integrating data from Excel worksheets to Microsoft Dynamics GP (Great Plains)
Enhanced the company’s bonus plan for regional managers by creating Excel workbooks with macros to allocate overhead costs among profit centers and adding tabs to the Excel Ribbon with buttons and menus to execute the macros
Redesigned the employee expense reimbursement form to secure a 30% reduction in accounts payable processing and payment times and facilitate the audit process