Lease - CAM Reconciliation

Reconciliation/YEB/Estimate Calculations

• Lead the end-to-end Reconciliation process for assigned properties/portfolios.
• Thoroughly review Agreements & LA, to understand Additional-Rent clauses, exclusions, CAPs, Gross-up, AF & MF, provisions, and Pro-rata share calculations for each tenant.
• Gather and analyze actual operating expenses from the General Ledger, Verifying Invoices, Receipts, and other financial records related to Additional Rent.
• Prepare detailed Reconciliation, comparing estimated tenant payments against actual expenses.
• Calculate and process true-up adjustments.
• Ensure all Recon calculations comply with Lease terms, Accounting Standards.
• Deep Data Validation & Analysis is must skill
• Collaborate with Lease Admin and Property Management teams to ensure accurate Results.
• Identify opportunities to streamline and improve Year-end billing and Reconciliation processes for greater efficiency and accuracy.
• Assist in developing and updating standard operating procedures (SOPs) related to billing and reconciliation.
• Support audit and review requests from tenants or third-party auditors.
• Maintain detailed workpapers, documentation, and audit trails.
  

Qualifications

• Bachelor’s degree preferred
• 3+ years of progressive experience in Reconciliation & YEB and Estimate calculation.
• Technical Skills –
• Proficient in MS-Excel
• Experience with property management software is plus
• Excellent written and verbal communication skills, with the ability to explain complex financial information clearly
• Highly organized with the ability to manage multiple priorities and meet tight deadlines in a fast-paced environment.
• Review and provide feedback on complex Reconciliations/YEB/Estimate calculations end to end.
• Perform in-depth quality control checks on calculations, data integrity, and supporting documentation.
• Act as a key liaison and subject matter expert for internal and external Teams.
• Provide insights and recommendations based on reconciliation outcomes to inform budgeting and forecasting processes.
• Soft Skills
• Team-building skills, with a proven ability to motivate, develop, and manage a team
• Good Communication with interpersonal skills
• Proactive and results-oriented mindset