Who can use the LR Telegram bot (t.me/Kuberlrbot). Get someone's numeric chat ID by having them message @userinfobot on Telegram and send you what it replies.
Loading…
LR
Add each expired/damaged item found in the warehouse, then submit for admin approval.
Loading…
New Company Claim
All Claims
Loading…
Correct expiry-stock quantities directly — positive to increase, negative to decrease. Every change is logged.
Loading…
Claim
Audit — Add Line
Pick item
Issue Details
Items Affected
Photos
Loading…
Issue
Pick item
Your draft orders
Search for a customer to begin.
Quick order for
One product per line. End a line with a quantity — add cs/case/carton/box/cbb right after it for a box quantity, otherwise it's counted in pieces. e.g. colgate mfp 200g 5cs
to
Loading your orders…
My product requests (new items not in Kuber)
Product requests
Loading requests…
Pre-Receiving
to
Loading…
New Receiving
Invoice reference photo (optional)
Reference photo pages: 0
Products Recorded: 0 · Total Quantity: 0
Added so far
Quantity
Product
MRP
Billed Qty
UOM
Actual Qty Received
Loading now
Recent loads
to
Loaded / sold / returned / currently in the van, per product, across this van's whole history.
to
Net business per customer for the selected range (Sell from Van + Book Order, minus any Customer Returns) — defaults to today.
to
Or pick a shop sold to before
Stock leaves the van now — reduces what's on board.
Full stock list, fulfilled from the warehouse later — nothing leaves the van.
Or pick a past cash shop
Recent returns
to
Returning now
Cash on hand₹0
Pending confirm
Settled
Confirm this load
Product
Boxes
Pcs
Total pcs
Payment received
Invoice total₹0
to
Loading orders…
Make Invoice — Export for Kuber
Select confirmed orders, then download the Kuber import file (.xls).
Loading confirmed orders…
Loading customers…
Outstanding
—
to
Loading statement…
Outstanding
Loading…
Loading…
Credit Analysis
Loading…
My Tasks
Loading…
Analytics
Days of Supply
Current stock ÷ average daily sales (last 90 days) — lowest first, i.e. most urgent to restock
Customer Payment Trend
Average days between a sale and its receipt, by month — a shift shows the pattern changing
Red Flags
Customers whose order volume dropped sharply, or whose payment delay increased sharply, vs their own recent history — plus data-integrity checks like reused voucher numbers
Lapsed Customers
Bought something in the prior period, nothing in the recent one — pick both ranges
Unbilled Customers
No sale since the chosen date — includes customers never billed at all in the data currently loaded
Buying the Brand, Not the Product
Still buys from a brand recently, but has stopped a specific product — MRP variants of the same product don't count (uses the Catalogue's product grouping)
Customer Segments (RFM)
Recency / Frequency / Monetary, last 180 days — the standard distribution customer-health view
Business by City
Total invoiced sales by customer city — which cities generate how much business, and how many invoices/customers behind that number. Leave dates blank for all-time.
to
Ask about the business
Free-form questions, answered using the same reports above — e.g. "which customers have red flags", "has Sharma Traders' payment pattern changed", "who hasn't bought since April"
Notes here are added to every question the assistant answers — use them for corrections you don't want to repeat (e.g. "GST rate for X brand is 12%, not 18%").
Performance
Confirmed orders only
Loading…
Salesman leaderboard
to
Loading…
Team metrics
Loading…
Hourly orders punched (today)
Loading…
Daily confirmed value (last 14 days)
Loading…
Incentive tracker
Loading…
Catalogue
Loading groups…
Loading catalogue…
Loading…
Users & access
Add / link a login
Step 1: create the user in Supabase (Authentication → Add user). Step 2: link the same email here and pick a role. Scopes and module toggles appear on the card below after linking.
Loading…
Settings
Business rules and thresholds used across the app — changes apply immediately, everywhere.
Loading…
Cross-firm
Sign in to each firm to load stock…
Rajlaxmi sale invoices billed to Mahalaxmi Enterprises (party A2783), with items translated to Mahalaxmi's own item codes where mapped — read this off while entering the Purchase voucher in Kuber. Unmapped items need a one-time mapping below before they'll translate.
Loading…
Mahalaxmi sale invoices billed to Rajlaxmi Enterprises, with items translated to Rajlaxmi's own item codes where mapped — read this off while entering the Purchase voucher in Kuber. Unmapped items need a one-time mapping first.
Loading…
Every mapping between another firm's item/super-product and Mahalaxmi's own — map products here even if they've never appeared on an inter-firm invoice (e.g. items both firms buy directly from the same principal).
Add a mapping
Loading…
Reports
Reports
Sales
Customer
Compliance & Tax
Route & Warehouse
Cross-Firm
Loading…
Loading…
Loading…
Unresolved entries currently parked in the Bank Reconciliation A/c — tap one to find the most likely counterparty from past narrations (this year first, then prior years).
Loading…
Loading…
Loading…
Loading…
Search a customer to enroll them in ROU. Ending an enrollment keeps its history — it's never deleted.
Enrolled customers (current & past)
Loading…
Period A
Period B
Loading…
Automatically email this Customer Sales report on a recurring schedule.
Ctrl/Cmd-click to pick multiple cities. Leave nothing selected for all cities.
Customers (all included by default — untick any to always exclude them from this schedule)
Customer
Loading…
GSTR-1 Table 12 format — HSN-wise summary of outward supplies (secondary sales, net of returns), ready to copy into the actual filing. Flags below are review nudges based on current GST law, not a compliance verdict — always have your CA confirm before filing.
Loading…
Matches our purchase register against Kuber's own imported GSTR-2B download by GSTIN + invoice number (normalized). Scoped to where we actually have purchase data synced — older GSTR-2B periods aren't compared since we'd get false "missing" flags from a data gap, not a real issue. Not a compliance verdict — always double-check before acting.
Every supplier's filing history in GSTR-2B (full available history, not just this range) — chronic late/non-filers are a forward-looking risk, not something a one-time download shows on its own.
Lines where GSTN itself flagged ITC as not available — a direct compliance signal, not an inference.
Loading…
Consolidated audit-style flags across the whole portal — a starting point for review, not a compliance verdict. Always verify before acting.
Loading…
Loading…
Computed by this app from Kuber's synced general ledger (party_master) — not pulled from Kuber's own printed report. Reconcile against Kuber's own statement before relying on these for filing or lending purposes.
Loading…
Pending (undispatched) invoices, grouped by delivery route → city → party → date. Tap an invoice to view it. Excludes SAM- sample invoices and @-locked (settled) invoices.
Loading…
Products on at least one pending (route-candidate) invoice where demand exceeds physical stock. Shortage qty = total pending demand minus physical stock (Kuber stock + qty tied up in pending invoices).
Loading…
Batch/expiry tracking for drug-licence products only (Ring Guard, Strepsils, Disprin Tab). Balance = purchased minus sold minus returns, per batch, sorted by nearest expiry first. Stays empty until batch number + expiry date start getting entered at goods-receipt in Kuber.
Loading…
Warehouse packing status per invoice — tap a status pill on a card to change it. Red border = not packed within 3 days of the invoice date.
Loading…
Town → Route
A border town can be valid on more than one route (e.g. Sirohi works on 3 different corridors) — set its usual (primary) route, then add any other routes it could also ride along on when that route's load is light.
For a customer closed every week on one or more fixed days (e.g. every Sunday) — pick as many as apply.
Loading…
Vacation / temporary closures
One-off date ranges with no recurring pattern — e.g. a customer's shop shut for a specific week.
Loading…
Tithi calendar
Confirm which tithi falls on which date — amavasya and punam are just two examples, add any tithi. This alone doesn't close anyone; a customer only flags red on a date if that tithi is also marked as one of their own off-days below.
Loading…
Customer off-days
Search a customer and mark which tithi(s) they're off on. Their pending invoices flag red on any day that matches.
Loading…
Carton weight by brand
Brands without a weight set here default to 10 kg/carton.
Loading…
Vehicle fleet
Used to suggest which vehicle fits each route's pending load, in "M-equivalent" cases (see Item weights → carton size class).
Loading…
Loading…
Every TDS/TCS account in the books — "Duties & Taxes" (own TDS payable/TCS collected) and "Loans & Advances" (TDS the brands deducted, claimable as credit). A non-zero payable balance is worth checking against whether it's actually been deposited.
Counterparties crossing ₹50L this period on either side. This is a review flag, not a compliance verdict — 194Q/206C(1H) only bite if your own prior-year turnover crossed ₹10cr (not checked here), and this can't see whether TDS/TCS was actually applied for this specific party (that's recorded in the aggregate ledger accounts above, not per-party). 194Q and 206C(1H) are mutually exclusive per CBDT Circular 13/2021 — a party flagged on both is worth a closer look.
Loading…
Sundry Debtors billed in this range with no security-cheque note on file (customers.remarks, synced from Kuber). Empty = no note recorded — a non-empty note isn't guaranteed to be a cheque specifically, that depends on data-entry convention.
Loading…
Billed customers (at least one invoice ever) missing a mobile number, or with a city set but no address on file.
Loading…
Item codes with real sale/purchase history but no resolvable brand (falls into "Unknown" on every report). Sorted by lifetime sale amount. Pick a brand (existing ones autocomplete) and save — updates item_master directly.
Loading…
Party codes with real sale history but no matching customer record — not auto-resolved by name lookup or GSTIN match. Either link to an existing live customer (their history rolls up into that customer) or set a name/city manually.
Loading…
Pairs of item_codes with very similar names within the same brand — likely the same real product recorded under two different codes (a price/pack revision, a typo, a duplicate entry). Sorted by combined lifetime sale value. Confirming a merge lets reports that cross-check by item_code (e.g. Discount Variance's purchase-cost check) find purchases/sales across both codes. Only dismiss/confirm pairs you can see really are (or aren't) the same product from the names shown — a high score is a hint, not proof.
Loading…
Stock Verify
Loading…
Pick a company, optionally narrow to specific brand-groups, then choose which pending (undispatched) invoices to add back to the count as "still physically in the warehouse".
Loading…
Samsung
Loading…
Loading…
Loading…
Generate NDC Letters
Compiles one letter per active dealer into a single document — a print dialog opens; choose "Save as PDF".
Loading…
IMEI Formatting
Upload a raw IMEI export (grouped by product, or already flat) — downloads a formatted copy with one row per IMEI and the product filled in on every row.
Loading…
Aged Dealer Stock vs Scheme Support
Loading…
All tracked scheme letters
Loading…
Loading…
Special Tie-Ups
Dealers with a custom gift/reward arrangement instead of the standard per-unit payout (e.g. Samsung's "Dhanvarsha" silver scheme) — their dealer-facing message shows this reward table instead of the payout slabs.
Loading…
Activation Data
Upload Samsung's activation Excel file — the Master historical file first, then daily/as-available MTD files after. Only IMEI/ActivationDate/ModelNo/ProductCode/TertiaryBuyerCode/TertiaryBuyerName/TertiaryOrderReason/MRP columns are used; only TertiaryOrderReason=NORMAL rows are kept. If the file has a "category" sheet (TertiaryBuyerCode/TertiaryBuyerName/Category), that's imported too. Re-uploading dates already on file REPLACES them. Also fetched automatically each morning by a bot — this status line reflects whichever happened most recently, bot or manual.
DMS Stock
Upload Samsung's own DMS Stock report (MDD Code=RAJR003654) — treated as the dealer stock figure for reports like Stale Stock, even if it doesn't exactly match a physical count. Every upload REPLACES the entire current snapshot — this is "stock as on <date>", not a running history. Report list is under the "DMS Stock" tab.
Zero Stock Outlet Tracker
Upload Samsung's Zero Stock Outlet Tracker (SRD Code=RAJR003654) — lists which model families are REQUIRED at each dealer for the month, and whether each is currently at zero stock. On any day this isn't freshly uploaded, the report falls back to computing zero-stock status live from DMS Stock instead. Report list is under the "Zero Stock Outlets" tab.
Sell In/Sell Out
Upload Samsung's Day-Wise Sell In/Sell Out report (RAJR003654). Columns are cumulative Month-to-Date figures as of each row's date, not that day's own qty — the report below always uses the latest value within a month. Re-uploading a date already on file replaces it.
GMCS Declarations
Upload GMCS declaration data — one row per IMEI. Unlike every other upload here, this NEVER overwrites: an IMEI already on file is left untouched, only new IMEIs get added. Upload as many monthly files as you have; nothing needs to be re-uploaded.
Loading…
Total activation-unit target per dealer for the month — separate from the per-model Sellout target in Dealer Plan. TSE Rollup on Target vs Actual sums these automatically.
Loading…
Loading…
Loading…
Loading…
Upload from Samsung Data ▸ All Uploads. Snapshot below reflects the latest upload — "stock as on <date>", not a running history.
Loading…
Pulls straight from DMS Connect itself — no manual upload, no login needed. Also pushes the same report to the Samsung Telegram group. Takes 30–90 seconds; only one DMS Connect task can run at a time, so this may briefly wait if another is in progress.
Last 30 days of real activation (yesterday back 30 days) per dealer+model, × factor, minus DMS Connect's own current dealer stock for that model = how much still needs to go out. Uses the same live Dealer Stock data as the Live DMS Reports tab — refresh there first if it's stale.
Loading…
IMEIs physically here (per your physical scan upload below) that DMS Connect's own Dealer Stock still shows as sold to a dealer — stock being carried twice on paper. Needs a fresh physical scan upload and a fresh Live DMS Reports → Dealer Stock fetch to be accurate.
Loading…
IMEIs DMS Connect's own MDD stock still shows as ours, but aren't in your physical scan upload — likely sold in Kuber without DMS being told. Shows who it was actually sold to, from Kuber's own records.
Loading…
Upload from Samsung Data ▸ All Uploads. On any day this isn't freshly uploaded, the report below falls back to computing zero-stock status live from DMS Stock instead.
Loading…
Compares Samsung's DMS Stock snapshot against Rajlaxmi's own physically-counted Dealer Stock, model by model — useful to see where the two disagree.
Loading…
Compares Samsung's own Tertiary figure (Sell Thru2, dealer → end consumer) against our real IMEI-level Activation data for the same month — two independent measurements of the same thing.
Loading…
GMCS (Sales Type=MCS SO) is the dealer self-declaring a sale for payout, separate from a real Activation (SIM inserted). Samsung penalizes a dealer if a GMCS-declared unit isn't matched by a real Activation within 90 days. "First GMCS" is approximate — the earliest snapshot date this model showed a positive GMCS qty, not an exact per-unit declaration date.
Loading…
Dealers with GMCS-declared IMEIs sitting unsold 60+ days since Sell In. Tap a dealer to see which IMEIs/models.
Loading…
IMEIs sitting unsold 80+ days since Sell In — flagged for immediate sales return from the dealer.
Loading…
Upload SPD's Allocation .xlsx (the "Mobile tab Wearable" sheet — Accessories aren't activation-tracked, so that sheet is left untouched). Per model code: purchasable qty = last-10-days activation count minus current Kuber stock, rounded up, floored at 0. If a model's been tracked under that many days, uses (lifetime activations ÷ days tracked) × window instead of the raw count. Models with zero activation history ever get 0 — not auto-ordered. Rows with qty > 0 get pushed to the Samsung Telegram group automatically once processed, so it can be reviewed/edited on the go.
Auto-fetched from today's "Available Stock" email (also sent to Telegram) —
Downloadable multi-sheet Activation Tracker — Tracker, No Sale Today, Dealer x Model, LMTD vs MTD, Model Family, Day-wise MTD (each of the last 3 split into All + one sheet per TSE). LMTD/Base always compare against the same day-range / full total of the calendar month right before the date picked below.
Pick a date and tap Preview.
Dealer-wise sellout — MTD vs LMTD Qty and Amt (all models, same rolling day-range comparison as Activation Tracker), with separate Volume and Value growth/degrowth %.
Pick a date and tap Preview.
Independence Scheme — A07/A17/A27 family sellout (activations), MTD vs LMTD (same day-range of the prior month, always rolling). Also sent to Telegram automatically every day at 10am.
Loading…
Samsung's RISE MBO scheme, GMCS 5G Innovative smartphone sellout — fetched automatically each morning from the daily tracker email. Gate/Slab are Samsung's own computed values, shown as-is.
Loading…
Samsung/Anant Telelink credit notes — the Register is a straight list of every CN as Samsung issues it; the Payout Tracker pivots your own rcn-verified claim lines into per-IMEI, per-scheme payout (only IMEIs you've personally tagged with an rcn reference show up here).
Loading…
Pick a dealer and month.
Samsung's own scheme narration is long and repeats a lot of legal boilerplate — give each recurring scheme a short label here; it's what shows as the column header in the Payout Tracker.
Loading…
IMEIs from your CN payout data with no Kuber-side activation record. Where Samsung's own IMEI Validation report already shows a GMCS declaration for that IMEI, the phone was billed but never activated by an end consumer — real penalty risk. GMCS history only goes back to Jan 2026 on Samsung's own portal.
Loading…
Expiry Claims
Loading…
Print or reprint the pickup Loading Slip for an approved claim — this list stops showing a claim once it's marked received.
Loading…
Approved claims move here once goods are physically expected at the warehouse — mark received, verify quantities item-by-item, then complete verification.
Loading…
Verified claims move here to work out the credit — start settlement, set qty/rate per line, record the Kuber-side credit note number, then mark settled.
Loading…
Loading…
Expiry Loss vs Sales, by Company
Frequent Claimers (last 90 days)
Top Claimed Products
Top Customers
Generate or regenerate a customer's no-login expiry-claim link. Regenerating disables the previous link for that customer.
Reconciliation
Past Uploads
Loading…
Past Uploads
Loading…
Letters
Loading…
Loading…
Loading…
Loading…
Loading…
Stock Market
Loading…
Loading…
Enter tickers above and run the screener.
Fundamentals-only screen over the Nifty 500 (sector-relative ROE/ROCE/D-E/growth/valuation, earnings-quality gate, NSE Quality Index basket). A full run takes 20–60 minutes — runs in the background on the VM and refreshes weekly on its own; Run Now just kicks off an extra one.
No data yet — Run Now, or wait for the weekly refresh.
Outlet Geomapping
Loading…
Are you at this outlet right now?
Symbol
Claim
Warehouse Verify
Settlement
Session
Orders
Performance metrics
New task
Outstanding
Pending Cash Bill
Full Statement
Invoice
Tags —
Assigned
Add existing tag
New tag
Sign in
Map to Mahalaxmi
Their own name won't fit Mahalaxmi's naming style — type a name the way Mahalaxmi's own catalog names it. Kuber creates the product from this name on export/import; you can link it to the real item code later once it syncs back.