Accounts Payable Analyst (Contract)

Location: Markham, OntarioJob DescriptionWhat is the role?In this role you will be directly supporting the Manager, Accounts Payable in performing analysis and reconciliations, supporting controls and performing additional duties as required. You will do this using Microsoft Navision (GL), the Concur portal (employee expense submissions), Odiss (invoice portal) and the Company’s bank portal. Additionally, collecting, logging, validating and communication with all parties relating to EFT setups, plus other tasks related to payment support.What will you do? Review and upload third party vendor files. Analyze them for accuracy, completeness and resolve any issues that are identified.Work with the utility invoice management provider to ensure accurate files are provided on a regular basis and upload them into NAV. Assist with pulling invoices from the utility and telecom portalsAssist with store change tracking and updates to ensure vendors are paid and coding is accurateGenerate month end and year end journal entries and expense accruals Support auditor queries and provide support for control testing as requested by internal and external audits including EFT setup and payments.Produce month end reconciliations with appropriate analysis. Work issues through to satisfactory resolution while ensuring reconciliations are accurate and kept up to date (including aging, GRNI, adoptions, etc)Ensure appropriate approval and coding is in place for non trade invoices. Process select AP vendors as needed. Process payments via wire, EFT/ACH or cheque.Prepare & follow up on vendor credits to ensure timely application to payments and/or collection.Generate employee expense summaries and monthly accruals. Process claims in the Concur portal, follow up and resolve issues. Timely completion of the monthly Concur reconciliation.Collect, log and validate EFT information for the purpose of setting up EFT accounts into NAVISION which will directly link with our XML payment process Due diligence required to ensure EFT information is collected from a reputable source and inputted information is valid and accurate to avert fraudulent activity.Provide accurate updates and metrics on the EFT status at requested timeAssist with manual wire setups and wire portal banking information upkeepAssist with review of the Odiss portal to help flow the invoices with exceptions to NAVMonitor the Accounts Payable invoice folders, mailbox and email inboxes daily for incoming invoices.Support manager in oversight/supervision of other team members/tasks as requiredDevelop and maintain various excel files to support AP processes using pivot tables and vlookupsReview existing processes and continuously look for efficiencies/improvements.Ensure timely response to both internal and external customer and vendor requests, developing strong relationships with all groups.Assist with entering invoices into NAV as requiredAssist on ad hoc projects and analysis as requiredWhat will you need to succeed?Education And ExperienceCollege or university degree in finance, accounting or math1-2 years of experience in financial analysis, or Accounts PayableKnowledge And SkillsExperience using MS Office suite of products including Outlook, Word, & ExcelStrong Excel skills including pivot tables, v-lookups and ability to determine best way to create files based on data and analysis neededExceptional interpersonal skills highlighted by excellent verbal and written communication skillsA team player who is adaptable and can work independentlyOrganized with attention to detail#INDS