Role Overview
A beverage distribution firm active in the Kenyan on-trade, off-trade and HORECA markets is looking for an analyst to keep its customer collections healthy and its financial reporting automated. You will work alongside the Finance Manager to chase outstanding invoices, set credit limits on new accounts and turn Sage/Excel data into clear debtors' dashboards and monthly statements. The role matters because steady cash flow keeps the business running, while accurate systems help management act quickly on overdue accounts and risk trends.
Key Responsibilities
- Maintain a close watch on outstanding balances and actively chase overdue amounts across pub, retail and hospitality accounts through calls, emails and face-to-face visits.
- Evaluate new and existing customers for creditworthiness, then propose appropriate limits and payment conditions that protect the debt-to-sales ratio at 25% or lower.
- Prepare monthly customer statements and debtors' summaries, making sure reconciliations are exact and that all bank and M-Pesa receipts are matched in Sage.
- Investigate and resolve billing queries or contra entries, and prepare documentation for legal action when a customer refuses to pay.
- Authorise or block sales loadings by checking live debt positions, and support management in deciding when to place a customer on stop-supply.
- Build efficient Excel workflows using Power Query, PivotTables and XLOOKUP/INDEX-MATCH so recurring reports no longer depend on manual copying.
- Keep the customer master file clean by removing duplicates and orphan records, and improve Sage report configurations to produce accurate financial extracts.
- Run monthly DSO and ageing analyses, categorise customer risk, and coordinate quarterly debtor confirmations with clients.
Requirements & Qualifications
- Bachelor's degree in commerce, finance, accounting, economics or statistics.
- CPA(K) qualification or active progress through CPA/ACCA examinations.
- A minimum of three years of practical experience in credit control, accounts receivable or finance analytics, ideally within FMCG, distribution or beverage trade.
- Strong hands-on use of Sage ERP and an advanced command of Microsoft Excel including Power Query, complex formulae and dashboard design.
- Ability to interpret large transaction datasets and produce clear, decision-ready reports for management.
- Understanding of credit terms, collections methods and risk assessment within the Kenyan retail, wholesale and HORECA trade environment.
- Confident negotiation and customer-facing skills, with the maturity to handle difficult conversations and sensitive account information.
- Attention to detail and a structured approach to meeting month-end reporting deadlines.
What We Offer / Why Join
- Monthly gross remuneration of KES 70,000 to KES 100,000 depending on experience and qualifications.
- Full-time, on-site employment in Nairobi reporting directly to the Finance Manager.
- The chance to own meaningful improvements in credit processes and reporting systems for a beverage distribution company serving trade channels across Kenya.
728 open positions on Semasocial right now
· 10435 open positions in Nairobi County, Kenya
· 60 posted in the last 7 days
Application deadline: Sep 11, 2026 · 1 day left to apply
Contact Information