Financial Analyst

Description

The key elements of the Financial Analyst role include: reviewing franchise billing transactions, investigating franchise billing inquiries and performing month end duties and analysis. The incumbent acts as backup for the department supervisor and other staff as needed. The Financial Analyst will be required to maintain good relationships with the franchisees and with internal teams. The Financial Analyst will work with Store Operations, IT and other internal departments to troubleshoot system issues and resolve franchisee inquiries.

The position calls for excellent Excel skills where the individual is able to handle high volumes of data. The ability to meet departmental deadlines including daily billing generation, month-end reports, reconciliations and other time-sensitive work is essential.

• Review daily franchise billing transactions, including reimbursements to stores, leasing chargeback and other store related expenses chargeback
• Upload franchise billing transaction batches and run franchise billing jobs
• Updating store card for new store set up
• Monitor daily error logs and franchise billing summary reports to identify and troubleshoot any transmission errors
• Prepare promotion credits to stores, follow up with internal team to resolve any discrepancies or variances from franchisees’ inquiries.
• Monitor weekly Gift Card Settlement and follow up as needed
• Coordinate investigations into Franchise Billing inquiries

• Prepare various month end journal entries and accruals
• Run queries in MS Access to prepare:
  Ecommerce transaction accrual, vendor billbacks; month end accruals including royalty and percent rent income; and prepare applicable franchise billing chargebacks
• Prepare reimbursements for franchise stores via franchise billing
• Reconcile various GL Accounts and resolve discrepancies

• Ensure the maintenance of a strong control environment
• Identify process improvements
• Act as a backup for the Senior Financial Analyst and support Billing Clerks as required.
• Other ad hoc projects as assigned

• Bachelor’s Degree in Accounting or Finance
• Working toward CPA designation is preferred but not mandatory
• 2-3 years Accounting or Finance working experience
• Previous experience with month-end process (reconciliations, accruals and journal entries)
• Previous experience in retail environments or exposure to franchise billing desirable

• Strong IT skills essential– Access, excel (v-lookup, pivot tables)
• Accounting and financial analysis skills
• Exposure to Microsoft Navision or other ERP system an asset
• Excellent organizational and problem solving skills
• Must be able to work in a fast-paced environment and meet deadlines
• Able to work well independently and as part of a team
• Strong communication and interpersonal skills