Accounts Payable Analyst

at  Pet Valu

Location: Markham, Ontario
Job Description:
What is the role?
In this role you will be directly supporting the Manager, Non Trade 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) and the Company’s bank portal.

What will you do?

• Review and upload third party vendor files. Analyze them for accuracy, completeness and resolve any issues that are identified.
• Generate month end and year end journal entries and expense accruals
• Support auditor queries and provide support for control testing as requested by internal audit.
• Produce month end reconciliations with appropriate analysis. Work issues through to satisfactory resolution while ensuring reconciliations are accurate and kept up to date.
• 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.
• Support manager in oversight/supervision of other team members/tasks as required
• Develop and maintain various excel files to support AP processes
• Review 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 on ad hoc projects and analysis as required

What will you need to succeed?

Education and Experience:

• College or university degree in finance, accounting or math
• 1-2 years of experience in financial analysis, or AP

Knowledge and Skills:

• Experience using MS Office suite of products including Outlook, Word, & Excel
• Strong Excel skills including pivot tables, v-lookups and ability to determine best way to create files based on data and analysis needed
• Exceptional interpersonal skills highlighted by excellent verbal and written communication skills
• A team player who is adaptable and has the ability to work independently
• Organized with attention to detail

• Review and upload third party vendor files. Analyze them for accuracy, completeness and resolve any issues that are identified.
• Generate month end and year end journal entries and expense accruals
• Support auditor queries and provide support for control testing as requested by internal audit.
• Produce month end reconciliations with appropriate analysis. Work issues through to satisfactory resolution while ensuring reconciliations are accurate and kept up to date.
• 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.
• Support manager in oversight/supervision of other team members/tasks as required
• Develop and maintain various excel files to support AP processes
• Review 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 on ad hoc projects and analysis as require