Created monthly reconciliation spreadsheets on excel programmed with VLOOKUP, SUMIF, TRUE/FALSE statements, mathematical formulas, color-coding, and locked in cells.
- Maintained and reconciled trial balance and balance sheet accounts for 10 different properties in development with a combined asset value of over $500 million
- Performed review and analysis of budget vs. actual variance in the monthly financial package and presented recommendations on critical balance sheet and income statement line items.
- Performed ad-hoc analysis assignments such as using pivot tables to summarize debt information for over 100 different properties in development
- Maintained accurate records of development progress by creating debt amortization and interest expense schedules on excel that reconciled with the GL and bank statements
- Prepared work papers for first year audits, financial statements, and construction loan closes with an combined asset value of over $100 million
- Worked directly with Asset Managers, Project Managers, and Financial institutions in conducting monthly draw process, monitoring project budget and forecasting future expenses
- Managed all aspects of project monitoring including detailed journal entries, expense accruals, GL accounting, and account analysis as part of monthly close