Reports and analytics

Every report, built from the bills you already raise.

Wiseventory has 17 report screens and four month-end downloads. None of them needs data entry. Sales, profit, customers, stock, money owed and GST are all worked out from the invoices, purchase orders, payments and expenses you record while running the shop. Every screen filters by date range, and the money figures stay with the owner.

01

Overview

The first screen after you open Reports. It answers the questions an owner asks on the way home: how did today go, how is the month going, and who still owes me.

Overview

Today's sales and bill count against the same time yesterday, this month against the whole of last month, and the state of your invoices.

What it shows

  • Sales and number of bills so far today, with the change against yesterday up to the same hour
  • This month's revenue and bills, with the change against last month
  • Paid, pending and overdue invoices, and the amount still owed on the overdue ones
  • Products below their minimum stock, active products and suppliers, new customers
  • A sales chart for the chosen range, and revenue against cost by month

02

Sales

What sold, how big the average bill was, and how customers paid. All three filter by any date range.

Sales trend

Revenue and bill count by day, with the products that drove it and the ones that came back.

What it shows

  • Revenue and orders for each day in the range
  • Top-selling products by quantity and by value
  • Top-returned products, total return value, and returns as a share of sales

Order value

The size of a typical bill, and whether it is growing. The range is compared with the equal period just before it.

What it shows

  • Bills, revenue and average bill value for the range and for the previous period
  • Average lines per bill and units per bill
  • The same figures by day, week or month, and the change in average bill value

Payment mix

How much came in by cash, UPI, card and online, so the drawer and the bank can be checked against it.

What it shows

  • Amount, number of payments and share for each mode
  • A mode nothing was paid by is left out rather than shown as zero

03

Profit

Margin figures use the taxable value of each bill, net of GST, so tax never inflates a margin. Credit notes are taken off in the month they were issued, the same way the GST returns treat them.

Profit & margin

Gross and net profit by month, with returns netted and expenses taken off.

What it shows

  • Revenue, cost of goods, gross profit and gross margin for the range and for each month
  • Recorded expenses and net profit, shown only to a user with the financials permission
  • Total sales returns, shown separately so the netting can be seen
  • A month with expenses or returns but no sales still appears, as a loss

By product

Profit per item or per category, most profitable first.

What it shows

  • Quantity, revenue, cost, profit and margin for each item or category
  • Returns taken off per item: the returned quantity, its value and the cost it was sold at

04

Customers

Who buys the most, and how much of the month came from people buying for the first time.

Top customers

Customers ranked by revenue, with a running share so you can see how much of the business the top ten carry.

What it shows

  • Rank, bills, revenue, share of revenue and cumulative share for each customer
  • Date of each customer's last bill
  • Walk-in revenue and bills, counted separately from identified customers

New vs returning

Revenue split between first-time customers, returning customers and walk-ins.

What it shows

  • New, returning and walk-in revenue for the range
  • The same split by day, week or month, with the number of new and returning customers in each

05

Inventory

Five views of the same stock: what it is worth, how fast it moves, what to order, what is about to expire, and what has stopped selling.

Stock on hand

What your shelves are worth at cost, and which products have dropped below their minimum.

What it shows

  • Total stock value at cost, split by category
  • Low-stock list with product, variant, SKU, current stock and the minimum you set

Turnover

How many times stock sells through in the range, overall and by category.

What it shows

  • Cost of goods sold, stock value, units sold, turnover ratio, annualised turnover and days of inventory
  • The stock value is today's stock at cost. There are no historical snapshots, so it is not a true average, and the report says so

Reorder

Which variants will run out, when, and how much to order to stay covered.

What it shows

  • Units sold in the lookback period and the daily pace that implies
  • Days of cover at that pace and a suggested quantity to reach the cover you want
  • A status for each line: out of stock, critical (under 7 days), low (under 14), reorder, or OK

Near-expiry

Batches that expire within a window you choose, with the money tied up in them.

What it shows

  • Batch number, expiry date, days to expiry, quantity, value at cost and at selling price
  • Total value at risk across every matching batch
  • Stock that has already expired shows with negative days, so it is not hidden

Dead stock

Variants that have not sold in a set number of days, and the cash locked in them.

What it shows

  • Current stock, stock value, last sale date and days since that sale for each variant
  • Items that have never sold are listed too
  • Total locked value across every matching variant

06

Receivables and purchasing

What customers owe you, aged by how late it is, and what you spend with and owe each supplier.

Receivables

Unpaid customer balances as of today, aged by due date.

Needs the financials permission

What it shows

  • Total outstanding, the part not yet due, and the overdue part in 0 to 30, 31 to 60, 61 to 90 and over 90 days
  • Each customer's outstanding, their overdue buckets and their oldest overdue bill in days
  • Days sales outstanding: how many days of sales are still unpaid

Supplier spend and payables

Where purchase money went in the range, and which supplier bills are still open.

What it shows

  • Spend, purchase orders, expenses, share of spend and outstanding balance per supplier
  • Expenses with no supplier are grouped as one row
  • Payables aged 0 to 30, 31 to 60, 61 to 90 and over 90 days, in total and per supplier, with the oldest open bill in days

07

Tax

The returns themselves, and the position they will show, for a month or a QRMP quarter. Both need the financials permission.

GST returns

GSTR-1 and GSTR-3B for the period, built from the same invoices and purchase orders.

Needs the financials permission

What it shows

  • GSTR-1 as a printable PDF or as the JSON file the GST portal accepts
  • A pre-check that lists what the portal is likely to reject, so you fix it before downloading
  • IFF output for the first two months of a QRMP quarter
  • GSTR-3B as a PDF

GST position

What the period's return will come to, before you file it.

Needs the financials permission

What it shows

  • Output tax, input tax credit, credit reversed and reverse-charge tax, each split into IGST, CGST and SGST
  • Net payable per head, or credit carried forward when it is negative
  • Taxable value and tax by rate, and by HSN code

08

Month-end downloads

Four reports you can hand to an accountant or file away, each for any month, as a PDF or an Excel file. The file is named after the report, the month and your shop, so it stays findable later.

Monthly sales
PDF or Excel. Needs the reports permission.
Monthly product sales
PDF or Excel. Needs the reports permission.
Monthly expenses
PDF or Excel. Needs the financials permission.
Monthly profit and loss
PDF or Excel. Needs the financials permission.

Who sees what

Opening Reports needs the reports permission. Expenses, net profit, receivables, the GST returns and the GST position need the financials permission as well. A cashier login has neither, so staff can run the counter all day without ever seeing a margin. When a user without the financials permission opens the profit report, the expense and net profit fields are left blank rather than shown as zero, so a gross figure is never mistaken for a net one.

Questions owners ask about the reports

Do I have to enter anything to get these reports?

No. Every figure comes from records you already keep: invoices, credit notes, purchase orders, payments and expenses. Raise bills and receive stock as usual and the reports fill themselves in.

Can my cashier see my profit?

Not unless you let them. Reports need the reports permission, and anything that touches money (expenses, net profit, receivables, the GST reports) needs the financials permission on top. A cashier login has neither, so they can bill without seeing margins.

Are the margins shown with or without GST?

Without. Profit and margin figures use the taxable value of each bill, so the tax you collect is never counted as income. Returns are taken off in the month of the credit note, the same way the GST returns handle them.

Can I download a report or send it to my accountant?

Yes. Four month-end reports (sales, product sales, expenses, profit and loss) download as PDF or Excel for any month. GSTR-1 downloads as a PDF or as the JSON the GST portal takes, and GSTR-3B as a PDF. The on-screen reports filter by any date range.

How is stock turnover worked out?

Cost of goods sold in the range divided by stock value. The stock value is today's stock at cost, because the app does not keep historical stock snapshots, so it is a current figure rather than a true average. The report states this.

See the reports with your own numbers

Add a few products, raise a few bills, and open Reports. The overview fills in from the first invoice. Every report here is included in the free plan, which does not expire.