Description
What is the role?
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.
What will you do?
Daily Duties :
- 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
Month End Duties :
Prepare various month end journal entries and accrualsRun 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 chargebacksPrepare reimbursements for franchise stores via franchise billingReconcile various GL Accounts and resolve discrepanciesOther :
Ensure the maintenance of a strong control environmentIdentify process improvementsAct as a backup for the Senior Financial Analyst and support Billing Clerks as required.Other ad hoc projects as assignedWhat will you need to succeed?
Education and Experience
Bachelor’s Degree in Accounting or FinanceWorking toward CPA designation is preferred but not mandatory2-3 years Accounting or Finance working experiencePrevious experience with month-end process (reconciliations, accruals and journal entries)Previous experience in retail environments or exposure to franchise billing desirableKnowledge and Skills
Strong IT skills essential– Access, excel (v-lookup, pivot tables)Accounting and financial analysis skillsExposure to Microsoft Navision or other ERP system an assetExcellent organizational and problem solving skillsMust be able to work in a fast-paced environment and meet deadlinesAble to work well independently and as part of a teamStrong communication and interpersonal skills