LCBO AR Administrator - Contract
Bolton, Ontario, Canada, L7E 3A9
Who We Are
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 Contact 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 Manager, Brewer Accounting. This is a 12-month, Full-Time Contract opportunity. This position is responsible for the timely reconciliation of financial transactions with the Liquor Control Board of Ontario (LCBO), which serves as the wholesaler for all convenience and grocery store customers of The Beer Store. 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 Remote/Hybrid Flex work with visits into the office on an as-needed basis depending on their role and function.
What You'll Be Doing
- Reconcile and isolate discrepancies with the LCBO for the outstanding balances of individual LCBO retail stores, grocery stores, and convenience stores based on the monthly AR aging report
- 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
- Create journal entries and load 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
We are 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 provide employment accommodation in accordance with provincial 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.
