How to Read Sales Reports and Make Better Business Decisions

Many owners open a report, look at total sales and close it. That answers only “How much was billed?” It does not explain whether growth came from more customers, larger orders, a temporary bulk sale or heavier discounting. It also does not show how much cash was collected or whether profitable products were sold.

DukaanAdda provides an overview plus Sales, Profit & Loss, GST, Inventory and Payment reports, with customer and product shortcuts. This guide explains how to connect those views and make a decision that can be checked in the next reporting period.

Reports summarise saved transactions. If bills are missing, payment modes are wrong, purchase prices are zero or products are duplicated, the chart can look precise while describing an inaccurate business.

• Every sale is saved once with the correct items and quantities.
• Cash, UPI, Bank and Due modes reflect what actually happened.
• Cancelled, returned or corrected transactions follow the proper workflow.
• Product purchase prices are maintained for useful cost and profit estimates.
• Customers are selected consistently instead of using duplicate accounts.
• Stock changes are recorded with the right movement and reason.

At closing, compare recorded cash with the cash drawer, UPI and bank collections with real account entries, and Due sales with customer ledgers. Investigate differences before using the day as a performance benchmark.

DukaanAdda report selectors support Today, Yesterday, This Week, This Month and Custom Range. The app compares standard ranges with the relevant previous period: today versus yesterday, this week versus last week and this month versus last month. A custom range uses the preceding period.

Avoid comparing a festival week with a normal week and calling the difference permanent growth. Add context such as holidays, stockouts, a large B2B order, weather, closures or a promotion.

The detailed Sales Report shows Total Sales, Total Orders, Average Order Value, Cash Sales, Credit Sales Outstanding and Total Discount. Read them together instead of celebrating one green percentage.

Example: total sales rise 12%, orders rise 20% and average order value falls. The shop attracted more transactions, but the typical basket became smaller. A useful response may be better cross-selling or product bundles—not simply more advertising.

A period total hides timing. The Sales Trend chart groups data automatically for the chosen range. Look for spikes, long flat areas, repeated busy days and sudden drops.

A spike may be a successful day, but it may also be one large wholesale bill. Open recent sales and identify which orders created it. A drop may reflect lower demand, a shop closure, missing billing entries or an out-of-stock bestseller.

Sales value becomes actionable when connected to items. The Sales Report includes category breakdown and top-selling products, while the main overview shows best-selling products. Use these views to identify repeat demand.

A top product deserves reliable availability, but do not order only from rank. Check current stock, supplier lead time, purchase cost, shelf life and whether sales came from a one-time bulk order. For a weak product, review visibility, price, stockouts and whether it solves the same need as a stronger variant.

Product naming and category data must be consistent. Duplicated items split sales across records and make a true bestseller appear weaker. Use the inventory management mistakes guide to clean the underlying product master.

Sales do not automatically mean money is available. The Payment Report shows Total Billing, Total Collected, Cash, UPI, Bank Transfer and Pending Payments. It also includes payment-method breakdown, collections trend, method performance and recent payments with All, Cash, UPI, Bank and Pending filters.

Reconcile each recorded mode with the real source. Cash should match the drawer after expenses and approved removals. UPI and Bank should match account statements. Pending should connect to customer or invoice follow-up.

If sales rise but pending payments rise faster, tighten credit review and collection—not necessarily sales activity. Read the Khata and Udhar management guide for a customer-wise collection process.

The report overview includes New Customers and Top Customers. Top-customer ranking is based on recorded spend and order count, while new-customer calculations compare customer activity in the selected and preceding periods.

A valuable customer is not only the highest spender. Check payment reliability, return behaviour, margin, order frequency and outstanding credit. A customer with high sales and late payments may require different terms from a smaller customer who pays immediately.

The Inventory Report includes total products, total stock value, low-stock items, out-of-stock items, movement trend, category distribution, top-moving products, stock-health overview and recent activity.

Compare top-selling products with low and out-of-stock lists. A sales decline caused by unavailable stock needs replenishment, while a decline with plenty of stock may need pricing, placement or demand review. High stock value in slow-moving categories can tie up cash.

DukaanAdda's Profit & Loss report shows Total Revenue, Total Expenses, Gross Profit, Net Profit Margin, profit trend, revenue-versus-expense and cost breakdowns, plus invoice-level entries and PDF export.

In the current calculation, revenue is recorded bill total minus tax. Cost of goods sold is item quantity multiplied by the saved product purchase price. Gross profit is revenue minus that cost.

Missing purchase prices make cost data incomplete and can overstate profit. Maintain product cost consistently before using the margin for pricing decisions.

The GST Report summarises taxable sales, output GST, CGST, SGST, IGST, rate slabs, recent GST invoices, B2B/B2C counts, HSN-based groupings and trend information from recorded bills. It can be exported as PDF.

This helps check billing consistency, but it is not a GST portal return. In the current report calculation, input tax credit is zero, GST payable equals recorded output GST, filing status is not available, and reverse-charge and cess values are not populated as a complete compliance ledger.

1. 1

   Choose one question

   For example: why did weekly cash collection fall?

2. 2

   Select an equal comparison

   Use the same period length and note special events.

3. 3

   Verify the base data

   Check bills, payment modes, products and customer records.

4. 4

   Find the driver

   Separate order count, basket value, credit and stock effects.

5. 5

   Take one action

   Assign an owner, start date and a measurable target.

6. 6

   Review the next period

   Keep, adjust or stop the action based on evidence.

Example: credit outstanding increased for three weeks. Verify that payment modes are correct, identify the customers and invoices responsible, tighten approval for new Due sales and schedule collection follow-up. Measure outstanding again next week.

Export a PDF when a permanent review copy is useful, but keep the original app data as the current source. A PDF reflects the selected period and the records available when it was created.