Finance Revenue Management Intern
Current+ Analyzing 5+ client Hotel P&L statements in Excel to verify formulas and prepare tax reconciliations and presenting final reports to senior leadership+ Submitting and tracking 50+ business and utility tax invoices using FMS and RevQ to adjust incorrect penalties + Entering financial data for 100+ Hotels in Excel using VLOOKUP and creating Pivot tables to efficiently look for discrepancies in gross rent and tax deductions + Maintaining accurate and complete documentation of 100+ client tax returns to facilitate accounting and filing functions+ Investigating unclaimed property reports and collecting $100,000+ in property for various departments across City Hall+ Conducting research and analysis on tax code sections & regulations across 3 industries to categorize various fees from given financial reports