The video effectively addresses a common pain point for small business owners (manual record-keeping) by offering a tangible, automated solution in a widely accessible format (Excel). The clear demonstration of the tracker's functionality and the creator's offer to help others create similar tools likely resonated with viewers looking for practical business management tools.
Summary
The creator showcases a fully automated Excel workbook designed to track a sachet water business. The workbook includes 15 sheets to manage production, sales, inventory, and finances, eliminating the need for manual record-keeping. The creator explains the functionality of the tracker and offers to help others create similar spreadsheets for their businesses.
Structure
1Introduction of a client's manual record-keeping problem
2Presentation of the automated Excel workbook solution
3Explanation of the workbook's features and sheets
4
Original caption
He was running a whole sachet water business from a notebook 📓 ; no calculations, no summaries, just raw manual records. I built him a fully automated Excel workbook that tracks everything from production to sales to inventory. 15 sheets, zero manual calculations. This is what I do💧 #ExcelForBusiness #DataAnalysis #Excel #dataanalytics #ExcelTips
More from @.livingdata
More breakout videos from this creator.
Demonstration of data entry and automated calculations
5Client feedback and requested modifications
6Call to action for viewers to get their own custom tracker
Product placement
Excel: it is used to create a business tracker. The tracker has 15 sheets and is fully automated. It tracks production, sales, and inventory. The tracker is presented as a solution to manual record-keeping. The tracker itself is the product being promoted. It acts by organizing and calculating business data.
Call to action
Reach out to me and I'm going to help you create that spreadsheet to track your business
On-screen text
I Built a Sachet Water Business Tracker in Excel 💧📊
Transcript
Hello guys, a client reached out to me. He runs a sachet water business and needed a better way to track everything. No more notebooks, no more manual calculations. So I built him a fully automated Excel workbook that tracks everything from production, sales, expenses, inventory, and the dashboard. Your Sachet Water Business Workbook is ready. I've recorded a walkthrough video showing how everything works, production, sales, expenses, inventory, and the dashboard. Once you've watched it and you're happy, kindly send the balance of N25,000 and I'll send the full file right away. Good Afternoon. Your Sachet Water Business Workbook is ready. You did a very nice job. I made a list of corrections and things to be added. I will send them soon. Materials: *Amount owed by supplier *(Quantity difference) should indicate maybe with colours or + and - if I owe the supplier or the supplier owes me. *Total numbers of rolls delivered. Note: this should be blue color(type my own data) Production: *Machine count should be different from sachets produced, because machine count is usually higher by few numbers, never accurate. *Good sachets should be in blue(type my own data) *Total bags produced should be "Good bags" added to "Bags leakages" **Total sachets produced should be "Good sachets" added to "Sachets leakages" Leakages: *This should be post production leakages only. That's leakages that occurs after productions, while loading trucks before leaving the factory, leakages discovered at the factory from parked or stocked bags) This is different from Free bags and replacement bags. Bags out & bags in: *Sometimes trucks loads two to three times(example: in the morning 1st truck loads like 210.5 bags OUT then maybe before 12pm he will comeback with maybe 4 bags then load 150.5 bags OUT etc) So for 23/06/2026 might have something like 150.5 bags out, 170.6 bags out, 6 bags in, 50 bags out, 75 bags out. Sales: *"Bags sold" should be Total bags out for sale(Bags OUT minus bags IN) minus (free bags and replacement bags) *Total bags out for sale (Bags OUT minus Bags IN) *Remove (Customer name and Payment status) Debtors/awaiting payments: *Please add more "Amount Paid". Because most of them pays like 3 to 4 times. Also if possible, anything to indicate when a debt exceeds one week. Daily summary: *So I'm thinking daily summary should only be about sales, bags out and in, expenses, post production leakages, sales leakages(Free bags and Replacements) and debts *Then you create a weekly summary for all the summary. Should also include "Total of Roll weight used(kg)" subtracted from "Quantity delivered(kg)" Monthly summary: *Everything looks good *I need a total of "Roll weight used(kg)" subtracted from "Quantity delivered(kg)" Inventory: I'm not sure what's in there, because you didn't show it in your recorded video. Alright, I'll fix that to your preference and get back you you. Alright, I'll fix that to your preference and get back you you. He was running a whole sachet water business from a notebook; no calculations, no summaries, just raw manual records. I built him a fully automated Excel workbook that tracks everything from production to sales to inventory. 15 sheets, zero manual calculations. This is what I do. If you're interested in creating a spreadsheet to track your business, reach out to me and I'm going to help you create that spreadsheet to track your business.
2 videos
