Accounts Payable Analyst (Contract) na Petvalu

Job Description:

What 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 portals
• Assist with store change tracking and updates to ensure vendors are paid and coding is accurate
• Generate 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 time
• Assist with manual wire setups and wire portal banking information upkeep
• Assist with review of the Odiss portal to help flow the invoices with exceptions to NAV
• Monitor the Accounts Payable invoice folders, mailbox and email inboxes daily for incoming invoices.
• Support manager in oversight/supervision of other team members/tasks as required
• Develop and maintain various excel files to support AP processes using pivot tables and vlookups
• 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 with entering invoices into NAV as required
• 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 Accounts Payable

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 can work independently
• Organized with attention to detail

#INDS