Junior Accountant | ACCA Candidate

Elevating Financial Clarity.

I am a detail-oriented financial professional based in Nairobi, Kenya. I combine rigorous full-cycle bookkeeping discipline with advanced data visualization and VBA automation to transform raw financial data into strategic, executive-ready insights.

ACCA 7/13 Papers Full-Cycle Bookkeeping Excel VBA Dashboards AP/AR & Payroll
Hire / Contact Me
Ayub Farah
Detail-Oriented

Finance Support

Dashboard-Ready

Reporting

Reconciliation

& Bookkeeping

Available For

Roles & Freelance

Professional Profile

About Me

As a Junior Accountant and active ACCA candidate (7/13 papers completed), I bring a robust foundation in full-cycle bookkeeping, AP/AR, payroll, fixed asset management, and cost control.

Beyond traditional ledger management, I specialize in leveraging accounting platforms (QuickBooks, Xero, Zoho Books) and advanced Excel VBA to engineer automated workflows and dynamic financial dashboards. Whether supporting a corporate finance team or assisting a freelance client, my goal is to ensure absolute compliance while delivering the financial clarity required for strategic growth.

Career History

Experience

Accountant

VUN Trading LTD, Nairobi, Kenya | Aug 2025 – Present
  • Administer full-cycle bookkeeping, executing precise general ledger postings, bank reconciliations, and rigorous month-end close procedures.
  • Spearhead AP/AR workflows, strategically monitoring payment discounts, recovering overdue invoices, and optimizing operating expense processing.
  • Execute monthly payroll operations, including complex sales commission structures, ensuring flawless PAYE compliance and timely disbursements.
  • Maintain and reconcile critical financial schedules including fixed assets, depreciation, rentals, and comprehensive tax/audit support documentation.
  • Develop high-impact weekly sales and cost analysis reports, directly influencing pricing strategies and supplier negotiations to drive campaign profitability.

Finance & Administration Intern

Kosokoso Police Station, Kampala, Uganda | Jan 2025 – Mar 2025
  • Maintained impeccable daily financial records and spearheaded the digitization of legacy files to elevate audit readiness.
  • Assisted in payroll administration, meticulous expense tracking, and the generation of structured quarterly Excel reports.
Visualizing Data

Dashboard Showcase

A curated selection of premium financial analytics, precise budgeting tools, and strategic cash-flow dashboards. These projects demonstrate my ability to translate complex datasets into intuitive, executive-ready visual reports.

Executive Cash Flow Dashboard

Executive Cash Flow Dashboard

A comprehensive monitoring tool tracking inflows, outflows, net cash flow trajectories, and categorical expense breakdowns for rapid executive oversight.

Excel VBA Cash Flow Dashboard Design
Debt Payoff Dashboard

Strategic Debt Payoff Tracker

An analytical dashboard designed to monitor debt reduction, comparing starting vs. current balances, interest impacts, and total portfolio composition.

Financial Reporting Liability Analysis
12-Month Cash Flow Forecast

12-Month Cash Flow Forecast

A month-by-month forecast table covering opening balances, inflows, outflows, net cash flow, and annual totals for planning liquidity.

Cash Forecasting Planning
Year 2026 Bookkeeping Summary

Yearly Bookkeeping Summary

A yearly bookkeeping dashboard summarizing income, expenses, profit margin, monthly charts, and category-level performance.

Annual Review Performance Metrics
Monthly Budget Breakdown

Monthly Budget Breakdown

A detailed budgeting view with income sources, expense sources, category percentages, and monthly spending breakdowns.

Budget Analysis Variance Tracking
5-Year Bookkeeping Dashboard

5-Year Bookkeeping Dashboard

A multi-year bookkeeping dashboard comparing income, expenses, profit margin, category breakdowns, and long-term trends.

Trend Analysis Forecasting
Monthly Bookkeeping Dashboard

Monthly Bookkeeping Dashboard

A monthly bookkeeping dashboard showing income, expenses, profit or loss, margins, charts, and category breakdowns.

Strategic Reporting Cost Control
Budget vs Actual Monthly Dashboard

Budget vs Actual Monthly Dashboard

A monthly variance dashboard comparing budget to actual costs, showing savings rate and key spending categories.

Variance Analysis Corporate Finance
Freelance Offerings

Client Services

Bookkeeping Support

End-to-end ledger management, ensuring your books are accurate, compliant, and consistently up to date using platforms like QuickBooks and Xero.

Dashboard Design

Transforming your raw data into stunning, automated Excel dashboards that provide instant clarity on your business's financial health.

Reconciliation

Expert resolution of discrepancies across bank statements and accounts, utilizing custom VBA scripts to accelerate matching and accuracy.

Cash Flow Tracking

Implementing structured budget and cash flow monitoring systems to optimize liquidity and safeguard your operational runway.

Project Experience

Independent Work

Small Business Accounting & POS Support

Freelance & Volunteer | Nairobi, Kenya | 2024 – Present

Successfully engineered bookkeeping frameworks and simplified POS trackers in Excel and QuickBooks Online, streamlining operations for 3 local small businesses.

Excel VBA Automation for Reconciliation

Personal Development Project | 2024

Architected a custom Excel VBA reconciliation utility that algorithmically matches transactions, reducing manual reconciliation time by approximately 70% and auto-generating summary reports.

Real Estate Expense & Client Tracker

Freelance Project | 2025

Developed a dedicated Excel dashboard for a real estate client to meticulously track tenant payments, outstanding balances, property-specific operational expenses, and overall monthly cash flow.

Technical Expertise

Core Capabilities

Accounting Systems

QuickBooks Online QuickBooks Desktop Xero Zoho Books Busy Accounting

Excel & Analytics

Pivot Tables VLOOKUP / XLOOKUP Advanced IF Functions VBA Macros Reporting Dashboards Data Visualization

Core Accounting

Full-Cycle Bookkeeping Accounts Payable (AP) Accounts Receivable (AR) Payroll & PAYE Fixed Asset Registers Bank Reconciliation Month-End Close
Academic Background

Education & Credentials

ACCA

Association of Chartered Certified Accountants

Self-study, Nairobi | Candidate

Successfully completed 7 of 13 papers.

BBA in Accounting & Finance

Cavendish University Uganda

Kampala | Jun 2022 – Aug 2025
Let's Connect

Contact & Social

Whether you are a hiring manager seeking a meticulous accounting professional, or a business owner in need of freelance bookkeeping and custom dashboards, I am ready to deliver.

Email Address ayubfarah67@gmail.com Phone Number +254 714 644 491 Upwork Profile View freelance profile LinkedIn Profile View professional profile Download CV Download
Download CV