The screenshots below come straight from the real file — not mockups.
S3 · Simple tool
Daily Sales Record
Excel Template for Malaysian Small Business
Out of the 555 notebook, into a record that adds itself up.
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
- 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.