Lcbo Ar Administrator

**LCBO AR Administrator - Contract**:

- Requisition ID: 816- Location: Bolton, Ontario, Canada, L7E 3A9- Job Type: Full-Time**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 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 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 for the LCBO wholesale 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

**Deadline to Apply**:
**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.

**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