Financial Analyst

Pet Valu Canada Inc.
Competitive salary
16 Sep 2020
17 Sep 2020
Location: Markham, Ontario

Job 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
  • Upload franchise billing transaction batches and run franchise billing jobs
  • Monitor daily error logs and franchise billing summary reports to identify and troubleshoot any transmission errors
  • Prepare vendor billbacks, communicate with vendors and resolve any discrepancies or variances
  • Monitor weekly Gift Card Settlement and follow up as needed
  • Coordinate investigations on Franchise Billing inquiries

Month End Duties:
  • Prepare various month end journal entries and accruals
  • Run queries in MS Access to prepare: monthly loyalty report for stores reimbursement; vendor billbacks; month end accruals; expired goods claims report; monthly Store Donation Report and prepare applicable franchise billing chargebacks
  • Prepare reimbursements for franchise stores via franchise billing
  • Reconcile various GL Accounts and resolve discrepancies
  • Run query in MS Access to prepares Monthly Store Donation Report and prepare applicable franchise billing chargeback

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

What will you need to succeed?

Education and Experience
  • Bachelor's Degree in Accounting or Finance
  • Working toward CPA designation is preferred
  • 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

Knowledge and Skills
  • 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

Similar jobs

Similar jobs