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
Staff AccountantJun 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 AccountantOct 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 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 AccountantMar 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
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