Sales
Which product sold the most in Salem last month?
₹4.2LCotton bedsheets, October
Cotton bedsheets took 51% of branch revenue, 31% ahead of September.
Reads from: Invoice register, current month
You askedWhat can I actually ask it?
Question library40 questions businesses ask on a Monday morning.
Each card is a real question shape with the answer Datatopple returns: the headline number, a chart, the one-line insight and the source it had to read. Filter by area or search for the one on your mind.
Sales
Which regular customers stopped ordering?
₹11.4LAnnualised revenue at risk
9 accounts that ordered monthly all year have been silent for 45 days.
Reads from: Invoice register, 13 months
Sales
Which territory is behind target this quarter?
71%Coimbatore vs quarter target
Coimbatore is at 71% of target with 9 days left; every other territory is past 90%.
Reads from: Invoice register + target sheet
Sales
Where are we discounting more than we agreed?
₹68,400Discount above policy
14 invoices went out above the 12% scheme cap, all from one price list.
Reads from: Invoice register + scheme master
Sales
How many retailers reordered within 30 days?
36%30-day reorder rate
22 of 61 retailers reordered inside a month, up from 15 in the previous quarter.
Reads from: Invoice register, rolling 90 days
Sales
Is our average order value growing or shrinking?
₹24,180Average order value
Order value is up 8% but order count is down 4%, so growth is coming from fewer, larger orders.
Reads from: Invoice register, 6 months
Sales
How much of this month came from new customers?
17%Revenue from new accounts
New accounts contributed 17% of revenue, the highest share in five months.
Reads from: Invoice register + customer master
Sales
Which channel grew fastest this year?
+41%Direct retail, year to date
Direct retail grew 41% while distributor volume stayed flat.
Reads from: Invoice register, channel tagged
Sales
What share of quotations turned into orders?
38%Quotation to order
38% of quotations converted; the ones that converted were answered within 2 days.
Reads from: Quotation sheet + invoice register
Sales
Did festive demand arrive earlier this year?
-11 daysShift in peak week
The peak week moved forward by 11 days against last year.
Reads from: Invoice register, two years
Inventory
Which SKUs haven't moved in 90 days?
₹12.6LValue with no movement
38 SKUs are idle, and curtain fabric is half the value.
Reads from: Stock register, movement dates
Inventory
What will run out in the next two weeks?
6 SKUsBelow 14-day cover
6 fast movers fall below cover at current run rate; two have 19-day lead times.
Reads from: Stock register + sales velocity
Inventory
Where does the physical count disagree with the system?
₹1.8LUnreconciled value
23 SKUs differ by more than 5 units, concentrated in one godown aisle.
Reads from: Stock register + physical count sheet
Inventory
How old is the stock we are holding?
28%Stock older than 120 days
28% of inventory value is older than 120 days, up from 19% in April.
Reads from: Stock register, GRN dates
Inventory
Which supplier is slipping on delivery?
+9 daysSlippage vs commitment
One supplier has averaged 19 days against a committed 10, every month since June.
Reads from: Purchase order book + GRN sheet
Inventory
What is slow stock costing us to hold?
23 daysPurchases locked in idle stock
Idle stock is absorbing working capital equal to 23 days of purchases.
Reads from: Stock register + purchase book
Inventory
Is stock sitting in the wrong location?
41ptGap between stock and demand share
Salem holds 62% of curtain fabric but generates 21% of curtain sales.
Reads from: Stock register + branch sales
Inventory
Has our buying price moved without us noticing?
+7.4%Landed cost drift
Landed cost on one fabric line rose 7.4% across three POs without a price revision note.
Reads from: Purchase book, landed cost column
Inventory
Where is wastage highest on the floor?
4.1%Wastage, B shift cutting
Cutting wastage is 4.1% on one shift against 2.3% on the other two.
Reads from: Production log + issue slips
Inventory
Are our reorder levels still right?
14 SKUsReorder level below run rate
14 SKUs have a reorder level set for last year’s demand and now stock out twice a month.
Reads from: Item master + stock movement
Finance
Who are our slowest-paying customers?
₹18.7LCash locked past 60 days
Four accounts on 30-day terms are averaging 61 to 83 days.
Reads from: Tally receivables ledger
Finance
Which product line actually makes money?
11.2%Curtain contribution margin
Curtains carry the highest price but the lowest contribution after returns and freight.
Reads from: Sales + cost sheet + credit notes
Finance
Which expense head grew faster than revenue?
+34%Freight, year on year
Freight is up 34% against 11% revenue growth, driven by part-load dispatches.
Reads from: Tally expense ledger, two years
Finance
How long is cash tied up end to end?
74 daysCash conversion cycle
Cash conversion is 74 days; 41 of them sit in receivables.
Reads from: Tally ledgers + stock register
Finance
Which customers are over their credit limit?
₹6.9LExposure above limit
Three accounts are above sanctioned limit, one by 2.4 times.
Reads from: Receivables ledger + credit master
Finance
Do our sales registers tie to the filed returns?
₹42,600Unexplained variance
A ₹42,600 gap traces to four invoices booked in the wrong tax period.
Reads from: Sales register + return summary
Finance
How much will we actually collect next month?
₹31.2LExpected collection
Based on each account’s own payment history, ₹31.2L against ₹44.8L due.
Reads from: Receivables ledger, 18 months
Finance
Which vendor advances are still unadjusted?
₹4.3LUnadjusted advances
11 advances older than 90 days remain open, two from last financial year.
Reads from: Tally payables ledger
Finance
Which branch is profitable after allocated cost?
2 of 3Branches profitable
Erode turns positive once freight is allocated by weight instead of revenue.
Reads from: Tally ledgers, branch tagged
Finance
Did we pay any supplier bill twice?
₹2.1LPossible duplicate payments
3 bills match on supplier, amount and bill number within 10 days of each other.
Reads from: Payables ledger + bank statement
Payroll
How much overtime did we pay in Q2?
₹6.84LQ2 overtime cost
₹6.84L, with packing B shift running overtime in 11 of 13 weeks.
Reads from: Payroll OT register, quarter
Payroll
Where are we losing people fastest?
31%Stitching attrition
Stitching attrition is 31% annualised; 7 of 9 exits were inside their first 90 days.
Reads from: Payroll master, joiners and exits
Payroll
Does attendance match the roster?
184Unmatched shift-days
184 shift-days were rostered but not punched, 71% of them on Saturdays.
Reads from: Roster sheet + biometric export
Payroll
What does one shift actually cost us?
+18%B shift cost per unit
B shift costs 18% more per unit packed once overtime is included.
Reads from: Payroll register + production log
Payroll
How much unused leave are we carrying?
1,140 daysAccrued leave balance
1,140 days of accrued leave sit with 38 employees, concentrated in long-tenure staff.
Reads from: Leave register + payroll master
Payroll
Are people in the same role paid consistently?
2 rolesSpread above 40%
Two roles show a spread wider than 40% between the lowest and highest paid.
Reads from: Payroll master, current month
Payroll
How much of the floor is contract labour?
44%Contract share of headcount
Contract labour is 44% of headcount but 29% of cost, and rising in packing.
Reads from: Payroll register + contractor bills
Payroll
How long do new joiners take to reach full output?
34 daysMedian ramp to full output
Median ramp is 34 days; joiners paired with a senior operator reach it in 21.
Reads from: Production log + joining dates
Payroll
What is unplanned absence costing in overtime?
1.6 hrsOvertime per absence
Every unplanned absence in packing generates 1.6 hours of overtime elsewhere.
Reads from: Attendance export + OT register
Payroll
Is PF deducted for everyone who should have it?
6Missing deductions
6 employees above the eligibility threshold have no PF deduction this month.
Reads from: Payroll register, statutory columns
Go deeper
Ten questions per library, with the data each one needs.
10
Sales questions
Revenue, territory, retailer mix and the orders that quietly stopped coming.
Invoice registers, order books, CRM exports and Tally sales ledgers.
Open library10Inventory questions
Stock age, dead SKUs, reorder timing and the warehouse that never reconciles.
Stock registers, GRN sheets, purchase books and warehouse movement logs.
Open library10Finance questions
Receivables, margin by line, spend drift and where the working capital went.
Tally exports, receivable ledgers, expense books and bank statements.
Open library10Payroll and workforce questions
Overtime, attrition, shift cost and attendance that does not match the roster.
Payroll registers, OT sheets, attendance exports and biometric logs.
Open libraryThe question you keep putting off
Type it. Get the answer.
No dashboard to build, no analyst to brief, no 40-tab workbook to open first. Connect a source and your first answer lands in about two minutes.
Want to see it against your own workbook first? Contact us
- Read-only connections
- Source and rows on every answer
- Never used to train models