Daily Sales Register Format — Free Excel and App
A daily sales register lists every sale made in a day by item, amount and payment mode.
Shops use it to close the day, match cash with sales and see which items and staff sell the most.
Daily Sales Register format preview
| Date | Bill no. | Item | Quantity | Rate | Amount | Payment mode | Salesperson |
|---|---|---|---|---|---|---|---|
| 12-Nov-2026 | B-0231 | Notebook A4 | 6 | ₹40 | ₹240 | UPI | Kiran |
The second row is a filled sample.
What each column means
Date
Example: 12-Nov-2026
Bill no.
Example: B-0231
Item
Example: Notebook A4
Quantity
Example: 6
Rate
Example: ₹40
Amount
Example: ₹240
Payment mode
Example: UPI
Salesperson
Example: Kiran
Daily Sales Register FAQs
What is a daily sales register?
A day-wise record of all sales with item, amount and how the customer paid.
How do I match it with cash?
Total the cash payment rows and compare with the cash in your drawer at closing.
Can I see sales by salesperson?
Yes, if you record the salesperson column you can group or filter by it.
Does this replace billing software?
It is a record of sales, not a GST invoicing tool. Use it alongside your billing system.
Related registers
Running a retail & inventory business? See Recordbook for retail & inventory · Recordbook vs Excel