📂 Data Source
💻 Local Files
|
☁ Google Drive
EVPL Dashboard v156
Everthrive Ventures · Sales, Purchase, AR, Stock & 20 Sub-Reports + MDC & Financial Status · Load files then click a report
📂 Load Data Files
💻 Local Files
|
☁ Google Drive
🔑
Connect
📂
Scan
⬇
Download
⚙
Parse
✅
Ready
📅 Tally:
🧾 Vouchers:
📧 SO Email:
Quick Reports
🔍 Master Data Check
💰 Financial Status
Sales & Orders
5📦
SO Report
Sales Orders — pending, dispatched & fulfilled order tracking
→
🧾
Sales Analysis (Customer & Item)
Customer- & item-wise sales over any date range — exportable to Excel
→
📅
Daily Operational Report
Day-wise sales trend, target vs actual & daily performance
→
🌐
Fan Report
Fast / Average / Non-moving items — identify slow stock
→
⭐
Top Focus Report
Priority items & parties needing immediate attention this period
→
Receivables & Collections
4🔔
AR Report
Accounts Receivable — outstanding dues & aging analysis
→
📋
Collection Tracking
Customer credit limits, utilisation & collection follow-up
→
📈
Invoicing Proposal
Item & party-wise invoicing proposal with SKU-level margin
→
🧾
Receipts & Payments
Cash & bank receipt tracking, cheque bounce & payment register
→
Purchase & Payables
5🏢
Purchase Proposal
Distributor & party-wise purchase planning & proposal
→
⚖️
Purchase vs Sales
Item-wise purchase & sales comparison — margin, movement & matrix
→
🧮
Item Purchase vs Sales Matrix
Per-item pivot — Current Stock · Purchase by voucher type · Sales by region
→
💹
Purchase vs Sales vs Collection
Tax-inclusive cash-flow trend by period & vertical — purchases, billed sales & collections
→
💳
Account Payable
Channel finance + Signify payables — sanction limit, due dates & overdue tracking
→
Inventory & Data Quality
5🎯
Current Focus · Focus Item
Liquidation tracker for focused stock — live period sales, new-stock alerts & status per item
→
🏭
Stock Report
Item-wise stock levels, godown-wise valuation & movement
→
📍
Stock by Location
Closing stock quantity & value split across godowns — matrix & item×location list
→
🚚
LR / RR Report
Lorry & Railway Receipt dispatch register — carrier-wise & box count
→
👥
Customer Index
Full customer profile — transaction history, outstanding & loyalty
→
🛠️
Data Entry Correction Needed
Surfaces likely data-entry mistakes for review & correction
→
Management Review
2💹
Sales vs Collection Tracking
Sales (with & without tax) vs customer collections — by Month, Customer or Ledger Group
→
🧾
Purchase vs Payment Tracking
Purchases (with & without tax) vs supplier payments — by Month, Voucher Type, Supplier or Ledger Group
→
How transactions are grouped (from master data)
Every Sales / Purchase / Credit Note / Debit Note row is enriched by walking the master-data hierarchy:
Party Ledger → Ledger Group Name → Ledger Group Parent → Business Vertical.
Every inventory line is enriched: Stock Item → Parent Group → Item Group Parent → Item Brand.
Filters below apply the same resolved taxonomy across every sheet, so results are consistent.
Unified Filters — apply to Sales, Purchase, Credit Note, Debit Note & all Inventory sheets
Date Range
Party & Ledger Hierarchy
Drill-down →
Business Vertical
›
Ledger Group Parent
›
Ledger Group Name
›
Party Ledger
All▼
All▼
All▼
All▼
Voucher Type
Filter by specific voucher types (Sales, Purchase, etc.)
All▼
Inventory
Applies to Sales/Purchase/Credit/Debit Inventory sheets only
All▼
All▼
Daily Operational Report Filters Daily Operational Report — select a single date and apply standard filters to view daily transactions.
Report Date
View transactions for this specific date
Party & Ledger Hierarchy
Drill-down →
Business Vertical
›
Ledger Group Parent
›
Ledger Group Name
›
Party Ledger
All▼
All▼
All▼
All▼
Voucher Type
Filter by voucher type
All▼
Inventory
Filter by Item Brand / Group
All▼
All▼
Fan Items Report Filters 🌀 Fan Report — fan item sales, purchases & collections by date range
Apply filters to load…
Select LG Parent first…
Load data and click Apply to see purchase voucher types…
Load data and click Apply to see sales voucher types…
Accounts Receivable Filters 📊 AR Report — outstanding customer receivables · Sundry Debtors only
Business Vertical (click to select — multiple allowed)
Ledger Group Parent
Load data to see options
Ledger Group Name
Load data to see options
Aging Bucket
📈 Sales & Margin
Total Sales (excl. tax)
—
Net Sales (excl. tax)
—
Sales − Credit Notes
Gross Margin
—
Credit Notes (excl. tax)
—
Sales Returns (RTN, excl. tax)
—
Invoices
—
Unique Customers
—
Avg Invoice (excl. tax)
—
Fans Sold (units)
—
🛒 Purchases by Vertical (excl. tax · Net of Debit Notes)
📊 Receivables · Collections · Stock
📥 Total Receivables
—
Sundry Debtors outstanding
⚠️ Overdue >60d
—
Bills >60 days old
📅 DSO
—
Days Sales Outstanding
💰 Collected (MTD)
—
From overdue customers this month
📈 Recovery Rate
—
Collected ÷ Overdue outstanding
📦 Closing Stock
—
At cost · click to open report
🔄 Stock Turnover
—
COGS ÷ Closing Stock
Debit Notes (excl. tax)
—
Supplier returns
🏦 Bank · Payables · Bounce Risk
🏦 Bank Balance
—
All bank accounts · click for FS
📤 Total Payables
—
Sundry creditors · click for FS
⚠ Bounce Risk Parties
—
Customers with cheque bounce · click for R&P
💰 Director Capital
—
Total capital from directors
⚖ Working Capital
—
Current Assets − Current Liabilities
📋 Reports Hub — click a report to open it
📦
Sales Order Report
Track Sales Orders vs actual Sales fulfillment. View pending, partial, and completed orders with aging analysis.
Open Report
📊
Stock Valuation Report
Closing stock values from the Tally Item master. Includes ABC analysis, brand-wise breakdown, and inventory health indicators.
Open Report
📅
Daily Operational Report
Sales and customer collections summary for a specific date. View day vs MTD sales and payments received from customers, grouped by Ledger Group.
Open Report
🌀
Fan Items Report
Monthly stock movement for Fan items — purchases, sales and closing stock grouped by month with ledger group summary, customer analysis and PDF export.
Open Report
📊
Accounts Receivable
Outstanding bill-wise aging analysis — party-level receivables, days-pending breakdown (0-30 · 31-60 · 61-90 · >90 days), payment performance and drill-down by party.
Open Report
🧾
Invoicing Proposal
Open Sales Orders eligible for invoicing — checks customer credit (>60-day overdue must be ≤ ₹1,000) and stock availability for every pending order line.
Open Report
💰
Collection Tracking
Monthly recovery tracking for customers with overdue bills at month start (configurable: 30/60/90/120 days) — shows collected vs remaining balance and recovery rate for each party.
Open Report
🛒
Purchase Proposal
Item-wise purchase recommendations based on open Sales Orders vs current stock. Shows shortfall qty, proposed purchase qty, and average monthly sales for each item.
Open Report
🏆
Customer Index
Rank customers by a composite score (0–100) across payment speed, order volume, reliability, and outstanding health — identify your best and at-risk customers.
Open Report
🗺️
Purchase vs Sales — Area Wise
Compare purchases and sales by voucher type with state-level area breakdown. Interactive item drill-down shows what was bought vs sold per region.
Open Report
💳
Receipts & Payments
Full payment tracking from the All Vouchers file — receipts, payments, cheque bounces, and invoice-to-receipt matching. Requires the All Vouchers file to be loaded.
Open Report
💹
Purchase vs Sales vs Collection
Tax-inclusive cash-flow trend — purchases, billed sales and customer collections over time, by business vertical. Month / Quarter / Year · Financial or Calendar year.
Open Report
🎯
Current Focus · Focus Item
How we are liquidating the focused stock items — live sales in the period, new-stock alerts, status & suggested action per item, with total and current stock-value cards.
Open Report
⭐
Top Focus Report
Ranked analysis of Top Customers, Top Selling Items, Top Stock Value, and Top Profitable Items — with Pareto 80/20, concentration risk, ABC classification, and margin health benchmarks.
Open Report
🚚
LR / RR Dispatch Register
Lorry & Railway Receipt tracking — carrier name, LR-RR number, dispatch date, no. of boxes, and full sales detail with vertical & ledger group breakdown.
Open Report
⭐ Top Focus Report Focus Analysis — ranked analytics with industry benchmarks
📅 Period
to
—
📈 Sales Report Filters
Date Range
Party & Ledger Hierarchy
All Verticals
▾
All Groups
▾
All Sub-Groups
▾
All Parties
▾
Voucher Type & Inventory
All Types
▾
All Brands
▾
All Item Groups
▾
Monthly Sales — Basic Amount (₹)
Monthly Transactions & Unique Parties
Sales by Business Vertical
Monthly Trend by Vertical
Top 15 Ledger Groups by Sales (₹)
Ledger Group Rollup
| Ledger Group | Amount ₹ | Txns | % Share |
|---|
Top 15 Parties by Sales (₹)
Party Rollup
| Party | Amount ₹ | Txns | % Share |
|---|
Sales by Voucher Type
Voucher Type Rollup
| Voucher Type | Amount ₹ | Txns | % Share |
|---|
Sales by Item Group — from Inventory lines
Item Group Rollup
| Item Group | Qty | Amount ₹ | % Share |
|---|
🧾 Transaction Detail
| Date | Voucher No | Voucher Type | Party | Vertical | Ledger Group | Basic Amt ₹ | Tax ₹ | Total ₹ |
|---|
Sales Analysis Filters 🧾 Customer & Item — pick a date range and apply the standard sales filters.
Date Range
View sales between these dates (inclusive)
Party & Ledger Hierarchy
Drill-down →
Business Vertical
›
Ledger Group Parent
›
Ledger Group Name
›
Party Ledger
All▼
All▼
All▼
All▼
Voucher Type
Filter by voucher type
All▼
Inventory
Filter by Item Brand / Group
All▼
All▼
👤 Sales by Customer
| Customer | Vertical | Ledger Group | Items | Invoices | Qty | Sales ₹ | % Share |
|---|
📦 Sales by Item
| Item | Item Group | Brand | Ledger Group | Customers | Invoices | Qty | Sales ₹ | % Share |
|---|
📂 Sales by Ledger Group
| Ledger Group | Vertical | Customers | Items | Invoices | Qty | Sales ₹ | % Share |
|---|
📈 Ledger Group Performance over time
GRANULARITY
PERIOD
CHART
Cells are heat-shaded by sales value across the whole matrix. The Trend column shows each group’s sales shape and the change from its first active period to the latest.
View defaults to Month, and switches to Year automatically when the selected range spans multiple years — use Financial ⇄ Calendar to change how quarters/years are bucketed.
🎯 Current Focus — Focus Item — how we are liquidating the focused stock items
📅 Sales Period
to
🔎 Item search
📊 Status
🗂 Category
🏢 Business Vertical (of the sale)
Load data first…
🏷 Customer Ledger Group (of the sale)
Load data first…
| # | Focus Item | Category | Status | Pur Qty | Sold (all-time) | Sell-thru % | Cur Stock | Stock Value ₹ | Sold in Period (Qty) | Sold in Period ₹ | New Stock (period) | Suggested Action |
|---|
Sold in Period and New Stock (period) are computed live from the Sales Inventory and Purchase Inventory sheets, matched to each focus item by its SKU code, within the selected Sales Period (New Stock honours date + vertical). Pur Qty · Sold (all-time) · Sell-thru % · Cur Stock · Stock Value · Status · Suggested Action come from the Focused items sheet snapshot. A highlighted New Stock cell flags fresh stock of a focus item purchased during the period.
💹 Purchase vs Sales vs Collection — tax-inclusive cash-flow trend by period & business vertical
📅 Date Range
to
GRANULARITY
PERIOD
🏢 Business Vertical
Load data first…
By Period
| Period | Purchase ₹ | Sales ₹ | Collection ₹ | Coll % of Sales | Net S−P ₹ |
|---|
By Business Vertical
| Vertical | Purchase ₹ | Sales ₹ | Collection ₹ | Coll % |
|---|
All figures are tax-inclusive: Purchase = purchase-voucher totals, Sales = sales-voucher totals, Collection = customer receipt vouchers (needs the All-Vouchers file). Coll % of Sales = collection ÷ billed sales in the period (cash realisation). Verticals are classified from the voucher type via the enriched inventory map. Defaults to Month, switches to Year automatically across multiple years.
🛒 Purchase Proposal Filters PP Report — multi-select with cascade
All▼
All▼
All▼
All▼
All▼
All▼
🛒 Purchase Proposal PP — open SO demand vs current stock · proposed purchase quantities · avg monthly sales
🛒
No Sales Order data found
Ensure the loaded file contains a
Sales Order Inventory sheet from Tally.🛒 Items to Purchase
—
unique items with shortfall
🔴 Zero Stock
—
items with no stock at all
🟡 Partial Stock
—
items with insufficient qty
✅ Sufficient Stock
—
items fully covered
📋 Open SO Lines
—
pending SO line items
📦 Total Pending Qty
—
across all open SOs
💡 Logic: Pending SO Qty = Open SO Qty − Already Invoiced. Proposed Purchase = max(0, Pending SO − Closing Stock). Avg Monthly Sales from all Sales Inventory vouchers.· All SO dates
| # | Item Name | Brand | Group | Pending SO Qty | Closing Stock | Godown | Proposed Purchase | Avg Monthly Sales | Stock Cover (Mo) | Status |
|---|
🏠 Dashboard
›
🔍 Master Data Check
🔍 Master Data Inconsistency Report MDC — Ledger · Item · Group masters
🔴 Critical Issues
—
Require immediate attention
🟠 High Priority
—
Important data gaps
🟡 Medium
—
Cleanup recommended
✅ Checks Passed
—
No issues found
Grouped Roll-ups (master-data driven)
Sales by Business Vertical
Purchases by Business Vertical
Sales by Ledger Group Name
| Ledger Group ▴ | Sales ₹ | Invoices | % Share |
|---|
Purchases by Supplier Branch (Voucher Type)
| Branch ▴ | Gross ₹ | DN ₹ | Net ₹ | % Share |
|---|
Sales by Item Brand
Sales by Item Group (Top 15)
| # Item Group ▴ | Sales ₹ | Qty | % Share |
|---|
Monthly Sales vs Purchase Trend by Business Vertical
📦 Stock Valuation — Closing Stock from Tally Item Master · Industry-Standard Metrics
Vertical / Brand
Item Group
Location / Godown
Closing Stock Value
—
At cost (from Tally Item master)
Stock Items
—
Items with closing stock > 0
Total Closing Qty
—
Units in hand
Stock Turnover Ratio
—
COGS ÷ Closing Stock
Days Inventory Outstanding
—
Days of stock on hand (DIO)
Stock-to-Sales Ratio
—
Stock ÷ Net Sales
Stock Turnover
—
—
Industry benchmark (Electrical/Lighting): 4–8× /year. Higher = faster-moving inventory.
Days Inventory Outstanding (DIO)
—
—
Industry benchmark: <60 days = healthy | 60–90 = caution | >90 = overstock risk.
Stock-to-Sales Ratio
—
—
Lower is better. <0.20 = lean | 0.20–0.35 = normal | >0.35 = high stock relative to sales.
ABC Analysis — Stock Value Concentration
A-class: top 70% of total value (fast-movers) · B-class: next 20% · C-class: bottom 10% (slow-movers)
By Individual Stock Item
A
B
C
A-class: — items · ₹—
B-class: — items · ₹—
C-class: — items · ₹—
By Item Group
Each item group classified by its share of total closing stock value
A
B
C
A-class: — groups · ₹—
B-class: — groups · ₹—
C-class: — groups · ₹—
ABC by Item Group
| # | Item Group | SKUs | Stock Value ₹ | % of Total | Cumulative % | ABC Class |
|---|
Closing Stock by Brand
Closing Stock by Item Group (Top 15)
📍 Stock by Location (Godown)
Estimated from stock movements (purchases + returns − sales) · Closing stock proportionally split by godown| # | Location / Godown | SKUs | Est. Closing Qty | Est. Closing Value ₹ | % of Total | Top Items |
|---|
Top Items by Closing Stock Value
Filter ABC:
Ranked by closing stock value at cost. Data sourced directly from Tally Item master (Closing Qty × Closing Rate). Showing all items.
| # | Stock Item | Brand (Parent Group) | Item Group | Closing Qty | UOM | Rate ₹ | Value ₹ | Godown | ABC |
|---|
🕰️ Non-Moving & Slow-Moving Stock
Click a dial to see items · Based on last invoice date in loaded data| # | Stock Item | Brand | Item Group | Closing Qty | UOM | Rate ₹ | Value ₹ | ABC | Last Billed |
|---|
🚨 Critical Zone Watch — Purchased But Not Moving
Age = days since last purchase · items currently in stock
⚠️ Watch Zone · 30–60 Days
—
items
—
🟠 Warning Zone · 60–90 Days
—
items
—
🔴 Critical Zone · 90 Days+
—
items
—
ℹ️ No Purchase Inventory data loaded — load the Tally Excel to see purchase-age analysis.
| # | Stock Item | Brand | Voucher Types | Item Group | Closing Qty | UOM | Value ₹ | Last Purchase | Days in Stock | Zone |
|---|
💡 Only items currently in stock (closing qty > 0) with age ≥ 30 days are shown. Age is calculated from the most recent purchase voucher date in the loaded Purchase Inventory data.
📈 Stock Value Trend — Last 6 Months
Monthly purchase inflow vs sales outflow · estimated stock value6-Month Purchase Inflow
—
Total stock added
6-Month Sales Outflow
—
At selling price (invoice)
Net Stock Movement
—
Purchases minus sales (6m)
💡 Purchase Inflow = monthly purchase voucher amounts (excl. tax). Sales Outflow = monthly sales invoice amounts (excl. tax). Estimated Stock Value is computed by working backwards from current closing stock, applying each month's net movement.
Closing Stock by Brand Summary
| # | Brand | Items | Total Qty | Value ₹ | % of Total |
|---|
📊 Stock Addition vs Reduction
12-month rolling · Purchase receipts vs Sales outflow · net position & trend direction
📦 Total Additions
—
12-month purchases
📤 Total Reductions
—
12-month sales
⚖️ Net Position
—
Additions minus reductions
📈 3-Month Trend
—
Last 3 months direction
Monthly Stock Flow — 12 Months
Stock Added (Purchases)
Stock Reduced (Sales)
Net Movement (line)
· Purchases at cost · Sales at invoice value
Month-by-Month Breakdown
| Month | Added ₹ | Reduced ₹ | Net ₹ | Direction | Cover Ratio | MoM Δ Net |
|---|
Brand-wise Stock Flow — 12 Months
| # | Brand | Added ₹ | Reduced ₹ | Net ₹ | Position | Cover % |
|---|
💡 Added = purchase receipts at cost. Reduced = sales invoiced at selling price. Cover % = Reductions ÷ Additions — above 100% means selling more than buying (drawing down stock). Net = Added − Reduced.
📌 Data Source & Methodology: Closing stock values are sourced directly from the Item sheet in the Tally export (fields: Closing Qty, Closing Rate, Closing Amount). This reflects the exact stock register as of the last Tally sync date.
Stock Turnover Ratio = Total Purchases (excl. tax) ÷ Closing Stock Value.
DIO (Days Inventory Outstanding) = (Closing Stock ÷ COGS) × 365.
ABC classification follows standard inventory management practice: A = top 70% of cumulative value, B = next 20%, C = bottom 10%. Applied both at the individual stock item level and at the item group level — item groups are ranked by their total closing stock value and classified accordingly.
Valuation method follows Tally's configured costing (typically FIFO or Weighted Average).
Sales by Voucher Type — breakdown of sales figures per sales voucher type
Sales Share by Voucher Type
Sales Amount by Voucher Type
Monthly Sales Trend by Voucher Type
Sales by Location (Godown) — Basic Amount excl. tax · consistent with Voucher Type totals above
Sales Share by Godown
Sales Amount by Godown
Voucher Type Summary
| Voucher Type | Basic Amount ₹ (excl.tax) | Amount ₹ (incl.tax) | Invoices | Avg Invoice ₹ | % of Total | Unique Customers |
|---|
Sales Order Filters SO Report — filters applied to Sales Order vs Sales report. Date range uses Sales Order date.
Sales Order Date Range
Filters the SO by its order date (not invoice date)
Party & Ledger Hierarchy
Drill-down →
Business Vertical
›
Ledger Group Parent
›
Ledger Group Name
›
Party Ledger
All▼
All▼
All▼
All▼
Sales Order Type
Filter by Sales Order voucher type (e.g. Sales Order, Proforma Invoice)
All▼
Inventory
Filters SO and linked Sales Inventory by Item Brand / Group
All▼
All▼
Sales Order vs Sales — how orders received are being fulfilled (SO value vs invoiced value, linked on Sales Order Number)
Total SO Value (excl. tax)
—
—
Invoiced
—
—
Pending (open)
—
—
Pre-closed / Cancelled
—
—
Fulfillment Rate
—
Invoiced ÷ (SO − Pre-closed)
✓ Fulfilled SOs
—
—
◐ Partially fulfilled
—
—
○ Pending (0% invoiced)
—
—
✕ Pre-closed / Cancelled
—
—
A · Monthly Trend — SO Received vs Sales Invoiced
Bars show order intake (SO value by SO date) vs invoicing output (Sales value by invoice date). The line overlays show the month-on-month fulfillment gap.
Monthly: SO Received vs Sales Invoiced
B · By Brand — Ordered vs Invoiced vs Pending vs Pre-closed
Each brand's stacked bar shows the breakup of SO value. "Invoiced" is what's already been billed; "Pending" is the open (unfulfilled) portion; "Pre-closed" is cancelled before completion.
SO Value Breakup by Brand
Fulfillment Rate by Brand
| Brand | SO Count | SO Value ₹ | Invoiced ₹ | Pending ₹ | Pre-closed ₹ | Fulfillment % |
|---|
C · By Ledger Group Name — SO vs Sales Fulfillment
Each ledger group's breakdown of SO value: Invoiced (fulfilled), Pending (open), and Pre-closed (cancelled). Helps identify which customer segments have the largest unfulfilled pipeline.
SO Value Breakup by Ledger Group
Fulfillment Rate by Ledger Group
Fulfillment by Ledger Group — summary
| Ledger Group Name | SO Count | SO Value ₹ | Invoiced ₹ | Pending ₹ | Pre-closed ₹ | Fulfillment % | Pending % |
|---|
D · By Customer — Top Parties with Pending Orders
Sorted by pending (open) value. These are the customers most affected by unfulfilled orders. Row colour = Fulfillment % — ● Green ≥90% · ● Yellow 60–89% · ● Red <60%
| Customer (Party Ledger) | Ledger Group | SO Count | SO Value ₹ | Invoiced ₹ | Pending ₹ | Pre-closed ₹ | Fulfillment % |
|---|
E · SO-level Detail — Every Sales Order with Status ▾
One row per SO voucher. Status is derived: Fulfilled = invoiced ≥ 99% of (SO − pre-closed); Partial = some but not all invoiced; Pending = 0 invoiced; Pre-closed = fully cancelled.
Row colour = SO Status —
● Green Fulfilled ·
● Yellow Partial ·
● Red Pending ·
Plain Pre-closed
| SO # | SO Date | Customer | Ledger Group | Brand | SO ₹ | Invoiced ₹ | Pending ₹ | Pre-closed ₹ | Fulfil % | Status | Action |
|---|
—
F · Item-wise Fulfillment — Ordered vs Invoiced vs Stock on Hand ▾
One row per stock item across all filtered SOs. Click any row to see which SOs ordered that item and what has been invoiced. Stock on Hand is from the Item master.
Filter:
| Stock Item | Brand | Group | SOs | Ordered Qty | Invoiced Qty | Pending Qty | Pre-closed Qty | Stock on Hand | Fulfil % | Status |
|---|
Item Detail
| SO # | SO Date | Customer | Ordered Qty | Invoiced Qty | Pending Qty | Pre-closed Qty | SO ₹ | Invoiced ₹ | Status |
|---|
G · Item-wise SO Received — All Order Lines with Ledger Group ▾
Every Sales Order line item — one row per item per SO. Includes Ledger Group and Ledger Group Parent for customer segmentation. Use the search box or the Excel export below.
| # | Stock Item | Brand | Item Group | SO # | SO Date | Customer | Ledger Group | Ledger Group Parent | Qty | SO Value ₹ |
|---|
📅 Daily Operational Report — Sales & Customer Collections for the selected date
📅
Daily Operational Report
Select a date and apply filters to load the daily operational report.
📊 Collection Tracking Summary Card
Download the image, then attach it in WhatsApp manually if direct share is unavailable.
📊 AR Outstanding Summary Card
Download the image, then attach it in WhatsApp manually if direct share is unavailable.
📦 Sales Order Fulfillment Summary Card
Download the image, then attach it in WhatsApp manually if direct share is unavailable.
Purchase vs Payment Filters Mgmt Review — compares supplier purchases against payments made. Purchase date = invoice date; Payment date = payment voucher date.
Date Range
Applies to purchases, debit notes and payments
Supplier & Ledger Hierarchy
Applied to both Purchases & Payments
All▼
All▼
All▼
All▼
Purchase Voucher Type
Narrows the Purchase side only
All▼
Inventory
Item filters narrow the Purchase side only (payments are recorded at supplier level)
All▼
All▼
🧾 Purchase vs Payment Tracking — select filters and press Apply
Purchase (excl. tax)
—
Basic amount
Tax
—
GST / charges
Purchase (incl. tax)
—
Invoice value
Debit Notes
—
Purchase returns
Payment
—
Paid to suppliers
Payment %
—
of net purchase
Sales vs Collection Filters Mgmt Review — compares invoiced sales against customer receipts. Sales date = invoice date; Collection date = receipt date.
Date Range
Applies to both invoice date (sales) and receipt date (collections)
Party & Ledger Hierarchy
Applied to both Sales & Collections
All▼
All▼
All▼
All▼
Sales Voucher Type
Narrows the Sales side only
All▼
Inventory
Item filters narrow the Sales side only (collections are recorded at party level)
All▼
All▼
💹 Sales vs Collection Tracking — select filters and press Apply
Sales (excl. tax)
—
Basic amount
Tax
—
GST / charges
Sales (incl. tax)
—
Invoice value
Collection
—
Customer receipts
Collection %
—
of sales incl. tax
Net (Sales − Coll.)
—
period movement
Stock by Location Filters Mgmt Review — closing stock split across godowns using the authoritative per-godown weighting.
Party & Ledger Hierarchy
Party/Ledger/Voucher do not affect stock (kept for consistency)
All▼
All▼
All▼
All▼
Voucher Type
Kept for consistency — does not affect stock
All▼
Inventory & Location
Brand / Item Group / Godown actually filter the stock
All▼
All▼
All▼
📍 Stock by Location — select filters and press Apply
Total SKUs
—
items in stock
Total Qty
—
closing quantity
Total Stock Value
—
closing amount
# Locations
—
godowns
Ledger/Party/Voucher filters do not affect stock (kept for consistency).
💳 Account Payable — Philips channel-finance payment schedule
Payment Schedule — by Due Date
| # | Tran ID | Category | Value Date | Tran Amount ₹ | Outstanding ₹ | Due Date | Days | Overdue Beyond ₹ | Status |
|---|
💳
No Account Payable data found
Load the
SO Email Register file containing the Dealer Outstanding sheet.📲 Credit Hold / Collection Intimation
Message (copy & paste)
Image Card
Download the image, then attach it in WhatsApp manually if direct share is unavailable.
💳 Account Payable — Payment Schedule Card
Download the image, then attach it in WhatsApp manually if direct share is unavailable.
🌀 Fan Items Report — monthly stock movement
🎯 Fan Sales vs Ledger-Group Target
| Ledger Group | Target (units) | Sold (units) | Achieved % | Balance | Sales Value |
|---|
Sales of the items in the Fan Stock & Target sheet, by ledger group, over the selected date range vs the sheet's target. Respects the vertical / LG-parent / ledger-group / sales-VT filters (the fan SKU set itself is fixed).
Monthly Summary
Click any month row to expand item-level details. Closing stock for current month is from Tally Item master; past months computed by rolling back actual invoice movements.
| Month | Purchases | Sales | Closing Stock | Collections | ||||
|---|---|---|---|---|---|---|---|---|
| Qty | Value ₹ | Qty | Value ₹ | Qty | Value ₹ | Amount ₹ | Txns | |
📊 Sales by Ledger Group
Fan item sales grouped by ledger group for the selected period. Click a row to see customers in that group.
| # | Ledger Group | Customers | Invoices | Sales Qty | Sales Value ₹ | % of Total | Avg Invoice ₹ |
|---|
| # | Customer | Invoices | Fan Qty | Sales Value ₹ | % of Group |
|---|
📦 Item-wise Fan Tracking
Quantity and value per fan stock item across the selected date range. Sales = outward, Purchase = inward, Returns = Credit Notes (sales returns back from customer).
| # | Stock Item | Brand | Item Group | Sales | Purchase | Returns (CN) | Net Sales | ||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| Qty | Value ₹ | Qty | Value ₹ | Qty | Value ₹ | Qty | Value ₹ | ||||
| # | Stock Item | Brand | Item Group | Purch Qty | Purch ₹ | Sales Qty | Sales ₹ | Net Qty |
|---|
🏆 Top Customers — Fan Items
| # | Customer | Business Vertical | Ledger Group | Invoices | Fan Qty Sold | Gross Sales ₹ ▼ | Returns ₹ | Net Sales ₹ | Collections ₹ | Est. COGS ₹ | Gross Profit ₹ | GP % |
|---|
| # | Fan Item | Brand | Group | Qty Sold | Revenue ₹ | Est. COGS ₹ | Profit ₹ | GP % |
|---|
| # | Voucher No. | Date | Voucher Type | Fan Items | Fan Qty | Fan Amount ₹ |
|---|
🌀
No fan items found
No items with "fan" in their name, group, or brand were found in the loaded data.
📊 Accounts Receivable — outstanding bill aging analysis
Outstanding by Business Vertical
Payment Performance — Closed Bills
Party-wise Outstanding & Aging
| Party ↕ | LG Parent ↕ | LG Name ↕ | Vertical ↕ | Coll. Cat ↕ | Age | Max Days ↕ | 0–30d | 31–60d | 61–90d | 91–180d | 181–365d | >365d | ▲ Above 90d ↕ | Outstanding ₹ ↕ | ⚠ Bounced ₹ | ⚠ Payment Order | Share |
|---|
📊
No Bill data found
Ensure the loaded file contains a
Bill sheet from Tally.⏱ Collection Category — by full payment history
Each customer is graded on the average days taken to clear their invoices, across all their paid bills. Honours the filters above (party / vertical / ledger group).
| Collection Avg Days | Category | Customers | Avg Days | Sales w/Tax ₹ | % Contribution | Current Outstanding ₹ |
|---|
Collection Category — Year on Year · customers graded on each calendar year's invoice→payment days · honours the ledger group / vertical / party filters (not the 6-month toggle)
| Calendar Year | A <60 | B 60–89 | C 90–119 | D ≥120 | Uncat | Total |
|---|
Sales Contribution (w/Tax) by Category — per Calendar Year · each category's sales as ₹ and % of that year's total
| Calendar Year | A <60 | B 60–89 | C 90–119 | D ≥120 | Uncat | Total |
|---|
Customer detail
| Customer | Avg Days | Category | Paid Bills | Sales w/Tax ₹ | % Contrib | Current Outstanding ₹ | Last Sale |
|---|
Avg Days = average of (payment cleared date − invoice date) over all the customer's cleared bills (full payment history — no date window).
Category: A <60 · B 60–89 · C 90–119 · D ≥120 days; Uncat. = has sales in the range but no cleared payment yet.
% Contribution = customer / category sales ÷ total sales (with tax) in the range. Current Outstanding = the customer's live pending receivable (as of today). Amounts are tax-inclusive Tally bill values.
🧾 IP Filters IP
SO Date Range
Business Vertical
All▼
Ledger Group Parent
All▼
Ledger Group Name
All▼
Party Search
SO Type
All▼
Action Status
All▼
🧾 Invoicing Proposal — open Sales Orders · credit check >60d overdue > ₹1,000 = hold · stock availability
Open SO Value
—
pending orders
🟢 Ready to Bill
—
credit OK · stock full
🟡 Partial Ready
—
credit OK · partial stock
🟠 Awaiting Stock
—
credit OK · no stock
🔴 Credit Hold
—
>60d overdue > ₹1,000
⚠ Bounce Risk
—
cheque history <12m
✅ Already Billed
—
no pending qty
Credit Rule: If a customer's outstanding aged over 60 days exceeds ₹1,000 the entire SO is placed on Credit Hold — no invoicing possible. Overdues of ₹1,000 or less do not block.
· Stock Rule: Pending qty per item line checked against Tally closing stock (Item master).
· Status: Ready = credit OK + all items in stock · Partial = credit OK + some items short · Awaiting Stock = credit OK + no stock for any item · Hold = credit blocked.
SO-level Invoicing Proposal
| # | SO Number | SO Date | Party | Vertical | Ledger Group | Pending Value ₹ | Credit Status | Chq Bounce ⚠ | Stock Status | Action |
|---|
| # | Stock Item | Brand | Ordered Qty | Already Billed Qty | Invoice #(s) | Pending Qty | Pending Value | Stock on Hand | Godown | Availability |
|---|
🧾
No open Sales Orders found
Ensure the loaded file contains a
Sales Order Inventory sheet with pending orders in the selected date range.💰 CT Filters CT
Tracking Month
Overdue Threshold
Business Vertical
All▼
Ledger Group Parent
All▼
Ledger Group Name
All▼
Recovery Status
All▼
Party Search
Cutoff Option
☑ Include due 1st → today
☐ Only due on 1st (default)
☐ Only due on 1st (default)
💰 Collection Tracking — select a month and apply filters to load
Parties Tracked
—
overdue bills at month start
Outstanding at Month Start
—
overdue bills (net balance)
✅ Collected in Month
—
bills cleared during month
Still Remaining
—
not yet recovered
Recovery Rate
—
Net Collected ÷ Outstanding
⚠ Bounced in Month
—
cheques returned
Overall Recovery
Fully Recovered: 0
Partially Recovered: 0
No Recovery: 0
📈 3-Month Recovery Trend
Prior 3 months before selected tracking monthNo data available for the 3 prior months
📊 Ledger Group Trend
Outstanding by Ledger Group Name — prior 3 monthsNo LGN data for the 3 prior months
📊 Statistics by Ledger Group Name
👆 Click a row to filter the party list below
| # | Ledger Group Name | Ledger Group Parent | Parties | Outstanding ₹ | Collected ₹ | ⚠ Bounced ₹ | Net Remaining ₹ | Recovery % |
|---|
🔍 Showing parties in group:
Party-wise Collection Status
| # | Party | Business Vertical | Ledger Group | Outstanding ₹ | No. of Bills | Collected ₹ | ⚠ Bounced ₹ | Net Remaining ₹ | Recovery % | Status | ⚠ Payment Order |
|---|
| # | Bill / Voucher No. | Bill Date | Days Overdue at Month Start | Bill Amount ₹ | Cleared On | Bill Status |
|---|
💰
No overdue receivables found
Ensure the
Bill sheet is loaded and a tracking month is selected. Only Sundry Debtors with overdue bills at month start are shown.Customer Index Filters 🏆 CX Report — composite customer ranking · multi-select with cascade
All▼
All▼
All▼
All▼
🏆 Customer Index — composite ranking by payment speed · order volume · reliability · outstanding health
Customers Ranked
—
analysed from Bill sheet
🌟 Top Customers
—
Grade A+ and A
Avg Index Score
—
out of 100
Total Business Volume
—
total invoiced (filtered)
⚠ Bounce Risk
—
customers with bounce history
Grade Distribution
🏆
No customer data found
Ensure the
Bill sheet is loaded. The Customer Index analyses all Sundry Debtors with at least one invoice on record.| # | Customer ↕ | Vertical ↕ | LGN ↕ | Index Score ↕ | Grade | Billed ₹ ↕ | Invoices ↕ | Avg Pay Days ↕ | % Paid ↕ | Bounces ↕ | Outstanding ₹ ↕ |
|---|
💰 Financial Status — Bank Balances · Cash · Director Investments · Borrowings
Category
click to toggle
Ledger Group
Balance
Enriched Transaction Tables (master-data columns appended)
—