How do I get a weekly sales report without asking anyone?
Decide five numbers that matter, keep the sales record in one sheet, and have the report written the same way every Monday morning and sent to the chat the owner already reads. Add three things that look odd and the follow-ups due. A one-screen report gets read, a long one does not.
Who asks this: An owner of a small Indian business who wants to know how sales are going without chasing the team, and who has numbers in a sheet, an invoice export or a billing app but never has them on one screen.
The steps
1. Pick five numbers, not twenty
Choose the numbers you would ask about in a call: sales this week, sales against last week, orders or invoices raised, money collected, and the amount still pending. Write the exact meaning of each in one line, for example whether sales means invoiced or paid. The owner signs this off once.
2. Keep one sales record
Use a single sheet or a single export from your billing tool, with one row per invoice or order: date, customer, amount, status. The person who raises invoices keeps it up to date every day. A report is only as good as this one record.
3. Fix the day and the place
Choose Monday at a set hour and the chat where the owner actually reads messages, usually WhatsApp. A report that arrives at the same time each week becomes a habit, and the owner stops asking for updates in between.
4. Add three things that look wrong
Below the five numbers, list up to three odd items: a customer who stopped ordering, an invoice unusually large or small, or a week sharply below the average. The person preparing the report writes one line on each. This is the part owners value most.
5. List the follow-ups that are due
Add the quotations waiting for an answer and the payments overdue, with the name of the person responsible. The report then ends with actions, not only history, and each person knows what the owner will see next Monday.
6. Read it, reply once, and adjust
The owner reads the report, replies with a decision or a question, and changes one number or one definition if it is not useful. After a month the report matches what the owner really needs, and the weekly status meeting becomes shorter.
A worked example
illustrative
A small electrical goods wholesaler in Nagpur invoices around sixty orders a week. The accounts person keeps a sheet of invoices. Every Monday at eight, the owner receives five numbers in chat: sales of about seven and a half lakh rupees against eight lakh the week before, sixty-two invoices, about five and a half lakh collected, and about four lakh pending. Below them are three flags, including a retailer who ordered every week for a year and has not ordered for three weeks. The last lines list two quotations waiting and three overdue payments with names. The owner calls the retailer that morning and learns a competitor was cheaper on one item.
What goes wrong
- The numbers mean different things to different people, so the report starts arguments.
- The sheet is updated only at month end, so Monday's report is out of date.
- The report has twenty figures and the owner stops reading after two weeks.
- There are no flags and no actions, so the report only describes the past.
- It goes to an email inbox the owner rarely opens instead of the chat they use daily.
- Nobody owns the report, so it stops when the person who built it is busy.
How Demystify OS helps
Weekly summaryEarly access
A weekly summary routine gives the owner one short read of what moved and what is stuck, which is the shape of this report.
Owner brief, morningEarly access
The morning owner brief is the same idea for each day: one message built from what happened and what needs a decision.
WhatsAppProvisioned on request
WhatsApp is connected on request, so the report can arrive in the chat the owner already reads.
Mysty WorkersEarly access
Mysty Workers can be set up with you to read the sales sheet or invoice export you connect and post the five numbers, three odd items and the follow-ups due each Monday morning. A sales report routine is not yet a standard catalogue entry.
What it does not do. Demystify OS does not replace your accounting records or decide what your sales mean; it reads the record you connect and reports it, and a person checks anything that looks wrong.
Questions people ask
What should a weekly sales report include?
Five numbers are enough for most small businesses: sales this week, sales compared with last week, the number of orders, money collected and money pending. Add three flags for anything unusual and the follow-ups due. Anything more makes the report harder to read.
Do I need special software to get this report?
No. A shared sheet with one row per invoice and a person who prepares the report each Monday is enough to start. Software only makes the preparation faster and more regular, it does not change what a good report contains.
Why send the report on WhatsApp?
Because the owner already reads it every day. A report in an inbox that is opened twice a week is often missed. Keep the message short and put the details in the sheet it links to for anyone who wants to look further.
How do I stop the numbers from being argued about?
Write the meaning of each number in one line, such as whether sales means invoiced or paid, and keep it at the top of the sheet. When two people disagree, the written meaning settles it and you can change it deliberately.
What is a good flag to include?
Include a regular customer who has gone quiet, a week far below your usual level, and an invoice far from the normal size. Each flag should come with one line on why it matters and the name of the person who will look into it.
Apply for the beta.
Demystify OS is invite only, and a person reads every application.
Apply for the beta