Yate Supplies are a family run company who provide a one stop shop to the hospitality and catering industry. Trading for over 40 years, we provide our customers with over 25,000 food packaging, janitorial and catering products. The customer is at the heart of everything we do, and we are renown in the industry for our excellent service and management of bespoke printed food and drink packaging. We send products all over the UK, mainly on our own vehicles and provide a unique service (especially in central London) by delivering our customers’ orders at night for minimal operational disruption for our end user.
We are currently recruiting for a Sales Ledger Controller on a permanent basis based in Yate, Bristol.
The role is 37.5 hours a week, 09:00 - 17:00 hrs , Monday to Friday with a half hour unpaid break.
The salary range for the role is £24,784.50 - £26,000 per annum, depending on experience.
We also offer 24 days holiday plus bank holidays that increases with service, Birthday Gift, Salary Sacrifice Pension Scheme, Medicash Scheme, Staff discount scheme and increased family leave.
Key Objectives:
· To complete Sales Ledger tasks
· To offer support to the Finance Manager and wider team as required
Key Responsibilities:
· Complete routine tasks including: daily invoice runs, daily cash receipts allocations, processing rebate, export invoices and other ad-hoc invoices, processing credit card and cash transactions
· Run range of Excel statement reports, including ODBC and Profit Plus Reporting
· Manage the baling process
· Manage Sales Order Status report
· Manage invoicing through EDI portals (Acquire, Procure Wizard, Coupa) and handling queries
· Assist with clearing outstanding items on the RBS bank reconciliation
· Match daily bank transactions with nominal
· Complete month-end activities ensuring all working sheets are up-to-date and accurate as well as running all relevant reports
· Carry out regular credit control activities ensuring that debt is collected within terms and liaising with the Sales reps where necessary
· Maintain the Sales Ledger including creating new customer accounts and regularly reviewing the ledger for any errors / old transactions
· Monitor the Accounts inbox and respond to emails and queries in a timely manner
· Maintain the highest levels of customer service to all customers both external and internal
· Handling phone calls
· Provide cover for Purchase Ledger when required
· Be flexible and support other departments during busy periods, as agreed with the Finance Manager
· Assist with the year-end audit
Key Skills / Qualities:
· Attention to detail
· Competent Excel and MS Office package user
· Ability to manage own workload and prioritise tasks
· Take ownership of tasks and be proactive when dealing with any queries including liaising with the relevant department to seek quick resolution
· Ability to escalate and seek solutions
· Great customer service skills
· Able to work under pressure and deal with difficult situations / customers
· Team player
Job Types: Full-time, Permanent
Pay: £24,784.50-£26,000.00 per year
Benefits:
- Company events
- Company pension
- Employee discount
- Enhanced maternity leave
- Enhanced paternity leave
- On-site parking
Application question(s):
- Which of the following Excel functions/features are you confident using independently? Please select all that apply and provide examples where appropriate:
☐ SUMIF / SUMIFS
☐ IF statements
☐ VLOOKUP / XLOOKUP
☐ Pivot Tables
☐ Other Excel functions/features – please specify
- This role involves daily transaction processing, Excel reporting, reconciliations and month-end deadlines. Please describe your level of Excel experience and give an example of how you have used Excel to identify, investigate or resolve an error or discrepancy.
- How much experience do you have working within a Sales Ledger or Accounts Receivable function, including invoicing, cash allocation, credit control and maintaining customer accounts? Please briefly outline the systems/processes you have worked with.
Work Location: In person
