Tuong Dao

Motivated and dedicated Accountant with four 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, retail insurance, and wholesale petroleum distribution accounting

Email: tuongdao@outlook.com

LinkedIn: linkedin.com/in/luckystar

Experience

June 2020 - Present

Staff Accountant, Confie Administrative Services, Inc.

Huntington Beach, California

Managing general ledger tasks for over twenty retail insurance stores in three different states, including:

  • Preparing monthly journal entries (e.g., accrual, prepaid amortization, expense allocation, deferred rent, reclass entries) in accordance with U.S. GAAP

  • Preparing reconciliations of all balance sheet accounts

  • Analyzing financial reports and providing comments on uncommon or remarkable variances from previous periods and forecast

October 2018 - June 2020

Property Accountant, Western National Property Management

Irvine, California

Managed a portfolio of thirty apartment communities and is responsible for cash management, month-end journal entries, monthly financial statement preparation, and general ledger account reconciliation for these sites

Before monthly closings of account receivables, the following reports for the assigned communities were reviewed

  • Reviewed gross potential rent reports to ensure that market rent, potential rent, and vacancy loss are calculated accurately

  • Reviewed tenant ledgers to verify that all charges and rent payments were posted correctly and promptly by community managers

  • Reviewed accounts receivable aging reports for delinquencies to confirm that the balance of past tenants has been collected

For month-end closings, the following tasks were performed

  • Booked miscellaneous cash receipts and reimbursements such as laundry income, vendor rebates, telephone commissions, loan payments, etc.

  • Booked recurring journal entries such as depreciation/amortization and accrual entries

  • Analyzed general ledger and budget variance report to ensure that all revenues and expenses tied to the budget amounts and that it is coded to the correct general ledger accounts

  • Analyzed trend reports and balance sheets to identify any general ledger accounts that had unusual net changes and made comments about them to submit to the controller for review

After month-end closings, the following reconciliations were performed for the assigned communities

  • Performed monthly bank reconciliations between bank accounts and general ledger cash accounts for assigned apartment communities

  • Performed resident refund reconciliations to make sure that security deposit dispositions were done properly by on-site managers and that refund checks were processed by the accounts payable team

Prepared monthly and quarterly ownership distributions

Monitored daily cash balances and set up wires to transfer funds between bank accounts when necessary

Assisted with annual budget formations

June 2018 - October 2018

Accounts Payable Associate, International Education Corporation

Irvine, California

Processed an average of 800 invoices to ensure that the accounts payable aging balance stayed at around $3 - $4 million every month

Matched vendor invoices with purchase orders

Obtained approval for invoices that had no purchase orders

Performed weekly check runs

Applied payments and credit memos to open invoices

Requested and maintained W9 forms to set up new vendors

Reviewed monthly vendor statements to investigate and resolve unknown invoices

For month-end closings, accrued for invoices that came in after accounts payable closed for the month

March 2017 - June 2018

General Ledger Accountant, IPC (USA), Inc.

Santa Ana, California

Prepared month-end closing journal entries, including

  • Accrual entries to accrue for recurring revenues and expenses (interest expenses, audit fees, sublease revenues, etc.)

  • Reclassification entries to reclassify the used portion of prepaid expenses to expenses

  • Payroll entries to record salary expenses, 401k, payroll tax, and other payroll liabilities

  • Depreciation entries to depreciate fixed assets

  • Other adjusting entries as needed

Reconciled key balance sheet accounts to their supporting schedules, including bank reconciliations, fixed assets, prepaid expenses, notes receivable, long-term debts, allowance for bad debts, etc.

Processed selling, general and administrative (SG&A) invoices that are not handled by accounts payable team (invoices that are not related to cost of goods sold (COGS), e.g., office supplies, utilities, outside services, legal invoices, etc.)

Recorded cash receipts that the accounts receivable team did not handle, such as tax refunds, insurance premium benefits, notes receivable payments, etc.

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

Enhanced the company’s bonus plan for regional managers by creating Excel workbooks with macros to allocate overhead costs among profit centers

Redesigned the employee expense reimbursement form to secure a 30% reduction in accounts payable processing and payment times and facilitate the audit process

Education

January 2014 - December 2016

Master of Science in Accountancy, California State University, Fullerton

September 2009 - June 2013

Bachelor's Degree in Business Administration, University of Economics, Ho Chi Minh City

Skills

Interpersonal

Organized, analytical, detail-oriented, time-management, multi-tasking, and communication (verbal and written)

Technical

Proficient with Microsoft Office (Word, PowerPoint, Outlook), especially Excel

  • Efficient at applying important functions (VLOOKUP, SUMIF, IF, AND, OR, DATEDIF, INDEX, MATCH, CONCATENATE, PIVOT TABLES, etc.) to perform accounting duties

  • Capable of utilizing XML and VBA knowledge to create macros to automate repetitive tasks and add tabs to the Excel Ribbon with buttons and menus to execute the macros

Experienced with Microsoft Dynamics GP, Acumatica, Sage MAS 500, and Yardi Voyager

Lanuages

Bilingual in English and Vietnamese