Preparing your business dashboard…

Loading the embedded April–October sales and medicine records. This works completely offline.

✚ Patwardhan Pharma Distributors

Business Intelligence · Sales, Customers & Medicines · Sirsi

● Private & offline · No data leaves this browser
+ Import new TXT reports (bill-wise or party/item-wise)

TXT files are processed in this browser only. Imported records remain until this page is closed. Matching invoice numbers connect item rows to bill dates; new item-only invoices may have unknown dates.

Total sales trend

Net invoice value by month, including tax and invoice adjustments

Sales volume & monthly growth

Invoice counts and month-on-month changes

Top customers

Ranked by net invoice value · click customer in the table to explore

Top medicines by value

Item line amounts (not the same as net invoice value)

Monthly performance

Full breakdown of invoice totals and medicine sales, without adding them together

Customer performance

Click a customer to see monthly sales, product mix and purchasing history

Medicine sales by month

Item-line amount, using matched invoice dates

Top medicines by quantity

Sold quantity in the report's own pack units; free quantity shown separately

Medicine performance register

Each medicine + pack size is treated as a distinct product

Customer Explorer

Monthly sales, customer-specific medicines, and invoice history

Customer sales month by month

Customer medicine purchases by month

Medicines purchased by this customer

Invoices for this customer

Invoice register

Net invoice totals, searchable by invoice number or customer

Item-level register

Product, customer, pack, MRP, rate, paid quantity, free quantity and amount

What the numbers are telling you

Practical observations based on the currently selected date range and customer filters

Customer concentration

Share of invoice sales from the top 10 customers

Month-on-month comparison

Net invoice sales compared with previous month

Customer activity watchlist

Customers with sales earlier in the selected period but none in the latest 60 days of that period. This is a billing-based signal, not proof that they stopped trading.

Data coverage

How to read this report

Net invoice sales comes from the bill-wise reports and includes tax/adjustments. Medicine/item sales is the item report's AMOUNT column and may differ due to taxes, discounts and other adjustments. These totals must never be added together.

The item report has no transaction dates; dates are obtained by matching invoice numbers to the bill-wise reports. Unmatched item rows appear in unfiltered all-time medicine totals but cannot be assigned to a month or date-filtered analysis.

Quantity means the report's QTY column; the adjacent second integer is treated as free quantity. Item amounts do not always equal RATE × QTY because of invoice-level/item-level adjustments. Do not infer profits, margins, stock on hand, expiry, collections or outstanding receivables from these reports.

Customers with spelling differences may appear separately. Product names and pack sizes are used as printed; this does not merge equivalent medicines with different descriptions.

Import and validation notes