# Day Wise Sale
Daily sales summary with invoice count, taxable value, bill totals, outstanding balances, return details, and net revenue. Each day row is clickable to drill down into full transaction detail.
Overview
Go to Sales → Reports → Day Wise Sale.
Report title in ERP: Day Wise Sale
What it shows. One row per day with total sales count, amount, discount, taxable value, bill total, balance, return metrics, and Net Total. Click a day row to open the detailed sales transactions for that date.
When to use it. Use for daily sales monitoring, spotting peak and low days, and drilling into a specific day's invoice list.
The Day field is displayed as DD/MM/YYYY (e.g., 01/12/2025 = 1 December 2025).
Screenshot pending — Day Wise Sale report view.
Use Cases
- Store manager — Which days had the highest and lowest sales this month? Run daily or weekly to monitor floor performance.
- Sales manager — Did a promotion day show a spike in invoice count and net total? Run after campaigns to measure impact.
- Finance team — What is the daily net revenue after returns for the current month? Run at month-end for revenue reconciliation.
- Operations — Which specific day needs invoice-level investigation? Click the day row to drill down into all transactions for that date.
Filters
Year, PayMode, Employee. Advanced Filter: Customer, Branch, Center, Item Group.
Columns
| **Column** | **Description** |
|------------|-----------------|
| Day (DD/MM/YYYY) | Date of the sales summary. Click to open detailed sales for that day. |
| Count | Total number of sale invoices generated. |
| Amount | Total sales amount before discount and tax. |
| Discount | Total discount given for the day. |
| Taxable | Amount after discount before tax. |
| Bill Total | Final invoice amount including tax. |
| Balance | Outstanding unpaid amount for the day. |
| Ret Count | Number of return invoices (credit notes). |
| Ret Taxable | Taxable value of return invoices. |
| Ret Total | Total value of returns including tax. |
| Ret Balance | Outstanding balance related to returns. |
| Net Total | Revenue after return adjustment (Bill Total − Ret Total). |
Actions
- Generate — run the report for the selected filters
- Export — export to Excel
- Print — print the report
- Drill-down — click a day row to view all sale transactions for that date
- Advanced Filter — open additional filter fields
- clear — reset active advanced filters
FAQ
How do I see individual invoices for a day?
Click the Day row to open the detailed sales transaction list for that date.
How is Net Total calculated?
It is Bill Total minus Ret Total for the day, representing actual revenue after returns.
How is this different from Month Wise Sale?
Month Wise Sale aggregates by calendar month. Day Wise Sale provides daily granularity with drill-down to individual invoices.
Can I filter by payment mode?
Yes. Set PayMode before generating to see only cash, credit, or bank sales for each day.
Which invoice date is used?
Sale invoice bill date in the selected range. Draft and cancelled invoices are excluded.
How is this different from Month Wise Sale?
Month Wise Sale aggregates by calendar month. Day Wise shows daily spikes for operations planning.
Need sales by item group per day?
Use Day Wise Item Group Wise Sale for day rows with item-group columns and optional return detail.