A simple daily sales report format for a small shop
A one-page end-of-day report tells you what sold, how it was paid, who owes you and whether the till is right. Here is a format you can use on paper or in software.
Why a daily report is worth five minutes
Most small shops know roughly how the day went. Few know it precisely, and the gap is where cash goes missing and slow sellers hide. A short report at closing, done every day, turns a vague feeling into numbers you can compare week to week.
The format
| Section | What to record |
|---|---|
| Date and day | Date, weekday, any festival or special event |
| Total sales | Number of bills and total value |
| Payment split | Cash, UPI, Card, and amount sold on credit |
| Credit given and collected | New udhaar for the day and dues settled by customers |
| Expenses | Rent share, electricity, supplies, wages, other costs |
| Cash in till | Opening cash + cash sales + dues collected - cash expenses = expected closing cash; compare with the actual count |
| Top sellers | The three to five products that sold most |
| Stock alerts | Items that are low or out of stock |
| Notes | Cancelled bills, returns, price changes, anything unusual |
How to fill it in
- Total the day's bills and note the count.
- Split the total by how each bill was paid.
- Add credit sales separately, because that money has not come in yet.
- List any dues customers paid today.
- Record the day's expenses, then work out expected cash and compare it with the physical count. Note any difference, even a small one.
- Write the top sellers and anything that needs reordering.
Reading the numbers
- A growing credit figure with flat cash means you are lending more than you are collecting.
- A repeated small cash difference points to a process problem, such as change errors or unrecorded expenses.
- A product that is always in the top five and often out of stock is costing you sales.
- A product that never appears is tying up money on the shelf.
Doing it automatically
On paper, this takes careful addition every night. In billing software, the numbers already exist. RathTech Billing POS shows today's sales and bill count on the dashboard, the last ten transactions, and low-stock and out-of-stock counts. The Reports screen gives sales and profit for any day, week, month or year, the top ten and lowest sellers, a breakdown by payment method and category, and an export to PDF or Excel or a direct print. Expenses are logged in the app, so profit reflects real costs. See inventory management for the stock side.
Weekly and monthly roll-ups
Once the daily habit is in place, add a weekly total and a monthly total of the same lines. Compare the same weekday over several weeks, because Saturdays and Mondays behave differently. Share the monthly figures, including tax collected, with your accountant. See the GST billing page for the GST report.
Limits
A report is only as good as the entries behind it. Record every sale, expense and payment on the day. Software reports reflect what you enter, and cash counts still need a person with a calculator at the end of the day. Read how to track udhaar customers for the credit side.
Frequently asked questions
What should a daily sales report include?
Total sales and bill count, payment split, credit given and collected, expenses, cash count, top sellers and stock alerts.
Can billing software produce it for me?
RathTech Billing POS shows today's sales on the dashboard and gives period reports with payment and category breakdowns, exportable to PDF or Excel.
How do I check my cash?
Opening cash + cash sales + dues collected - cash expenses should equal the cash in the till.