BEFORE: Client had messy Excel inventory with 500 rows, duplicates (A12 / a12), blanks, wrong prices like "$ 2.5" and "N/A", and different warehouse names (KER / ker / Kericho).

AFTER: I did:

Removed 12 duplicate SKUs

Standardized item names to Title Case

Fixed QTY and Prices to 2 decimals

Unified Warehouse to Kericho

Made sheet ready for pivot dashboard

Result: Clean, ready-to-use inventory in 2 days using Excel.

Tools: Excel, Remove Duplicates, Text to Columns, TRIM, PROPER

"I use my business card for personal stuff. What's the big deal?"

A small business owner client asked me this during a routine ledger review.

He was taking a regular salary, but he was also tapping his corporate card for everyday personal purchases. To him, it was all "his money anyway" which is also right but, as a financial analyst, I showed him why this habit was quietly hurting his business: Mixing personal expenses into operating accounts distorted his Profit & Loss statement, masking his true profit margins. Commingling personal and business funds creates massive compliance risks and headaches during tax season.

Also, he couldn't accurately forecast his working capital because personal draws were scattered across random accounts.

So, I audited his chart of accounts, reclassified past personal transactions out of the P&L and into Owner’s Equity/Drawings, and helped him set up a strict boundary: a fixed transfer schedule to his private bank account, leaving the business card strictly for corporate expenses.

You know what was the result; a clean, IFRS-aligned Profit & Loss statement and 100% clarity on his true monthly profits.

Lesson: Clean bookkeeping isn't just for taxes—it’s the foundation for knowing if your business is actually making money.