Business Reports, Dues & Analytics
Step-by-step guide to generating sales reports, tracking outstanding customer dues, monitoring empty jar stock, and exporting Excel statements.
PaniHisab automatically summarizes your daily jar sales, cash collection, pending customer udhaari, and unreturned empty jar inventory into real-time visual reports and downloadable Excel spreadsheets.
1. Sales & Revenue Reports
Track daily, weekly, and monthly sales performance across your water delivery business:
- Open Reports Screen: From the menu, click Reports.
- Select Date Range: Choose from preset date ranges (Today, Last 7 Days, This Month, Last Month) or set a Custom Date Range.
- Review Key Revenue Metrics: View Total Jars Delivered, Gross Sales Value, Spot Cash Received, UPI Online Payments, and Total Dues Added.
2. Outstanding Dues & WhatsApp Recovery
Recover unpaid customer balances (udhaari) quickly using dedicated dues tracking:
Switch to the Outstanding Dues tab. PaniHisab displays a complete list of customers with pending balances, sorted by highest due amount. Tap the green Send WhatsApp Reminder button next to any customer to send an instant payment reminder message with their current balance and UPI QR link.
3. Empty Jar Inventory & Stock Tracking
Prevent jar losses and track empty cans across your delivery network:
- Customer Empty Jar Ledger: Displays exactly how many empty 20L cans each customer currently holds at home or at their office.
- Total Plant Stock: Displays filled cans ready for delivery, empty cans in plant storage, and total active jar inventory.
4. Delivery Staff Performance Reports
Review delivery boy daily collections and jar counts:
Select the Driver Summary tab to view total full cans delivered, empty cans collected back, and total cash collected by each delivery driver during their shift.
5. Exporting Reports to Excel & PDF
Download report data for offline accounting or tax reporting:
Click the Export Excel (.xlsx) button at the top of any report tab. PaniHisab generates a clean, formatted Excel spreadsheet containing full transaction ledgers, customer names, jar counts, and payment breakdowns.
Business Reports Reference
Overview of available reports in PaniHisab:
| Report Type | Key Metrics Tracked | Best Used For | Export Options |
|---|---|---|---|
| Sales & Revenue | Jars sold, Gross Sales, Cash & UPI | Daily business profit & sales tracking | Excel (.xlsx) / PDF |
| Outstanding Dues | Unpaid customer balances & due dates | Collecting pending udhaari via WhatsApp | Excel (.xlsx) / PDF |
| Empty Jar Inventory | Unreturned empty cans per customer | Preventing jar losses & stock audit | Excel (.xlsx) / PDF |
| Driver Summary | Jars delivered & cash per driver | End-of-shift driver cash reconciliation | Excel (.xlsx) / PDF |
Frequently Asked Questions
How often are reports updated in PaniHisab?
All reports update in real time instantly whenever a delivery, return, or payment is recorded by you or your delivery staff.
Can I export reports for accounting or tax filing?
Yes! Click the 'Export Excel' button on any report screen to download complete transaction spreadsheets compatible with Tally, Excel, and CA accounting software.
How do I track missing empty jars?
Open the Empty Jar Inventory report to see a detailed list of every customer holding unreturned empty cans, sorted by total cans unreturned.
Next Step Guide
Learn how to configure your shop profile, bank UPI ID, and subscription.