Tuong Dao

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, wholesale petroleum distribution accounting, and retail insurance accounting

Experience

Staff Accountant

Jun 2020 - Present Confie Administrative Services, Inc.

Managing general ledger tasks for over twenty retail insurance stores in three different states, including preparing monthly journal entries and reconciliations of all balance sheet accounts, analyzing financial reports, and reporting on uncommon or remarkable variances from previous periods and forecast

Property Accountant

Oct 2018 – Jun 2020 Western National Property Management

Managed a portfolio of thirty apartment communities and been responsible for reviewing delinquency reports and vacancy loss reports, performing resident refund reconciliations and bank reconciliations and preparing monthly financial statements (trend operating reports, budget variance reports, and balance sheets) for these sites

Accounts Payable Associate

Jun 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 Accountant

Mar 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

Achievements

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

Education

Doctor of Business Administration

Mar 2018 – Dec 2021 (Anticipated) Westcliff University

Master of Science in Accountancy

January 14 – Dec 2016 California State University, Fullerton

Bachelor’s Degree in Business Administration

Sep 2009 – Jun 2013 University of Economics, Ho Chi Minh City

Language Skills

Vietnamese

English

Computer Skills

Microsoft Excel

Visual Basic for Applications (VBA) for Office

Web Design