William Grant & Sons
Financial Planning & Reporting Analyst
November 2011 — June 2013
Managed and analyzed $46 million North American (United States, Canada, and Mexico) budget for bottling and warehouse facility for wholly owned American subsidiary of award-winning independent family distillery headquartered in the United Kingdom.
Prepared monthly income and expenses reports for executive team review.
Reconciled monthly expenses to transactional, reporting, and budget databases, reviewing, researching, and correcting errors and write-offs.
Reconciled 246 U.S.-based employees’ compensation on monthly basis with U.S. human resources and UK headquarters to identify variances against budget; included tracking new hires, terminations, open positions, and interdepartmental transfers.
Reviewed departmental budgets to identify risks and opportunities, and audited travel and entertainment costs by employee with explanations for possible overspends.
Modernized monthly intercompany salary billing for 15 U.S.-based UK employees, updating process to linked Excel workbooks to decrease manual input and allow invoices to be sent via secured files to UK counterparts.
Prepared intercompany overhead report that included tracking royalties and miscellaneous expenses for UK offices.
Documented step-by-step instructions for all job functions (headcount reconciliation, invoicing, journal entries, travel and entertainment reporting, and accruals) to facilitate cross training.