Sales Tax Analyst
CurrentEquity LifeStyle Properties, a leading operator of residential and vacation communities across North America, I managed tax compliance and general ledger accuracy across numerous properties, ensuring precision through advanced data analysis.Data Analysis & Reporting• Analyzed large datasets of financial information for over 200 properties using advanced Excel functions (e.g., Pivot Tables, VLOOKUP, SUMIFS) to ensure accurate tax calculation, revenue tracking, and financial reporting.• Investigated variances between tax collected and reported, identifying and resolving discrepancies through detailed data analysis.Financial Reconciliation & Journal Entries• Reconciled monthly tax payable accounts and reclassified journal entries to accurately allocate revenue, expenses, and adjustments, achieving 100% accuracy in month-end reporting and enhancing data flow into financial statements through close collaboration with accounting.Tax Filing & Compliance• Gathered and reviewed monthly, quarterly, and annual tax data to compute tax due across multiple state and local taxing authorities.• Filed sales tax returns prepared in-house, ensuring accuracy and timely submission to the appropriate taxing authorities.Process Improvement & Coordination• Coordinated and improved sales tax data procedures for both outsourced and in-house filings, enhancing process efficiency and accuracy.Tax Audit Assistance• Assisted with sales tax audits by gathering and reviewing purchase invoices, pulling reports such as trial balances, general ledger downloads, and queries.Research & Tax Advisory• Monitored, researched, and answered sales tax notices, ensuring timely and accurate resolution.
