Accounting Services Coordinator

SUMMARY:
The prime purpose is to verify and analyze EDI transmission discrepancies and manually process necessary payments to vendors. Audit and process manual Expense and non EDI vendor payments for Direct to Stores and DC deliveries. Process manual cheques, direct deposits, manual billings, cheque clearing, account reconciliation, journals and Pharmacy charge account application control.

SPECIFIC RESPONSIBILITIES:

• Update and upload weekly journal to clear accounts.
• Balance accounts payable accruals for period end reporting. Prepare & process required journals.
• Monitor and analyze SAP IDOC reports processing required adjustments to release invoices for payment to vendors.
• Process store charges and payments to vendors using Company Policies and Procedures for APCA, EUMR, MCMA, ADON for Direct to Store, Distribution Center and Expense.
• Review and respond to vendor and customer inquiries on the Metronet daily.
• Investigate and reply to any inquiries from both the vendors and the stores regarding EDI or manual billings processed in error.
• Communicate technical errors to vendors and advise them accordingly – to retransmit or to contact Metro IT.
• Ensure compliance for the two signature policy for Expense payments and for employee expenses to SAP Concur.
• Record cheques received in Daily Bank Deposit Register and prepare Bank Deposit Slip with Cheques.
• Reconcile and clear cheques.
• Reconcile direct deposits received weekly with supporting documents and email the Consolidated Weekly Direct Deposits schedule to Pharmacies.
• Reconcile weekly BDMS pharmacy sales as per the Pharmacy charge account Summary and journalize required adjustments.
• Update Pharmacy detail workbook with data from the weekly charge account summary and upload journals to book line details for charges, cheque deposits and adjustments.
• Upload various journals including Pharmacy unbilled commercial terms and estimated coupon loss.
• Create manual billings which are supported with appropriate documentation as requested.
• Ensure 52-109 compliance as applicable to your area of responsibility.

QUALIFICATIONS:

• College diploma or University studies in finance/accounting
• 1-3 years related accounting experience
• Intermediate knowledge of MS Office. Ability to extract, export and manipulate data from various sources into Excel Workbooks.
• Requires knowledge of SAP, BDMS, Sweda, Miro, MMS, AS400.
• Capability to work in a highly computerized environment and meet deadlines.
• Ability to analyze discrepancies between vendor invoices, store acknowledgments and purchase orders as per Company Policies and Procedures.
• Requires strong analytical skills, ability to analyze and handle GL accounts.
• The skill to multitask is required. Must be able to prioritize multiple tasks, handle strict and urgent deadlines, and meet regular deadlines.
• Detail oriented and the ability to work independently is essential.
• Excellent communication skills, both written and verbal.

RELATIONSHIPS:

• Internal – Store Operations, Merchandising, Operations, Finance, Margin Matching Accounting
• External – Suppliers, Customers

#LI- Hybrid