Ayan Mondal

About Ayan Mondal

Finance and accounting professional with 7+ years of experience, currently working as a Property Management Accountant at CBRE. I specialize in financial reporting, reconciliations, and automation. At CBRE, I developed Lean tools using VBA macros to streamline key processes, reduce turnaround time, and enhance accuracy with built-in control checkpoints.Skilled in month-end close, budgeting, variance analysis, audit support, and tools like Excel VBA, Power BI, SAP FI, Tramps and Yardi. I’m focused on driving efficiency, ensuring compliance, and delivering value through data-driven insights and process improvements.

Experience

1. Senior Rtr Analyst

   CBRE Asia Pacific

   Jun 2024 — Present · Hyderabad, IN

   As a Property Management Accountant at CBRE, I specialize in delivering accurate financial reporting and process optimization for a portfolio of commercial properties. I have successfully implemented and developed Lean tools using VBA macros, automating manual and time-consuming processes. These tools introduced structured control checkpoints, enhanced data accuracy, and significantly reduced turnaround time. driving both efficiency and compliance within our operations.Key Responsibilities:• Drive process improvements through automation and system enhancements• Prepare and review monthly, quarterly, and annual property financial statements (P&L, balance sheet, cash flow).• Responsible for Client Review, Pre month-end checks, Pay-over of income to the clients, Rent Analysis, and Reconciliations such as - Bank, Non Recoverable expenses, Rent and Insurance.• Manage income and expense equalization processes in line with client agreements.• Collaborate with Client Accounting and on-site Property Management teams to ensure accurate budgeting, forecasting, and reconciliations.• Handle rent rolls, lease audits, and service charge reconciliations.• Monitor accounts payable/receivable and ensure proper allocation of revenues and expenses.• Ensure compliance with internal controls and SOX standards.• Act as a liaison between CBRE and clients for all finance-related queries.• Support the transition and onboarding of new properties, ensuring clean handover of financials.• Assist in audit preparation and resolve discrepancies proactively.

Education

• University of Calcutta

  Master's degree

  2015 — 2017

• Heramba Chandra College - India

  Bachelor of Commerce - BCom

  2012 — 2015