Case Experience
Easy Sales, Cost, and Profit Tracker for Small Businesses (KitaTrack Lite)
Role: Process Consultant & Google Sheets Developer
Background:
Many small business owners struggle with tracking their true profitability due to fragmented records, manual computations, and lack of structured reporting. To address this, I developed KitaTrack Lite using Google Sheets as a free, accessible solution tailored for startup owners and micro-entrepreneurs. Any owners starting out with laundry business, water refill stations, carenderia, and printing services can use the tool.
The system was designed to:
1. Simplify daily sales and expense tracking,
2. Automatically compute gross profit margins,
3. Provide quick, visual insights for decision-making,
4. Eliminate reliance on complex or paid software, and
5. Provide easy to use User Guide to simplify user experience.
Other Details:
KitaTrack Lite focuses on usability and clarity, ensuring even non-technical users can:
1. Input transactions in seconds
2. View real-time profit summaries
3. Monitor short-term performance (daily/weekly trends)
4. Use cellphone or any best available tool for viewing KitaTrack Lite.
In this case, I used the tool Google Sheet because it is free making KitaTrack Lite easily accessible by start up business owners. This bridges the gap between raw data and actionable insight—something most small businesses lack in their early stages.
Skills & Deliverables:
This is how I structured and implemented the solution.
1. Business Process Maps (BPMN) and SOP Documentation
2. Standardized Reporting Structure
3. Automated Google Sheets Reporting Dashboards
Workflow:
Business Impact:
1. Reduced manual computation time by 60–80%, enabling faster daily closing.
Before (manual): Encoding = 20 mins; Manual computation = 30 mins
Total = 50 mins/day
After (KitaTrack Lite): Encoding only = 15 mins; Total = 15 mins/day
Thus: (50 – 15) / 50 = 70% reduction
2. Improved visibility of daily profit, helping owners make real-time pricing and cost decisions.
3. Increased reporting consistency, reducing errors and missed entries by over 60%.
User Guide:
Quickly get a copy of this tracker and the user guide when you reach out through Magayon Management Consultancy Services, I help organizations transform complex processes into structured systems that drive accuracy, efficiency, and better decision-making.
Are you looking to fix or improve your business processes?
Let’s build a system that works for you.
Contact me
LinkedIn Profile Send me a message to jalopez@libottayo.com
Tutorial: Excel Now Ph on YouTube
Life Update: Libot Tayo by Lily on Facebook
Consulting through Magayon Management Consultancy Services
