Last updated on April 2, 2026
Case Experience
Easy Sales, Cost, and Profit Tracker for Small Businesses (KitaTrack Lite)
Role: Process Consultant & Google Sheets Developer
Content
Details
Deliverables
Workflow
User Guide
Frequently Asked Questions
Payment
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.
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.
Frequently Asked Questions
1. Paano ko sisimulan gamitin ito?
ENGLISH: Start with MyDailyMenu, then record your sales in MySalesLog.
TAGALOG: Unahin ang MyDailyMenu, pagkatapos ilagay ang benta sa MySalesLog.
2. Kailangan ba exact ang costing?
Hindi kailangan exact. Kahit estimate lang, okay na.
Ang importante: Consistent at may basis ang presyo.
3. Bakit hindi nagbabago ang ibang cells?
May mga cells na naka-lock para hindi masira ang system. Do not edit gray cells (auto-compute).
4. Pwede ba ito sa cellphone?
YES. Fully working sa Google Sheets mobile.
Tip: Mag zoom out para makita ang buong table.
5. Paano kung may bagong product/service?
I-add lang sa MyDailyMenu, then gamitin sa MySalesLog.
Mag auto-update ang lahat ng choices sa ibang sheets.
6. Bakit mali ang lumalabas na cost/profit?
Check:
• Tama ba ang input sa MyDailyMenu?
• May laman ba ang quantity?
• May mali bang spelling ng product/service?
7. Pwede ba ito sa ibang negosyo (hindi carenderia)?
YES. Pwede sa Laundry, Printing, Retail, at Reseller.
8. Paano ko malalaman kung lugi ako?
Check Profit column.
Kapag negative = LUGI
Kapag positive = may KITA
9. Pwede ba i-customize ito?
YES (₱999 per user).
I-message mo lang ako for:
• Layout changes
• Additional features
• Business-specific setup
10. Paano kung may problem ako?
Message mo lang ako anytime.
Kasama sa support:
• Troubleshooting
• Guidance
• Improvements
We are continuously improving this tool. If you have suggestions or problems, feel free to message. Hindi lang ito tracker, ito ay system para mas maintindihan at mapalago ang negosyo mo.
To get a copy of Kita Track Lite Php 499
1. Scan my GoTyme QR below.
2. Send your proof of payment via message or
3. Fill in this Payment Form.
4. I’ll send your file within 24 hours to your registered email address.
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
