LCBO AR Administrator - Contract

The Beer Store; Ontario; Hybrid; CAD 50,000 - 70,000; Full time

Job summary

The Beer Store is seeking a full-time LCBO AR Administrator for a 12-month contract in Bolton, ON. This role involves reconciling financial transactions, addressing discrepancies in payment data, and collaborating with various stakeholders. Candidates should possess a strong background in finance or accounting and excel in data reconciliation tasks.

Benefits

Health benefits program

Employee & family assistance program

Recognition programs

Casual dress environment

Summer hours

Qualifications

• Minimum 3 years experience with data mining, reconciliation, or analytics.
• Post-secondary degree in Accounting or Finance required.
• Preferred finance background and strong Excel skills.

Responsibilities

• Reconcile financial transactions with the LCBO.
• Investigate discrepancies in delivery and payment data.
• Manage accounts receivable collections and resolve issues.

Skills

Excel

Data reconciliation

Data analytics

Communication

Analytical skills

Organizational skills

Education

Post-secondary degree in Accounting or Finance

Tools

SAP

Job description

Press Tab to Move to Skip to Content Link

Select how often (in days) to receive an alert:

Becoming experts on beer doesn't happen overnight - we've been in business since 1927 and today, The Beer Store is the primary distribution and sales channel for beer in Ontario and is owned by 30+ Ontario-based brewers! Through our Retail Stores, Distribution Centres, Draught Services, Customer Experience Centre, and our Corporate Office, we form one large team that is passionate about the beer business. The Beer Store is proud to foster a respectful and inclusive culture that expands and leverages the diverse talents, experiences, and perspectives of our team members to deliver exceptional service for our customers. We continue to be successful by working together, respecting each other, having a positive attitude and by trying new and innovative ideas. Not only are we knowledgeable, passionate, and loyal ambassadors for beer, we’re also health and safety advocates, environmental champions, DEIB enthusiasts and we give proudly back to our communities.

The Role

We are currently searching for an LCBO AR Administrator, reporting to the Supervisor, AR LCBO Wholesale. This is a12-month, full-time contract opportunity. This position is responsible for timely reconciliation of financial transactions with the Liquor Control Board of Ontario.The role involves identifying and resolving discrepancies between delivery and payment data, coordinating with various stakeholders to address issues, and managing accounts receivable collections for outstanding payments.

Location

Our Corporate Office is located in Bolton, ON. We offer a hybrid work model with visits into the office a minimum of twice per week and on an as-needed basis depending on the role and function.

What You'll Be Doing

• Reconcile and isolate discrepancies for the individual LCBO store outstanding based the monthly AR aging.
• Investigate and analyze the root cause of discrepancies between delivery data and payment data – pricing vs quantity etc.
• Coordinate adjustments with operational centers
• Monitor collection and payment status with LCBO and obtain issue resolution in a timely manner
• Validate the weekly LCBO variance files and provide the required documentation to the LCBO
• Fulfill LCBO POD requests
• Work with LCBO to resolve past due accounts receivables
• Match and clear payments to AR open items - SAP billing documents with payments and adjustments
• Ensure accuracy and integrity of AR data, payment postings and adjustments
• Raise tickets for system errors regarding SAP billing documents and payment posting
• Process billing of invoices for miscellaneous LCBO activities
• Provide weekly reconciliation status report to management
• Creating journal entries and loading into SAP
• Provide internal and external auditor requirements and assist in supporting the audits as needed
• Back up support for other roles within Brewer Accounting especially daily payment processing
• Perform other related duties and projects as assigned
  

Who You Are - Your Knowledge, Skills & Experience

Education

• Post-secondary degree in Accounting or Finance

Experience

• At least 3 years experience with high volume data mining, data reconciliation, or data analytics
• Past finance background is preferred

Skills

• Strong skills using Excel, creating and working with complex worksheets
• Experience in ERP accounting systems such as SAP is an asset
• Excellent levels of communication both verbal and written
• Quick learner, with ability to maneuver and cope with dynamic working environments
• Excellent analytical and organizational skills
• Capable of managing time effectively, working both independently and collaboratively as part of a team
• Capacity to manage high volume of transactions and data
• A proven results-oriented track record for problem solving and issue resolution in a timely manner
• Ability to work outside the normal hours during month-end and other peak periods

What We Offer

Our success as an organization is a result of our commitment to our greatest strength…our people! We believe that any opportunity we can provide to help further your career growth and development is an investment in not only your individual success, but our overall success as a business.We work to recognize you in meaningful ways including a competitive compensation, a health benefits program, employee & family assistance program, recognition programs, hybrid work arrangement, summer hours, employee special offers, and a casual dress and work environment.

*Benefits and perks are dependent upon role and status and are subject to change at the sole discretion of the company.

Equal Opportunity Employer

Weare committed to providing a respectful and empowering workplace that values our greatest resource, our people. Diversity, Equity, Inclusion & Belonging are essential components of our culture that empower us to meet the needs of our employees, customers and communities. We welcome applicants from all backgrounds including racialized persons / persons of colour, women, Indigenous / Aboriginal People of North America, persons with disabilities, 2SLGBTQIA+ persons, and any other characteristic. We’re an equal opportunity employer and provideemployment accommodation in accordance withprovincial legislation.If contacted for an employment opportunity or testing, please advise Human Resources if you require accommodation at any stage of the recruitment process.

We genuinely thank you for your interest in this opportunity with us. Due to the high volume of applications we receive, only applicants selected for an interview will be contacted.