EVPL Dashboard v109

Everthrive Ventures · Sales, Purchase, AR, Stock & 14 Reports · Load files then click a report

📂 Load Data Files

💻 Local Files 📂 Select Folder | 🗂 Tally Data 🧾 All Vouchers

☁ Google Drive

📅 Tally: 🧾 Vouchers:

Quick Reports

🔍 Master Data Check

💰 Financial Status

Main Dashboard

📊

EVPL Main Dashboard

Full overview · KPIs · Charts · Revenue Rollups · Sales by Voucher Type & Location · All reports

→

Sub-Reports (14 Reports)

Report 📦

SO Report

Sales Orders — pending, dispatched & fulfilled order tracking

Report 🏭

Stock Report

Item-wise stock levels, godown-wise valuation & movement

Report 📅

Daily Operational Report

Day-wise sales trend, target vs actual & daily performance

Report 🌐

Fan Report

Fast / Average / Non-moving items — identify slow stock

Report 🔔

AR Report

Accounts Receivable — outstanding dues & aging analysis

Report 📈

Invoicing Proposal

Item & party-wise invoicing proposal with SKU-level margin

Report 📋

Collection Tracking

Customer credit limits, utilisation & collection follow-up

Report 🏢

Purchase Proposal

Distributor & party-wise purchase planning & proposal

Report 👥

Customer Index

Full customer profile — transaction history, outstanding & loyalty

Report ⚖️

Purchase vs Sales

Item-wise purchase & sales comparison — margin & movement

Report 🧾

Receipts & Payments

Cash & bank receipt tracking, cheque bounce & payment register

Report ⭐

Top Focus Report

Priority items & parties needing immediate attention this period

📂 Data Source

💻 Local Files 📂 Select Folder | 🗂 Tally Data

🧾 All Vouchers

☁ Google Drive

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

Date From

Date To

Party & Ledger Hierarchy

Drill-down → Business Vertical › Ledger Group Parent › Ledger Group Name › Party Ledger

Business Vertical

All▼

Ledger Group Parent

All▼

Ledger Group Name

All▼

Party Ledger

All▼

Voucher Type Filter by specific voucher types (Sales, Purchase, etc.)

Voucher Type

All▼

Inventory Applies to Sales/Purchase/Credit/Debit Inventory sheets only

Item Brand

All▼

Item Group

All▼

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)

SO Date From

SO Date To

Party & Ledger Hierarchy

Drill-down → Business Vertical › Ledger Group Parent › Ledger Group Name › Party Ledger

Business Vertical

All▼

Ledger Group Parent

All▼

Ledger Group Name

All▼

Party Ledger

All▼

Sales Order Type Filter by Sales Order voucher type (e.g. Sales Order, Proforma Invoice)

Sales Order Type

All▼

Inventory Filters SO and linked Sales Inventory by Item Brand / Group

Item Brand

All▼

Item Group

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

Date

Party & Ledger Hierarchy

Drill-down → Business Vertical › Ledger Group Parent › Ledger Group Name › Party Ledger

Business Vertical

All▼

Ledger Group Parent

All▼

Ledger Group Name

All▼

Party Ledger

All▼

Voucher Type Filter by voucher type

Voucher Type

All▼

Inventory Filter by Item Brand / Group

Item Brand

All▼

Item Group

All▼

Fan Items Report Filters 🌀 Fan Report — fan item sales, purchases & collections by date range

Date From

Date To

Item Name Search

Business Vertical

LG Parent

Apply filters to load…

Ledger Group

Select LG Parent first…

Item Category

Accounts Receivable Filters 📊 AR Report — outstanding customer receivables · Sundry Debtors only

Party Search

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 (click to select — multiple allowed)

📈 Sales & Margin

Total Sales (excl. tax)

—

Net Sales (excl. tax)

—

Sales − Credit Notes

Gross Margin

—

Credit Notes (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

Financial Health — Receivables · Payables · Net Position · DSO · DPO · Aging Analysis

📥 Total Receivables

—

Outstanding from customers

📤 Total Payables

—

Outstanding to suppliers

⚖ Net Position

—

Receivables − Payables

📦 Closing Stock Value

—

From Tally Item master · click to open report

📅 DSO

—

Days Sales Outstanding

📅 DPO

—

Days Payable Outstanding

📥 Receivables Aging

0-30d

30-60d

60-90d

>90d

0–30 days: —

30–60 days: —

60–90 days: —

>90 days: —

📤 Payables Aging

0-30d

30-60d

60-90d

>90d

0–30 days: —

30–60 days: —

60–90 days: —

>90 days: —

Top Outstanding Receivables by Customer

Customers with the highest outstanding amounts. Row color = age of oldest outstanding invoice.

#	Customer	Outstanding ₹	0–30 days	30–60 days	60–90 days	>90 days	Aging Status

Top Outstanding Payables by Supplier

Suppliers with the highest amounts owed. Row color = age of oldest payable.

#	Supplier	Outstanding ₹	0–30 days	30–60 days	60–90 days	>90 days	Aging Status

Industry Standards: DSO <30 days = excellent | 30–45 = good | 45–60 = needs attention | >60 = concerning. DPO <30 days = typical; negotiating 45–60 improves cash flow. Aging buckets follow standard GAAP/IFRS receivables classification. Bill sheet data is used for receivables/payables; if the Bill sheet is absent, totals show as 0. See the Stock Valuation panel below for accurate closing stock from the Tally Item master.

📋 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 days outstanding) 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

⭐

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

⬅ Main Dashboard › ⭐ Top Focus Report

⭐ Top Focus Report Focus Analysis — ranked analytics with industry benchmarks

📅 Period

—

🛒 Purchase Proposal Filters PP Report

📅 SO Date From

SO Date To

🔍 Item Search

SO Type

🏷 Ledger Group

Ledger / Party

Brand

Item Group

Stock Status

🏠 Dashboard › 🛒 Purchase Proposal Report

🛒 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-class: — items · ₹—

B-class: — items · ₹—

C-class: — items · ₹—

By Item Group

Each item group classified by its share of total closing stock value

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 sales dispatch history · 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 value

6-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

🏠 Dashboard › 📦 Sales Order vs Sales Report

🏠 Dashboard › 📊 Stock Valuation Report

🏠 Dashboard › 📅 Daily Operational Report

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

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%

Sort by

Show top

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

Search (SO #, customer, brand…)

Status filter

	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.

Search item / brand / group

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

📅 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 Image

Download the image, then attach it in WhatsApp manually if direct share is unavailable.

📊 AR Outstanding Summary Card

⬇ Download Image

Download the image, then attach it in WhatsApp manually if direct share is unavailable.

🏠 Dashboard › 🌀 Fan Items Report

🌀 Fan Items Report — monthly stock movement

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
Month	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
#	Stock Item	Brand	Item Group	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

Show top

#	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.

🏠 Dashboard › 📊 Accounts Receivable

📊 Accounts Receivable — outstanding bill aging analysis

Outstanding by Business Vertical

Payment Performance — Closed Bills

Party-wise Outstanding & Aging

Party ↕	LG Parent ↕	LG Name ↕	Vertical ↕	Age	Max Days ↕	0–30d	31–60d	61–90d	91–180d	181–365d	>365d	Outstanding ₹ ↕	⚠ Bounced ₹	Share

📊

No Bill data found

Ensure the loaded file contains a Bill sheet from Tally.

Invoicing Proposal Filters 🧾 IP Report — open Sales Orders · credit check ≤60 days · stock availability

SO Date From

SO Date To

Business Vertical

Ledger Group Parent

Ledger Group Name

Party Search

Sales Order Type

Action Status

🏠 Dashboard › 🧾 Invoicing Proposal Report

🧾 Invoicing Proposal — open Sales Orders · credit check ≤60 days outstanding · 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

—

>60 days outstanding

⚠ Bounce Risk

—

cheque history <12m

Credit Rule: If a customer has any outstanding bill older than 60 days the entire SO is placed on Credit Hold — no invoicing possible. · 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	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.

Collection Tracking Filters 💰 CT Report — customers with overdue bills at month start · monthly recovery tracking

Tracking Month

Overdue Threshold

Business Vertical

Ledger Group Parent

Ledger Group Name

Party Search

Recovery Status

🏠 Dashboard › 💰 Collection Tracking Report

💰 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 month

No data available for the 3 prior months

📊 Ledger Group Trend

Outstanding by Ledger Group Name — prior 3 months

No 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

#	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 by payment speed · order volume · reliability · outstanding health

📅 Invoice Date Range

From Date

To Date

Business Vertical

Ledger Group Parent

Ledger Group Name

Grade Filter

Party Search

🏠 Dashboard › 🏆 Customer Index Report

🏆 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 ₹ ↕

🏠 Dashboard › 💰 Financial Status

💰 Financial Status — Bank Balances · Cash · Director Investments · Borrowings

Enriched Transaction Tables (master-data columns appended)

—