The screenshots below come straight from the real file — not mockups.
P6 · Premium control pack
Shop & Stock Control Pack
Daily Retail Sales & Stock Control
Catch empty shelves and dead stock before they cost you.
Not open for sale yet
This file is built and audited, but it has not passed phone testing and is not ready to deliver. We do not take money for something we cannot hand over.
Tell me when it's readyBuilt without formulas that break in Google Sheets. The phone import test has not been run yet.
The problems this fixes
- Stock runs out and you only notice when a customer asks
- Dead stock piles up with money locked inside it
- Margins are thin but nobody knows where the leak is
What you get
- Automatic DASHBOARD: 6 key-number cards plus a comparison with last month
- 12-month trend chart (sales vs expenses) plus expenses by category
- Five-check business health score with plain-language advice
- One-page monthly REPORT — ready to print or send as a PDF
- Lists you can edit yourself (products, expense categories, sales channels)
- White cells = you type, grey cells = calculated (formulas protected)
- 1,000-row SALES register — built for shops with many small transactions
- STOCK: balances, stock value and automatic reorder warnings
- CUSTOMERS for regulars and credit accounts
- INVOICE sheet for wholesale buyers
Sheets in the file
live formulas, audited with zero errors
Included with every purchase
- Excel file (.xlsx) — a SAMPLE version (with example data) plus a BLANK version ready for your own data
- MULA SINI sheet: a 15-minute starter guide in Malay
- Imports into Google Sheets — use it on an Android phone or iPhone
- Buyer's guide (PDF) plus FAQ
- Free replacement file if yours breaks, and free version updates
Common questions
Can I use it on a phone?
The files are deliberately built without formulas that break in Google Sheets (no XLOOKUP, LET or spill formulas), so they should import and open in the Microsoft Excel app (Android/iOS) or Google Sheets (File > Import). Being straight with you: we have not yet run the import test on a real phone, so we cannot promise every chart and dropdown survives the import. If anything breaks, WhatsApp us — we fix it or refund you.
Do I need to be good at Excel?
No. You only type in the WHITE cells. GREY cells hold the formulas and calculate themselves.
How do I clear the example data?
Use the included '_KOSONG' (blank) file — it is already empty. Keep the sample file as a reference.
Is there a password?
No. Sheets are protected without a password so formulas cannot be deleted by accident. You can unprotect them yourself (Review > Unprotect Sheet) if you want to modify the file.