S3 · Simple tool
Daily Sales Record
Out of the 555 notebook, into a record that adds itself up.
Excel Template for Malaysian Small Business
Every screenshot here comes straight from the real file - not a mockup.
The problems this fixes
- Sales recorded in a 555 notebook that goes missing
- Month-end means adding everything up line by line
- Can't remember who still hasn't paid
What you get
- 400-row sales register with date, customer, product, quantity, price
- PAID / UNPAID / DEPOSIT status with automatic colour coding
- Monthly summary: total, received, outstanding, average per record
- 12-month trend chart
- Filter by date, product, customer or status
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.